How do I fix G/L when it is Out Of Balance

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.

  1. 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.
  2. 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.
  3. 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.
  4. Check the transactions on the Journal Activity Report for that Journal Date to get the transaction(s) that posted incorrectly.
  5. How to correct the transaction that posted out of balance.

  6. Type in ID from any menu. This will bring you to the Development Menu (IDMENU1). Select option V for view.
  7. Enter view name GLCGLTR (G/L Transaction File). The records will be displayed horizontally on the screen.
  8. 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.
  9. 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.
  10. Repeat the process for any other transactions that posted incorrectly.
  11. Reprint the Journal Activity Report to make sure the Journal is now in balance.

About Us | System Software | Software Demo | Request info
Support FAQ'sHighlights | Home | Enhancements  
PO Box 262, Centereach, NY 11727
(631) 580-1115 or Fax (631) 580-7722