Back

The field Tax Group of table G/L Account contains a value that cannot be found in the related table.

Published: Aug 08, 2016
Post Author Written by eOne Solutions

In the example below, I was attempting to import G/L Accounts into Microsoft Dynamics NAV and received the following error message: “Failed to create record with keys No = 11200 and No = 11200″. The field Tax Group of table G/L Account contains a value (NONTAXABLE) that cannot be found in the related table (Tax Group).”

To correct this, I setup the missing Tax Group codes in Microsoft Dynamics NAV. Using the Microsoft Dynamics help menu, I searched for the Tax Group and simply added the missing Code (NONTAXABLE).

Once this value was added to Microsoft Dynamics NAV, my import was successful.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.