General Journal Transaction Out Of Balance After Interface with AR

General Journal Transaction Out Of Balance After Interface with AR

Customer question: While I was interfacing with AR, someone posted a cash receipt payment. Now my interface is out of balance. Can I just delete the transactions and then re-interface?
Answer: If you interface once a month, yes, you may delete the General Journal Transaction then Re-Interface (field # 6 = Y).

If not, here are some other steps to resolve the issue:

  1. Print GJ Transaction Edit List and get out of balance on the last page (i.e., $100.00DR)
  2. Print AR Distribution to GL Report (field # 10. Interface to GL Status? = “N”) and get out of balance on the last page (i.e., $100.00CR) If (1) + (2) = 0 then we know the out-of-balance portion still stay in the AR Distribution file.
  3. Ideally, you should perform the following interface and posting steps:
    1. Turn on “Allow out of balance posting” flag on GL setup (field # 1 = Y).
    2. Post AR Interface (Allow out of Balance Post = Y).
    3. Interface with AR the same as you've normally done before. The system will interface the rest of the un-interfaced portion to GL from AR. Of course, it is out of balance. Go ahead and post (with out of balance = Y).
    4. After posting, run Trial Balance to see if it is in balance.


    • Related Articles

    • GNJINLENT General Ledger General Journal Trx Processing

      Processing General Journal Trx Processing Application Overview The General Journal Transaction Processing application allows for Journal Transaction entries and changes before posting to the General Ledger. Transactions may be keyed directly into the ...

    • General Journal Transaction In Balance But Not Able to Post

      Q - My General Journal Transaction screen, Session ID, shows that the total debit and credit amounts are in balance. See sample screen below. But when I print the General Journal Edit List, it shows that they are out of balance. In addition, I can't ...

    • Error During GL Interface from Other Package and Journal Transaction Is Lost

      Q - In General Ledger, during the interface from other package process, I got a Btrieve Error 3112 on AP Distribution File (APDISFIL). The interface stopped and my Elliott session was terminated. I went to General Ledger -> Processing -> General ...

    • GLRECENT General Ledger Recurring Journal Trx Processing

      Recurring Journal Trx Processing Application Overview The Recurring Journal Transaction Processing application allows standard recurring journal transactions to be entered. They may also be changed before being posted to the General Ledger through ...

    • GLJNLLST General Ledger Journal History Report

      Journal History Report Application Overview The Journal History Report produces a listing of all journal totals. To maintain journal history totals, the field in G/L Setup must be set to "Y". Each posting procedure that is performed for any package ...