1. Select a period - Enter Start Date and Enter End Date (check that they are valid dates) (to be entered in dd/mm/yyyy format)
2. Create a new file based on the information in the c:\touch\data\accounts\[url removed, login to view] file (This new file will reside in same directory and be called Statements.dbf. If it already exists, clear all data in it and start again)
2.1 Sort the data in [url removed, login to view] into Account Number order then date order
2.2 Summarize all information prior to start date into one record per Account
2.2.1 Fields in new file to be as follows:
Account = Account from previous records
Transtype = "B"
Transdate = day before "Start Date"
Branch = Branch from previous records
Ref = BF-yyyymmdd
Details = "Balance Forward"
Debit = Total of Debits from previous records
Credit = Total of Credits from previous records
Outvalue = Total Debit - Total Credit
All other fields can be ''
2.3 Copy all records after and including start date and up to and including end date into the new file exactly as they are in the [url removed, login to view] file
The resulting file should have one summary record for each Account and then records duplicated from the [url removed, login to view] file that fall between start & end dates
If you check the attached excel spreadsheet, you'll see an example of what we're after. In this case, the orginal data is in sheet "Original" and the resultant summary data is in the sheet "Summary". The start date entered was 1/10/2014 and the end date entered was 31/10/2014. The Summary records created are those with transtype of "B"
[url removed, login to view] sample file is attached.
Any questions just reply back