Dynamics GP
Dynamics GP
Organizer:
- JOSE Organized by
-
-
GL Account not displaying or sorting properly on GP reports
-
GL Account not displaying or sorting properly on GP reports
GL Account not displaying or sorting properly on GP reports since June CAD Tax Table Update.
All GP Reports now are having a problem with the Account Mask.
It’s the same for all GL detail reports.
I’ve been creating SmartLists for temporary fixes for now.
There must be an update coming from Microsoft that you need to keep a lookout for as it can’t just be happening at my client.
Additionally, there seems to be a SQL interrupt generated when the account field is pulled in reports (just a guess).
GP is continually crashing for no reason and not just from the host pool workstation.
It is also crashing continuous when run from the SQL Server, so it’s not a network interrupt causing this.
To validate that the GL account wasn’t corrupt, I have copied the database to a test db and run CheckLinks on all financial – zero results.
I have included the PDF of a payroll posting report c/w the SmartList (Excel) that I made as a current work around.
This isn’t however, just occurring in payroll as GL Trial Balances aren’t working at all either.
Any report that uses the full account string is pulling without the main Segment.
-
4 Replies
-
GP has been heavily affected by recent Microsoft updates, especially post-CAD Tax Table changes. Your diagnostic approach is solid (data is clean = report-level issue).
Quick fixes to try:
- Rebuild RW files: Export affected reports ā Delete ā Reimport
- Reindex GL tables (GL00100/GL00101) in SQL
- Clear report cache: Delete C:\Program Files\Microsoft Dynamics\GP\Data\Reports
- Rebuild report dictionary: Admin > Reports > Rebuild All
- Verify GL Account segment configuration matches post-update CAD table setup
Root cause: Post-update, reports reference old segment indices, which drops the main Segment from account strings.
Let me know if any of these work for you.
-
This reply was modified 1 week, 3 days ago by
Kerry Hataley.
-
Part of the update process … is to use GP Utilities to rebuild the RW (Report Writer file ,,, or Reports dictionaries) .. I never use this process as I find it more problematic than rebuilding. I always rebuild all RW files every update .. so step 1 has been done but will be done once more. Step 3. Clear Report Cache is basically delete the dictionary … again .. was done during the update …
I will perform all GP SQL rebuilds on the databases tonight after backups and take care of any steps mentioned here. Updates to follow.
-
All steps have been taken as suggested. Report dictionaries were purged and rebuilt from package files. All GL indexes have been purged and rebuilt using Check Links.
The GL account on both financial and payroll posting reports is still not using the account mask, and therefor isn’t separating by GL segment. This is particularly an issue for Trial Balance Detail reports.
I doubt that the issue of GP crashing has been resolved.
I can be reached at stephen@gpcore.ca
I cannot work on any of this during business hours and they have employees working across all of Canada. As a result business hours begin 6:30 AM Eastern and run until 6 PM Pacific.
Log in to reply.
