← Back to team overview

openerp-india team mailing list archive

[Bug 1068037] Re: [trunk] 7.0 Wishlist Inventory issues in Multi-company and currency environment

 

Hello Emiliyan,

This types of issues are already posted/discussed, Would you please see
lp:778170 and lp:842078.

I appreciate your suggestion but currently we have not plan to improve
the functionality for V7, We are improved our GUI and Usability for v7.

This issue are closely related with  lp:778170, So I will your your bug
link on lp:lp:778170 and for meanwhile I am closing this issue.

Thanks for the suggestion!

** Changed in: openobject-addons
   Importance: Undecided => Wishlist

** Changed in: openobject-addons
       Status: New => Won't Fix

-- 
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):
  Won't Fix

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


References