35 Banking Requirements Processing Options

This chapter contains these topics:

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

  

35.2 A/P Payments - French Bank Tape (P04572F1)

Processing Option Processing Option Requiring Further Description
PROCESSING MODE:  
1. Enter a '1' to print a paper Funds Transfer Order.

If left blank a Electronic Funds Transfer (EFT) file will be created.

  
TAPE INFORMATION:  
2. Enter one of the following to load information to the reference field of the detail record.

' ' = payment document number

'1' = vendor number

'literal comment'

  
3. Enter the Sender's Bank ID number (6 pos.). If left blank, the Bank Account Bank System User Number (BACS) will be used.

Please note that if this field is blank on the tape, the tape will be rejected by the bank clearing house.

  
4. Enter the Sender's Fiscal Identification (15 positions). This can be either the SIRET code

(1 + 14 digits) or another code

(2 + code).

  
5. Enter the City to be loaded into the payment records.  
BANK TAPE:  
6. Enter the following default values:

Device Name. . .

Tape Density. . .

Label Name. . .

Blocksize. . . .

New Volume Name. . .

New Owner ID. . .

File Name. . .

  

35.3 A/P Payments - French Checks (P04572F2)

Processing Option Processing Option Requiring Further Description
ADDRESS FORMAT:  
1. Enter an override address format to use for the payee and/or company addresses.

If left blank, the country format will be used.

  
PAYMENT INFORMATION:  
2. Enter a '1' if you would like the purchase order number to print on the stub instead of the supplier invoice number.  
3. Enter the City to print on the Payment.  
PRINT INFORMATION:  
4. Enter the Forms Type for the Payments Spool File.

If left blank, the default is 'APCHECKS'.

  

35.4 A/P Payments - Register (P04576)

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

  

35.5 A/P Payments - Attachments (P04573)

Processing Option Processing Option Requiring Further Description
PRINT OPTIONS:  
1. Enter one of the following values to select the sequence order of the detail to appear on the attachment.

blank = Voucher Information

'1' = Vendor Invoice

  

35.6 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 criterion 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.

  

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

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

  

35.8 Automatic Debiting Build (P03575)

Processing Option Processing Option Requiring Further Description
PROOF OR FINAL MODE PROCESSING:  
1. Enter a '1' to create the file to be sent to the bank and to create the Automatic Debit entries against the selected invoices.

If left blank, only a proof report will be produced.

  
AS OF DATE:  
2. Enter the 'As of' Date to process. All invoices will be processed that have a comparison date on or before the As of Date.

If left blank, the system date will default.

  
DATE COMPARISON:  
3. Enter the type of date to compare to the As of Date.

' ' = Net Due Date (Default)

'D' = Discount Due Date

'I' = Invoice Date

'G' = G/L Date

'S' = Statement Date

  
MINIMUM AND MAXIMUM OPTIONS:  
4. Enter the MINIMUM amount which is to be selected for payment via Automatic Debits.

Amounts under this amount will not be selected.

  
5. Enter the MAXIMUM amount which is to be selected for payment via Automatic Debits.

Amounts over this amount will not be selected.

Note: The processing options above must be specified in the currency of the Bank Account.

  
BANK INFORMATION:  
6. Enter the G/L Bank Account that the invoices are being submitted to.

It is MANDATORY to enter a valid account short ID for this option.

  
G/L DATE:  
7. Enter a G/L Date.

If left blank, the system date will be used.

  
DISCOUNT PROCESSING:  
8. Enter a '1' if all discounts are to be processed.

If left blank, the cutoff date option will be used.

  
9. Enter the cutoff date for applying discounts. Discounts will not be taken if the Discount Due Date is prior to this date.

Note: These Discount Options also exist in Batch Receipts Processing (P03550). These options should have the same values as specified in your Batch Cash version.

  
COUNTRY SPECIFIC FORMAT SELECTION:  
10. Enter the name and DREAM Writer version number of the program to be called to create the formatted file for the bank. (Press F1 for a list of available programs.)

Program Name. . . .

Program Version. . . .

  
STATEMENT PRINT:  
11. Enter a '1' if a Customer Statement is to be printed for the Automatic Debits.

If left blank, Customer Statements will only be printed where the number of invoice details exceeds the maximum number that can be included onto the format.

  
12. Enter a '1' to use the Send Statement To address to retrieve the mailing address to use on the remittance. If left blank, the main mailing address of the customer will be used.  
COPY TO TAPE/DISKETTE:  
13. Enter a '1' if the Copy to Tape or Diskette option should be called automatically following Final Mode processing.

If left blank, the copy option may be run at a later stage. (Leave blank if creating paper forms).

  
14. Enter the version of the Copy to Tape/Diskette program P03579 to be called.

If left blank, this defaults to version ZJDE0001. Confirm values in P03579 processing options prior to running.

  
BATCH PROCESSING:  
15. Enter the version number of the Batch Receipts program to be called to create and match the Automatic Debits to the selected invoice details.

If left blank, one of the two versions will default.

ZJDE0002 - For Summary JE's.

ZJDE0003 - For Detail JE's.

Note: verify the processing option values for the Batch Receipts version (P03550).

  
JOURNAL ENTRY CREATION:  
16. Select G/L Entries Method:

' ' = Create summary total J.E.'s

'1' = Create detail J.E.'s, which will create one J.E. per deposit item.

  
BATCH CASH RECEIPTS PURGE:  
17. Enter a '1' to purge the Batch Receipts Workfile (F0312) upon run completion.

If left blank, the file will not be purged.

  
18. Enter the version number of the purge program P00PURGE to be called to clear records from the Batch Receipts work file F0312.

If left blank, version ZJDE0009 will be called.

  
BACS PROCESSING:  
19. Enter a '1' if processing BACS. A report message will be issued if the processing date is a non-workday.  
20. Enter the BACS processing date.  
21. Enter the number of days to add to the processing date. This is used to calculate the BACS expiration date.  
22. Enter the workday calendar to use for validating the processing and expiration dates.  
MINIMUM AND MAXIMUM FOR BACS CREDITS:  
23. Enter the MINIMUM CREDIT amount which is to be selected for payment via Automatic Debits.

Amounts under this amount will not be selected.

  
24. Enter the MAXIMUM CREDIT amount which is to be selected for payment via Automatic Debits.

Amounts over this amount will not be selected.

Note: The processing options above must be specified in the currency of the Bank Account.

  
MULTI-CURRENCY PROCESSING:  
25. Enter a '1' to pay using the transaction currency of the invoice.

Leave blank to pay using the domestic currency of the invoice.

  
BANK TYPE OVERRIDE:  
26. Enter an override Bank Record Type to be used to retrieve Bank Transit/ Bank Account data. If left blank, the bank type on the invoice or 'D ' will be used.