Is there a way to generate a report that shows all item names in column A then all bins in column B? This is to be used for inventory count since there are a lot of items and manually keying the adjustment in NetSuite for every item using the Inventory Count feature is impractical.
Trick: Currently, the Bins are not associated with Items (Advanced Bin). The above is possible if ALL bins are associated with the Item records but we want to avoid doing this.
Column A Column B
Item A Bin A
Item A Bin B
Item B Bin A
Item B Bin B