NetSuite Inventory Worksheet Adjustments (IWA)
During the last two years I have led the design, setup, implementation and use of a very complex inventory management system that includes inventory items, assembly items, non-inventory items, and lot numbered items.
One of the most confusing features in NetSuite is the Inventory Worksheet Adjustment form. Before using this, I strongly encourage you to read and study the Help System, and to conduct tests of your planned usage (preferably in a Sandbox account).
Here is what I have learned so far. This is definitely a work-in-progress. Please feel free to critique, question, and add-to based on your experience. I hope this will help many others to better understand IWA.
When making NS IWAs, please be aware of the impact to inventory:
[LIST=1]
[*]The changes made by the IWA make take 24 hours or longer to recalculate inventory quantity and value.[LIST]
[*]Therefore, the current Quantity On Hand shown on Inventory Reports, the Item Record, Assembly Builds, Inventory Adjustments, and other records may not be accurate until the next day, or later.
[*]If you immediately make another IWA or normal Inventory Adjustment, it may appear as if the changes you just made on the IWA did not take effect.
[*]IMO, NS should give us the option of recalculating immediately, rather than waiting until non-business hours.
I will be submitting an ER for this.[/LIST]
[*]IWAs set the absolute quantity, total value, and unit value of the Item.
[*]Even if the Item is set to use FIFO costs, the net effect is to make all units currently on hand have the same unit cost.
[LIST]
[*]Therefore, FIFO Unit Cost = Avg Unit Cost, until the quantity of items set by the IWA are consumed/sold.
[*]When new units of a FIFO Item are added (PO Item Receipt or normal Inventory Adjustment), they will be entered using FIFO[/LIST]
[*]The Last Cost (Last Purchase) field is NOT changed by the IWA
[LIST]
[*]However, this should not matter. The Last Cost is for visual reference only. It is NOT used when this item is consumed by an Assembly Build or is sold.
[*]The FIFO cost for FIFO Items is always used (in this case it is the same as Avg Cost)
[*]However, at this point the Last Cost field is VERY misleading.
NetSuite should change the Last Cost to Average Cost when an IWA is issued.[/LIST]
[*]The single IWA transaction will appear as two transactions when viewed on the Item Transactions tab.
[LIST]
[*]My understanding of this is that one of the transactions is to adjust the inventory to zero quantity and zero value.
[*]The other transaction is to set the inventory to the quantity and value you entered on the IWA form.[/LIST]
[/LIST]For more information, see "Inventory Worksheet Adjustments" in the NetSuite Help center.