Replacement key error in Excel Add ins in AX

Q: In AX2012, while trying to import data into the table ledgerJournalTrans using Excel add-in, we're getting this error, any solution for that?

Ans:

You have to specify the replacement key on the foriegn key tables of LedgerJournalTrans, basically Aif/web service displays the user friend values to the user in excel, i.e. if you want to sent the vendTransId in the LedgerJournalTrans, the user dont know about the Id, but he knows about the user friendly columns i.e. vendAccount and other transaction attributes, so it needs a replacement key that replace the foriegn key (recId) to user freindly columns.

Replacement key (pointing to an index, it can be equal to a clustered index)is a key that have columns identifying the unique record.

 Belows tables should be modified to set the Replacement key property in order to resolve this error

•  VendTrans
•  CustTrans
•  Tax1099BoxDetail
•  ReasonTableRef
•  VendBankAccount
•  CustBankAccount
•  BudgetSource

code samples ax 2009

I have found a very good link for code samples of different things in dynamics AX 2009

The list of items includes

·        Code samples for Microsoft Dynamics AX

·        Reports - Generate a List of Reports in Microsoft Dynamics AX

·        EP - Data Binding

·        AIF - Calling the Customer Service in Microsoft Dynamics AX 2009

·        AIF - Calling the Vendor Service in Microsoft Dynamics AX 2009

·        Enterprise Portal Quick Start: Creating Multi-Section Forms in Microsoft Dynamics AX 2009

·        Enterprise Portal Quick Start: Persisting Data Using View State and Data Sets in Microsoft Dynamics AX 2009

·        Enterprise Portal Quick Start: Customizing Lookups in Microsoft Dynamics AX 2009

·        Enterprise Portal Quick Start: Connecting a Details Part to a Grid

·        Enterprise Portal Quick Start: Adding a Toolbar to a Grid in Microsoft Dynamics AX 2009

·        Enterprise Portal Quick Start: Handling Exceptions in Microsoft Dynamics AX 2009

·        Enterprise Portal Quick Start: Using Record Context in Microsoft Dynamics AX 2009

·        Enterprise Portal Quick Start: Creating a Wizard (Tunnel) Form in Microsoft Dynamics AX 2009

·        Enterprise Portal Quick Start: Connecting a Fact Box to a Grid in Microsoft Dynamics AX 2009

·        Enterprise Portal Quick Start: Creating Links Based on Menu Items in Microsoft Dynamics AX 2009

·        Enterprise Portal Quick Start: Creating and Using Proxy Classes in Microsoft Dynamics AX 2009

·        Enterprise Portal Quick Start: Creating a Basic Form in Microsoft Dynamics AX 2009

·        Enterprise Portal Quick Start: Creating a Basic Grid in Microsoft Dynamics AX 2009

·        Enterprise Portal Quick Start: Creating an Advanced Grid in Microsoft Dynamics AX 2009

·        Code for video How Do I: Integrate an Application Using the .NET Business Connector?

·        Code for video How Do I: Create a Custom AIF Pipeline Component?

Office Add ins in AX 2012

How the office Add ins works in the Microsoft Dynamics AX 2012

here the links of the blog that is explaining it

http://msdax.wordpress.com/2011/05/14/office-addins-dynamics-ax-2012/