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


General Ledger

  1. GLMENU General Ledger Package Overview
  2. My General Ledger Interface with Other Package Is Out of Balance
  3. Can Journal Ledger Be Imported to General Ledger?
  4. Is There a Way to Pull All Manual GL Entries Out of Elliott?
  5. How to Print a Wider Financial Statement
  6. General Journal Transaction Out Of Balance After Interface with AR
  7. How to Archive GL Data Before Year-End Closing Procedure
  8. GL Year-End Closing Checklist
  9. Do I Need to Kick My Users Out When Interfacing with Other Packages in GL?
  10. General Journal Transaction In Balance But Not Able to Post
  11. Net Income from Profit & Loss Statement Does Not Match Balance Sheet
  12. Feature - G/L Interface from Other Package Customer/Vendor/Employee Number/Name Default
  13. Error During GL Interface from Other Package and Journal Transaction Is Lost
  14. COMPRESS General Ledger Processing Compress General Ledger TRX File
  15. GLBUDMNT General Ledger Budget File Maintenance
  16. GLCMPMNT General Ledger Comparative File Maintenance
  17. GLCONSOL General Ledger Company Consolidation
  18. GLCTLMNT General Ledger G/L Setup
  19. GLDSTMNT General Ledger Distribution Code File Maintenance
  20. GLENTMNT General Ledger Financial Entity File Maintenance
  21. GLJNLLST General Ledger Journal History Report
  22. GLPRDMNT General Ledger Accounting Period File Maintenance
  23. GLPRDSCN General Ledger Period Account Balance Report
  24. GLRATSCN General Ledger Financial Ratio Report
  25. GLRECALC General Ledger Recalculate Account Balances
  26. GLRECENT General Ledger Recurring Journal Trx Processing
  27. GLSRCMNT General Ledger Source File Maintenance
  28. GLTRIALB General Ledger Trial Balance Report
  29. GLWRKSHT General Ledger Print General Ledger Worksheet
  30. INTERFAC General Ledger Interface From Other Packages
  31. TEXTMNT General Ledger Statement Text File Maintenance
  32. SRCEXREF General Ledger Source Cross Reference Report
  33. YEAREND General Ledger Year-End Procedure
  34. GLACTMNU General Ledger G/L Account File
  35. GNJINLENT General Ledger General Journal Trx Processing
  36. My Net Income (BSNI) at Balance Sheet Does Not Equal My Net Income on the P&L Statement
  37. Budget File Maintenance Questions & Answers
  38. LAYMNU General Ledger Statement Layout File Maintenance 1
  39. LAYMNU General Ledger Statement Layout File Maintenance 2
  40. LAYMNU General Ledger Statement Layout File Maintenance 3
  41. LAYMNU General Ledger Statement Layout File Maintenance 4
  42. LAYMNU General Ledger Statement Layout File Maintenance 5
  43. LAYMNU General Ledger Statement Layout File Maintenance 6
  44. LAYMNU General Ledger Statement Layout File Maintenance 7
  45. LAYMNU General Ledger Statement Layout File Maintenance: Index
  46. STMNTMNU Select and Print Financial Statements 1
  47. STMNTMNU Select and Print Financial Statements 2
  48. STMNTMNU Select and Print Financial Statements 3
  49. STMNTMNU Select and Print Financial Statements 4
  50. STMNTMNU Select and Print Financial Statements: Index
  51. Job Code Adjustment through GL Journal Entries

Feedback and Knowledge Base