News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Split PO Line Into Two

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

Suggested answer

Split PO Line Into Two

(1) Share

Report

Report

Posted on by CU27081143-0

21

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:

Dynamics 365 Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 74,148 Super User 2024 Season 2 on at

Like (1)

Report

Split PO Line Into Two

This depends on the sorting method you need. If you want it to be sorted below this line, I think "Line No./2" would be better.

PS: Business Central Standard Error: The line cannot be split & There is not enough space to insert correction lines (AutoSplitKey Property)

https://yzhums.com/41714/

Hope this helps as well.

Thanks.

ZHU
Netjacker2097 263 on at

Like (1)

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

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,431 Super User 2024 Season 2

#2

Martin Dráb 230,503 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans