How to have by default few fields copied from the previous line while creating a new line item

(0) Share

Report

Posted on by UserRecord

Hello!

I am trying to customize the Lines in Sales order and want to have a field value automatically populated as the previous line when I create a new Line in Lines page.

Any solutions? Thank you in advance.

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (1)

Sort by

Verified answer

DAnny3211 11,423 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

hi

try this

[EventSubscriber(ObjectType::Table, 37, 'OnAfterInsertEvent', '', false, false)]

local procedure SetYpurField(var Rec: Record "Sales Line")

var

SalesLine: record "Sales Line";

begin

SalesLine.Reset();

SalesLine.SetRange("Document Type",rec."Document Type");

SalesLine.SetRange("Document No.",rec."Document No.");

SalesLine.SetFilter("Line No.",'<>%1',Rec."Line No.");

if SalesLine.FindFirst() then

begin

rec.YOURFIELD:=SalesLine.YOURFIELD

rec.Modify();

end;

end;

check my answer if it helped you, thanks

DAniele
UserRecord 54 on at

Like (0)

Report
Copy link

Link copied!

With a few Modifications this works. Thank you.
Suggested answer

Manan_Shah 1,461 on at

Like (0)

Report
Copy link

Link copied!

Hi Bismeet.

In Base there is 1 more functionality I think that you can use.

Search for Item Template. On this you get all similar field which are on Item card.

What are the values you fill on this. it will flow on While creating a new Item.

Now click on New on Item Card it will ask for choose Item Template if you create multiple. Select the Item template and it will fill all the values on new Item card from Item template.

Hope this will help.

Many Thanks,
Manan