web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Pages Not Editable with Custom Table and Source Table?

(0) ShareShare
ReportReport
Posted on by 607

Hi All,

When i associate a page with standard table , the page is editable and i can enter values in the fields on that page and all the fields are editable, but when i create a page with a custom table which i created , the page is Non-Editable as i am not able to enter values in the fields of the page.

The Edit List option in the Manage group in the Action bar of the page is non-editable.

pastedimage1574944871786v1.png

What should i do to change the values in the page? Please help!!!

Code for the custom table :

table 5**** Wfs_CreatePurchOrderStaggTable
{
    DataClassification = ToBeClassified;
    TableType = Normal;
    fields
    {
        field(1; Vendor; Integer)
        {
            Editable = true;
            Caption = 'Vendor';
            DataClassification = ToBeClassified;
        }
        field(2; Name; Text[20])
        {
            Caption = 'Text';
            DataClassification = ToBeClassified;
        }
        field(3; "No."; Code[20])
        {
            Caption = 'No.';
            DataClassification = ToBeClassified;
        }
        field(4; Descripion; Text[50])
        {
            Caption = 'Description';
            DataClassification = ToBeClassified;
        }
        field(5; Quantity; Integer)
        {
            Caption = 'Quantity';
            DataClassification = ToBeClassified;
        }
        field(6; "Unit of Measure"; Code[20])
        {
            Caption = 'Unit of Measure';
            DataClassification = ToBeClassified;
        }
    }



    var
        myInt: Integer;

    trigger OnInsert()
    begin

    end;

    trigger OnModify()
    begin

    end;

    trigger OnDelete()
    begin

    end;

    trigger OnRename()
    begin

    end;

}

Code for the page : 

page 50*** Wfs_CreatePurchOrderPage
{
    PageType = List;
    ApplicationArea = All;
    UsageCategory = Lists;
    SourceTable = Wfs_CreatePurchOrderStaggTable;
    Editable = true;
  

    layout
    {
        area(Content)
        {
            group(General)
            {
                field(Vendor; Vendor)
                {
                    ApplicationArea = All;
                    TableRelation = Vendor;
                    trigger OnValidate()
                    var
                        myInt: Integer;
                        VendorRecord: Record Vendor;
                    begin
                        if VendorRecord.Get(Namethen
                            Name := VendorRecord.Name
                        else
                            Name := '';
                    end;
                }
                field(Name; Name)
                {
                    ApplicationArea = All;
                    Editable = false;
                }
            }
            repeater(GroupName)
            {
                field("No."; "No.")
                {
                    ApplicationArea = All;
                }
                field(Descripion; Descripion)
                {
                    ApplicationArea = All;
                }
                field(Quantity; Quantity)
                {
                    ApplicationArea = All;
                }
                field("Unit of Measure"; "Unit of Measure")
                {
                    ApplicationArea = All;
                }
            }
        }

    }

    actions
    {
        area(Processing)
        {
            action("Create Purchase Order")
            {
                ApplicationArea = All;

                trigger OnAction();
                begin
                    Message('Hi');
                end;
            }
        }
    }
}

Thanks in Advance!:)

I have the same question (0)
  • Suggested answer
    Abhinav Mehra Profile Picture
    on at

    Hi,

    Define UsageCategory = Administration; in Page property.

    Thanks & Regards,

    Abhinav Mehra

  • AXBOY Profile Picture
    607 on at

    Tried, but stil the same output. Niether the +New nor any options in Manage Group in Working to make the fields in the page Editable.

  • Suggested answer
    Abhinav Mehra Profile Picture
    on at

    I tried your same code. It is working fine.

    pastedimage1574946508170v1.png

  • AXBOY Profile Picture
    607 on at

    Your Edit List Option is working? Also you ran the app by setting the Startup Object ID with that of this page right?

  • Abhinav Mehra Profile Picture
    on at

    Yes , i created as custom table & custom page same as yours. It is working fine with +New & Edit list options.

    Thanks & Regards,

    Abhinav Mehra

  • AXBOY Profile Picture
    607 on at

    Hmm..that's strange..is there any special extensions I should look for? Already downloaded Al extensions and Vs code icons

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,362

#2
YUN ZHU Profile Picture

YUN ZHU 867 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans