Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
2 Trả lời
15300 Lượt xem

Hi,

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.

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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

Ảnh đại diện
Huỷ bỏ
Tác giả

thank you!

Hi Gustavo, are average costing method recalculate the cost price when we do an refund goods to supplier? cause when i tried refunds goods the cost price not changed (this is can cause the price always high), or i miss something to settings. I use OpenERP 7 on Linux Ubuntu 12.04. Thanks before.

@Gustavo thanks for the formula, but if you say old price what does that means, is it latest old price?

Câu trả lời hay nhất

New Price = 
((Available Quantity(ie,in warehouse) *  Product cost )+
( New Quantity(ie, quantity of product in new shipment) * New Price(ie, price of product in this shipment) ))  /  ( Available Quantity + New Quantity )

Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 8 25
252
2
thg 6 25
1723
0
thg 3 25
1598
0
thg 2 25
1246
3
thg 8 24
5936