Microsoft Dynamics Axapta Technical,Functional Coverage

Upgrade yourself to Dynamics 365...!! Learn the most demanded ERP course by real time with hands on experienced consultants...!!

Following two line code can help you for Batch jobs log cleanup. If you delete from table manually then it will take longer time but by using delete_from command you can do it quickly. Delete cascade will also work using delete_from query. BatchJobHistory BatchJobHistory; delete_from BatchJobHistory ;

This is a sample Example of Code to create Free Text Invoice in Ax 2012. Variables you need to declare to complete code. ttsBegin; select custTable where custTable.AccountNum == '123'; custInvoiceTable.clear(); if (custTable.RecId != 0) { custInvoiceTable.OrderAccount = custTable.AccountNum; custInvoiceTable.modifiedField(fieldNum(CustInvoiceTable, OrderAccount)); custInvoiceTable.InvoiceId ='test04'; custInvoiceTable.insert(); lineNum = 0; } if (custInvoiceTable.RecId != 0) { custInvoiceLine.initFromCustInvoiceTable(custInvoiceTable); // LedgerDimension=Dimensionstorage::accountNum2LedgerDimension("30104000",LedgerJournalACType::Ledger); custInvoiceLine.LedgerDimension = LedgerDimension2;//5637146102; custInvoiceLine.Description = ''; custInvoiceLine.TaxGroup = '';

This Code Sample to Export Assets Master Table Value to CSV in Axapta. You can take many columns and value from table . This is just an example. Query q; QueryBuildDataSource qbds; QueryBuildRange qbr; QueryRun qr; CommaIO commaIO; FileName fileName; InventTable inventTable; AssetTable AssetTable; ; fileName = "C:\\TestSupport\\" + "ItemDetails1" + ".csv"; //Destination of the file commaIO = new CommaIO(fileName,'W'); q = new Query(); qbds = q.addDataSource(tablenum(AssetTable)); qbr = qbds.addRange(fieldnum(AssetTable,Assetid)); //Range qr = new QueryRun(q); commaIO.write("ItemId","Item Type"); //Header of the CSV File //Loop to insert values in the csv from the table while( qr.next() ) { AssetTable = qr.get(tablenum(AssetTable)); commaIO.write(AssetTable.AssetId,enum2str(AssetTable.AssetType)); break; } WINAPI::shellExecute(fileName);

I am sharing here good link which can help you to learn Dynamics 365 technical and functional for Finance and operation. Just visit this link to watch one by one video. Dynamics 365 learning collection   Ax 2012 Tutorial and tips are here Ax 2012 Tutorial and tips

Problem: Error on Event Log for Dynamics 365 database side. Clustered role 'D365AG' has exceeded its failover threshold.  It has exhausted the configured number of failover attempts within the failover period of time allotted to it and will be left in a failed state.  No additional attempts will be made to bring the role online or fail it over to another node in the cluster.  Please check the events associated with the failure.  After the issues causing the failure are resolved the role can be brought online manually or the cluster may attempt to bring it online again after the restart delay period. Solution: Following things you can try. 1. Restart all server and check admin user in tempdb databse right after restart if no permission then attach user to tempdb database. 2.Most of the problem resolve on restart of servers. 3. If still issue not solved then After some research, we traced it to the ‘Maximum failures in the specified period’ setting at the cluster g

Wow.. Today Got Wou-G Certificate from Godrej Infotech Ltd. For good work.

If you want to  update funding Source for Project Contract in Ax 2012 by code then you can get idea from below code.  These all standard table. ProjFundingSource projFundingSource; ProjInvoiceTable projInvoiceTable; LogisticsLocation logisticsLocation,logisticsLocationNew; ; ttsBegin; while select projInvoiceTable order by ProjInvoiceProjId desc { if(projInvoiceTable.ProjInvoiceProjId != "S_002834") { if(projInvoiceTable.fundingSourceName() != "") { while select forUpdate projFundingSource where projFundingSource.ContractId == projInvoiceTable.ProjInvoiceProjId { projFundingSource.FundingSourceId = projInvoiceTable.fundingSourceName(); projFundingSource.InvoiceLocation = 0; projFundingSource.update(); } } } else break; } ttsCommit;

You can Learn Power BI in easy steps . You just need to visit and view following online training videos from Technical channel. Power BI Report Design and development part first. Power BI Report Design and development part Second. , Publish Report in Power BI 

You can visit following link to view one by one videos which is related to Microsoft Dynamics Ax  Technical and functional Tutorials. Axapta Development Online clips Ax Functional Material Collection SSRS Reports And SQL SQL and SSRS Reporting You can subscribe above channel to get daily updates on new topics and get expertise in ERP .

To change SID for Domain user in Axapta you can see below clip .If you like it do not forget to subscribe it . Thanks in advance.