The main reason that a System
Journal would be out of balance is when the Journal is printed while
transactions are taking place. The journals must be printed when there
is no activity on the system. Another reason that a journal would go out
of balance is that an error occurred during an update (ex: Invoice
Update) and the process did not continue.
How to find the Journal that is out of balance.
- Run the Journal Activity Report (GLM, option 2) for the period
that is out of balance. Each Journal's transactions are printed on the
activity report sorted by G/L Account Number. There is a total for all
the Debits and Credits posted for the Journal. To locate the Journal
that is out of balance find the Journal where the Debits and Credits are
not equal.
- Run the Jrnl Act. Check for Daily Totals Report for the Journal that
is out of balance to find the date that is out of balance.
The date with the problem is the date that does not add up to
zero. The
correction to make is actually the opposite of what is reported.
If the
total is a credit amount then the correction is a debit and so forth.
If this report is not available on your system then add all the credits
and debits for each day to find the day that is out of balance.
- Go to the Original Journal (Invoice Journal, Cash Receipts Journal,
etc.) for that date to get the correct totals. Try to match the numbers
from the Original Journal (ex: Invoice Journal) with the numbers that
posted for the Journal.
- Check the transactions on the Journal Activity Report for that Journal Date to get the transaction(s) that posted incorrectly.
How to correct the transaction that posted out of balance.
- Type in ID from any menu. This will bring you to the Development Menu (IDMENU1). Select option V for view.
- Enter view name GLCGLTR (G/L Transaction File). The records will be displayed horizontally on the screen.
- Press F10 (the goto key) and type in the Company Code, Period
Number and Journal Number (ex: A10410001) of the transaction that is
incorrect then, press return. This will allow you to jump to the section instead of having to page down or arrow down to the section.
- Use the key to tab over to the GL-ACCT-AMT field (the field
names are displayed in the top left hand corner). Make sure you are on
the correct transaction. Type in the correct amount. If the amount is a
negative number then type in the minus sign first.
- Repeat the process for any other transactions that posted incorrectly.
- Reprint the Journal Activity Report to make sure the Journal is now in balance.