Field Validation not working in business central

(1) Share

Report

Posted on by Test user

305

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 95,761 Super User 2025 Season 2 on at

Like (0)

Report

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

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 305 on at

Like (0)

Report

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 885 on at

Like (0)

Report

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,005 Super User 2025 Season 2 on at

Like (0)

Report

can you share the oninsert code?

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

Like (0)

Report

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

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