Small and medium business | Business Central, N...

how to find table or page extends from which table or page

(0) Share

Report

Posted on by Suvarna

Hello,

I am new for development in Business Central. How to find which table extends to which table and even for pages. Like which page extends to which page.

For ex. Table Requisition Line extends which table? How to check this or find this in business central?

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

First analysis which table you want to extend and follow the below link How to extend

docs.microsoft.com/.../devenv-table-ext-object

Below is link to extend the current standard or custom page.

docs.microsoft.com/.../devenv-page-ext-object

For Requisition Line table id 246

Thanks.

Was this reply helpful? Yes No
Suvarna on at

Like (0)

Report

Hi Nitin,

Thanks for your reply !

tableextension 50115 RetailWinterSportsStore extends Customer

for ex. tableextension 246 Requisition Line extens ?? --- I want to know here ? what will come? How to find or check?

{

fields

{

field(50116;ShoeSize;Integer)

{

trigger OnValidate();

begin

if (rec.ShoeSize < 0) then

begin

message('Shoe size not valid: %1', rec.ShoeSize);

end;

end;

}

}

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

Just replace with your Customer table with Requisition Line

Thanks.

Was this reply helpful? Yes No
Suggested answer

Mahesh U 433 on at

Like (0)

Report

Hi Suvarna,

Requisition line itself is a standard table. By default it is not extended by any table.

If you want to add the new field in the table 246 then you need to extend the table 246.

For the reference follow below documentaion from Microsoft docs.

docs.microsoft.com/.../devenv-table-ext-object

Or

If you want to check the specific page or table having any extension then go to web client and use ctrl + Alt + F1 to see the Page inspection. Under extensions tab you can see the extensions related to that page.

Please see if it helps.

Regards,

Mahesh U.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

You can also use page inspection CTRL+ALT+F1 in any page to find out what table is the source of the page and it shows both the page and table number together with their names. That is an easy way to figure out what table and page you need to extend.

Was this reply helpful? Yes No
Suvarna on at

Like (0)

Report

Hi Nitin,

Thanks for your reply.

pageextension 50101 PurchOrderfromSalesOrder extends "......." ===== What will come?

{

layout

{

modify("Vendor Invoice No") ====== This field is created in table RequisitionLine. How to fetch it on this form?

{

ApplicationArea = All;

}

}

}

Was this reply helpful? Yes No