Date Lookup in a String Control

Sometimes, you may need to lookup the date calendar in a string control. This was easily possible by overriding the lookup function and call the below method in the AX older versions. public void lookup() { ; this.performFormLookup(SysLookup::LookupDate()); } But in AX2012R2 you cannot use the lookupDate function like this because it is made protected […]

read more

Calling table insert stops the AX service AX2012

0
Written By: Taimoor Hussain

Recently, I faced an issue when calling table insert from code. Every time I executed the statement table.insert() the service of dynamics AX2012 was stopped. There may be two reasons of this issue. 1-      The RecIds of that particular table tables is getting duplicated, in case if you inserted the data to  that particular table […]

read more

Exchange Currency Service Provider

Exchange currency service provider is OOTB available in MS Dynamics AX and by default three AX provide three service exchange provider i.e. Central Bank of the Russian Federal, Central bank of Europe and Lithuanian Bank. Following is the below screen for Exchange Rate provider which is Available in General Ledger Module Path: General ledger /setup […]

read more

Delete All the Transactions in a Company by keeping the Master Data intact Dynamics AX

Sometimes, you may have a requirement to delete all the transactions in a company while keeping the Master data as it is. In order to achieve this you can duplicate the company and run SysDatabaseTransDelete class, which will delete all the transactions in the related company while keep the master data intact. 1. Press Ctrl […]

read more

Usage Data User Specific Report Error Dynamics AX 2012

Sometimes, you might face the error in which some reports like “Summary trial balance” report in general ledger will not execute. In order to resolve this error you need to delete the related records from SysLastValue table. You cannot find this table in AOT so go to SysLastValue form, open data source node, right click […]

read more

Region as an Internal Organisation

System should allow users to create Region within the internal organization hierarchy. For this we have to do some customization First create new operating unit type element in OMOperatingUnitType base enum OMOperatingUnitType is used in OMOperatingUnit tables so we need to Restore OMOperatingUnit tables. Create new View which named as DimAttributeOMRegion as shown in below […]

read more

Customize Existing Number Sequence to Fiscal Year Number Sequence

Here we are customizing existing Number sequence and convert it in to Fiscal year number sequence Many customer demands for Purchase order creation with automatic year means how to add year to a number sequence in AX2012, e.g. to generate IDs such as 2013-xxxxx and 2014-xxxxx, that would automatically use the current year. Some people […]

read more

Consuming External Web Service through a .Net Class Library Wrapper in Microsoft Dynamics AX 2009

Direct referencing a web service in AOT may lead to different issues some times when it comes to use service reference in the x++ code. I will show you a simple recipe of how we can consume an external web service in AX2009 by wrapping this web service into a .net assembly wrapper. Open a […]

read more

Import ledger, AP and AR invoice journal lines

Recently, I came across a requirement in which users want to import the ledger, AP and AR invoice journal lines from a pre-defined excel format in general journal AX2012R2. So I developed a functionality hope that helps you Below snap shot shows the flat list of all objects in this project.  Below snap shot shows […]

read more