Documentation >
MAC-PAC Technical Library >
Financial >
Accounts Receivable >
Programs >
Customer Statements Print - Purpose >
Customer Statements Print - Calculations
Customer Statements Print - Calculations
AR370P
A. Mainline
1. Date Format Record
This Reference File record (category 049) contains the date format indicator. If this record is not found, a message is sent to the system operator, the format defaults to MMDDYY, and processing continues.
2. Defaults Record
This Reference File record (category 300) contains the accounts receivable default code to be used when writing the open item header record for a finance charge if the accounts receivable code does not exist on the customer master record.
3. Account Number Record
This Reference File record (category 302) contains the account number used when writing a finance charge to the open item header and distribution records.
4. Systems Option Record
This Reference File record (category 133) contains the single/multiple currency option and currency level.
5. Finance Charge Information Record
This Reference File record (category 309) contains the finance charge rate, the finance charge grace period, and a finance charge description. In addition, a special non-user-maintainable field has been set up to hold a six-digit field that is retrieved and used to format the document number for each finance charge written to the Open Item file. The field is then incremented by one and the Reference File record is updated.
6. Dunning Messages Record
This Reference File record (category 322) contains the nine levels of dunning messages used on the Customer Statement reports.
7. Document Type Defaults Record
This Reference File record (category 328) contains the document type default codes for the finance charge document type. Reference File category 329 validates the document types entered.
8. Report Options Record
This Reference File record (category P43) contains four indicators to specify whether statements for customers with a zero or negative balance should be printed, whether cash sales should be printed on the statements, and whether future invoices should be printed.
9. Aging Periods Record
This Reference File record (category P44) contains the classify into aging periods indicator, the last day of period 1, the last day of period 2, the last day of period 3, the earliest day a receivable is still considered current, and the first aging period considered to be overdue. If the classify into aging periods indicator is set to yes (Y), the delimiters between periods are used to determine the aging period into which each receivable should be accumulated. If the classify into aging periods indicator is set to no (N), all receivables are considered current. The first aging period considered overdue is used to calculate the value of all receivables overdue.
10. Country Codes Record
This Reference File record (category 007) contains the country code names to be used when printing a customer's country. A country name is only printed when a customer's address includes a country code.
11. Credit Manager Record
This Reference File record (category 313) contains the Credit Manager names used when printing the Control report.
12. Default Book Code Record
This Reference File record (category 135) contains the default book code to be used for this program.
13. Name and Address Record
The name and address record is read once for each customer master record on the Customer Master by Credit Manager file that is not bypassed. The customer's name and address are retrieved and listed on the Customer Statement report. If the customer name does not exist, "Customer name not found" will be printed.
14. Customer Master Record
The customer master record is read sequentially by credit manager and statement cycle. If the customer satisfies all credit manager, statement cycle, and customer balance due (accounts receivable balance less on-account balance) restrictions, processing continues. Otherwise the record is bypassed, and the next customer master record is read.
The statement type flag (CMSTMF) determines whether each customer should be processed for a balance forward basis report or for an open item basis report. If neither report is specified, the open item basis report is the default.
The customer single/multiple currency flag (CMSMDP) determines whether the customer operates in one or many currencies. If the customer is multiple currency, only open item-based reports are allowed.
If the parameter-specified aging as of date is not equal to the customer's last aging date, the aging subroutine is performed. This subroutine ages all open item headers by accumulating their open amounts into the appropriate customer level aging accumulators. If the aging dates are equal, the customer level accumulators are incremented by examining the age period on the open item and then incrementing the appropriate accumulator. If an open item for a finance charge is created during the execution of the Customer Statements Print program, its increment is accumulated into the current aging category. The customer master field is updated during this program to reflect the new aging amounts, the updated aging date, as well as other fields affected during execution of the Customer Statements Print program.
15. Open Items Header Record
All open item header records for each valid customer on the Customer Master by Credit Manager file are processed by Customer Statements Print. For balance forward basis customers, the printed on statement flag is examined first. If it is set to yes (Y), this open item has been listed on a previous statement and should be bypassed at this time. If the printed on statement flag is set to no (N), the most recent header flag is examined. For all headers that are not most recent, the increment amount is accumulated and the printed on statement flag is turned on. When the most recent header is found, the total header amount is rolled into the appropriate total accumulator (charge or credit). Depending on the nature of the header, the total amount is accumulated in the subject to finance charge array (if not a finance charge or cash sale). It is accumulated in the appropriate aging category and printed on the customer statement if the detail report option was selected. The printed on statement flag is then set to yes (Y), and the open item header record is updated.
16. Payment Header Record
For customers processed on a balance forward basis, payment headers are retrieved for each customer after all open items have been processed. Like open items, if the payment headers printed on statement flag is set to yes (Y), the payment header is bypassed. If the payment header is not the most recent header, its increment amount is added to an accumulator and the printed on statement flag is set to yes (Y). When the most recent header is processed, if the detail report option has been chosen, the total header amount is printed along with a separate output line for discounts and write-offs if these amounts are positive. For the summary version balance forward basis report, all payment amounts, discounts, and write-offs for every payment header for a customer are accumulated into a single total credits accumulator which is printed on the customer statement.
17. Payment Application Records
For customers processed on an open item basis using the detail report option, all payment applications for a given open item are read and printed after the open item header amount. If the application includes a discount or write-off, these amounts will also be listed. For the summary version of the open item basis report, no payment applications are read or processed because the open amount is printed from the open item header, and the application amount has already been applied to the open amount.
18. Controls
After all aging has been performed and any new finance charges have been created and aged, a redistributed totals check is made to verify that the sum of the re-aged open item receivables equals the accounts receivable balance on the Customer Master by Credit Manager file. If these two amounts are not equal, a terminal error occurs, and program execution is halted.
19. Installed Applications
This Reference File record (category 012) contains a listing of modules installed.
20. Payment Type
This Reference File record (category 344) contains all valid payment type codes.