How to Modify[Extends] Standard existing Table Relation in Business central Using AL [Cloud Version]

Business Central/NAV Technical Forum
1

Hi All,

I want to Modify the table relation of the “Requisition Line” [246] table for Field “No.”.

the Standard table relation For “No.” The field is as below

IF (Type = CONST(“G/L Account”)) “G/L Account”
ELSE
IF (Type = CONST(Item),
“Worksheet Template Name” = FILTER(<> ‘’),
“Journal Batch Name” = FILTER(<> ‘’)) Item WHERE(Type = CONST(Inventory))
ELSE
IF (Type = CONST(Item),
“Worksheet Template Name” = CONST(’’),
“Journal Batch Name” = CONST(’’)) Item;

And I want to Modify below as using a table extension

IF (Type = CONST(“G/L Account”)) “G/L Account”
ELSE
IF (Type = CONST(Item),
“Worksheet Template Name” = FILTER(<> ‘’),
“Journal Batch Name” = FILTER(<> ‘’)) Item WHERE(Type = CONST(Inventory), “Item Category Code” = const(‘FURNITURE’****))
ELSE
IF (Type = CONST(Item),
“Worksheet Template Name” = CONST(’’),
“Journal Batch Name” = CONST(’’)) Item;

Is it Possible the modify the standard table relation using table extension?

Thanks in Advanced.

2

You can not modify the Table relation of Standard Tables in BC Cloud Version. The reason is by changing the table relation it breaks the other extension that are depend of the (Base App).

To achieve your requirement, You can create new “Table Extension” and create new field in that extension and set the Table relation and use your newly created customized field in your extension. By this you can fulfill your requirement and also not break the other extensions that are depend on (Base App).