News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Split PO Line Into Two

Business Central forum

Unanswered

Split PO Line Into Two

(0) Share

Report

Report

Posted on by CU27081143-0

8

Hi all,

previously i asked One question related Split Po line into Two line..

I splited line into two line .. but what my question is how to handle line no for more than one original Po line record .. & how to split it ?

here i paste my code ..

anyone correct my code.

thanks In Advance ..

Categories:

Business Central

All responses Img

All responses (1)

Answers Img

Answers (0)

Netjacker2097 256 on at

Like (0)

Report

Split PO Line Into Two

hi,

please try this:

SplitQty := ABS(Rec."Quantity Received") / 2;
IF SplitQty > 0 THEN BEGIN
Rec.LOCKTABLE;

WHILE (Rec."Quantity Received" > 0) DO BEGIN
Newpurchaseline.INIT;
Newpurchaseline.TRANSFERFIELDS(Rec);

Newpurchaseline."Line No." := Rec."Line No." + (10000 * SplitCounter);
Newpurchaseline."Quantity Received" := MIN(SplitQty, Rec."Quantity Received");

Rec."Quantity Received" -= Newpurchaseline."Quantity Received";

Newpurchaseline.INSERT;

SplitCounter += 1;
END;

MESSAGE('Split Line Complete');
END;

Thanks,

M

Helpful resources

News and Announcements

Forum Structure Changes Coming on 11/8

Give Back to the Community this Month

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 229,247 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans