Integrate iCompleat with Exchequer to enjoy real-time AP automation

Our Exchequer connector is a piece of software that you install on your local network. It manages and protects all the information that's passed between Exchequer and iCompleat. Any information shared is secure and encrypted.

 

iCompleat posts to Exchequer:

• Invoice data (header and line level)
• Credit note data (header and line level)
• URL link to invoice/credit note
• General ledger posting date
• "Hold for query" flag for daybook postings
• 'Authorized', 'On hold', and 'Not authorized' posting statuses (default state can be applied, with ability to override per transaction)
• New suppliers

 

iCompleat receives from Exchequer:

• Supplier information (including bank details and payment terms)
• Exchange rates/currencies
• General ledger accounts
• VAT rates
• Departments
• Delivery sites
• User-defined fields
• Journal reference of the posted invoice

 

This guide shows you how to connect your iCompleat company to your Exchequer account. The setup process involves just a few quick steps to download and configure the connector.

 

1. Generate the BtrvSQL.Dat file

Please ensure .NET framework 4.7.2 or later is installed on the Host machine Exchequer is installed on before attempting to install the connector.

It is recommended to install the connector on the Host machine that Exchequer is installed on.

1. Run SetupWks.exe in the WSTATION folder inside the Exchequer installation, follow the instructions and complete the setup.

2. Generate the BtrvSQL file

a) Open TESTCOM.exe in the root of the Exchequer installation

b) Right click on "Diagnostics" to bring up the option to "Setup BtrvSQL Config".

This will generate the following file in the root of the Exchequer folder (e.g.\Exchqr\BtrvSQL.Dat)

 

2. Download the connector

1. Log in to iCompleat, and click Configuration.
2. Click Company.
3. Go to Connection.
4. Next to Connect to a new finance system, click Connect.
5. Click the Exchequer tile.
6. Choose Exchequer from the drop-down, and click Download.

   In the future, any updated versions of the connector we develop will be listed here.

   
7. When the connector has finished downloading, go to where downloads are stored on your PC and open it.

   Keep iCompleat open in your browser.

8. The Connector Configuration Tool opens.
9. Go back to iCompleat Connection area and make a note of your email address and the unique four digit pin.

   Keep iCompleat open in your browser.

10. In the Connector Configuration tool, enter the email address from iCompleat and the unique four digit pin, and click Next.
11. Your details are verified!

    Click Next.

12. Specify the BtrvSQL.Dat file when prompted.
    
13. The service is running and ready to integrate with iCompleat.

3. Select the connector in iCompleat

1. Go to iCompleat, and click the Go Back button underneath your four digit pin.

   If you navigated away from this page, just go back to Configuration > Company > Connection.

   
2. Next to Use existing connection, click Use.

   If you've connected to a finance system before, you'll see the message Multiple connectors are available.

3. Select Exchequer from the drop-down, and click Search.
4. From the available companies drop-down, select the Exchequer company you'd like to connect to, and click Connect.
5. iCompleat is collecting data from Exchequer.
6. Choose how you'd like invoices and credit notes to be labelled in Exchequer, and click Save.

   If you have other custom transaction names set up in Exchequer, they'll be available to select from the drop-downs.

7. Choose how you'd like iCompleat to handle particular features in Exchequer.

   Recommended settings are selected by default.

Success!

You've connected your iCompleat company to Exchequer.

iCompleat and Exchequer can now share data, and iCompleat can begin posting invoices and credit notes.

 

 

4. Extra technical info

Toolkit Permissions and DCOM Configuration changes

Re-generating the BtrvSQL.dat file

Licenses

 

Toolkit Permissions and DCOM Configuration changes.

(Instructions taken from the Exchequer toolkit help file located in Excheqr\SDK\ComTK)

 

When the COM Toolkit is registered within Windows only certain permissions are automatically granted due to security. For the COM Toolkit to operate, the following changes may need to be made.

1. Click Start, click Run, and type DCOMCNFG.
2. Expand Component Services - Computers - My Computer - DCOM Config
3. Right-click on the Toolkit Object from the list of applications.

   For 64 bit environments, if you can't find the Toolkit Object, run DCOM Config as follows: C:\Windows\SysWOW64\mmc.exe comexp.msc /32

4. Select Properties.

5. Click the Security tab.

6. Select Customise on the Launch and Activation Permissions.

7. Click Edit.

   Verify that the following users are listed in the launch permissions, or add the users if they are not listed:

       - INTERACTIVE

       - Everyone

       - Administrators

       - NETWORK SERVICE

8. Set the all permissions for each of the users to Allow, and click OK.

9. On the Access Permissions, select Customize.

10. Click Edit. Verify that the following users are listed in the launch permissions, or add the users if they are not listed:

        - INTERACTIVE

        - Everyone

        - Administrators

        - NETWORK SERVICE

11. Set the all permissions for each of the users to Allow, and click OK.

12. Click the Identity tab, then select The Launching User.

    By using the Launching User this allows you to control which user will launching the COM Toolkit as it will be the same user as the unattended application.

13. Click OK to close the property dialog box and return to the main applications list dialog box.

14. Select File - Exit to close DCOMCNFG.

15. Restart the system.

    This should only be required if changes have not been previously made to the Toolkit Object.

 

Re-generating the BtrvSQL.dat file

When the BtrvSQL file is generated, it creates a list of companies, their codes, names, and UNC file paths. This tells our connector where to point the Exchequer Toolkit in order to cache and post data to/from iCompleat.

In the event that you move the company folder, or add a new company, you must follow the steps to generate the BtrvSQL.dat file again so that the file is up to date.

 

Licenses

We have noticed that if the COM Toolkit license is missing from the Exchequer installation, the toolkit does not error, but instead attempts to open a windows dialog and locks up. If your connector installs correctly, but continually locks up upon attempting to cache, please verify your licenses as a first point of call.

 

 Still got questions? Comment below and let us know how we can improve this article.