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.