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 ...

    • My General Ledger Interface with Other Package Is Out of Balance

      Q - When I go to GL -> Processing -> Interface from Other Package, I choose to interface with the IM module. After the interface, my GL Journal transaction shows it is out of balance. How can this happen? What should I do? A - Generally speaking, the ...

    • INTERFAC General Ledger Interface From Other Packages

      Interface From Other Packages Application Overview Interface From Other Packages allows the distribution files of Accounts Receivable, Accounts Payable, Payroll, Job Costing, Inventory Management, and Assets and Depreciation to be transferred into ...