1. Objective and Scope

This OP shows how to maintain bank details for APAC countries. This is performed in PF1_050 for standard and miscellaneous vendors. Employee vendors will need to maintain bank details in productions system either PF1_020 or WP1_400 directly.

**Please note that there are few cases that vendor’s country might be different from bank’s country. Countries in this OP is based on bank’s country location not vendor location.

2. Context and definitions

In order to update bank account into vendor, there are mandatory requirement you will need to have.

- Supporting document for bank details: it is provided by requester via Vendor workflow or FreshDesk)

- Bank county: the location of bank which can be same as or different from vendor’s country

- Bank control key/bank key: it is a code to represent bank name, bank branch, SWIFT code and mandatory fields that is required to make payment successfully. Each country has its own codification

- Bank account

- Account holder: this is a beneficially name of bank account. It can be different from vendor name

- Account key: this field is for JP vendor

- Partner bank type: This the field indicating currency to be paid for that bank account

3. How to find PRS vendor code

Due to the fact that RCS vendor code might be different from PRS vendor code. Especially, the existing vendor code. Some requesters might advise RCS vendor code so you need to find PRS vendor code to update bank details in PF1_050. There are several ways to find PRS vendor code from RCS vendor code.

3.1 Find RCS vendor code from WP1_400

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-35-11.png

#	Main activities	Tips/Best practices	Key points
1	Select “ERP – Production – WP1” by double clicking on the ERP – Production icon

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-35-27.png

#	Main activities	Tips/Best practices	Key points
2	Click or press “Enter” on keyboard”

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-35-43.png

#	Main activities	Tips/Best practices	Key points
3	Insert T-code “XK03” and press “Enter” on your keyboard

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-36-9.png

#	Main activities	Tips/Best practices	Key points
4	Insert RCS vendor code in ‘Vendor’ field
5	Insert tick mark on ‘Address’ field and press “Enter” on your keyboard

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-36-31.png

#	Main activities	Tips/Best practices	Key points
6	Click

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-39-48.png

#	Main activities	Tips/Best practices	Key points
7	Click “Solvay Cross.Reference” tab	You can see PRS vendor code for this vendor

3.2 Find RCS vendor code from PF1_050

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-40-9.png

#	Main activities	Tips/Best practices	Key points
1	Select “ERP – Production – PF1” by double clicking on the ERP – Production icon

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-40-47.png

#	Main activities	Tips/Best practices	Key points
2	Click

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-43-8.png

#	Main activities	Tips/Best practices	Key points
3	Put T-code “xk02” and press “Enter” on the keyboard

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-43-22.png

#	Main activities	Tips/Best practices	Key points
4	Click to expand the search

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-43-41.png

#	Main activities	Tips/Best practices	Key points
5	Click
6	Select “L: Vendor by country and Duns and Cross reference”

Data Operations > APAC - Vendor bank account maintenance > image2019-6-4_17-43-59.png

#	Main activities	Tips/Best practices	Key points
7	Put RCS vendor code in “RCS vendor code”
8	Click

Data Operations > APAC - Vendor bank account maintenance > image2019-6-4_17-44-27.png

#	Main activities	Tips/Best practices	Key points
9	PRS vendor code will be in 'Vendor'

4. Bank details maintenance

4.1 Thailand and Korea

Data Operations > APAC - Vendor bank account maintenance > image2019-6-4_17-45-53.png

#	Main activities	Tips/Best practices	Key points
1	Select “ERP – Production – PF1” by double clicking on the ERP – Production icon

Data Operations > APAC - Vendor bank account maintenance > image2019-6-4_17-46-24.png

#	Main activities	Tips/Best practices	Key points
2	Click

Data Operations > APAC - Vendor bank account maintenance > image2019-6-4_17-46-56.png

#	Main activities	Tips/Best practices	Key points
3	Put T-code “xk02” and press “Enter” on the keyboard

Data Operations > APAC - Vendor bank account maintenance > image2019-6-4_17-47-25.png

#	Main activities	Tips/Best practices	Key points
4	Put “PRS” vendor code in 'Vendor' field
5	Put tick mark on ‘Payment transactions’ and press “Enter” on your keyboard

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-44-43.png

#	Main activities	Tips/Best practices	Key points
6	Put bank country in Ctry	If you are doing on TH bank , please put TH If you are doing on KR bank, please put KR
7	Click blank field in ‘Bank Key’
8	Click

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-45-15.png

#	Main activities	Tips/Best practices	Key points
9	Click

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-45-29.png

#	Main activities	Tips/Best practices	Key points
10	Double click on name of bank you want	Once you double click on the chosen bank key, the bank key will automatically appear in ‘Bank key’ field	Codification of TH bank key is always 7 digits of number

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-45-44.png

#	Main activities	Tips/Best practices	Key points
11	Put bank account in ‘Bank Account’ field		You can find bank number from the supporting document
12	Put currency n ‘BnkT’ field	Format will be currency + number e.g. THB1 or KRW1 New bank details will always end with 1	BnkT is a running code If there is THB1 in the system, you need to change THB1 to THB2 and update new bank as THB1 It can be other currencies such as USD1, EUR1, etc. depending on currency in purchasing organization
13	Click to save

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-46-1.png

#	Main activities	Tips/Best practices	Key points
14	The system will show status to confirm bank details have been maintained

4.2 China

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-47-25.png

#	Main activities	Tips/Best practices	Key points
1	Select “ERP – Production – PF1” by double clicking on the ERP – Production icon

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-47-40.png

#	Main activities	Tips/Best practices	Key points
2	Select Client “050” by clicking

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-52-8.png

#	Main activities	Tips/Best practices	Key points
3	Put T-code “xk02” and press “Enter” on the keyboard

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-52-29.png

#	Main activities	Tips/Best practices	Key points
4	Put “PRS” vendor code in 'Vendor' field
5	Tick only “Payment transactions” and press “Enter” on your keyboard

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-53-5.png

#

Main activities

Tips/Best practices

Key points

6

Insert “CN” in Ctry

7

Put “Bank key” in Bank key field

CN bank keys are in the sheet APAC CN bank key

If you cannot find bank key in the google sheet

It can be 2 scenarios:

1. The bank key has not created in SAP system. You will need to create bank key

2. The bank key was created in SAP system but details are not updated, you will need to update the correct CN name and CNAPs code which are mandatory for CN bank key

The correct bank key format is country + the first 4 digits of SWIFT code + 5 digits of running number

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-53-29.png

#	Main activities	Tips/Best practices	Key points
8	Put bank account in “Bank Account” field	If the length of bank account is longer than 18 digits, please put extra digit from 19^th in “Reference details” field #8a
9	Insert beneficiary name in “Acct holder” field	Normally, it is vendor’s name in CN version If it is cross boarder payment, it can be EN version
10	Insert “CNY1” in “BnkT” field	BnkT is a running code so if there is CNY1 in the system, you can use CNY2 in the system It can be other currencies such as USD1, EUR1, etc. depending on currency in purchasing organization
11	Click to save

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-53-57.png

#	Main activities	Tips/Best practices	Key points
12	The system will show status to confirm bank details have been maintained

4.3 Japan

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-54-42.png

#	Main activities	Tips/Best practices	Key points
1	Select “ERP – Production – PF1” by double clicking on the ERP – Production icon

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-54-59.png

#	Main activities	Tips/Best practices	Key points
2	Select Client “050” by clicking

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-55-21.png

#	Main activities	Tips/Best practices	Key points
3	Put T-code “xk02” and press “Enter” on the keyboard

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-55-35.png

#	Main activities	Tips/Best practices	Key points
4	Put “PRS” vendor code in Vendor field
5	Tick only “Payment transactions” and press “Enter” on keyboard

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-56-11.png

#	Main activities	Tips/Best practices	Key points
6	Put “JP” in Ctry
7	Insert bank key in ‘Bank key’ field		JP bank key must be 7 digits contains 4 digits of bank code and 3 digits of bank branch Bank key will be provided by requester in a template
8	Click

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-56-30.png

#

Main activities

Tips/Best practices

Key points

9

After check bank details,

Click

Bank details must contain bank name, branch code and Swift code

If this window is blank, this means that you have to create bank key

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-56-46.png

#	Main activities	Tips/Best practices	Key points
10	Insert bank account in ‘Bank Account field’		Provided in the template and please check against supporting document
11	Insert Account holder	Must be half Katakana format	Provided in the template
12	Insert either “01” or “02” in ‘AK’ field		Provided in the template 01 = saving account 02 = current account
13	Put “JPY1” in ‘BnkT’ field	New bank details will always end with 1	BnkT is a running code If there is JPY1 in the system, you need to change JPY1 to JPY2 and update new bank as JPY1 It can be other currencies such as USD1, EUR1, etc. depending on currency in purchasing organization
14	Click to save

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-57-10.png

#	Main activities	Tips/Best practices	Key points
15	The system will show status to confirm bank details have been maintained

4.4 Other countries

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-57-33.png

#	Main activities	Tips/Best practices	Key points
1	Select “ERP – Production – PF1” by double clicking on the ERP – Production icon

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-57-55.png

#	Main activities	Tips/Best practices	Key points
2	Click

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_11-58-8.png

#	Main activities	Tips/Best practices	Key points
3	Put T-code “xk02” and press “Enter” on the keyboard

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_12-47-44.png

#	Main activities	Tips/Best practices	Key points
4	Put “PRS” vendor code in Vendor field
5	Tick only “Payment transactions” and press “Enter” on keyboard

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_12-48-12.png

#	Main activities	Tips/Best practices	Key points
6	Put bank country code	e.g. SG, AU, TW, etc.
7	Put bank key	Different countries have their own codification, please see appendix 1
8	Click “Bank Data” to check whether bank details are correct or not		If there is nothing maintained in bank data, this means you need to create bank key Please see SOP bank key creation in the link below

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_12-48-25.png

#

Main activities

Tips/Best practices

Key points

9

After check bank details,

Click

Bank details must contain bank name, branch name and Swift code

If this window is blank, this means that you have to create bank key

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_12-50-43.png

#	Main activities	Tips/Best practices	Key points
10	Put bank account in “Bank Account” field	Rules for adding A/C no for SG DBS: 7171081 –Bank account has 9 digits, maintain 9 digits DBS: 7171XXX – Bank account has 10 digits, maintain 10 digits (first 3 digits out of 10 are branch code) HSBC: 7232XXX – Bank account to be maintained 9 digits OCBC: 7339XXX – Bank account to be maintained 9 digits Other banks: Bank account to be maintained as provided No space or hyphen (-) inside bank account. Rules for adding A/C for NZ Bank account must be 12 digits. If provided bank has less than 12 digits, you will need to add one 0 (zero) at the beginning and from 3^rd digits from right until account number has 12 digits
11	Put beneficiary name in “Acct holder” field	Please see appendix which country you need to maintain account holder field
12	Put currency n ‘BnkT’ field	New bank details will always end with 1	BnkT is a running code If there is SGD1 in the system, you need to change SGD1 to SGD2 and update new bank as SGD1 It can be other currencies such as USD1, EUR1, etc. depending on currency in purchasing organization
13	Click to save

Data Operations > APAC - Vendor bank account maintenance > image2019-6-7_12-51-21.png

#	Main activities	Tips/Best practices	Key points
14	The system will show status to confirm bank details have been maintained

Appendix

Country	Bank key	Bank account	Account holder
AU	- BSB code (XXXYZZ) - 6 numeric digits contain bank code (XXX), state code (Y) and branch code (ZZ)	- No spaces or hyphens https://searchmybank.com/Australia	Vendor's name or beneficially name
NZ	- BSB code (XXYYYY) - 6 numeric digits contain bank code (XX) and branch code (YYYY)	- No spaces or hyphens https://searchmybank.com/NewZealand Bank account must be 12 digits. If provided bank has less than 12 digits, you will need to add one 0 (zero) at the beginning and from 3^rd digits from right until account number has 12 digits	Vendor's name or beneficially name
ID	- 7 numeric digits (XXXYYYY) contain bank code (XXX) and branch code (YYYY)	- No spaces or hyphens https://www.sinaryuda.web.id/e-currency/bank-code-indonesia-paypal.html	Vendor's name or beneficially name
TH	- 7 numeric digits - Please see tab TH bank key	- Thai bank and Bank of America: 10 digits - Government Saving Bank: 11 digits - foreign bank: 11 digits	(Blank)
SG	- ACH bank and branch code (XXXXYYY) - 7 numeric digits contain bank code (XXXX) and Brach code (YYY)	- DBS with branch 081 > 9 digits - DBS with other branch codes > 10 digits - HSBC and OCBC > 9 digits - Other banks: maintained as provided - No spaces or hyphens https://www.uobgroup.com/assets/pdfs/global/achcode.pdf	Vendor's name or beneficially name
KR	- 3 numeric digits - Please see tab KR bank key	- No spaces or hyphens	(Blank)
JP	- 7 numeric digits (XXXXYYY) contain bank code (XXXX) and branch code (YYY)	- Must be 7 digits - If less that 7 digits, add 0 before bank account until it has 7 digits - Need to specify saving account (01) and current account (02) in AK field (BKONT) - Please see JP bank tab http://zengin.ajtw.net/	- Half katakana format (provided by requester)
CN	- Bank key generated by SBS BKK	- Maintain first 18 digits in bank account field, any extra digits are maintained in reference details field (BKREF) - No spaces or hyphens	- Vendor's name in Chinese
IN	- IFSC code - 11 alphanumeric digit	- No spaces or hyphens https://ifsc.bankifsccode.com/	if beneficially name is different from vendor's name
TW	- 7 numeric digits (XXXYYYY) contain bank code (XXX) and branch code (YYYY)	- No spaces or hyphens	- Vendor's name in Chinese
Other countries	SWIFT code	- No spaces or hyphens	Vendor's name or beneficially name