getting PO from invoice 1

[PJ62]

I'm doing an AR aging report and it's not clear to me how to associate a PO with each invoice number. Is there a way to do this? I've looked through the table documentation and can't find any explicit links.

 

[crystalreporting]

AP invoices are matched to receivers which in turn are associated with PO's. Try looking at the IMRECHST table - the voucher number is written there at the time a voucher is matched to a receiver (when the voucher is first entered).

If you join to IMRECHST, you should use a subreport or a left-outer join i.e. depending on how you have Macola setup, and your own internal procedures, there may be no receiver associated with a voucher. There may also be one, or there may be many.

Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.srhconsulting.com

 

[NEmacGuy]

If you are talking about PO from your customer :
ES or Progression ?
Assuming Progression, I did something similar by linking order history to the aropnfil. Joined the Inv_No to the Doc_No to pull the oe_po_no into the aging. It will take some playing around to get it right. I had some type of issue so ended up updating the Reference in the aropnfil to have the oe_po_no and then the native macola aging contained the customers PO number.