How can we create a report showing sales of widget A (an inventory item) ....including it's sales as a member of kits (report or SuiteAnalytics or saved search).
When reporting on sales of any one inventory item. We're stuck on kit sales and others are to and it's been this way for years.
Inventory item = widget A
Kit item = "5-pack of widget A".. components = 5 of "widget A"
How can we do a report showing the number of Widget A units sold? I can make it find all sales of Widget A and all sales of "5-pack of widget A", but it won’t total them accurately.
I'm looking at the "standard stock-ledger report". It has outputs and inputs and all kinds of data... but on the line for widget A it IGNORES all of the outputs that happened via its sales in kit items.
What we really need is just the units shipped in a time period both inside and outside of kits for ALL of our non-kit items.
any help would be much appreciated