Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Changing Custom Field Value on change if Reserve quantity has value

Posted on by 221
Dear Experts 
 
I want change custom field value based on the Reseve Quantity on Sales order at line Level when Reserve quantity has value then custom option field in line level should have value as EX STOCK 
 
as field is flow filed code not work on on validate and on lookup of reserve quantity field 
 modify(/Reserved Quantity/)
        {
            trigger OnAfterValidate()
            begin
                Rec.CalcFields(/Reserved Quantity/);
                if Rec./Reserved Quantity/ <> 0 then
                    Rec./Stock Type/ := /Stock Type/::/Ex Stock/;
 
            end;
        }
How i can achieve same thanks in advance 
 
Categories:
  • DineshM Profile Picture
    DineshM 221 on at
    Changing Custom Field Value on change if Reserve quantity has value
    @YUN ZHU sir 
    I am not able to get how to achive same can you please explain how i can do same. not geeting how to do it.
     
     
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 68,842 Super User 2024 Season 2 on at
    Changing Custom Field Value on change if Reserve quantity has value
    Hi, as you might know, flowfields do not trigger onModify event. But FlowFields are calculated based on information in another table. You can update fields in your table when other tables meet the conditions.
     
    Hope this can give you some hints.
    Thanks.
    ZHU
     

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,353 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,251 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans