We are trying to get a Dashboard / BAQ to be able to get a file with all the Open PO’s for a selected Product Group, and to have it include the QTY that has already been received on each open PO for that product group.
I can get everything but the total received amount. Not sure how to get it. Was thinking a sub-query to total all the receipts against the PO’s. But don’t have it working yet.
Thought maybe someone else has done this and might be willing to share what they have already done.
Best answer by glenn.owers
View original