SECTION 18.104.22.168U.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:
Merchant Street Line 1
Merchant Street Line 2
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.