Update custom fields on Sales Order from enum selection

(4) Share

Report

Posted on by MJ-27012000-0

105

I have an Enum field on a Sales Order Page extension where the user will make a selection and when that selection is made, a lookup should find the corresponding record in a custom table and update fields in the Sales Order Extension with values from that record.

This is what I have but it does seem to like that I reference the enum field ADDRID and will be an error in future versions of BC.

Any suggestions?

Thanks!

           Group("Ship From Address")
            {
                field("ADDRID"; rec."ADDRID")
                {
                    ApplicationArea = All;
                    Caption = 'Address ID';
                    ToolTip = 'Select ADDRID';
                }
                field("Name"; rec."Name")
                {
                    ApplicationArea = All;
                    Caption = 'Name';
                    ToolTip = 'Enter Name';
                }
                field("Address"; rec."Address")
                {
                    ApplicationArea = All;
                    Caption = 'Street Address';
                    ToolTip = 'Enter Street Address';
                }
                field("City"; rec."City")
                {
                    ApplicationArea = All;
                    Caption = 'City';
                    ToolTip = 'Enter City';
                }
                field("State"; rec."State")
                {
                    ApplicationArea = All;
                    Caption = 'State';
                    ToolTip = 'Enter State';
                }
                field("Zip"; rec."Zip")
                {
                    ApplicationArea = All;
                    Caption = 'Zip Code';
                    ToolTip = 'Enter Zip Code';
                }
            }
        }
        modify("ADDRID")
        {
            AssistEdit = true;
            trigger OnAssistEdit()
            var
                AddrRec: Record FromAddresses;
                AddrList: Page "FromAddresses List";
            begin
                if Rec."ADDRID" = '' then begin
                    Message('ID cannot be blank.');
                    exit;
                end;
                SpecRec.SetRange("ADDRID", Rec."ADDRID");
            end;
        }        

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (1)

MJ-27012000-0 105 on at

Like (3)

Report

Actually I asked and got answered a similar question here...

Cannot move or modify the Field '' in the same 'PageExtension' that you added

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,637 Super User 2025 Season 2 on at

Like (2)

Report

For me your code is not getting in-lined with what you are trying to achieve. You should be writing your code on the OnValidate trigger of the enum field. Based on every selection write your code and then it will exactly behave the way you want it to.

Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (2)

Report

I hope this can help https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/enum/enum-data-type

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
MJ-27012000-0 105 on at

Like (2)

Report

Actually I had one thing incorrect but still no luck

field("ADDRID"; rec."ADDRID")

{

ApplicationArea = All;

Caption = 'Address ID';

ToolTip = 'Select ADDRID';

trigger OnValidate()

var

SH_ADDR: record "Sales Header";

begin

SH_ADDR.reset();

SH_ADDR.SetRange("ADDRID", rec."ADDRID");

If SH_ADDR.FindSet() then

repeat

//if SH_ADDR.ADDRID = rec.ADDRID then begin

SH_ADDR.Name := (rec."Name");

SH_ADDR.Address := (rec."Address");

SH_ADDR.City := (rec."City");

SH_ADDR.State := (rec."State");

SH_ADDR.Zip := (rec."Zip");

SH_ADDR.Modify(true);

CurrPage.Update();

//end;

until SH_ADDR.Next() = 0;

end;

}

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,150 Super User 2025 Season 2 on at

Like (2)

Report

Just use the trigger OnValidate in the field

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Verified answer

MJ-27012000-0 105 on at

Like (3)

Report

What ended up work was not using and enum field for the drop down. Did a TableRelation on the ADDRID field in the SalesOrderTableExtension to the table that contains the address records.

field(50134; "ADDRID"; Code[12])

{

DataClassification = ToBeClassified;

TableRelation = FromAddresses.ADDRID;

}

for the SalesOrderExtensionPage, used the following code...

field("ADDRID"; rec."ADDRID")

{

ApplicationArea = All;

Caption = 'Address ID';

ToolTip = 'Select ADDRID';

trigger OnValidate()

var

SH_ADDR: record "Fromaddresses";

begin

SH_ADDR.reset();

If SH_ADDR.get(rec.ADDRID) then begin

rec.Name := SH_ADDR.Name;

rec.Address := SH_ADDR."Address";

rec.City := SH_ADDR."City";

rec.State := SH_ADDR."State";

rec.Zip := SH_ADDR.Zip;

end;

end;

}

Thanks to all that assisted...

Was this reply helpful? Yes No