hasa_multi_company_cost_price : This module modifies the product cost price for a multi-company use. No more need to have the same product for each company you manage to have the right cost price.

This module modifies the product cost price for a multi-company use. No more need to have the same product for each company you manage to have the right cost price.

It adds in the database the table product_multicostprice which makes the relation between a product, a company and a cost price. It allows to have different cost prices for the same product depending on the user company.

When you received products and you validate the incoming packing list, the rewrite "Make packing" wizard will check the quantity of each product in all the stock location of the user company, calculate the new cost price and update it in the table product_multicostprice.

!!!!!!TRY THIS MODULE ON A TEST DATABASE FIRST!!!!!!

CHANGES :

• Addition of the company field on stock locations

• The cost price (standard price) field in the product is now read only. It is a function that get the right cost price (depending the user company) in the table product_multicostprice.

• The cost prices are automatically calculated when the products are received (use of the "make packing" wizard when an incoming packing list is validated).

• To manually modify a product cost price you must load the view "Products/Products cost price" which is a list of all the products per companies. You have to be in the group "Product / Manager", otherwise you can only read the cost prices.

HOWTO :

1. !!!MAKE A BACKUP OF THE DATABASE!!!

2. You need to define which stock location will be used for the cost price calculation. You have to fill the company field ONLY on the stock location that will be used to calculate the amount of product in stock. I.e. don't fill the company on an output stock. Menu : "Stock management/Configuration/Locations"

3. You can manually change the product cost price in "Products/Products cost price" or import them (make a csv file with the columns : product name or code, partner name, cost price).

4. Don't forget to choose "Average Price" as the costing method on the concerned products. It allows to recompute the cost price at each reception of products.