Average Purchase Value problem
Anybody experience that the average purchase value being updated as 100 times (vary by items) different compare to the actual price ?
Note: We are using containerized items.
E.g. The purchase price is 21.8 per container. When I check through the Purchase Order History, all the purchases are done with the same price. do not know what is the reasons causing the average purchase price and latest purchase price being updated as 0.218.
The item detail is:
Item code: JCCOSA
Inventory Unit: cap
Storage Unit: GK1
Price & Purchase Unit: GK1
Convertion factor for GK1 to cap: 100
Standard Cost updated as 0.0022
We also have a record that the average purchase price in May is recorded as 21.8.