calculate the condition value

[Former Member]

Hi Experts

I have an Issue that "company agrees a discount of 15% with the particular customer,the agreement was made in 2004.but unfortunately customer found that he is getting only 5% and informs the company"

so i have to calculate the condition value for remainming 10% which is to be given to the customer from Jan 2004 to till date.

Regards

Ashwath reddy

[Former Member]

Ur discount condition validity would have been completed. so u need to maintain the discount agreement with the new validity period.

For the pending amount u need to settle it manually by changing the condition value.

[Former Member]

Hi,

Since discount % is calculated from Base Price (PR00), initially get all the list of invoices. Once u get the list take the condition value for all these invoices by passing in the condition record no (VBRK-KNUMV) in KONV table along with the condition type for the discount.

By the above step, you will have the condition type for all the invoices with 5% discount. Now w.r. to the base price calculate a new field which will calculate the discount for 15% and keep aside.

Finally, you can calculate the discount for the balance 10% by the formula: (Condition value of 15% - Condition value of 5%).

Explain this logic to your developer. This will work..

Regards,

JLN

[Former Member]

hello, friend.

many ways to do this. one of them as follows:

1. first, list all orders by this customer since 2004 by using VA05. alternately, you can list all billing documents within the same time period using VF05 or VF05N. if material is relevant for discount, you can use this in your search.

2. you can then process an invoice correction or credit memo request for these transactions.

of course, practicality of this approach depends on the volume of transaction with this customer.

hope this helped.

regards.