Program Purpose: The Payroll Department of your company requires a reconciliation paper report that should check all customer records for payment accuracy. Each customer is sent a statement and returns this statement along with their payment each month. The Data Entry Operator keys these payments into the online payment system for the appropriate customer. After the daily input, one of the batch jobs that runs each night, add these entries to a monthly Customer Payment Status file. This file will be your major input file. Inputs: 1. Customer Payment Status file. 2. Customer file Output: A paper report called: “Customer Payment Status Report??. Processing: Both files have the Customer Number for their primary key. They are therefore sorted by the Customer Number. Both files should be read simultaneously. The program should then check the amount of the statement against the amount of the payment made by the customer, and print one of the following messages in the PAYMENT STATUS field: 1. “PAYMENT CORRECT?? (if amount of statement = payment) 2. “PAYMENT INSUFFICIENT?? (if amount of statement > payment) 3. “CREDIT DUE?? (if amount of statement < payment) Then the program should check the date the payment was due against the date the payment was received, and print one of the following messages in the DATE STATUS field: 1. “PAYMENT EARLY?? (if payment is received prior to due date) 2. “PAYMENT ON TIME?? (if payment is received on the due date) 3. “PAYMENT LATE?? (if payment is received after the due date)
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. 4. Should work in a AS400 environment.
## Platform
Should work in a AS400 environment.