Field Validation not working in business central

(1) Share

Report

Posted on by Test user

321

Hi Guys,

I am facing one query . i.e.

For e.g. I have one field Req.Delivery Date on sales header.& same field on sales line. once i enter data into header field it will automatically populate into sales line field.

I have write this code. code is right as per my assuption, but it is not working.

Once i select the new line ,then it will not updating that value.i want to update this field

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

YUN ZHU 98,859 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

This is because your code only exists in the OnValidate trigger of Req.Delivery Date field. When you add new Sales Line, the trigger of this field is not executed.

I think you need to add similar logic in the Sales Line's OnInsert (Table) Trigger. This should solve the problem.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Judy Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Sir,

It is high recommended that you can troubleshoot in the AL code to identify the root cause of the issue, you can set up break points in the specific lines.

Debugging - Business Central | Microsoft Learn

Best Regards,

Judy

Was this reply helpful? Yes No
Test user 321 on at

Like (0)

Report
Copy link

Link copied!

Hi Yunzhu,

I have write the same logic on insert trigger on sales line table, but still is not working. Is any other way to do this?

Was this reply helpful? Yes No
Suggested answer

Robert Jolliffe 890 on at

Like (0)

Report
Copy link

Link copied!

This looks wrong

Should be Rec_SalesLine."Req.Delivery Date" as "Req. Delivery Date" is referring to Rec."Req. Delivery Date"

I think you're setting the header to itself.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,202 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

can you share the oninsert code?

Was this reply helpful? Yes No
Test user 321 on at

Like (0)

Report
Copy link

Link copied!

Hi Mohana,

This is the code i have written on insert trigger on sales line table.

Was this reply helpful? Yes No
Suggested answer

DevZubair 4 on at

Like (0)

Report
Copy link

Link copied!

use this code on onInsert trigger of sales Line Table and then execute

trigger OnInsert()
var
SalesHeader: Record "Sales Header";
begin
SalesHeader.Get("Document Type", "Document No.");
"My Field" := SalesHeader."My Field";
end;

Was this reply helpful? Yes No