Bank Translation System Documentation BTS-White-100px

Experiencing problems…?    Try searching our Frequently Asked Questions for a solution.



  • 1.BTS Installation
  • Download the BTS installation

    nikki31-08-2016

    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.

    SourceIT_BTS

     

    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.

    MyAccountPage

  • Load BTS programs onto SYSPRO server

    nikki31-08-2016

      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

    1.1.1_Upgrade_1.1.1

     

     

     

     

    Figure 1.1.1

    Yesa screen as per Figure 1.1.2 will be displayed.
    Nothe installation will abort.

    Programs_1.2

    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.

    1.1.1_Upgrade_1.1.1

     

     

     

     

    Figure 1.1.3

    Yesthe associated BTS program files will be loaded into their relevant SYSPRO folders on the SYSPRO server.
    Nothe 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.

    1.1.4_LoggedOut_1.1.4

     

     

     

    Figure 1.1.4

     

  • Initialise the BTS system

    nikki31-08-2016

    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.

    1.2.1_Sitini_1.2.1

     

     

     

     

    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.

    SITINI_BTS

     

     

     

     

     

     

    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)

    SystemSetup_new

     

     

     

     

     

     

     

     

     

     

     

     

    Figure 1.2.3

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

    Menu_1.7

     

     

     

     

     

     

     

     

     

     

     

     

    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.

    1.2.5_MenuExists_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.

    groupmaint_1-9

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    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

    1.2.7_SecurityMenu_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

    reindex_1-11

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    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

    1.2.9_ReIndex_Exists_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

    1.2.10_SITINI_Complete_1.2.10

     

     

     

    Figure 1.2.10

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

    Trigger_1.12(sbe 1.13)

     

     

     

     

     

     

     

     

     

     

     

     

     

    Figure 1.2.11

     

    Trigger2_1.13(sbe 1.14)

     

     

     

     

     

     

     

     

     

     

     

     

     

    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

     

    1.2.10_SITINI_Complete_1.2.10

     

     

     

    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.

  • BTS License Process

    nikki05-09-2016

    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

    BTSRelicense_new

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Figure 2.4.5

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

    2.4.5.4_MANNo_License_2.4.5.4

     

     

     

    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.

    BTSLicense

     

     

     

     

     

     

     

     

    Figure 2.4.5.3

    Expiry dateenter the license expiry date as. To ensure correct date format, make use of the date browser to select the expiry date.
    New Codeenter the license code as issued by the Source IT offices.
    Savewill 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.
    Closewill 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).

    2.4.5.3_MANLicenseExp2Days_2.4.5.3

     

     

     

    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.

  • BTS Upgrade From 6.1 and Earlier Conversion Process

    nikki05-09-2016

    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

    Conversion_new

     

     

     

    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

    btcnv7_new

     

     

     

     

    Figure 2

    Selecting OK will show the screen as per Figure 3

    BTCNV7_screen_newFigure 3

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

    btcnv7_results_new

    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.

    btcnv7_comp_new

     

     

     

    Figure 5

  • NetBank Secure Format Procedure

    nikki06-09-2016

    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:\windows\microsoft.net\framework\v2.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:\syspro71\base\btsned\BTSNEDHash.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:\syspro71\base\btsned\BTSNEDHash.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. Source IT has obtained a copy of this document and it can be found at www.source-it.co.za
    • 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

    NedbankDemo

     

     

     

     

     

     

     

     

    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.

  • Definition of Terms

    nikki06-09-2016
    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.
  • 2.BTS Overview
  • BTS Description

    admin16-07-2016

    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.

  • BTS Failure Consideration

    nikki06-09-2016

    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

    BTSFail_new

     

     

     

     

     

     

     

    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
    nationality

     

     

     

     

    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.

  • 3.BTS Process
  • BTS Menu

    nikki06-09-2016

    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.

    Menu_1.7

     

     

     

     

     

     

     

     

     

     

     

     

    Figure 3.1.1

  • Supplier/Beneficiary Banking Details

    nikki07-09-2016

    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.

    BankMaintenance_unused

     

     

     

     

     

     

     

     

     

     

     

     

     

    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

    Supplier_Maint_3.3.2

    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.

    EFTBankControl_unused

     

     

     

     

     

     

     

     

    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.

  • EFT Batch extract/re-extract process

    nikki07-09-2016

    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.

    EFT_bank_path_new

     

     

     

     

     

     

     

     

    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)

  • BTS Reports

    nikki07-09-2016

    The "List of EFT Suppliers" 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

    EFT_Report

     

     

     

     

     

     

     

    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. (See APPENDIX B)
    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 (See
    APPENDIX D). The report provides a listing of:
    - totals per supplier per invoice
    - a grand total
    This report should be filed for future audit requirements.

  • SYSPRO Setup Requirements and Routines

    nikki18-10-2016

    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.

     

  • BTS System Requirements

    nikki18-10-2016

    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)

  • 4.BTS Bank Format Setup
  • Assigning SYSPRO bank to a BTS format

    admin16-07-2016

    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.

    BTMCTL_3.2.1

     

     

     

     

     

     

     

     

     

    Figure 1

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

    CTL_Focus(Absa)_noetxra

     

     

     

     

     

     

     

     

    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)

    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)

    admin22-03-2018

    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 1 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 1 and 9

    Sub-level authority allowed - If the Payment approval is ticked, the user may tick this entry allowing level 1 and level 2 authorisers to overwrite for each other

    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

     

     

     

     

     

    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

    The files extracted by this BTS SWIFT format are XML files. The feedback files from Standard Bank are also XML files. These feedback files need to be placed in the XML dashboard path as show in figure 1.

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

    Figure 5

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

    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 6

     

     

     

    Figure 6

    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 7

     

    Figure 7

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

     

     

     

    Figure 8

  • CATS (Standard Bank)

    admin16-07-2016

    CATS (Standard Bank)

    ctl_catsstandard-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 referenceIdentify 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)"  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)

    nikki08-09-2016

    EFTS (Standard Bank)

    ctl_eftsstandard-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 algorithmMay be either "No" or "Yes". This new encryption was an enhancement done for SYSPRO 7 onwards

    btpefr_new

     

     

     

     

    Figure 2

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

    • RSA (Republic of South Africa)
  • CFC/ZAR (Standard Bank)

    nikki08-09-2016

    CFC/ZAR (Standard Bank)

    ctl_cfczarstandard-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".

     

    bts-currency_new

     

     

     

     

     

     

     

     

     

     

     

     

     

    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)

    nikki08-09-2016

    BEFT (Standard Bank)

    ctl_beftstandard-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

    beft_extra_new

     

     

     

    Figure 2

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

    • RSA (Republic of South Africa)
  • BOL (Standard Bank)

    nikki13-09-2016

    BOL (Standard Bank)

    ctl_bolstandard-bank_noextra

     

     

     

     

     

     

     

     

    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)

    nikki13-09-2016

    nBOL (Standard Bank)

    ctl_nbolstandard-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 numberMay 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 codeMay 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)

    nikki13-09-2016

    NetPlus (Standard Bank)

    ctl_netplusstandard-bank_noextra

     

     

     

     

     

     

     

     

    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)

    nikki13-09-2016

    Focus (Absa)

    ctl_focusabsa_noetxra

     

     

     

     

     

     

     

     

    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)

    nikki13-09-2016

    CashFocus (Absa)

    ctl_cashfocusabsa_noextra

     

     

     

     

     

     

     

     

    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 Integrator (Absa)

    nikki13-09-2016

    Business Inttegrator (Absa)

    ctl_business-intergratorabsa_noextra

     

     

     

     

     

     

     

     

    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)

    nikki13-09-2016

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

    nikki13-09-2016

    NedExec (Nedbank)

    ctl_nedexecnedbank

     

     

     

     

     

     

     

     

    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)

    nikki13-09-2016

    NetBank Secure (Nedbank)

    ctl_netbank-securenedbank

     

     

     

     

     

     

     

     

    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)
  • CPS (Nedbank)

    nikki13-09-2016

    CPS (Nedbank)

    ctl_cpsnedbank

     

     

     

     

     

     

     

     

    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)

    nikki13-09-2016

    CAMS (First National)

    ctl_camsfirst-national_noextra

     

     

     

     

     

     

     

     

    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)

    nikki13-09-2016

    PACS (First National)

    ctl_pacsfirst-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

    beft_extra_new

     

     

     

    Figure 2

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

    • RSA (Republic of South Africa)
  • BANKit (First National)

    nikki14-09-2016

    BANKit (First National)

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

    nikki14-09-2016

    CSV (First National)

    ctl_csvfirst-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 incryption will be included in the BTS file extracted for the bank.

    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

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

    • notify fields may not exceed 40 characters
    • email address fields may not exceed 200 characters
    • subject fields may not exceed 50 characters
    • code fields may not exceed 20 characters
    • number fields may not exceed 40 characters
  • AiDPS Swazi (First National)

    nikki14-09-2016

    AiDPS Swazi (First National)

    ctl_aidps-swazifirst-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)

    nikki14-09-2016

    EFT (CITIBANK)

    ctl_eftcitibank

     

     

     

     

     

     

     

     

    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.

    eftcitibankctl_error

     

     

     

    Figure 2

    eftcitibankctl_error2

     

     

     

    Figure 3

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

    • RSA (Republic of South Africa)
  • PAYLINK (CITIBANK)

    nikki14-09-2016

    PAYLINK (CITIBANK)

    ctl_paylinkcitibank

     

     

     

     

     

     

     

     

    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.

    eftcitibankctl_error

     

     

     

    Figure 2

    eftcitibankctl_error2

     

     

     

    Figure 3

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

    • RSA (Republic of South Africa)
  • CITIDIRECT (CITIBANK)

    nikki14-09-2016

    CITIDIRECT (CITIBANK)

    ctl_citidirectcitibank

     

     

     

     

     

     

     

     

    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.

    eftcitibankctl_error

     

     

     

    Figure 2

    eftcitibankctl_error2

     

     

     

    Figure 3

    citidirect_drop1

     

     

    Figure 4

    citidirect_drop2

     

    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)

    nikki14-09-2016

    CITI Preformat (CITIBANK)

    ctl_citi-preformatcitibank_noextra

     

     

     

     

     

     

     

     

    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)

    nikki14-09-2016

    Bureau (Bank Windhoek)

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

    nikki14-09-2016

    BANK@bility (Mercantile)

    ctl_bankbilitymercantile_noextra

     

     

     

     

     

     

     

     

    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)

    nikki14-09-2016

    BOE (BOE Bank)

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

    ctlboe_drop

     

     

    Figure 2

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

    • RSA (Republic of South Africa)
  • Global ACH GDFF (JP Morgan)

    nikki14-09-2016

    Global ACH GDFF (JP Morgan)

    ctl_global-ach-gdffjp-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)

    nikki14-09-2016

    FTI GMT (JP Morgan)

    ctl_fti-gmtjp-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)

    nikki14-09-2016

    SFI (Stanbic)

    ctl_sfistandbic_noextra

     

     

     

     

     

     

     

     

    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)

    nikki14-09-2016

    CSV NBOL (Stanbic)

    ctl_csv-nbolstanbic

     

     

     

     

     

     

     

     

    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)

    nikki14-09-2016

    PAY ALERT (Stanbic)

    ctl_pay-alertstanbic_noextra

     

     

     

     

     

     

     

     

    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)

    nikki19-09-2016

    SFI (Barclays)

    ctl_sfistandbic_noextra

     

     

     

     

     

     

     

     

    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)

    nikki19-09-2016

    Local Payment (Barclays)

    ctl_local-paymentbarclays

     

     

     

     

     

     

     

     

    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.

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

    • RSA (Republic of South Africa)
  • Barclays.net (Barclays)

    nikki19-09-2016

    Barclays.net (Barclays)

    ctl_barclays-netbarclays

     

     

     

     

     

     

     

     

    Figure 1

    Remittance type -  This determines what must be extracted a s 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

    barclays-net_error1

     

     

     

    Figure 2

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

    • RSA (Republic of South Africa)
  • STS (Standard Chartered)

    nikki19-09-2016

    STS (Standard Chartered)

    ctl_stsstandard-chartered_noextra

     

     

     

     

     

     

     

     

    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)

    nikki19-09-2016

    iPAYMENTS (Standard Chartered)

    ctl_ipaymentsstandard-chartered_noextra

     

     

     

     

     

     

     

     

    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)

    nikki19-09-2016

    SAB-iPAY (Standard Chartered)

    ctl_sab-ipaystandard-chartered_noextra

     

     

     

     

     

     

     

     

    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)

    nikki19-09-2016

    ePAYMENTS (Standard Chartered)

    ctl_epaymentsstandard-chartered_noextra

     

     

     

     

     

     

     

     

    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)

    nikki19-09-2016

    Straight2B (Standard Chartered)

    ctl_straight2bstandard-chartered_noextra

     

     

     

     

     

     

     

     

    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)

    nikki19-09-2016

    iFILE (HSBC)

    ctl_ifilehsbc

     

     

     

     

     

     

     

     

     

    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.

    bts-currency_new

     

     

     

     

     

     

     

     

     

     

     

     

     

    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)

    nikki21-09-2016

    KCB Quickpay (Kenya Commercial)

    ctl_kcb-quickpaykenya-commercial_noextra

     

     

     

     

     

     

     

     

    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)
  • Trade Payments CSV (CBA)

    nikki21-09-2016

    Trade Payments CSV (CBA)

    ctl_trade-payments-csvcba_noextra

     

     

     

     

     

     

     

     

    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)
  • BSI VDB (ABN Amro Bank)

    nikki21-09-2016

    BSI VDB (ABN Amro Bank)

    ctl_bsi-vdbabn-amro-bank_noextra

     

     

     

     

     

     

     

     

    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

    Transfer currencyMay not exceed 3 characters and is mandatory

    Intermediary bankMay not exceed 11 characters and is optional

    Account numberMay not exceed 34 characters and is mandatory

    Bank sort codeMay not exceed 17 characters and is optional

    Account residencyThis is a radio button and allows for either "Resident" or "Non-resident" options

    Beneficiary nameMay not exceed 35 characters and is optional

    AddressMay not exceed 35 characters and is optional

    Postal/zip codeMay not exceed 9 characters and is optional

    CityMay not exceed 35 characters and is optional

    Country ISO codeMay not exceed 2 characters and is optional

    Bank SWIFT IDMay not exceed 35 characters and is optional

    Bank nameMay not exceed 35 characters and is optional

    Bank cityMay not exceed 35 characters and is optional

    Bank country ISO codeMay not exceed 2 characters and is optional

  • FIHRST (Fihrst Management)

    nikki21-09-2016

    FIHRST (Fihrst Management)

    ctl_fihrstfihrst-management_noextra

     

     

     

     

     

     

     

     

    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)
  • BCI (Banco Comercial)

    nikki21-09-2016

    BCI (Banco Comercial)

    ctl_bcibanco-comercial_noextra

     

     

     

     

     

     

     

     

    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

    Conta(account number)May not exceed 21 characters and is mandatory

    Descritivo(reference)May not exceed 20 characters and is optional

  • NACHA (USA)

    nikki21-02-2017

    NACHA (USA)

    CTL_NACHA - USA

     

     

     

     

     

     

     

     

    Figure 1

    Format -  This will always be PPD

    Immediate destination code - This is a 10 character field and is mandatory.

    Immediate destination name - This is a 23 character field and is mandatory.

    Immediate origin code - This is a 10 character field and is mandatory.

    Immediate origin name - This is a 23 character field and is mandatory.

    Company name - This is a 16 character field and is mandatory. This is the abbreviated company name.

    Federal tax ID - This is a 10 character field and is mandatory.

     

  • BOA(Bank of Africa)

    admin11-03-2019

    BOA (Bank of Africa)

    Figure 1

    There are no extra parameters required for this 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

    Code BIC - This field is mandatory and must be entered. It may contain a maximum of 24 characters.

    Debtors Account - This field is mandatory and must be entered. It may contain a maximum of 24 characters.

    Reference Description - This field is mandatory and must be entered. It may contain a maximum of 70 characters and may not contain "special" characters. Valid characters are spaces, A - Z (both upper and lower case) as well as 0 - 9. Any other character be seen as an error and the message as per Figure 3 will be seen.

    Figure 3