Skip to main content

Posts

Showing posts with the label Error on import data into the table ledgerJournalTrans using Excel add-in in ax 2012

Error on import data into the table ledgerJournalTrans using Excel add-in in ax 2012

In AX2012, while trying to import data into the table ledgerJournalTrans using Excel add-in, If you are  getting this error? Then you can try following.You have to specify the replacement key on the foreign key tables of LedgerJournalTrans, basically Aif/web service displays the user friend values to the user, so it needs a replacement key that replace the foreign key (recId) to user friendly 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