Documentation >
MAC-PAC Technical Library >
Financial >
Accounts Receivable >
Programs >
Corporate Customer Credit Report - Purpose
Corporate Customer Credit Report - Purpose
AR330P
The Corporate Customer Credit Report program (AR330P) prints the Corporate Customer Credit report (AR330A). It first reads the input parameters to determine whether the user requested the report for all customers or a single customer, and whether the report is generated at a detail or summary level. For each corporate customer to be included, the program determines all subsidiary customers associated with the corporate customer, retrieves balances for then from the Customer Master file (ARCUSL22), and accumulates corporate totals for A/R balance, on-account amount, past due balance, current due, amount over A/R limit, on-reserve balance, on-order balance, pending invoice amount, not due drafts, total commitment, and amount over credit limit. The following calculations are used:
Over Credit Limit
|
equals
|
Total Commitment
|
minus
|
Credit Limit
|
A/R Days Over Limit
|
equals
|
Oldest Open Invoice
|
minus
|
A/R Days Overdue Limit
|
Total Commitment equals
Accounts Receivable Balance
|
plus
|
On-Order Amount
or
On-Reserve Amount
|
plus
|
Pending Invoice Balance
|
plus
|
Not Due Drafts
|
minus
|
On-Account Amount
|
The On-Order Amount or On-Reserve Amount is used, depending on the value on Reference File category 029.
The A/R days past due is calculated by determining the oldest open invoice from the Open Item file (AROPENL9).
If corporate credit checking is used, the days over limit for each subsidiary customer is calculated using the corporate customer's A/R Days limit. If corporate credit checking is not used, the days over limit is calculated using the subsidiary customer's limit. All other totals for the subsidiary customers are calculated based on the credit limits defined for the subsidiary, regardless of whether corporate credit checking is used.
The corporate customer totals amounts over limit are calculated as:
· If corporate credit checking is used for the corporate customer, then the total commitment and A/R balance are calculated for all customers. These totals are then compared to the corporate company's credit limit.
· If corporate credit checking is not used for the corporate customer, then the A/R amount over limit and amount over credit limit are calculated for each customer, based on that customer's credit limit. The amounts over are then summed to provide the corporate amounts.
If the detail report was requested, the customer totals and credit information are printed for each subsidiary and for the corporate customer as a whole. If the summary report was requested, only the corporate totals are printed.