Goods received not Invoiced Report

[alan180274]

Hi.

for MFG/Pro - using Progress database - version 74g7.

does anyone know which table(s) are best used to show Purchase order lines that have been received but not yet invoiced ? is it pod_det? whcih fields or other tables to compare ?

wanting to extract PO lines that are at this status

regards

Alan

 

[lig.qad]

In that version you can use prh_hist and compare prh_received_qty vs. prh_invoiced (not the actual fields, don't have access to manual or system right now). Prh has PO, Line, part, serial/lot, etc.

There is also an "unvouchered receipts" report in Accounts Payable... you can follow the logic on this report.