c2c-oerpscenario team mailing list archive
-
c2c-oerpscenario team
-
Mailing list archive
-
Message #31545
[Bug 842078] Re: Average cost does not work in a multicompany
Hello,
I have checked the bug report, It is related to the lp:778170 but
doesn't exactly the same.
This issue about the stock accounting with account anglo-saxon module
But currently I have not tested it because there are some problem is
already exist on picking in multi-company environment. please see this
lp:804991 and lp:828505 so after this both issue will resolved then we
will completely check your scenario.
So currently I am setting this issue as a "Triaged ".
Thanks for understanding!
--
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
References