68 Banking Requirements Processing Options

This chapter contains these topics:

68.1 Processing Options for A/R Brazilian Tag Maintenance (XT0311Z1BR)

Processing Options Processing Options Requiring Further Description
INTEREST RATE:  
Enter the rate for calculation  
PROSECUTION INSTRUCTIONS:  
First Instruction.

Second Instruction.

  

68.2 Processing Options for Bank Data Remit - Standard (P76550B)

Processing Option Processing Option Requiring Further Description
COMPANY CODE:  
1. Enter code provided by the bank.  
COMPANY IDENTIFICATION FOR BANK:  
2. Enter company ID as follows:

- Carteira

- Branch ID

- Account Number

- Account Number Check Digit

  
TYPE OF DOCUMENT:  
3. Enter Document type. If left blank '01' will default.  
ACCEPTANCE:  
4. Enter acceptance code as follows:

'A' Accepted 'N' Not Accepted If left blank, 'N' will default.

  
PROCESSING TYPE:  
5. Enter '1' for final mode.  
REMIT NUMBER:  
6. Enter the System for next number.  
7. Enter the occurrence for next number.  
DAYS BEFORE DUE DATE:  
8. Enter the number of days before due date that the document can be sent to the bank.  
COLLECTION DOCUMENT:  
9. Enter one of the following options:

1 = Bank prints the collection document, or

2 = Company prints the collection document.

Blanks will be default to 1.

  

68.3 Processing Options for Auto Cash Processing - Load Bank Tape (P03551)

Processing Option Processing Option Requiring Further Description
TAPE DEVICE AND LIBRARY:  
1. Enter the tape device name.

(Default is TAP01)

  
2. Enter the Data File Library to be used for the load of the F03551 file.

(Default is *LIBL)

  
JOURNAL ENTRY CREATION:  
3. Enter '1' to create a single Journal Entry for each deposit item.

Leave blank to create a summarized Journal Entry that includes all deposit items.

  

68.4 Processing Options for Bank Data Receipt - Standard (P76551B)

Processing Option Processing Option Requiring Further Description
COMPANY CODE:  
1. Enter code provided by the bank.  
GENERAL LEDGER DATE:  
2. Enter Date for movements in Account Ledger. If left blank, the Return file date will default.  
UDC FOR BANK/INTEREST ACCOUNT:  
3. Enter the system code.

Enter the user defined code.

NOTE: The UDC must have the document company as the key bank account in description 1 and interest account in description 2 (both short ID).

  
4. Enter Document Type to be used in A/R for Interest. If left blank 'RF' will default.  
ACCOUNTING:  
5. Enter '1' to write entries in detail, or leave blank to summarize.  

68.5 Processing Options for Create Payment Groups (P04570)

Processing Option Processing Option Requiring Further Description
PAYMENT SELECTION:

1. Enter either Pay Thru date or number of displacement days from today.

Pay Thru Date 07/05/05

Displacement Days

  
2. Enter a '1' to include all Debit

Memos in this payment run regardless of Due Date.

  
3. Enter one of the following values:

'1' = Omit Prenote vouchers

'2' = Select ONLY Prenote vouchers

' ' = Select all regardless of Prenote status (Default)

  
DISCOUNT DATE:

4. Enter the cutoff date for allowing discounts. Pay items with a due date prior to this date will not take a discount. If left blank, all discounts will be taken.

  
5. Enter a '1' to bypass the voucher if the discount cut off is missed and the Net Due Date is later than the Pay Thru date. If left blank, the Net Due Date will not be considered.  
AMOUNT RANGE:

6. Enter the payment amount range to be included in this pre-payment run. Also enter the pay instrument to be assigned to payments outside of the amount range. If currency conversion is turned on, enter the currency code for the amount range.

Minimum Amount. . . .

Min Pay Instrument. .

Maximum Amount. . . .

Max Pay Instrument. .

Currency Code . . . .

  
COMPANY PROCESSING:

7. Enter a '1' to create a different payment by company. Leave blank to process multiple companies on each payment.

  
DUE DATE PROCESSING:

8. Enter a '1' to print a separate payment by due date. If left blank a separate payment by due date will not be printed.

Note: If choosing this option, the DREAM Writer sequence should be set to include Due Date after Alternate Payee Address Number.

  
PAYEE PROCESSING:

9. Enter a '1' to create one payment per payee regardless of supplier.

  
PRINT CONTROL:

10. Enter a '1' to print a special attachment when payment detail information will not print on the stub.

  
11 .Enter the sequence ID which will DEMO order the payments when printed.  
PRINT CONTROL (continued):

12. Enter a '1' to print the full address for each payee on the Edit report. Leave blank to only print the payee alpha name.

  
13. Enter a '1' to print contract information on the report.  
14. Enter a '1' to print job information on the report.

Note: If choosing either option 10 or 11, payments should be sequenced by contract number.

  
PAY ITEM SUMMARIZATION:

15. Enter one of the following values to summarize the document on the pay stub and/or attachment. If left blank, no summarization will occur.

'1' - By Document and Due Date

'2' - By Document

  
16. Enter a '1' to have the summary description on the pay stub default from the first pay item's remark. If left blank, the description will be retrieved from the vocabulary overrides for this program.  
BANK ACCOUNT:

17. Enter an override bank account to be used for payment. If left blank the bank account in the Accounts Payable detail record will be used.

Note: This must be a Short Acct ID.

  
CURRENCY PROCESSING:

18. Enter one of the following values to indicate which currency should be used for payment.

' ' - Bank Account Monetary Unit

'1' - Voucher Domestic Currency

'2' - Voucher Foreign Currency

'3' - Current Domestic Amount

'4' - Alternate Currency Payment

If Alternate Currency payment, enter the currency code of the payment.

If Current Domestic payment, enter Effective Date to retrieve exchange rate. If blank, the system date will be used.

  
BUSINESS UNIT PROCESSING:

19. Enter a '1' to use the business unit as a selection criteria in the creation of a Payment Control Group.

If left blank, business unit will not be considered and one PCG may include vouchers with different business units.

  
ELECTRONIC FUNDS TRANSFER/EDI ONLY:

20. Enter a '1' if you will be using tape output and would like to see tape information on the edit report.

If left blank, no tape information will appear on the report.

  
21. Enter a '1' if using tape output and you would like to be notified if Supplier is set to Pre-Note status.

**PRE will print under Supplier Name.

  
22. Enter a '1' to issue an error on the edit report if the Payee's EFT/EDI bank information does not exist.  
ELECTRONIC FUNDS TRANSFER/EDI (cont.):

23. Enter a '1' to issue an error on the edit report if a G/L Bank Account's X12 information does not exist.

  
24. Enter an override Effective Date and Bank Type to use to retrieve Bank Account/Transit data. If left blank, the System Date and the Bank Type on the voucher will be used.

Effective Date. . . . . . . . . .

Bank Type . . . . . . . . . . . .

  
ELECTRONIC FUNDS TRANSFER/EDI(continued)

25. Enter a '1' to validate the IBAN/BIC values on Payor and Payee banks and that the payment is being made in EUROs for SEPA payments. If left blank, no SEPA edits will be performed.

  
26. Enter the currency code that represents EURO currency. If left blank, EUR will be used.  
27. Enter '1' to print IBAN & Swift/BIC on the report if available. If left blank, IBAN/Swift will not print.  
CALCULATE WITHHOLDING:

28. Enter a '1' submit the Calculate Withholding program (P04580) prior to running Pre-Payments. If left blank, Calculate Withholding will not be run.

Note: The voucher withholding pay items created will not be posted.

  
29. Enter the DREAM Writer version number of the Calculate Withholding program to be run. If left blank, version ZJDE0001 will be used.  
USER EXIT OPTION:

30. Enter the User Exit program name. If left blank the name 'X04570E' will be used.

  

68.6 Processing Options for A/P Payments - Work with Payment Groups (P04257)

Processing Option Processing Option Requiring Further Description
INTERACTIVE OR BATCH:  
1. Enter a '1' to process the payments interactively. Leave blank to submit the write or update in batch mode without a submittal message.  
1a. Enter Job Queue for Batch Process  
1b. Enter '1' to submit job on Hold  
BUSINESS UNIT PROCESSING:  
2. Enter a '1' to display the business unit fields. If left blank, the business unit fields will not display

Note: The selection and display of the business unit would only be applicable if you ran your Payment Control Group using business unit as a control field.

  
PRINT OPTIONS:  
3. Enter '1' to use the first voucher's exchange rate (thus ignoring any gains/losses) or an effective date to use to retrieve the exchange rate.

If both options are blank, the G/L date assigned to the payment will be used to retrieve the exchange rate.

Voucher Exchange Rate

or Effective Date

  
4. Enter a '1' to allow Currency Spot rates to be entered when Writing payments. If left blank, no spot rates will be allowed.  
5. For BACS, enter a '1' to allow entry of BACS processing dates. If left blank, BACS processing will not function.  
6. Enter one of the following options for output:

' ' - Each Payment Control Group (PCG) will be output to a separate tape file or spool file.

'1' - Group PCGs for the same bank account into one file.

'2' - Group all selected PCGs into one file regardless of account.

  
7. Enter a '1' to request the following:

Save Spool File

Hold Spool File.

  
8. Enter the version number for the Write program. If left blank, the Payment Instrument Default version will be used.

NOTE: This processing option will override any entry to the Controls Window also.

  
9. Enter a '1' to force the assignment of payment numbers to be in sequential order. This option is only valid if you have selected to output separate PCGs or those with the same bank account to one spool file.(Refer to previous Proc Option).

Note: This option is only valid for hard-copy payments and reserves the bank account payment number from the bank account file (F0030). If working with EFT, segregate PCGs by Prenote Code and use this option on only those PCGs with Prenote Vendors.

  
UPDATE OPTIONS:  
10. Enter a '1' to bypass clearing the prenote code in Bank Transit file.  
11. Enter the version number for the register program. If left blank, the Payment Instrument Default version will be used.

NOTE: This processing option will override any entry to the Controls Window also.

  
12. Enter a '1' to submit the A/P payment post after the payments have been updated. If left blank, the post WILL NOT be automatically submitted.

This will allow you to review the payment batch and post it at a more convenient time.

  
13. Enter a '1' to process void payments through the system (post to G/L, and the bank reconciliation).

If left blank, void payments will not be processed.

  
14. Enter '1' to automatically submit the Positive Pay Workfile Build (P04585) after the payments have been updated. If left blank, the Positive Pay file will not be built.  
PRELOADED DATA SELECTIONS:  
15. Any values entered into the following options will be loaded upon entry into the program:

Bank Account

Version

Originator

Payment Instrument

Print Queue

Currency Code

Business Unit

Write/Update

Sequence (Payment Review)

  
DW VERSION FOR BANK TAPE REVIEW:  
16. Enter the version number for the Bank Tape Review program. If left blank, ZJDE0001 will be used.  
DW VERSION FOR A/P PAYMENT PROCESSOR:  
17. To override standard A/P Payment processing (DREAM Writer XT0413, version ZJDE0001), enter an override version number. This should only be changed by persons responsible for system wide setup.  
DISPLAY OF ALTERNATE CURRENCY AMOUNTS:  
18. Enter a '1' to display the payment control group amounts in the alternate currency amount.

Exchange rate effective date If blank, default is system date

  
DW VERSION FOR G/L PROCESSOR:  
19. To override standard G/L processing (DREAM Writer XT0911Z1, version ZJDE0001), enter an override version number. This should only be changed by persons responsible for system wide setup.  
WRITE PAYMENT WINDOW OPTIONS:  
20. Enter a '1' to protect the Next Payment Number from change. If left blank, you may change the Next Payment Number.  
21. Enter one of the following options for handling the G/L Date:

' ' = No Date Restriction (Default)

'1' = Current or Future Date Only

'2' = System/Current Date Only