Anyone got any ideas why one matrix inventory item...
# inventoryc
Chris Roush
05/26/2021, 5:44 PMAnyone got any ideas why one matrix inventory item would report an a valuation in the thousands when the item is between negative and slightly positive on hand (in-store/SCIS location using inventory transfers and selling underwater).
The normal avg cost is supposed to be 5.55 USD for the item. There’s been no more than 24 on hand at the in-store location yet the valuation and COGS is like $60k. The costing calculations have also failed for this location. Periods are locked but not closed.
Any experience with something similar?
a
Automatech
05/27/2021, 1:47 AMThe inventory valuation report is a summary of transactional movement. You'll need to dive into the "Detail" of that report to understand where the numbers are coming from.
c
Chris Roush
05/27/2021, 5:34 AMHeard. Did that right when I heard about the issue. Check it out…
Chris Roush
05/27/2021, 5:34 AMOnly Item Transfers, no Inventory Adjustments or worksheets. Only sales after that.
Notice the zero quantity down toward the bottom.
The affect of underwater inventory with failed costing calculations (avg item costing) and closed/locked periods??
Chris Roush
05/27/2021, 5:34 AMNetSuite Support has this listed as a defect…
6 Views