Business Central TableRelation to "Product Group"."Item Category Code" after its removal

(4) Share

Report

Posted on by TAHER_El_Mehdi

1,981

Hi everyone,

During a migration from NAV to Microsoft Dynamics 365 Business Central, I encountered a field defined as follows:

field(2; Description; Code[30])
{
    TableRelation = "Product Group"."Item Category Code";
}

As the Product Group table has been removed in Business Central (v15+), I’m unsure how to correctly replace this TableRelation.

From my understanding, this relation was effectively allowing selection of Item Category Codes, but only those that existed in the Product Group table.

Would replacing it with the following be correct?

TableRelation = "Item Category".Code;

Or is there a better approach to preserve the original filtering behavior?

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central migration

Microsoft Dynamics NAV

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

OussamaSabbouh 17,608 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hello,

Yes, TableRelation = "Item Category".Code; is usually the correct replacement, because Microsoft replaced the old Product Group concept with the newer Item Category structure, so the closest BC equivalent is the Item Category table; however, it is not 100% the same behavior, because the old relation was indirectly validating against records in Product Group using "Item Category Code", while the new one validates directly against all item categories. If you must preserve the old behavior exactly, you need to migrate the old product-group logic into a custom table/field or add a filtering rule that matches how those old product groups were converted; otherwise, for normal NAV-to-BC modernization, relate directly to "Item Category".Code and clean/migrate the old values into valid item categories.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No