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

    • Can Journal Ledger Be Imported to General Ledger?

      Q - Can the General Journal ledger be imported from a spreadsheet into the General Ledger as opposed to manually entering it? A - Yes. You can go to General Ledger -> Processing -> Interface from Other Package -> CSV Import. See sample screen below. ...

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

    • AP0202 Accounts Payable Transaction Processing

      Processing A/P Transaction Processing Advanced Features The A/P Modules includes many features and functions, not applicable to all business, which we let you Pick & Choose to enhance your functionality and processing needs. These are detailed in the ...

    • Credit Card Transaction Time Out

      Q - When I process a credit card transaction in Elliott, I receive a message window with the title "Finished Transaction Status" and the detail message like followings: E:System.Net.WebException: The underlying connection was closed: A connection ...