Hello,
I got below error while creating new report using quick financial.
Not recommended to use quick financial for financial statement report if you are just a GP beginner, this is an ancient piece I don't know why Microsoft still even keeps this, try Management Reporter instead.
Rob
they already using MR but they want also to use AFR.
but they got above error only for some companies not all.
The 'GL_Account_Category_Mstr' table is the GL00102 table for the account categories (such as Cash, A/R, A/P, etc.) It appears as though something cannot be read or found in this table. You could run a dexsql.log to see what value it is looking for in this table, and/or see if any ACCATNUM values in the GL00100 do not exist in the GL00102, and/or compare the GL00102 table between a working company and a non-working company.
Hope that helps,
Cheryl W.
Microsoft Dynamics GP Support
hello,
Thx for your reply.
This is a new company and all data is matched between GL00100 and GL00102.
i created 6 new companies and 3 working perfect and other 3 giving me this error, so it is strange and if i selected the category manually so no error this is only if i want to create the report using the quick financial option.
Have you verified the database owner is DYNSA and then run the Grant.sql script on the company with the error?
It has been a long time since I have done much work with Advanced Financial Analysis (AFA), but I recall there being some accelerator options in GL Setup that sometimes needed to be tweaked. (Most GP performance issues were resolved long ago so these are less critical in the "modern" days of robust hardware.)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,004
André Arnaud de Cal... 857 Super User 2025 Season 2
Sohaib Cheema 548 User Group Leader
