How invoice variances affect the average costs of items

When calculating the average cost of an inventory item, the cost and currency variances are used to update inventory costs. This action occurs when the Update Cost/Currency Variances on Inventory Costs check box is selected. If the check box is cleared, the variance costs are not used to update inventory costs but are written to variance accounts instead.

The Update Cost/Currency Variances on Inventory Costs option is available from the Inventory Defaults window of the Organizations application.

For any transaction involving movement of items, the change of value in inventory must equal the transaction cost. In any case where this condition is not true, additional transactions must record the difference.

The product uses a perpetual average (or moving average) method for maintaining inventory value.

The primary features of the perpetual average method are the following:

Variances must be recorded if transactions affecting an inventory control account do not have an equal effect on inventory value.

Calculation of average cost for invoice variance

When invoice quantity is less than or equal to inventory balance, the average cost is calculated as follows:
  • Average cost = cost / quantity

When invoice quantity is greater than inventory balance, the average cost is calculated as follows:

In either case, the remaining invoice variance is recorded in the invoice transactions (INVOICETRANS) table.

Example with invoice variance

Example without invoice variance (balance is less than or equal to invoice quantity):



Feedback