HiFinance
5
SECTION 1.5.3.1U.3 - LAST
ODOMETER READING ASCII EXPORT
USAGE: This function will not appear
unless you are using the Cards option. This is a special ASCII export that is
used to create a file for corporates detailing which
cards are still active. The export is of a fixed nature and therefore there are
no ASCII options. The export is used for specific Customers who wish to have a
report of the last odometer reading, as a specific date. This is presumably used
for their internal accounting.
DISCUSSION: When you choose this function, HiFinance will ask
you to enter the parameters for the search pattern.
FOR ACCOUNT CODE The report is only deigned to export for one customer at a
time. Here you enter the Debtor code specifically relating to the account, ie the 6 character code.
TRANSACTION DATE RANGE Here you enter the lowest and highest dates you wish HiFinance to
scan for.
When you have entered all the above information,
press <F10> and you will be asked START FILE CREATION? If you answer N, the
program will reset and return you to the DEBTOR
ASCII EXPORT MENU. If you enter Y, the screen will clear and
the Debtor transaction-file will be read in. The program will find the last transaction
(within the range) that has an odometer reading. This is the value that will reported on.
Like other reports, it is possible to stop the
export of the ASCII file by pressing <ESC>. However, the ASCII file
will have been created up to the point where you stopped it.
When the report has completed, HiFinance will return
you to the DEBTOR/CARDS ASCII EXPORT
MENU.
The file will always export as sales-extract-<DEBTOR CODE>.txt in
the data directory. The file is TAB delimited, ie it
is not a CSV file. Each row will contain the following columns:
Account No
Card No
Record Type
Vehicle Rego
Odometer
Transaction Date
Litres
Amount
GST Amount
Net Amount
Cost Centre
Product Code
Voucher
Reference
Billed Date
Brand Description
Driver Name
Merchant No
ABN Number
BRN Number
Merchant Name
Merchant Street Line 1
Merchant Street Line 2
Merchant Suburb
Merchant State
Merchant Postcode
Card Description
Product Name
Unit Price
Estimated Quantity
Note that the calculation for Estimated Quantity is computed on a per-line fashion. The actual EOM calculation is not quite the same. This is function of round-off errors and cannot be corrected. Thus the value is an estimate.
