Posts

Showing posts from September, 2016

Financial Dimesnisons in ax 2012

x++ code to get financial dimensions of customer in ax 2012.     DimensionAttribute                              dimAttr;     DimensionAttributeValue                    dimAttrValue;     DimensionAttributeValueSetItem       dimAttrValueSet;   void customerFinacialDimensions(DimensionDefault  _defaultDimension) {       while  select DimensionAttributeValueSet,DimensionAttributeValue,DisplayValue from             dimAttrValueSet                 where dimAttrValueSet.DimensionAttributeValueSet    == _defaultDimension             join RecId,DimensionAttribute from dimAttrValue                 where dimAttrValue.RecId  == dimAttrVa...

x++ code to Insert Data into Table directly from Query in ax 2012

Hello Guys,the below is the process to insert data into table directly from query.     TestTable   testTable;     Query         query;     QueryBuildDataSource    qbds;     QueryBuildFieldList     qbdfieldList_customer;     QueryBuildRange         qbr;     Map                               fieldMappig;     delete_from testTable;     query = new Query();     qbds = query.addDataSource(tableNum(CustTable));     qbr = qbds.addRange(fieldNum(CustTable,Currency));     qbr.value('AUD');     qbdfieldList_customer = qbds.fields();     qbdfieldList_customer.addField(fieldNum(CustTable,Currency));     qbdfieldList_customer.addField(fieldNum(CustTable,AccountNum));     qbdfieldList_customer.a...