The following table describes the two fields in the Inventory Setup window that must be filled to enable average cost calculation.

Note
You can only use one average cost period and one average cost calculation type in a fiscal year. The Accounting Periods window shows which average cost period and which average cost calculation type is in effect during that period, for each accounting period.

When you post a transaction for an item that uses the Average costing method, an entry is created in the Avg. Cost Adjmt. Entry Point table. This entry contains the transaction’s item number, variant code, and location code. The entry also contains the Valuation Date field, which specifies the last date of the average cost period in which the transaction was posted.

Note
This field should not be confused with the Valuation Date field in the Value Entry table, which shows the date when the value takes effect and is used to determine the average cost period in which the value entry belongs.

The average cost of a transaction is calculated when the item’s cost is adjusted. For more information, see Design Details: Cost Adjustment. A cost adjustment uses the entries in the Avg. Cost Adjmt. Entry Point table to identify which items (or items, locations, and variants) to calculate average costs for. For each entry with a cost that has not been adjusted, the cost adjustment uses the following to determine the average cost:

• Determines the cost of the item at the start of the average cost period.
  
• Adds the sum of the inbound costs that were posted during the average cost period. These include purchases, sales returns, positive adjustments, and production and assembly outputs.
  
• Subtracts the sum of the costs of any outbound transactions that were fixed-applied to receipts in the average cost period. These typically include purchase returns and negative outputs.
  
• Divides by the total inventory quantity for the end of the average cost period, excluding inventory decreases that are being valued.
  

The calculated average cost is then applied to the inventory decreases for the item (or item, location, and variant) with posting dates in the average cost period. If any inventory increases exist that were fixed applied to inventory decreases in the average cost period, then the calculated average cost is forwarded from the increase to the decrease.

Example: Average Cost Period = Day

The following example shows the effect of calculating the average cost based on an average cost period of one day. The Average Cost Calc. Type field in the Inventory Setup window is set to Item.

The following table shows item ledger entries for the sample average-cost item, ITEM1, before the Adjust Cost - Item Entries batch job has been run.

Posting Date	Item Ledger Entry Type	Quantity	Cost Amount (Actual)	Entry No.
01-01-20	Purchase	1	20.00	1
01-01-20	Purchase	1	40.00	2
01-01-20	Sale	-1	-20.00	3
02-01-20	Sale	-1	-40.00	4
02-02-20	Purchase	1	100.00	5
02-03-20	Sale	-1	-100.00	6

Note
Because cost adjustment has not yet occurred, the values in the Cost Amount (Actual) field of the inventory decreases corresponding to the inventory increases that they are applied to.

The following table shows the entries in the Avg. Cost Adjmt. Entry Point table that apply to value entries resulting from the item ledger entries in the preceding table.

Item No.	Variant Code	Location Code	Valuation Date	Cost Is Adjusted
ITEM1		BLUE	01-01-20	No
ITEM1		BLUE	02-01-20	No
ITEM1		BLUE	02-02-20	No
ITEM1		BLUE	02-03-20	No

The following table shows the same item ledger entries after the Adjust Cost - Item Entries batch job has been run. The average cost per day is calculated and applied to the inventory decreases.

Posting Date	Item Ledger Entry Type	Quantity	Cost Amount (Actual)	Entry No.
01-01-20	Purchase	1	20.00	1
01-01-20	Purchase	1	40.00	2
01-01-20	Sale	-1	-30.00	3
02-01-20	Sale	-1	-30.00	4
02-02-20	Purchase	1	100.00	5
02-03-20	Sale	-1	-100.00	6

Example: Average Cost Period = Month

The following example shows the effect of calculating the average cost based on an average cost period of one month. The Average Cost Calc. Type field in the Inventory Setup window is set to Item.

If the average cost period is one month, then only one entry is created for each combination of item number, variant code, location code, and valuation date.

The following table shows item ledger entries for the sample average-cost item, ITEM1, before the Adjust Cost - Item Entries batch job has been run.

Posting Date	Item Ledger Entry Type	Quantity	Cost Amount (Actual)	Entry No.
01-01-20	Purchase	1	20.00	1
01-01-20	Purchase	1	40.00	2
01-01-20	Sale	-1	-20.00	3
02-01-20	Sale	-1	-40.00	4
02-02-20	Purchase	1	100.00	5
02-03-20	Sale	-1	-100.00	6

Note
Because cost adjustment has not occurred yet, the values in the Cost Amount (Actual) field of the inventory decreases corresponding to the inventory increases that they are applied to.

The following table shows the entries in the Avg. Cost Adjmt. Entry Point table that apply to value entries resulting from the item ledger entries in the preceding table.

Item No.	Variant Code	Location Code	Valuation Date	Cost Is Adjusted
ITEM1		BLUE	01-31-20	No
ITEM1		BLUE	02-28-20	No

Note
The valuation date is set to the last day in the average cost period, which in this case is the last day of the month.

The following table shows the same item ledger entries after the Adjust Cost - Item Entries batch job has been run. The average cost per month is calculated and applied to the inventory decreases.

Posting Date	Item Ledger Entry Type	Quantity	Cost Amount (Actual)	Entry No.
01-01-20	Purchase	1	20.00	1
01-01-20	Purchase	1	40.00	2
01-01-20	Sale	-1	-30.00	3
02-01-20	Sale	-1	-65.00	4
02-02-20	Purchase	1	100.00	5
02-03-20	Sale	-1	-65.00	6

The average cost of entry number 3 is calculated in the average cost period for January, and the average cost for entries 4 and 6 is calculated in the average cost period for February.

To get the average cost for February, the average cost of the piece received in inventory (100.00) is added to the average cost at the beginning of the period (30.00). The sum of the two (130.00) is then divided by the total quantity in inventory (2).This gives the resulting average cost of the item in the February period (65.00). The average cost is assigned to the inventory decreases in the period (entries 4 and 6).

The Valuation Date field in the Value Entry table is used to determine in which average cost period an inventory decrease entry belongs. This also applies to work in process (WIP) inventory.

The following table shows the criteria that are used to set the valuation date.

Example

The following table of value entries illustrates the different scenarios.

Scenario	Posting Date	Item Ledger Entry Type	Valuation Date	Valued Quantity	Cost Amount (Actual)	Item Ledger Entry No.	Entry No.
1	01-01-20	Purchase	01-01-20	2	20.00	1	1
2	01-15-20	(Item Charge)	01-01-20	2	8.00	1	2
3	02-01-20	Sale	02-01-20	-1	-14.00	2	3
4	03-01-20	(Revaluation)	03-01-20	1	-.4.00	1	4
5	02-01-20	Sale	03-01-20	-1	-10.00	3	5

Note

In entry number 5 in the preceding table, the user has entered a sales order with a posting date (02-01-20) that comes before the latest valuation date of applied value entries (03-01-20). If the corresponding value in the Cost Amount (Actual) field for this date (02-01-20) were used for this entry, then it would be 14.00. This would give a situation where the quantity on inventory is zero, but the inventory value is -4.00. To avoid such a quantity-value mismatch, the valuation date is set to equal the latest valuation date of the applied value entries (03-01-20). The value in the Cost Amount (Actual) field becomes 10.00 (after revaluation), which means that the quantity on inventory is zero, and the inventory value is also zero.

Caution
Because the Inventory Valuation report is based on posting date, the report will reflect any quantity-value mismatches in scenarios as in the above example. For more information, see Design Details: Inventory Valuation.

If the quantity on inventory is less than zero after posting the inventory decrease, then the valuation date is first set to the posting date of the inventory decrease. This date may be changed later, according to the rules described in the note earlier in this section, when the inventory increase is applied.

Valuing inventory decreases as a weighted average would be straightforward if purchases were always invoiced before sales are invoiced, postings were never backdated, and you never made mistakes. However, the reality is somewhat different from this ideal.

As illustrated in the examples in this topic, the valuation date is defined as the date from which the value entry is included in the average cost calculation. This gives you the flexibility to do the following for items using the Average costing method:

• Invoice the sale of an item before the purchase of the item has been invoiced.
  
• Backdate a posting.
  
• Recover an incorrect posting.
  

Note
Another reason for this flexibility is fixed application. For more information about fixed application, see Design Details: Item Application.

Because of this flexibility, you may have to recalculate the average cost after the related posting has occurred. For example, if you post an inventory increase or decrease with a valuation date that comes before one or more inventory decreases. The recalculation of the average cost will occur automatically when you run the Adjust Cost - Item Entries batch job, manually or automatically.

It is possible to change the inventory valuation base within an accounting period by changing the Average Cost Period field and the Average Cost Calc. Type field. However, this should be done with care and in agreement with an auditor.

Example

Concepts

Other Resources