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)
Calculate ledger balance by dimension set in X++ in AX2012/Dynamics 365 FO
There are a variety of ways users can view balances in the general ledger. Some of the most common options are: 1. Trial balance 2. Financia...
-
static void Main ( string [ ] args ) { string customer = " US-004 " ; AxdCustomer foundCustomer = null ; C...
-
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);