Exchequer Enterprise (legacy)

How do I set to use this interface?

In the accounts centre record, select Exchequer (in the legacy group).

Cost Centre codes

Use the Records | Cost Centres menu in Enterprise to display your list of cost centres.  Note that you must have Use Cost Centres and Departments ticked in Utilities | System Setup | General Settings for this item to appear in the Records menu. Make a note of each cost centre code (the CC column) and its description.

Open the list of code classes in Match-IT using the Functions | Standing Data | All Code Classes menu. Locate the CostCentre line and go into the detail of the record.  Add each of the cost centres that you noted above.  We suggest that you use the Match-IT Instance ID and Full Name fields to represent the Enterprise Code and Description fields.  Use of the Match-IT Description field is optional, but for example it can be used to describe what you use that cost centre for.

Department codes

Use the Records | Department menu in Enterprise and proceed as above, adding department codes in Match-IT instead of cost centre codes.

Nominal  codes

Use the Match-IT All Code Classes menu as above to locate and edit the NominalAccount code class set to contain those nominal codes that you require.  These should be setup to match Enterprise.

VAT codes

Use the Functions | Standing Data | Accounts | VAT Codes menu in Match-IT and make sure that you have set up all the VAT codes that Enterprise uses; usually S,E,Z,1,2.  To see the VAT codes in Enterprise, use the Utilities | VAT Setup menu.  When creating the VAT codes in  Match-IT make sure that the code field is one of these single character codes.

Area codes

You only need to do this if you use the Area field in Enterprise.  Use the Match-IT All Code Classes menu as above to locate and edit the CusSupArea code class set.  Make sure that all area code short names are at most four characters long; as this is the limit for the corresponding Enterprise field.

Currencies

Use the Functions | Standing Data | Units | Units of Measure menu in Match-IT and click the Currency tab.  Make sure that you have set up a currency for each currency that you actually use in Enterprise. Enterprise currencies are available from the Utilities | Currency Setup menu.  For currency import/export to work correctly the UnitID (short name) of each of your Match-IT currencies should start with the corresponding currency number in Enterprise followed by a comma; e.g. 1,Sterling.  Note that you do not need to create extra currencies for this purpose if one already exists.  For example if you already have a Sterling currency in Match-IT, just edit it to include a 1, prefix to the short name.

Match-IT defaults

The table below shows a list of defaults and their values that need to be setup in Match-IT.  You can access Match-IT defaults by pressing F4 at any time. Click the Show all Classes check box at the bottom of the list to get a complete list.  When you edit each default you must set the System Value to the value shown in the table.

Class

Default name

Value

Notes

CS

Accounts Export Sales Inv. Lines

No


CS

Accounts Export Purch. Inv. Lines

No


CS

PO Department

-

Make sure this value is a valid Enterprise department.

CS

SO Department

-

Make sure this value is a valid Enterprise department.

CS

PO Cost Centre

-

Make sure this value is a valid Enterprise cost centre.

CS

SO Cost Centre

-

Make sure this value is a valid Enterprise cost centre.

Match-IT accounts centre

In Match-IT use the Functions | Standing Data | Accounts | Accounts Centres menu and enter the Detail of the Main account centre.  Select the Exchequer interface.  On the Run tab, in the Run this field you should point at the Enterprise CSV import program; this document assumes this field is set up correctly.  The path relative to the Enterprise installation folder is usually import\csvexch.exe.  The Working In field would then be the import folder itself.  For example:-

Run this:        c:\excheqr\entrprse\import\csvexch.exe
Working In:        c:\excheqr\entrprse\import

When you click on Run this, Match-IT starts the Enterprise CSV import program.  You use this program to import data into Enterprise.

Match-IT ledger interface

In Match-IT use the Functions | Standing Data | Accounts | Ledger Interface menu and enter the Detail of the Main account centre.  This window defines the files that Match-IT and Enterprise will write when exporting their data.  We recommend these file names:-

CSV Import Files (files that Enterprise creates)

Cus Balances:        c:\csv\sl_agedm.csv
Sup Balances:        c:\csv\pl_agesm.csv
New Cus:                c:\csv\sales.csv
New Sup:                c:\csv\purchase.csv

CSV Export Files (files that Match‑IT creates)

Cus Trans:        c:\excheqr\entrprse\import\csv\sl_trans.csv
Sup Trans:        c:\excheqr\entrprse\import\csv\pl_trans.csv
New Cus:        c:\excheqr\entrprse\import\csv\sales.csv
New Sup:        c:\excheqr\entrprse\import\csv\purchase.csv

If you do not use these file names you will need to edit the Enterprise import templates (.sav files) to point at different files.  The reason for saving the files exported from Enterprise in a folder on the root drive is that Enterprise has a limit of 30 chars for exported file names, including the drive and folder etc.  You will have to create a csv folder in your root drive before exporting any files from Enterprise.  Make sure that everybody who will be exporting data from Enterprise can see and has write access to this folder.

Note that the Match-IT ledger files window may have slightly different field names than those shown above.  When referring to various import and export files in the sections below,  the document is referring to the appropriate filenames that you have defined in the ledger interface.

Enterprise settings

From the Enterprise Utilities | System Setup | General Settings menu, select the SL/PL tab and set the desired number of decimal places to represent quantities and unit prices; you may have already done this.  These settings are used when importing to calculate line net values from unit values.  Select the System/GL/Currency tab and tick Use Cost Centres and Departments if appropriate.

Enterprise import templates

As a pre-emptive task, create these folders if they do not already exist:-

c:\excheqr\entrprse/import/sav
c:\excheqr\entrprse/import/imp
c:\excheqr\entrprse/import/csv
c:\excheqr\entrprse/import/logs

Enterprise converts the CSV files produced by Match-IT (see above) into .imp files via a template file (.sav) and then imports the .imp files.  The conversion is controlled by the template files.  We supply the templates with a standard Match-IT installation, but they need to be copied to your Enterprise installation.  To do this copy all the .sav files in the Match-IT configs folder to the Enterprise import/sav folder.  Please note that you may need to create the sav folder by hand; it may or may not exist.  There will four of them: sl_trans.sav, pl_trans.sav, sales.sav and purchase.sav; corresponding to the four types of file that Match-IT can export.  After importing, Enterprise renames the .imp files to .ren and leaves a log file in the import/logs folder.  If you are happy using a DOS command line window you can copy the templates like this (but make sure the sav folder does exist first):-

copy c:\match-it\configs\*.sav c:\excheqr\entrprse\import\sav

Enterprise CSV import program settings

Start the Enterprise CSV import program as follows: in Match-IT, use the Functions | Standing Data | Accounts | Accounts Centres menu to get a list of your accounts centres, enter the Detail of the Main account centre and press the Run now button.  This is just one way to start the CSV import program; it may already be running or you can start it from your Windows desktop.  The Enterprise CSV import program is called csvexch.exe and is located in the import folder of your Enterprise installation; for example: c:\excheqr\entrprse\import\csvexch.exe.

From the Enterprise CSV import program, select the Utilities | System Setup menu and make sure the following options are set:-

Switches tab:  Tick these check boxes:-

Calculate Header Totals
Calculate Total Number of Lines
Calculate Line VAT
Link to the Import Module – Automatic

Untick the rest.

Default tab: Set the three fields to these (or change as per your installation folder) paths:-

c:\excheqr\entrprse\import\csv
c:\excheqr\entrprse\import\imp
c:\excheqr\entrprse\import\sav

Make sure that the csv, imp and sav folders exist in the import folder.  If they do not, create them.  Set the date format to: yyyymmdd.

Timer Settings tab: You can choose to archive the CSV files that you import; this is your choice; the setting does not affect the interface in any way.

Enterprise native import program settings

The Enterprise native import program is called exwimp.exe and is located in the import folder of your Enterprise installation; for example:

c:\excheqr\entrprse\import\exwimp.exe

Execute this program, select the Tools | System Setup menu and make sure the following options are set:-

Enterprise - Switches tab:  Tick all check boxes in the left hand column except for Use Ex. Trans No; this is critical for the import to operate correctly. Untick all check boxes in the right-hand column except for Update Account Balance.

Enterprise -  Set Up tab: Set the three folders to be:-

C:\EXCHEQR\ENTRPRSE\
C:\EXCHEQR\ENTRPRSE\IMPORT\IMP\
C:\EXCHEQR\ENTRPRSE\IMPORT\LOGS\

Please notice the trailing \, the import will not work without them.  You may need to use different folders depending on your installation folder.  Leave everything else set as it is or change to suit your preferences.

Import – Set Up tab: Leave the default settings.

Close the program.

Enterprise report templates

Before you export any information from Enterprise you must install the export templates supplied by Match-IT.  To do this, start the Enterprise report writer and then locate the Utilities | Import Reports menu.  Use this menu to import the match-it.rpt file resident in the Match-IT configs folder.  After closing then reopening the report tree, you will see a new folder appear in the Enterprise report writer tree with four reports in it.

How do I import my customer list?

Run the Report Writer from the Reports menu and show the list of reports from the Records | Report Tree menu.  Open the Match-IT reports branch until you can see the report called Export customers to Match-IT.  Click on this line and use the Print button to sart the export.  When prompted  instruct the Enterprise report writer to write to the file identified above in the Match-IT ledger interface for new customers; e.g. c:\csv\sales.csv.  When you press the Save button of the file selector, Enterprise will run the report and create the file.  It will then display a print preview which does not show any lines.  Exit the print preview to return to the report writer.

How do I import my supplier list?

As above.  Work by example using the above instructions but export suppliers from Enterprise. The Enterprise report is called Export suppliers to Match-IT.

How do I import my customer credit balances?

As above.  Work by example using the above instructions but export customer balances from Enterprise. The Enterprise report is called Export customer balances to Match-IT.

How do I import my supplier credit balances?

As above.  Work by example using the above instructions but export customer balances from Enterprise. The Enterprise report is called Export supplier balances to Match-IT.

How do I export new customer accounts?

Start the Enterprise CSV import program as described in the Enterprise CSV import program settings section above.  Use the Process | Customers menu to open the import window and open the sales.sav template.  Leave the .imp filename that Enterprise displays as it is; you should find it adds a prefix of ex to the filename; it will do this for all import operations and does not need editing.  Press Run Conversion to perform the import.  If errors occur they will be left in a file in the import/logs folder.  The most common errors will be trying to import codes that do not exist in Enterprise; e.g. currency, vat rate, cost centre, area and department code.

How do I export new supplier accounts?

As above.  Work by example using the above instructions but use the Process | Suppliers menu and purchase.sav template in Enterprise.  Opening balances work the same way.

How do I export new sales invoices?

As above.  Work by example using the above instructions but use the Process | Transactions THs and TLs in one file menu and the sl_trans.sav template in Enterprise.

How do I export new purchase invoices?

As above.  Work by example using the above instructions but use the Process | Transactions THs and TLs in one file menu and the pl_trans.sav template in Enterprise.

Notes

1.The CSV import part of Enterprise can be configured to calculate line VAT or import the line VAT as it is defined in the CSV file.  However, if you ever edit an imported invoice and Enterprise thinks the VAT is incorrect, it changes it under your feet.  For this reason we have the line VAT calculation turned on.