c2c-oerpscenario team mailing list archive

["Amit Parik \(OpenERP\)" <amp@xxxxxxxxxxx>]

** Changed in: openobject-addons
       Status: New => Triaged

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/842078

Title:
  Average cost does not work in a multicompany

Status in OpenERP Modules (addons):
  Triaged

Bug description:
  In a multicompany setup, where there is a parent with children
  relationship, the cost of the product is the same throughout the
  company when the product is created as a shared product (ie. not
  belonging to a company). Eventhough seperate child companies can have
  different average costs on a product, there is only one cost value
  that the product can have. The cost of the product must be unique for
  each child company, as this allows for the inventory valuation to
  equal the branch's general ledger value.

  Assumptions: Using realtime valuation and anglo-saxon module and
  average cost.

  Here is an example:
            HO
         /         \
        /           \
  Branch1   Branch2

  Branch 1: buys 1 "test product" at R10 ->    reciepts stock and validates supplier invoice.
  Branch 2: buys 1 "test product" at R20  ->    reciepts stock and validates supplier invoice.
  Total stock valuation (eg. in reporting->inventory analysis) should be R30 Branch 1: stock value: 10 Branch 2: stock value: 20 Consolidated total: stock value: 30

  However stock cost is changed to 20 in the product object.
  So when you do a valuation analysis:
  Branch 1: stock value: 20
  Branch 2: stock value: 20
  Consolidated total: stock value:  40  (Wrong)

  This causes problems with the costs allocated to a sale in the general ledger or accounts. For instance: If you sell the product which has an original cost of 10, but is now expensed at 20, the inventory account will be -10 in the general ledger.
  The issue is the child companies do not know the stock levels at other branches and so over-write the products cost price to the branches average cost for that product.
  There are 2 options: Either the the stock average cost must be calculated at a consolidated level, and hence the average cost for the consolidated general ledger would be correct, The general ledger accounts will be accurate on a consolidated view, however incorrect on at a branch view. The other option is each branch must have its own average cost for that product. In this case the product valuation and cost will tie up with each branches general ledger.

  This bug is somewhat linked to bug: https://bugs.launchpad.net/openobject-addons/+bug/778170
  This bug clarifies the Average cost multicompany problem.
  This bug has been discussed with support and olivier as well.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/842078/+subscriptions