gl_posting.jar

The gl_posting.jar utility reads the General Ledger (GL) summary records in the MonogDB system for a given GL date range, and writes GL journal entries to XML files.

Syntax

java -jar gl_posting.jar startDate(yyyy-mm-dd) endDate(yyyy-mm-dd) outputFolder outputFilePrefix gl_posting.yaml [tenantId]
java -jar gl_posting.jar -noaggr startDate(yyyy-mm-dd) endDate(yyyy-mm-dd) outputFolder outputFilePrefix gl_posting.yaml [tenantId]
java -jar gl_posting.jar -p password gl_posting.yaml [tenantId]

Options

The gl_posting.jar utility has the following options.

-noaggr
Runs this utility in non-aggregate mode. Prints the GL journal entries in the requested date range without summing the journal amounts. Used with the exportFields property in the GL posting properties file, which specifies the list of fields to export.
-p password gl_posting.properties
Encrypts and saves the specified password in the specified properties file.
startDate(yyyy-mm-dd)
The start date of the GL date range within which the utility aggregates all journal entries from the GL daily summary records stored in your MongoDB system.
endDate(yyyy-mm-dd)
The end date of the GL date range within which the utility aggregates all journal entries from the GL summary records stored in your MongoDB system.
outputFolder
The folder to save the output files.
outputFilePrefix
The prefix of the output file name.
gl_posting.yaml
The YAML configuration file the utility reads when run. You can use any name for this configuration file.
tenantId
The string ID of the tenant GL database from which to generate reports.

Example

Aggregate journal entries of the GL daily summary records for the GL dates 2016-02-01, 2016-02-02, 2016-02-03, 2016-02-04, and 2016-02-05 and export the data to the specified output files.

java -jar /opt/mtx/bin/gl_posting.jar 2016-02-01 2016-02-05 posting 2016Feb0105 /opt/mtx/data/gl_posting.yaml tenantId

For sample output and output descriptions, see the discussion about processing and posting GL information.

Note: To enable tracing in the gl_posting.jar utility, add the following property to the log4j properties file (the log4j properties file you specify in the command when you execute the utility):

<Logger name='com.matrixx.glposting'level='trace'>

For more information about GL support for multi-tenancy, see the discussion about General Ledger for Multi-Tenancy.