Completed a modification to a MSĀ® Excel workbook that we first put into production over five years ago for a client, David Walsh Gas Pty Ltd. The modification was to add another supplier to the two suppliers already being processed through the workbook.
The workbook performs the following tasks.
- Imports supplier delivery details (in the form of a csv file or Excel workbook) into the workbook.
- Create invoices for MYOB, with individual invoice lines for each delivery, product type.
- Import invoices to MYOB via the MYOB ODBC driver.
- Set the invoice delivery flag in MYOB to the customers default invoice delivery method (post or email).
- Produce an exception list for those customers from the supplier delivery sheet that are not found within the MYOB data file.
In addition to this invoice processing procedure, the workbook also performs the following tasks on an ad-hoc basis.
- Processes fixed price adjustments.
- Processes volume price adjustments.
These two price adjustments update individual customer charge rates for particular products based on the quantity supplied to date and a defined calculation (including allowance for the number of days it takes for a customer to pay their bills) for which the parameters are contained on a sheet in the workbook, so that they can be easily updated by the end user.
- Sales Analysis by Customer.
- Inactive Customer listing showing their last billing rate.