during the migration of inventory levels into production via inventory adjustments, how should we handle the correct inventory valuation when using FIFO? Do we need to import the historical inventory layers from the legacy system (i.e., quantities by date and cost) through multiple adjustments to properly reconstruct FIFO? Thanks!

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** When migrating inventory levels into production via inventory adjustments and using FIFO, it's important to consider the historical inventory layers from the legacy system. However, importing these layers through multiple adjustments to properly reconstruct FIFO can be complex and may not always yield the desired results. In NetSuite, the Inventory Worksheet is often used to adjust inventory values. However, it's important to note that this tool resets all the FIFO cost layers. If you've already recorded sales related to the items you're adjusting, this could complicate matters. Another method discussed in the threads is to bring the inventory to 0 on a day with no inventory transactions, then bring the inventory back up to stock at the correct value on the following day. This requires a full calendar day at 0 on hand for it to work. However, this method will change the financials in that period, and you'll need to use an appropriate expense account or a holding account for both inventory adjustments. Alternatively, you can use the Adjust Inventory feature in NetSuite. This feature allows you to adjust the inventory by a certain number, rather than replacing the number as the Inventory Worksheet does. This might be a more suitable option if you're looking to maintain the historical layers of your inventory. Remember, each method has its own implications and should be carefully considered based on your specific situation and requirements.