Microsoft Dynamics AX (Archived)

Which AX table stores the Budget details per dimension?

(0) Share

Report

Posted on by Community Member

Hi All,

I need some help identifying the corresponding table from my database, where these data are stored.

I have the Main Account Budgets that are entered at Dimension Level.

3162.1.jpg

One example of Budget per Dimension in Budget Register is as per below.

87441.2.jpg

I would like to know which AX table do we query so as to retrieve the budget details per dimension?

Many thanks in anticipation,

Nadeem

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

syed baber 11,633 on at

Like (1)

Report

Hi Nadeem,

You can use the Budget control statistics form (Budgeting -> Inquiries -> Budget Control Statistics) to see the Budget balances based on dimension values. In order to find out the values through X++ code, take a look at BudgetConrolStatisticsManager class.

Please verify and let me know if you have further queries.

Thanks,

Baber.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Baber,

Thanks for your prompt reply.

I verified the form but all I could get is the temporary table BudgetTmpControlStatistics, where the values are not stored.

I've gone through the codes also and found out that it is reading the BudgetControlBudgetCycle table but when I check the table in my database, it is empty.

Can you advise please?

I need a query to fetch the budget details per dimension.

Thanks

Was this reply helpful? Yes No
Suggested answer

Jonathan Halland 11,310 on at

Like (0)

Report

Nadeem

To look up these values is quite complex and does require code to do the look up. There is no simple look ups as the budget will be recorded differently as to what Budget control is enforced against. E.G. Budget is captured against all dimensions but only enforced on two.

This is why the form makes use of temporary tables. You will (as Baber suggested) need to drill into the code to figure out how to do what you want.

Was this reply helpful? Yes No
syed baber 11,633 on at

Like (0)

Report

Agree with Jonathan

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

try BudgetTransactionLine

field name: LedgerDimensions

Was this reply helpful? Yes No
Suggested answer

syed baber 11,633 on at

Like (0)

Report

Hi Nadeem,

Check the Budget Details and Budget control account details history reports. These reports showing the data based on dimension set, so you would definitely get some idea how to retrieved budget balances based on dimensions. The related classes are as follows:

BudgetAccountDetailHistoryDP

BugdetDetailsDP

Check the processReport methods of the above two classes.

Please verify and let me know if you have further queries.

Thanks,

Baber.

Was this reply helpful? Yes No