Hello NetSuite Gurus
We are trying to determine whether our manufacturing configuration is contributing to a costing issue we see with partial Work Order Completions.
Our manufacturing process uses one large raw EPS block to produce multiple finished products over time. Operationally, our preferred workflow is to issue the raw material at the start of production and complete the Work Order as finished bundles are produced.
During testing, we found that when the full raw material is issued at the start of the Work Order, the first few partial Work Order Completions appear to absorb most of the material cost instead of the cost being distributed across the total planned production. Our Accounting team therefore changed our process so materials are only issued at the time of each Work Order Completion.
Before accepting this as a limitation of NetSuite, we'd like to confirm that our manufacturing preferences and costing configuration are correct.
Specifically:
- Are there manufacturing preferences (such as Cost of Assembly, Open WIP Amount, or other WIP/costing settings) that affect how costs are allocated during partial Work Order Completions?
- Is the behavior we are seeing expected for Average Cost items, or could it indicate that our manufacturing configuration is not set up optimally?
- Is there a recommended configuration that allows materials to be issued at the start of production while distributing the cost across all partial Work Order Completions as production progresses?
We're trying to determine whether this is an inherent limitation of NetSuite or whether there are manufacturing preferences or configuration options that should be reviewed.
I've attached an example prepared by our Accounting team showing the costing behavior we're seeing.
Thank you for your assistance.