Advanced Pricing - EBS (MOSC)

MOSC Banner

Item Selling Price fetch on total Order Quantity for Same Product

edited Nov 26, 2017 10:11PM in Advanced Pricing - EBS (MOSC) 2 commentsAnswered ✓

Hi All,

we have following requirement Customer order total quantity of item ABC 1000 nos.

business enter 1000 qty in following manner:

Line        Product      Quantity       Unit Selling Price                                   Price List Price break criteria           

1.1          ABC            100              10$                                                        0-200     = 10$

1.2          ABC            200              10$                                                        200-300 =  8$

1.3          ABC            300               8$                                                         300-999999 =  6$ <<<<<<

1.4          ABC            400               6$                            

                       Total= 1000

when Order Total Quantity reach to 1000 nos total order quantity final selling Price for each line should be 6$

Line        Product      Quantity       Final Unit selling Price when order reach to 1000 Qty

1.1          ABC            100                  6$

1.2          ABC            200                  6$

1.3          ABC            300                  6$

1.4          ABC            400                  6$

final order quantity should applied to all previous lines irrespective to Price break.

can we change price break logic of item qty range to total order sum quantity. or any other way to achieve it?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center