SQL query to extract financial dimension value from CUSTTABLE in Ax

Description:-

Use the Financial dimensions form to create financial dimensions that you can use as account segments for shared charts of accounts.  Although you can use financial dimensions to represent legal entities without creating the legal entities in Microsoft Dynamics AX, financial dimensions aren’t designed to address the operational or business needs of legal entities. The interunit accounting functionality in Microsoft Dynamics AX is designed to address only the accounting entries that are created by each transaction.The following SQL query can be used to extract a financial dimension value from the CUSTTABLE table:

select CustTable.ACCOUNTNUM, SubscriberType.DISPLAYVALUE as SubscriberType 
from CustTable 
  left outer join DIMENSIONATTRIBUTEVALUESETITEM AS SubscriberType ON SubscriberType.DIMENSIONATTRIBUTEVALUESET = CUSTTABLE.DEFAULTDIMENSION 
  left outer join DIMENSIONATTRIBUTEVALUE ON DIMENSIONATTRIBUTEVALUE.RECID = SubscriberType.DIMENSIONATTRIBUTEVALUE 
  left outer join DIMENSIONATTRIBUTE ON DIMENSIONATTRIBUTE.RECID = DIMENSIONATTRIBUTEVALUE.DIMENSIONATTRIBUTE and DIMENSIONATTRIBUTE.NAME ='SubscriberType'

Author : Umesh Patel

Related Posts