#TipADay: Copying Data Between Companies using Excel Add-in

Hello everyone Here is little tip on how to migrate data through Excel Add-In  . Through Excel Add-in you have the option of selecting what instance, partition, and company that you want to upload and publish to. Let us work on how we can use the Excel Add-In to copy data between entities. I have not […]

read more

#TipADay: Day 2: Importing Data to Microsoft Dynamics AX 2012 using Excel Add-in

Excel is a great spreadsheet tool and the AX 2012 Add in is even more wonderful. It allows to publish information/data back to Dynamics AX 2012 without any changes in AX 2012  configuration.  In this functioned example, I will show how you can use the Dynamics AX Excel Add-In to update your data.  Before we […]

read more

Questionnaires: How to create Questionnaires in Dynamics AX 2012

This is the second post in the series related to Questionnaires in Microsoft Dynamics AX 2012. Questionnaires are not difficult; they are just extremely flexible. In an ERP solution, you may think that standard and/or best practices should be part and parcel; but Microsoft Dynamics AX 2012 offers some features that are not only extremely […]

read more

Dynamics AX 2012: Questionnaires, what are they and why you should use them

In this two part tutorial, we shall explore and evaluate the true potential of the questionnaires in AX2012. Even though Microsoft Dynamics AX 2012 offers a wide variety of mainstream features in relevant modules apt for a tier one ERP solution; some little known features can help you explore the little nooks and crannies that […]

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