R-MACC : RETAIL MACC

This Integrated product meets the needs of Retail Companies by providing systems for the Sales Outlets and for the Back Office and the complete communication and control facilities between them.

When the Branches and the central system are not connected online the system provides for a Push and Pull synchronisation and update technique. The system Pulls all the branch data (Sales, transfers and then Pushes into the Branches incoming transfers, new prices, new items etc…). This way the central system maintains a full copy of the Branch data and keeps control on the pricing and new items by restricting this function to the head office.

This complete system is composed of several integrated modules some of which can be operated as standalone systems.

A - THE SALES OUTLET MODULES ARE :

- Point of Sales system including :
- Sales Invoice
- Settlement
- Returns
- Day end closing
- Outlet Back Office
- Stock Receiving and Transfers
- Accounting Preparation
- Communication to other branches and Head Office

B - MACC BACK OFFICE MODULES

- Communication with Outlets
- Company stock control and sales reporting.
- General Accounting
- Foreign purchases and automatic landing of goods
- Budget and financial Reporting
- Bank statement reconciliations
- Payroll
- Fixed Assets management
- Human Resources
- Time and attendance system


POINT OF SALES (POS)

SYSTEM FEATURES

The POS system has the full functionalities required to handle the customer checkout needs as well as outlet controls and back office function links.

- Fully programmable in Database language to allow customisation
- Maintains the stock database on-line
- Several cashiers may be active at same time to allow for single or Network environment.
- Full functionality to cancel, return etc... .
- Multicurrency settlement.
- Snapshot summary during the day
- Full daily closing procedure
- Link to local Back Office System
- Two way Link to Central system for push/pull of data.

INTER-COMPANY DATA MANAGEMENT

In order to provide for a secured data manipulation between the various branches and the head office the following procedure has been developed :

- The Head Office system acts as the Central Control for many functions in the system. The following functions are reserved for the Head Office system :

§ Creation of new items, suppliers, units
§ Price changes
§ Customer credit limit

- Each entity (Branch operation or warehouse) can operate on standalone basis during the day.

- Transfers to other locations are done and the system retains a copy of the transfer details to be sent for the location concerned.

- At end of day all the outlets call the Head Office system for automatic transfer of all daily movements to the central system.
The data transfer is done in Database to Database mode to ensure data integrity. If the line fails the database automatically rolls back and restarts the operation without user intervention.

- Once all the branch data has been pulled in then the Central system prepares data to be sent to the individual Branches namely New items, prices… and the copy of the transfer vouchers they are receiving. The Branches are then called (usually the next morning) and all the relevant data transmitted for updating.

- At the branches the users update their system data and open the transfer vouchers and confirms them. In case of actual receipt discrepancy they are not allowed to change the transfer but instead put the actual quantity received and the system generates a return voucher with the difference.

- The above procedures with associated control reports provide for a very secure system for maintaining the Branch operations. At the same time the Head Office retains a full copy of all the branch operations and the reporting and analysis needed.

THE REPORTS
1. Daily sales summary by department
2. Daily cash summary by currency
3. Detailed sales summary by item
4. Items reaching zero stock
5. Items with negative stock (exceptions)
6. Daily Receipts from and transfers
7. Audit file for dispatch to central
8. Update of items and for prices


INVOICING AND ACCOUNTS RECEIVABLE REPORTS

- INVOICES ISSUED (PREPRINTED) ARABIC OR ENGLISH).
- LIST OF CUSTOMERS BY AREA OR SALESMAN
- LIST OF CUSTOMERS (NUMERICAL ORDER/ALPHA ORDER)
- PRICE LIST
- DISCOUNTS SCHEDULE
- DAILY LIST OF INVOICES
- DAILY LIST OF INVOICES BY SALESMAN
- MONTHLY LIST OF INVOICES
- DAILY SALES AND COLLECTIONS SUMMARY
- DAILY JOURNAL OF MOVEMENTS ( Interface to General Accounts)
- CUSTOMER STATEMENT OF ACCOUNT ON SCREEN
     or ON REGULAR PAPER
     or ON PRE-PRINTED FORMS
- AGING OF CUSTOMER ACCOUNTS RECEIVABLE
- SALES COMMISSION BY SALESMAN
- SALES COMMISSION SUMMARY










STOCK CONTROL SYSTEM

The Stock Control System is highly modular with very flexible file structure. The system has the following features :

1 - Multiple warehouse, multiple location possibilities with item number of up to 25 alphanumeric digits long and no limit on the number of stock items.

2 - Item Grouping can be done by several criteria (family, group, color, supplier, country of origin etc…).

3 - Price changes in % or amount by item or Family or Range of items

4 - The system is linked with the Purchase Order handling system which keeps track of pending orders from the time they are placed until they are received in stock.

5 - Maintains Historical data over several years to assist the management in the analysis of fast/slow moving items and pricing margins, profitability of products and to determine demand trends.

6 - Periodic and year end Inventory taking cycle with automatic adjustment of stock quantities and accounting movements.

7 - Rollback of computations to recompute average prices of issues. This is needed to handle situations where final prices of landed goods are known after receipt and issue of goods.

8 - Stock inquiry can be done over all the warehouses and locations.

9 - The master file structure has in it such relevant fields :
- Item description in English and Arabic
- Supplier No.
- Original supplier reference No.
- Min/max quantities and reorder level
- Order units/issue units
- ABC classification
- Last issue date
- Last receipt date
- Last cost prices : FOB or landed (original currency)
- Selling prices (wholesale, retail)
- Discount codes
- Sales Commission Codes
- Monthly and year-to-date summary data on :
- Receipts (Qty, Value)
- Issues (Qty, Value)
- Returns, Adjustments, Transfers

STOCK SYSTEM REPORTS

- MATERIAL RECEIPTS ISSUES AND OTHER MOVEMENTS
- STOCK INDEX
- DETAILED STOCK MOVEMENTS STATEMENT (KARDEX)
- STOCK MOVEMENT SUMMARY : MONTHLY
- STOCK MOVEMENT SUMMARY : YEAR-TO-DATE
- STOCK INVENTORY
- ITEMS TO BE REORDERED
- NON MOVED ITEMS
- DETAILED ISSUES (SALES & RETURNS)
- DETAILED RECEIPTS
- INTER WAREHOUSE TRANSFERS
- ISSUES SUMMARY
- LIST OF FREE OF CHARGE ITEMS

SALES ANALYSIS REPORTING

- Item sales history for 1 year
- Sales analysis by item (company total)
- Sales analysis by area and item
- Gross profit analysis by item (ranked)
- Gross profit analysis by customer
- Sales performance appraisal by salesman
- Year to date customer ranking by total purchase
- Detailed purchases by customer & item

SALES STATISTICS REPORTING (OPTIONAL)

This year sales compared to last year - by Area & Item
" " " " " " " " " - by Item - Company Total
" " " " " " " " " - by Area & Product Line
" " " " " " " " " - Product Line
" " " " " " " " " - Company Total
" " " " " " " " " - Area & Product Line
" " " " " " " " " - Area - Co. Total Summary

This year sales compared to budget - by Area & Item
" " " " " " " " " - by Item - Company Total
" " " " " " " " " - by Area & Product Line
" " " " " " " " " - Product Line
" " " " " " " " " - Company Total
" " " " " " " " " - Area & Product Line
" " " " " " " " " - Area - Co. Total Summary

Sales performance appraisal (all sales force)

Year-to-date sales by trade and section

Monthly sales by trade and section






















 

 

 

Copyright © 2001 by COMPUTEC Ltd - All rights reserved - Site creation