openerp-india team mailing list archive

["Normunds \(Alistek\)" <610738@xxxxxxxxxxxxxxxxxx>]

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