Export G/L Transactions

Back Office Menu -> Daily Close Menu -> Daily Close 3 -> Export G/L Transactions

Reports Menu -> Automatic Reporting -> Function XMLEXP3 -> runs Export G/L Transactions

This utility can be used to re-create the XML export G/L transaction files, if the parser has failed or the XML files were deleted.
This utility can also be used to directly generate a new XML export data file for a range of Posting Reference numbers, as assigned to the G/L posting batches.
A record is written for G/L Transaction exports to the View Application Log.

Refer to Company Daily Close Parameters for the directory and parser setup used by the XML Export process with the option to email the resulting XML files to the operator currently signed in.
The feature to automatically capture and export G/L data by XML transactions in Daily Close 3, can also be activated in the Company Daily Close Parameters.

The prompts in this Export G/L transaction utility are:

XML TRANSACTION#

Recreate XML Export file:
To reproduce an XML file from an existing export file, select the XML transaction from the Select XML Transaction# window.
If an XML transaction number is selected the other filters for this utility do not apply, and only the Print Summary Totals Report option is enabled.

Export New XML file:
Leave the XML Transaction# field blank, to export a new XML data file for a batch of G/L transactions by Posting Reference number, using the selection filters provided in this utility.

LAST POSTING REFERENCE

This is an information field only, and provides the current Posting Reference number.

FROM POSTING REFERENCE

Enter a starting posting reference number for the range of G/L transactions to be included in the export file. This is a mandatory field.

TO POSTING REFERENCE

Accept the default of the From Posting Reference or enter an ending posting reference number for a larger range.

ONLY TRANSACTIONS NOT EXPORTED

Uncheck this box to include ALL transactions in the Posting Reference range and export the data to an XML file type GLGL.

Note: Because this export file may include Posting Reference batches that have already been exported and have already been assigned an XML transaction number, no change is made to the contents of an existing XML transaction when this new composite XML file is created.
Instead this new XML file will use the naming convention TRS_GLGL_yyyymmdd_hhmmss.xml where TRS represents the 3 digit company code, GLGL (General Ledger) is the data type, yyyymmdd is the date, and hhmmss is the time of creation.

Check this box to select only G/L Posting Reference batches that are NOT already included in a saved XML transaction record.
The option is provided to stamp the G/L transactions in this file with an XML transaction#.

ASSIGN XML TRANSACTION#

This field is only enabled if Only Transactions Not Exported has been selected.

Check this box to create an XML transaction for future use, stamping the Posting Reference transactions as included in this trx file.
The XML file naming convention for G/L transactions is TRS_GLGL_00000000000000004912.xml where TRS represents the 3 digit company code, GLGL (General Ledger) is the data type, and 00000000000000004912 is the sequential XML transaction number.

Uncheck this box to generate a one time XML export file identified by date/time in its name, but leaving the Posting Reference transactions unlinked to any XML trx.

PRINT SUMMARY TOTALS REPORT

Check this box to generate a summary of the total Debits and Credits by G/L Posting Reference number.
Uncheck this box to suppress the Debit/Credit summary.

Finished?

Click ACCEPT to proceed or CANCEL to abort the export.

Automated Reporting Option:
The G/L export file can be generated automatically by setting up using XLMEXP3 to be run from Automatic Reporting.
This option exports any G/L transactions that have not yet been exported to an XML file and date-stamps them and the Debit/Credit Summary is emailed to the address setup in Automatic Reporting.
The operator code assigned to export files generated by the auto-reporting is recorded as _Cr.