Microsoft Dynamics Axapta Technical,Functional Coverage

Following step need to set for administration point of view for workflow steps and setting. 1. Click Area Page node: System administration -> Setup -> Batch group . Form name: Batch group 2. Switch to the Batch servers tab on the Batch group form and check whether server is added to batch group or not. 3. Click the Close toolbar button. 4. Close the Batch group form. 5. Click Area Page node: System administration -> Setup -> System -> Server configuration . Form name: Server configuration 6. Click the Close toolbar button. 7. check server name and Close the Server configuration form. 8. Click Area Page node: System administration -> Setup -> System -> System service accounts . Check the service accounts. 13. Click Area Page node: System administration -> Setup -> Workflow -> Workflow infrastructure configuration . Form name: Workflow infrastructure configuration wizard 14. Click the Next

Step 1: (‎05-‎Mar-‎17 12:42:41 PM) User left click on "Microsoft Dynamics AX 2012 (menu item)" Step 2: (‎05-‎Mar-‎17 12:42:43 PM) User left click on MSD‬ [‎‪xyz‬‪: ‎‪Session ID‬ - ‎‪3‬‬]‎ - ‎ [‎‪1‬ - ‎‪usmf‬ - ‎‪initial‬]‎ (list item)" Step 3: (‎05-‎Mar-‎17 12:42:45 PM) User left click on "BatchJob (link)" in test‬ [‎‪xyz‬‪: ‎‪Session ID‬ - ‎‪3‬‬]‎ - ‎ [‎‪1‬ - ‎‪usmf‬ - ‎‪initial‬]‎" Step 4: (‎05-‎Mar-‎17 12:42:47 PM) User mouse drag start on "‪Batch job‬ (‎‪1‬)‎‪ - ‎‪‪‪Job description‬: ‎‪Change based alerts‬‬, ‎‪‪Withhold‬‬‬, ‎‪Partition Key: initial‬‬ (window)" in "‪Batch job‬ (‎‪1‬)‎‪ - ‎‪‪‪Job description‬: ‎‪Change based alerts‬‬, ‎‪‪Withhold‬‬‬, ‎‪Partition Key: initial‬‬" Previous Next Step 5: (‎05-‎Mar-‎17 12:42:48 PM) User mouse drag end on "‪Batch job‬ (‎‪1‬)‎‪ - ‎‪‪‪Job description‬: ‎‪Change based alerts‬‬, ‎‪‪Withhold‬‬‬, ‎‪Partition Key: ini

To Get total number of records from all table and Export data  into excel in Axapta 2012 you can apply below tips. Go to AOT(CTR+D)->Tool->Number of Records to bring in excel select all  records then press Control +T key You can get exact steps from below video clips. To Reindex and synchronize table from Microsoft Dynamics Axapta You can apply below tips System administration -Periodic-Database -SQL Administration To get exact step see below clips. You can subscribe to get more updates.

How to Get version of Microsoft Dynamics ax 2012 how to arrange window as cascade and tile. how to compile,full and incremental CIL from AOT. How to get total number of records from all tables from menu items. How to refresh cache for dictionary,data,element and SSRS report.

If you want to get Get current User Full name in Ax 2012 the you can try below code through job in x++. static void getcurrentUserFullname(Args _args) { ; info(UserInfoHelp::userName(curuserid())); }

To find BOM Unit and Inventory Unit for item you can get idea from below code sample.This code you can try in your job code editor in axapta. InventTable inventTable; InventUnitId inventoryUnit,BOMUnit; BOM bom; ItemId curItem; ; while select BOM order by itemid where BOM.BOMQty { if(curItem != BOM.ItemId) { curItem = BOM.ItemId; inventTable = InventTable::find(bom.ItemId); inventoryUnit = inventTable.InventUnitId(); BOMUnit = bom.UnitId; if(!UnitOfMeasureConverter::canBeConverted(UnitOfMeasure::findBySymbol(inventoryUnit).RecId, UnitOfMeasure::findBySymbol(BOMUnit).RecId, inventTable.Product)) { if(inventoryUnit != BOMUnit) { info(strFmt("item %1 has bom unit %2, inventory unit %3",inventTable.itemId,BOMUnit,inventoryUnit)); } } }

->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.

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

This is Ternary Operator Example in Axapta. Its same as below if else condition results. str result; result = (custTable::find("US-027").RecId) ? "found" : "not found"; info(result); // Same as if(custTable::find("US-027").RecId) resut= "found"; else resut= "not found";

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

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.

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.