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

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

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

    • Do I Need to Kick My Users Out When Interfacing with Other Packages in GL?

      Q - When interfacing the sub-ledgers (i.e., AR, AP, IM) to the General Ledger, must all other users exit Elliott? Or if we are interfacing only AP, can users just stay out of AP, for instance? A - The key is that no one should perform any "POSTING" ...

    • ARMENU Accounts Receivable Package Overview

      Package Overview How to Use This Manual When most people receive a new product they want to use it right away. Unfortunately, this is not quite possible when dealing with computer hardware and software. This manual is intended to serve as a reference ...

    • BM1800 Bill of Material Production Transaction Processing

      BM1800 Bill of Material Production Transaction Processing ← Bill of Material / Work Order Plus Production Transaction Processing Application Overview The Production Transaction Processing application allows for reporting progress made toward ...