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

Why is my Codeunit to update PlanningLine dates failing?

(0) Share

Report

Posted on by Community Member

I've written the below codeunit with the goal of updating all Planning Line's "Planning Date" values whenever the related Jobs "Starting Date" value changes. Why is the Planning Date field not updating?

// Codeunit Source
codeunit 50102 UpdatePlanningLines
{
    procedure ByJobStartDate(Job: Record Job)

    begin
        PlanningLines.SetRange("Job No.", Job."No.");
        if PlanningLines.FindSet() then
            repeat
                Message('Looping task '   PlanningLines."Job Task No."   ' and setting Planning Date to '   Format(Job."Starting Date"));
                PlanningLines."Planning Date" := Job."Starting Date";
            until PlanningLines.next = 0;
    end;

    var
        PlanningLines: Record "Job Planning Line";
}

//On Job Card
modify("Starting Date")
{
    trigger OnAfterValidate()
    begin
        if Rec."Starting Date" <> 0D then begin
            UpdatePlanningLines.ByJobStartDate(Rec);
        end;
    end;
}

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 82,747 Super User 2025 Season 1 on at

Like (0)

Report

RE: Why is my Codeunit to update PlanningLine dates failing?

Hi, as Wolfind mentioned, you need to use Record.Modify([Boolean]) Method here.

In addition, if you are all modified to be the same date, please consider using the ModifyAll method, this will not require a loop

More details:

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-insert-modify-modifyall-delete-and-deleteall-methods

Hope this will help.

Thanks.

ZHU
Suggested answer

Community Member on at

Like (0)

Report

RE: Why is my Codeunit to update PlanningLine dates failing?

Solved it - Needed to finish off REPEAT iteration with:

PlanningLines.Modify();