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...
-
You may face this error when importing data through data entities and this mostly because of the index of the staging table. The data in you...
-
I was supposed to create a delivery schedule for purchase lines via code and I created this job from the form, how the delivery schedule lin...
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);