AL Commission

The commission module is developed with the new AL development technology for Navision 2018. It can be installed without changing the standard code and allows it to be automatically updated with the new versions of Microsoft Dynamics Nav.

The advantages of this module for calculating commissions are:

  • an easy and flexible setup, which adapts to the company's calculation needs by proceeding by exceptions on the combination of agents with customer and product hierarchies (freely definable by the user with any number of levels);

  • the consistency with which it guarantees the correctness and punctuality in the calculation of commissions;

  • the simplicity with which any errors made in the setup for the calculation are discovered and corrected;

  • the speed with which it automatically calculates the commissions of the fleet of agents and / or the list of area managers;

  • the precision with which the system charges (or reverses for credit notes) the cost of commissions to individual sales lines through the lines of purchase invoices for commissions that the system automatically generates broken down by billing period and agent;

  • the immediacy with which it integrates with the modules for the calculation of the Enasarco and the contracts for year-end bonuses (GDO), from which it is possible to print the real margins net of discounts, transport costs, end-of-year bonuses year and, in fact, of the commissions.

In particular, we can summarize the main characteristics of the product in the following points:

  1. The commission setup is a series of combinations of agents with the various levels of freely defined customer and product hierarchies. The system, to calculate the commission, retrieves the setup defined at the highest level of detail so that, for example, if there are two applicable setup lines for the calculation of commissions, one defined for the entire GDO and the other for a brand or even a single store, the system will use the row corresponding to the store to calculate the commission. Similarly, if there are two (or more) setup lines, one referring to all the products and the other to the "private label" one, the system will select the setup line corresponding to the private label items.

  2. Ability to calculate commissions by hierarchy of agents. For each agent, it is possible to freely define different lists of super-agents and sub-agents to which it belongs and for which to calculate the commissions on the customers assigned to the agent. It is possible to modify this list for single customer or even for single invoice.

  3. Possibility to define, for each agent, the calculation period and the type of calculation of the commissions so that the system can automatically create for each agent and for each period, a batch (journal) for the calculation of his commissions and the commissions of subagents (or area managers) attached to him. The system allows you to massively launch the calculation of commissions for the desired batches (for example relating to all agents for the third quarter of 2015).

  4. Commissions are always calculated with the greatest possible detail, that is by agent, invoice (or credit note) and item and always explains the setup used to make the calculation. It is therefore easy for the operator to identify any errors in the commission setup (for example, the commissioner has forgotten to define the commissions for a certain class of products) and remedy them by modifying it. At this point it is sufficient to relaunch the calculation of the commissions to immediately check the validity of the corrections made.

  5. Management of the discount scale. It is possible to calculate the commissions on the basis of the (real) discounts applied to sales to customers. Discounts are calculated from the list price of the sales line and the price invoiced to the customer. This prevents errors in the calculation of the discounts actually applied.

  6. Possibility of connecting multiple agents to the same supplier. This allows you to easily set up different setups relating to agents linked to the same supplier, to whom the purchase invoices for commissions will still be made out.

  7. The system allows you to automatically generate purchase invoices for commissions. If several agents are linked to a single supplier, the system allows both to keep the purchase invoices distinct by agent, and to group them into a single invoice, with the purchase lines distinct by agent and billing period. The purchase invoice lines are debit lines that automatically and promptly assign the cost of the commissions to the sales lines for which the commissions have been calculated. This allows you to have a cost of commissions, per single sales line, exact to the cent.

  8. In the commission purchase invoices it is possible, through the Enasarco management module, to automatically calculate the Enasarco contributions.

  9. Ability to print the commission summary by agent, group, brand, billing customer, delivery point and item. In the event that a single agent is selected, it is also possible to automatically send the pdf of the commission summary to the agent by email. Ability to print the purchase invoice with the amounts corresponding to the summary of the commissions sent to the agent.

  10. Calculation of commissions for turnover or collected (possibly partial). In the batch for the calculation of the commissions and in the printing of the summary, in addition to the payable amount corresponding for example to the amount collected, the amount of the accrued commission corresponding to the turnover is always shown.

  11. Possibility of calculating the commission only when the amount is fully collected.

  12. Possibility to freely create batches for the calculation of commissions with different calculation methods (collected, invoiced, fully collected), period (month, quarter, semester, year) different from those set for agents. This allows for example to calculate and print the commissions for the turnover of a whole year for all agents, or the commissions on the turnover of the third quarter of 2015 of an agent who has instead set a monthly commission settlement period and the calculation of commissions on the collected.

  13. This module is integrated with the module for calculating year-end bonuses, from which it is possible to print the margins, netted with respect to the commission amounts that are precise to the hundredth for each sales line.