107 Period-End Processing - Processing Options

This chapter contains these topics:

107.1 A/R Credit Note Reimbursements (P03610)

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.

 

107.2 Date File Generation (P03900)

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)

 

107.3 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.4 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.5 A/R to G/L by Offset Integrity Report (P037001)

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.

 

107.6 A/R Drafts to G/L by Offset Account (P037002)

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.