Description

Average Cost Basis is an Inventory costing methodology alternative to First-In-First-Out (FIFO), and this decision should be made prior to adding any activity into the system. Average Cost Basis is calculated by taking the total cost of each Item you own and dividing by the total number of Quantity, and this calculation is done per Item per Warehouse. The calculation for the value is updated sequentially with any activity (see below) that would impact the calculation. 

Calculation

avgCost = ((prevCost * prevQty) + (newCost * newQty)) / (prevQty + newQty)

Transaction Types that impact Average Cost Calculation

At a high level, these are the positive adjustment transaction types that would affect the avg cost value:

1. positive adjustment
2. receive with no SOLineItemId
3. unfulfill with no POLineItemId
4. voidconsume
5. positive transfer

Transactions that use the Average Cost Basis

And here are the negative adjustment transactions that would use the calculated average cost:

1. consume
2. return with no SOLineItemId
3. fulfill no POLineItem
4. negative transfer
5. negative production
6. negative adjustment