Module Margins
| Marges | |
|---|---|
| Numéro/ID du module | 59000 |
| Doc utilisateur du module | This page |
| Doc développeur du module | Module Margin (developer) |
Introduction
This module is included in Dolibarr since version 3.3.0
The margins module allows you to calculate and display the margins made on sales. Summary tables provide a view of the margins on each document (commercial proposal, order, contract, invoice) as well as overall, by user, product and customer.
The margin can be calculated by default against the best purchase price or the AWP price (Aveage Weighted Price), although there is the possibility of free entry of the purchase price at any time.
Installation
This module is included with the Dolibarr distribution, so there is no need to install it.
Configuration
To use this module, you must first activate it. To do this, after logging in with an administrator account, go to the "Home - Configuration - Modules" page.
Choose the tab where the module appears and click on "Activate".
The module is then activated.
Define your global operating parameters for the module:
Choice of the type of margin managed: gross margin or net margin
Display of the margin rate or the brand rate
Behavior of the module if the purchase price is not entered in the lines:
At "ON" the line is taken into account with a zero margin (the purchase price is forced to be equal to the sales price)
At "OFF" the line is taken into account with a margin equal to the sales price (the purchase price is forced to 0).
Choose a method for managing global discounts: on the total, on products or on services
(Optional) Define a contact type to be used to assign the margins of a document to a user other than the one assigned as salesperson on the third party. It is possible to use a predefined contact type of Dolibarr, or to create one for this purpose (in Configuration -> Dictionaries -> Contact types).
Managing purchase prices/costs
Enter the supplier purchase prices on your product and service sheets - you can have several. They will be proposed as a choice of purchase price on the lines for entering sales proposals, customer orders and customer invoices (drop-down list) - they also allow you to create supplier orders. On the supplier files for products and services, you have an additional field called "Charges" which allows you to add your own charges to the supplier purchase price. The total will be the cost price of your product or service. By choosing to calculate the net margin in the settings, all the margin calculations described below will be made on this cost price, and not on the supplier price alone. If you enter a supplier price for a minimum number of items (for example, 100 chairs) because you have a particular rate from a threshold of products purchased, you can also enter the charge corresponding to this "batch". It will be distributed to be considered as a unit cost on each item of this ordered lot.
Manage your sales people
To track margins by salesperson, you must have as many user accounts as different salespeople. These accounts must be internal to the company, not external. Then, on the tab "file" of your customers, you must choose a salesperson to attach to this customer. From then on, no matter which user creates the invoices, the margins will be posted to this sales person, unless you define a different type of contact and user on the invoices (on a case by case basis).
Attention : Dolibarr allows you to assign several sales representatives to a third party. However, the Margins module does not manage this case, and your margins will be multiplied by the number of sales representatives indicated.
You must therefore assign only one salesperson per third party (the main one), then manage the cases of different salespersons via the "Contacts/Address" tab of each document concerned by choosing the user concerned, and the type of contact that you have defined in the module configuration.
Entering a document
In the propale/order/invoice line entry, choose or enter the purchase price of the product or service to include the line in the margin calculation.
Choice of purchase prices:
- If you enter a "free" line, you indicate the sale price and the purchase price (or the cost price according to your choice of global calculation).
- If you choose a product or service from your product/service base, you will be able to choose a supplier price as indicated on the file, or enter a free purchase price.
Rappel : si le prix d'achat n'est pas renseigné, la prise en compte de la ligne dans le calcul des marges dépendra du paramètre que vous avez défini dans la configuration du module.
Un tableau récapitulant les marges relatives au document en cours, avec une ligne pour les marges sur les produits, une pour les marges sur les services, et une pour la marge totale du document est présent sur l'écran de chaque document.
Cas des remises
Une remise faite sur une ligne sera prise en compte pour le calcul de la marge. Les remises globales sont prises en compte en fonction du paramétrage du module.
Récapitulatifs généraux
Accédez aux récapitulatifs généraux par commercial, par client ou par produit/service en cliquant sur le menu Marges présent dans Compta/Tréso.
La prise en compte des marges dans les tableaux récapitulatifs est faite sur les factures validées. Pour chaque onglet de cet écran, vous pouvez afficher le tableaux récapitulatif ou le détail par produit, client, ou agent commercial. Vous pouvez également sélectionner une plage de dates de prise en compte des factures validées.