# Business Central Production WIP Report and Make-or-Buy Setup

> Source: https://netray.co/erp-help/business-central-production-wip-report-and-make-or-buy
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: ERP Help

## Short answer

In Business Central, the Inventory Valuation - WIP report shows the value of unfinished production orders, and the amount in the general ledger comes from posted consumption, capacity and output through the WIP account in the inventory posting setup. Make-or-buy is set per item with Replenishment System (Prod. Order or Purchase) and Manufacturing Policy.

## Kind

how-to

## System

dynamics

## Erp

Microsoft Dynamics 365 Business Central

## Module

Manufacturing / Inventory Costing

## Query

business central production wip report

## Alternate Queries

- business central make or buy
- business central inventory valuation wip
- business central replenishment system prod order or purchase

## Applies To

Dynamics 365 Business Central, online and on-premises, with Manufacturing (Premium or Essentials for production orders). Report names can differ slightly by version.

## Steps

### Run the WIP report and set make or buy

**Items:**

- Search for Inventory Valuation - WIP and open the report; set the starting and ending dates and run it for the period to be reconciled.
- Run Adjust Cost - Item Entries first so consumption and output costs are correct, then run Post Inventory Cost to G/L if your setup does not post automatically.
- Compare the report total to the WIP account in the general ledger; differences point to unadjusted costs, manual journal entries or timing.
- For make-or-buy, open the Item Card and set Replenishment System to Prod. Order for make or Purchase for buy.
- Set Manufacturing Policy to Make-to-Stock or Make-to-Order, and set the production BOM number on the item for items that are made.
- Run the Planning Worksheet or Requisition Worksheet and Calculate Regenerative Plan; planned orders then follow the chosen replenishment system.
- Use stockkeeping units if make-or-buy differs by location, for example make at one plant and buy at another.

## Sections

### How WIP builds up and clears

**Body:**

When you post consumption of components to a released production order and run capacity (labor and machine time), the cost sits in work in progress. Posting output moves the finished item cost out of WIP into inventory. Whatever is left on open production orders is the WIP balance.

The WIP account is set in the inventory posting setup, and costs reach the general ledger through the cost posting routines. If the costing method is Standard, variances are calculated when the order is finished.

### Reports to know

**Body:**

Inventory Valuation - WIP reports the WIP value by production order. The production order statistics page shows expected and actual cost on a single order. For period reconciliation use the WIP report together with the general ledger entries for the WIP account.

Make sure you finish production orders that are physically done. Open orders with no activity inflate WIP and are a common source of reconciliation differences.

### Make or buy in practice

**Body:**

Replenishment System decides how the planning engine fills a demand: with a production order or with a purchase order. Manufacturing Policy decides whether production is anticipated (stock) or triggered by a demand (order). Combine them carefully; an item with Purchase replenishment and a production BOM will not generate production orders.

For a true make-or-buy decision, compare the roll-up cost of the production BOM and routing with the vendor price, and include capacity availability.

## Pitfalls

- Running the WIP report before Adjust Cost, which understates or mis-states cost.
- Leaving finished production orders in Released status, so WIP never clears.
- Setting Replenishment System to Purchase but expecting production orders.
- Not reconciling WIP to the general ledger every period.

## Ai Angle

An assistant grounded in your Business Central data can list production orders with WIP value and no activity, flag items where the replenishment setting conflicts with a production BOM, and show the query it used. It is read-only. Netray can run it against an on-prem database.

## Faq

### Which report shows production WIP in Business Central?

**Answer:** Inventory Valuation - WIP. Run it after Adjust Cost - Item Entries, and reconcile the result with the WIP account in the general ledger.

### How do I set make or buy for an item?

**Answer:** On the Item Card set Replenishment System to Prod. Order to make or Purchase to buy, and for made items set the production BOM and Manufacturing Policy.

### Why does my WIP not match the general ledger?

**Answer:** Usual causes are costs not yet adjusted or posted to the general ledger, manual journal entries on the WIP account, or finished orders still open. Run the cost routines and then compare again.

## Search terms

business central production wip report, business central make or buy, inventory valuation wip business central, business central replenishment system, business central manufacturing policy, business central production order cost, business central wip account, adjust cost item entries

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json
