Notifications
Announcements
No record found.
Hi there, I was trying to develop an SQL Query to fetch Financial Dimension details (General Ledger > Financial Dimensions) for Divison. My requirement is i need to get the Legal entity details for the Financial DImension. Which tables i need to refer to get the Legal Entity for Financial Dimensions. I can able to get the details like Display value, Description, Group Dimension from joining with DimensionAttributeValue and Dimensionfinancialtag tables but i cant able to find the legal entity details for Financial Dimension. Pls suggest accordingly.
Thanks & regards,
Prem Kumar K
Hello Prem Kumar,
Can you share the AX version you are working with?
Many thanks,
Ludwig
Hi Ludwig, Currently i was working with D365 F&O (On premises) version
Hi, i tried to join with DirPartyTable with recid of Dimensionattribute and am not sure whether it was returning the correct legal entity for the Division Financial Dimension or Not.
DIMENSIONATTRIBUTE.RECID = DIRPARTYTABLE.RECID .
Pls suggest on the same. Thanks
moved to the d365 forum
Hi Can u pls suggest how can i get the Legal entity for Financial Dimension in SQL Query.
Example :
DAT xxxxxxx
USMF xxxxxxx
TST xxxxxxx
It should populate financial dimension details for all the legal entities. Thanks
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 503 Most Valuable Professional
André Arnaud de Cal... 434 Super User 2025 Season 2
BillurSamdancioglu 278 Most Valuable Professional
