Hi Graeme,
Data is in INLocationStatus and INSiteStatus and INLocationCostStatus and INSiteCostStatus. Try the attached GI and Pivot table to get good Inventory summaries. You can add ItemClass.
Hi Graeme,
Data is in INLocationStatus and INSiteStatus and INLocationCostStatus and INSiteCostStatus. Try the attached GI and Pivot table to get good Inventory summaries. You can add ItemClass.
Fantastic! Thank you so much, this saves me a LOT of time digging into reports to find the right tables.
Very much appreciated!
Hi SimonAngland
Any idea how to get the SO and PO Qty's populating?
I've created a test scenario where STOCKITEM has:
10x Receipted into stock
2x On an Open Sales Order
10x On an Open Purchase Order
The standard Inventory Summary screen reflects these values as expected.
The custom GI you sent shows 0 for both these values.
standard Inventory Summarycustom Inventory Summary Enquiry GI
Maybe remove INLocation fields, relations and tables from GI as you are not using Inventory Locations and select INSiteStatus fields like QtySOBooked, QtyPOOrders.
SimonAngland Ah that's it, I was using Results Grid fields at Location level, not Site/Warehouse level.
Using the INSiteStatus fields gives me what I want.
Thanks again :)
5 stars, would recommend!
