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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Average Cost Issue: Partial Work Order Completion Causing Incorrect COGS on Period Close
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
0