cr10 on Informix db.
I have a purchase order table where I am selecting the po number and the status of the po which is either AA, CL or CC. I also have an invoice table where a final_paid field is either Y or N. I need to show the po status as is for each po except where it might be AA and one or more invoices paid against the po have the final_paid column = "Y". In which case, I want to show the status as "CL". I have the ap table linked to the purchase order table. Can a formula be used to put this condition in place without actually reporting the ap data and grouping it? I'm trying to get counts of po's that are CL and CC for a chart and when the ap data is on the report (suppressed or not), it messes my counts up.
rw
I have a purchase order table where I am selecting the po number and the status of the po which is either AA, CL or CC. I also have an invoice table where a final_paid field is either Y or N. I need to show the po status as is for each po except where it might be AA and one or more invoices paid against the po have the final_paid column = "Y". In which case, I want to show the status as "CL". I have the ap table linked to the purchase order table. Can a formula be used to put this condition in place without actually reporting the ap data and grouping it? I'm trying to get counts of po's that are CL and CC for a chart and when the ap data is on the report (suppressed or not), it messes my counts up.
rw