Back

The field Gen. Bus. Posting 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 = 44200 and No = 44200″. The field Gen. Bus. Posting Group of table G/L Account contains a value (EU) that cannot be found in the related table (Gen. Business Posting Group).”

080816 1945 KBArticleTh1

To correct this, I setup the missing Gen. Business Posting Groups in Microsoft Dynamics NAV. Using the Microsoft Dynamics help menu, I searched for the Gen Business Posting group and simply added the missing Codes (EU and EXPORT).

Once these values were added to NAV, my G/L Account import was successful.

080816 1945 KBArticleTh2

080816 1945 KBArticleTh3

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.