INTRODUCTION

Millennium Software is developing a fully modular integrated ERP (Enterprise Resource Planning) system for industries who are interested in acquiring cost effective state-of-the-art solutions for their operations.In fact some of the modules have been computed and successfully implemented.

SYSTEM ARCHITECT

The package being developed using open platform state-of-the-art technology. It is based on open standards, thereby protecting the company’s investment into the future and meeting the challenges of the 21^st Century.

The development tool is Oracle Developer/2000, using full function GUI, utilizing Client / Server technique with Oracle as the database engine, running on Windows NT server, as this is the trend for the future.

The regional offices will have a similar application running as stand alone with a facility to down-loading their daily activity at the Head Office server using dial-up facility, or they may opt for WAN.

 

DESIGN CONCEPT

The major design objective of the system has been to provide the tailoring ability to suit the organizational needs without program modification. This is achieved through the use of a wide range of parameters. The parameter (control) tables govern many of the operations of the system.  These parameters are defined at various levels:

• System Level

• Module Level

• Transaction Level

REAL TIME PROCESSING

The system will perform all the business functions in real-time,which means that the information impacts the system from the moment it is input. As a result of this, on-line inquiries and reports reflect the latest position rather than that of the previous close of business. All information is held on-line giving users instant access to appropriate files and functions. This widely accepted approach enhances staff productivity and customer service, while also ensuring that management decision-making is based on the most up-to-date information available.

MODULAR INTERGRATION

The system consists of various modules, each module covering the entire functionality within its defined application. This provides a phased implementation approach where the customer can have the option of choosing one module for implementation and then the others based on its requirements and priority. All the modules are fully integrated and they have consistent user interface to improve efficiency, minimize learning time, and prevent duplication of effort.
  

FULL FUNCTION GUI

In order to make the application easy to use and productive for the end users, all the screen interfaces have full function GUI. The dialogue boxes and pop-up windows provide a powerful memory resident user aid, which makes the end-users more efficient and productive. Relevant information is accessed directly from one screen, thus saving time. This greatly reduces input documents as the business activity is actually carried out on the system by the user at the initiation of any activity.

 

TEST  ENVIRONMENT

The application will be capable of providing a test environment in parallel to the production environment, so that the management can test new or modified functions without the fear of damage to live data.

This feature enables Personnel Manager to simulate situations for testing increment impacts off-line from the live system. It also allows new products that the company might wish to introduce, to be tried, tested and refined prior to their launch in the market place. The major benefit of the test environment lies in its extensive use during training.

Relational Database

This system uses an industry standard Relational Database Management System. The RDBMS enables easy access and manipulation of data and provides excellent data security and integrity. It also allows for unlimited growth of database and flexibility. It will offers numerous choice of industry standard relational database management systems e.g. DB2, Informix, Sybase, etc.

CLIENT/SERVER

The system is based on client/server design. This design allows presentation logic to be executed on the client workstation where as the business logic and database resides on the server. Client/server design provides seamless connection to various choices of servers and host platforms. This allows horizontal and vertical growth of the organisation platform and ensures upgradation to various technologies available now and in the future. Lastly the client/server design ensures the implementation of single and multiple offices automation solution.

APPLICATIONS

The following areas of activities is presently being covered in this ERP system:                             

Module	Features & Functionality
Personnel
	Personal Information Leave Record Management Loan Management Medical Management Provident Fund Information Training & Courses Recruitment End of Service Management
Pay Roll
	Computation of Salary: Management Employees Daily Wage Staff Preparation of Salary Salary Disbursement Computation of Provident Fun Computation of Taxes Produce: Salary Register Pay Slip
Inventory Management
	Log Maintenance Raw Materials Management Finished Products Monitoring movements Report excess / shortage Provide Inventory carrying cost Store Management Security Management
Distribution/Logistics
	Transport Management Own Vehicles Transporters Database Labour (Loaders) Delivery Schedule Management Claims Management Goods In Transit
Sales & Marketing
	Maintain Customers Database Annual Sales Target Projection Distribution Planning Order Management Marketing Advertisement & Publicity Promotional Campaigns Recipe Competition Give away Pricing
Procurement & Purchases
	Imports  Banking LC Management Indentors / Exporters Database Claims Management Terminal Wharfage Local Purchases
Production
	Shift Management Material Management Process Control Time Management Production Details
Engineering
	Maintenance of Plant Safety Parts Management
Quality Assurance
	Sample Management Complaint Management Internal Auditing
Financial
	General / Subsidiary Ledger Receivable Payable Consolidation Fixed Asset Accounting Budgetary Control Management Costing
Core Module
	System Set-up General Ledger Security Users System Query Management Reports & Statements MIS Back Office
Administration
	Vehicle Management Lease Maintenance
Import/Export
	Maintain LC/Bills Information Generate Accounting entries Provide Foreign Currency Transactions Bank Reconciliation