NetSuite Insights & Guides | CuriousRubik

NetSuite Manufacturing Setup and WIP Controls

Written by Krishna | Feb 21, 2025, 5:00:00 AM

A manufacturing implementation can create work orders and still leave finance unable to explain production cost. The gap usually appears between physical activity and transaction capture: components are consumed before they are issued, time arrives late, or finished goods are completed while the order still holds unexplained work in process.

A sound NetSuite manufacturing setup connects the production model, bill of materials, work order, shop-floor capture, and accounting close. Evaluate that complete chain with one representative order before expanding to more products or locations.

Begin with the manufacturing model

Describe how the business actually produces: make to stock, make to order, assemble on demand, or a combination. Identify batch sizes, intermediate stock, routing steps, outsourced operations, and quality decisions that affect the transaction flow.

Then confirm which NetSuite features and entitlements support the intended design. Assembly builds, work orders, WIP, routing, advanced BOM structures, and specialist capture tools have different prerequisites and purposes. Their presence should be verified in the intended account.

Choose the simplest model that preserves the required operational and accounting evidence. Adding detailed routing to a process with no reliable time capture can create maintenance without better decisions. Omitting WIP detail from a long production cycle may leave finance with an unacceptable visibility gap.

Establish the product and cost foundations

Validate item types, units, locations, costing methods, and account mappings. Confirm the BOM quantities and revision rules. Decide which subassemblies are stocked and which relationships exist only for planning or engineering purposes.

Write down the expected cost flow. Which transactions move material into WIP? How are labour and overhead represented? What moves value into finished goods? What completes the accounting for the order?

These questions require a joint answer from manufacturing and finance. A posting account selected during setup is not evidence that the accounting policy has been agreed. Review local requirements and the organisation's costing policy before approving the design.

Release an order with known expectations

Use a test work order with a known quantity, BOM revision, location, schedule, and expected costs. Verify the component requirements before release and confirm how shortages or substitutions are handled.

Record who can release, change, cancel, or close an order. Decide how the shop floor learns that an order has changed after work begins. A correct master record cannot protect production if operators continue using an outdated instruction.

Include a partial completion in the rehearsal. Many configuration weaknesses remain hidden when the entire order is issued and completed in a single transaction on the same day.

A hypothetical production order

Assume an order plans 100 finished units. Each unit requires two components costing ten currency units each. Expected material is therefore 2,000. Illustrative conversion cost is ten per planned unit, or 1,000, giving an expected total of 3,000.

For this test, the approved costing design values good finished units at 30 each. Actual component issues total 206 units, valued at 2,060. Six additional components are consumed beyond the original 200-unit expectation. Recorded conversion cost is 1,000.

The order produces 98 good finished units and two rejected units. Total cost accumulated for the order is 3,060. The 98 good completions transfer an illustrative 2,940 into finished goods at 30 each. A remaining 120 requires explanation and approved close treatment.

This example assumes a particular test valuation and excludes other movements. It is not a universal posting result for every costing method. The implementation team must compare the actual ledger impact with the agreed expectation.

Reconcile quantity before explaining cost

The quantity evidence should show why 206 components were issued, what happened to the additional six, and how the two rejected finished units were handled. Distinguish material scrap, finished-unit rejection, rework, and unused components returned to stock.

A total cost variance does not provide that operational explanation. Two orders can have the same 120 difference for entirely different reasons: excess material use, labour overrun, incorrect standards, or missing completion records.

For the hypothetical order, the expected cost of two units not completed as good stock is 60. Additional component consumption contributes another 60. Together they explain the illustrative 120 remaining after good completions, subject to confirmation of the approved costing treatment.

If rejected units will be reworked, the order may require a different operational and accounting disposition. Record that decision instead of closing the order simply because the original due date has passed.

Capture work where it occurs

Choose a capture process operators can complete consistently. Specify the timing and responsibility for material issues, returns, operation time, rejected quantities, and completions. Validate any mobile, barcode, or integrated capture tools in the intended workflow.

Automatic consumption or backflush processes need their own tests. Compare calculated quantities with actual usage, substitutions, and scrap. A convenient automatic transaction may be appropriate, but it still relies on accurate BOMs and disciplined exception capture.

Test late time entry and corrections after a partial completion. Confirm what changes downstream and how finance sees the effect. Also check duplicate submission and interrupted processing so a retry does not create another issue or completion.

Separate physical completion from accounting close

A production team may consider the order finished when the last good unit leaves the line. Finance still needs all relevant transactions, cost processing, and variance review to be complete.

In a WIP process, review the order's opening balance, material and conversion additions, completions, returns, and other movements. Reconcile the remaining balance before the supported close process is approved.

Do not use close merely to sweep unexplained amounts out of WIP. A zero balance after closing can coexist with incorrect component consumption or a missing cost. Retain the explanation and actual close accounting as part of the order's evidence.

Decide what must pass before rollout

The end-to-end test should establish that:

  • The order uses the intended BOM, revision, units, and location.
  • Material shortages and substitutions follow an approved process.
  • Partial issues and completions preserve remaining quantities.
  • Scrap and rejected output are separately visible.
  • Labour and overhead capture match the selected costing design.
  • The WIP bridge reconciles to actual ledger activity.
  • Close variances are explained and reviewed.
  • Operators and finance can perform their tasks with assigned roles.

Include a period boundary if production normally spans month end. Same-day tests will not reveal every cutoff or late-entry issue.

Frequently asked questions

Does every manufacturer need routing and WIP?

The decision depends on production duration, cost visibility, scheduling needs, and control requirements. Evaluate the operational model and available features rather than enabling every capability by default.

Is a completed work order fully accounted for?

Not necessarily. Physical output, cost capture, and accounting close are distinct checkpoints. Verify the order's transaction history and remaining WIP before sign-off.

Can scrap be included in a general variance?

The accounting treatment depends on policy and configuration, but operations should still retain the quantity and cause. Otherwise, the business loses evidence needed to improve yield and investigate losses.

What is the best first manufacturing test?

Use one representative order with a partial completion, a realistic exception, and a complete quantity-and-value bridge. It should be simple enough to calculate independently but complex enough to expose normal operating risks.

Prove one production chain before scaling

Ask CuriousRubik about a scoped manufacturing setup workshop built around your BOM, capture process, and WIP reconciliation. A tested order gives operations and finance a shared standard for deciding what is ready to expand.