Inventory item ranges

[SpeedBWild]

Does GP have the ability to set ranges for example: we sell a product and based on the quantity the pricing is different. Is it possible in GP to set that up so when an order is entered and the quantity falls within a range that it calculates the correct price?

 

[Luvsql]

Yes. In the price list maintenace window (open item then go to price list), you can specify qty breakdown ie currency Z-C$, unit of measure EACH from 1 to 10, price is $100 (if price method is currency amount) or 95% of list (if percentage of list). Then next line could be 11-20, $95 or 90% of list etc.

 

[jazgeek]

not the nicest way of doing it. I believe horizons

http://www.hzs.com

had something called Item Pricing Matrix.



-----------
and they wonder why they call it Great Pains!

jaz

 

[winthropdc]

You can also look at Omni Price, which uses a filtering system with intra-range selection. Check out the products page of

http://www.winthropdc.com

for more information or a free trial.

Jennifer Musgrave
Winthrop Dexterity Consultants
The Home of Omni Tools and Omni Price
mailto:info@nospam-winthropdc.com

http://www.winthropdc.com

 

[stef315]

The limitation of the Great Plains built-in pricing break points is that it's really only a price level. This price is then set for the entire quantity on that line. So, let's say you set up that 1-50 items is $2 and 51-999999 items is $1. If you sell 50 items the price is 50 x $2 = $100. If you sell 51 items the price is 51 x $1 = $51.

This works fine in some senarios but not in others. The other products out there allow you to setup tiered pricing. So, in the above example, if you sold 51 items the price would be (50 x $2) + (1 x $1) = $101. Can be a big difference.

I've never used Horizons or Omni Price but I've used similar setups with utility billing.