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

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.

Parents
No Data
Reply
  • 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).

Children
No Data
Related
Recommended