I have setup few of my product to use Average Price as it's costing method but I'm wondering how it really works?
The tooltips mention it is recomputed at each incoming shipment but is it base on the item line from supplier's invoice, generated P.O or price from the product's page?
THanks & best regards, Max Chock.
The average price uses the following formula for calculating its price on each shipment received:
New Price = ((Old Price * Quantity valued at Old Price) + (Quantity received in last shipment * Price of the product in last shipment)) / (Quantity valued at old price + quantity received in last shipment)
This price is calculated every time a shipment and its corresponding invoice is confirmed
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 4/2/13, 9:35 AM|
|Seen: 2675 times|
|Last updated: 3/16/15, 8:10 AM|