When prices are sorted in the Price Book app they are sorted based on unit prices. Furthermore the unit prices are sorted based on the following unit groups:
1) Weight - (e.g. pound, kilogram, weight ounce)
2) Length - (e.g. foot, inch, cm)
3) Area - (e.g. sq ft, sq m)
4) Volume (fluids) - (e.g. liter, gallon, cup, fluid ounce, pint, quart)
Everything else (such as each, carton, bundle, etc), currently doesn't get sorted per unit price.
Within a unit group, each unit price is recast into the unit that is the smallest for that group of prices for an item, and then the unit prices are sorted based on that smallest unit. For example, for a group of prices, for an item, that are listed in the units: "gallon, pint, quart", a pint is the smallest unit in this group and so all of the prices per unit will be recast into price per pint, and then sorted.
For example, for the following prices, A), B), C):
A) $8 for 1 gallon = $1 for 1 pint
B) $4 for 1 pint = $4 for 1 pint
C) $4 for 1 quart = $2 for 1 pint
So these prices would be sorted with the smallest first as:
A)
C)
B)
Last edited: Fri, 16 Sep 2011, 08:21am by admin