static void FinancialDimension(Args _args) { DimensionAttributeValueSet dimensionAttributeValueSet; DimensionAttributeValueSetItem dimensionAttributeValueSetItem; DimensionAttributeValue dimensionAttributeValue; DimensionFinancialTag dimensionFinancialTag; ProjTable projTable; Select projTable join dimensionAttributeValueSet where dimensionAttributeValueSet.RecId == projTable.DefaultDimension && projTable.ProjId == "000002" join dimensionAttributeValueSetItem where dimensionAttributeValueSetItem.DimensionAttributeValueSet == dimensionAttributeValueSet.RecId join dimensionAttributeValue where dimensionAttributeValue.RecId == dimensionAttributeValueSetItem.DimensionAttributeValue join dimensionFinancialTag where dimensionFinancialTag.RecId == dimensionAttributeValue.EntityInstance; info(strFmt("Description%1", dimensionFinancialTag.Description)); }
Tuesday, 30 December 2014
Job to get Financial dimension Values in AX 2012
Subscribe to:
Post Comments (Atom)
Best Practices for Troubleshooting Application Issues in D365 and Power Platform
When facing application issues, it’s important to systematically troubleshoot before reaching out for support. Follow these steps to ensure...

-
Microsoft Dynamics Ax Macros In MorphX macros are not commonly used. A few places make use of macros such as keeping track of the li...
-
Introduction The query statement in X++ is a primary method of retrieving and manipulating data in Microsoft Dynamics AX 2012. A query can...
how to insert value Default dimension in table ?
ReplyDeleteplease
Container offdefault;
DeleteTableBuffer TableBuffer;
offdefault = [1,"SUBACCOUNTS",'1000'];
Note: 1 is the number of dimensions
Subaccount is the dimension attribute name
1000 is the dimension value
TableBuffer.DefaultDimension=AxdDimensionUtil::getDimensionAttributeValueSetId(offdefault);