Skip to main content

Notifications

Announcements

Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Dimension combination ...
Finance | Project Operations, Human Resources, ...
Suggested answer

Dimension combination repeating in Budget Control Statistics report

(3) ShareShare
ReportReport
Posted on by MYGz 2,042
Hi,
 
What is the reason that the dimension combination is repeating 2 times in Budget Control Statistics Report, once for+ve and once for -ve values? Why is it not merging the two together?
 
Categories:
Dynamics 365 Finance
  • Raj Borad Profile Picture
    Raj Borad 1,138 on at
    Dimension combination repeating in Budget Control Statistics report
    Hi @MYGz,
     
    In the Budget Control Statistics by Period report, you see the same dimension combination appearing twice—once with a negative amount and once with a positive—due to different transaction sources or statuses (e.g., one might be a reversal, pre-encumbrance, or correction).
     
    This happens especially if budget checks are triggered at multiple stages like requisition, purchase order, or invoice. The report does not merge these because it reflects transaction-level entries affecting budget consumption. To validate, check the source documents or voucher transactions tied to each line.
     
    For a merged view, consider building a custom Power BI report or using Financial Reporter to net values at the dimension combination level.
  • Suggested answer
    Arvind Bharti Profile Picture
    Arvind Bharti 379 on at
    Dimension combination repeating in Budget Control Statistics report
    Are these values posted separetly in different months or in different way? 
     
    May be check on any of the attribute which might be different for these , is negattive coming from one entry or multiple?

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

News and Announcements

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

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

#1
Martin Dráb Profile Picture

Martin Dráb 501 Most Valuable Professional

#2
Saalim Ansari Profile Picture

Saalim Ansari 315

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 310

Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans