33 Banking Requirements Processing Options

This chapter contains these topics:

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

  

33.2 A/P Payments - German Bank Tape (P04572G1)

Processing Option Processing Option Requiring Further Description
ELECTRONIC FUNDS TRANSFER:  
1. Enter the city of origin.  
BANK TAPE:  
2. Enter the following default values:

Device Name

Tape Density

Label Name

New Volume Name

New Owner ID

Tape File Name

  

33.3 A/P Payments - German Diskette (P04572G2)

Processing Option Processing Option Requiring Further Description
ELECTRONIC FUNDS TRANSFER:  
1. Enter the city of origin.  
BANK TAPE:  
2. Enter the following default values:

Device Name

Tape Density

Label Name

New Volume Name

New Owner ID

Tape File Name

Block Size

  

33.4 A/P Payments - German Checks (P04572G3)

Processing Option Processing Option Requiring Further Description
TRANSLATION PROGRAM:  
1. Enter the program name to translate payment amounts from numbers to words. (See User Defined Codes system code '98', record type 'CT' for program names.)

If left blank, the translation program associated with the payment currency code will be used.

  
ADDRESS FORMAT:  
2. Enter an override address format to use for the payee and/or company addresses.

If left blank, the country format will be used.

  
PRINT INFORMATION:  
3. Enter the Forms Type for the Payments Spool File.

If left blank, the default is 'APCHECKS'.

  

33.5 Print Payments - Z1 Diskette Format (P04572G5)

Processing Option Processing Option Requiring Further Description
ELECTRONIC FUNDS TRANSFER:  
1. Enter the city of origin.  
WAY BILL INFORMATION:  
2. Label Name  
RECORD 'R' INFORMATION  
3. Regional Central Bank Area Codes (2 digit)

Principals Company Code (5 digit)

Principals Industrial Classification (3 digit)

  
4. Enter the LZB file to use, if left the default file 74/LA will be used.

System Code.

User Defined Codes

  

33.6 A/P Payments - German Register (P04572T)

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 ID Number

'3' = 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 check print program to use if the pre-note status is set to 'P', requiring a check print.  
BANK TAPE:  
6. Enter the following default values:

Device Name

Tape Density

Label Name

Blocksize

New Volume Name

New Owner ID

File Name

  

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

  

33.8 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 pre-note 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.  

33.9 Auto Debit - German Disk Format (P03575DD)

Processing Option Processing Option Requiring Further Description
ABBUCHUNGEN V. LASTSCHRIFTEN:  
1. Enter a '1' if the automatic debits are to be created as Abbuchungen.

If left blank, Lastschriften records will be created.

  

33.10 Processing Automatic Debits (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.

  
COPY TO TAPE/DISKETTE:  
12. 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).

  
13. 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:  
14. 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:  
15. 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:  
16. Enter a '1' to purge the Batch Receipts Workfile (F0312) upon run completion.

If left blank, the file will not be purged.

  
17. 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:  
18. Enter a '1' if processing BACS. A report message will be issued if the processing date is a non-workday.  
19. Enter the BACS processing date.  
20. Enter the number of days to add to the processing date. This is used to calculate the BACS expiration date.  
21. Enter the workday calendar to use for validating the processing and expiration dates.  
MINIMUM AND MAXIMUM FOR BACS CREDITS:  
22. Enter the MINIMUM CREDIT amount which is to be selected for payment via Automatic Debits. Amounts under this amount will not be selected.  
23. 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.

  

33.11 General Ledger Post (P09800)

Processing Option Processing Option Requiring Further Description
BATCH SELECTION:  
1. Enter Batch Number

or Batch Date

or Batch User ID

  
PRINT SELECTION:  
2. Identify how to print amount fields on Post Journal:

'1' = to Millions (w/ commas)

'2' = to Billions (w/o commas)

Blank (Default) = No Journal Printed.

  
3. Identify which account number to print on report:

'1' = Account Number

'2' = Short Account ID

'3' = Unstructured Account

'4' = (Default) Number Entered During Input

  
FIXED ASSETS:  
4. Enter a '1' to post F/A entries to Fixed Assets.

Note: DREAM Writer version ZJDE0001 of Post G/L Entries to Assets (P12800) is executed when this option is selected. All transactions selected from that DREAM Writer will be posted rather than just the current entries being posted to G/L.

  
5. Enter a 'Y' if you wish to explode parent item time down to the assembly component level. Component billing rates will be used. (This applies to batch type 'T' only.)  
CASH BASIS ACCOUNTING:  
6. Enter a '1' to create and post Cash Basis accounting entries.  
7. Enter units ledger type for Cash Basis Accounting entries.

Default of blank will use "ZU" ledger type.

  
ACCOUNTING FOR 52 PERIODS:  
8. Enter a '1' for 52 Period Post.

Note: DREAM Writer data selection is used for 52 period posting ONLY. It is NOT used for the standard post to the F0902. Additionally, 52 period date patterns must be set up.

  
TAX FILE UPDATE:  
9. Identify when to update the Tax Work file (F0018):

'1' = V.A.T. or Use Tax only

'2' = for All Tax Amounts

'3' = for All Tax Explanation Codes

Blank (Default) = No Update to File.

Note: When using Vertex Taxes the Vertex Tax Register file will be updated instead of the Tax Work file for methods '1', '2', and '3'.

  
10. Adjust VAT Account for Cash Receipt Adjustments and Write Offs. Tax explanation must be a 'V'.

'1' = update VAT amount only

'2' = update VAT amount, extended price and taxable amount

  
11. Adjust VAT Account for Discount Taken. The Tax Rules file must be set to Calculate Tax on Gross Amount, including Discount and Calculate Discount on Gross Amount, including Tax. Tax explanation must be a 'V'.

'1' = update VAT amount only

'2' = update VAT amount, extended price and taxable amount

  
PROPERTY MANAGEMENT:  
12. Enter DREAM Writer version of Property Management G/L Transaction Creation to be executed.

Default is version ZJDE0001. (This applies to batch types '2' and '/'.)

  
UPDATE OPTION:  
13. Enter '1' to update short ID number, company, fiscal year/period number, century, and fiscal quarter in unposted transaction records selected for posting. (May be required for custom input programs.)  
REPORT FORMAT:  
14. Enter a '1' to print the Posting Journal in a 198 character format.

The default of blank will print the format with 132 characters.

  
DETAILED CURRENCY RESTATEMENT:  
15. Enter a '1' to create currency restatement entries. This creates records in the XA, YA, and/or ZA ledgers depending on the version you are running.  
16. Enter the version of the Detailed Currency Restatement (P11411) to execute.

Default of blank will execute ZJDE0001.

  
RECONCILIATION FILE PROCESSING  
17. Enter a '1' to update the Cross-Environment Reconciliation file. Blank will not update the reconciliation file.

Note: The Cross-Environment Reconciliation file can also be updated through the stand-alone Cross-Environment File Creation program.

  
REVERSING JOURNAL ENTRIES:  
18. When normal number of periods = 12 or 13 and posting a reversing entry into period 12 or 13, enter a '1' to create reversing journal entries to the first period of the following year. This is to avoid posting reversing entries to an adjusting period.

Example:

Normal number of periods = 12.

Period 12 ends 12/30/xx and period 13 ends 12/31/xx.

Journal Entry date of 12/30/xx will post reversing entry to period 01 of next year if processing option is set to '1'.

  
SKIP SUSPENDED TAX POST  
19. Enter a '1' to bypass automatic submittal of the Suspended VAT post.  
BATCH TYPE SELECTION:  
Note: This option should NOT be changed by User.  

33.12 Copy Tape File to Tape (P03579)

Processing Option Processing Option Requiring Further Description
AUTOMATIC DEBITS VERSION:  
1. Enter the version number of the Automatic Debits for which the Copy to Tape/Diskette is to be performed.  
COPY TO TAPE OPTIONS:  
2. Enter the tape unit to which the Automatic Debits file is to be copied.

Tape Unit:

Tape Density:

Tape Volume ID:

Tape Owner ID:

Tape File Name:

  
PC FILE DOWNLOAD:  
3. If generating a PC file, enter the file name to be used and the library name where the file will be placed.

File Name:

Library Name:

File Size:

Austrian Diskette = 120

German Diskette = 128

German Tape = 523

BACS Tape = 100

Swiss Diskette = 128

Swiss Tape = 530

  
COUNTRY SPECIFIC FORMATTING OPTIONS  
4. Enter the country-specific program that will perform the copy to tape or the creation of the diskette file.

P03579DT - German Tape (Variable Length)

  

33.13 Load Custom 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.