Scales(?) - based on cummualitve quantity of all items

[csaba_szommer]

Hi All,

Do you have any idea how to solve it, if possible with standard settings:

Conditions:

material1

0-10 pallet 10 EUR/pallet

11-20 pallet 9 EUR/pallet

21-30 pallet 8 EUR/pallet

31-40 pallet 7 EUR/pallet

material2

0-15 pallet 5 EUR/pallet

16-30 pallet 4 EUR/pallet

31-45- pallet 3 EUR/pallet

material3

1-20 pallet 15 EUR/pallet

21-40 pallet 14 EUR/pallet

41-60 pallet 13 EUR/pallet

Sales order with not proper price:

material1 11 pallet -> 9 EUR/pallet

material2 10 pallet --> 5 EUR/pallet

material3 13 pallet --> 15 EUR/pallet

But total quantity is 34 pallet (31=111013), and system should apply this total quantity when determing price:

Sales order with proper price:

material1 11 pallet -> 7 EUR/pallet

material2 10 pallet --> 3 EUR/pallet

material3 13 pallet --> 14 EUR/pallet

Thanks in advance,

Csaba

My colleauge helped me: we can solve it via group conditions.

Edited by: Csaba Szommer on Mar 25, 2010 10:54 AM

-

---

In SAP online help I can read:

http://help.sap.com/saphelp_erp60_sp/helpdata/en/1c/8c8b518d8c11d199a30000e8a5bd28/frameset.htm

You must mark the condition type as a group condition in Customizing
If you want the system to carry out cumulation across all items, but to read a separate condition record with this cumulated quantity for each item, you must make the following additional entries for the condition type:
Quantity unit for cumulation 
Group key number

How can I enter the group key number for the condition type???*

Please help, thanks,

Csaba

Edited by: Csaba Szommer on Mar 25, 2010 4:20 PM

Edited by: Csaba Szommer on Mar 25, 2010 4:22 PM

Ok, it is "GrpCond routine" (V_T685A-GRLNR).

Edited by: Csaba Szommer on Mar 25, 2010 4:55 PM

[Former Member]

In the condition type definition, select the Group condition formula 1.

condition class B - Prices and calculation Type C - Quantity.

Scale bases : Quantity Scale

Check Value A Ascending.

Try these settings and check if it works.

Regards

Sai