Search for answers or browse our documentation.
BTS Supplier CSV Imports
Import Additional BTS Customer Data
A CSV (Comma Separated Value) file – with a format that is determined by Source IT – is used to import the required extra Supplier banking details into BTS.
The following BTS bank formats cater for this facility:
- Business Integrator (ABSA)
- CSV (First National)
- Local PayBulk (Barclays)
- Barclays.net UK (Barclays)
The screen of this program is as per Figure 1
Figure 1
Bank – a valid SYSPRO Bank will need to be entered on the toolbar and can be browsed and selected. If the bank entered does not have a BTS format that is handled by this program, an error will be seen
Import File – this must contain the full path as well as the name of the file being imported. This will be validated and can be browsed and selected.
Business Integrator (ABSA)
This is the import layout for ABSA Business Integrator (BTIFOC) BTS import.
The Comma Separated Value (CSV) layout must be:
- Source 2 characters, either AP or CB
- Supplier code maximum 15 characters
- Account number maximum 16 numeric characters
- Bank Branch maximum 6 numeric characters
- Bank Account Type 1,2,3,4 or 5 (explanation below)
- Statement narration maximum 30 characters
Bank Account Type:
1 – Current Account
2 – Savings Account
3 – Transmission Account
4 – Subscription Shares
Here are 2 CSV entries with a heading descriptor which must be removed:
Source (2), Supplier Code (15), Account Number (16), Bank Branch (6), Bank Account Type (1), Statement Narration (30)
AP,000000000000001,2345678,12345,1,Testing statement
CB,1,87612393,001432,2,Re-Testing statement
CSV (First National)
This is the import layout for CSV First National (BTIFNC) BTS import to populate the additional information as prompted by BTS for existing SYSPRO Suppliers. This only updates the associated BTS tables.
The Comma Separated Value (CSV) layout must be showing maximun characters used:
- Source 2 characters, either AP or CB
- Supplier code 15 characters
- Email 1 notify 40 characters
- Email 1 address 200 characters
- Email 1 subject 50 characters
- Email 2 notify 40 characters
- Email 2 address 200 characters
- Email 2 subject 50 characters
- Email 3 notify 40 characters
- Email 3 address 200 characters
- Email 3 subject 50 characters
- Email 4 notify 40 characters
- Email 4 address 200 characters
- Email 4 subject 50 characters
- Email 5 notify 40 characters
- Email 5 address 200 characters
- Email 5 subject 50 characters
- SMS 1 notify 40 characters
- SMS 1 code 20 characters
- SMS 1 number 40 characters
- SMS 2 notify 40 characters
- SMS 2 code 20 characters
- SMS 2 number 40 characters
- FAX 1 notify 40 characters
- FAX 1 code 20 characters
- FAX 1 number 40 characters
Here is a CSV heading descriptor entry which must be removed:
Source (2), Supplier Code (15), Email 1 notify (40), Email 1 address (200), Email 1 subject (50), Email 2 notify (40), Email 2 address (200), Email 2 subject (50), Email 3 notify (40), Email 3 address (200), Email 3 subject (50), Email 4 notify (40), Email 4 address (200), Email 4 subject (50), Email 5 notify (40), Email 5 address (200), Email 5 subject (50), SMS 1 notify (40), SMS 1 code (20), SMS 1 number (40), SMS 2 notify (40), SMS 2 code (20), SMS 2 number (40), FAX 1 notify (40), FAX 1 code (20), FAX 1 number (40),
Local PayBulk (Barclays)
This is the import layout for Local Paybulk – Barclays (BTIBPB) BTS import to populate the additional information as prompted by BTS for existing SYSPRO Suppliers. This only updates the associated BTS tables.
The Comma Separated Value (CSV) layout must be showing maximun characters used:
- Source 2 characters, either AP or CB
- Supplier code 15 characters
- Payment identifier (PI) 2 characters (“DD”, “SW”, “OW”, “IN”, “LO”)
- Display code 8 characters (must be entered if PI = “OW”)
- SWIFT code 11 characters (must be entered if PI = “SW”)
- Charge option 3 characters (“SHA”, “BEN”, “OUR” must be entered if PI = “SW”)
- Beneficiary name 35 characters
- Benficiary address line 1 100 characters (must be entered if PI = “DD”)
- Beneficiary address line 2 100 characters (must be entered if PI = “DD”)
- Beneficiary address line 3 100 characters (must be entered if PI = “DD”)
- Beneficiary phone number 11 characters (must be entered if PI = “DD”)
- Recipient name 35 characters (must be entered if PI = “DD”)
- Recipient address line 1 35 characters (must be entered if PI = “DD”)
- Recipient address line 2 35 characters (must be entered if PI = “DD”)
- Recipient address line 3 35 characters (must be entered if PI = “DD”)
- Recipient city 25 characters (must be entered if PI = “DD”)
- Recipient pin code 8 characters (must be entered if PI = “DD”)
- DD pay at location 35 characters (must be entered if PI = “DD”)
- Beneficiary bank 100 characters (must be entered if PI = “SW” or “LO”)
- Beneficiary city 100 characters
- Beneficiary country 100 characters
- Intermediary SWIFT code 11 characters
- Intermediary account number 34 characters
- Intermediary bank 35 characters
- Intermediary bank address 1 35 characters
- Intermediary bank address 2 35 characters
- Remittance info 1 35 characters
- Remittance info 2 35 characters
- Remittance info 3 35 characters
- Remittance info 4 35 characters
- Nominated bene 1 character
- Purpose of payment 50 characters (must be entered if PI = “SW”)
- International branch code 50 characters (must be entered if PI = “SW”)
- Account number 32 characters (must be entered if PI = “LO”)
Barclays.net UK (Barclays)
This is the import layout for Barclays.net – Barclays (BTIBNU) BTS import to populate the additional information as prompted by BTS for existing SYSPRO Suppliers. This only updates the associated BTS tables.
The Comma Separated Value (CSV) layout must be showing maximun characters used:
- Source 2 characters, either AP or CB
- Supplier code 15 characters
- BIC 11 characters
- Account number 34 characters
- Reference 25 characters
- Charges 3 characters (“OUR”, “SHA’, “BEN”)
- Supplier name 35 characters