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?

Hi Susan,

You would need to create a new View based on the PurchaseOrder Header file, selecting only outstanding receipts. You can sort/subtotal the records by Vendor. Then you can use a GetLinkedValue formula in your Vendor Master view to get the subtotal amount for each vendor.

I couldn't find the "Invoice Status" field in the PurchaseOrder Header file, so instead, I created a new view using PO Details and then inserted related column "Total Value" from the PurchaseOrder header file. Now I have the results I want - almost!

The problem is now the receipts with multiple items displays the "Total Value" multiple times and so the total is incorrect. In the screen shot attached, the total is $1,391.75, but it should be $1,036.75. It is adding RC00018384 twice and RC00019838 three times and RC00019897 twice. Can you help me resolve this?