111 Statement and Reminder Processing - Processing Options

This chapter contains these topics:

111.1 Finance Charge Update (P01830)

Processing Option Processing Options Requiring Further Description
UPDATE MODE:  
1. Enter a '1' to run the update in final mode.

If left blank, the batch will run in proof mode, and no update will occur.

  
PERCENTAGE:  
2. Enter a finance charge to be added to the existing percent OR a finance charge to replace the existing percent in the Address Book.

(When entering a percent, you must use the decimal form. For example, two percent would be entered as "0.02")

Enter the percent to be added:

- OR -

Enter the replacement percent:

  

111.2 Finance Charge Journal (P03435)

Processing Option Processing Options Requiring Further Description
PROCESSING MODE:  
1. Enter a '1' to run in Final Mode and create G/L and A/R entries.

Leave blank to run in Proof Mode.

  
DATE PROCESSING:  
2. Enter the G/L date to be entered to the G/L and A/R records.

If left blank, today's date will be used as the default.

  
3. Enter a '1' to compute finance charges using the Net Due Date.

If left blank, the Invoice Date will be used.

  
4. Enter the effective date to be used for comparing against the Invoice/Net Due Date above for the finance charge computation.

If left blank, today's date will be used.

  
SUPPRESS WARNINGS:  
5. Enter a '1' to suppress printing warnings on the report for finance charges with no errors.

If left blank, all warnings will be printed.

  
FINANCE CHARGES:  
6. Enter a '1' to compute compound finance charges (Finance charge on finance charges).  
7. Enter an override percent factor to be used when calculating finance charges.

If left blank, the finance percent factor will default from Customer Master Information.

Note: 6.5 percent would be entered as .065.

  
MINIMUM AMOUNT:  
8. Specify a minimum amount for creating finance charges. Finance charges will not be created if the amount is less than this limit.

If left blank, finance charges will be created regardless of the amount.

  
INVOICE PRINT:  
9. Enter a '1' to print an invoice for each finance charge created. If a '1' is entered here, a '1' must also be entered to run in Final Mode.  
10. Enter the version of the Invoice Print program, P03505, to run when printing invoices.

If left blank, version ZJDE0001 will be run as the default.

  
11. Enter the Payment Terms Code to be entered to the new invoices created.  
DW VERSION FOR A/R RECORDS:  
12. To override standard Accounts Receivable processing (DREAM Writer XT0311Z1, Version ZJDE0001), enter an override version number. This should only be changed by persons responsible for system-wide setup.  
DW VERSION FOR G/L RECORDS:  
13. To override standard Journal Entry processing (DREAM Writer XT0911Z1 version ZJDE0001), enter an override version number. This should only be changed by persons responsible for system-wide setup.  

111.3 Interest Invoices (P03540)

Processing Option Processing Options Requiring Further Description
PROOF/FINAL MODE:  
1. Enter a "1" for final mode to print invoices and update files.

If left blank, a proof report will be printed and no file updates will occur.

  
AS OF DATE:  
2. Enter the "As Of" date for invoice selection.

If left blank, the current date will be used.

  
G/L DATE:  
3. Enter the G/L date to be assigned.

If left blank, the current date will be used.

 If the payment date for an invoice is after the 'as of' date, the invoice will not be selected. The 'as of' date must be greater than the payment dates for invoices you want to select.
ADDITIONAL INTEREST PERCENT:  
4. The base finance charge rate is entered in the Interest Rate Constants (by company). If a rate is entered in the Address Book for the customer, it will be added to the base rate. Enter here the amount to be added to the base rate if the rate in the address book is blank.

Note: Enter 2.5% as "2.5", etc.

All rates for Interest Invoices are entered as MONTHLY amounts.

  
MINIMUM AMOUNTS:  
5. Enter the minimum amount of interest required per Original Invoice.  
6. Enter the minimum amount of interest required per Interest Invoice.  
7. Enter the Currency Code that defines the minimum amounts entered above.  
TAX RATE/AREA:  
8. Enter the Tax Rate/Area Code to be used for VAT tax calculations.

Leave blank for no VAT tax.

  
PAYMENT TERMS:  
9. Enter the Payment Terms code to be applied to the invoice.  
EXTRA CREDIT DAYS:  
10. Enter the number of days to be given as a grace period.  
PRINTING OF INTEREST RATE:  
11. Enter rate to be printed in Interest Rate column:

"1" = Daily rate,

"2" = Monthly rate,

"3" = Annual rate.

  

111.4 A/R Statements (P035001)

Processing Option Processing Options Requiring Further Description
PROOF/FINAL MODE:  
1. Enter a '1' to run the statements in final mode.

If left blank, the statements will be run in proof mode and no updates will occur.

  
COMPANY CONSOLIDATION:  
2. Enter a company to be used for the 'Remit To' company, aging constants and/or special text when performing company consolidation.

If left blank, separate statements will be printed per company.

  
CREDIT/CASH MANAGEMENT FILE BUILD:  
3. Enter a '1' to rebuild the temporary A/R Credit/Cash Management work file (F0315WJA) prior to printing A/R statements. The Based On File must be F0315WJA.

If left blank, the existing Credit/Cash Management file (F0315JA) will be used.

 When using a '1' in this processing option, verify the Based on File is F0315WJA.
4. Enter a '1' to include zero open balance records when rebuilding the temporary A/R Credit/Cash Management work file (F0315WJA).  
AGING:  
5. Enter a '1' to retrieve the aging specifications and statement date from A/R Company Constants, ignoring the following options 6 through 9.

Leave blank to use the following processing options 6 through 9 to specify the statement date and aging.

 When using a '1' in this processing option, the remaining aging processing options will be ignored.
6. Enter the statement date. Open balances are aged as of this date and detail records are selected based on this date.  
7. Specify the date from which to age open balances:

D = Due Date (default)

I = Invoice Date

G = General Ledger Date

S = Statement Date

  
8. Specify the method for defining aging categories:

1 = Aging Days (default)

2 = Fiscal Periods

3 = Calendar

  
9. If using the Aging Days method, enter the aging day ranges:

Beginning

thru

thru

thru

thru

thru

  
10. Enter a '1' to apply credits to the current aging balance.

Leave blank to age credits.

 Use this processing option to specify whether to age account credits, or to apply credits to the current aging balance.
DATA SELECTION:  
11. Enter the version number for the F0311 selection and sorting DREAM Writer (Form ID P03500X).

If left blank, version 'ZJDE0003' will be used. See program helps for more information.

  
12. Enter a '1' to exclude future amounts.  
13. Enter a '1' to exclude paid invoices.

Blank will print paid invoices with current activity.

  
14. Enter a '1' to process with multi- currency.

Leave blank to process statements in domestic currency only.

  
15. Specify the date to be used to select detail records. This date will be compared to the Statement Date:

D = Due Date

I = Invoice Date

G = General Ledger Date

S = Statement Date

Leave blank to use aging date.

  
PRINT FORMAT:  
16. Enter a '1' to print aging information on the statement.  
17. Enter a '1' to suppress printing the account summary information at the end of the statement.  
18. Enter a '1' to print the invoice date on the statement.

Leave blank to print the due date.

  
19. Enter a '1' for RIBA draft format.

Leave blank for standard format.

  
20. Enter a '1' to print the following at the top of each statement:

Statement Number

Remit To Address

  
21. Specify which address is used as the "Remit To" address:

Related Address

(Blank = Company, any other is Related Address Code. Ex:

1 = 1st Address Number

P = Parent )

Specific Address

 Use this processing option to determine the address that will print on the notice for the "Remit to" address. If both processing options are blank the Company address number will be used. If the Related Address field is entered, it will retrieve the related address from address book. If a Specific Address is used, it will retrieve that address book information for the "Remit to" address.
22. Enter a '1' to summarize each invoice on a single detail line.

Leave blank to print each pay item on a separate detail line.

  
STATEMENT NUMBER UPDATE:  
23. Enter one of the following values to update the statement number in the A/R Ledger file:

' ' = Always update statement number

'1' = Never update statement number

'2' = Update only blank statement numbers

  

111.5 A/R Invoice Print (P03505)

Processing Option Processing Options Requiring Further Description
INVOICE SELECTION DATE RANGE:  
1. Enter the as of date after which all invoices should be printed.

The range will include the date entered. This is a mandatory entry.

  
2. Enter the cut off date before all desired invoices should be printed.

The range will include the date entered. This is a mandatory entry.

  
PRINT OPTIONS:  
3. Enter a '1' to print the invoice using the foreign amount.

A default of a blank will print the domestic amount.

  
4. Enter a '1' to print tax amount on the invoice.

A default of a blank will not print tax amounts.

  
5. Enter a '1' to print generic text for each invoice pay item.

If left blank, no generic text will print.

  
6. Specify which address is used as the "Remit To" address:

blank = Company (default)

A = 1st Address Number

B = 2nd Address Number

C = 3rd Address Number

D = 4th Address Number

E = Factor/Special Payee

F = 5th Address Number address = address entered

  
PROCESSING CONTROL EDIT:  
7. Enter a '1' to perform Processing Control Edit to determine which customers to process.

Enter a '2' to perform Processing Control Edit, but default to processing options listed below if not found.

If left blank, the processing options listed below will be used to determine the processing mode.

Note: Option '2' allows clients to setup exceptions and process all others.

  
EDI PROCESSING:  
8. Enter a '1' to create EDI transactions.

If left blank, no EDI transactions will be created.

  
9. If creating EDI transactions, enter a '1' to print the document.

If left blank, the document will not print.

Note: If not creating EDI transactions the invoice will ALWAYS print.

  
FAX DOCUMENT PROCESSING:  
10. Enter a '1' to fax the document.

If left blank, the document will not be faxed.

  
11. Enter Fax Output Queue.

If left blank, the fax will be written to the same output queue as printed documents.

  

111.6 Payment Reminders (P03530)

Processing Option Processing Options Requiring Further Description
PROOF/FINAL MODE:  
1. Enter a '1' to print a Final payment reminder.

A default value of blank will print a Proof payment reminder.

  
AS OF DATE:  
2. Enter the "As Of" Date to be used for invoice selection.

If left blank, the current date will be used.

The system selects invoices with overdue amounts and invoice dates greater than or equal to this date for payment reminders.

  
MINIMUM DAYS:  
3. Enter the minimum number of days between payment reminders.  
MINIMUM AMOUNTS:  
4. Enter the total minimum amount open for a customer that is required to send a reminder.

Note: Please enter Twelve Dollars and Twenty-Five cents as 12.25, One Dollar as 1.00.

  
5. Enter the currency code that defines the minimum amount open.  
TEXT MESSAGE:  
6. Enter a "Y" to print a text message on the reminder. (Final mode only)  
NUMBER OF REMINDERS:  
7. Enter the number of payment reminders to send.

If left blank, the default value is '3'.

The system will use the number of reminders specified at the invoice level first, then at the customer level and then in this processing option until a non-blank value is found.

  
PRINT FORMAT:  
8. Enter '1' to print the alternate format which has the address on the left side and prints a remark column and no G/L date column.  

111.7 Delinquency Notices (P035111)

Processing Option Processing Options Requiring Further Description
CREDIT/CASH MANAGEMENT BUILD:  
1. Enter a '1' to rebuild the temporary A/R Credit/Cash Management workfile (F0315WJA) prior to printing delinquency notices. The Based On File must be F0315WJA.

If left blank, the existing Credit/Cash Management file (F0315JA) will be used.

  
AGING:  
2. Enter a '1' to retrieve the aging specifications from A/R Company Constants.

Leave blank to use the following processing options for aging specifications.

  
3. Enter the Notice Date. Open balances are aged as of this date.

Leave blank to use today's date.

  
4. Specify the date from which to age open balances:

D = Due Date (Default)

I = Invoice Date

G = General Ledger Date

S = Statement Date

  
5. Specify the method for defining aging categories:

1 = Aging Days (Default)

2 = Fiscal Periods

3 = Calendar

  
6. If using the Aging Days method, enter the aging day ranges:

Beginning

thru

thru

thru

thru

thru

thru

thru

  
DATA SELECTION:  
7. Enter a '1' to exclude future amounts.  
8. Enter a '1' to process with multi- currency.

Leave blank to process notices in domestic currency only.

  
FORMAT:  
9. Enter a '1' to print the "Remit To" address at the top of each notice.  
10. Specify which address is used as the "Remit To" address:

Related Address

(Blank = Company, any other is Related Address Code. Ex:

1 = 1st Address Number

P = Parent )

Specific Address

 Use this processing option to determine the address that will print on the notice for the "Remit to" address. If both processing options are blank the Company address number will be used. If the Related Address field is entered, it will retrieve the related address from address book. If a Specific Address is used, it will retrieve that address book information for the "Remit to" address.
FORMAT:  
11. Enter the date to print on the notices.

Leave blank to use the "As Of" date.

  
12. Enter a '1' to print the A/R detail records.  
DETAIL SELECTION AND SORTING:  
13. Enter the Version number for the F0311 Selection/Sort DREAM Writer.

(Form ID P03511X) If left blank, version 'ZJDE0004' will be used.

  
AS OF DATE PROCESS:  
14. Enter a '1' to use "As Of" date process.

You must use a version of P03511X that is based on the F0311A instead of the F0311.

  
DELINQUENCY NOTICE TEXT:  
15. For each level of notices, specify the aging category and data dictionary item for narrative text.

Valid aging categories are "C" (current) or 1 - 7.

Aging category for mild notice

Data Dictionary item for text

Aging category for second warning

Data Dictionary item for text

Aging category for severe warning

Data Dictionary item for text

  
TOTAL PERCENTAGE:  
16. Enter a percentage of the total amount due to be exceeded in order to print the delinquency notice.

Enter the percentage as a whole number; 5% should be entered as 5.

  
TICKLER FILE:  
17. Enter a '1' to write a message to the tickler file indicating that a notice has been sent.

Enter a version of the E-Mail Message Server (X00PPAT1).

If left blank, the default is ZJDE0002.

  

111.8 Reminder Report/Update (P03461)

Processing Option Processing Options Requiring Further Description
PROOF/FINAL MODE:  
1. Enter a '1' to run the Final Reminder Report.

Default of blank will run a Proof Reminder Report.

  
MINIMUM DAYS:  
2. Enter the minimum number of days between the last Payment Reminder sent and when the customer should appear on the Reminder Report.  

111.9 A/R Detail Report with Reminders Info (P034202)

Processing Option Processing Options Requiring Further Description
AS OF DATE:  
1. Enter the "As Of" date to process invoice balances. Invoices selected will have a due date less than the As Of date entered.

If left blank, the current date is used as the default.