Sage 300 ERP Bank Interface Seamless

The following steps will guide you through the process of exporting your bank data from Clarity, and importing the data into Sage.

 

Clarity Export:

*Ensure you have posted all payroll information.*

Steps:

  1. Go to Payroll > Export > Export to Bank Services Special.
  2. Enter the appropriate settings in Bank services parameters tab:
    1. Bank Code: This is the bank code in Sage. This bank code has to exist
    2. Statement Date: Date of the statement.
    3. Stock Code: Check Stock Code in the Bank record in Sage
    4. System Manager Version: Version of the system manager. Note: If you are using 5.6A, enter 56A (do not include the '.')  or if you are using 5.3, just enter 53
    5. Status: outstanding (3) or printed (9). For versions later than 5.3A, this has to be 3
      - If records exported with printed (9) status then Sage user can post them and the status will be changed to outstanding     
      - If records exported with outstanding (3) status, Sage will treat these entries as posted entries and Sage user will not be able to post them   
    6. User ID and password: These have to be entered in capital letters.
    7. Company ID: Company ID in Sage.
  3. Click on Next and select the items from the list to be exported and then click Export. 

Note: Only information that has not been previously exported will be included. If you wish to re-export data, you can do so using the ‘Export to Bank Service Special’ function (which is date-controlled).

 

Be the first to review this article