Reply To: GL Account not displaying or sorting properly on GP reports

  • Hardik Gupta

    Member
    July 14, 2026 at 8:45 am
    Up
    0
    Down
    ::

    Hi @stephengpcore-ca

    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:

    1. Rebuild RW files: Export affected reports → Delete → Reimport
    2. Reindex GL tables (GL00100/GL00101) in SQL
    3. Clear report cache: Delete C:\Program Files\Microsoft Dynamics\GP\Data\Reports
    4. Rebuild report dictionary: Admin > Reports > Rebuild All
    5. 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 month, 1 week ago by  Kerry Hataley.

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!