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?


Attachments
Capture.PNG (134 downloads)

_________________________
Susan Tennier
TDL Canada
Trenton, Ontario