openerp-india team mailing list archive

[Emiliyan Tanev <em.tanev@xxxxxxxxx>]

Public bug reported:

Hello,

I will talk about two issues which are related to older versions too.

So, lets think about this business case:

We are small trading company which is operating in one or several
countries and we would like to implement ERP system for our shops which
are separate legal entities. We are selling same products in every shop,
but we have different sale prices, suppliers, shipping costs, currencies
and etc.

Here are some issues, that we will face, if we want to have 1 product in
OpenERP db for all companies:

1. Accounting - We can't have separate average cost for all products.
You can have different suppliers with different shipping costs which are
selling to you with different sale prices and in different companies.

http://www.iasplus.com/en/standards/standard6 - From International
Accounting Standard 2 for inventory valuations, cost should consist:


- costs of purchase (including taxes, transport, and handling) net of trade discounts received
- costs of conversion (including fixed and variable manufacturing overheads) 
- other costs incurred in bringing the inventories to their present location and condition

Here we could mention purchase_landed_costs module which will be great
if its implemented in 7.0 as a core module.

But here is another obstacle for Multi-Company. For every legal entity
we should have separate average costing of our products, but currently
in OpenERP all companies have one costing. That will be unacceptable for
every company that would like to use the system for the accounting
purposes. And as you know, accountants are stakeholders with huge power
in decision-making when we are going to talk about ERP.

2. We don't have the ability to set different basic sale price for
different products with different currency. It takes only the base
currency which is not good thing. Solution that I found for 6.1 is
product_price_currency. It will be great to have it in the core.


Easy solution:

The turnaround will be to have separate product in OpenERP db for every
company and somehow to consolidate the information. That could be done
by adding "View" types of products which will be parent of same child
products. Parent view type of product should consolidate the quantities
and inventory valuation. The problem here is how to show the stocks of
the other shops of particular item, so the sales rep to know where they
have stocks of particular item.


Advanced solution:

1. To have separate average costing for every company. Maybe that will be a big architectural change in DB of products and movements.
2. To have separate price for every company with different currency similar to suppliers in procurement tab
3. To have the ability to choose supply method, costing method and procurement method and other things that I could forgot know

In summary it could be done like product catalog for the group, where
child companies will choose their products with their configuration. It
is a huge, but maybe necessary change if we want to use OpenERP in
multi-comapny.

Regards,
Emiliyan Tanev, CIMA Adv Dip Management Accountant

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
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/1068037

Title:
  [trunk] 7.0 Wishlist Inventory issues in Multi-company and currency
  environment

Status in OpenERP Addons (modules):
  New

Bug description:
  Hello,

  I will talk about two issues which are related to older versions too.

  So, lets think about this business case:

  We are small trading company which is operating in one or several
  countries and we would like to implement ERP system for our shops
  which are separate legal entities. We are selling same products in
  every shop, but we have different sale prices, suppliers, shipping
  costs, currencies and etc.

  Here are some issues, that we will face, if we want to have 1 product
  in OpenERP db for all companies:

  1. Accounting - We can't have separate average cost for all products.
  You can have different suppliers with different shipping costs which
  are selling to you with different sale prices and in different
  companies.

  http://www.iasplus.com/en/standards/standard6 - From International
  Accounting Standard 2 for inventory valuations, cost should consist:


  - costs of purchase (including taxes, transport, and handling) net of trade discounts received
  - costs of conversion (including fixed and variable manufacturing overheads) 
  - other costs incurred in bringing the inventories to their present location and condition

  Here we could mention purchase_landed_costs module which will be great
  if its implemented in 7.0 as a core module.

  But here is another obstacle for Multi-Company. For every legal entity
  we should have separate average costing of our products, but currently
  in OpenERP all companies have one costing. That will be unacceptable
  for every company that would like to use the system for the accounting
  purposes. And as you know, accountants are stakeholders with huge
  power in decision-making when we are going to talk about ERP.

  2. We don't have the ability to set different basic sale price for
  different products with different currency. It takes only the base
  currency which is not good thing. Solution that I found for 6.1 is
  product_price_currency. It will be great to have it in the core.

  
  Easy solution:

  The turnaround will be to have separate product in OpenERP db for
  every company and somehow to consolidate the information. That could
  be done by adding "View" types of products which will be parent of
  same child products. Parent view type of product should consolidate
  the quantities and inventory valuation. The problem here is how to
  show the stocks of the other shops of particular item, so the sales
  rep to know where they have stocks of particular item.

  
  Advanced solution:

  1. To have separate average costing for every company. Maybe that will be a big architectural change in DB of products and movements.
  2. To have separate price for every company with different currency similar to suppliers in procurement tab
  3. To have the ability to choose supply method, costing method and procurement method and other things that I could forgot know

  In summary it could be done like product catalog for the group, where
  child companies will choose their products with their configuration.
  It is a huge, but maybe necessary change if we want to use OpenERP in
  multi-comapny.

  Regards,
  Emiliyan Tanev, CIMA Adv Dip Management Accountant

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