Skip to Content
avatar image
Former Member

Price scales by total amount in sales order

Hi gurus,

I have a requiremente, and is to have a price with scales based on the total amount of the sales order.

For example i have a sales order with

Material A      1 Palet

Material B      2 Palet

Material C      4 Palet

Total Amount = 7 Palet

The prices are:

                       0-2 Palet   2-7 Palet     More than 8 Palet

Material A          10$             8$                    6$

Material B           9$               7,5$               4$

Material C           8$               5$                    3$

So for this sales order price are material A: 8$, material B: 7,5$ and material C: 5$.

I know that using "material pricing group" i can have the same price for the total amount of a group of material. But amount for all the material but different price is posible?

Best Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 12, 2015 at 07:53 PM

    Hi Luis,

    have you tried changing 'Scale Basis' to 'G - Scale based on a formula' in V/06?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      If i change it, it will apply to all the price schema that contains this condition price, isnt it?

      I want that for the rest of the material, scale basis keep being "Quantity scale"

  • Feb 12, 2015 at 08:16 PM

    Hi Luis ;

    The mixed pallet discount accumulates the quantities of the individual items in an order and calculates the discount for complete pallets only. This is controlled by condition type KP02 and the corresponding condition record.

    Can you try condition type KP02 ?

    2a.JPG (79.6 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      If i am not missunderstanding, this is a discount for pallets. What i need is a price determined by the total amount of pallets of the sales order.

  • avatar image
    Former Member
    Feb 12, 2015 at 09:07 PM

    There are 2 options to look at -

    1. Using Grouping routine – if Mat A & Mat B & Mat C cannot be grouped using pre-defined group keys, a new group key should be defined (group routine).
    2. Using Scale formulae – new scale formulae can be defined and the scale basis can be determined programmatically. Once you determine the scale value, condition value will be calculated by system.

    Both need help from developers and involves some development activity.

    Add comment
    10|10000 characters needed characters exceeded