43 Automatic and Alternate Currency Payments Processing Options

This chapter contains these topics:

43.1 Create Payment Groups (P04570)

Processing Option Processing Options 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

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

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 order the payments when printed.  
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 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:  
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.

Note: 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.  
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

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

 

43.2 A/P Payments - Work with Payment Groups (P04257)

Processing Option Processing Options 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.

When this option is activated, you will be able to manually enter an exchange rate at the time of update.
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 print 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). 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 Vendor Master. Use this option when you do not want the prenote code to automatically update during the payment process. Once you have confirmation from the bank that the prenote information is correct, you will have to manually update the prenote code.
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.

 
PRELOADED DATA SELECTIONS:  
14. 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:  
15. Enter the version number for the Bank Tape Review program.

If left blank, ZJDE0001 will be used.

 
DW VERSION FOR A/P PAYMENT PROCESSOR:  
16. 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:  
17. 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:  
18. 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:  
19. Enter a '1' to protect the Next Payment Number from change.

If left blank, you may change the Next Payment Number.

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

 

43.3 Manual with Match Check Processing (P04102)

Processing Option Processing Options Requiring Further Description
DEFAULT PROCESSING:  
1. Enter a '1' to summarize pay items by Voucher number and Due Date when viewing open items.

Note: A function key exists to toggle summarized pay items.

 
2. Enter a '1' to automatically assign payment numbers based on the bank account next payment number if field is left blank.

Enter a '2' to automatically assign payment number and prohibit manual entry of payment number.

If left blank, you will be required to enter a payment number.

 
3. Enter a '1' to prevent deletion of an unposted payment.

If left blank, you may delete unposted payments.

CAUTION: We recommend you review this option in the A/P Payment Server XT0413 to ensure processing is consistent. This will reduce error and unexpected results.

 
FORMAT CONTROL:  
4. Select the default screen format:

" " = Discount Amount

"1" = Open Amount

 
FIELD DISPLAY CONTROL:  
5. Enter a '1' to allow display and update of Value Date.  
6. Select the default screen mode:

' ' = Supplier Mode

'1' = Alternate Payee Mode - Not allowed for One Time Payment suppliers.

 
7. Enter a '1' to allow display and update of Subledger/Subledger Type fields. When using subledger/subledger types with manual payments, the account associated with the subledger will always be the account designated in the G/L Bank Account field.
DRAFT PROCESSING:  
8. Enter a '1' to display the draft entry field.  
DUPLICATE PAYMENT PROCESSING:  
9. Enter a '1' to issue a warning when a duplicate payment number within the same bank account has been entered for different suppliers.

If left blank, an error will be given for duplicate payment numbers entered against the same bank account.

 
9a. Enter a '1' to consider voids and issue the error or warning even if the payment number was previously voided.  
NEGATIVE PAYMENT PROCESSING:  
10. Enter a '1' to allow negative payments to be created.  
AUTOMATIC PRINT PROCESSING:  
11. Enter in the following default information for automatic print processing:

Payment Instrument

Print Program Version Number

Save Spool File ('1' = yes)

Hold Spool File ('1' = yes)

Retain Print Field Value

 
DREAM WRITER VERSIONS:  
Enter the version for each program:

If left blank, ZJDE0001 will be used.

12. Name Search (P01200)

13. Manual Ck w/o Voucher Match (P04106)

14. Supplier Ledger Inquiry (P042003)

15. Void Payment (P04103)

16. A/R A/P Netting (P03455)

17. A/P Netting Void Payment (P04456)

 
EXCHANGE RATE:  
18. Enter a '1' to protect the Exchange Rate field.

If left blank, the Exchange Rate will not be protected.

 
ALTERNATE PAYMENT PROCESSING:  
19. Enter a '1' to display the alternate currency code field. If the currency code in this field does not match the currency code inquired upon, an alternate currency payment will be recorded.  
20. If alternate currency is turned on, enter a '1' to display the Foreign to Alternate Exchange Rate.

Blank (Default) will display the Alternate to Domestic Exchange Rate.