If you’ve already invested in Dynamics 365 for Finance and Operations, then you know the value of a cloud-based ERP system. Now, eCommerce companies can
Enterprise Resource Planning (ERP) solutions have nowadays become an essential part of any organization that needs to manage their business functions within a centralized and
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!
We’ve seen a lot of confusion around the use of Dynamics 365 Portals within Dynamics 365 for Marketing. More specifically, we’ve received
If you’ve already invested in Dynamics 365 for Finance and Operations, then you know the value of a cloud-based ERP system. Now,
Staying in compliance with sales tax laws is no easy feat and seemingly small errors can turn into costly mistakes. With so