30 Banking Requirements Processing Options

This chapter contains these topics:

30.1 Update Multi-Tiered A/R (P005142)

Processing Option Processing Option Requiring Further Description
TAX PROCESSING:  
1. Enter a '1' to indicate that Tax Information should not be printed.  
AS OF DATE:  
2. Enter the "As of" date to process. The batch program will calculate the discount as if the current date were this date.

If left blank the system date will be used.

 

30.2 A/P Payments - Bank Tape for Japan (P04572JP)

Processing Option Processing Option Requiring Further Description
ELECTRONIC FUNDS TRANSFER:  
1. Enter the File ID modifier (1 pos.). This is used to distinguish between multiple files created on the same date.

Default value is '1'.

 
2. Enter the tape payment detail (10 pos.) description. For example, you may want to enter EXP REIMB for expense reimbursements. This description may be used by the bank and printed on the supplier's bank account statement.  
3. Enter the Company ID number (10 pos.). This is the Identification Code Designator (ICD) followed by a 9 digit identification number. Valid ICD's are:

'1' = IRS Employer Identification Number

'2' = Data Universal Numbering Syst

'9' = User Assigned Number

If left blank, the Tax ID for the Bank Account's company will be used. Please note that if this field is blank on the tape, the tape will be rejected by the banking clearing house.

 
4. Enter a value (20 character alpha) to be placed in the Discretionary Data field on the Company/Batch Header record format.

If left blank, the Discretionary Data field will be blank.

 
PRINT PROGRAM:  
5. Enter the payment print program to use if the pre-note status is set to 'P', requiring a payment print.  
BANK TAPE:  
6. Enter the following default values:

Device Name. . . .

Tape Density. . . .

Label Name. . . .

Blocksize. . . .

New Volume Name. . . .

New Owner ID. . . .

File Name. . . .

 

30.3 A/P Payments - Register for Japan (P04576JP)

Processing Option Processing Option Requiring Further Description
FOR SUBCONTRACT PAYMENTS:  
1. Enter one of the following values:

'1' = Print contract information

'2' = Print job number information

 

30.4 Create Payment Groups (P04570)

Processing Option Processing Option Requiring Further Description
PAYMENT SELECTION:  
1. Enter in either a Pay Thru date or the number of displacement days from today.

Pay Thru Date

Displacement Days

 
DISCOUNT DATE:  
2. 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.

 
AMOUNT RANGE:  
3. 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. Enter your amount range in whole numbers.

Minimum Amount. . . .

Min Pay Instrument. . . .

Maximum Amount. . . .

Max Pay Instrument. . . .

Currency Code. . . .

 
COMPANY PROCESSING:  
4. Enter a '1' to create a different payment by company.

Leave blank to process multiple companies on each payment.

 
DUE DATE PROCESSING:  
5. 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:  
6. Enter a '1' to create one payment per payee regardless of supplier.  
PRINT CONTROL:  
7. Enter a '1' to print a special attachment when payment detail information will not print on the stub.  
8. Enter the sequence ID which will order the payments when printed.  
9. Enter a '1' to print the full address for each payee on the Edit report.

Leave blank to only print the payee alpha name.

 
10. Enter a '1' to print contract information on the report.  
11. 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:  
12. Enter a '1' to summarize pay items within a document on the pay stub and/or the attachment.

If left blank, pay items will not be summarized.

 
13. 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:  
14. 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:  
15. 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

 
BUSINESS UNIT PROCESSING:  
16. 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:  
17. 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.

 
18. Enter a '1' to issue an error on the edit report if the Payee's EFT/EDI bank information does not exist.  
19. Enter a '1' to issue an error on the edit report if a G/L Bank Account's X12 information does not exist.  
CALCULATE WITHHOLDING:  
20. 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.

 
21. 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:  
22. Enter the User Exit program name.

If left blank the name 'X04570E' will be used.

 

30.5 Work with Payments (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.

 
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. For BACS, enter a '1' to allow entry of BACS processing dates.

If left blank, BACS processing will not function.

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

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

Save Spool File. . . .

Hold Spool File. . . .

 
7. 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. (Option 5 is a blank or '1').

Note: This option is only valid for hard-copy payments and reserves the bank account payment number from the bank account file (F0030). This option will not work with tape payments.

 
UPDATE OPTIONS:  
8. Enter a '1' to bypass clearing the prenote code in Vendor Master.  
9. 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.  
10. 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.

 
PRELOADED DATA SELECTIONS:  
11. 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. . . .

 
DW VERSION FOR BANK TAPE REVIEW:  
12. Enter the version number for the Bank Tape Review program.

If left blank, ZJDE0001 will be used.

 
DW VERSION FOR A/P PAYMENT PROCESSOR:  
13. 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.  
DW VERSION FOR G/L PROCESSOR:  
14. 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.  

30.6 Draft Collection (P7503576)

Processing Option Processing Option Requiring Further Description
PROOF OR FINAL:  
1. Enter '1' to update the status of the drafts and create Journal Entries if selected.  
AS OF DATE:  
2. Enter the "As of" date to process. All drafts due on or before this date will be processed.

If left blank, the current system date will be used.

 
DEFAULT PROCESSING:  
3. Enter the default document type for the journal entries.

If left blank or invalid, 'AE' will be used.

 
JOURNAL ENTRY CREATION:  
4. Enter a '1' to create Journal Entries.

If left blank, no Journal Entries will be created.

 
5. Enter the G/L date for the Journal Entries.

If left blank, the system date will be used.

 
6. Enter a '1' to calculate the G/L Date by adding the Float Days for the bank account to the Net Due Date.

Leave blank to use the option above to calculate the G/L Date.

 
7. Enter the Pay Status to update the draft records to. If left blank and the next option is 1, the pay status will be updated to 'R' (Remitted).

If left blank and the next option is blank, the pay status will be updated to 'P' (Paid).

 
8. Enter '1' process draft for Remittance Stage.

If left blank process draft for Collection Stage.

 
9. Enter 'Payment Instrument' that will be used in the AAI RD3x to specify the Draft Contingent Liability G/L Account.

This option should not be blank.

 

30.7 Drafts Receivable Report (P7503420)

Processing Option Processing Option Requiring Further Description
1. Select the format you wish to print.

'1' - List by Customer Number.

'0' - List by Value Date (Default)