Question

PSEUDO CODE - Just need a general idea

Our department is in need of a report containing the invoices that have not been paid for the current period. With pseudo code, write a program that has the needed functionalities. Assume that the files given to you are two indexed files, which have the following information:

File 1: Contains customer information, such as Account number, Name, Business address, remaining balance.

File 2: Invoice information, such as Account number, Invoice number, inv. date, inv total, payment total and payment date.

The Output should be printed to a new file.

Answer 1

It is better to have a sorted file 2 to easily access invoices for a current period after getting to the start date in that file and then accessing simultaneous records in that file up till the end data.

Hence, if File 2 is not sorted, then sort File 2 first according to inv. date

Design code to get the input of the period for which the report has to be generated through either command line arguments or by normal input as per the programming language chosen.

Then iterate to the record in file2 from which the current period starts.

And for every record, find the value of inv total - payment total.

If it is greater than 0, add corresponding columns of the record(according to your requirement for the report into a list)

Do the above process for all the records in that file until the end period reaches.

If you want the customer information also to be printed in the report, then for every row in the list, get the customer information using account number and finding that customer information from file1 and store into the list.

Finally, output the stored list into a new file created earlier or create program in such a way that it generates filename according to the program running time so that a new file with report generated date and time will be generated whenever you run the program and it will be easier to access the report at a later time.