General Ledger: How to use the General Ledger Transactional Export utility

A. How to run the Transactional Export Utility

1. The Transactional Export utility is used to export your general ledger transactions to MS Excel as per export filters.

2. As shown below, you can filter the report export results on a range of GL accounts as well as specific periods to be      exported.

3. You can also choose to export either the GL account code, GL account description or both.

4. Before exporting, select the export location by clicking the browse button on the ‘Specify a file path’ option.

5. After specifying the export criteria, click the Export button.

6. The export file is created in MS Excel, and the exported data can be further analysed with the various MS Excel     tools/ features.

7. Also notice that the export file includes each transaction’s Audit Trial Number.

B. Why use the Transactional Export Utility

This utility is useful if you observe the following type of errors when running the reports mentioned below:

 a) General Ledger Audit Trial report

b) General Ledger Account Transactions report

C. Further information on the above errors

The main reasons for the above errors may be due to:

a) A significant number of general ledger accounts in a company database, and/or number of posted transactions, for instance transactions in the POSTGL MS SQL table

and/or

b) The Evolution server and/or workstation/s not adhering to the minimum Sage recommended specifications.

 Further information can be obtained by accessing the link shown below:

'Error creating stored procedure! Object was open’