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.

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!