cancel
Showing results for 
Search instead for 
Did you mean: 

Distribute Partial Payment in Sales Invoice with multiple item lines

former_member230865
Participant
0 Kudos

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.

ItemLinetotal
1500
2500
3500
4500
5500
6500
7500

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member205840
Active Contributor
0 Kudos

Hi Norman,

Is that 500 is fixed amount ?  you said payment 2300, If I distribute 328.57, then I can take part payment in all business lines ?

or

If that amount is fixed then, divide payment amount with fixed amount(500) 2300/500 -- it will be 4.6 so, take int part of it and distribute the amount for first 4 business lines and remaining will go in 5th business line.


Thanks,

Sastry

Former Member
0 Kudos

Hi Norman,

I would like to know why you want to do so?

Also for what industry you are processing in this manner?

regards,

Ravi.