Exploring Drill through Reports in Dynamics Ax 2012 R3.

Creating basic drill through reports in Dynamics Ax 2012 R3 is really simple. Consider following scenario where we have to show the list of customer and their sales Orders in particular legal Entity.  In this report when User clicks on customer account, a new report opens, which contains list of all possible sales Orders. For […]

read more

Date effective framework – Retrieve Data using Query

0
Written By: Fatima Zafar

Introduction: In order to cater the scenarios where organizations need to keep track of or analyze data which keeps changing over time, Date effective framework was introduced in Microsoft Dynamics AX 2012. One of the main requirements of an organization could be to keep track of an exchange rate.  What is the exchange rate today? […]

read more

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

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