Split one row in two or more

Hi Family,

I have a Sales table with a column of terms payments, as you can see below:

o 50 * SD * 10 means that the calculated DueDate is equal to “Ship Date” + 10 and that the amount to be paid is 50% of the amount of the line

o 50 * SD * 60 means that the calculated DueDate is equal to " Ship Date " + 60 and that the amount to be paid is 50% of the amount of the line

So if I have a purchase of $ 150,000 with this payment term and a " Ship Date " = 2021-06-01, we should find in the model of two purchases

• $ 75,000 payable on 2021-06-11 (50% 10 days later than Ship Date)
• $ 75,000 payable on 2021-07-30 (50% 60 days later than Ship Date)

Importantly, the original line of $ 150,000 should no longer be there or no longer counted. We could keep it by changing the amount payable to $ 0, so nothing to pay.

My question is, how can I split the original row in two (or more in another case)?  

Thank you all 

aj1973 
Anonymous