Small Visual Foxpro programming project

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

Habilidades: Visual Foxpro

Ver mais: what is visual programming, what is visual foxpro programming, what is in programming, visual Foxpro Programming, visual c++ programming, re audit, programming with foxpro, programming visual foxpro, programming in visual foxpro, programming in foxpro, original programming, in visual foxpro, $ in visual foxpro, credit into account, audit format, audit file, audit details, what is foxpro, balance sheet audit, foxpro, dbf, Bf, audit account, accounts and audit, account & audit

Acerca do Empregador:
( 8 comentários ) Hindmarsh, SA, Australia

ID do Projeto: #6816292

Premiar a:


Hi, I can do this job for you. Can create such program during 1 hour, since this type of job is very familiar to me. P.S. What version of Visual Foxpro you use (I prefer Visual Foxpro 9) ? Regards, programm Mais

$45 AUD em 1 dia
(8 Avaliações)