Our LPG client has contracted us to write a new application to replace and enhance the MS Excel solution we have developed over the past several years for them.
The application will replicate all of the processes in the current MS Excel solution including
- Importing third party deliveries customers.
- Creating invoices for the above deliveries and interfacing them into MYOB for accounting and publication of the invoice.
- Calculating billing rates based on volume and payment history.
- Updating customer MYOB records to reflect current billing rates.
Enhancements to the system will include maintaining a datastore of historical records for the above, along with enhanced customer information including
- multiple locations of LPG tanks.
- Size of LPG tanks.
- Inspection dates for LPG tanks.
- Leasing details of LPG tanks for customers.
- Invoicing of LPG tanks periodically.
- Grouping of customers for possible group discounts.
- Tracking of LPG usage and scheduling probable next delivery dates based on average usage.
- Entry of direct delivery LPG and invoicing of same
- Creation and maintenance of customers and interfacing same to MYOB
The application will be written in C++ and utilise a SQLite database for the datastore. SQLite was chosen due to its portability and it’s zero based maintenance.