Finance | Project Operations, Human Resources, ...

AX 2012: Department Financial Dimension

(3) Share

Report

Posted on by TT-23122329-0

Hello everybody,

So I know that D365 stores the Department financial dimension value on the Position. However, in AX 2012 I don't see it there. Is there a field for this in AX 2012?

If so, what table is this field in?

Categories:

Microsoft Dynamics AX

2025-11-12_10-25-...

I have the same question (0)

All responses (6)

Answers (0)

Adis 6,027 Super User 2025 Season 2 on at

Like (0)

Report

Updated the category to AX

Was this reply helpful? Yes No
Suggested answer

Sathish Kumar Palan... 380 on at

Like (0)

Report

Hi

In AX 2012, Department is not a direct field on Position. It’s stored via DefaultDimension, which links to DimensionAttributeValueSet.

1 people found this reply helpful.

Was this reply helpful? Yes No
TT-23122329-0 82 on at

Like (0)

Report

That table does not have the Department value:

We have an issue with 2 employees that within their financial dimensions the department value is blank, but within the worker list page/table it shows a value. I need to find the table name in order to remove the department value from the back end.

2025-11-12_14-45-...

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,023 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

If you want to modify Department dimension on Homeworker, check the following code, it updates cost center financial dimension in invent Table:

https://community.dynamics.com/blogs/post/?postid=527b6405-7e13-4b21-a021-aadd9654b0cb

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
TT-23122329-0 82 on at

Like (0)

Report

I just need to know the name of the table where this field is stored

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 300,743 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

In case you are referring to the financial department dimension, then this is stored in several tables building up dimension set combinations with their values. You can download a whitepaper that explains the data model. https://download.microsoft.com/download/4/E/3/4E36B655-568E-4D4A-B161-152B28BAAF30/Implementing_the_Account_and_Financial_Dimensions_Framework_AX2012.pdf

Using this whitepaper, you can find the table.

Was this reply helpful? Yes No