(GBR) Setting Up Functionality for Great Britain

This chapter discusses how to:

See Also

(Europe) Setting Up European Union Functionality

Click to jump to parent topicSetting Up UDCs for Great Britain

Setting up Great Britain-specific UDCs enables you to use Great Britain-specific functionality. You also set up some base software UDCs with Great Britain-specific values.

Click to jump to top of pageClick to jump to parent topicSetting Up UDCs for CIS

Set up these UDCs before you process vouchers for the construction industry scheme (CIS).

Subcontractor Business Type (74U/SB)

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

CIS Taxable Status Codes (74U/TS)

Use CIS taxable status codes to indicate whether a line item on a voucher is subject to withholding tax.

CIS Voucher Status Codes (74U/VS)

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.

Click to jump to top of pageClick to jump to parent topicSetting Up UDCs for ACM for Great Britain

Before you enter and print certificates for application and certificate management (ACM), set up these UDCs.

ACM Status Codes (74U/AS)

Application and Certificate Management (ACM) status codes are assigned by the system at various stages of ACM processing to identify the current status of an ACM document. Some processes require that an ACM document be at a specific status.

ACM Voucher Return Codes (74U/VR)

You use ACM voucher return codes to indicate whether a CIS24 tax payment voucher has been returned for a payment.

Click to jump to parent topicSetting Up the System for BACS Payments for Great Britain

The following subsections describe the setup that is required for BACS processing.

Supplier Master

Set up suppliers with payment instrument B for EFT in the BACS format.

Payment Instrument Defaults (P0417)

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)

Bank Accounts by Address

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.

Bank Account Information (P0030G)

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

Click to jump to parent topicSetting Up Payment Formats for Great Britain

This section provides an overview of payment formats for Great Britain and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Payment Formats for Great Britain

JD Edwards EnterpriseOne software provides these payment formats for Great Britain:

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.

Working with the APACS Check Format

APACS is the governing body for check printing standards in Great Britain. Businesses in Great Britain 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:

In addition, the checks that you print comply with these APACS standards:

Technical Considerations for the APACS Check Format

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:

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.

Working with the BACS Format

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:

Click to jump to top of pageClick to jump to parent topicWriting Payments Using the BACS Format

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.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Create A/P Bank Tape - BACS - UK (R04572B)

Processing options enable you to specify the default processing for programs and reports.

Transfer

1. File ID (file identification)

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.

BACS

1. BACS Bureau Number (FUTURE)

This processing option is not used.

2. Euro Currency Code

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.

Tape

1. Device Name

Specify the tape dump device. Enter a valid dump device name from UDC 97/DD.

Remittance

This processing option is reserved for future use.

1. Address Format ID (FUTURE)

This processing option is not used.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Print Automatic Payments - Cheque - UK (R04572U1)

Processing options enable you to specify the default processing for programs and reports.

Payee

Payee Name

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.

Payee Address

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.

Address

Address Format ID (FUTURE)

This processing option is not used.

Print

Forms Type (FUTURE)

This processing option is not used.

Amount

Program ID

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.

String or Boxes

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

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Print A/P Payment Attachment - UK (R04573U)

Processing options enable you to specify the default processing for programs and reports.

Purchase Order

Invoice or Purchase Order

Enter 1 to print the purchase order number on the stub instead of the supplier invoice number.

Print Option

Remark

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.

Click to jump to parent topicSetting Up Automatic Debit Formats for Great Britain

This section provides an overview of automatic debits for Great Britain and discusses how to set processing options for Great Britain Bank File and Statement Diskette (R03B575GB).

See Also

Processing Automatic Debits

Click to jump to top of pageClick to jump to parent topicUnderstanding Automatic Debits for Great Britain

Businesses in Great Britain 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 Great Britain.

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 Great Britain.

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:

When creating and processing automatic debit batches for Great Britain, 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.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Great Britain Bank File and Statement Diskette (R03B575GB)

Processing options enable you to specify the default processing for programs and reports.

Default

Print Customer Statement

Specify whether a 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.

Tape Density

Specify the tape density.