Sage Sterling

iMIS provided support to meet export requirements for Sage Sterling. This support was in place in iMIS LAN version 3.50b and in iMIS 4.10.

Minimal setup is required on the iMIS side to facilitate the interface. No setup steps are required with Sterling.

Within Sterling, there is a department designated by an integer no longer than 3 digits and a Nominal Account Reference, which is represented by a character string, no longer than 8 characters. You must construct the iMIS GL account by the department code, followed by a hyphen (-), followed by the account.

Note: 1-4000 in iMIS translates to Nominal Account Reference “4000” belonging to Department “1” in Sterling.

To set up iMIS for Sage Sterling

  1. From AR/Cash, select Set up module, and click G/L Interface to open the AR/Cash General Ledger Interface window.
  2. Click Edit.
  3. From the GL interface type drop-down list, select Sage Sterling.

    4. Note: In LAN, select Sterling.

  4. Select an option from the Summarize by drop-down list.
  5. Enter the Output File Path/Name, which dictates how iMIS should name the export/import file and where it should be stored.
  6. Click Save.

To create the export file from iMIS (Sage Sterling)

  1. Generate the general ledger transaction export files using AR/Cash > Process month-end procedures > Create GL Journal.

To import data into Sage Sterling

  1. Launch the application and select Data > Import.
  2. Click the Transactions radio button and click Run.

  3. From the selection window that appears, locate and double-click the export/import file.

  4. If Sterling detects a problem with the import file, it will post an error message detailing the problem line by line and will reject the import.

Note: One common problem is that the Nominal Account number in Sterling does not match a GL number in iMIS.

Import Header File Sample

GJASI4000Test GL Import01/31/201104/30/201100000DistIM00010''

Import Data Sample

ASI40001Dist11000-000-0000DIST-AR-PAYIM0001IM00011''100.00100.00100.001.01.0
ASI40001Dist11010-000-0000DIST-AR-PAYIM0001IM00011''-100.00-100.00-100.001.01.0