Distribution Management System – Fuel
DMS5 is a sophisticated, yet user-friendly software package specifically designed to automate all aspects of business operations for: Bulk Fuel/Petroleum Products Distribution.
DMS5 will run on a variety of Technologies.
DMS5 is fully integrates with Accounting and Decision Support applications that are leaders in sophistication and flexibility.
DMS5 is an integrated and comprehensive set of applications aimed at helping oil distribution industry clients to efficiently handle customer order processing, billing, purchase order processing, inventory management and accounting. The system helps improve cash flow through links with accounts receivable, reduce the overall investment in inventory and improve productivity in customer and purchase order processing. This can result in increased sales, increased customer service levels, and overall improvement in business reporting and management control. Using DMS5, distributors can facilitate the monitoring of important aspects of their operations and draw upon timely, accurate data necessary for making critical business decisions.
SYSTEM FEATURES
Order Processing and Billing
Sales orders are interactively entered, edited, and maintained. System built-in functions include order inquiry and inventory control.
Invoice Processing is performed interactively and allows for Point-of-Sale type operation.
The System allows for pre and post delivery orders and accounts for gravity and temperature volume corrections, according with established international tables.
Automated pricing and costing facility
Allows for unlimited products and possible interface to point of sale devices
Reports Produced
Daily Order Verification Report
Daily Invoice Register Report
Inventory Transaction Batch Edit
Bulk Reconciliation
Month-to-date Invoice Summary Report
Dealer Allowance Report
Excise Tax Report
Monthly Return of Liquid Fuel Tax
Summary of Exemptions and Deductions
INVENTORY MANAGEMENT SYSTEM
DMS5 is fully integrated with DSR’s Inventory Management System, a cell structured database management system developed as a specialised tool for inventory management purposes. IMS provides an enormous level of flexibility on both the overall data management and inventory reporting by giving the user the ability to expand the system capabilities and respond to unforeseen requirements without costly programming.
IMS FEATURES
Unlimited product types (Fuel and Hard Goods)
Real-time inventory allocation/de-allocation, availability checking, product and product pricing information maintenance and online inquiry into product activities, are among the functions of the system.
Allows for the definition of input transaction formats and “posting” instructions by end-users, without the need for programming.
Allows for the definition of up to 99 report formats containing up to 13 columns of information that can be selected from the IMS database reflecting activity for a selected month or year.
Allows for the definition of mathematical computation formulas.
Allows for the definition of transaction formats that use the IMS database as both input and outputs therefore giving the authorised user the ability to perform system maintenance without conventional programming.
Allows for multiple closings of a given inventory month or year.
DSSI – DECISION SUPPORT SYSTEM
DSSI is a cell structure Data Warehouse and Analysis System designed to allow for the tracking of historic information and provide management with Advanced Decision Support capability for strategic areas and to extend the Sales Analysis capabilities of DMS5 to a virtually unlimited level.
DMS5 contains the automatic interfaces required to maintain a Sales Analysis Database within DSS-I to reflect all “ACTUAL” sales and cost activity. Users may define hundreds of statistical reports by defining data extraction and report layout instructions without conventional programming. In addition to having access to the “ACTUAL” histories, users can also define and maintain parallel databases containing sales forecasts at multiple levels (area, salesperson, products etc.) and integrate this information to produce statistical reports to monitor sales performance, at a more sophisticated level. Reports can be produced at multiple levels of consolidation, with unlimited key selections (customer, products etc.) and can contain up to 20 columns of extracted or computed information.
Optional Interfaces to Following Sub-Systems: