I'm trying to build a report of qty on hand by loc...
# australia
j
I'm trying to build a report of qty on hand by location. I can't seem to find a good starting point for this. The Qty on Hand report seems to lack fields about the location
Qty On Hand
is total across all locations. Use
Location On Hand
and
Inventory Location
fields for per location levels
j
thanks for the pointer
that's perfect thank you!
j
I'm fond of a saved search to show inventory qty across columns
message has been deleted
m
You can use an analytics workbook with pivot table for that, unless you need to export.
👍 1
j
thanks guys, good tips there