How to sum up billing documents and provide scale based discounts

[samjalees2000]

Dear Gurus,

Here is the client's requirement:

Actually the client requires that after two weeks some of the customers are given discount based on the total quantity or value been sale.

Invoice list seems a great option but issue is that its sums up the factor discount from all the billing documents.Although,the client requires that after the toal quntity or value been taken from the billing docuements a scale is applied at the level of invoice list.For example

billing 1  value 10,000 discount 3 %   = 300

billing  2 value  1,000  discount 3%    =30

system response:

invoice list  value 1100 discount =330

client requirement

invoice list value 1100

scale  :  if value <= 500  discount 3%

             if value >500 && value<2000  discount 4%

required value : invoice value 1100 discount 400

Kindly help , if there some better option availble in invoice lists or any other solution you may come up or suggest.

Regards,

Sam Ahmed

[former_member186940]

Hello,

you can create a discount condition type and add access sequence to it. If your client does not have access sequence as per your requirement create one with copying a standard access sequence for discounts.

you can create a separate table to fulfill changes so that access could be made.

regards,

amol marathe

[Former Member]

I guess you need to create 2-3 different condition types and assign routine to them, only to display this condition type if sum of all invoice for customer.

Condition type ABCD - routine should say should get calculated only if sum of all invoices in last 15 days is < = 500.

then maintain condition record of 3%