Industries - Food and Beverage - Consignment Management

In partnership with Schouw Informatisering, Admiral Consulting Group exclusively offers SI Foodware®. Combined with Microsoft Dynamics NAV, this forms a standard company-wide ERP solution for the food and beverage sector.

Running a successful business in the turbulent fresh products market, such as the Fruit & Vegetable sector, means facing up to the challenges of time (speed and shelf life), logistics (transport and traceability) and quality. Retailers and customers are becoming increasingly critical and setting stricter requirements in which they find increasing support from regulations and the authorities.

Tuning supply to demand is a real challenge. Often, imported products are sold while still in transit and an amount has to be settled with a third party. Companies who trade in this way usually maintain a consignment administration so that they can continually monitor the logistics and financial situation of the consignments.

SI Foodware

The Food and Beverage industry is characterised by specific requirements which can often not be catered for by a standard company-wide solution. For this reason Schouw Informatisering and Admiral Consulting Group have combined their many years of knowledge and experience into SI Foodware®. In combination with Microsoft Dynamics® NAV, SI Foodware® forms a fully integrated standard company-wide ERP solution specifically for food and beverage companies.

SI Foodware is under continuous development and meets the latest industry requirements. This creates a specific solution, where costs remain manageable as the amount of customisation is reduced to a minimum. SI Foodware has been recognised by Microsoft with the highest quality label: 'Certified for Microsoft Dynamics'. SI Foodware consists of a number of integrated solutions, one of which is SI Foodware - Consignment Management. This solution provides insight into the logistics and financial status of consignments.

Consignment Management Functionality

The Consignment Management module enables you to register and monitor all logistics and financial transactions on the level of supplier, consignment contract, consignment, lot, item attribute or customer. Furthermore, Consignment Management deals with the situation where no regular purchasing transactions are recorded, but where purchasing is based on commission, joint account or minimum guarantee. In these settlement methods the cost of goods sold is calculated based on the costs incurred and the income from the transaction. And this calculated value is settled using a purchase invoice and/or credit memo.

This is known as self-billing. The integration with the consignment master record ensures the complete flow of information to the supplier and the consignment monthly closing procedure. Consignment Management functions independently from the chosen inventory valuation method but is particularly suitable for actual costing.

Consignment Management Process

The Consignment Management process starts with defining a consignment contract. The consignment contract defines data such as conditions, products and cost determination factors. In the data hierarchy a consignment contract is above an item. Cost determination factors are defined within Consignment Management based on item surcharges. Examples of these costs include costs for receipt, manual costs, cooling costs (per location), transport costs, costs for handling (per location) or costs for commissioners.

The goods will be purchased and received on consignment number. As soon as the purchase order is ready, a consignment master record is created. The consignment master record differentiates between general, source, logistics and financial data. Items from this consignment will be sold to customers. But these items may also be used in the production or assembly of semi-finished products or finished products. Furthermore, transfers, return orders and other corrections can be posted to this consignment. Consignment Management also contains unique lot tracing which is also displayed on any relevant order line.

Sales Report and Account Sale

Sales on account is the result agreed with the supplier that is settled based on one of the following account sale settlement methods: commission, joint account or minimum guarantee. For a consignment, per consignment line, the sale on account quantity and price are calculated based on the details in the consignment master record. A distinction is made in these transactions between direct and indirect sales where the consignment line can also be used in an assembly and/or production order. The consignment result is influenced by various factors.

One of these factors is that when posting the sale on account transaction, the quantity and the price can be entered so that a positive result can be achieved for the sale on account. A second factor is the commissioner's result, at monthly closing an interim amount is posted and on settlement a final amount. Finally a cost result may be posted due to higher or lower costs being passed on to the supplier. Intimately a combination of these three factors leads to the consignment result. Settlement is drawn up following the sales on account transaction.

The settlement is a collection of consignment revenues, costs and commission; that all have to be settled with the supplier. The consignment revenues are determined based on the sales on account transaction. The budgeted and/or posted purchase costs are the source for the consignment costs. The commission is based on the consignment revenues and is determined per supplier. However this last item can be changed during the final settlement.

Ultimately two results are calculated, the commissioner's result and a settlement result. When a settlement is posted, a purchase invoice or credit memo is automatically generated, thus creating a direct link with the settlement being posted.

Periodic Closure

The goal of Consignment Management is to give you a continuously clear overview of the costs and revenues of your consignments in every stage of the process. Therefore, the periodic activities 'Closing month' and 'Correct accounted costs' are created where costs and revenues to be accounted are placed on the balance and P/L accounts.

Reports

There are a large number of reports available within the Consignment Management module. These include the consignment contract, the sales report proposal, the account sale and the consignment result.