Discount in pricing

[Former Member]

Hi All,

We have a requirement of giving a discount to customer based on the total

amount invoiced so far (across financial years).

Where do we set this up? We have seen so far the discounts are calculated

based on the value of the current invoice.

The discount should be on a graduated scale basis for example

0 - 100000 No discount

100000 - 200000 5%

200000 - and above 10%

This means that discount would only start after the customer's net sale

value crosses 100000.

For example, if the customer has been billed for 99000 and the current

invoice is for 3000, a discount of 5% should be given on 2000 i.e. 100.

Another complication is that, the discount is not based on the total amount

billed so far, but only on the effort billed and not on reimbursements (like

airfares, living expenses, visa charges, beeper charges etc). The discount

applies only to the effort and not to the reimbursements. In the above

example (invoice of 3000) say the effort billed is only 1500, the rest being

reimbursements. The discount is only on the 500. (the rest being taken up by

the lower limit for eligibility of 100000)

For example the customer might have been billed say 150000 so far but actual

effort billed might be only 90000, the rest being reimbursements of actual

costs and hence the customer is not eligible for the discount.

Kindly help,

[Former Member]

Hi there,

To track the customer invoice amount paid, you need to have a customized Z table which updates as & when the customer makes a payment to the previous invoices. In the pricing procedure, in the requirement routine for the condition type, write a customized code. The code shoulld call the Z-table & read the value.

Basing on the value it should apply the scale value of the condition records.

In the condition type, define the scale value. Donot select check scale sothat you can maintain condition record such that if value is 10-100 discount 10%, 100-500, 20%.

Make sure you mainatin the condition record based on value scales.

Regards,

Sivanand

[Former Member]

hi

use scale type - D graduated-to interval scale. for your condition and maintain

Maintain scale type D in your condition type.

Note : You can't maintain scale type D in condition records.