iMIS Power Suite - GL Processor

Exports

The iMIS GL Processor Cloud allows users to transfer financial transactions from iMIS to an external accounting system. Using customizable templates, you can export data in various file formats, set summarization levels, and choose whether to include Due To/Due From transactions. The GL Processor Cloud also maintains its own export tracking, ensuring flexibility between iMIS processing and an organization’s accounting needs. When you specify a date range and organization, the system verifies that all runs for that period have been completed in iMIS before determining which runs to include in the export.

Creating an export

First step is to create an export. You must designate a Preferred Organization before you can create the export.

Do the following to create an export:

  1. Go to the GL Processor Dashboard and select Exports > New.
  2. Choose the intended Organization from the drop-down list.
  3. Enter date range - Begin date.
  4. Enter date range - End date.
  5. Click Create Export File.

The export process produces a detailed log while the file is being generated.

Once the export process has completed, the generated file can be downloaded by clicking Download GL Export File.

Exporting logs

After the export finishes, you can view the record of the exports.

To view exported logs, select the Exports > Logs menu option from the top navigation bar.

The export logs can be filtered by Organization using the drop-down at the top of the table. The export log table consists of the following columns:

  • Run - iMIS GL Processor run number (different than the iMIS run number).
  • Begin Date - Begin date of the export.
  • End Date - End date of the export.
  • Organization - Organization of the export.
  • Financial Entity - Financial Entities associated with the organization.
  • Created On - The date the export was created on.
  • Download - Provides a button to download the export file.

Note: The download button will produce a new export file, incorporating the latest changes to the template. The resulting data remains the same, but the format will be based on the most recent version of the template. If the organization’s template is configured to separate files by financial entity, the files will be downloaded in a .zip file.

Logs can be in different statuses, indicated by the color of the log and button.

  • Green - Process is complete and ready to be exported. The button will generate and download the export file.
  • White - Export has been generated and can be downloaded. The button will generate and download the export file.
    • No Result - The export process resulted in no results.
  • Orange - An issue occurred while generating the export. The button will retry processing the export.

Errors

If an error occurs while processing an export, additional exports will be halted until the bad export is addressed. For example, if the last export was not successful, attempting to create a new export will result in the following warnings: