This chapter contains these topics:
Section 110.4, "Open A/R by Business Unit and Address (P03445)"
Section 110.5, "A/R to G/L by Offset Integrity Report (P037001)"
Section 110.6, "A/R Drafts to G/L by Offset Account (P037002)"
Section 110.7, "Revenue Recognition Integrity Report (P037116) (Release A9.3 Update)"
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PAY THRU DATE: | |
| 1. Enter the Pay Thru date.
If left blank, the system date will be used. |
|
| PROOF OR FINAL: | |
| 2. Enter a '1' to create reimbursement vouchers (final mode).
Default of blank will print a report only. |
|
| GENERAL LEDGER DATE: | |
| 3. Enter the G/L date to record the reimbursement.
If left blank, the system date will be used. |
|
| GENERAL LEDGER OFFSET: | |
| 4. Enter an override G/L offset for the Trade A/P account.
If left blank, the G/L Class from the Supplier Master File will be used. |
|
| VOUCHER CREATION: | |
| 5. Enter a '1' to create one voucher record per customer (summary).
Default of a blank will create one voucher per invoice (detail). |
|
| 6. Enter a '1' to assign the payable voucher to the customer's parent address.
Default of blank will assign it to the customer. |
|
| 7. Enter the document type to be assigned to the voucher.
If left blank, 'PA' will be used. Note: If you are using Cash Basis accounting, you must enter and use a document type other than 'PA' as well as add it to the excluded document types UDC table 00/DX. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| 'AS OF' DATE: | |
| 1. Enter the 'As Of' date.
If left blank, the current date will be used. |
|
| UPDATE OPTION: | |
| 2. Include paid items in 'As Of' file.
' ' = open items only '1' = open and paid items |
|
| 3. Enter a '1' for a partial build. The build will delete and write only records for those companies selected in DREAM Writer Data Selection.
(RPCO *EQ *VALUE) |
| 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. |
| 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. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PRINT OPTIONS: | |
| 1. Enter a '1' to print only accounts that are out-of-balance.
If left blank, all accounts will print. |
|
| 2. Enter a '1' to print detail A/R Invoice and Receipt data for any account that is out-of-balance.
Enter a '2' to print detail for all accounts. If left blank, no detail will print. |
|
| 2a. Enter a '1' to only print detail where the calculated gross is NOT equal to the ledger open amount.
If left blank, all detail will print. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PRINT OPTIONS: | |
| 1. Enter a '1' to print only accounts that are out-of-balance.
If left blank, all accounts will print. |
|
| 2. Enter a '1' to print detail A/R Draft data for any account that is out-of-balance.
Enter a '2' to print detail for all accounts. If left blank, no detail will print. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| REPORTS AND DATA PRINT | |
| 1. Enter '1' to bypass printing the FB Journal Entry details if it is out-of-balance for the invoice.
If left blank, the system prints detail by account. |
|
| ADDITIONAL INTEGRITY VALIDATIONS | |
| 2. Enter '1' to print A/R Revenue Recognition - Invoices (F03116) and A/R Revenue Recognition Distribution (F03117) records not linked to A/R invoices.
If left blank, the system does not compare the records to the A/R invoices. |
|
| 3. Enter '1' to compare the percentage of revenue recognized to the percentage of COGS recognized on sales order invoices.
If left blank, the system does not compare the percentages. |
|
| 3a. Enter the allowable tolerance limit percentage for comparing recognized revenue and COGS. For example, 2 indicates a tolerance within 2 percent. |