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.
This manual export utility only exports transactions associated with the xml transaction# and does not utilize the "Number of Transactions" minimum set in the Company Daily Close Parameters configuration.

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.

RESERVED DC POSTING REFERENCES

When the action to "Export G/L Transactions in Daily Close 3" is activated in the Company Daily Close Parameters and G/L postings are generated, many of the Posting References are flagged as "Reserved" to be exported the next time Daily Close 3 is run.
Reserved Posting References are not included in an export generated manually or from Automatic Reporting for XMLEXP3.
The Reserved Daily Close Posting References window is provided to view any reserved Posting References pending export in Daily Close 3.

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 XMLEXP3 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.