# SAP Business One production planning: MRP, production orders, cost and variances

> Source: https://netray.co/erp-help/sap-business-one-production-planning-mrp-order-cost-variance
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: ERP Help

## Short answer

Planning in SAP Business One starts with demand (sales orders, forecasts), runs through the MRP wizard to produce recommendations, converts them into production and purchase orders, and ends with cost and variance review at close. The standard module is strong on BOM and MRP, light on scheduling and shop floor, where add-ons fill the gap.

## Kind

how-to

## System

sap

## Erp

SAP Business One

## Module

Production / MRP

## Query

sap business one production planning

## Alternate Queries

- sap business one production order variance report
- sap business one manufacturing add on
- sap business one for manufacturing industry
- sap business one production standard cost rollup

## Applies To

SAP Business One 10.0 on SQL Server or HANA; add-on scope depends on the vendor.

## Steps

### Run production planning in Business One

**Items:**

- Prepare master data: items with correct procurement method (make or buy), lead times, order multiples and minimum order quantity, and BOMs.
- Enter demand: sales orders, forecasts (Production > MRP > Forecast) and reorder points.
- Run the MRP Wizard (Production > MRP > MRP Wizard): choose scenario, scope, planning horizon, and what to consider (stock, open orders, forecasts).
- Review recommendations in Order Recommendation Report: select lines, then create production and purchase orders from it.
- Check component availability on the production order and release it. Adjust dates when components are late.
- Execute: issue components, report receipt, handle scrap, then close the order.
- After close, review cost and variances (see below) and adjust BOM quantities or standard costs.

## Sections

### Costing, standard cost and variance in production

**Body:**

Production order cost follows the item's valuation method. Components are issued at their cost, and finished goods are received at the order cost. With standard costing, the receipt is valued at the standard price of the finished item and the difference between actual consumption and standard is posted as a variance when you close the order. With moving average or FIFO, the finished goods take the actual cost.

A true multi-level rollup of standard cost is not a one-click function in the standard application. A common approach is to calculate the BOM cost from component prices (for example with a price list based on component cost), then update the finished item's standard price through a controlled process, such as a DI API script or an add-on. Confirm the options available in your version before you design the process.

### Order variance reporting

**Body:**

Compare planned and actual quantities and costs per order. The production order carries planned component quantities (WOR1) and issued quantities, and the inventory log (OINM) records the cost of each movement. A query joining these gives a variance report by component and by order, which you can run as a saved query or Crystal report.

Look at quantity variance (more or less material than the BOM said), price variance (component cost changed) and yield variance (receipt quantity versus planned). Different corrective actions follow from each: BOM correction, purchasing action or process fix.

**Code:**

- -- Planned vs issued quantity per component for closed orders
- SELECT T0."DocEntry", T1."ItemCode", T1."PlannedQty", T1."IssuedQty",
-        (T1."IssuedQty" - T1."PlannedQty") AS "QtyVariance"
- FROM "OWOR" T0 JOIN "WOR1" T1 ON T0."DocEntry" = T1."DocEntry"
- WHERE T0."Status" = 'L';

### Limits, process manufacturing and add-ons

**Body:**

The standard module does not provide finite capacity scheduling, work center routings with operations, co-product and by-product management, formula recipes with potency or yield adjustments, or shop floor data collection. Companies in process industries such as food, chemicals and pharma, or those with complex discrete routing, usually add a partner manufacturing solution built on the Business One platform.

When you evaluate add-ons, test them against your real BOMs, a real month of orders, your costing method and your upgrade path, and ask how they handle the next feature package. A short pilot on a cloned database is cheaper than a wrong decision.

## Pitfalls

- Running MRP with wrong lead times and then blaming MRP.
- Assuming standard cost rolls up automatically through multi-level BOMs.
- Closing orders late, so variances land in the wrong period.
- Ignoring scrap and yield in the BOM, causing permanent quantity variances.
- Buying an add-on without checking how it handles upgrades and your custom fields.

## Ai Angle

Planning questions are mostly questions about data: which components are short for next week's orders, which orders have large variances, which items have unrealistic lead times. A read-only assistant on your Business One database answers these and shows the SQL, and because it can run on your own server, the data stays private. Write actions such as creating orders remain a human step.

## Faq

### Does SAP Business One have MRP?

**Answer:** Yes. The MRP Wizard in the Production module calculates requirements from sales orders, forecasts and stock levels and produces recommendations to create production or purchase orders.

### How does Business One calculate production order cost?

**Answer:** It values issued components at their inventory cost and receives finished goods according to the item's valuation method. With standard costing, differences are posted as variances when the order is closed.

### Can Business One handle process manufacturing?

**Answer:** Only to a limited degree. Recipes, co-products, potency and strict batch control usually need a partner add-on. Test candidates against your process before you decide.

### How do I see production variances?

**Answer:** Use the production order reports and the inventory audit, or build a query comparing planned and issued quantities and the inventory log cost. Variances are posted when the order is closed.

## Search terms

sap business one production planning, sap b1 mrp wizard, sap business one production order variance, sap business one standard cost, sap business one manufacturing add-on, sap business one for manufacturing industry, sap b1 cost rollup, sap business one production order process

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