...
- Moving Average Cost is calculated by company. Thus, the Moving Average Cost for an item will be the same across the entire company.
- Transactions that will cause recalculation of Moving Average Cost :
- Goods Received Note
- Purchase Return
- Stock Adjustment
- Trade In
- Sales Return ( if it's configured to use Invoice MA Cost )
- Transactions that consume the Moving Average Cost :
- Invoice
- Sales Return ( if it's configured to use Current MA Cost )
Sample Moving Average Cost calculation for Item1 in CompanyA :
| Creation Date | Transaction | Qty | Purchase Price/Unit | Unit Cost | Balance Qty | Balance Amt | MA Cost |
|---|---|---|---|---|---|---|---|
| 2015-10-01 | GRN1001 | 10 | 100.00 | NA | 10 | 1,000.00 | 100.00 |
| 2015-10-12 | INV2001 | 6 | NA | 100.00 | 4 | 400.00 | 100.00 |
| 2015-10-12 | GRN1002 | 20 | 90.00 | NA | 24 | 2,200.00 | 91.67 |
| 2015-10-23 | INV2002 | 1 | NA | 91.67 | 23 | 2,108.33 | 91.67 |
| 2015-10-28 | SR3001 (for INV2001) | 1 | NA | 91.67 | 24 | 2,200.00 | 91.67 |
| 2015-10-28 | PR4001 (for GRN1001) | 1 | 100.00 | NA | 23 | 2,100.00 | 91.30 |