Hi Everyone,
I am facing a costing issue in NetSuite Manufacturing while using Average Costing and would appreciate your guidance.
Scenario:
- Work Order created for 5 quantity
- Work Order Issue done for all 5 qty on 29-Jan-2026
- Work Order Completion done for 2 qty on 30-Jan-2026
- A Sales Order and Item Fulfillment was created for these 2 completed items
- At month end, the accounting period was closed
While reviewing the GL impact of the Item Fulfillment, the COGS value appears to reflect the cost of all 5 quantities issued, rather than only the 2 completed units.
Later, when attempting to complete the remaining 3 quantities, the average cost is showing as zero, resulting in zero cost for the completion.
Questions:
- Why is NetSuite allocating the cost in this way when using Average Costing?
- What is the best approach to handle or correct this scenario, especially since the accounting period is already closed?
- What would be the recommended best practice to avoid this situation in the future?
Any insights or recommended approaches would be greatly appreciated.
Thank you!