Microsoft Dynamics 365 / AX

  • Home
  • Get in touch

SQL

Dynamics 365 For Fin & Ops SQL

BaseEnum values

Hey! In D365FO some BaseEnums doesn’t have the Enum Value property in its elements. This happens because the ABC BaseEnum is extensible. To comply with the extension framework Microsoft introduced a new property on BaseEnums that determine if the enum is extensible or not. If the Enum is extensible then Read more…

By ptornich@hotmail.com, 6 yearsSeptember 25, 2019 ago
SQL

SQL Server table locks

Hello folks, I’ve been working with AX/D365 for several years and there is one thing that happens in almost all projects with high data volume, at some point we start to get slow processes. When I have to analyze very slow process, those that seems to be stuck, I like Read more…

By ptornich@hotmail.com, 6 yearsSeptember 25, 2019 ago
Dynamics 365 For Fin & Ops Financial Dimensions SQL

Get financial dimension value and description

We were posed with the following task the other day, get all financial dimension values and descriptions But those fields can come from different tables depending on the type of the dimension.For example, custom dimensions are stored in the DimensionFinancialTag, while Departments will be stored in the DirPartyTable. To overcome Read more…

By ptornich@hotmail.com, 6 yearsSeptember 16, 2019 ago
Pedro Tornich
Recent Posts
  • Use D365FO metadata API in .Net
  • Create Journal Line With CustTransOpen (AX2012)
  • Create Journal Line (AX2012)
  • Get call stack
  • Get Dimension Value From Default Dimension
Categories
  • .Net
  • AX2012
  • Dynamics 365 For Fin & Ops
  • Financial Dimensions
  • SQL
  • SSRS
  • Home
  • Get in touch
Hestia | Developed by ThemeIsle