Compleat can fully integrate with Exchequer to share your accounts payable & purchasing data in real-time.

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

 

Compleat posts to Exchequer:

• Invoice data (header & line level)
• Credit note data (header & line level)
• URL link to invoice/credit note
• General ledger posting date
• "Hold for query" flag for daybook postings

 

Compleat receives from Exchequer:

• Supplier information (including bank details & 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 Compleat company to your Exchequer account. The setup process involves just a few quick steps to download & configure the connector.

It's quick & easy - we promise!

 

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 Exchequwe 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 foler (e.g.\Exchqr\BtrvSQL.Dat)

 

2. Download the connector

1. Log in to Compleat, & go to Configuration > Company Management.
2. Go to Connection.
3. Next to Connect to a new finance system, click Connect.
4. Click the Exchequer tile.
5. Next to Connector edition, tick the Exchequer checkbox, & click Download.

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

   
6. When the connector has finished downloading, click to open it in the bottom-left of your browser window.

   Keep Compleat open in your browser.

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

   Keep Compleat open in your browser.

9. Enter the email address from Compleat & the unique four digit pin in the Connector Configuration Tool, & click Next.
10. Your details are verified!

    Click Next.

11. Specify the BtrvSQL.Dat file when prompted.
    
12. The service is running & ready to integrate with Compleat.

3. Select the connector in Compleat

1. Go to Compleat, & click the Go Back button underneath your four digit pin.

   If you navigated away from this page, just go back to Configuration > Company management > 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, & click Search.
4. From the available companies drop-down, select the Exchequer company you'd like to connect to, & click Connect.
5. Compleat is collecting data from Exchequer.
6. Choose how you'd like invoices & credit notes to be labelled in Exchequer, & 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 Compleat to handle particular features in Exchequer.

   Recommended settings are selected by default.

Success!

You've connected your Compleat company to Exchequer.

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

4. Extra technical info

Toolkit Permissions & DCOM Configuration changes

Re-generating the BtrvSQL.dat file

Licenses

Toolkit Permissions & 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.

Click Start, click Run, and then type DCOMCNFG.

Expand Component Services - Computers - My Computer - DCOM Config

Right click on the Toolkit Object from the list of applications.

NOTE: For 64 bit environments, if you cannot find the Toolkit Object, run DCOM Config as follows:

 C:\Windows\SysWOW64\mmc.exe comexp.msc /32

Select Properties.

Click the Security tab.

Select Customize on the Launch and Activation Permissions.

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

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

Select Customize on the Access Permissions.

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

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

Click the Identity tab and then select The Launching User.

NOTE: 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.

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

Select File - Exit to close DCOMCNFG.

Restart the system. This should only 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 allows our connector to know 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.