The BTS installation files are specific for each version of SYSPRO and are available for download from the Source IT website: http://www.source-it.co.za/product-category/software/bts/

You will be required to login using your once-off registered user account to perform the download.
Simply add the required download file to the "cart" and follow the "checkout" process to complete the order.

 

An email will be sent to your email address containing hyperlinks that will facilitate the download.

Alternatively, these "orders" with the hyperlinks will also be available on "My Account" page once you are logged in.

  Load Programs onto SYSPRO Server

To install the BTS product, follow the same process as per a SYSPRO port upgrade.
Simply unzip the downloaded file place the executable in the SYSPRO base upgrade directory on the Server.
Once that is done, logon on to SYSPRO as an administrator and the following message will be displayed as per Figure 1.1.1

 

 

 

 

Figure 1.1.1

Yes – a screen as per Figure 1.1.2 will be displayed.
No – the installation will abort.

Figure 1.1.2

This screen will list all the BTS program files and will display the SYSPRO folder on the server into which they will be placed.

Select the “Start Upgrade” button and the message as per Figure 1.1.3 will be displayed.

 

 

 

 

Figure 1.1.3

Yes – the associated BTS program files will be loaded into their relevant SYSPRO folders on the SYSPRO server.
No – the installation will abort.

Once the installation has completed successfully, a message as per Figure 1.1.4 will be displayed and it will automatically log you out of SYSPRO.

 

 

 

Figure 1.1.4

 

Initialise the BTS System

The BTS programs now reside in the relevant SYSPRO directories and need to be initialised.
This program needs to be run straight after the BTS programs have been installed. It will set up the following:

• BTS menu in SYSPRO
• BTS programs security options in SYSPRO
• BTS file re-indexing options in SYSPRO
• BTS trigger programs for EFT validation and creation of bank files after a batch has been extracted/re-extracted.

To run the initialisation process the following needs to be done:

• Login into SYSPRO as an Administrator
• From the SYSPRO menu, select File / Run and a screen as per Figure 1.2.1 will be displayed.

 

 

 

 

Figure 1.2.1

 Next  to ‘Program to run:’ type in SITINI and press the “OK” button
A screen as per Figure 1.2.2 will be displayed.

 

 

 

 

 

 

Figure 1.2.2

 The following options need to be ticked for BTS to be initialised successfully:

• Create or remove menu
• Create or remove security access
• Create or remove re-indexing of files
• Setup trigger points(Current company)

If any of the menu, security access or re-indexing of files already exist in the relevant files, this process will remove them.

The Source IT initialisation process will always ascertain whether a custom programs directory has been set up and will use an existing one. If one has not been set up and the System administrator does not wish to manually create one, this program will automatically create one and update the relevant fields in SYSPRO. This directory will be created as a sub-directory within the main SYSPRO directory on the server and will be called ‘cusprog’. (See Figure 1.2.3)

 

 

 

 

 

 

 

 

 

 

 

 

Figure 1.2.3

 Create or remove menu - this option will setup the BTS menu in SYSPRO as per Figure 1.2.4.

 

 

 

 

 

 

 

 

 

 

 

 

Figure 1.2.4

 If the BTS menu already exists, a warning message will be displayed to the user as per Figure 1.2.5.

 

 

 

Figure 1.2.5

Create or remove security access - this option will setup the BTS programs into the SYSPRO security access menu. To deny/allow access to the various BTS programs the following steps need to be taken:

From the SYSPRO menu select “Setup” > “Groups…” then select a group that will be using the BTS system and select “Edit” and “Change…” and a screen as per Figure 1.2.6 will be displayed.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 1.2.6

On the "Security Access" window, locate the "BTS Conversion System" module, tick the "Access Allowed" tickbox to give permissions to this Group.

It is important that the users that will be extracting the EFT payment in SYSPRO has access to the necessary BTS programs.

Create or remove re-indexing files - this option will add the BTS data files to the SYSPRO Data Dictionary so that they may be re-indexed in the same manner as the SYSPRO ISAM data files. Please note that if you are running SQL, all BTS files will still be created as C-ISAM and will reside in the SYSPRO data directory.

If the BTS programs already exist in the SYSPRO security access files, a
warning message will be displayed to the user as per Figure 1.2.7

 

 

 

Figure 1.2.7

To re-index the BTS files the following needs to be done:
From the SYSPRO menu, select “File” > “Re-index data files” and a list of all SYSPRO data files will be displayed. Go to the end of the list and the BTS files should be listed as per Figure 1.2.8

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 1.2.8

If the BTS files already exist in the SYSPRO data dictionary, a warning message will be displayed to the user as per Figure 1.2.9

 

 

 

 

Figure 1.2.9

Once the Source IT initialisation program has successfully completed, the following message will be displayed as per Figure 1.2.10

 

 

 

Figure 1.2.10

OK – will automatically log the user out of the SYSPRO session.

NOTE:
When running SITINI, either to create or remove options from SYSPRO, please ensure that the correct version of SITPRG, SITMEN, SITFIL and SITTRG are sitting in SYSPRO’s programs directory. There are several Source IT packages using a generic installation, one overwrites the other.

Setup trigger points (Current company)
This option is a very IMPORTANT step to run and failure to do so will result in no bank file being created during an EFT run.
This option will set up two BTS programs at various trigger points in SYSPRO that will validate banking details accordingly and automatically create a bank file during an EFT run.

PLEASE NOTE: This option ONLY needs to be run for every SYSPRO company that will be utilizing EFT.

The following trigger points will be added to the SYSPRO trigger programs options as per Figure 1.2.11 and 1.2.12.

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 1.2.11

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 1.2.12

To ensure that the relevant trigger points were setup correctly, from the
SYSPRO menu, under the Administration tab, select on Trigger Programs. Locate the A/P Supplier Maintenance programs and the following tick boxes should be ticked:

• After supplier added
• After supplier changed
• After supplier deleted

By highlighting each option and clicking on the ‘Maintain Trigger’ button, all three should be calling a program called “BTTSVL.int“ that resides in the SYSPRO programs directory.

Locate the EFT Beneficiary Maintenance program and the following tick boxes should be ticked:

• After beneficiary added
• After beneficiary changed
• After beneficiary deleted

By highlighting each option and clicking on the ‘Maintain Trigger’ button, all three should be calling a program called “BTTSVL.int” that resides in the SYSPRO programs directory.

Locate the EFT Payment Extract program and the following tick box should be ticked:
After EFT payment extract
By highlighting this option and clicking on the ‘Maintain Trigger’ button, it should call a program called “BTTCAL.int” that resides in the SYSPRO programs directory.
NOTE: THIS OPTION MUST BE RUN FOR EVERY COMPANY THAT UTILIZES EFT!

Once the SOURCE IT initialization program has successfully completed, the following message will be displayed as per Figure 1.2.13

 

 

 

 

Figure 1.2.13
The process will automatically LOG OUT of SYSPRO. Log in again to ensure that the initialization installed everything successfully by following the steps outlined above.

Licensing Process 

If the user wishes to license BTS or re-license BTS, the program is found under the "Bank File Translation(BTS)" menu as per Figure 2.4.5

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 2.4.5

If it’s the first time BTS is being run, Figure 2.4.5.2 will be displayed.

 

 

 

Figure 2.4.5.2

Contact your SYSPRO distributor or Source IT to obtain license codes.
To contact Source IT, you may email your request to cotact us via the Source IT Contact page or alternatively phone +27 11 781 4000.

By clicking on OK, Figure 2.4.5.3 will be displayed.

 

 

 

 

 

 

 

 

Figure 2.4.5.3

Expiry date – enter the license expiry date as. To ensure correct date format, make use of the date browser to select the expiry date.
New Code – enter the license code as issued by the Source IT offices.
Save – will validate the entered values and verify if the license code is valid for the expiry date based on specifics pertaining to the SYSPRO registered company currently logged into. If deemed valid, the information will be stored as entered.
Close – will exit the program without validating the information on the screen. If the “Ignore warnings” tickbox status was modified, the new setting will be applied to the license validation process in the future.

The license process is written to provide a warning message each time it is run in the expiry month indicating the number of days until the license expires (see figure 2.4.5.4).

 

 

 

Figure 2.4.5.4

The following information needs to be relayed to the relevant person who will be obtaining your license codes with the exact spelling and case (upper/lower) as per the example in figure 1.3

• Company
• System
• SYSPRO users
• Platform (ISAM)
• SYSPRO version (7.0)

Ensure that both the “Ignore warnings” and “Evaluation License” tickboxes have been UNTICKED.
The relevant “Expiry date” and “New Code” values must be entered and the “Save” button selected.

The BTS User Manual will explain the detailed functioning of the various BTS processes.

Conversion Process 

This is only required when upgrading from SYSPRO 6.1 SP1 and earlier after having used BTS in any version of SYSPRO prior to SYSPRO 7. Due to the enlargement of fields in SYSPRO 7, a BTS conversion program is required to be run in order to enlarge the necessary field sizes in the BTS System.

If the data requires the conversion to be run, Figure 1 will be displayed

 

 

 

Figure 1

To run the conversion program, from the SYSPRO menu, select File / Run and enter BTCNV7. A screen as per Figure 2 will be displayed

 

 

 

 

Figure 2

Selecting OK will show the screen as per Figure 3

Figure 3

Start Processing will run the conversion of the data. Once this has been completed, summary detail will be seen as per Figure 4

Figure 4

When closing the BTS conversion program after it has completed successfully, a message as per Figure 5 will be displayed and it will automatically log you out of SYSPRO.

 

 

 

Figure 5

Nedbank have introduced a new format called “NetBank Business (Secure Format). This format has a very complex algorithm in the trailer record to prevent fraud on the bank file. In order for BTS to calculate this algorithm a Dynamic Link Library (DLL) process had to be written and the BTS process invokes this DLL file to do the final hash calculation. This process has to be performed on a client machine as it is only supported by a Windows Environment. This process has been called BTSNEDHash.dll. It will automatically register in the client machine registry on any user’s machine that is running BTS the first time that the program is invoked on that machine. When BTS is installed, this DLL file is automatically copied onto the server SYSPRO/BASE folder. When a user runs either the BTS Bank setup program for the NetBank Secure Format or performs an EFT extract, the program will automatically copy this DLL file onto that user’s client machine in a folder called BTSNED within the SYSPRO/BASE folder. The program will then check if this DLL has been registered on that client machine. If it has not, then the BTS program will automatically register this DLL. All this processing happens in seconds in the background without any user intervention required.

However, due to security measures applied to client machines in various companies, the automatic registering of this DLL could fail. If this is the case, an administrator with full administrative rights might need to login to that client computer and invoke the relevant BTS program. This step will only need to be done once per client machine if there is tight security at that specific company.
If the DLL does not register when an administrator invokes the BTS process, then there is a manual procedure to follow as follows:

• Please run an "elevated" dos session (right click on cmd and select 'Run as administrator') on the client machine
• Access the folder that contains the following command REGASM.EXE. It usually sits in the following folder:
  c:windowsmicrosoft.netframeworkv2.0.50727
  NOTE: Irrespective whether the client machine is running 64bit or not, the 32bit 'Framework' folder must be used.
• Once in that folder, type in the following command (replacing the path below in quotes with your SYSPRO installation path on the client machine):
  REGASM “c:syspro71basebtsnedBTSNEDHash.dll”

This will now register the DLL on the client machine.

If for some reason you wish to de-register the DLL off any client machine, then you will need to type in the following command (replacing the path below in quotes with your SYSPRO installation path on the client machine):
REGASM “c:syspro71basebtsnedBTSNEDHash.dll” /unregister

Prior to a successful import into the NetBank Software, the company needs to register a SEED NUMBER with Nedbank as follows.

• They will need to obtain a document called “Add Delete or Maintain profile options - MR5.doc” from Nedbank’s help desk.
• The user must fill in the relevant details and create their own 32 character seed number. Please note that this seed number HAS to be 32 characters long and the only characters allowed are: ABCDEF123456789. Please only use these characters in any sequence you desire and make sure that you have used 32 characters. If you by mistake use a character that is not allowed, Nedbank automatically changes it and sometimes neglects to inform you what substitute was
  used. You will then receive a HASHCALC error when attempting to import the file
• Once the relevant form has been completed, it must be faxed to the number provided on the form. It can take up to 2 working days for the bank to load this on the profile. The user must just follow up on this by calling the Nedbank help desk.
• When the bank confirms that the SEED NUMBER has been registered successfully on their profile a test run should done
• The BTS product will create a bank file with an extension of .CSV
• This is the file that needs to be uploaded into the NetBank software

When the NetBank Business Software is invoked, a screen as per Figure 4.1 will be displayed

 

 

 

 

 

 

 

 

Figure 4.1

The user must select the “NetBank Business (Secure Format)” option and where it says “File Name” they must put in the name of the BTS .CSV file or browse for it. Thereafter just follow the screen prompts and the file should import successfully.
If the file does not import, the most obvious problem is that the Seed Number captured in the BTS software does not correspond to the Seed Number that Nedbank added to the user’s profile. The user MUST contact Nedbank to verify the seed number and make sure it matches the one captured in BTS.

Please ALWAYS run a test the first time to make sure there are no problems before attempting to load a Live Run.

1. Abbr Name (Abbreviated company name)
   This name appears on the supplier’s bank statement for bank formats that do not cater for a long statement reference eg. PACS
2. ACB Service Type
   This can either be 1 Day, 2 Day, 5 Day Sub-Service or SSV/CSSV Service. Refer to your bank’s documentation.
3. Account Name
   Name of account with bank.
4. Account Number
   This refers to the company bank account number.
5. Bank Code
   The SYSPRO bank code linked to the suppliers/beneficiaries that require EFT payments.
6. Bank format
   Contains information that specifies the type of fund transfer, e.g., PACS, Nedinform, CATS etc.
7. Branch Number
   This refers to the company bank branch number.
8. Seed Number
   A 32-character number allocated by the user. This number is used when calculating the batch totals for the Nedinform Payments System.

1   System Description

The Bank file Translation System (BTS) is an add-on facility to the SYSPRO EFT module.  Designed to interact specifically with the Accounts payable(AP) supplier and Cash Book(CB)  beneficiary electronic payments process, BTS provides the user with an interface between SYSPRO and the various electronic banking services offered by major banking institutions in South Africa, African counties, Australia and USA.

2   System Overview

A parameter file containing the user’s banking requirements is created by the user at installation time.  BTS uses this file to determine in what format to supply the payment details to the given institution. (E.g. CAMS and PACS are just two of the facilities offered by First National Bank.)

A parameter file containing the user’s banking requirements is created by the user at installation time.  BTS uses this file to determine in what format to supply the payment details to the given institution. (E.g. CAMS and PACS are just two of the facilities offered by First National Bank.)

Once the BTS system is installed and the initialisation program has been run, relevant trigger programs will be set up in SYSPRO as follows:

Validation of EFT supplier/beneficiary banking details

• After Accounts Payable supplier added
• After Accounts Payable supplier changed
• After Accounts Payable supplier deleted
• After Cashbook beneficiary added
• After Cashbook beneficiary changed
• After Cashbook beneficiary deleted

Creation of relevant bank file format

• After EFT batch extract/re-extract

The initialisation program will also setup the BTS menu, program security and BTS file re-index options. It will create the relevant entries in the files required by SYSPRO that reside in the custom programs directory. If this directory has not been set up yet, the program will create a directory called ‘CusProg’ under the SYSPRO directory automatically and create the relevant files there.

Suppliers from the AP module and beneficiaries from the CB module need to be captured in the SYSPRO master files with the relevant banking details for EFT payments. The SYSPRO EFT module allows the users to batch relevant payments together by bank for payment and allocates a batch number to them. At the time that the batch is created, a trigger program set up by the BTS system will translate all the relevant records into the specified bank format selected by the user in the BTS system.

The user will need to run the BTS setup program for each SYSPRO company that has been set up for EFT payments and capture the relevant bank formats.

The BTS program will automatically create the relevant bank files in the directory that the user has specified in the SYSPRO EFT bank control program. If the user is using BTS they do not need to tick the XML file creation option in the SYSPRO EFT bank control program.

Troubleshooting BTS

When running BTS for the first time in a client/server environment and the following screen as per Figure 1.15 is displayed, it could be one of the following:

• The BTS programs have incorrect permissions
• The BTS programs are not in the correct directory
• The incorrect BTS programs are loaded for the current SYSPRO version running on this machine

 

 

 

 

 

 

 

Figure 1.15

Please note that BTS looks at the SYSPRO nationality code. It only supports the following nationalities:

• AUS (Australia)
• BWP (Botswana)
• GH (Ghana)
• IND (India)
• KEN (Kenya)
• MZ (Mozambique)
• RSA (Republic of South Africa)
• TZ (Tanzania)
• UG (Uganda)
• USA (United States of America
• ZAM (Zambia)

If the nationality code does not match one of the above, an error screen as per Figure 1.16 will be displayed

 

 

 

 

Figure 1.16

If any other Nationality has been entered in SYSPRO it needs to be changed to one of the above dependent on the country running the product in SYSPRO’S: Setup, System Setup, General TAB, Nationality field.

Once BTS has been installed and the Source IT initialisation program has been run, the following menu in Figure 3.1.1 should have been added to the SYSPRO menu.

Figure 3.1.1

This is a report listing all EFT suppliers from the AP module and beneficiaries from the CB module with their banking details. A selection can be made by Bank as per figure 3.7.1

Figure 3.7.1

This report will only print banking details pertaining to the bank format for the supplier/beneficiary. Eg. If the bank format is pre-format then only the credit line numbers will be displayed.

Supplier Invalid Banking Details - A report is produced that displays any suppliers/beneficiaries with missing banking details that will be needed for the bank file
Detailed List of Payments – This report is automatically generated after an EFT Batch is
extracted/re-extracted. It contains a detailed list of all transactions to be paid by the bank

The report provides a listing of:
- totals per supplier per invoice
- a grand total
This report should be filed for future audit requirements.

Installation and initial licensing of BTS will be performed by your SYSPRO consultant.
An annual licence fee will be charged and once payment is received, the license code will be emailed to the client. It is the client’s responsibility to keep SOURCE IT updated with new email addresses and contact people.
BTS will run on platforms presently compatible with the SYSPRO and has been developed for C-ISAM and SQL.
There are many files that store the data relating to BTS, including the output file transmitted to the bank. The control files reside in the SYSPRO data directory and the bank output files will reside in a directory set up by the user in the EFT Bank maintenance program. It is the user’s responsibility to make sure that these files are backed-up on a regular basis.
ALL files will be prefixed with the SYSPRO company code.

ALL files will be prefixed with the SYSPRO company code:

The file naming convention and details can be found under each bank layout in the BTS Bank Format Setup catagory.

If "same file" name is selected in bank parameters program, the bank output files will be prefixed with the SYSPRO company code and bank code that the format is attached to.

If "unique file" name is selected in bank parameters program (Will start at 001 and increment for each run)

The following steps have to be completed in SYSPRO before BTS can be used:

Step one:   All relevant banks that require EFT transactions need to be selected for EFT payments.

Step two:   The Source IT initialisation program that sets up the Menu, Security, Files for reindexing and trigger programs needs to be run.

Step three:   The BTS Bank setup program must be used to capture all the relevant bank formats for EFT banks.

Step four:   Select all the relevant AP suppliers and CB beneficiaries that require EFT payments and capture the relevant banking details. The AP suppliers need to be ticked as ‘EFT payments required’.

Step five:   Setup the security access in SYSPRO for all groups that will be using BTS.

 

When BTS is installed and the initialisation program has been run, it will automatically set up a trigger "After EFT batch extract".

This program will automatically create a bank file in the format set up for that bank in the BTS Bank setup module. The bank file will be named as per the option selected by the user and will be placed in the directory that has been set up in the EFT
Bank control program for that bank as per Figure 1.

 

 

 

 

 

 

 

 

Figure 1

If no directory has been set up, a validation error will be displayed and no bank file will be created. The user will need to set up the relevant directory and re-extract the batch. Every time a new batch is extracted or an existing batch is re-extracted a bank file will be created. The re-extract may be used if a supplier/beneficiary bank details were incorrect. The user may correct them in the relevant maintenance program and re-extract that particular batch.

It is important that the users that will be extracting the EFT payment in SYSPRO has access to the necessary BTS programs (explained in detail in the "Initialise the BTS system" question)

Accounts payable (AP) and Cashbook (CB) EFT payments are bank driven. AP suppliers and CB beneficiaries need to be linked to a bank that has been activated for EFT payments as per Figure 3.3.1.

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 3.3.1

To enable EFT payments for a supplier the ‘EFT payments required’ option needs to be ticked. This option will only be enabled if the supplier is linked to an EFT enabled bank. When the user selects "save", the screen as per Figure 3.3.2 will be seen

Figure 3.3.2

The SYSPRO Cashbook beneficiary maintenance program is purely for EFT payments out of the Cashbook. All beneficiaries with their relevant banking details will be used for Cashbook EFT payments. The relevant bank linked to these beneficiaries needs to be EFT activated and the captured beneficiaries will only be linked to that specific bank as per Figure 3.3.3.

 

 

 

 

 

 

 

 

Figure 3.3.3

In the AP Supplier maintenance and CB Beneficiary maintenance, the Account number, Bank branch and Account type are compulsory for bank formats that are not Pre-Format. The account types are a 1 digit field that depicts the account type as follows:

1- Current Account
2- Savings Account
3- Transmission Account
4- Bond Account
5- Subscription Shares

The above numbers are shared by all the banks. When using a Bond or Subscription Shares account, the account number is normally 18 digits long. The normal Account number field is only 15 characters long so the user may use the EFT USER 1 field to capture account numbers for these account types.

CATS PRE-FORMAT: This bank format does not require an Account number, Bank branch or Account type. An alphanumeric credit-line number is used against each supplier and this must be captured in the EFT USER 1 field ("Credit Line (CATS)" as per Figure 3.3.2).
NEDBANK PRE-FORMAT: This bank format does not require an Account number, Bank branch or Account type. A numeric credit-line number is used against each supplier and this must be captured in the EFT USER 2 field("Credit Line (NED)" as per Figure 3.3.2).

The SYSPRO EFT system allows these fields to be renamed and the user may rename them to Credit-line for easier identification when capturing PRE-FORMAT credit-line numbers. Alternatively if the bank format is not pre-format and the account types are Bond or Subscription the user may rename the EFT USER 1 field to Alternate Account. When BTS is installed and the initialisation program is run, it automatically sets up a validation trigger program after an AP supplier is added, changed or deleted and after a CB beneficiary is added, changed or deleted. This program will warn a user if any relevant banking details are missing and will suggest that they be captured before an EFT run is performed. When an EFT batch is extracted the validation program will automatically run and will NOT create a bank file if any of the relevant banking details are missing. A report will automatically print out with a list of suppliers/beneficiaries whose banking details are missing. The user will need to rectify this and re-extract the batch through the SYSPRO EFT module.

This is an audit report listing all changes made to the EXTRA Supplier details if pertinent to the BTS bank format being used. Selections can be made as per figure 3.7.3

Figure 3.7.3

Clear Audit File - this button will delete ALL the Audit File records for the company the user is signed into.

Reprint records – if set to “Yes”, the report will be produced for all records in the selected date range whether previously printed or not.
Date selection – selecting “Single” will only allow entry of the “Date from” field. “Range” will allow entry of the “Date from” and “Date to” fields.  If “All” is selected, the audit records will print in date and time sequence.

This program is only used by the SWIFT BTS formats.

This is an audit report listing all transactions created when approving a BTS payment.
Selections can be made as per figure 3.7.2

Figure 3.7.2

Clear Audit File - this button will delete ALL the Audit File records for the company the user is signed into.

Reprint records – if set to “Yes”, the report will be produced for all records in the selected date range whether previously printed or not.
Date selection – selecting “Single” will only allow entry of the “Date from” field. “Range” will allow entry of the “Date from” and “Date to” fields.  If “All” is selected, the audit records will print in date and time sequence.
Bank - if the Bank selection is "Single" or "Range", the bank code entered is validated. The available banks can be browsed and selected.
Batch - if the Batch selection is "Single" or "Range", the batch entered is validated. The available batches can be browsed and selected.

 

This program is only used by the SWIFT BTS formats.

If the BTS bank format being used caters for authorisation levels for payment approval before creating the BTS payment file, this can be maintained using this program. The EFT payment extract or re-extract program uses these records to determine who has authority and permission to approve an EFT batch.

All the available authorisation levels already set up will be seen as per Figure 1

Figure 1

Selecting add or change will show the following screen as per Figure 2

Figure 2

Bank – a valid SYSPRO bank code will need to be entered. The available bank codes can be browsed and selected.
Operator - a valid SYSPRO operator code will need to be entered. The available operator codes can be browsed and selected.
Authorisation level - this needs to be entered. A drop down is available for selection to assign an authorisation level to this operator.

This program is currently only supported by the following BTS bank formats:

• SWIFT(Standard Bank)
• SWIFT(Standard Chartered)
• SWIFT(Deutsche Bank)

This program is only available from SYSPRO 7 onwards and is used to "takeon" Supplier banking details into the pertinent BTS EXTRA Supplier details.

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:

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

This program is only used by the SWIFT BTS formats.

The files extracted by BTS SWIFT formats are XML files. The feedback files from SWIFT are also XML files. These feedback files need to be placed in the XML dashboard path as setup in the SWIFT Bank format setup

In order to process these feedback files, the BTS Dashboard on the BTS menu can be run. The screen will look as per figure 1

Figure 1

Selecting the Status Update button on the screen in figure 1 will process available files in the XML dashboard path and update the status of the corresponding records in the BTS SWIFT system

Selecting the Status Auto Update button on the screen in figure 5 will begin polling the XML dashboard path for available files to process and should update files be encountered, the process will update the status of the corresponding records in the BTS SWIFT system with all the updated Batches for Bank entries being highlighted in green text and the polling process will exit with the first updated (green) entry highlighted. The entries highlighted in green will revert back  to black text when the dashboard program is exited.
The user will be unable to use any of the dashboard functionality until an update XML file is located when the Status Auto Update process will stop executing and the first updated (green) entry will be highlighted..
The user could exit the Status Auto Update process by selecting the Status Auto Update button.

If the Payment approval switch has been set in the BTS control for SWIFT, when the BTS extract is run, the extract file will not be created and the user will see the screen as per figure 2

 

 

 

Figure 2

In order to release these payments, the BTS Payment Approval on the new BTS menu can be run. This program will look as per figure 3

Figure 3

Selecting the Payment Approval button on the screen in figure 3 will release the selected batch and the BTS XML file will be created. The following message as per figure 4 will be seen that shows the user what the file name being extracted is

 

 

 

Figure 4

BTS Dynamic Link Library (DLL) and Windows Communication Foundation (WCF) Processing

Sending - DLL:
Should the BTS format being used make use of API’s to push the files through to the banking  institution, BTS will make use of a Dynamic Link Library (DLL) process which will be called into by the BTS extract process and should the push process fail due to, amongst other things, communication failure, the associated Batches for Bank entries will be represented in red text and it will be required to re-extract the associated EFT batches once the cause for the failure has been resolved.
Receiving - WCF:
Should the BTS format being used make use of a Windows Communication Foundation (WCF) to receive the payment response files from the banking  institution, BTS will make use of a WCF service which, once installed and activated, will accept the payment response files and present them to the BTS Dashboard for importing to update the Batched for Bank status entries.
Should the BTS Dashboard attempt to import payment status update files and identify that the WCF service is flagged as inactive, an error message will be generated as per Figure 5.

 

 

 

Figure 5

This program is only used by the SWIFT BTS formats.

This allows the batch to be approved by the user that is running the program. Only the users that have been setup in the "Payment Approval" program for the bank in question will be allowed to approve the payment. If a level 1 has been approved and a level 2 is required, then only level 2 operators will be able to approve this payment and visa versa.

The Payment Approval button on the toolbar of the screen as per figure 1 will be available if the user running the program is allowed to approve this batch (else this button on the toolbar will be greyed out and unavailable)

Figure 1

If there are still more approval's required for the batch in question, the Addition Status will be updated and the Payment Approval button will be greyed out.

If the batch has been successfully approved as all authorisation level users have approved the batch, selecting the Payment Approval button on the screen in figure 1 will release the selected batch and the BTS XML file will be created. The following message as per figure 2 will be seen that shows the user what the file name being extracted is

 

 

 

Figure 2

This program is only used by the SWIFT BTS formats.

The files extracted by BTS SWIFT formats are XML files. The feedback files from SWIFT are also XML files. These feedback files need to be placed in the XML dashboard path as setup in the SWIFT Bank format setup

In order to process these feedback files, the BTS Dashboard on the BTS menu can be run. The screen will look as per figure 1

Figure 1

This list view is not maintainable. This is just used to check who has authorised the BTS batch. There are 2 options available in the toolbar:

Current - This will show you the current authorisation for the BTS batch in question. If the payment file has already been created (as the file was properly authorised), the current information will be cleared out, so you will need to use the "History" selection

History - This will show you all the history of the audthorisation details for the the BTS batch in question.

This process will allow the user to capture bank format details or alter an existing banking facility for BTS. One bank format per bank may be captured.

It only supports the following SYSPRO Nationality codes:

• AUS (Australia)
• BWP (Botswana)
• GH (Ghana)
• IND (India)
• KEN (Kenya)
• MZ (Mozambique)
• RSA (Republic of South Africa)
• TZ (Tanzania)
• UG (Uganda)
• USA (United States of America
• ZAM (Zambia)

On the BTS Menu, opening the "BTS Bank Formats" program show a list view as per figure 1 containing all bank codes that have been captured with their associated bank formats will be displayed. The user may then either, add a new bank format, amend an existing bank format or delete a bank format. Please note that if there are pending EFT transactions for a bank the delete will be prohibited.

 

 

 

 

 

 

 

 

 

Figure 1

 When you select a bank to maintain, the maintenance screen will be seen as per Figure 2

 

 

 

 

 

 

 

 

Figure 2

Bank code - a valid SYSPRO bank code that is linked to EFT suppliers/beneficiaries.
Bank format - a list box will display the payment options available to the user.  The user must select the banking facility that they are currently with. The following types are available:

SOUTH AFRICA (and in the African countries catered for):     

• ABSA (Focus, CashFocus and Business Integrator)
• Nedbank (Nedinform, NedExec, NetBank Secure and CPS)
• Standard Bank (CATS, EFTS, CFC/ZAR, BEFT, BOL, nBOL and NetPlus)
• First National Bank (CAMS, PACS, BANKit, CSV and AiDPS Swazi)
• CITIBANK (EFT, PAYLINK, CITIDIRECT and CITI Preformat)
• Bank Windhoek (Bureau)
• Mercantile (BANK@bility)
• BOE (BOE)
• JP Morgan (Global ACH GDFF and FTI GMT)
• Stanbic (SFI, CSV NBOL and PAY ALERT)
• Barclays (SFI, Local Payment and Barclays.net)
• Standard Chartered (STS, iPAYMENTS, SAB-iPAY, ePAYMENTS and Straight2B)
• HSBC (iFILE)
• Kenya Commercial (KCB Quickpay)
• CBA (Trade Payments CSV)
• ABN AMRO (BSI VDB)
• Fihrst Management (FIHRST)
• BANCO Comercial (BCI)
• SWIFT(Standard Bank, Standard Chartered, Barclays Bank and Deutsche Bank)

AUSTRALIA

• All banks (Direct Entry Payments)

USA

• Wachovia (NACHA)

Account name - the Name of Account with the bank.
Account no - this is the Company’s Bank account number.(Not required for USA)
Branch number - this is the Company’s Bank branch number. (Not required for CitiBank, Australia or USA)
Bank output file - can be Unique, Same or User-defined

• Unique file name - this will allocated a unique bank file name for each EFT run. The file name will be prefixed with the SYSPRO company code at run time
• Same file name - this will allocate the same file name for each EFT run. The file name will be prefixed with the SYSPRO company code at run time
•  User-defined file name - this allows the user to allocate a name for the bank file. It will always allocate the name entered here for each EFT run. The file name will be prefixed with the SYSPRO company code at run time.

Certain institutions require additional information.  Depending on which institution is chosen an extra screen appears for the capturing of the additional information.

SWIFT (Standard Bank)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 1

User defined customer reference - This decides what will appear on the Customer statement reference on the file that is sent to the bank: "Supplier name", "EFT number/Supplier code" or "EFT number/Supplier name".
XML dashboard path - This is the physical path where all the "feedback" return files from the bank will reside. This path needs to be accessible from SYSPRO itself and must have the correct permissions. The BTS Dashboard program (found on the new SYSPRO 7 BTS menu in SYSPRO under Transaction Processing as per Figure 2)
File name prefix - This is a maximum of 6 characters and is mandatory. This is the 1st 6 characters of the physical file name extracted by this bank format
Group header ID - This is a maximum of 20 characters and is mandatory. This is the tag to identify the company profile
BIC number - This is a maximum of 11 characters and is mandatory. This is bank BIC code for the company
Large account number - This is a maximum of 16 characters and is mandatory. BTS bank account number only stores 11 characters. As SWIFT banks require a larger account number, this field is used instead
Payment approval - If this switch is ticked, this prevents the BTS from extracting the physical XML payment file until the EFT batch is approved by authorised users - as per Figure 2
Number of level 1 authorisers - If the Payment approval is ticked, the user may enter how many level 1 authorisers are required. This is drop down that allows between 0 and 9
Number of level 2 authorisers - If the Payment approval is ticked, the user may enter how many level 2 authorisers are required. This is drop down that allows between 0 and 9
Sub-level authority allowed - If the Payment approval is ticked, the user may tick this entry allowing level 2 authorisers to function as level 1 authorisers.
Bank address line 1 - This field is optional and may contain 40 characters of the bank address line 1
Bank address line 2 - This field is optional and may contain 40 characters of the bank address line 2
Bank address line 3 - This field is optional and may contain 40 characters of the bank address line 3
Bank address line 4 - This field is optional and may contain 40 characters of the bank address line 4

Country
Maputo Instrid – this option will include the vendor code in the “InstrId” tag along with the EFT number
Select to include the vendor code in the “InstrId” tag along with the EFT number.
This process will also remove leading zero’s from the beginning of the EFT number itself.
An example would be as follows: “84-BYTMZM001” where “BYTMZM001” would represent the vendor code and “84” the EFT batch number without the leading zeros

Mauritius Payment Instruction – this option is to be selected for all Mauritius SWIFT Standard Bank and Standard Chartered formats.
Select to include the extra <ChrgBr> element in the payment XML extracted file. If this option is selected, the <BtchBookg> in the extract is always TRUE. These are requirements needed for Mauritius
If this option is selected, a Mauritius Charge Bearer code needs to be selected from the dropdown available when maintaining the Supplier extra details in Figure 3.

Mulesoft Web Service
This set of parameters caters for the automatic pushing of the BTS payment XML files into the Mulesoft API solution.
This process makes use of the BTS SourceIT_ServiceIntegration.dll
Flowid – Inclusion of this Flowid will serve to activate this service and the validation of the rest of the associated parameters.
Path – Location that the XML files will be pushed by the SourceIT_ServiceIntegration.dll process
Port – Port number. If the port number is included in the "Path" parameter, then do not enter the port number.
Username – User ID for login
Password – Login password

Mulesoft WCF Service
This set of parameters is passed to a WCF service installed separately which handles the receiving of the return XML files as sent by the Mulesoft API solution.
BTS will automatically import these files into the BTS SWIFT dashboard.
Host – Local host setup
Port number – Local port number
Username – User ID for login
Password – Login password
Active – the WCF Service will check this parameter each time the service or the server is restarted and it will only start if this parameter is ticked

Figure 2

If your BTS menu does not like the menu above (with this Transaction Processing menu options), please follow the instructions on our website for the BTS Installation - Initialise the BTS system (File --> Run SITINI and enter the 3 options. You will be asked if you wish to remove each in SYSPRO. Select No and the BTS installed products will be amended. Then you should see the Transaction Processing option under the BTS menu. Without these 2 functions, the SWIFT Dashboard and Payment Approval processes cannot be controlled on site)

This BTS Bank format is available for all African Nationalities:

• RSA (Republic of South Africa)
• BWP (Botswana)
• ZAM (Zambia)
• UG (Uganda)
• KEN (Kenya)
• GH (Ghana)
• MZ (Mozambique)
• TZ (Tanzania)

There are extra details required when using this BTS bank format. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, the following screen as per Figure 3 will be seen:

 

 

 

 

 

 

 

 

 

 

 

Figure 3

Payment type - May be selected from the available drop down list as per Figure 4
BIC number - This is a maximum of 11 characters and is mandatory. This is the BIC code for the Supplier
Country code - This is a maximum of 2 character country code and is mandatory. There is no validation
Reference - This is a maximum of 35 characters and is mandatory. This is a free-format supplier reference
Additional reporting - This is a maximum of 140 characters and is optional. Selecting the browse button will show a list of available currencies as per Figure 2
Account number - This is a maximum of 35 characters, is free-format and is optional.
Payment reason - This is a maximum of 35 characters, is free-format and is optional.
Sup currency - This is a maximum of 3 characters and is optional. This gets used in the payment extract file as the Supplier currency code
Additional remit info 1 - This is a maximum of 35 characters, is free-format and is optional
Additional remit info 2 - This is a maximum of 35 characters, is free-format and is optional
Additional remit info 3 - This is a maximum of 35 characters, is free-format and is optional
Additional remit info 4 - This is a maximum of 35 characters, is free-format and is optional
Bank id - This is a maximum of 3 characters, is free-format and is optional
Branch id - This is a maximum of 3 characters, is free-format and is optional

 

Figure 4

If the Payment approval switch has been set in the BTS control for SWIFT, when the BTS extract is run, the extract file will not be created and the user will see the screen as per figure 5

 

 

 

Figure 5

In order to release these payments, the BTS Payment Approval on the BTS menu can be run. This program will look as per figure 6

Figure 6

Selecting the Payment Approval button on the screen in figure 6 will release the selected batch and the BTS XML file will be created. The following message as per figure 7 will be seen that shows the user what the file name being extracted is

 

 

 

Figure 7

Selecting the Check Authorisation button on the screen in figure 7 will show what authorisation has already been done against this batch. Refer to the Check Authorisation tab under BTS Process

Once payment has been extracted and sent to the bank in question, the bank will supply in return "feedback" files with details as to their processing of the batches. For more information regarding this step, refer to the BTS Dashboard tab under BTS Process

CATS (Standard Bank)

 

 

 

 

 

 

 

 

Figure 1

Payment format - Identify the type of payment used. May either be "FREE-FORMAT" or "PRE-FORMAT". This is determined by the contract made with the bank.
Detail batch no - Must always be 1.
Contra batch no - Must always be 1.
User defined reference - Identify what must appear in the reference field for the bank, either just the "Supplier name" or the "EFT number/ Supplier name"
Encrypt with hash algorithm - No/Yes. This new encryption was an enhancement done for SYSPRO 7 onwards
Print hash algorithm - Yes (if this check box is ticked)/No (if the check box is not ticked) if the hash algorithm must appear on the payment report

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

There is one extra detail required when using this BTS bank format and the "PRE-FORMAT" option in Figure 1 has been selected. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, if the "Credit Line (CATS)"  (EFT user 1) has not been captured, as per highlighted field in Figure 2:

 

 

 

 

Figure 2

The following error as per Figure 3 will be seen:

 

 

 

Figure 3

EFTS (Standard Bank)

 

 

 

 

 

 

 

 

 

Figure 1

Abbreviated name - An abbreviated name for your company. May not exceed 10 characters and is mandatory
Bank company code - This is a 4 character word supplied by the bank identifying your site and is mandatory
Batch number - Should always be 1
Language - May either be set t0 "ENGLISH" or "AFRIKAANS"
Credit/Debit - Identifies the type of payments to be made. May be "CREDIT", "DEBIT" or "SALARY"
Run type - This field identifies the type of run. "TEST" for a test run, and "LIVE" for a live run. The bank will treat the file accordingly
Modify bank company code at runtime - May be either "No" or "Yes". If this is set to Yes, when the BTS extract is run, the user will see the screen as per Figure 2. The EFT company code entered here will be used in the extract rather than the SYSPRO company signed into at time of BTS extract
Encrypt with hash algorithm - May be either "No" or "Yes". This new encryption was an enhancement done for SYSPRO 7 onwards

 

 

 

 

Figure 2

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

CFC/ZAR (Standard Bank)

 

 

 

 

 

 

 

 

Figure 1

Subsystem type - May be either "CFC" or "ZAR"
Finance currency - The currency that must appear on the bank file must be entered here. It cannot exceed 3 characters and is mandatory. Selecting the browse button will show a list of BTS available currencies as per Figure 2
File version - Will always be 0.05
User statement reference - This decides what will appear on the Customer statement reference on the file that is sent to the bank: "Supplier name", "EFT number/Supplier code" or "EFT number/Supplier name".

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 2

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

There are extra details required when using this BTS bank format. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, the following screen as per Figure 3 will be seen:

Figure 3

Beneficiary code - This is a maximum of 16 characters and is mandatory
Beneficiary type - This button option man either be "Entity" or "Individual"
Beneficiary name - This is only entereable when the the Beneficiary type is set to "Individual" and is then mandatory
Beneficiary surname - This is only entereable when the the Beneficiary type is set to "Individual" and is then mandatory
Beneficiary currency - This is a maximum of 16 characters and is mandatory. Selecting the browse button will show a list of available currencies as per Figure 2
Cover type - May be selected from the available drop down list as per Figure 4
Spot type - This is a maximum of 10 numerics and is mandatory and enterable only if Cover type is set to "Spot cover"
Forward exchange contract - This is a maximum of 10 numerics and is mandatory and enterable only if Cover type is set to "FEC cover"
Free format cover info - This is a maximum of 75 characters and is mandatory and enterable only if Cover type is set to "FEC info"
Statement reference - This is a maximum of 75 characters and is optional
Preferred IBC - This is a maximum of 8 numerics and is optional
Compliance type - May be selected from the available drop down list as per Figure 5
Excon approval number - This is a maximum of 8 characters and is optional
Authorised dealer code - This is a maximum of 3 characters and is optional
Excon application date - This must be a valid date if entered with a maximum of 8 numerics YYYMMDD and is optional

 

 

Figure 4

 

 

 

Figure 5

 

 

 

Figure 6

 

 

 

Figure 7

The details for either/or BOP1 or BOP4 details are needed. If neither are entered("Not required"), an error will be seen as per Figure 6. If both are entered, an error will be seen as per Figure 7

BOP1 Details (if set to anything but "Not required")
BOP1 Category - May be selected from the available drop down list as per Figure 8
BOP1 Country - This is a maximum of 2 characters and is mandatory. Selecting the browse button will show a list of available country codes
BOP1 Import control format - This may be set to "Not required", "BOE-Bill of entry" or "INV-Offshore invoice". Selecting the browse button will show a list of available country codes
BOP1 Import control no. BOE date - Only available for entry and mandatory if BOP1 Import control format is set to "BOE-Bill of entry". This must be a valid date if entered with a maximum of 8 numerics YYYMMDD and is mandatory
BOP1 Import control no. BOE alpha - Only available for entry and mandatory if BOP1 Import control format is set to "BOE-Bill of entry". This is a maximum of 3 characters and is mandatory
BOP1 Import control no. BOE numeric - Only available for entry and mandatory if BOP1 Import control format is set to "BOE-Bill of entry". This is a maximum of 7 numerics and is mandatory
BOP1 Import control no. INV number - Only available for entry and mandatory if BOP1 Import control format is set to "INV-Offshore invoice". This is a maximum of 32 characters and is mandatory
BOP1 Reason information - This is a maximum of 50 characters and is optional
BOP1 Exchange control reference - This is a maximum of 8 characters and is optional
BOP1 Authorised dealer code - This is a maximum of 3 characters and is optional
BOP1 Reference authorised date - This must be a valid date if entered with a maximum of 8 numerics YYYMMDD and is optional

 

 

Figure 8

BOP4 Details (if set to anything but "Not required")

All the rules behind the BOP4 Details are the same as those from BOP1 Details above.

BEFT (Standard Bank)

 

 

 

 

 

 

 

 

Figure 1

Abbreviated acc name - An abbreviated acc name for your company. May not exceed 10 characters and is mandatory. This field appears on the extracted bank file as the user reference
Installation ID from - This is a 4 character field and is mandatory
Installation ID to - This is a 4 character numeric field and is mandatory
Installation gen-no - This is a 4 character numeric field and is mandatory
ACB service type - This is a 10 character field that must be selected from an available drop-down list (as per Figure 2) and is mandatory
User sequence-no - This is a 6 character numeric field and is mandatory
Contra sequence-no - This is a 6 character numeric field and is mandatory
Control sequence-no - This is a 6 character numeric field and is mandatory

 

 

 

Figure 2

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

BOL (Standard Bank)

 

 

 

 

 

 

 

 

Figure 1

There are no extra parameters required for this bank format

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

nBOL (Standard Bank)

 

 

 

 

 

 

 

 

Figure 1

Bank statement post method - This determines the post method: whether the transactions must be either "Total amount post" or "Post in detail" (selected from the available drop down list)
Processing value - This determines the processing value: whether the transactions must be either "Normal" or "Urgent" (selected from the available drop down list)
Charges bearer - This may be "OUR" - if the charges are the companies, "BEN" - if the changes belong to the Beneficiaries or "SHA" - if the charges are shared between the two (selected from the available drop down list)
User statement reference - This determines what the user would like to see as the statement reference: may be "Supplier number", "Supplier name", "EFT number", "EFT number/supplier code" or "EFT number/supplier name" (selected from the available drop down list)
This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

There are extra details required when using this BTS bank format. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, the following screen as per Figure 2 will be seen:

 

Figure 2

Country from - This field must be selected from an available drop-down list (as per Figure 3) and is mandatory
Payment type - Button selection that may either be "Local payment" or "Cross border payment". If Cross border payment is selected, then the Payment reason (maximum of 35 characters) is mandatory.
Charges bearer - Button selection that may be "OUR", "SHA" or "BEN".
The following fields are only available if the Pre-defined beneficiary is not selected
Account number - May not exceed 35 characters and is mandatory
IBAN account number - May not exceed 35 characters and is optional
Bank BIC - May not exceed 35 characters and is optional
Branch code - May not exceed 10 characters and is mandatory
The Non-predefined  Beneficiary information is optional

 

 

 

Figure 3

If Pre-defined beneficiary is selected, the screen will look as per Figure 4:

 

Figure 4

Identification code - May not exceed 35 characters and is mandatory

NetPlus (Standard Bank)

 

 

 

 

 

 

 

 

Figure 1

There are no extra parameters required for this bank format
This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

There are extra details required when using this BTS bank format. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, the following screen as per Figure 2 will be seen:

 

 

 

 

 

 

 

Figure 2

Sort code - May not exceed 8 characters and is mandatory
Account number - May not exceed 13 character numerics and is mandatory
Currency - May not exceed 3 characters and is mandatory. A browse facility has been made available should you wish to search SYSPRO for available currency codes
Email address - May not exceed 50 characters and is optional

Focus (Absa)

 

 

 

 

 

 

 

 

Figure 1

There are no extra parameters required for this bank format

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

CashFocus (Absa)

 

 

 

 

 

 

 

 

Figure 1

There are no extra parameters required for this bank format

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

Business Inttegrator (Absa)

 

 

 

 

 

 

 

 

Figure 1

There are no extra parameters required for this bank format

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

Nedinform (Nedbank)

Figure 1

EFT type - Identify the type of payment used. May either be "FREE-FORMAT" or "PRE-FORMAT". This is determined by the contract made with the bank.
Transaction type - Identify the type of transactions. May either be "SUPPLIERS" or "SALARIES/PENSION".
Debit line no -  This is a 10 character numeric field and may not be zero.
Seed number -  This is a free format 32 character field and is optional (may be left blank).
Flexible description - May be "Blank", Yes" or "No".
One-to-many transactions - May be "Blank", Yes" or "No".
Many-to-one transactions - May be "Blank", Yes" or "No".
Single transaction - May be "Blank", Yes" or "No".
Variable length bank file - Yes (if this check box is ticked)/No (if the check box is not ticked). This will affect the length of the records in the file that is extracted and sent to the bank.
Swaziland (.TXT) - If this is ticked, the file that is extracted by BTS is a .TXT file (not a .IMP file). There are also slight changes to the records as requested by Swaziland only.

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

There is one extra detail required when using this BTS bank format and the "PRE-FORMAT" option in Figure 1 has been selected. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, if the "Credit Line (NED)"  has not been captured, as per highlighted field in Figure 2:

Capture the Nedbank BENEFICIARY REFERENCE number in EFT USER-DEFINED FIELD 1 for the relevant suppliers. In the Setup/Financial/Electronic Funds Transfer "User Defined" tap setup (See Figure 3 below), you may rename this field to for example "Credit Line (NED)" as per the example in Figure 2 below.
This beneficiary reference number MUST match the number captured in the Nedbank software.

 

 

 

 

Figure 2

 

 

 

 

 

 

 

 

 

 

Figure 3

The following error as per Figure 4 will be seen if this EFT USER-DEFINED field 1 has no entered value:

 

 

 

Figure 4

NedExec (Nedbank)

 

 

 

 

 

 

 

 

Figure 1

EFT type - Identify the type of payment used. May only be "PRE-FORMAT". This is determined by the contract made with the bank.
Transaction type - Identify the type of transactions. May either be "SUPPLIERS" or "SALARIES/PENSION".
Debit line no -  This is a ten character numeric field and may not be zero.
Seed number -  This is a free format 32 character field and is mandatory (may not be left blank).

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

NetBank Secure (Nedbank)

 

 

 

 

 

 

 

 

Figure 1

Seed string -  This is a 32 character field that may only contain characters ABCDEF123456789 and is mandatory (may not be left blank).
Payment format - Identify the type of payment used. May either be "FREE-FORMAT" or "PRE-FORMAT". This is determined by the contract made with the bank.
This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

NOTE
This format  requires that an associated DLL is registered on the PC that is physically running the EFT extract.
This is handled automatically by the BTS process but should the DLL registration fail due to permission issues, please see the "NetBank Secure Format Procedure" tab under "BTS Installation".

CPS (Nedbank)

 

 

 

 

 

 

 

 

Figure 1

Abbreviated name - May not exceed 10 characters and is mandatory. This field appears on the extracted bank file as part of the supplier reference
Client identifier - This is a 2 character field and is mandatory
Client profile - This is a 10 character numeric field and is mandatory
Charges account - This is a 16 character numeric field and is optional (may be left as a zero)
Contract/Policy - This is a 14 character field and is mandatory. This field appears on the extracted bank file as part of the supplier reference
User defined reference - Identify what must appear in the reference field for the bank, the "Supplier name", "EFT number/Supplier code" or "EFT number/ Supplier name"
Run type - This field identifies the type of run. "Test" for a test run, and "Live" for a live run. The bank will treat the file accordingly

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

There are extra details required when using this BTS bank format. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, the following screen as per Figure 2 will be seen:

 

 

 

 

 

 

 

Figure 2

Branch code - May not exceed 9 character numerics and is mandatory
Account number - May not exceed 16 character numerics and is mandatory
Service type - This field must be selected from an available drop-down list (as per Figure 3) and is mandatory

 

 

Figure 3

CAMS (First National)

 

 

 

 

 

 

 

 

Figure 1

There are no extra parameters required for this bank format

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

PACS (First National)

 

 

 

 

 

 

 

 

Figure 1

Abbreviated acc name - An abbreviated acc name for your company. May not exceed 10 characters and is mandatory. This field appears on the extracted bank file as the user reference

Installation ID from - This is a 4 character field and is mandatory

Installation ID to - This is a 4 character numeric field and is mandatory

Installation gen-no - This is a 4 character numeric field and is mandatory

ACB service type - This is a 10 character field that must be selected from an available drop-down list (as per Figure 2) and is mandatory

User sequence-no - This is a 6 character numeric field and is mandatory

Contra sequence-no - This is a 6 character numeric field and is mandatory

Control sequence-no - This is a 6 character numeric field and is mandatory

 

 

 

Figure 2

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

BANKit (First National)

 

 

 

 

 

 

 

 

Figure 1

User statement reference - This decides what will appear on the Customer statement reference on the file that is sent to the bank: "Supplier name", "EFT number/Supplier code" or "EFT number/Supplier name".

Encryption required - Yes (if this check box is ticked)/No (if the check box is not ticked). If selected, a calculated encryption will be included in the BTS file extracted for the bank.

Exclude future payment date - Yes (if this check box is ticked)/No (if the check box is not ticked). If not selected,the date will populate the control record of the BTS file extracted for the bank.

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

CSV (First National)

 

 

 

 

 

 

 

 

 

Figure 1

User statement reference - This decides what will appear on the Customer statement reference on the file that is sent to the bank: "Supplier name", "EFT number/Supplier code" or "EFT number/Supplier name".

Encryption required - Yes (if this check box is ticked)/No (if the check box is not ticked). If selected, a calculated encryption will be included in the BTS file extracted for the bank.

Namibia - Yes (if this check box is ticked)/No (if the check box is not ticked). If selected, there are 2 fields on the Supplier Maintenance that are needed to be populated and these two fields appear on the payment extract file. If this fields is unticked (set to No, these fields are not used). Please note this feature is only available from SYSPRO 8 onwards.

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

There are extra details required when using this BTS bank format. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, the following screen as per Figure 2 will be seen:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 2

It is possible to send a payment notification to a maximum of 5 email addresses, 2 SMSs and 2 faxes. The notify fields above are used to action the details  entered.

All the fields in Figure 2 are optional and are generally explained below:

• notify fields - if entered to be used must contain Yes. The 2 fields following each notify field will be ignored by the bank if this field does not contain Yes
• email address fields - if entered to be used may not exceed 200 characters and must contain the email address to send the payment notification to
• subject fields - if entered to be used may not exceed 50 characters. These will be seen on the email to be sent as proof of payment
• code fields - if entered to be used must contain the first 3 digits of the cellphone or fax in question
• number fields - if entered to be used must contain the remaining 7 digits of the cellphone or fax number in question

SWIFT BIC code - This field is mandatory if the Namibia switch in the control has been selected for this format and optional if not selected. This field will replace the supplier's bank branch in the extracted file for Namibia. Please note this feature is only available from SYSPRO 8 onwards. Available options to select from as per Figure 3

Reason code - This field is mandatory if the Namibia switch in the control has been selected for this format and optional if not selected. This field is added to the end of the payment file only if Namibia in the control has been selected. Please note this feature is only available from SYSPRO 8 onwards. Available options to select from as per Figure 4

 

 

 

 

 

Figure 3

 

 

 

 

 

Figure 4

 

AiDPS Swazi (First National)

 

 

 

 

 

 

 

 

Figure 1

Customer ID - This is a 4 character numeric field. If not entered or left as zero, will default to "9999". n abbreviated name for your company. May not exceed 10 characters and is mandatory

Transaction code - This may be either "40-Direct Debits" or "71-Salaries".

Run type - This field identifies the type of run. "TEST" for a test run, and "LIVE" for a live run. The bank will treat the file accordingly

Next run number - This is a display field only. It is not enterable or updateable and shows the next run number. This will increment with each BTS run

Last date run - This is a display field only. It is not enterable or updateable and shows the next run number. This field will be blank if BTS has not been run before, else it will show the date the last run occurred

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

EFT (CITIBANK)

 

 

 

 

 

 

 

 

Figure 1

Decimal point - This may be either "Fullstop" or "Comma" and whichever is chosen will appear as the decimal point in the value fields that are extracted by the BTS program

Encryption required - Yes (if this check box is ticked)/No (if the check box is not ticked). If selected, a calculated encryption will be included in the BTS file extracted for the bank.

Encryption tool directory - This is a 70 character field that may contain the full path of the encryption directory and is only needed if the "encryption required" field has the check box ticked. A browse is available to allow the user to find the path. If the path entered is invalid or the user has no permissions to the folder entered, the error as per Figure 2 will be seen. If the path entered does not contain the file "CreateSMime.class", the error as per Figure 3 will be seen.

Java runtime path - This is a 100 character field and is optional. This field is not validated and if entered is used to populate extract information on the BTS file that is extracted for the bank.

Bank details from ApMaster - This is a display field only. It is not enterable or updateable.

Default to ACH payment type - This is a display field only. It is not enterable or updateable.

Default country code - This is a display field only. It is not enterable or updateable.

Default ACH entry class - This is a display field only. It is not enterable or updateable.

 

 

 

Figure 2

 

 

 

Figure 3

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

PAYLINK (CITIBANK)

 

 

 

 

 

 

 

 

Figure 1

Decimal point - This may be either "Fullstop" or "Comma" and whichever is chosen will appear as the decimal point in the value fields that are extracted by the BTS program

Encryption required - Yes (if this check box is ticked)/No (if the check box is not ticked). If selected, a calculated encryption will be included in the BTS file extracted for the bank.

Encryption tool directory - This is a 70 character field that may contain the full path of the encryption directory and is only needed if the "encryption required" field has the check box ticked. A browse is available to allow the user to find the path. If the path entered is invalid or the user has no permissions to the folder entered, the error as per Figure 2 will be seen. If the path entered does not contain the file "CreateSMime.class", the error as per Figure 3 will be seen.

Java runtime path - This is a 100 character field and is optional. This field is not validated and if enterd is used to populate extract information on the BTS file that is extracted for the bank.

Bank details from ApMaster - This is a display field only. It is not enterable or updateable.

Default to ACH payment type - This is a display field only. It is not enterable or updateable.

Default country code - This is a display field only. It is not enterable or updateable.

Default ACH entry class - This is a display field only. It is not enterable or updateable.

 

 

 

Figure 2

 

 

 

Figure 3

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

CITIDIRECT (CITIBANK)

 

 

 

 

 

 

 

 

Figure 1

Decimal point - This may be either "Fullstop" or "Comma" and whichever is chosen will appear as the decimal point in the value fields that are extracted by the BTS program

Encryption required - Yes (if this check box is ticked)/No (if the check box is not ticked). If selected, a calculated encryption will be included in the BTS file extracted for the bank.

Encryption tool directory - This is a 70 character field that may contain the full path of the encryption directory and is only needed if the "encryption required" field has the check box ticked. A browse is available to allow the user to find the path. If the path entered is invalid or the user has no permissions to the folder entered, the error as per Figure 2 will be seen. If the path entered does not contain the file "CreateSMime.class", the error as per Figure 3 will be seen.

Java runtime path - This is a 100 character field and is optional. This field is not validated and if enterd is used to populate extract information on the BTS file that is extracted for the bank.

Bank details from ApMaster - Yes (if this check box is ticked)/No (if the check box is not ticked).

Default to ACH payment type - Yes (if this check box is ticked)/No (if the check box is not ticked).

Default country code - This field is optional. A dropdown list is available as per Figure 4 for selection.

Default ACH entry class - This field is optional. A dropdown list is available as per Figure 5 for selection.

 

 

 

Figure 2

 

 

 

Figure 3

 

 

Figure 4

 

Figure 5

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

There are extra details required when using this BTS bank format. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, the following screen as per Figure 6 will be seen:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 6

Country - This field must be selected from an available drop-down list (as per Figure 4) and is mandatory

Payment method - This field must be selected from an available drop-down list (as per Figure 7) and is mandatory

Supplier narration 1 - May not exceed 35 characters and is optional

Supplier narration 2 - May not exceed 35 characters and is optional

BKT Information (only if Payment method is set to "BKT")

Destination branch - May not exceed 3 numerics and is optional

DFT Information (only if Payment method is set to "DFT")

DFT Bank route code - May not exceed 11 characters and is mandatory

RCH Information (only if Payment method is set to "RCH")

RCH Delivery method - This field must be selected from an available drop-down list (as per Figure 8) and is mandatory

ACH Information (only if Payment method is set to "ACH")

Entry class - This field must be selected from an available drop-down list (as per Figure 5) and is mandatory

Account type - This field must be selected from an available drop-down list (as per Figure 9) and is mandatory

ACH Beneficiary account - May not exceed 13 characters and is mandatory

ACH Bank route code - May not exceed 6 numerics and is mandatory

EFT Information (only if Payment method is set to "EFT")

Beneficiary account - May not exceed 34 characters and is mandatory

Beneficiary bank name - May not exceed 35 characters and is mandatory

Beneficiary bank addr1 - May not exceed 35 characters and is mandatory

Beneficiary bank addr2 - May not exceed 35 characters and is optional

Beneficiary bank addr3 - May not exceed 35 characters and is optional

Other instruction - This field must be selected from an available drop-down list (as per Figure 10) and is mandatory

Bank route method - This field must be selected from an available drop-down list and may only be "IS - SWIFT" and is mandatory

Charge indicator - This field must be selected from an available drop-down list (as per Figure 11) and is mandatory

Bank route code - May not exceed 11 characters and is mandatory

Beneficiary is - This field must be selected from an available drop-down list (as per Figure 12) and is mandatory

 

 

Figure 7

 

 

Figure 8

 

 

Figure 9

 

Figure 10

 

Figure 11

 

Figure 12

CITI Preformat (CITIBANK)

 

 

 

 

 

 

 

 

Figure 1

There are no extra parameters required for this bank format

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

Bureau (Bank Windhoek)

 

 

 

 

 

 

 

 

Figure 1

User code - This is a 4 character number field that is allocated by the bank and is mandatory.

ACB service - This may be either "Same day" or "Two day".

User statement reference - This decides what will appear on the Customer statement reference on the file that is sent to the bank: "Supplier name", "EFT number/Supplier code" or "EFT number/Supplier name".

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

BANK@bility (Mercantile)

 

 

 

 

 

 

 

 

Figure 1

There are no extra parameters required for this bank format

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

BOE (BOE Bank)

 

 

 

 

 

 

 

 

Figure 1

Abbreviated acc name - An abbreviated acc name for your company. May not exceed 10 characters and is mandatory. This field appears on the extracted bank file as the user reference

User code - This is a 4 character number field that is allocated by the bank and is mandatory.

ACB service - This is a 1 character field that must be selected from an available drop-down list (as per Figure 2) and is mandatory.

User statement reference - This decides what will appear on the Customer statement reference on the file that is sent to the bank: "Supplier name", "EFT number/Supplier code" or "EFT number/Supplier name".

BOE version no - This is a display field only and will always be "03". It is not enterable or updateable.

 

 

Figure 2

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

Global ACH GDFF (JP Morgan)

 

 

 

 

 

 

 

 

Figure 1

Client ID - This is a 10 character field and is mandatory. This field should be allocated by the bank.

User defined reference - This decides what will appear on the Customer statement reference on the file that is sent to the bank: "Supplier name", "EFT number/Supplier code" or "EFT number/Supplier name".

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

There are extra details required when using this BTS bank format. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, the following screen as per Figure 2 will be seen:

 

 

 

 

 

 

 

 

Figure 2

Destination country - This may only be ZA and is mandatory

Branch code - May not exceed 6 character numerics and is mandatory

Account number - May not exceed 13 character numerics and is mandatory

Supplier currency - May not exceed 3 characters and is mandatory. A browse facility has been made available should you wish to search SYSPRO for available currency codes

Transaction category - This field must be selected from an available drop-down list (as per Figure 3) and is mandatory

Statement reference - May not exceed 20 characters and is optional

 

 

 

Figure 3

 

FTI GMT (JP Morgan)

 

 

 

 

 

 

 

 

Figure 1

Client ID - This is a 8 character field and is mandatory. This field should be allocated by the bank.

User defined reference - This decides what will appear on the Customer statement reference on the file that is sent to the bank: "Supplier name", "EFT number/Supplier code" or "EFT number/Supplier name".

Last batch number - This is a display field only. It is not enterable or updateable and shows the last batch number used. This will increment with each BTS run.

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

There are extra details required when using this BTS bank format. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, the following screen as per Figure 2 will be seen:

Figure 2

Payment method - This field must be selected from an available drop-down list (as per Figure 3) and is mandatory

Payment location - This must be "JPJ-JHB held payments" and is mandatory

Country - May not exceed 2 characters and is mandatory. A browse facility has been made available should you wish to search SYSPRO for available country codes

Currency code - May not exceed 3 characters and is mandatory. A browse facility has been made available should you wish to search SYSPRO for available currency codes

Bank name - May not exceed 35 characters and is mandatory

Bank country - May not exceed 2 characters and is mandatory. A browse facility has been made available should you wish to search SYSPRO for available country codes

Account or IBAN number - May not exceed 34 characters and is mandatory

Bank swift ID - May not exceed 35 characters and is optional

SARB BOP code(TLX only) - May not exceed 35 characters and is optional

Correspondent charges - This field will default to "B-Beneficiary". the drop down selection will allow you select "R-Remitter" should you wish to change it

Debit bank charges - This field will default to "R-Remitter". the drop down selection will allow you select "B-Beneficiary" should you wish to change it

Beneficiary type - This field will default to "N-Beneficiary is not a bank". the drop down selection will allow you select "B-Beneficiary is a bank" should you wish to change it

Statement reference - May not exceed 16 characters and is optional

All the Intermediary details fields are optional

Identifier, Name, Address 1, Address 2 and Address 3 - May not exceed 35 characters

Swift ID - May not exceed 11 characters

Intermediary country - May not exceed 2 characters. A browse facility has been made available should you wish to search SYSPRO for available country codes

 

Figure 3

 

SFI (Stanbic)

 

 

 

 

 

 

 

 

Figure 1

There are no extra parameters required for this bank format

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

CSV NBOL (Stanbic)

 

 

 

 

 

 

 

 

Figure 1

User statement reference - This determines what the user would like to see as the statement reference: may be "Supplier number", "EFT number/supplier code" or "EFT number/supplier name"

Charges bearer - This may be "OUR" - if the charges are the companies, "BEN" - if the changes belong to the Beneficiaries or "SHA" - if the charges are shared between the two

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

There are extra details required when using this BTS bank format. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, the following screen as per Figure 2 will be seen:

 

 

 

 

 

 

 

 

 

 

Figure 2

Instruction service level - May be "Normal", "Urgent" or "UrgentSA"

Account type - May be "Current", "Savings", "Transmission", "Bond" or "Subscription"

Account number - May not exceed 35 characters and is mandatory

IBAN account number - May not exceed 35 characters and is optional

Supplier currency - May not exceed 3 characters and is mandatory. A browse facility has been made available should you wish to search SYSPRO for available currency codes

BOP code - May not exceed 10 characters and is optional

Beneficiary code - May not exceed 16 characters and is optional

Country code - May not exceed 3 characters and is optional. A browse facility has been made available should you wish to search SYSPRO for available country codes

All the Financial Details fields are optional

Agent bank name and Intermediary bank name - May not exceed 70 characters

Agent bank address, Agent sort code, Intermediary bank address and Intermediary bank town - May not exceed 35 characters

Agent BIC code and Intermediary bank BIC - May not exceed 11 characters

Agent bank country - May not exceed 2 characters. A browse facility has been made available should you wish to search SYSPRO for available country codes

PAY ALERT (Stanbic)

 

 

 

 

 

 

 

 

Figure 1

There are no extra parameters required for this bank format

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

There are extra details required when using this BTS bank format. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, the following screen as per Figure 2 will be seen:

 

 

 

 

 

 

 

Figure 2

Account number - May not exceed 35 characters and is mandatory

Bank sort code - May not exceed 6 characters and is optional

Bank swiftcode - May not exceed 11 characters and is optional

IBAN code - May not exceed 35 characters and is optional

Statement reference - May not exceed 35 characters and is optional

Country code - May not exceed 2 characters and is mandatory. A browse facility has been made available should you wish to search SYSPRO for available country codes

Address line 1 - May not exceed 35 characters and is optional

Bank country code - May not exceed 2 characters and is mandatory. A browse facility has been made available should you wish to search SYSPRO for available country codes

Bank address line 1 - May not exceed 35 characters and is optional

Payment reason/BOP code and Payment reason/BOP code - May not exceed 50 characters and are optional

Intermediary bank details and Correspondence bank details - May not exceed 11 characters and are optional

SFI (Barclays)

 

 

 

 

 

 

 

 

Figure 1

There are no extra parameters required for this bank format

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

Local Payment (Barclays)

Figure 1

Bank code -  This is a 3 character numeric field and may not be zero.

Branch code -  This is a 3 character numeric field and may not be zero.

Exclude EFT number from bank file - Yes (if this check box is ticked)/No (if the check box is not ticked).

Supplier branch from EFT-USER1 field - Yes (if this check box is ticked) will extract the Branch from EFT-USER-DEFINE1 field/No (if the check box is not ticked) will extract the Supplier Branch.

BTC variations -  This has a drop down selection that is available and would look like Figure 2

Figure 2

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

Barclays.net (Barclays)

Figure 1

Remittance type -  This determines what must be extracted as the remittance. Options are: "Use SYSPRO" (which will use the information as entered and selected in SYSPRO), "E-mail address", "Fax number" or "SMS number" . If anything other than "Use SYSPRO" is selected, the user will need to enter the User defined remittance below

User defined remittance -  This field is only applicable if the previous Remittance type field has not been set to "Use SYSPRO". The rules behind this entered field is:

• "E-mail address" - 100 characters for e-mail address to be used as the remittance. This is not validated
• Fax/SMS number - Must start with '+' and be followed by at least 11 numbers that do not start with zero. A valid example is +27117814000. If the Fax or SMS number is invalid, the user will see the message as per Figure 2

 

 

 

Figure 2

Debtor BIC code -  This caters for 8 characters and is used in the extracted payment file

Extract currency -  This caters for 3 characters and is used in the extracted payment file

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

STS (Standard Chartered)

 

 

 

 

 

 

 

 

Figure 1

There are no extra parameters required for this bank format

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

iPAYMENTS (Standard Chartered)

 

 

 

 

 

 

 

 

Figure 1

There are no extra parameters required for this bank format

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

There are extra details required when using this BTS bank format. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, the following screen as per Figure 2 will be seen:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 2

Payment type - This field must be selected from an available drop-down list (as per Figure 3) and is mandatory. The the payment type selected is not supported in your country, you will see the error as per Figure 4

Debit country - This field must be selected from an available drop-down list (as per Figure 5) and is mandatory

Debit bank ID - May not exceed 11 characters and is optional

Payee bank code - May not exceed 11 characters and is optional

Payee local clear code - May not exceed 17 characters and is optional

Payee branch code - May not exceed 5 characters and is optional

Payee branch sub code - May not exceed 2 character numerics and is optional. This field is not available for entry when using "RTGS" Payment type

Payee account number - May not exceed 34 characters and is optional

Payment currency - May not exceed 3 characters and is optional

Debit currency - May not exceed 3 characters and is optional

Local charges to - May not exceed 10 characters and is optional

FX type - This field must be selected from an available drop-down list (as per Figure 6) and is optional

Counter pickup location - May not exceed 3 characters and is optional. This field is not available for entry when using "RTGS" Payment type

Payee id - May not exceed 35 characters and is optional

Statement reference - May not exceed 70 characters and is optional

The following is only required if the Payment type is "TT" as per Figure 7

Intermediary bank code - May not exceed 11 characters and is optional

Clearing code - May not exceed 105 characters and is optional

Foreign charges to - This field must be selected from an available drop-down list (as per Figure 8) and is optional

The following is only required if the Payment type is "LBC" or "IBC" as per Figure 9

Clearing zone code - May not exceed 30 characters and is mandatory

Delivery method - This field must be selected from an available drop-down list (as per Figure 10) and is mandatory

Drawee bank code - May not exceed 11 characters and is mandatory

Delivery to - This field must be selected from an available drop-down list (as per Figure 11) and is mandatory

 

 

 

Figure 3

 

 

 

Figure 4

 

 

Figure 5

 

 

Figure 6

 

 

Figure 7

 

Figure 8

 

 

 

Figure 9

 

 

Figure 10

 

Figure 11

SAB-iPAY (Standard Chartered)

 

 

 

 

 

 

 

 

Figure 1

There are no extra parameters required for this bank format

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

There are extra details required when using this BTS bank format. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, the following screen as per Figure 2 will be seen:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 2

Payment type - This field must be selected from an available drop-down list (as per Figure 3) and is mandatory

Debit country - This field must be selected from an available drop-down list (as per Figure 4) and is mandatory

Payee account number - May not exceed 34 characters and is optional

Payee bank code - May not exceed 11 characters and is optional

Payee branch code - May not exceed 5 characters and is optional

Payment currency - This field must be selected from an available drop-down list (as per Figure 3) and is mandatory

Debit currency - This field must be selected from an available drop-down list (as per Figure 3) and is mandatory

Statement reference - May not exceed 70 characters and is optional

Payee branch sub code - May not exceed 2 character numerics and is optional. This field is only available for entry when using "ACH" Payment type

Payee local clear code - May not exceed 17 characters and is optional. This field is not available for entry when using "BT" Payment type

Local charges to - This field must be selected from an available drop-down list (as per Figure 5) and is optional. This field is not available for entry when using "BT" or "ACH" Payment types

FX type - This field must be selected from an available drop-down list (as per Figure 6) and is optional.This field is not available for entry when using "BT" or "ACH" Payment types

The following is only required if the Payment type is "TT" as per Figure 7

Intermediary bank code - May not exceed 11 characters and is optional

Clearing code - May not exceed 105 characters and is optional

Foreign charges to - This field must be selected from an available drop-down list (as per Figure 5) and is optional

 

 

Figure 3

 

 

Figure 4

 

Figure 5

 

 

Figure 6

 

 

 

 

 

Figure 7

 

ePAYMENTS (Standard Chartered)

 

 

 

 

 

 

 

 

Figure 1

There are no extra parameters required for this bank format

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

Straight2B (Standard Chartered)

 

 

 

 

 

 

 

 

Figure 1

There are no extra parameters required for this bank format

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

There are extra details required when using this BTS bank format. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, the following screen as per Figure 2 will be seen:

 

 

 

 

 

 

 

 

Figure 2

Branch code - May not exceed 15 characters and is mandatory

Account number - May not exceed 34 characters and is mandatory

Bank code - May not exceed 11 characters and is mandatory

Currency - May not exceed 3 characters and is mandatory. Selecting the browse button will show a list of available SYSPRO currencies

Payment details 1 - May not exceed 70 characters and is optional

Payment details 2 - May not exceed 70 characters and is optional

Email address - May not exceed 255 characters and is optional

iFILE (HSBC)

 

 

 

 

 

 

 

 

 

Figure 1

Country code - Identify the country (nationality) the file is being extracted for. May either be "IN" (for India) or "ZA" (for RSA).

Institution code - Identify the institution. May either be "HBAP" or "HBEU".

Account currency - This the currency that must appear on the bank file must be entered here. It cannot exceed 3 characters and is mandatory. Selecting the browse button will show a list of BTS available currencies as per Figure 2.

Hexagon ABC ID - This is an 11 character field and is mandatory. This is used as the Customer ID.

HSBC net ID - This is an 18 character field and is mandatory. This is used as the HSBC ID.

Account number - This is a 35 character field and is mandatory. This is the customer account number.

File format - Will always be "IFILE"

File type - Will always be "CSV"

Authorization type - This is the authorization that needs to be supplied by the bank and can be: "P", "F", "V" or "S"

File version - Will always be 1.0

ADV required - Yes (if this check box is ticked)/No (if the check box is not ticked). This determines if the relevant records need to be extracted or not.

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 2

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)

There are extra details required when using this BTS bank format. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, the following screen as per Figure 3 will be seen:

Figure 3

Instruction type - This field must be selected from an available drop-down list (as per Figure 4) and is mandatory

Beneficiary country code - May not exceed 2 characters and is mandatory. A browse facility has been made available should you wish to search SYSPRO for available currency codes

Payment currency - May not exceed 2 characters and is mandatory. A browse facility has been made available should you wish to search SYSPRO for available currency codes. This field is not available for entry is the Instruction type is "ACC" or "ICO".

Account number - May not exceed 11 character numerics and is mandatory only if the Instruction type is "ACH"

Branch number - This field must be selected from an available drop-down list (as per Figure 5) and is mandatory only if the Instruction type is "ACH"

Reference - May not exceed 34 characters and is mandatory only if the Instruction type is "ACH"

The following Email fields are only available for entry if the ADV required field has been selected in Figure 1

Email address 1 - May not exceed 70 characters and is mandatory

Email address 2 & 3 - May not exceed 70 characters and is optional

The following is only available for maintenance if the Instruction type is set to "PP", "RTGS", "IAT" or "NEFT" (as per Figure 6)

Account number - May not exceed 35 characters and is mandatory

Charge details - This field must be selected from an available drop-down list (as per Figure 7) and is mandatory (unless the Instruction type is set to "PP", then this field is optional)

Bank ID/SWIFT code - This field must be selected from an available drop-down list (as per Figure 8) and is optional

Bank ID/SWIFT address - May not exceed 34 characters and is optional (unless the Instruction type is set to "NEFT" or "RTGS" then this field is mandatory)

Bene bank name - May not exceed 35 characters and is mandatory. Only available when only when the Instruction type is set to "PP"

Bene bank address 1 - 3 - May not exceed 35 characters. Only Bene bank address 1 is mandatory and the others are optional. Only available when only when the Instruction type is set to "PP"

Reference - May not exceed 35 characters and is optional. Only available when only when the Instruction type is set to "PP"

Bene CHIPS UID - May not exceed 6 characters and is optional. Only available when only when the Instruction type is set to "PP"

The following is only available for maintenance if the Instruction type is set to "ACC", "ICO", "IDD" (as per Figure 9)

Institution code - This field must be selected from an available drop-down list and if entered, may only be "HBAP". This field is mandatory

Deduct charge flag - This field must be selected from an available drop-down list and if entered, may only be "B" or "C". This field is mandatory

Printing location - This field must be selected from an available drop-down list and if entered, may only be "Bangalore". This field is mandatory

Payable locations - May not exceed 100 characters and is optional, unless the Instruction type is set to "IDD" - in which case it is mandatory . A browse facility has been made available should you wish to search SYSPRO for available payable locations.

Deliver to - This field must be selected from an available drop-down list and if entered, may only be "S" or "B". This field is mandatory

 

 

 

Figure 4

 

 

 

Figure 5

 

 

 

 

 

Figure 6

 

Figure 7

 

Figure 8

 

 

 

Figure 9

KCB Quickpay (Kenya Commercial)

 

 

 

 

 

 

 

 

Figure 1

There are no extra parameters required for this bank format

This BTS Bank format is available for the following SYSPRO Nationalities:

• RSA (Republic of South Africa)