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

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 Journal Transaction Processing -> Change.  I got the message "No Session ID found." See sample screen below:



Then I went to Accounts Payable -> Reports -> AP Distribution to GL Reports and printed the date range of the distribution of the interface.  They were all marked as "interfaced."  So why am I not seeing them in the General Journal Transaction?

A - The process of the interface is that it will write to the General Journal Transaction File (GLGENTRX) as each distribution record is marked as being interfaced.  At the end of the successful interface, it will write to the G/L Session ID File (GLIDFIL).  Because the interface was interrupted by error 3112 (Failure Receive from Target Server), which is a network-related error, it was not able to write the corresponding records in GLIDFIL.

When this happens, and you go to General Journal Trx Processing and choose the change mode, there can be three possibilities:
  1. The system detects there is no session ID in GLIDFIL and performs a rebuild.  In a case like this, everything will work correctly.
  2. The system detects that a recurring Journal session ID exists in GLIDFIL, so it does not perform the rebuild. But since there's no general journal session ID, the system gives you the "No Session IDs Found" message.
  3. The system detects that another General Journal Trx session ID exists and displays in the Session ID Search window.  But the one you expected to see, in this case, "APINTRFACE," does not show up.

    In this case, you lost the session ID record, but you did not lose records in the GLGENTRX (General Journal Transaction) table.  The solution to this problem is that you should use the following procedure to force the GL Session ID (GLIDFIL) table to be rebuilt:

  1. Rename Session File from data folder -- For example, our Elliott data is stored in the M:\ELLIOTT7\DATA folder. You should rename the session file from "GLIDFIL.BTR" to "GLIDFIL.OLD." Make sure no one is working in the GL module while you are renaming the session file.
  2. Go back to GL -> Processing -> General Journal Transaction Processing -> Change mode. The system will notice that the GLIDFIL table is missing. The system will automatically re-create the table and  rebuild it based on the details in the General Journal Trx table. 
  3. Now go to General Journal Transaction Processing again. You will see the Session ID show up.
EMK





    • Related Articles

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

    • Job Code Adjustment through GL Journal Entries

      Release Date: 11/28/2017 Q - Is there a way to make an adjustment to amounts posted to a job code? Including amounts posted through the payroll system? A - Are you talking about a GL Adjustment Journal Entry? You have the option to turn on Job Code ...

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

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

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