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 / Microsoft Dynamics AX (Archived) / SQL report for Budget ...
Microsoft Dynamics AX (Archived)

SQL report for Budget transaction line

(0) ShareShare
ReportReport
Posted on by Kemi 95

Hello all,
Am trying to run a query in SQL to show budget transactions line and the related account dimensions value. But in the table(Budgettransactionline) it only has the ledgerdimension codes alone not the account dimension numbers. Please how do I get the display value for the ledger dimension filed in the Budgettransactionline table.

Thank you

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    Have you recorded your budget transactions with a financial dimension?

    If so, why don't you use the management reporter to analyze your budget data by financial dimension?

    Best regards,

    Ludwig

  • Kemi Profile Picture
    Kemi 95 on at

    I Have issues with my Management reporter that is why i am resulting to ssrs.

    Thank you

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    I see.

    What about the standard budget control and budget planning cubes?

    docs.microsoft.com/.../deploy-the-default-cubes

    They are there out of the box.

    Can't you use them?

    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

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 March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 16

#2
GiacomoRovai Profile Picture

GiacomoRovai 4

#3
Douglas Noel Profile Picture

Douglas Noel 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans