This chapter contains the following topics:
Section 3.2, "Setting Up the System for BACS Payments for the United Kingdom"
Section 3.3, "Setting Up Payment Formats for the United Kingdom"
Section 3.4, "Setting Up Automatic Debit Formats for the United Kingdom"
Setting up the UDCs for the United Kingdom enables you to use the localizations for the United Kingdom. You also set up some base software UDCs with specific values for use with localizations.
Set up these UDCs before you process vouchers for the construction industry scheme (CIS).
The JD Edwards EnterpriseOne software provides hard-coded values for this UDC table to enable you to specify the supplemental CIS functionality to enable. You select from the values in this UDC table when you set up the supplemental constants using the CIS Supplemental Constants program (P74U0402).
See Understanding Constants for Supplemental CIS Functionality
Values are:
| Codes | Description | Description 2 |
|---|---|---|
| 1 | Base CIS | CIS Flow |
| 2 | Option To Classify Work/Ops | CIS Supplement |
| 3 | Voucher Splitting | CIS Supplement |
| 4 | VCHR Split - Opt to Classify | CIS Supplement |
The JD Edwards EnterpriseOne software provides hard-coded values for this UDC table. You use the values in the 74U/IO UDC table to classify work or operations so they can be defined as included or excluded from the CIS. You select from the values in this UDC table when you enter purchase orders for subcontracts.
The system enables the classification of work or operations only when you set the CIS Process Flow constant in the supplemental CIS constants to 2 or 4.
See Understanding Constants for Supplemental CIS Functionality.
You use the values in the 74U/SB UDC table to specify the type of business entity for your subcontractor. Values are:
| Codes | Description 01 |
|---|---|
| C | Company |
| P | Partnership |
| S | Sole trader |
| T | Trust |
Use CIS taxable status codes to indicate whether a line item on a voucher is subject to withholding tax.
The JD Edwards EnterpriseOne software provides hard-coded values for this UDC table. The system assigns CIS status codes at various stages of CIS processing to identify the current status of a document. Some processes require that a document be at a specific status.
|
Note: Codes P, R, and Z are not used for the new CIS scheme effective beginning in 2007. |
Three additional status codes have been added to this UDC table to process vouchers using the supplemental CIS functionality. The system uses codes S and B for voucher splitting, and code X for CIS exclusion.
Values are:
| Codes | Description |
|---|---|
| (blank) | Voucher Entered/Created |
| B | Voucher split |
| C | CIS Payment Validation Run |
| D | Related F0411 File Deleted |
| M | Monthly Return Run |
| P | CIS25 Voucher Printed |
| Q | Cheque/BACS produced |
| R | CIS24 Voucher Returned |
| S | Payment Statement Printed |
| T | Corresponding Payment Record |
| V | Void |
| W | Withholdings Run |
| X | Outside CIS Scheme |
| Z | End of Year Return Run |
Before you can process payments using the SPC process, you must set up values for these UDC tables:
You set up additional ledger types for SPC if you want to write retention, MCD (main contractor discount), and commitment amounts to specific ledgers.
Set up values in this UDC table for the document types that you use when you enter purchase orders for the JD Edwards EnterpriseOne SPC module. The system uses the values in this UDC code to determine whether to launch the Requisition Template Answers Revisions program (P74U4321) after you enter additional information for the purchase order in the SPC-specific forms. You must also set a processing option in the Purchase Order SPC Additional Information Header program (P74U4312) or Purchase Order Detail SPC Additional Information program (P74U4316) to cause the system to launch the Requisition Template Answers Revisions program.
Examples of values are:
| Codes | Description |
|---|---|
| 09 | Requisition |
| OC | Contract orders |
The JD Edwards EnterpriseOne system provides hard-coded values that you use to specify whether a subcontract purchase order is a labor-only contract.
Values are:
| Code | Description |
|---|---|
| L | Labour only |
| N | Not labour only |
Set up values in this UDC table to identify the type of letter that you send. You use the codes that you set up in this UDC table when you set up the late authenticated receipt letter in the Authenticated Receipt Letter Set-up program (P74U0431).
Set up values in this UDC code to associate with purchase orders. You use the values to specify if a purchase or is included in the CIS. The system gives you the option to associate a value from this UDC table to a purchase order only when you set up the supplemental CIS constants to enable the inclusion or exclusion of a purchase order.
The system uses the value in the Special Handling Code field to determine whether to include or exclude a purchase order from the CIS. The system excludes from CIS purchase orders that have an associated code in which the value EXC appears in the Special Handling Code field. If the Special Handling Code field is blank, the system includes the purchase order in the CIS.
Examples of values are:
| Codes | Descriptions | Special Handling Code |
|---|---|---|
| Excluded | Exclude | EXC |
| Included | Include | (blank) |
| SitePrep | Site Preparation | (blank) |
The JD Edwards EnterpriseOne system provides hard-coded values for this UDC table. You assign a value in the CIS supplemental constants to specify the order in which the system calculates retention and MCD. You enter a value in the SPC constants.
Values are:
| Codes | Description |
|---|---|
| M | MCD, Retention, VAT |
| R | Retention, MCD, VAT |
Set up values in this UDC table for the order types that you use to enter purchase orders for the subcontractor payment control module. The system launches the additional information forms for only the purchase orders assigned a document type that exists in this UDC table.
The JD Edwards EnterpriseOne system provides hard-coded values for this UDC table. The system assigns a value from this UDC table when it processes records in the CIS Pre-Withholding Validation program (P74U4030A). Values are:
| Codes | Description |
|---|---|
| Blank | Generated |
| C | Certificate entered |
| P | Payment |
| R | Reverse |
| V | Voucher Created |
The following subsections describe the setup that is required for BACS processing.
Set up suppliers with payment instrument B for EFT in the BACS format.
Set up payment instrument B to use these programs:
| Format | Program |
|---|---|
| Payments | P04572B (Produce Bank Tape - BACS) |
| Payment Register | P04576 (Payment Register - Standard) |
| Attachments | P4573U (Print Attachments - UK) |
| Debit Statements | P04574 (Print Dbt Statement - Standard) |
Set up bank account information according to this example:
| Field | Description |
|---|---|
| Record Type | Choose Supplier. |
| Bank Transit Number | Enter the sorting code (six digits without spaces or dashes). |
| Bank Account Number | Enter eight to ten digits without spaces or dashes. |
| Control Digit | Enter 00 (two zeros). |
| Description | Enter the name of the bank account. |
| Checking or Savings Account | Enter the type of account (optional). |
| Swift Code | This field is optional. |
| Reference/Roll Number | This field is required if the payment is made to a building society. All customers of a building society have the same sort code and account number. The value that is entered in the Reference/Roll Number field specifies which actual account is used. |
This example shows how the values that are entered on the Set Up Bank Accounts By Address form populate the Bank Transit Master (F0030) and Bank Account/Supplier Number Worktable (F0030W) tables.
| Field | Description |
|---|---|
| Record Type | Supplier |
| Bank Transit Number | 601613 |
| Bank Account Number | 31926819 |
| Control Digit | 00 |
| Description | Lloyds |
| Checking or Savings Account | Blank |
| SWIFT Code | Blank |
| Reference/Roll Number | Blank |
The system populates the F0030 table like this:
| AYBKTP | AYTNST | AYBNK | AYAN8 | AYDL01 |
|---|---|---|---|---|
| V | 601613 | 31926819 | 22699 | Lloyds |
The system populates table F0030W like this:
| AXAN8 | AXBKTP |
|---|---|
| 22699 | V |
|
Note: When you import bank account information directly into the F0030 table, you must also populate the F0030W table. |
Set up the bank account from which BACS payments are made.
BACS payments and paper check payments can be made from the same bank account. However, the Next Payment Number field on the Set Up G/L Bank Account form is used only for paper check payments.
From the Set Up G/L Bank Account form, select Bank Info from the Form menu, and then enter this information on the Revise Bank Information form:
| Field | Description |
|---|---|
| Address Book Number | You can set up the bank account in the address book record. This value is optional. |
| Override Supplier Pre-Note Code | Clear this option. This option is not used for BACS payments. |
| Float Days | You can calculate the float days by subtracting the deposit date from the check date. The system adds the float days to the check date to populate the Date - Cleared/Value field (VLDT) in the F0413 table. |
From the Set Up G/L Bank Account form, select BACS Info from the Form menu, and then enter this information on the Revise BACS Information form:
| Field | Description |
|---|---|
| Bank User Number | Enter the six-digit number that was supplied by BACS. |
| Reference/Roll Number | Enter the reference number that was supplied by BACS. |
| Bank Reference Name | Enter the description that you want to appear on the recipient's bank statement. |
|
Important: These fields must be completed correctly for the BACS payment to process successfully. |
This example illustrates how the values that are entered on the Revise BACS Information form populate the F0030 table.
| Field | Description |
|---|---|
| G/L Bank Account | 1.1110.BEAR |
| Description | Bear Creek National Bank |
| Bank User Number | 777777 |
| Reference/Roll Number | 88888888 |
| Bank Reference Name | MIDLAND |
The system populates the F0030 table like this:
| AYBKTP | AYTNST | AYBNK | AYDL01 | AYRLN | AYBACS | AYRFNM |
|---|---|---|---|---|---|---|
| AYBACSG | 555555 | 66666666 | Bear Creek | 88888888 | 777777 | Midland |
This section provides an overview of payment formats for the United Kingdom and discusses how to:
Write payments using the BACS format.
Set processing options for Create A/P Bank Tape - BACS - UK (R04572B).
Set processing options for Print Automatic Payment - Cheque - UK (R04572UI).
Set processing options for Print A/P Payment Attachment - UK (R04573U).
JD Edwards EnterpriseOne software provides these payment formats for the United Kingdom:
| Format | Description |
|---|---|
| P04572B | Electronic funds transfer (EFT) in the Bankers Automated Clearing System (BACS) format (tape or diskette) |
| P04572U1 | Checks in the Association for Payment Clearing Services (APACS) format. |
|
Note: All dates for the BACS table are written in a BYYDDD format, according to the standards required by BACS. In this required format, B represents one blank space, YY is the last two digits of the year, and DDD is the Julian date (the number of days that have passed since noon on January 1) in the year.For example, December 31, 2005, is written to the table as 05365 because December 31 is the 365thday of the year. |
APACS is the governing body for check printing standards in the United Kingdom. Businesses in the United Kingdom are required to issue checks according to the most current APACS standards.
You can use JD Edwards EnterpriseOne localized software to print checks that are formatted to APACS standards. As required by APACS, when you use the localized Print Automatic Payments - Cheque - UK program (R04572U1), you can use processing options to specify:
Whether the payee name prints above or below the amount in words.
Whether to print or omit the payee's address on the check, such as for use in a window envelope.
Whether to print the amount (in words) in boxes or as one string.
The translation program that you want the system to use to print the amount in words.
In addition, the checks that you print comply with these APACS standards:
The payee name field is completed by a string of asterisks.
The amount printed in figures is prefixed and suffixed by asterisks.
A hyphen prints in place of the decimal character.
Thousands separators are omitted from the amount that is printed in figures.
When you write APACS checks, verify that processing options 5 and 6 of the Print Automatic Payments - Cheque - UK program (R04572U1) correspond to each other.
JD Edwards EnterpriseOne software supplies these translation programs, which you can specify in processing option 5:
X00500U1: Prints numeric values as words in boxes.
X00500U: Prints numeric values as words in a string.
For example, if you enter translation program X00500U1 in processing option 5, leave processing option 6 blank to print the check amount in boxes. Similarly, if you enter translation program X00500U in processing option 5, enter a 1 in processing option 6 to print the check amount in a string.
When you write payments using the BACS format, the system:
Populates the A/P Payment Tape table (F04572OW).
You can view the data written by the Write process here, but Oracle recommends that you do not transfer this data to the media that you use to send the information to your bank because the data will not be formatted correctly.
Populates the Text Processor Header (F007101) and Text Processor Detail (F007111) tables.
You can use the Text File Processor program (P007101) to copy the data from the text processor tables to the media that you send to your bank. The data that you copy from the text file processor tables will be in the correct format for submission to banks.
Generates a summary PDF.
The PDF includes a batch number, which you can use to locate the data in the text file processor tables.
When you write payments using the BACS format from the Work with Payment Groups program, the system populates the A/P Payment Tape table (F04572OW) as shown in this table:
| Field | Description |
|---|---|
| KNMID | The member ID. The system populates this field using the next number for system 04, line 6. |
| KNLNID | The line number. |
| KNFNAM | The file name. For BACS processing, this is F04572B. |
The KNAPTA field includes this payment information:
Line 1: VOL 1 (volume header label).
Line 2: HRD 1 (first file header label).
Line 3: HRD 2 (second file header label).
Line 4: UHL 1 (user header label).
Line 5: Account information, one line per account.
Line 6: Account information, one line per account.
Line 7: EOF 1 (first end-of-file).
Line 8: EOF 2 (second end-of-file).
Line 9: UTL 1 (user trailer label).
|
Note: This description of the KNAPTA is based on a nine-line payment file. An actual payment file will be a different length, based on how many account information lines it has. |
When you write payments using the BACS format, use the following guidelines when completing the Write Payments form:
| Field | Value |
|---|---|
| Next Payment | This field does not apply to BACS payments; it is used only for paper check payments. The system supplies this value from the Setup G/L Bank Account form. |
| Proc Date (Processing Date) | Enter the date that the file will be sent to the bank and processed by the BACS system. |
| Expir Date (Expiration Date) | Enter the date after which the file is out-of-date and should not be processed. |
Processing options enable you to specify the default processing for programs and reports.
Specify a number from 1 to 9 for the system to use for the File ID modifier. This number is used to distinguish among multiple files created on the same date. If you leave this processing option blank, the system uses the default value of 1.
This processing option is not used.
Specify the currency code that represents the euro in your system. When the payment currency code equals the currency code specified in this processing option, the user header label in spaces 20 and 21 is populated with 01 to indicate that the currency is euro. If the payment currency code does not equal the currency code specified in this processing option, the user header label is populated with 00.
Specify the character value for positions 32 to 35 of DATA Detail Records.
Leave this processing option blank to complete the field with zeros. Enter 1 to complete the field with blank spaces. Enter 2 to complete the field with a special characters last option, enter it in the Special Character field.
Specify the character value for positions 32 to 35 of CONTRA Detail Records.
Leave this processing option blank to complete the field with zeros. Enter 1 to complete the field with blank spaces. Enter 2 to complete the field with a special characters last option, enter it in the Special Character field.
Specify the tape dump device. Enter a valid dump device name from UDC 97/DD.
This processing option is reserved for future use.
This processing option is not used.
Processing options enable you to specify the default processing for programs and reports.
Enter 1 to print payee name above the amount in words. If you leave this processing option blank, the system prints the payee name below the amount in words.
Enter the override address format. If you leave this processing option blank, the system uses the country format associated with the country in the address book record for the payee.
This processing option is not used.
This processing option is not used.
Enter the program name to translate payment amounts from numbers to words. the value that you enter must exist in UDC 98/CT. If you leave this processing option blank, the system uses the translation program associated with the payment currency code.
Enter 1 to print the amount in words in one string (X00500U). If you leave this processing option blank, the system prints the words in separates boxes (X00500U1).
Processing options enable you to specify the default processing for programs and reports.
Enter 1 to print the purchase order number on the stub instead of the supplier invoice number.
Enter 1 to print the supplier name. Enter 2 to print the supplier invoice number. Leave this processing option blank to print the remark on the pay stub.
This section provides an overview of automatic debits for the United Kingdom and discusses how to set processing options for the Great Britain Bank File and Statement Diskette (R03B575GB).
Businesses in the United Kingdom automatically debit customer bank accounts using EFT. Transfers must adhere to the standards that are set by the BACS. Businesses can send transfer information to the bank using modem, tape, or diskette.
You can use the standard automatic debit process to meet the requirements of the United Kingdom.
The JD Edwards EnterpriseOne system provides Great Britain Bank File and Statement Diskette (R03B575GB) format for automatic debits.
The program generates a bank table that adheres to the banking standards for automatic debits in the United Kingdom.
To process the automatic debit, the BACS processing date and the expiration date of the debit must be actual workdays. In addition, common business practice is to:
Send statement reports to customers regarding the debit.
Identify customers who have agreed to the automatic debit process.
Select invoices that are due to customers.
Validate the processing and expiration dates against a workday calendar.
Generate debit information in the BACS format.
Generate statement reports for applicable customers.
Update customer accounts after collecting the appropriate funds.
When creating and processing automatic debit batches for the United Kingdom, the system validates the BACS processing date against the workday calendar that you specify in the processing options. If the date is not a workday, the system searches for a valid workday, based on the workday calendar that you specify in the processing options, and increments the date by one day until it reaches the next valid workday.
The system issues a warning message to indicate that the day you entered is not a workday.
|
Note: If you do not set up and specify a workday calendar, the system uses the BACS processing date without performing the necessary validation. |
The system calculates the BACS expiration date, based on the value that you enter in processing option 15 on the BACS tab of the Process Automatic Debits program. To calculate the expiration date, the system uses the BACS processing date that is written to the BACS table and then adds the number of days that you specify in the processing option.
|
Note: You must use the Supplier Master program (P04012) to create supplier master records for the customers for whom you submit automatic debits. |
The first time that you submit automatic debits for a specific customer, you submit a first claim rather than a standard claim. The first-claim status indicates to the bank that you are verifying the bank account information for the automatic debit. No transfer of funds occurs with a first claim. After you have verified the bank account information for a customer, you submit automatic debits for that customer as standard claims.
To submit a first-claim automatic debit for a customer, select the Pre-Note Code option on the Supplier Master Revision form. Selecting the Pre-Note Code option for a customer indicates that any electronic funds transfer, including automatic debits, should be processed as a first claim.
|
Important: After you have processed the first claim automatic debits and the bank has approved the customer for automatic debits, you must clear the Pre-Note Code option on the Supplier Master Revision form for that customer so that Great Britain Bank File and Statement Diskette program can correctly process automatic debits. |
Processing options enable you to specify the default processing for programs and reports.
Specify whether the system prints customer statements for automatic debits. Values are:
Blank: Print customer statements only when the number of invoice detail lines exceeds the maximum number that the format allows.
1: Print customer statements for automatic debits.
Specify the tape density.