Skip to main content

Posts

Showing posts from 2016

Steps to Create cube through Axapta

->First step is you need to Create a perspective for a cube a)A perspective is a collection of tables and views that is used to identify the tables and views that contain measures and dimension attributes for a cube. After you create a perspective, you can use it to generate an Analysis Services cube through SQL Analysis Wizard. b) Specify measures and attributes in Perspective and Set required properties for Perspective. c) Generate and deploy the Analysis Services project using Perspective. d) View cube objects in the generated project and see dimension relationship is ok or not. If not then you need to rework with your perspective and deployment. e)Deploy you cube then you can see your cube in SQL analysis connect. e) Process cube.

Code to get Invoice settlement data for customer in ax 2012

This is simple Code to get Invoice settlement amount data for customer payment in ax 2012. This data is after posting of data. select sum(SettleAmountCur) from custSettlement where custSettlement.TransRecId == custtrans.RecId If you want get settlement amount before posting than you can refer spectrans table.The table SpecTrans contains all the transactions marked for settlement for payment journal. while select spectrans join custtransopen join custtrans where spectrans.SpecCompany == ledgerjournaltrans.DataAreaId && spectrans.SpecTableId == ledgerjournaltrans.TableId && spectrans.SpecRecId == ledgerjournaltrans.RecId && spectrans.RefCompany == custtranssopen.DataAreaId && spectrans.RefTableId == custtranssopen.TableId && spectrans.RefRecId == custtranssopen.RecId && custtransopen.RefRecId == custtrans.RecId && custtransopen.AccountNum == custtrans.AccountNum { info(str

Ax debugging configuration,Enable database log, Deploy Default cubes in Axapta

How to set batch job in Axapta Microsoft Dynamics Ax debugging configuration Rest usage data for user in dynamics Axapta Deploy Default cubes in Dyamics Ax

How to get new Sales order number,Project proposal id and Transfer order number in Ax 2012

To get new Sales order number,Project proposal id and Transfer order number in Ax 2012 You can get hints from below code. //Get new sales Id salesTable.SalesId = NumberSeq::newGetNum(SalesParameters::numRefSalesId()).num(); //Get new project proposal id NumSeq = NumberSeq::newGetNum(NumberSeqReference::findReference(extendedTypeNum(ProjProposalId))); //Get new Transfer order number inventTransferTable.TransferId = InventTransferTable::numberSeq().num(); Where parameter table is used and extended data type passed in method.

Check SSRS Report data through job in Ax 2012

If you want to Check SSRS Report data through job in Ax 2012 without executing report then you can get idea from below code. SalesOrderValueTmp tempTable; SalesOrderValueDP dataProvider = new SalesOrderValueDP(); SalesOrderValueContract contract = new SalesOrderValueContract(); contract.parmCustAccount("Test001); contract.parmNoOfBuckets(6); dataProvider.parmDataContract(contract); dataProvider.processReport(); tempTable = dataProvider.getSalesOrderValueTmp(); while select tempTable { info(strFmt("%1,%2,%3,4",tempTable.CurrencyCode,tempTable.SalesId, tempTable.Monthname,tempTable.CurrentMonthSum)); } In this code while look is use to get data inserted in temporary table from data provider class . Contract object is SSRS Report contract class object.

Microsoft Dynamics AX 7 Model Package,Features

Microsoft MB6-890 exam Certification Ax 7 Rainier questions and answers dump sample

1. Which of the below is NOT a component of AX architecture? 10/10 Forms engine UI interaction layer AIF Caches 2. In new AX architecture, AOS windows service has been  removed. True or False? True False 3. Number sequence fall in which part of application stack? 10/10 Application suite Application foundation Application platform None of the above. It comes as a separate model which is not part of any of above. 4. Identify all the conceptual areas of AX cloud architecture.10/10 Shared Microsoft services Microsoft Dynamics AX Microsoft Windows Azure Microsoft Dynamics LifeCycle Services 5. Which of the below statement is true? 10/10 If an object fails in compilation whole build fails. If an object fails in compilation, rest of the objects in the build will still work. If an object fails in compilation, rest of the objects in the build will work but the build