D-MACC : Distribution Management and Invoicing

D-MACC is an integrated product that meets the needs of wholesalers and distribution companies who need to maintain a multi warehouse, multi product stock environment and produce invoices that automatically update the stocks and the accounts receivable and sales statistics.A wide range of reporting is available to monitor stocks, receivables and sales history and trends.This complete system is composed of several integrated modules some of which can be operated as standalone systems.

D-MACC main modules include the following:

Customer Relationship Management Database (CRM) including customer basic data, routing and other relevant information.
Stock Control System.
The Stock Control System is highly modular with very flexible file structure. The system has the following features:

Invoicing.

In order to minimise the processing of invoices and to ensure proper updating of the associated files, an integrated system approach is implemented. It involves the following steps and procedures :

A daily report of sales and collections is also produced by salesman. The summary of this report can automatically generate a daily sales journal voucher which is passed on to the general ledger system to complete the integration.

The issuing of the invoice therefore has updated automatically the customer accounts, the stock, the sales statistics and general ledger files. No more action on the invoice movements is needed.

The customer master file maintains data relevant to the customer dues, payment history, his salesman, credit limit, language of invoice, area etc... . All of this data can be requested on the screen.

The stock file has a multi-warehouse capability to allow for multiple branch operations. The stock movements file constitutes the base for sales statistics. This file contains sales by customer, item, area, salesman and date. The Sales data is maintained at the invoice item level by item number , quantity , sales value , discounts and cost value. From these details any level of detailed Sales Statistics , gross margin analysis and other reporting can all be produced.

Accounts Receivable, Credit Control and Aging Analysis. The accounts receivable module receives the customers debits (invoices) from the invoicing system which can be a separate module or integrated with the accounts receivable module. This module maintains customer movements by invoice, settlements can be in different currencies and mode of payments. The system interfaces with the general accounting system, the level of interfacing can be either at the individual account level or at the ledger control level.

Sales Reporting and Analysis.

The sales reporting system accepts input from either the on-line invoicing system or from invoices issued manually and entered offline. The system maintains sales data over any number of years, the data is maintained at the lowest optimum level/ item / warehouse/ customer / month / year / quantity/ gross value / net value / cost value / salesman.

The system interfaces with the customers file where the customer area, territory and trade are known thus additional variations on the sales file to which can be obtained by these classifications.

The stock file to which the system also interfaces is used to obtain the item units to product order units conversion factors.

With these features it is then possible to have a complete sales reporting management system. The system can produce summary reports for upper management and field reports for followup or for management evaluation whenever neccessary.

Interface to general accounting system.

Interface to/and from hand held devices of field sales force.

D-MACC basic modules include the followin :

D-MACC optional modules include the following: