Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Inventory adjustments when using FIFO?
I have a document from Professional Services called "Opening Balances Best Practices". In one section it says...
The Inventory Adjustment Worksheet should be used for inventory adjustments ONLY when using average costing. FIFO and LIFO costing requires that you adjust the inventory counts in dated “layers” which reflect the date of purchase of each item and its price.
Some FIFO and LIFO customers have successfully used the Inventory Adjustment Worksheet to enter their initial Quantity On Hand values, but have done so by sacrificing their date and purchase history “layers”. Instead, they have chosen to use average cost for the current Quantity On Hand, and use LIFO or FIFO going forward.
0