Bank Integration - Host to Host Procedure

The term Host to Host (H2H) refers to the direct integration of the corporate Financial or ERP system and Eco Bank Online Banking platform. This integration makes it possible for a two-way direct communication between the corporate ERP and Eco Bank Omni Online Banking Platform. This seamless approach makes it possible for real-time high volume transaction processing between corporate and bank. A similar procedure can be used for other banks as well looking to integrate with Sage X3 ERP.

Benefits of Host-to-Host Integration

The following are some of the benefits of a Host-to-Host Implementation;

Initiate and complete payment instructions by corporate from ERP.

Instant feedback on transaction status and feeding same information to ERP.

High volume and high speed instructions for mass collections and payments Allows corporate to maintain one point of transaction initiation and authorization Savings on Payment instruments such as Cheques.

Increased security and confidentiality.

Automated reconciliation using transaction reports which contain original reference numbers.

Scope of Integration 1

Payment Remittance

Payment Remittance file generation from Sage x3.

Export the remittance file and mark it so it can be send to bank SFTP location.

A scheduler will be created by Greytrix which will read all the marked remittance entries and generate an encrypted file.

Encrypted file will be generated in PGP format using public key shared by both by Greytrix & ECO Bank.

By using both key Greytrix will encrypt the file and later using the same keys bank will decrypt the file.

The Encrypted file will then be send to the Bank SFTP location using a specific IP (156.0.82.28) and port (22).

Upon receiving the file, it will be checked by the Eco Bank and later transferred to the Bank Iris Server.

Upon Checking again by ECO bank it will be further send to the Bank OMNI application and the payment will be processed.

The Host-to-Host Architecture – Payment Advice through Bank (One Direction)

Sage X3 Bank Remittance file generation architecture & encryption

Sage X3 to Bank SFTP Transmit Architecture

Functional & Technical Process

The Payment remittance will be generated after approval by the user in Sage X3. The remittance which is being approved and ready to be send to Bank. User will click on the new export Button on the remittance screen which will mark the remittance can be sent to the bank.

Scheduler service will be running in the background will check the remittance table for the record can be send to the bank.

Scheduler service then read the record and create the encrypted file and send to the SFTP location under bank environment.

Also the scheduler service will delete any local copy from the server. So user will not get hold of file being sent to the bank. They can view the content of the file from the bank portal only.

An encryption key will be provided both by the bank and Greytrix to encrypt the file and later using the key bank will decrypt the file.

The File will be checked by the Eco Bank and later transferred to the Bank Iris Server.

Upon Checking again by ECO bank it will be further send to the Bank OMNI application and the payment will be processed.

Note: Encryption will include the public key of the bank which will help the bank to identify the authencity of the file.

Scope of Integration 2

Bank Balance Update

Bank Reconciliation in Sage X3 through import of closing balance from ECO Bank.

ECO Bank will send the closing bank balance for the previous day through MT940 file format.

The file will be dropped into the ECO Bank SFTP location on Eco bank server.

Eco Bank will provide a user credentials for Client to login and access and upload the files into the SAGE X3.

Scheduler routine will copy the file locally (this will be temporary) to read it, then import the data in Sage X3 and delete the file immediately so it cannot be accessed latter.

After upload user will run the reconciliation process in Sage X3 application

The Host-to-Host Architecture – Bank Balance Up-dation (One Direction)

Functional & Technical Process

At the end of each day ECO Bank will send the current bank balance for the previous day through a MT940 file format. The file will be dropped into the SFTP location on Eco bank server.

Eco Bank will provide a user credentials for Client to login and access and import the statement files into the SAGE system.

MT940 file will be provided on daily basis by bank at 5am GMT.

Bank Integration Auto Scheduler

Configuration Details

STEP 1: Create scheduler task:

Go to Control Panel > Administrative Tools

Select Task Scheduler

Click on Create Task from the right side menu.

STEP 2: Details of Task

Click on General Tab

Name of the Task: Bank File Export(Example)

Description : Bank Integration

If task needs to run even user is not logged on select “Run whether user is logged in or not”,It will require the system credentials username and password to continue.

STEP 3: Specify condition to trigger the Task:

Click on Triggers Tab, click on New Button at the bottom of the screen

On setting section, click on Daily, Recur every 1 day and in advance setting select repeat task every 10 minutes.

Enabled check box should be checked

STEP 4: Specify executable file which needs to execute:

Click on Action Tab: Click New button on the bottom of the screen.

And Action field choose start of the program

Program/Script: click on browse and select the executable file from the path

Click on Ok.

STEP 5: Click on Refresh:

If the Task is not displaying in task scheduler then click on refresh button on the right side menu.

STEP 6: Run the Task

Select the task just created and click on Run button on the right-side Menu and the procedure will be completed.

About Us

Greytrix Africa is a leading Sage business partner and ISV Partner offering Consulting, Implementation, and development services for Sage X3, Sage 300, Sage 300 People (HRMS), Sage CRM, and Sage Intacct, which covers East Africa, West Africa, SADC, and Middle East region. We offer professional services such as Implementation and Configuration, Business Process Analysis, Project Management, Integrations and Migrations, and Technical & Functional Support, along with enhancements within Sage X3, Sage 300 People (HRMS), Sage 300, Sage CRM, and Sage Intacct across various industry verticals like Process Manufacturing (Food & Beverages, Chemical), Discrete manufacturing (Automotive, Textile & Apparel), Non-Profit, Health-care Industry and Services Industry (Financial, Software & Engineering), Distribution (Transportation & Logistics), and Agriculture.

Sage Solutions

Other Solutions

E-invoicing Solutions for

Sage Solutions

Other Solutions

Integrations

Addons

Integrations

Sage X3-Integrations

Sage Intacct Integrations

Sage 300 Integrations

addons

Sage X3 Add-ons

Sage Intacct Add-ons

Sage 300 Addons

Process Manufacturing

Distribution

Discrete Manufacturing

Service Industry

Industry Specific

Blogs

Video Gallery

Sage Solutions

Other Solutions

E-invoicing Solutions for

Sage Solutions

Other Solutions

Integrations

Addons

Integrations

Sage X3-Integrations

Sage Intacct Integrations

Sage 300 Integrations

addons

Sage X3 Add-ons

Sage Intacct Add-ons

Sage 300 Addons

Process Manufacturing

Distribution

Discrete Manufacturing

Service Industry

Industry Specific

Blogs

Video Gallery

Bank Integration - Host to Host Procedure