System overview:
The main modules supported by this system are:
- Financial management
- Human Resource & Payroll capable of handling casuals, seasonal ,permanent and contract employees
- Milling Module
- Marketing module
|
System Capabilities
- Registration of Producers/Growers
- Registration of Certification Bodies
- Registration of Marketing Agents
- Registration of County Councils
- Booking of coffee Delivery
- Recording of Deliveries
- Quality Check/Testing
- Recording of the quantities delivered
- Pre-milling Quality tests
| - Milling Instructions
- Parchment Bulking
- Recording of Milling Inputs
- Recording of Milling Outputs
- Calculation of Milling Charges and Billing
- Clean Coffee Bulking
- Dispatch/Transport to warehouse Instructions
- Pre-financing:Loan Applications on Deliveries
|
The system is also capable of producing the following reports
- Agreements with the Growers/Producers
- Receipt of coffee Stocks
- Generation of Weekly Coffee catalogue
- Setting of Floor Prices
- Sales Invoicing
- Calculation of Statutory deductions
| - Loan Recoveries
- Third Party payments
- Raising of Marketing Charges
- Allocation
- Stock reports (un-milled and clean coffee)
- Recording of Auction Results
|
Technology Supported
- It Runs on Relational Database Management System preferably MS SQL, Oracle, Sybase, or DB2
- Preferentially runs Microsoft server platform latter than 2000Server -Support XML and XHTML
- Import and export data with MS Excel
- Ability output report on MS word, Excel
- Ability to email reports directly using MS outlook
- Ability to integrate with light weight database and synchronize remotely VIA PDA
- Ability to scale in database size to store data for 5 years
- Ability to dynamically link to a website
|
