Inventory Summary by Class - Generic Inquiry

Question

Has anyone made or come across a generic inquiry that returns the data from the Inventory Summary screen (IN401000) but at the Item Class level?

If not, any clues on which Data Classes/Tables I can use to access each of the qty data values?

The GI screen doesn't like the InventorySummaryEnquiryResult data class.

When running the GI, this error shows saying the Table doesn't exist.

Any other tables I can try? or ideas on how to use this one better?

simonangland · Accepted Answer

Hi Graeme,&nbsp;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.

graemelm · Answer

Fantastic! Thank you so much, this saves me a LOT of time digging into reports to find the right tables.Very much appreciated!

graemelm · Answer

Hi&nbsp;SimonAngland&nbsp;&nbsp;Any idea how to get the SO and PO Qty's populating?&nbsp;I've created a test scenario where STOCKITEM has:10x Receipted into stock2x On an Open Sales Order10x On an Open Purchase Order&nbsp;The standard Inventory Summary screen reflects these values as expected.The custom GI you sent shows 0 for both these values.&nbsp;standard Inventory Summarycustom Inventory Summary Enquiry GI&nbsp;&nbsp;

simonangland · Answer

Maybe remove INLocation fields, relations and tables from GI as you are not using Inventory Locations and select INSiteStatus fields like QtySOBooked, QtyPOOrders.

graemelm · Answer

SimonAngland&nbsp;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.&nbsp;Thanks again :)&nbsp;5 stars, would recommend!

Forum Discussion

Inventory Summary by Class - Generic Inquiry

5 Replies

Related content

Inventory

Inventory Script

Paye tax summary

Inventory Locations

Inventory

Inventory Adjustment

Inventory Zero Value

Inventory value