107 A/R Reports Processing Options

This chapter contains these topics:

• Section 107.1, "A/R Summary Report (P03413)"

• Section 107.2, "A/R Detail Report (P034201)"

• Section 107.3, "A/R Currency Detail (P03429)"

• Section 107.4, "Receivable Summary by Pay Status (P03416)"

• Section 107.5, "Multi-Level Open A/R Summary by Parent (P03415)"

• Section 107.6, "Open A/R by Business Unit and Address (P03445)"

• Section 107.7, "A/R Detail Report (P034201)"

• Section 107.8, "A/R Unresolved Matters (P03601)"

• Section 107.9, "Problem Accounts Receivable (P036001)"

• Section 107.10, "Customer Totals by G/L Account (P09450)"

107.1 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.

107.2 A/R Detail Report (P034201)

Processing Option	Processing Options Requiring Further Description
PRINT OPTIONS:
1. Enter one of the following formats: ' ' = 132 characters; aging without G/L offset. (Default) '1' = 198 characters; 6 aging categories. '2' = 132 characters; discount, G/L offset, and remark. '3' = 132 characters; aging with G/L offset.
AGING SPECIFICATIONS:
2. If an aging report has been selected: Enter a '1' to retrieve the aging specifications from A/R Constants. Default of blank will use the processing options for aging. Note: Report MUST be sequenced and set to page break by company if company defaults are requested.
"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:
4. Specify one of the following dates to age accounts from: D = Due Date (Default) I = Invoice Date G = General Ledger Date S = Statement Date
AGING CALCULATIONS:
5. Specify one of the following methods for aging calculations: 1 = Aging Days (Default) 2 = Fiscal Periods 3 = Calendar
CATEGORY INFORMATION:
6. Enter the following aging category information: (for method "1" only) Aging Days: Beginning . . . Thru . . . Thru . . . Thru . . . Thru . . . Thru . . .
CREDIT PROCESSING:
7. Enter a '1' to age credits or a blank (default) to apply credits to the current column.
"AS OF" DATE PROCESSING:
8. Enter a '1' to use "As Of" date process. Note: DREAM Writer Based-On file must be F0311A.
PROMISES, PROMISES INFORMATION:
9. Enter one of the following: ' ' = No Messages print (Default) '1' = Print message type P '2' = Print message type P and F '3' = Print all messages
"FROM" TICKLER DATE:
10. Enter "From" Tickler Date to print Promises, Promises information. If left blank, the current date will be used.
CONTACT NAMES:
11. Enter a '1' to print contact names from the Who's Who file. If left blank, contact names will not be included on the report
ROUNDING FACTOR:
12. Enter desired rounding factor: ' ' = No rounding '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 from 0-6 will round the decimals to whole numbers. Amounts are divided using 4/5 rounding. Actual amounts are used to accumulate total fields.
DRAFTS:
13. Enter a '1' to print a separate draft amount on the report. If left blank, the draft column will not appear on the report. (This applies to all formats except long aging).
GENERIC TEXT:
14. Enter a '1' to print the generic text for pay items in a 40-character width, a '2' to print text in an 80-character width. If left blank, generic text will not be printed.
15. Enter a '1' to print only the summarized generic text, a '2' to print both the pay item generic text and the summarized generic text. If left blank, only pay item generic text will print.

107.3 A/R Currency Detail (P03429)

Processing Option	Processing Options Requiring Further Description
PRINT OPTIONS:
1. Enter one of the following print formats: ' ' = Foreign and Domestic information. (132 characters) '1' = Aging information. (132 characters) '2' = Foreign and Domestic with aging information. (Long, 198 characters)
AGING SPECIFICATIONS:
2. If an aging format has been selected: Enter a '1' to retrieve the aging specifications from A/R Constants. If left blank, the processing option values for aging will be used. Note: Report MUST be sequenced and set to page break by company if company defaults are requested.
"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:
4. Specify one of the following dates to age accounts from: D = Due Date (Default) I = Invoice Date G = G/L Date S = Statement Date
AGING CALCULATIONS:
5. Specify one of the following methods for aging calculations: 1 = Aging Days (Default) 2 = Fiscal Periods 3 = Calendar
CATEGORY INFORMATION:
6. Enter the following aging category information: (for method "1" only) Aging Days: Beginning . . . Thru . . . Thru . . . Thru . . .
CREDIT PROCESSING:
7. Enter a '1' to age credits amounts. If left blank (Default), credits will be applied to the current column.
"AS OF" PROCESSING:
8. Enter a '1' to use 'As Of' date process. Note: DREAM Writer Based on File must be F0311A.
COMMA SUPPRESSION:
9. Enter a '1' to suppress commas from the original, open, and discount amount columns, allowing these columns to display into the billions. If left blank (Default), commas will appear in these columns.
ROUNDING FACTOR:
10. Enter the desired rounding factor: ' ' = no rounding (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 Rounding will be to whole numbers. Actual amounts are used to accumulate totals.

107.4 Receivable Summary by Pay Status (P03416)

Processing Option	Processing Options Requiring Further Description
AGING SPECIFICATIONS:
1. Enter a '1' to retrieve the aging specifications from Accounts Receivable Constants. Default of blank will use the processing options for aging. Note: If selected, all other aging processing options will be ignored.
"AS OF" DATE:
2. Enter the "As Of" date to age open balances. If left blank, the current date is used as the default.
ACCOUNT AGING DATE:
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 blank, 'D' is default)
DRAFT PROCESSING:
4. Enter a '1' to age DRAFT amounts using the dates from the original invoice. Default of blank will perform aging using the draft dates.
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. Enter a '1' to age credits, a '2' to apply credits to the oldest balance, or a blank (default) to apply credits to the current column.
PROMISES, PROMISES INFORMATION:
8. Enter a '1' to print Promises, Promises information for each customer.
"FROM" TICKLER DATE:
9. Enter the "From" Tickler Date to print Promises, Promises information. If left blank, the current date will be used.

107.5 Multi-Level Open A/R Summary by Parent (P03415)

Processing Option	Processing Options Requiring Further Description
"AS OF" DATE:
1. Enter the "As Of" date to age open balances. If left blank, the current date is used as the default.
ACCOUNT AGING:
2. 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:
3. Specify one of the following methods for aging calculations: 1 = Aging Days (Default) 2 = Fiscal Periods 3 = Calendar
AGING CATEGORIES:
4. Enter the following aging category information: (for method 1 only) Aging Days: Beginning . . . Thru . . . Thru . . . Thru . . . Thru . . .
CREDIT PROCESSING:
5. Enter a '1' to age credits, a '2' to apply credits to the oldest balance, or a blank (default) to apply credits to the current column.
"AS OF" DATE PROCESSING:
6. Enter a '1' to use the "As Of" date process.
PROMISES, PROMISES INFORMATION:
7. Enter a '1' to print Promises, Promises information for each customer.
"FROM" TICKLER DATE:
8. Enter the "From" Tickler Date to Promises, Promises information. If left blank, the current date will be used.
LEVEL OF DETAIL:
9. Enter the lowest level of detail to be printed (i.e. '0' equals parent information only). Default of blanks will print all levels.
COMPANY:
10. Enter a company to process. Default of blank will process all companies.

107.6 Open A/R by Business Unit and Address (P03445)

Processing Option	Processing Options Requiring Further Description
PRINT FORMATS:
1. Enter one of the following print formats: ' ' = 132 characters, without aging. (Default) '1' = 132 characters, with aging. '2' = 198 characters, with foreign currency aging.
SUBHEADINGS:
2. Enter a '1' to have the report subheading appear with Business Unit first and Address second. If left blank, Address will be first and Business Unit will be second.
"AS OF" AGING:
3. Enter the "As Of" date to age open balances. If left blank, the current date is used as the default.
ACCOUNT AGING:
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 . . .
"AS OF" DATE PROCESSING:
7. Enter a '1' to use "As Of" date process. Note: DREAM Writer Based on File must be F0311A.
PROMISES, PROMISES INFORMATION:
8. Enter a '1' to print Promises, Promises information for each customer.
"FROM" TICKLER DATE:
9. Enter the "From" Tickler Date to print Promises, Promises information. If left blank, the current date will be used.
ROUNDING FACTOR:
10. Enter required rounding factor: ' ' = no rounding (Default) '0' = round decimals only '1' = divide by 10 '2' = divide by 100 '3' = divide by 1,000 '4' = divide by 10,000 '5' = divide by 100,000 '6' = divide by 1,000,000 Any value of 0 - 6 will round decimals to whole numbers. Amounts are divided using 4/5 rounding. Actual amounts are used to accumulate total fields.
RETAINAGE:
11. Enter a '1' to show retainage amounts in the fourth aging column. If left blank, the retainage column won't appear on the report. Note: A '1' will reduce domestic and foreign aging categories from four to three.
TOTAL MATCHING DOCUMENTS:
12. Enter a '1' to include matching document amounts in the Original total column on the report. If left blank, only original document amounts will be included.

107.7 A/R Detail Report (P034201)

Processing Option	Processing Options Requiring Further Description
PRINT OPTIONS:
1. Enter one of the following formats: ' ' = 132 characters; aging without G/L offset. (Default) '1' = 198 characters; 6 aging categories. '2' = 132 characters; discount, G/L offset, and remark. '3' = 132 characters; aging with G/L offset.
AGING SPECIFICATIONS:
2. If an aging report has been selected: Enter a '1' to retrieve the aging specifications from A/R Constants. Default of blank will use the processing options for aging. Note: Report MUST be sequenced and set to page break by company if company defaults are requested.
"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:
4. Specify one of the following dates to age accounts from: D = Due Date (Default) I = Invoice Date G = General Ledger Date S = Statement Date
AGING CALCULATIONS:
5. Specify one of the following methods for aging calculations: 1 = Aging Days (Default) 2 = Fiscal Periods 3 = Calendar
CATEGORY INFORMATION:
6. Enter the following aging category information: (for method "1" only) Aging Days: Beginning . . . Thru . . . Thru . . . Thru . . . Thru . . . Thru . . .
CREDIT PROCESSING:
7. Enter a '1' to age credits or a blank (default) to apply credits to the current column.
"AS OF" DATE PROCESSING:
8. Enter a '1' to use "As Of" date process. Note: DREAM Writer Based-On file must be F0311A.
PROMISES, PROMISES INFORMATION:
9. Enter one of the following: ' ' = No Messages print (Default) '1' = Print message type P '2' = Print message type P and F '3' = Print all messages
"FROM" TICKLER DATE:
10. Enter "From" Tickler Date to print Promises, Promises information. If left blank, the current date will be used.
CONTACT NAMES:
11. Enter a '1' to print contact names from the Who's Who file. If left blank, contact names will not be included on the report
ROUNDING FACTOR:
12. Enter desired rounding factor: ' ' = No rounding '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 from 0-6 will round the decimals to whole numbers. Amounts are divided using 4/5 rounding. Actual amounts are used to accumulate total fields.
DRAFTS:
13. Enter a '1' to print a separate draft amount on the report. If left blank, the draft column will not appear on the report. (This applies to all formats except long aging).
GENERIC TEXT:
14. Enter a '1' to print the generic text for pay items in a 40-character width, a '2' to print text in an 80-character width. If left blank, generic text will not be printed.
15. Enter a '1' to print only the summarized generic text, a '2' to print both the pay item generic text and the summarized generic text. If left blank, only pay item generic text will print.

107.8 A/R Unresolved Matters (P03601)

Processing Option	Processing Options Requiring Further Description
INVOICE SELECTIONS:
1. Enter one of the following choices for invoice selection: 1 = Partially Paid Invoices Only 2 = Problem Invoices Only 3 = All Invoices If left blank, only partially paid invoices will be printed.

107.9 Problem Accounts Receivable (P036001)

Processing Option	Processing Options Requiring Further Description
NUMBER OF ACCOUNTS ON REPORT:
1. Enter the number of problem accounts to be printed. The default will be 50.
"AS OF" DATE:
2. Enter the "As Of" date to age open balances. If left blank, the current date is used as the default.
AGING OPTIONS:
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 blank, "D" is default.)
4. Specify one of the following methods for aging calculations: 1 = Aging Days (Default) 2 = Fiscal Periods 3 = Calendar
5. Enter the following aging category information: (for method "1" only) Aging Days: Beginning thru thru thru thru

107.10 Customer Totals by G/L Account (P09450)

Processing Option	Processing Options Requiring Further Description
ACCOUNT DISPLAY MODE:
1. Enter the type of account number to print on the Report. ' ' = Number entered during input. '1' = Structured Account. '2' = Short Account ID. '3' = Unstructured Account Number
DISPLAY ADDRESS:
2. Enter a '1' to print the supplier/ customer address. If left blank, no address will print.