GL Reversing Entry File Maintenance (GLFM007)

Program Description

There is a new program in Revision 14 that can be found on the General Ledger File Maintenance menu (GL-3-7).   With this enhancement, you can set up GL Entries that will be performed automatically when this program is ran.  This is useful when used in conjunction with GL Repeating Entry File Maintenance.  The GL Repeating Entries program can be used to create transactions that occur every month with the same dollar amount (i.e. rent).  If the transaction needs to be done for AP/GL end of month, and then reversed back out, the reverse transaction can be created to accomplish this.  See documentation below for more details. The file maintenance program where the reversing transactions are set up is located in the GL Reversing Entry File Maintenance program (GL-3-7).  The GL Reversing File is GLREV.DT.  The same debit and credit accounts can be in the file more than once if you need to have different dollar amounts and/or descriptions.

 

Example:

 

 

Fields:

 

Debit Account

This is the account that will be debited by the transaction.  This could be an account number with a debit type or a credit type.  It must however be a valid account number.

 

Credit Account

This is the account number that will be credited by the transaction.  This could be an account number with a debit type or a credit type.  It must however, be a valid account number.

 

Amount

This is the dollar amount that will be posted in the transaction.  It could be a positive number or a negative number

 

Description

This is the description that will be used when writing into the General Ledger File (GLDISTD).

 

Last Fiscal Month Updated (0-12)

Whenever the GL Reversing Entries creates a transaction, the last fiscal month updated in the GL Reversing File will be updated.  This will prevent the same transaction from being done twice in one month.  If the transaction should be done the next time the GL Reversing Entries program is run, place 0 in this field.  If this transaction should be done only after a certain fiscal month (within the current fiscal year), then place that fiscal month minus 1 in the field.  For example: If your fiscal year starts in January, and you would like a transaction to start in May, place 4 (5 minus 1) in this field.

 

General Ledger

Master Menu