Skip to main content

I have an Inventory base that was not created by me, but I’m the owner now. I have a Materials Checked In table, that I need to sum up the qty received by PO and description.

I tried using the Roll up, but it pulls all of the items by description, which is not helpful when I need to see items received by PO. This way I can see the Ordered Qty, Received Qty, then have an Open balance remaining per PO.

Try using the “Group By” setting for the view. You can group by PO first, then description. The view will show you totals and subtotals for each group and subgroup: