web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Financial dimension se...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Financial dimension set update balance batch job

(3) ShareShare
ReportReport
Posted on by Anoop Paliath 27

Hi Experts,

I executed the Update Balance batch job for a financial dimension set by selecting the legal entity context as "ALL". However, upon reviewing the batch job ID and checking its parameters, I noticed that the legal entity context has changed to "Current".

Additionally, the logs do not provide any confirmation that the batch job executed across all legal entities and only USMF is listed in the batch job history.

Is this behavior expected by design?

How can we verify that the batch job has indeed run for ALL legal entities?



 
Categories:
Dynamics 365 Finance
I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 305,182 Super User 2026 Season 1 on at
    Hi Anoop,
     
    As far as I remember, it will update balances per dimension set, not restricted per company, but I might be wrong. Have you tried setting up this batch job in the DAT company? 
     
    Anyway, there is a feature available in feature management with a storage and performance improvement for dimension sets. This will also replace the need for setting up this batch job. Ensure you test the impact before enabling it in a production environment as data will be physically stored in new tables. In case there are customizations or add-on solutions with dependencies on the old data model, this needs to be replaced first: Performance and Storage Improvements Coming to Financial Dimensions - Microsoft Dynamics 365 Blog
  • Suggested answer
    Anoop Paliath Profile Picture
    Anoop Paliath 27 on at
    Hi Andre,
     
    Yes, I tested this but getting the same results. So, I assume this is by design, however not able to validate of the update batch job is working for all the legal entities. 
     
    Microsoft has suggested to enable the ‘Performance enhancement for general ledger dimension set balance calculation’ feature that was specifically created for this type of performance issues. This is available from 10.0.38. New financial dimension sets - Finance | Dynamics 365 | Microsoft Learn.
     
    However, as you mentioned, it is getting failed due to old tables as client use lot of customized reports and few of this are getting failed. We are fixing this first before enabling the feature in Prod.
     
    Meanwhile we have suggested "Update balance" batch job since client has not enabled this and balances are updated only in TB form when user click "Calculate balance" and they experience delay in TB run as balance are updated only at this time. 
     
    Regards,
    Anoop

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 694

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 584 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 518

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans