This query i am posting again, as there is a need from my client for this regularly.
I need your expertise for meeting out this functionality.
Pl findherwith the following sceario.
I had created a Scheduling agreement for 5000 units with the following quanity discounts
1000 - Rs. 10
2000 - Rs. 08
5000 - Rs. 05
The quantity discount is maintained through Scales.
After that i had maintained delivery schedules like this Say
1 st day 1000 units
2 nd day 1000 units
3 rd day 2000 units.
My requirement is , when i am trying to do MIRO for the first line item,
I should get the value as 1000 units * Rs. 10 = Rs.10000
For 2 nd line item
Value = Rs. 1000 units * Rs. 08 = Rs. 8000
( since the quantity of line item had exceeded 1000 units and sum of line item 1 & 2 is equal to 2000 for which the rate is Rs. 08)
So i should be able to post the invoice at Rs. 8000 instead of Rs. 10000.
Pl suggest with your valuable solutions.