- (619) 483-4180
- info@avantiico.com
Product Selection Tools
Evaluation Guides
Readiness Overview
Identifying Stakeholders
Managing Expectations
Prepare to be Prepared
Upgrade Services
Project Management
Roadmap Services
Data Migration
Data & Analytics
Avantiico Industry Solutions
Explore by Business Need
Avantiico Industry Solutions
Microsoft Platforms
Licensing & Pricing Options
Our Partners
Careers
Avantiico Academy Program
About Avantiico
Events & Webinars
Core Services
Core Solution Areas
Recent Blog Posts
Featured Blog Posts
The Microsoft Dynamics AX/D365 Support Team at Avantiico is focused on solving our client’s problems, from daily issues to large and more complex problems.
Introduction 2023 was a big year at Avantiico. We were awarded the 2023-2024 Microsoft Business Applications Inner Circle award, achieved the Great Place to Work
Introduction Navigating the complexities of Microsoft licensing is a crucial task for modern businesses. This guide offers a comprehensive comparison between Microsoft’s EA or Enterprise
This blog explores how D365, combined with the Advanced Multi-Company Solution by Avantiico, enables streamlined financial management and reporting. Discover the transformative impact of Ledger
Explore the transformative impact of Avantiico’s 3PL Billing Automation ISV solution on logistics operations. Discover how this solution streamlines billing processes, ensures accuracy, and integrates
Financial dimensions are stored as a 64bit integer surrogate key in the database. It may be necessary to extract this information to understand the financial dimensions that this surrogate key represents. For example, a custom BI solution, report or integration may require that this surrogate key be de-serialized to reveal the exact financial dimensions it represents. This blog explains some of the common Microsoft Dynamics APIs available and display financial dimension segment from a default dimension surrogate key. A simple job is created to demonstrate this.
In this example, we will be working with the financial dimensions of a customer.
This is stored in the SQL database as a 64 bit integer.
The database schema below represents all the tables and views that are required to de-serialize and display the financial dimensions that this surrogate key represents, however this blog post will demonstrate key Microsoft Dynamics AX API’s that can assist developers.
The following script is created to demonstrate:
The following Microsoft API’s are used:
The DimAttribute financial dimension backing entities have a key, value and name field. The following example shows the financial dimension backing entity for departments which are stored in the table OMOperatingUnit
Thanks for reading, comment below to let me know if you struggle with something specific in D365 or DynAX!
Introduction 2023 was a big year at Avantiico. We were awarded the 2023-2024 Microsoft Business Applications Inner Circle award, achieved the Great
Introduction Navigating the complexities of Microsoft licensing is a crucial task for modern businesses. This guide offers a comprehensive comparison between Microsoft’s
This blog explores how D365, combined with the Advanced Multi-Company Solution by Avantiico, enables streamlined financial management and reporting. Discover the transformative
600 B Street, Suite 300, San Diego, CA 92101 | (619) 483-4180 | info@avantiico.com
Discover how Avantiico helps you improve business processes, provide customers with a seamless experience and transform the way you do business.