Anybody know of a way to show inventory sold withi...
# suiteanalytics
p
Anybody know of a way to show inventory sold within a given date range that includes when it's sold as a kit component? Example - inventory item ABC was sold 50 times as a stand-alone item and 30 times as part of a kit so I need a line in the report to say item ABC was sold 80 times. Any canned reports that do a better job of this than the item search i’m building that has two lines of 50 (standalone sales) and 30 (sales of kit with quantity of member items)? The business requirement is pretty straightforward - tell me how many times Inventory Item ABC was sold so that I can understand how many I need to order. Unless I'm missing something, it looks like NS only considers an item 'sold' if it appears on the transaction. Anyone come across this and solved for it in one search rather than multiple + excel?
b
you can make a summary saved search that uses the item member related fields in formulas
message has been deleted
message has been deleted
you may want additional logic in your formula if you want this to work with assembly items (they use the same member item join)
NVL({item.memberitem}, {item})
is used to group normal items and items used as part of kits together
NVL2({item.memberitem}, {quantity} * {item.memberquantity}, {quantity})
is used to properly sum the quantity since kit components can have multiple quantity
p
ooooh....I like this! Thanks @battk I'll give this a try!
Hmmmm... @battk I'm getting an error invalid expression for the NVL({item.memberitem}, {item}). Any thoughts on why it would work on your end and not mine?
message has been deleted
b
its not a numeric formula
p
yup. that would be it. 🤦‍♂️ how embarrassing! Thanks again!