Update custom fields on Sales Order from enum selection

(4) Share

Report

Posted on by MJ-27012000-0

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

All responses (6)

Answers (1)

Verified answer

MJ-27012000-0 75 on at

Like (3)

Report

Update custom fields on Sales Order from enum selection

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...
Suggested answer

Sohail Ahmed 4,844 on at

Like (2)

Report

Update custom fields on Sales Order from enum selection

Just use the trigger OnValidate in the field

✅ Mark this answer as verified if it helps you.
MJ-27012000-0 75 on at

Like (2)

Report

Update custom fields on Sales Order from enum selection

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;

}
Suggested answer

Ramesh Kumar 5,520 on at

Like (2)

Report

Update custom fields on Sales Order from enum selection

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.
Suggested answer

RockwithNav 7,288 on at

Like (2)

Report

Update custom fields on Sales Order from enum selection

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/
MJ-27012000-0 75 on at

Like (3)

Report

Update custom fields on Sales Order from enum selection

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

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