Americas - Pacific Northwest - ID, OR, WA

Hello @Jack.Pennypacker.  I have done this and I am attaching the BAQ that we currently use.  I did not use a sub-query for the total received against the PO’s because the analysis is done at the PO release level.  You will want to look for the calculated field “RemBal”.  The BAQ has an optional parameter only for Supplier ID, but you could easily add a similar one for Product Group, or just use the standard filtering after the query executes.

Hope this helps.  I can upload the dashboard, too, if you want it.

Regards,

I appreciate the quick response and will look at the BAQ that was uploaded.    I think this might work.   Both responses are pointing at the same process, which makes me think this is what I was looking for.

I was able to get what I need, both responses were great.   There is a lot going on in the BAQ that was uploaded.   I found the first answer the best, as it was exactly what I need.    But if I hadn’t received it, the second one had it also.

FWIW, that BAQ is designed to be the equivalent of the standard Open Purchase Orders report, with some additional fields to add pertinent information regarding part demand and part availability.