Developed starting from the needs of leading food companies, AL Food is an agile vertical that elegantly solves the multiple and complex needs of this sector.
Microsoft Dynamics NAV is Microsoft's ERP solution that offers small and medium-sized businesses greater control in financial and accounting management, as well as simplifying the management of supply chains, production and operations. It is quick to implement, easy to use and is able to grow with the company.
On this platform, Applibra has developed AL Food, a vertical that solves the needs of companies working in the agri-food world, from purchasing and production planning (particularly important when sales budgets are linked to campaigns for Easter and Christmas), to integrated management outlets, interfacing with scales, integrated quality management system, integration into all company processes with the management of radio frequency terminals for reading EAN 128 (GS1) codes, EDI system, to the management of agents' commissions, to end-of-year bonus contracts (GDO) to a system for the management of recipes integrated with a system for calculating the standard cost of the product, which allows to arrive at a precise calculation of product margins.
Management of commercial policies. AL Food allows you to manage a plurality of commercial channels in an advanced and effective way, first of all the large-scale retail trade, with its elaborate multi-level structure with groups, brands and points of sale. Integrated with the systems for calculating commissions and transport, this system allows you to calculate margins with great precision, starting from a single sales line, up to the turnover of an entire group.
Traceability and traceability of products. An important concept for agri-food products; for this reason AL Food offers specific functions that allow to comply with the laws in force on food safety in the best way, following the product along the entire supply chain.
Terminal management. AL Food interacts natively with the terminal applications and allows you to manage purchases, sales, transfers and inventories. The use of EAN 128 barcodes, which contain multiple information and are universally recognized in the agri-food world, allows operators to automate the insertion process right from the loading of raw materials, eliminating input errors at source, making more business processes are simple and efficient, allowing greater control and real-time updating of information on products in the warehouse.
Accessibility. Taking advantage of the modern NAV platform, AL Food is easily accessible from the web, tablet or smartphone, being able to control the company in the most convenient ways for the user.
Interfacing with external systems: AppLibra srl has developed interfaces with various platforms of the most important service providers that gravitate around the agri-food world: from systems for order collection, to systems for the management of excise duties (calculated natively by AL Food), to systems for the management of the tills, to the bidirectional interface with the scales
Quality management. Natively integrated, the system allows you to easily manage all problems related to quality.
Business Intelligence. To keep the large amount of data necessary to manage the complex world of agri-food monitored in the best possible way, AL Food provides powerful Business Intelligence tools with integration with QlikView as well as with the native potential 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:
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.
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.
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).
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.
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.
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.
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.
In the commission purchase invoices it is possible, through the Enasarco management module, to automatically calculate the Enasarco contributions.
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.
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.
Possibility of calculating the commission only when the amount is fully collected.
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.
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.
In AL Quality it is possible to set up sampling plans that define the checks, the periodicity and the constraints on the measured values that must be carried out to guarantee the quality of the products.
When a product is sent into production, which is linked to a sampling plan according to its type, the set of printouts of the checks to be carried out for each operator in the different stages of production are produced.
The detections can be automatic, thanks to the integration of the module with devices that are in the production lines (for example NIR machines or seal recognition systems).
The system can therefore produce, coupled to each production batch, the certifications that the required checks have been carried out on the product and that the measured results were within the range of allowed values.
The quality system is also connected to the receipt of raw materials and allows, thanks to a connection with the credit note system, to automatically enter the reason for non-compliance which, based on the severity found, will help determine the supplier's assessment. , automatically calculated based on the frequency and severity of non-conformities found.
The certificates and non-conformities are linked both to the lot and to the plant on which the checks were carried out.
Thanks to the hierarchical plant concept, it is possible to calculate detailed statistics.