macola progression 7.8.200 Link Purchase order line item to voucher number and voucher date

[sans2174]

Hi There,
We have macola progression 7.8.200, I'm looking to do a report and get the voucher number and voucher date for each of the Purchase order line item. Each of our PO line items may have multiple receivers.
So I'm looking in POordhdr_sql and POordlin_sql, I'm trying to link it to AccPayable voucher using the receiver number.
I have been looking in all AP and PO table, I'm not able to find the table that I can use link between the PO ord_no for each line items to the receiver number and use the receiver number to get the AP voucher number and voucher date. Will appreciate any help.
Thanks

 

[crystalreporting]

Try looking at imrechst_sql.

Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.erpessentials.com

 

[sans2174]

yes, that worked.
Thank you