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, ... / AX 2012: Department Fi...
Finance | Project Operations, Human Resources, ...
Suggested Answer

AX 2012: Department Financial Dimension

(4) ShareShare
ReportReport
Posted on by TT-23122329-0 86
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?
2025-11-12_10-25-36.png
2025-11-12_10-25-02.png
Categories:
Microsoft Dynamics AX
I have the same question (0)
  • Adis Profile Picture
    Adis 6,513 Super User 2026 Season 1 on at
    Updated the category to AX
  • Suggested answer
    Sathish Kumar Palanisamy Profile Picture
    Sathish Kumar Palan... 388 Super User 2026 Season 1 on at
    Hi 
     
    In AX 2012, Department is not a direct field on Position. It’s stored via DefaultDimension, which links to DimensionAttributeValueSet.
     
     
  • TT-23122329-0 Profile Picture
    TT-23122329-0 86 on at
    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-54.png
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 9,073 Super User 2026 Season 1 on at
    Hi,
     
    If you want to modify Department dimension on Homeworker, check the following code, it updates cost center financial dimension in invent Table:
     
     
     
     

    Thanks,

    Waed Ayyad

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

  • TT-23122329-0 Profile Picture
    TT-23122329-0 86 on at
    I just need to know the name of the table where this field is stored
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,383 Super User 2026 Season 1 on at
    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.

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 386

#3
Adis Profile Picture

Adis 259 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans