Skip to Content
0
Mar 16, 2007 at 05:10 AM

Scales in Scheduling agreement.

13 Views

Hi,

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.

Hi,

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.

Regards,

R. Dillibabu.