This chapter provides an overview of bank account setup and discusses how to:
Set up GL bank accounts.
Set up customer bank accounts.
Set up supplier bank accounts.
Set up bank account cross-references.
Print bank account exception reports.
Note. Country-specific functionality for back account setup exists for Denmark, Finland, Norway, Sweden, and Spain.
See Also
Setting Up Additional Bank Information for Foreign Suppliers
Entering A.E.B. Customer and Supplier Bank Information for Spain
You must set up bank account information if you process JD Edwards EnterpriseOne Accounts Payable payments or use specific JD Edwards EnterpriseOne Accounts Receivable applications, such as draft processing and auto debit processing. Depending on the type of information that you process, you must set up bank account information for your company's bank accounts, as well as for your customers and suppliers.
The system provides these programs for setting up bank account information:
Bank Account Information (P0030G).
Use this program to set up your company's bank accounts. If you process accounts payable payments or accounts receivable automatic debits, you must set up your company's bank accounts.
Bank Account Cross Reference (P0030A).
Use this program to set up bank account information for your suppliers and customers. If you process accounts payable payments using electronic funds transfer, you must set up bank account information for the supplier. If you process automatic receipts, accounts receivable drafts, or automatic debits, you must set up bank account information for the customer. You also use this program to associate a bank transit number with a bank address book record.
Note. Although the same program is used for Bank Account Cross-Reference and Bank Account Addresses applications, the system displays a different form based on which application you choose.
These programs update and store bank account information in the Bank Transit Master table (F0030). The system differentiates each bank account record using a record type. The record type not only identifies whether the bank account is for a supplier or customer; it is also used to differentiate customers who process drafts and automatic debits from suppliers who process automatic payments.
This table describes the available record types and how they are used:
Record Type |
Description |
B |
The system assigns this value to records created using the Bank Account Addresses program (P0030A). You use this program to associate bank transit numbers with the bank account address number. |
C |
The system assigns this value when you set up bank account information and specify the option for Customer using the Bank Account Cross Reference program (P0030A). |
D |
The system assigns this value when you set up bank account information and select the AR Drafts, Auto Debit option using the Bank Account Cross Reference program (P0030A). You must select this check box for customers who process drafts or auto debits. |
G |
The system assigns this value when you set up GL bank account information for your company using the Bank Account Information program (P0030G). |
H |
The system assigns this value when you set up Dutch bank accounts using the Dutch Payments Bank Information program (P74030H). |
M |
The system assigns this value when you set up bank account information by business unit using the Business Unit Information program (P0030B). |
P |
The system assigns this value when you set up bank account information and select the Auto Receipts Payor option using the Bank Account Cross Reference program (P0030A). |
V |
The system assigns this value when you set up bank account information and select the Supplier option using the Bank Account Cross Reference program. |
X, Y |
These codes are predefined for you to use if your supplier has multiple bank accounts. You do not need to use these specific codes (X or Y); you can set up and use any bank type code in the UDC table 00/BT that is not listed in this table. |
This section discusses how to set up GL bank account information.
Form Name |
FormID |
Navigation |
Usage |
Work With G/L Bank Accounts |
W0030GA |
Use one of these navigations:
|
Review and, if necessary, delete existing GL bank accounts. |
Set Up G/L Bank Account |
W0030GB |
On Work With G/L Bank Accounts, click Add. To revise an existing bank account record, select Revise from the Row menu. |
Set up and revise GL bank account information. |
Revise Bank Information |
W0030GC |
On Work With G/L Bank Accounts, select Bank Info from the Form menu. |
Revise bank information. To avoid the use of the pre-note code that is assigned to the supplier, verify that the Override Supplier Pre-Note check box is selected. |
Revise BACS Information |
W0030GD |
On Work With G/L Bank Accounts, select BACS Info from the Form menu. |
Revise BACS information. |
Work With Bank Account X12 Information |
W0030GE |
On the Work With G/L Bank Accounts form, select X12 Info from the Form menu. |
Revise bank account X12 information. |
Set Up Bank Account X12 Information |
W0030GF |
On Work With Bank Account X12 Information, click Add. To revise existing information, select Revise X12 Info from the Row menu. |
Set up or revise bank account X12 information. |
Access the Set Up G/L Bank Account form. This is the first of four forms that you access to set up GL bank account information.
Set Up G/L Bank Account Form
Next Payment Number |
Enter a number that represents the next payment number to be processed for the specified bank account. The system updates this field during Accounts Payable payment processing. |
Next Autodebit Number |
Enter the receipt number that the system will assign to the next automatic debit record that it generates for the specified bank account. The system updates this field incrementally, by one, when it generates an automatic debit record from the JD Edwards EnterpriseOne Accounts Receivable system. |
Number of Alignment Forms |
Enter the number of checks that are needed at the start of check printing for the printer operator to align the check stock properly. |
Detail Lines Per Stub |
Enter the number of detail lines that can appear on an AP payment stub. |
Revise Bank Information Form
Access the Revise Bank Information form.
Revise BACS Information Form
Access the Revise BACS Information form.
Set Up Bank Account X12 Information Form
Access the Set Up Bank Account X12 Information form.
Authorization Info Qualifier |
Enter a code to identify the type of information in the Authorization Information. |
Authorization Information |
Enter information used for additional identification or authorization of the interchange sender or the data in the interchange. The type of information is set by the Authorization Information Qualifier. |
Security Information |
Enter a value used for identifying the security information about the interchange sender or the data in the interchange; the type of information is set by the Security Information Qualifier. |
Security Info Qualifier |
Enter a code to identify the type of information in the Security Information. |
Interchange Sender ID |
Enter an identification code published by the sender for other parties to use as the receiver ID to route data to them; the sender always codes this value in the sender ID element. |
Interchange Receiver ID |
Enter an identification code published by the receiver of the data. When sending, it is used by the sender as their sending ID, thus other parties sending to them will use this as a receiving ID to route data to them. |
Application Sender's Code |
Enter a code identifying party sending transmission. These codes are agreed to by trading partners. |
Application Receiver's Code |
Enter a code identifying party receiving transmission. These codes agreed to by trading partners. |
After you enter customer address book information and customer master information, you can assign bank accounts to customers.
This section lists prerequisites and discusses how to set up customer bank account information.
Before you complete the tasks in this section:
(BEL) Verify that your customers have a country code that is equal to BE (Belgium) in the Address Book Master table (F0101).
The validation of the online bank account information is activated based on this key.
(FRA) Verify that your customers have a country code that is equal to FR (France) or a blank with FR in the second description of UDC table 00/CN.
The validation of the online bank account information validation is activated, based on the R.I.B. key.
Form Name |
FormID |
Navigation |
Usage |
Work With Bank Accounts By Address |
W0030AD |
Use one of these navigations:
|
Review bank accounts for a specific customer, if necessary, delete a customer bank account. |
Set Up Bank Accounts By Address |
W0030AA |
On Work With Bank Accounts by Address, click Add. To revise an existing bank account, select Revise from the Row menu. |
Set up or revise a customer bank account. |
Work With Bank Transit Addresses |
W0030AE |
Accounts Receivable Setup (G03B41), Bank Account Addresses |
Review a list of bank transit numbers by address number. |
Set Up Bank Transit Address |
W0030AB |
On Work With Bank Transit Addresses, click Add. |
Set up a bank transit number by address. |
Access the Set Up Bank Accounts By Address form.
The fields on the Set Up Bank Accounts By Address form are similar to those on the Set Up G/L Bank Account form.
See Setting Up GL Bank Account Information.
Address Number |
Enter the address book number of the bank account. This field, in combination with the record type, specifies the bank account for a specific record type. |
Supplier, Customer, A/R Drafts, Auto Debit, Auto Receipts Payor |
Select the record type that applies to the customer address number. |
Bank Transit Number |
Enter the number assigned to a particular bank by the Federal Reserve to facilitate the clearing of funds. You can leave this field blank. |
This section provides an overview of supplier bank accounts, lists prerequisites, and discusses how to:
Set up supplier bank account information.
(CAN, DEU, FIN, GBR, NOR, SWE, and USA) Set up country-specific supplier bank account information.
After you enter supplier address book information and supplier master information, you can assign bank accounts to suppliers. Businesses that use bank tape processing to transmit payments electronically must assign bank accounts to their suppliers. The system uses this information to identify the supplier's bank account when you pay vouchers by electronic funds transfer.
Before you complete the tasks in this section:
(BEL) Verify that your suppliers have a country code that is equal to BE (Belgium) in the Address Book Master table (F0101).
The validation of the online bank account information is activated based on this key.
(FRA) Verify that your suppliers have a country code that is equal to FR (France) or a blank with FR in the second description of the UDC table.
The validation of the online bank account information validation is activated, based on the R.I.B. key.
Form Name |
FormID |
Navigation |
Usage |
Work With Bank Accounts By Address |
W0030AD |
Automatic Payment Setup (G04411), Bank Account Cross-Reference |
Review bank accounts for a supplier or, if necessary, delete a supplier bank account. |
Set Up Bank Accounts By Address |
W0030AA |
On Work With Bank Accounts by Address, click Add. To revise an existing bank account, select Revise from the Row menu. |
Set up or revise a supplier bank account. |
Access the Set Up Bank Accounts By Address form.
The fields on the Set Up Bank Accounts By Address form are similar to those on the Set Up G/L Bank Account form.
See Setting Up GL Bank Account Information.
Address Number |
Enter the address book number of the bank account. This field, in combination with the record type, specifies the bank account for a specific record type. |
Supplier, Customer A/R Drafts, Auto Debit, Auto Receipts Payor |
Select the record type that applies to the address number. |
Bank Transit Number |
Enter the number assigned to a particular bank by the Federal Reserve to facilitate the clearing of funds. You can leave this field blank. |
Access the Set Up Bank Accounts By Address form.
(FIN, NOR, and SWE) Field-Specific Information
Record Type |
Select the Supplier option for Nordic payments. |
Bank Transit Number |
Use this field in connection with the Bank Account Number field. For domestic payments in Finland, a special relationship exists between the bank account number and the bank transit number. The last digit of the bank account number is a check-digit for the account number. If the account number is entered correctly, the program creates a "machine account number" in the Bank Transit Number field. This special modification for domestic payments in Finland is invoked when both the user's country code in User Preferences and the supplier's country code in the Supplier Master is Finland. |
Bank Account Number |
Enter the bank account number of the Bankgiro/Postgiro account number. |
Control Digit |
This field is not used for Nordic electronic payments. |
SWIFT Code |
Enter the SWIFT code for the supplier's bank, if required. |
Reference/Roll Number |
Enter the recipient's reference number. This field is not used for Nordic payments. (NOR): Enter the number provided by the DNB Telebank. (FIN): Enter the payee business code. |
This table lists the bank information that is required for suppliers in Nordic countries:
Payment To Country |
Bank Transit Number |
Account Number |
Control Digit |
SWIFT Code |
Domestic suppliers (FIN) Bank Finland |
Machine Account Number |
Account Number |
Blank |
Blank |
Domestic suppliers Bankgiro/Postgiro |
* |
Bankgiro or Postgiro Number |
Blank |
Blank |
Domestic suppliers (SWE) Bank Account - Sweden |
Code |
Account Number |
Blank |
Blank |
Note. All numbers must be entered consecutively without spaces. Avoid blanks or symbols such as dashes or periods.
(CAN, DEU, GBR, and USA) Field-Specific Information
Bank Transit Number |
Enter the bank transit number using an asterisk and the two-letter code followed by the numeric code. For example, enter *BL12345. For other foreign suppliers, enter the code without an asterisk. For domestic suppliers with Bankgiro or Postgiro accounts, enter an asterisk. For domestic suppliers whom you want to pay directly to a bank account, enter the bank transit number (clearingnummer) for the bank. |
Bank Account Number |
The routing or transit number is normally a part of the bank account number. Sometimes the number cannot be distinguished from the bank account number. If so, use the address number for the supplier, and include an asterisk before the figures. Enter the full account number (including the bank transit number) in this field. |
This table lists the bank information that is required for suppliers in different countries:
Payment To Country |
Bank Transit Number |
Account Number |
Control Digit |
SWIFT Code |
(DEU) Germany |
*BL + code |
Account Number |
BL |
Required |
(GBR) Great Britain |
*SC + code |
Account Number |
SC |
Required |
(USA) United States |
*FW + code |
Account Number |
FW |
Required |
(CAN) Canada |
*CC + code |
Account Number |
CC |
Required |
Other foreign suppliers |
Code |
Account Number |
Blank |
Blank |
Note. All numbers must be entered consecutively without spaces. Avoid blanks or symbols such as dashes or periods.
This section provides an overview of bank account cross-references and discusses how to set up a bank account cross-reference.
For payments, you must set up a cross-reference between the bank address in the Address Book Master table (F0101) and the bank account number in the Bank Transit Master table (F0030). The bank transit number is a key that links the bank address to the address number of the bank account. This cross-reference is used to print the name and address of the bank on the payment.
The system creates a record in the Bank Transit Master table (F0030) with the record type B.
Form Name |
FormID |
Navigation |
Usage |
Work With Bank Transit Addresses |
W0030AE |
Use one of these navigations:
|
Review a list of bank transit numbers by bank address. |
Set Up Bank Transit Address |
W0030AB |
On Work With Bank Transit Addresses, click Add. To change the address book number that is associated with a bank transit number, select Revise from the Row menu. |
Set up a bank transit number by address or revise the address for an existing bank transit number. |
Access the Set Up Bank Transit Address form.
Bank Transit |
Enter the bank transit number in this field. The number is the same one that you entered on the Set Up Bank Accounts by Address form. If the number contains an asterisk, the asterisk is a part of the number and is also entered. If the bank has not been set up in the address book, use the Address Book program (P01012) to set up the bank. The default search type in the Address Book for banks is V (vendors). |
This section provides overviews of the bank account and address book exception reports and discusses how to:
Print the Bank Account Exception Report.
Print the Address Book Exception Report.
The Bank Account Exception Report (R00310) verifies that the address book number for each supplier and customer bank record in the Bank Transit Master table (F0030) exists in the Address Book Master table (F0101). Any records that do not exist in the address book print on the report. The report bypasses any bank account records that have a blank address number.
This report does not update any information. If any records appear on this exception report, you must do one of these things:
Add the missing address book number to the Address Book Master table (F0101)
Remove the supplier or customer bank record from the Bank Transit Master table (F0030)
Note. This program does not have processing options.
The Address Book Exception Report (R00311A) lists any suppliers or customers in the JD Edwards EnterpriseOne Address Book that do not have corresponding bank account information (such as bank transit and account numbers) in the Bank Transit Master table (F0030). The system reviews suppliers only if their payment instrument is T or B.
This program does not update any information. If any records appear on the exception report, you must do one of these things:
Enter the missing bank account information using the Bank Account Cross-Reference program (P0030A).
Change the payment instrument for the supplier or customer to one that does not require bank account information.
This report does not have processing options.
Select one of these navigations:
Automatic Payment Setup (G04411), Bank Account Exception Report.
Accounts Receivable Setup (G03B41), Bank Account Exception Report.
Select one of these navigations:
Automatic Payment Setup (G04411), Address Book Exception Report
Accounts Receivable Setup (G03B41), Address Book Exception Report