HiFinance 5




USAGE: To import a file containing a list of Shopper Dockets that need to be voided. This is usually the result of a doubling up of entries or a set of dockets that should not have been accepted at the site, but were either not set correctly in HiFinance or the POS did not reject correctly.


DISCUSSION: Make sure that you have a good backup of your data and that no-one is using HiFinance during the update. HiFinance may not update the files as you expected and the only completely safe way to correct the mistake is to restore your data from backup.


The import file required must be called sdoctf.csv, although case is not important in Windows. This file must reside in your data directory, eg \HF5DATA\COMP1. Also, the file must not be in use. This is important because if you have created the file from a spreadsheet and have saved it but not closed it, the file will still be locked by the spreadsheet program and HiFinance will not be able to open it.


The input file must be in CSV format. This is a comma-delimited file (without quotes) with one record per line. Exporting from Excel, choosing the CVS format, will produce the correct format automatically. Each alphanumeric field must be left justified. HiFinance will make no attempt to remove leading spaces (for names, etc.). Numeric fields should not have any dollar signs or commas. Do not use commas in any alpha fields. These will be treated as a field break and HiFinance will not import the row correctly. A blank cell will be treated as a valid entry, thus a blank alpha cell will clear the corresponding field in the master-file and a blank numeric cell will reset the corresponding field in the master-file to zero. Thus if you do not wish to change a field delete the row


The first line of the input file must contain the line:




There is no requirement for a trailer line.


HiFinance will then read import, lines one at a time, confirming firstly that the first three columns actually match a transaction. If so, the program will set the transition type to void, the paid-EFT to cancelled, the billed-eft to cancelled and it will add a note to the effect that the transaction has been voided. If an invalid or blank row is encountered, the process will stop. You will need to fix the file and re-import it. Finally the import file will be renamed to sdoctf.old (to stop you from accidentally rerunning the program with used data) before returning you the MAIN MENU.

Description: Description: Description: Return to Table of Contents  Return to Table of Contents