106 Credit and Collections Management Processing Options

This chapter contains these topics:

Section 106.1, "Credit Analysis Refresh (P03525)"
Section 106.2, "Account Status Summary (P03203)"
Section 106.3, "Credit Granting and Management (P0305)"
Section 106.4, "Address Book Credit Management/Granting Z File (P0305Z)"
Section 106.5, "Credit Reporting Tape - TRW/Dun & Bradstreet (P03920)"
Section 106.6, "Credit Reporting Tape - CREDITEL (P03920C)"
Section 106.7, "Collections Manager (P03218)"
Section 106.8, "Customer Payment History (P03204)"
Section 106.9, "Activity Log (P0331)"
Section 106.10, "Calculate High Balance (P03526)"
Section 106.11, "Outstanding Credit/Collection Items (P03440)"
Section 106.12, "A/R Summary Report (P03413)"
Section 106.13, "Print Promises, Promises (P013151)"

106.1 Credit Analysis Refresh (P03525)

Processing Option	Processing Options Requiring Further Description
AGING:
1. Enter a '1' to retrieve the aging specifications from A/R Company Constants. (Default of blank will use the processing options for aging.) Note: If selected, all other aging processing options will be ignored.
AGING "AS OF" DATE:
2. Enter the "as of" Date to age open balances. (If left blank, the current date is used as the default.) Note: If Company Constants aging is requested, this date will only update the Credit Management "As of" date data area (AR0315), and will NOT be used for aging.
AGING (Cont'd):
3. Specify one of the following dates to age accounts from: D = Due Date I = Invoice Date G = General Ledger Date S = Statement Date (If left blank, "D" is the default.)
4. Specify one of the following methods for aging calculations: 1 = Aging Days 2 = Fiscal Periods 3 = Calendar (If left blank, "1" is the default.)
5. Enter the following aging category information: Aging days: Beginning thru . . . Thru . . . Thru . . . Thru . . . Thru . . . Thru . . . Thru . . .
TEMPORARY CREDIT MESSAGES:
6. If using Temporary Credit Messages, enter the aging category at which an open amount is considered late and should be flagged with the Temporary Credit Message entered below. Leaving this option BLANK means that nothing is considered late enough to flag the account with a Temporary Credit Message, and all accounts will have the Temporary Credit Message reset to be the same as the Credit Message (unless the reset function is bypassed using option 8, below).
7. Enter the Temporary Credit Message.
8. Enter a '1' to bypass the function that resets the Temporary Credit Message to be the same as the Credit Message. Blank means that the Temporary Credit Message will be changed to be the same as the Credit Message if the open amount is no longer overdue or if blank was entered in option 6 above. The temporary credit message is automatically reset to the permanent message if the open amount is no longer overdue.
DRAFT PROCESSING:
9. Indicate which drafts to include in the outstanding draft calculation: ' ' = Do not include drafts (Default) '1' = Include ALL unpaid drafts '2' = Include only drafts not due
CREDIT PROCESSING:
10. Specify one of the following for credits: ' ' = Age Credits (Default) '1' = Apply Credits to Current Column '2' = Apply Credits to oldest active Aging Column

106.2 Account Status Summary (P03203)

Processing Option	Processing Options Requiring Further Description
AGING:
1. Specify one of the following dates to age accounts from: D = Due Date I = Invoice Date G = General Ledger Date S = Statement Date (If left blank "D" is the default.)
2. Specify one of the following methods for aging calculations: 1 = Aging Days 2 = Fiscal Periods 3 = Calendar (If left blank, "1" is the default.)
3. Enter the following aging category information: Aging days: Beginning thru . . . thru . . . thru . . . thru . . . thru . . . thru . . . Thru . . .
4. Enter a '1' to retrieve the aging specifications from A/R Company Constants. (Default of blank will use the processing options for aging.) Note: If selected, all other aging processing options will be ignored.
5. Enter a '1' to process aging in the "Real Time" mode. (If left blank "As of" is the default.)
CREDIT PROCESSING:
6. Specify one of the following for credits: ' '= Age Credits (Default) '1'= Apply Credits to Current Column '2'= Apply Credits to oldest active Aging Column. '3'= Separate Credits (Real Time Only)	This processing option allows you to specify how to view credit amounts. In addition to the options of how to age credit amounts, option 3 allows you to view all credit amounts as a separate total in the 'Real Time' mode.
DRAFT PROCESSING:
7. Indicate which drafts to include in the outstanding draft calculation: ' ' = Do not include drafts (Default) '1' = Include ALL unpaid drafts '2' = Include only drafts not due
CREDIT LIMIT:
8. Enter a 1 to display the Child credit limit. If left blank, the parent credit limit will be displayed.

106.3 Credit Granting and Management (P0305)

Processing Option	Processing Options Requiring Further Description
FIELD DISPLAY:
1. Enter a '1' to suppress the Credit Limit field. If left blank, the Credit Limit will appear on the screen.
Z-FILE PROCESSING:
2. Enter the character you will use to indicate you want the field cleared. If a value is entered, fields left blank will not be updated. If no value is entered, the entire record, all fields, will be processed and blank fields will be cleared.

106.4 Address Book Credit Management/Granting Z File (P0305Z)

Processing Option	Processing Options Requiring Further Description
DREAM WRITER VERSIONS:
1. Enter the version to be used to call Address Book Credit Mgmt (P0305). If left blank, ZJDE0001 will be used.
ERROR REPORTING:
2. Enter '1' to skip printing the error report. If left blanks, the report will print.
3. Enter the version to be used to call the error report program (P00ZERR). If left blank, ZJDE0001 will be used.

106.5 Credit Reporting Tape - TRW/Dun & Bradstreet (P03920)

Processing Option	Processing Options Requiring Further Description
SUBMITTING COMPANY INFORMATION:
1. Enter your 'Contributor' number.
2. Enter your 'Business Category' code.
'AS OF' DATE:
3. Enter the 'As Of' Date to be used as the A/R cutoff date.
CREDIT REPORT AMOUNTS:
4. Enter the code to be used for the printed amounts on credit reports. '0' = Actual amount to be displayed '1' = +100000 to be displayed on account balances over 100,000 '2' = +200000 to be displayed on account balances over 200,000 '3' = +300000 to be displayed on account balances over 300,000 '4' = +400000 to be displayed on account balances over 400,000 '5' = +500000 to be displayed on account balances over 500,000
TAPE CREATION OPTIONS:
5. Enter the tape device name to use (Default is TAP01).
6. Enter the Data File Library to use for the load of the F03920 file (Default is *LIBL).
CREDIT/CASH MANAGEMENT BUILD:
7. Enter a '1' to rebuild the temporary A/R Credit/Cash Management work file prior to generating the tape. Note: If you do not build the temporary work file, the existing Credit/Cash Management file will be used. If a '1' is entered, the Based On File must be F0315WJA.
8. Enter a '1' to rebuild the temporary A/R Credit/Cash Management work file with zero balance records. If left blank, records with an open amount of zero will not be included.
DATA OPTIONS
9. Enter a '1' to use the Mailing Name for the customer or parent. If left blank, the Alpha Name will be used.

106.6 Credit Reporting Tape - CREDITEL (P03920C)

Processing Option	Processing Options Requiring Further Description
SUBMITTING COMPANY INFORMATION:
1. Enter your CREDITEL membership number.
'AS OF' DATE:
2. Enter the 'As Of' Date to be used as the A/R cutoff date
TAPE CREATION OPTIONS:
3. Enter the tape device name to use (Default is TAP01).
4. Enter the Data File Library to use for the load of the F03920C file (Default is *LIBL).
CREDIT/CASH MANAGEMENT BUILD:
5. Enter a '1' to rebuild the temporary A/R Credit/Cash Management work file prior to creating the tape. Note: If you do not build the temporary work file, the existing Credit/Cash Management file will be used. If a '1' is entered, the Based On File must be F0315WJA.
6. Enter a '1' to rebuild the temporary A/R Credit/Cash Management work file with zero balance records. If left blank, records with an open amount of zero will not be included.
DATA OPTIONS
7. Enter the Phone Types to be used to retrieve the Customer phone number and fax number. For fax, if left blank or no fax number is found for that type, 'FAX' will be used. Phone Number Type Fax Number Type (Default=FAX)
8. Enter a '1' to use the Mailing Name for the customer or parent. If left blank, the Alpha Name will be used.

106.7 Collections Manager (P03218)

Processing Option	Processing Options Requiring Further Description
DEFAULT PROCESSING:
1. Enter the Aging Categories to be displayed on the screen. (If left blank the values will default from the Data Dictionary.) From Category Thru Category
2. Enter a "1" if the User ID is to be loaded into the Collections Manager field on the screen. (A default of blank will not load the User ID.)
MESSAGE TEXT VERSION:
3. Enter the DREAM Writer version of Message Text Entry to call. If left blank, ZJDE0002 will be used.
CREDIT GRANTING VERSION:
4. Enter the DREAM Writer version of Credit Granting and Management to call. If left blank, ZJDE0001 will be used.

106.8 Customer Payment History (P03204)

Processing Option

Processing Options Requiring Further Description

DREAM WRITER VERSIONS:

1. Enter the version for each program.

If left blank, ZJDE0001 will be used.

Name Search (P01200)

Customer Ledger Inquiry (P032002)

Account Status Summary (P03203)

106.9 Activity Log (P0331)

Processing Option	Processing Options Requiring Further Description
PRELOADED DATA SELECTIONS:
1. Any values entered into the following options will be loaded upon entry to the program: Activity ID Address Number Company Sequence FROM Tickler Date
DREAM WRITER VERSIONS:
2. Enter the version for each program. If left blank, ZJDE/XJDE0001 will be used. Customer Master Message View and Entry Account Status Summary Customer Ledger Inquiry

106.10 Calculate High Balance (P03526)

Processing Option	Processing Options Requiring Further Description
AS OF PROCESSING:
1. Enter a '1' if using the As Of processing method. Note: DREAM Writer Based-on file must be F0311A) This method uses the current F0311A file and last build date. If left blank, the F0311 file is used with the current system date.	Run Date File Generation (P03900) to build the F0311A. Caution: Changing methods of calculation can cause inaccurate results. Choose a method of calculation and run only that method.

Processing Option

Processing Options Requiring Further Description

AS OF PROCESSING:

1. Enter a '1' if using the As Of processing method.

Note: DREAM Writer Based-on file must be F0311A)

This method uses the current F0311A file and last build date.

If left blank, the F0311 file is used with the current system date.

Run Date File Generation (P03900) to build the F0311A.

Caution: Changing methods of calculation can cause inaccurate results. Choose a method of calculation and run only that method.

106.11 Outstanding Credit/Collection Items (P03440)

Processing Option	Processing Options Requiring Further Description
Enter an "As Of" date to include items which have not been worked. If left blank today's date will be used.

106.12 A/R Summary Report (P03413)

Processing Option	Processing Options Requiring Further Description
PRINT OPTIONS:
1. Specify one of the following print formats: ' ' = Standard 132 character format. (Default) '1' = Standard 132 character format with parent number. '2' = Long 198 character format. '3' = Long 198 character format with parent number. '4' = Long 198 character format with foreign currency aging.
AGING SPECIFICATIONS:
2. Enter a '1' to retrieve the aging specifications from Accounts Receivable Constants. Default of blank will use the processing options for aging.
"AS OF" DATE:
3. Enter the "As Of" date to age open balances. If left blank, the current date is used as the default.
ACCOUNT AGING DATE:
4. Specify one of the following dates to age accounts from: D = Due Date I = Invoice Date G = General Ledger Date S = Statement Date (If blank, 'D' is default)
AGING CALCULATIONS:
5. Specify one of the following methods for aging calculations: 1 = Aging Days (Default) 2 = Fiscal Periods 3 = Calendar
AGING CATEGORY INFORMATION:
6. Enter the following aging category information: (for method 1 only) Aging Days: Beginning . . . Thru . . . Thru . . . Thru . . . Thru . . .
CREDIT PROCESSING:
7. Specify one of the following for aging credits: ' ' = Apply Credits to Current Column (Default) '1' = Age Credits '2' = Apply Credits to oldest active Aging Column
"AS OF" DATE PROCESSING:
8. Enter a '1' to use the "As Of" date process. Note: DREAM Writer Based on File must be F0311A.
PROMISES, PROMISES INFORMATION:
9. Specify one of the following to print Promises, Promises: '1' = print 'P' message type '2' = print 'P' and 'F' messages '3' = print all message types If left blank, no Promises, Promises will be printed.
"FROM" TICKLER DATE:
10. Enter the "From" Tickler Date to print Promises, Promises information. If left blank, the current date will be used.
ROUNDING FACTOR:
11. Enter Rounding factor for Non-Aging: ' ' = no scaling (Default) '0' = round decimals only '1' = divide by 10 '2' = divide by 100 '3' = divide by 1000 '4' = divide by 10000 '5' = divide by 100000 '6' = divide by 1000000 Any value of 0 through 6 will round decimals to whole numbers. Amounts are divided using 4/5 rounding. Actual amounts are used to accumulate the total fields. This is for NON-AGING amounts.
ROUNDING FACTOR:
12. Enter Rounding factor for Aging: ' ' = no scaling '0' = round decimals only '1' = divide by 10 '2' = divide by 100 '3' = divide by 1000 '4' = divide by 10000 '5' = divide by 100000 '6' = divide by 1000000 Any value of 0 through 6 will round decimals to whole numbers. Amounts are divided using 4/5 rounding. Actual amounts are used to accumulate the total fields. This is for AGING amounts.
CATEGORY CODE:
13. Enter the category code number indicating which category code to print on the report. If left blank, no category code will print. (This pertains to the two short report formats only.)
CREDIT LIMIT:
14. Enter a '1' to print the credit limit for each customer listed on the report. If left blank, no credit limit will print.
DRAFTS:
15. Enter a '1' to print a separate draft amount on the report. If left blank, a separate draft amount will not be printed. (This pertains to the long format without parent number.)
SUMMARY PAGE:
16. Enter a '1' to print the company summary page at the end of the report. If left blank, no summary page will be printed.

106.13 Print Promises, Promises (P013151)

Processing Option	Processing Options Requiring Further Description
PPAT Message Printing Option:
1. Enter a '1' to print the first line of the PPAT message. Leave blank to print the complete message.