Distribute Partial Payment in Sales Invoice with multiple item lines

Hi Experts,

Newbie here, i am creating reports on Sales Invoice that has partial payment. What we want to do is distribute the amount of the partial payments base on the item lines.

Example.

Item Linetotal 1 500 2 500 3 500 4 500 5 500 6 500 7 500

Invoice Total: 35000

Partial Payment 2300

The partial payment should be applied base one the line item number.

So the item 1,2,3,4 for should be paid and 5 has balance of 200 and same as item 6 and 7.

By the way, i am using SAP HANA.

Thank you.

Norman