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

    • Btrieve Error Codes 001 - 199

      MicroKernel (Btrieve) Database Engine Status Codes This section describes status codes that the MicroKernel returns. All status codes are provided in 3-digit formats since the search on this website cannot search 1 or 2-digit words correctly. That is ...

    • Btrieve Error Codes 3000 - 3099

      MicroKernel Router Status Codes This section lists the status codes you can receive from the MicroKernel router, which receives requests from the Btrieve requesters and routes them to the correct version of the MicroKernel. 3000: The MicroKernel ...

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

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

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