The field Gen. Bus. Posting Group of table G/L Account contains a value that cannot be found in the related table.
By Brady SwensonMonday, August 8, 2016
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).”
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.