HiFinance
5
SECTION
1.5.4.6 - VOID SHOPPER DOCKETS
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:
RECEIPT_NUMBER,DOCKET_NUMBER,SITE_NUMBER,REDEMPTION_DATE,BRAND,DISCOUNT_LITRES,DISCOUNT_VALUE,WILL_PAY_VALUE
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.
