I have a requirement of reporting on PO/OA that are Output to vendors. We can find that information in NAST table.
But the Po amount shown on Report should match Amount Outputted to Vendors.
In other words if PO has Line 1 and Line 2, And Po is outputted.
And Again Line item 3 and 4 are created but not re-outputted.
My report should show only amount total in Line item 1 and Line item 2. but should not show line item 3 and 4.
NAST table is document level table, how can I achieve this report.
Any suggestions.......Points will be awarded.