This is what I am trying to show in numbers. See attached xls file. File is downloaded from: http://toolboxes.flexiblelearning.net.au/demosites/series11/11_06/toolbox11_06/resources/html/ffact_weightavinvent.htm
So, first definition: we use here Weighted Average Cost Valuation- NOT FIFO OR LIFO!!!! According this table we recalculate Average price in INPUTS only. We USE our current Average Cost Price for customer refunds - therefore there is no need to adjust Average Cost Price on customer refund, because we DO NOT use original Cost price at time of Sale on Customer Refund, because of two reasons: 1. We do not use FIFO 2. We may not use incoming/outgoing lots tracking what is not required with Weighted Average Cost Valuation but required with FIFO. When we do not use lots we even do not know cost price at time of Sale of particular item. It looks like Fabien is right. He is right sometimes :)! I am also not accounting guru, therefore should rely on external sources, but we need this made crystal clear in OpenERP. I tested Camptocamp c2c_stock_accounting module also - I got messy results with it. Is this latest version available on launchpad? Please, make your comments. Normunds Alistek Ltd ** Attachment added: "stockcard1.xls" https://bugs.launchpad.net/openobject-addons/+bug/610738/+attachment/3818879/+files/stockcard1.xls -- You received this bug notification because you are a member of OpenERP Indian Team, which is subscribed to OpenERP Addons. https://bugs.launchpad.net/bugs/610738 Title: [Trunk/7.0/6.0/5.0] return products to supplier does not update price average Status in OpenERP Addons (modules): Confirmed Bug description: When returning products to a supplier, the average standard price should be updated using the price of the packing list which is returned. For example : 1- We have 10 products with average price = 100 2- We receive 5 products with price = 80 --> average price is calculated as (10*100+5*80)/(10+5) = 93,33 3- We return 3 products from the last packing list (the one where products cost 80) The new average price should be (93,33*15 - 3*80)/(15-3)=96,67 If the return is made directly from the stock and does not concern any incoming packing list, we do not update the average price. To manage notifications about this bug go to: https://bugs.launchpad.net/openobject-addons/+bug/610738/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~openerp-india Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-india More help : https://help.launchpad.net/ListHelp
