Wednesday, 31 August 2011

EDT Relation Migration Tool [Dynamics AX 2012]

Hi All,

In AX 2009, We all know that Table relations were defined only through EDTs and this was a problem if multiple relations were needed between tables, or if relations involved composite keys.
In Microsoft Dynamics AX 2012, relations can no longer be created under extended data type (EDT) nodes in the Application Object Tree (AOT). Relations that are defined under EDT nodes are still effective, but in a future release they will be obsolete and deleted.
The EDT relation migration tool helps you move relations from EDT nodes to table nodes. The EDT relation migration tool is found on the client menu, under Tools > Code upgrade > EDT relation migration tool.
For more information : click here.


Deactivating configuration key will not affect the table any more [Dynamica AX 2012]

Hi All,

In DAX 2009 or earlier versions, deactivating a configuration key affected a table in Microsoft Dynamics AX and the associated table was removed from the underlying Microsoft SQL Server database.
In Microsoft Dynamics AX 2012, the associated tables are not removed from the database. Instead, the tables are deactivated in the system, which means that they are treated as empty tables. However, the deactivated tables and their data are still fully available in the underlying database.

Free Text Invoices allows to add Qty and unit price in Dynamics AX 2012

Hi All,
Free Text Invoice in AX 2012 is enhanced to add quantity and unit price. I remember for most of the clients we have added/customized these fields. But, during the upgrade to AX 2012, we probably need to help the clients with the new feature in AX2012 [Ofcourse, bringing data will be tricky]
Path >> AR >> Common >> Free Text Invoices >> All Free Text invoices. Create a header and Journal Line as shown below.
On the Action Pane, click Free text invoice.
- In the Customer account, select customer 1103
- Go to Invoice lines > Description, enter Installation and configuration.
- Select Main Account as 401190.
- Enter Quantity as 3
- Enter Unit Price as 500
Below is the screen shot for reference.

Save the record and click on the post button on the Action pane.
I see an important tab on the Lines called Distrubute amount. This will help to distribute the amount across multiple financial dimensions. [Help from MS docs]. Will post another entry in detail to explain the same.


AX 2012 Upgrade - Detect Code Upgrade Conflicts Issue

Hi All,
We are upgrading from  Ax2009 - Ax2012.When we try to run the upgrade checklist - Detect Code upgrade conflicts process our client is crashed after few minutes of the process start.After a long research we found the following few things which made our process complete successfully.

1. Full AOT compilation is required
2. Run the AX in single-user mode
3. Remove customizations from the following forms.(We used Debugging Tools for windows - Windbg and then keep track on AX client and found the following forms causing crash)
           
BOMTable
HRMAbsenceApproval
InventPosting
LedgerJournalTable
ProjStatistic
ProjTransEmpl
SalesCreateQuotation
SalesEditLines
VendTable
PurchEditLines