D365 Finance & Operations and Dynamics AX Forum

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
------------------------------

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
------------------------------

Original Message:
Sent: May 23, 2020 07:30 PM
From: Alexis Barrios
Subject: Trial Balance Report

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
------------------------------

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
------------------------------

Original Message:
Sent: May 24, 2020 06:32 PM
From: André Arnaud de Calavon
Subject: Trial Balance Report

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

Original Message:
Sent: May 23, 2020 07:30 PM
From: Alexis Barrios
Subject: Trial Balance Report

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
------------------------------

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
------------------------------

Original Message:
Sent: May 24, 2020 07:14 PM
From: Alexis Barrios
Subject: Trial Balance Report

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

Original Message:
Sent: May 24, 2020 06:32 PM
From: André Arnaud de Calavon
Subject: Trial Balance Report

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

Original Message:
Sent: May 23, 2020 07:30 PM
From: Alexis Barrios
Subject: Trial Balance Report

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
------------------------------

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
------------------------------

Original Message:
Sent: May 24, 2020 07:14 PM
From: Alexis Barrios
Subject: Trial Balance Report

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

Original Message:
Sent: May 24, 2020 06:32 PM
From: André Arnaud de Calavon
Subject: Trial Balance Report

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

Original Message:
Sent: May 23, 2020 07:30 PM
From: Alexis Barrios
Subject: Trial Balance Report

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
------------------------------

Thank you Shirley,

I will try it

Regards,

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

Original Message:
Sent: May 25, 2020 08:32 PM
From: Shirley Adams
Subject: Trial Balance Report

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

Original Message:
Sent: May 24, 2020 07:14 PM
From: Alexis Barrios
Subject: Trial Balance Report

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

Original Message:
Sent: May 24, 2020 06:32 PM
From: André Arnaud de Calavon
Subject: Trial Balance Report

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

Original Message:
Sent: May 23, 2020 07:30 PM
From: Alexis Barrios
Subject: Trial Balance Report

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
------------------------------