Dear Gurus,
Currently, when one item has stock in different locations/bins, the Bin Numbers column is showing all bins as combined in one line.
For example:
Qty On Hand = 3
Bin Numbers = C(6)2B02(2), F(1)4A06(1)
Instead of combining them, we would like the report to show the stock separately by Item + Location + Bin Number, with each bin shown in a separate row together with Qty, Avg Cost, and Inventory Value.
May I know if this can be solved through:
Stock Ledger report customization, Saved Search, or SuiteAnalytics Workbook?
Our preferred output is bin-level stock ledger detail, not summarized item-level bin display.
Thank you.