Skip to main content

Posts

Solved Error during Inventory Closing and Recalculation in Ax 2012

Getting following Error during Inventory Closing and Recalculation in Ax 2012. Error Details: "You can't have unallocated cost on a planning formula" Solution : This error may come many ways. First check the item in production type is formula or not, if not, change production type to formula. Then you can debug following method in class InventCostItemDim  \Classes\InventCostItemDim.addFormulaKeyAdjustment() To get any error due to rounding you can check ledgervouchertransobject class in checkrounding method. Then you can correct rounding issue. If still error exist then find the recid by debugging on error editing message and find that record in inventtrans table. If in inventtrans table valueopen field if its yes then select no this option you can use only if there is no other solution you found.

Get unit conversion value of item in Ax 2012

To Get unit conversion value of item in Ax 2012 you can use below code. UnitOfMeasureConverter_Product is a class which has different method to give you converted value. Here example is showing to get conversion value from liter to kilo gram. UnitOfMeasureConverter_Product unitConverter = UnitOfMeasureConverter_Product::construct(); unitConverter.parmProduct(InventTable::find("TestIte",true).Product); unitConverter.parmFromUnitOfMeasure(UnitOfMeasure::unitOfMeasureIdBySymbol("ltr")); unitConverter.parmToUnitOfMeasure(UnitOfMeasure::unitOfMeasureIdBySymbol("kg")); unitConverter.parmRoundAbsoluteValue(NoYes::Yes); unitConverter.parmApplyRounding(NoYes::Yes); info(strFmt("%1",unitConverter.convertValue(1)));

Run Dynamics Ax as different user on single machine

If you want to Run Dynamics Ax with different user on single machine then you need not to login as remote with different user you can run Ax with same login by following trick. Just press shift and then right click on dynamics Ax Icon then following option will show for login as different user. This will work only for original Ax Shortcut not Ax configuration file. If you want to do this trick with configuration file then you need to do below. First You need to create an AX32.exe shortcut that takes the config file as a parameter using properties option . Put below. C:\Program Files\Microsoft Dynamics AX\60\Client\Bin\Ax32.exe" -regconfig=C:\ConfigName.axc

Execute SSRS Report by code in Ax 2012

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();

Create lookup Code on dimension field in Ax 2012

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

Bank Account Reconciliation Error in Ax 2012

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.

System admin cannot add or edit roles privileges duties Ax 2012

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.