D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Trial Balance Report

  • 1.  Trial Balance Report

    Posted May 23, 2020 07:31 PM
    Hi Everyone, hope all of you are doing well

    I am wondering if some of you have had issues with the Trial Balance report

    In one of the companies I am handling the Trial Balance is not showing correct balances for the last three months.  My question is if there something I can do to correct it?


    When I run the defined trial balance using the financial reports is showing correct.

    ------------------------------
    Alexis Barrios
    Fyffes Group Ltd
    Pompano Beach FL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Trial Balance Report

    MICROSOFT MVP
    Posted May 24, 2020 06:32 PM
    Hi Alexis,

    Are you using Dynamics 365 or AX2012?
    Are you using the Trial balance inquiry form/report or a report defined under 'Financial reports' (Management reporter)?
    If you are using the inquiry form, try to rebuild the balances for all Financial dimension sets.
    If it is Management reporter, try to reset the data mart database.

    ------------------------------
    kind regards,

    André Arnaud de Calavon
    Product manager, Microsoft MVP - Microsoft Dynamics Business Solutions
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Trial Balance Report

    Posted May 24, 2020 07:15 PM
    Hi Andre,

    Thanks for your answer

    I am using D365, and yes I have the issue with the Trial Balance Inquire form

    I have tried to rebuild the balances from all the financial dimension sets, did not work

    Also recalculated the periods from Account Structure, neither work.

    The trial balance from the Management reporter is working fine.  I get all data trough it, correctly.






    ------------------------------
    Alexis Barrios
    Fyffes Group Ltd
    Pompano Beach FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Trial Balance Report

    SILVER CONTRIBUTOR
    Posted May 25, 2020 06:06 PM
    Edited by Shilpi Thakur May 25, 2020 06:06 PM
    In the trial balance form can you check if you see any data when you select "Include Closing transactions in balances" and/or "show opening transactions in opening transaction column" checkboxes available from the Trial balance Column to display form on action pane.

    Also when you rebuild the balances did you enable that in batch?



    ------------------------------
    Shilpi Thakur
    Freelance AX/D365 Microsoft Consultant
    Dynact Consulting Ltd
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Trial Balance Report

    TOP CONTRIBUTOR
    Posted May 25, 2020 08:32 PM
    Edited by Shirley Adams May 25, 2020 08:33 PM
    Hi Alexis,

    I actually just had this happen to me as well - we reversed some transactions and although the detail was right, the TB totals were wrong.  We tried rebuilding and updating but the only thing that fixed it for us was completely clearing the financial set balances and then recreating.  I don't know why updating or rebuilding alone didn't fix it, but you might try that as well.

    ------------------------------
    Shirley Adams
    Solution Architect
    AKA Enterprise Solutions
    New York NY
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Trial Balance Report

    Posted May 25, 2020 08:37 PM
    Thank you Shirley,

    I will try it

    Regards,

    ------------------------------
    Alexis Barrios
    Fyffes Group Ltd
    Pompano Beach FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role