Cumulative values

[Former Member]

Hi Experts,

I have a requirement to have Scales for cumulative values of a condition type.

Ex. If the customer buys 100 MT in the month of March he is eligible for Rs. 5 Per MT discount

If the customer buys 200 MT in the month of March he is eligible for Rs. 7 Per MT discount

If the customer buys 300 MT in the month of March he is eligible for Rs. 10 Per MT discount

as our normal scales will work for individual sales orders.. but i want to apply above said scale for the whole cumulative quantity in a given period of time.

Thanks in advance

Sree

[Former Member]

It is possible thru Rebates. you need to specify scales in Rebate condition record in VBO1.

[Former Member]

Hi

I had requirements that is very similar to what was stated and I understand that customer does not like end of month credit memo solutions because it hits their cash flow. The way I have solve the problem is this ( mind you there is some ABAP coding required, if you absolutely will not entertain this then you are SOL I think):

1. First, to collect sales order statistics, create an info structure in SIS where your characterisctics will likely be sales org, customer, material plus whatever criteria needed. Key figure will be order qty and whatever else that is needed. Also complete the associated upate rules for info structure. Time period is calendar month. Once activated, every sales order created or change will update the infostructure automatically.

2. This is the ABAP part comes in, create a scale base routine via transaction VOFM. The code in the scale base routine is pretty straight forward, do a select againt the info structrue table SXXX using and extract the order qty value and return it to pricng procedure via XKWERT

3. Change your condition type scale base formula assignment to the routine number create above. Add price condition to your standard pricing proceure.

This is the config/developement you need. Last thing you need to do before using it for real is to load the info structure with existing orders via tranaction OLI7.

From then on, discount base on month to date qty will appear on your order pricing screen.

Frank

[Former Member]

Hi,

When you are copying the data from existing info structure to your new info structure SXXX, data will be copied but it will not copied as per the format you have mentioned in new structure SXXX. It will copy teh data as per the format you have taken referenc strucutre.

How you are managing this situvation.

Example: You have created info structure for SXXX to display order wise details. In OLI7 you have given customwer analysis reference structure. The data in your ifno structure will not copied as per sales order wise. It will copy based on customer analysis format.

Thansk & Regards

[Former Member]

URK:

The transaction to do copying from one info structure to another you mentioned is OLIX not OLI7. What OLI7 lieterially is "SIS statistical setup for sales orders" . It is expresedly created to load sales order information into SXXX that you create.

Frank

[Former Member]

Hi Sridhar

I agree with Marcin,You should use Rebate agreements . Use material rebates with validity period .you can create condition group for material rebates. and set your validity period to month or year. and maintain access sequence and condition table based on material /customer.

Add subtotal to pricing for monthend settlement purpose.

Try it and revert if u have any specific problems

Regards

Mandar

[Former Member]

Hi Sree,

As per your requirement, to give discount on monthly cumulative qunatity. What i can suggest you is:

1. At end of the month raise a credit memo for the customer with material quantity = summmation of all sales order quantity in that month.

2. Maintain Condition scales for condition type you want use in credit memo.

3. For summation of monthly sales orders qty, write code in sales oder user exit under MV45AFZZ.

Suppose you have created 4 orders in one month with qty 100, 150, 250, and 300 respectively.

At end of the month create a credit memo (manually or through background schedule) with qty = 800. Based on 800 your condiiton type in credit memo will determine value as 10. So credit memo's total value will become 800*10 = 8000.

try and revert.

[Former Member]

Thanks Yadav,

I wanted to have it in Standard procedure rather than using a Userexit.

are there are any other ways to solve it?

Sree

[marcin_milczynski]

Hi,

You could consider use of rebate agreements, however then it will be off-invoice discount istead of on-invoice discount. Rebate agreements provide functionallity whcih is required by you.

BR,

Marcin

[Former Member]

Hi Marcin,

Thank you for your reply, as you said we can have discount calculating off the invoice in rebates. But where can we maintain Scales for the rebates?

if we maintain scales for the rebate condition type will it calculate on cumulative quantity or the particular invoice quantity ?

Thanks in advance,

Sree

Edited by: Sridhar Raju E on Mar 26, 2010 8:21 AM