New OpenERP module: Product_costs and margin report >> OpenERP version 6.1
A product in OpenERP has a cost price and a sales price in the product form. It is also possible to make a sale- and purchase price list.
We want to add the concept of product costs in the product form. Product costs are e.g. transport costs. The costs are one fixed price. The costs are added to the current cost price, resulting in a new cost price.
So a product has now:
- Purchase price
- Costs (fixed amount)
- Cost price (= purchase price + costs)
- Gross profit amount (= Sales price – Cost price (calculated field, not editable)
- Gross profit %: (=Sales price – Cost price)/Cost price (calculated field, not editable)
Important:
- The purchase price is the base price for all purchases, and also for the purchase price list
- The cost price is the price shown in sales order, when you install standard module product_margin
We also need a report witch will print the margin on the sold product (based on invoices). The report has:
- Product
- Salesman
- Gross total amount (=quantity * base saleprice)
- Total discount (=gross amount - net amount)
- Net total amount (=quantity * customer saleprice)
- Purchase value (=quantity * cost price) >> The new cost price
- Gross margin amount (=net total amount - purchase value)
- Gross margin % (=net total amount - purchase value/purchase value)