Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Trial balance showing incorrect date when selecting date interval

(0) ShareShare
ReportReport
Posted on by 59

Hi there

In our AX, we have many companies setup.  Our main company, GAA is working correctly but our secondary company GAB is not.

The issue is when selecting Date interval on the Trial Balance for 2021 P03, the correct date interval is showing for GAA but not for GAB.

I have checked the financial calendars for GAA and GAB and they are setup identically.  

I have looked at the ledger calendars and again, I cannot see a problem with the setup.  

Can anyone advise what the problem might be?

Thanks 

 

 

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Trial balance showing incorrect date when selecting date interval

    Hi Chocolate Pizza,

    I was wondering whether the date interval setup is made differently.

    Can you check whether the parameters have been made differently?

    Best regards,

    Ludwig

  • Chocolate_Pizza Profile Picture
    59 on at
    RE: Trial balance showing incorrect date when selecting date interval

    Hi Ludwig 

    Yes, we can see the correct data and using the from and to dates manually.

    I attach screen shots of the financial calendar for GAA and GAB.  I have named them GAA and GAB as I do not want to give the actual company names (data protection) so apologies for crude red font from the snipping tool!

    pastedimage1617721092235v1.pngpastedimage1617721212446v2.png

    Let me know if you need further screenshots and as long as there is no sensitive data, I can provide them.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Trial balance showing incorrect date when selecting date interval

    Hello Chocolate Pizza,

    Can you share some screenprints of your setup?

    If you don't make use of the date intervals but rather enter the from and to dates manually, do you see the correct data?

    Best regards,

    Ludwig

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.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 601 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 416

#3
Adis Profile Picture

Adis 384 Super User 2025 Season 1

Product updates

Dynamics 365 release plans