I have a Gridview using the table: A/P Vendor Master. I want to add a column from Purchase Order showing the Outstanding Receipt total amount for each vendor including both positive and negative receipts. I can add the I/R Outstanding Balance column, but that amount includes both PO's and Receipts for each vendor. I only want the total amount from Receipts for each vendor, not the amount from PO's. Is there a a way to add this column?
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario