Chapter 612 Qty Prices
Qty Prices is a feature you turn on to add quantity price breaks on sales transactions.
Qty Prices are a complete feature set you turn on to enable:
• Qty Prices tab on the Item card for entering Qty's and their Prices
• Export and Delete options in Qty Prices Search
• Import options for bulk updates to Qty Prices
Qty Prices
Qty Prices adds a Tab on Item Card for entering Quantity Prices, that is price breaks or discounts to the Item's Price when a higher Qty is entered on sales transactions.
To enable the Qty Pricing tab:
1. Go to the Item Prefs.
2. Click the checkbox, Use Item Price Tab
3. Click OK to save
To use Qty Pricing:
1. Go to an Item Card to the Pricing tab
2. Click Add to add a new row
3. Enter a Qty and Prices
4. Click OK to save
Entering a Qty on a Quote, Sales Order, or Invoice will use the matching price.
Qty Prices Import
Big Business 8.5.1 adds an Import for Item Pricing, for adding quantity price breaks or discounts, and the options to Export and Delete existing entries.
This solution describes using this feature. (6279)
To Import Item Pricing:
1. Go to the Maintenance toolbar to the Import tool
2. Open a Tab-Text file to import
3. Select Item Pricing (at the bottom of Import list)
4. Map the import fields (highlight and click Insert)
5. Click OK to Import
To create a Tab-Text file to import:
1. Create a new spreadsheet
2. Add columns for Item Code, Qty, and Prices
3. Save As... Tab-Text
To Export Item Pricing:
1. Go to Item Search and find Items
2. Hold Shift and Option/Alt keys
3. Click Export
To Delete Item Pricing:
1. Go to Item Search and find Items
2. Click Apply
3. Choose Item Pricing in the first pulldown and Delete will appear in the middle
4. Click OK to proceed
5. Choose Apply Changes in the confimation dialog
To use Qty Pricing, you must select Use Qty Pricing in the Item Prefs.
Qty Prices Custom
Big Business includes several options for selling different Quantities at different prices.
There is a optional feature (for a paving stone distributor) that lets you key in one unit (square feet) on one row and converts to other units (pallets and eaches) on split rows. This works with Qty Pricing to automatically set bulk price (pallet) on bulk rows.
There is another feature (for beverage distributor) for splitting one item (drink cases) into other items (individual drinks) automatically, so the inventory is kept up-to-date. This does not require Qty Pricing because each item (cases and eaches) has its own item card to automatically avoid fractional items (one case minus one bottle leaves 23).
Qty Pricing Tab
Big Business 14 updates the Qty Pricing Tab on the Item Card to improve useability.
Qty Pricing is separated from Item Pricing for clarity. As pictured, you see your price breaks for Qty's (10, 100, 200) sorted in ascending order. Click Add (+) for a new blank row and it goes on top (highlighted).
Qty Pricing is one of many optional tabs for items along with Item MRP, Price Levels, BigCommerce, and Shopify, pictured. Each is turned on separately so there are only three tabs to start. Go to Item Prefs, click Qty Pricing, and this will enable this feature.
Qty Prices Search
Qty Prices Search is a tool for managing quantity pricing entries, which may be many.
Qty Prices Import assumes you are adding new entries for new price breaks and does not delete old or check for duplicates. If you do not Delete you may get duplicates.
To change prices, use the Qty Prices Search to Export and Delete. Then update the exported entries in spreadsheet and import anew.