# Quantity Discounts

## Recommended Posts

We have an FM5.5 file we enter customer orders in. We want to improve its effeciency by being able to enter a number in the quantity ordered field and get the corresponding quantity discount price looked up from the product file. There may be 4 or five price levels based on quantity ordered. I can't figure out how to get the correct price into the customer order file from the product info file.

##### Share on other sites

Hmmm this is a tough one. It might be better done with a script. Either way, map out the steps you'd do to perform the same task.

##### Share on other sites

If all of the products have the same quantity break point, you could include in the product file a set of prices for the quantity discounts and do a Lookup to find the discount price. Each product could have a different price, but all products would have to break at the same quantity, i.e. 1-25, 25-50, 50-75, 100>, etc. Then it would be an easy matter of Looking up the price with this calcuation:

Case(Quantity >= 25 and Quantity < 50,ProductList: : price2,

Quantity >= 50 and Quantity < 75,ProductList: : price3,

Quantity >= 75 and Quantity < 100,ProductList: : price4,

Quantity >= 100,ProductList: : price5,Price1)

[The last price1 will catch anything that doesn't match the other quantities]

[ November 30, 2001: Message edited by: dykstrl ]

[ November 30, 2001: Message edited by: dykstrl ]

[ November 30, 2001: Message edited by: dykstrl ]

##### Share on other sites

quote:

Originally posted by dykstrl:

Case(Quantity >= 25 and Quantity < 50,ProductList: : price2,

Quantity >= 50 and Quantity < 75,ProductList: : price3,

Quantity >= 75 and Quantity < 100,ProductList: : price4,

Quantity >= 100,ProductList: : price5,Price1)

[The last price1 will catch anything that doesn't match the other quantities]

This is the approach I would take; you can simplify this calc even further by taking advantage of the fact that Case() will return the first "true" result:

Case(Quantity < 50,ProductList: : price2,

Quantity < 75,ProductList: : price3,

Quantity < 100,ProductList: : price4,

ProductList: : price5)

##### Share on other sites

You can take this a step further. If each product has different price break points, you can store those quantities in the product file along with the prices and use this calculation

case(

qty<Products::BreakQty1,Products::Price1,

qty<Products::BreakQty2,Products::Price2,

qty<Products::BreakQty3,Products::Price3,

Products::Price4)

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×

• ### Who Viewed the Topic

1 member has viewed this topic:
Christoph
×
×
• Create New...