Technical Tutorials on MS Dynamics Axapta 2012,D365 FnO

I want to share to Execute SSRS Report by code in Ax 2012. You can use below code to run report manually . You can try this code if you are not able to view your report due to some security issue. You can use controller class code to debug your report the get the cause. //version ax 2012 Code SrsReportRunController SRScontroller; SRScontroller= new SrsReportRunController(); SRScontroller.parmReportName(‘TestReport.ReportDesign1′); SRScontroller.runReport();

This code is to create lookup on dimension field like Business unit,department,division etc.You can add this code in your class ,form etc.There could be little bit  change in coding on  form for lookup. // FormStringControl control = dialog.formRun().controlCallingMethod(); SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(DimensionAttributeValue), control); Query query1 = new Query(); QueryBuildDataSource queryBuildDataSource; QueryBuildRange queryBuildRange; DimensionAttribute dimAttr; ; dimAttr = DimensionAttribute::findByName("Department"); query1.addDataSource(tablenum(DimensionAttributeValue)).addRange(fieldNum(DimensionAttributeValue,DimensionAttribute)).value(queryValue(dimAttr.RecId)); sysTableLookup.addLookupMethod(tableMethodStr(DimensionAttributeValue, getname)); sysTableLookup.addLookupMethod(tableMethodStr(DimensionAttributeValue, getValue)); //this code is to add

Getting below error on Bank Account Reconciliation in Ax 2012. Solution: The error given above generally comes when a manual entry is made in the Bank Reconciliation form. After checking data it was found that a manual entry has been done in one of the transactions for an amount xxxx. This requires ledger account in the Bank Transaction type.To correct this issue A journal voucher is required to be posted for the adjustment transaction of particular amount which is found as manual entry.

Problem: Issue is user sys admin not able add or edit and roles privileges duties etc its allowing from AOT but not from AX client. Solution: If you have Sys Admin and Sys User you should be able to make changes via System administration > Setup > Security but if you are still not able to do that then there may be something setting issue. After checking all setting at Ax found that Version control was enabled in the system so its not allowing to change roles privileges and duties  when Version control disabled then its working fine. Due to Version control enabled its being locked for change and its for security reason.

Getting this error on data dictionary synchronization.. Error Synchronise database Cannot execute a data definition language command on  (). The SQL database has issued an error. Info Synchronise database SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot alter column 'VOUCHER' because it is 'REPLICATED'. Info Synchronise database SQL statement: ALTER TABLE "DBO".BANKCHEQUETABLE ALTER COLUMN VOUCHER nvarchar(30) NOT NULL Error Synchronise database Cannot execute a data definition language command on  (). The SQL database has issued an error. Info Synchronise database SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot alter column 'VOUCHER' because it is 'REPLICATED'. Info Synchronise database SQL statement: ALTER TABLE "DBO".BANKDEPOSIT ALTER COLUMN VOUCHER nvarchar(30) NOT NULL Error Synchronise database Cannot execute a data definition languag

Problem: Purchase order Budget validation Error in Ax 2012 coming during purchase invoice . This PO is previous year purchase order on which period is stopped/closed. "The accounting date for the invoice must be in the same fiscal year as the related purchased order. Run the purchase order year-end process or change the date to the current fiscal year" Solution: Check the option in below menu. Go to budgeting -Setup->Budget control->Budget control configuration and make changes in projectsourcedoucuemntlineitemHelper class of projTranstype method by comparing class at Hotfix Ax 2012 R2 KB2921204

Problem . I faced this error Workflow stopped Error after submission for approval in Ax 2012. The items are Purchased, Received or Registered. Quantity ordered cannot be reduced because there are not enough open stock transactions with the ordered status. Observation My observation is as below When I am create new Purchase order and purchase order is in invoiced status but 2 qty is in cancel mode then purchase order getting approved but for old order its give above error. After investigation on google and other sites I did not get anything so finally I did approved workflow from back end activity. I hope some people who is smart they will give answer to me on this query. After some days I get same error again then I assigned admin rights to approval user then its getting approved.