SAP Business One Production Order: What Impacts Total Variance

In SAP Business One, the Total Variance on a production order represents the difference between the actual value of components issued to production and the value of finished goods/by-products received from production.

At a high level:

Total Variance = Value of Issues for Production / Returned Components compared against Value of Receipts from Production

This variance is calculated at the individual production order level. It does not automatically affect other production orders, except indirectly through inventory valuation if later transactions consume or receive items whose costs were affected by revaluation.

The SAP Business One SDK table reference also confirms that production order-related cost adjustment/recalculation data tracks both Issue for Production and Receipt from Production document types, including line cost, actual accumulated cost, applied adjustment, and variance fields.

1. Main Concept

A production order has two financial sides:

If these two sides do not match, SAP Business One shows the difference as Total Variance on the Summary tab of the production order.

2. What Creates Total Variance

A. Component Overconsumption

This occurs when the production order consumes more components than originally planned.

Example

Planned component requirement:

Actual issue:

The finished good may have originally been received based on a lower expected cost. If more material is issued than expected, the production order absorbs additional cost.

Impact

This normally creates a negative production variance because the actual input cost is higher than expected.

B. Component Savings

This occurs when the production order consumes less components than originally planned.

Example

Planned component requirement:

Actual issue:

The production order used fewer components than planned.

Impact

This can create a positive production variance because the actual input cost is lower than expected.

C. Component Cost Changes

Even if the quantity consumed is correct, variance can occur if the cost of the components changes during the production process.

This is especially relevant when items are valued using methods such as:

• Moving Average

• FIFO

• Serial/Batch valuation

• Any non-standard cost valuation method

Example

At the time the finished good is received, SAP Business One may estimate the finished good value based on the component cost available at that moment.

If the component cost changes before or after the issue is posted, the actual issued value may differ from the originally expected receipt value.

Impact

The system may need to revalue the finished product when the production order is closed.

D. Receipt from Production Before Issue for Production

This is one of the most common causes of variance.

A Receipt from Production can be posted before all components are issued. In that case, SAP Business One has to assign a value to the finished product before it knows the final actual component cost.

Example sequence

Impact

If the production order structure, component quantities, or component costs change between the receipt and the issue, a variance can result.

E. Changes to the Production Order Structure

Variance can also occur if the production order is changed during execution.

Examples:

• Components are added.

• Components are removed.

• Planned quantities are changed.

• Warehouse assignments are changed.

• Item costs change before posting.

• The receipt is posted before the final component structure is settled.

If the receipt value was based on one structure, but the actual issues reflect another structure, SAP Business One will calculate a variance.

3. What Happens When the Production Order Is Closed

For items using valuation methods other than standard cost, SAP Business One performs a reconciliation-style calculation when the production order is closed.

The system generally does the following:

Step 1: Sum Received Output Value

SAP Business One sums the value of:

• Finished goods received from production

• By-products received from production

These are based on the Receipt from Production transactions.

Step 2: Sum Actual Component Value

SAP Business One sums the value of:

• Components issued to production

• Returned components, if applicable

These are based on:

• Issue for Production

• Receipt from Production for returned components, where applicable

Step 3: Compare the Two Amounts

If the total received output value does not equal the total issued component value, the difference becomes the Total Variance.

Simplified example

In this example, the production order consumed $150 more in components than the value initially assigned to the finished goods.

4. How SAP Business One Handles the Variance

When the production order is closed, SAP Business One may revalue the finished product according to the actual cost of issued components.

The purpose is to replace estimated product cost with actual production cost.

In many cases, this clears or reduces the production variance because the finished good inventory value is adjusted to reflect the real cost of production.

5. Accounting Impact

The accounting impact depends on the company’s G/L Account Determination setup.

The variance can impact accounts such as:

The specific journal entry depends on:

• Item valuation method

• G/L determination setup

• Whether WIP accounts are configured

• Whether the item is standard cost or moving average/FIFO

• Timing of Issue for Production and Receipt from Production

• Whether the production order is closed with remaining differences

6. Why Standard Cost Behaves Differently

For standard cost items, SAP Business One expects the finished good to be valued at the predefined standard cost.

If actual component consumption differs from the standard cost expectation, the difference is typically posted as variance rather than changing the finished good cost.

For non-standard valuation methods, such as Moving Average or FIFO, SAP Business One can revalue the finished good based on the actual issued component cost when the order is closed.

7. How to Investigate the Variance

To understand what caused the Total Variance, review the production order in this order:

A. Compare Planned vs. Actual Components

Check whether actual issued quantities differ from planned component quantities.

Look for:

• Overconsumption

• Underconsumption

• Additional components

• Missing components

• Returned components

B. Review Posting Sequence

Check whether the Receipt from Production was posted before the Issue for Production.

This is important because receipt-before-issue often causes temporary or final variance if costs changed afterward.

C. Review Component Cost at Posting Time

Confirm the item cost at the time of:

• Issue for Production

• Receipt from Production

• Production order closure

A cost change between these events can create variance.

D. Review Production Order Changes

Check whether the production order was updated after partial processing.

Examples:

• BOM changed

• Planned quantity changed

• Component line changed

• Warehouse changed

• Additional issue added manually

E. Use the Variance Report

In SAP Business One 9.3 PL02 and later, the Variance Report is available from the production order.

Path:

Production Order → Summary tab → Link arrow beside Variance Report

This report helps identify which component contributed to the final production variance.

8. Practical Summary 

The Total Variance on a production order is the difference between what SAP Business One received into inventory as the finished product value and what was actually consumed through component issues.

It is mainly affected by:

1. Using more components than planned

2. Using fewer components than planned

3. Posting receipt from production before issuing all components

4. Changes in component cost during the production process

5. Changes to the production order or BOM structure

6. Returned components

7. Item valuation method

8. G/L account determination setup

The variance belongs to the specific production order. When the order is closed, SAP Business One compares the total value received from production against the total value issued to production. If there is a difference, it is shown as Total Variance and may be posted or cleared through inventory revaluation depending on the valuation method and accounting setup.