Error 037 on GLFSPASS GL Fin Stmnt Pass File
Release Date: 09/17/2020
Version: 7.x & Up
Q - Our company implemented NTFS security with our Elliott folder. Our financial manager is not a Windows system admin so she has minimum rights to the DATA folder. We did the procedure in the following article to grant everyone in the group the modify right to all *.DAT files:
She was able to run a financial statement yesterday. Now, after another user (a Windows system admin) ran the financial statement, our financial manager receives the following error:
Error 037 on GLFSPASS GL Fin Stmnt Pass File
What happened?
A - GLFSPASS is the General Ledger Financial Statement Passing File and is used when printing financial statements. It is a DAT instead of a BTR file. DAT file security is directly handled by the OS, and your financial manager by default has minimum rights to that file. As stated in the above KB article, when you first implemented NTFS security, you used the NTFSSEC.bat DATA at the command prompt to grant all users in the Everyone group the right to modify all DAT files. That allows your financial manager to run financial statements. Each time a user runs financial statements, the GLFSPASS.DAT file is re-created (i.e., the old file is deleted and a new file is created.) As a result, the Everyone user group rights go back to minimum as in the DATA folder. But since this file was created by your financial manager, she is the new owner of this file. The next time she runs the financial statement again, she has sufficient rights to override because she is the owner.
This will be fine until the Windows admin user (e.g., the boss) runs the financial statement. Since it is the Windows admin, he/she can override the GLFSPASS.DAT file. However, when your financial manager wants to run the financial statement again, she is no longer the owner of this GLFSPASS.DAT file. Thus, she receives the "Error 037 File access denied" message.
You can solve this problem in the following ways:
- Use NTFSSEC.bat DATA again as documented in the KB article above. You can also do this manually by using Windows Explorer and browsing to the <ElliottRoot>\DATA folder, then right clicking on GLFSPASS.DAT and granting the "Modify" right to the "Everyone" user group.
- Avoid letting the Windows admin run the financial statement and delegate this task to your financial manager only.
- Grant your financial manager full rights to the DATA folder.
- In Elliott 8.6, you can optionally convert GLFSPASS.DAT to a BTR file, and this issue will be resolved.
The permanent solution is resolved in Elliott 8.5 & up release after 05/05/2021. Please see the following KB article:
EMK
Related Articles
Change - Move GLFSPASS.DAT (GL Financial Passing) File to LOG Folder
Release Date: 05/05/2021 Version: 8.5 The General Ledger Financial Passing File (GLFSPASS.DAT) resides in the Elliott DATA folder and is an ASCII file, and therefore is subject to NTFS security issues. During the setup of NTFS security, all *.DAT ...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 ...GL Year-End Closing Checklist
Q. GL year-end closing is a major event for our accounting department every year, but it's easy to forget the steps involved since we only do it once a year. Do you have a checklist for year-end closing that we can follow? A. Yes. The GL year-end ...Using Raw Data Pass Through for Dot Matrix Printer on Windows 10 Does Not Work
'Q: How can I use raw data pass through with dot matrix printer on a Window 10 computer? In Elliott we can print to a dot matrix printer by using the raw data pass through method -- that is to say using a printer font other than 00. This works with ...How to Purge AP Distribution to GL Report
Q - We need to purge A/P Distribution to G/L Report. However, the user interface skips the field "2. Purge File?" and I can't change the default answer from "N" to "Y." I cannot find where -- in Global Setup, AP Setup, Global User's Security, etc. -- ...