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 ...LAYMNU General Ledger Statement Layout File Maintenance: Index
Due to the size of the document entitled "LAYMNU General Ledger Statement Layout File Maintenance," we have divided it into several separate sections within the Knowledge Base. What follows is an index listing the contents of each section, along with ...GLENTMNT General Ledger Financial Entity File Maintenance
Financial Entity File Maintenance Application Overview The Financial Entity File application enables you to define financial entities within the main G/L Account File. These entities may then be reported upon individually by entering the entity's ...LAYMNU General Ledger Statement Layout File Maintenance 5
Run Instructions Select Statement Layout File from the pull down G/L Maintenance window. The following screen will then be displayed: Statement Layout File Entry Screen The following options are available: * Select the desired mode from the Statement ...LAYMNU General Ledger Statement Layout File Maintenance 3
Ratios Ratios can only be printed on the Profit and Loss Statement and the Profit and Loss Format Supporting Schedule. In order to be able to select ratios to print on a statement, you must define the basis upon which the ratios will be calculated ...