RE: Depreciation Entries not equal through Fixed Asset Module
Faraz,
Thank you for your inquiry. For your first issue where the POST to GL entry. An asset included in the run may not have been setup with default accounts.
You can verify this by running the Depreciation Expense to General Ledger Report. Reports>Fixed Assets>Depreciation. Choose Report: Depreciation Expense to General Ledger Report. ON your Ranges: Choose the FA YEAR and the FA PERIOD corresponding the last run you did. On top of that report, the assets without default accounts will show up.
To correct the entry, you can summarize the depreciation amounts of the assets shown with "Account not found" on the report above then edit the unposted JE corresponding to the GL posting procedure in FA. The batch ID of the JE would be prefixed with "FATRX"
For your error log issue, you may need to
1. IMPORTANT - Log everybody out of GP
2. Log into SQL Server Management Studio on the SQL Server housing Dynamics GP.
3. IMPORTANT - Make a new backup of the erring company db.
4. Run the following SQL scripting against the erring company db: delete FAINDEX
5. Log back into the erring Dynamics GP company as the 'sa' or an administrative user.
- Note: This process rebuilds the FAINDEX table based on current FA table content.
6. Back in SQL Server Management Studio, query the erring company db to ensure the FAINDEX file contains data (repeat steps 1-5 if it does not): select * from FAINDEX
Please send in a case with us should your issue persists or need further assistance.
Cheers!
