Scenario
A user is working with a Work Order in Average Costing and notices this sequence:
- Work Order Issue 1 is entered for quantity 1
- Work Order Completion 1 is entered for quantity 1 and posts GL impact
- Work Order Issue 2 is entered for the remaining components
- Work Order Completion 2 is entered for quantity 1, but no GL impact is generated
The user also notices that after the second issue is created, the GL impact of the first completion changes.
Solution
This is standard NetSuite behavior for Work Orders using Average Costing with WIP. NetSuite recalculates and reallocates cost across partial completions so the total WIP balance is cleared correctly by Work Order close.
Option 1: Standard Issue and Completion Flow
When components are issued, their value moves from Inventory into the WIP Asset account. When a completion is saved, NetSuite relieves the WIP balance to value the finished assembly. If more component cost is added later, NetSuite re-averages the total cost pool across the completed quantities, which can update the first completion and leave the second completion with no immediate GL impact.
Option 2: Backflush Completion
When you use Backflush, NetSuite creates the Issue and Completion at the same time. This links the component cost directly to that completion, so each completion normally posts its own GL impact immediately. NetSuite noted that the first completion may still be updated later if component average cost changes between transactions.
Notes
- This behavior is tied to Average Costing and WIP cost reallocation.
- NetSuite treats the Work Order as a single cost bucket and redistributes the total cost pool across completions.
- The Average Cost Completion Unit Cost preference shown in the discussion was set to Open WIP Amount.
If the first Work Order Completion changes after a later component issue, and the second completion shows no GL impact, that is expected in an Average Costing WIP process. NetSuite is recalculating the cost pool across the full Work Order instead of locking the first completion cost at entry.
-----
If you find this information useful, let us know by reacting or commenting on this post!