We do this with PO’s all the time.
If you have a 1/2 30 days 1/2 60 days type of invoice.
We invoice half the merchandise with the 30days terms and the other half at the 60days terms.
When I mean half I actually mean half so if we order 144 pcs of 10 items we invoice 72 pcs of the 10 items at one term and the remaining 72 at the other term.
Sometimes it can be alot of items and a pain manually so I made a function
It checks for rounding too and lets you know if there is an odd split:
IF NOT DIALOG.CONFIRM(‘Would you like to split the invoice?’,TRUE)
THEN EXIT
ELSE
Purchline.RESET;
Purchline.SETRANGE(Purchline.“Document Type”,“Document Type”);
Purchline.SETRANGE(Purchline.“Document No.”,“No.”);
IF Purchline.FIND(’-’) THEN
REPEAT
IF Purchline.“Quantity Received” <>0 THEN BEGIN
Purchline.“Qty. to Invoice” := (Purchline.“Quantity Received” / 2);
Remainder := Purchline.“Quantity Received” MOD 2;
IF Remainder <> 0 THEN MESSAGE(‘Item %1 Needs Rounding’,Purchline.“No.”);
Purchline.VALIDATE(“Qty. to Invoice”);
Purchline.MODIFY;
END;
UNTIL Purchline.NEXT = 0;
I would assume sales orders could work the same way