This chapter contains the following topics:
Changing Prices for Groups of Items
Use this selection to do the following:
| • | Change existing prices for an item or group of items |
| • | Enter prices for an item in a specific warehouse (if you selected to use multi-warehouse pricing in Control information) |
| • | Enter sale or contract prices for an item or group of items |
| • | Print a list of sale or contract prices for a group of items |
| • | Print a price list for a group of items |
| • | Print a price list for a particular customer |
Refer to the Price Lists chapter for a description of Price Lists.
Inventory Control provides for the following types of prices:
| • | Item default prices |
| • | Warehouse-specific prices |
| • | Sale prices |
| • | Contract prices |
This chapter also explains how to use the Purge sale prices and Purge contract prices selections on the Utility menu. For printing a list of prices, refer to the Price Lists chapter.
Prices may also be controlled by Price codes. See the Introduction to Price codes in the Price Codes chapter.
Item default prices are the prices that exist for an item in Items (Price-1/2/3/4/5 for the stocking unit and for each alternate unit). If you do not enter a price code or set up any other prices for an item, Price-1 for the corresponding selling unit will be used as the default selling price. Price-1 is always used as the default price if the item is sold using the Inventory selection.
If an item has a price code for the selected selling unit, the item's selling price is calculated by applying the price code to the item default prices. Price codes are used only in Order Entry, Accounts Receivable and Point of Sale.
Item default prices can be changed using either the Item prices or Items selection.
Warehouse-specific prices are the prices charged for an item at a particular warehouse. These prices are used in place of item default prices when the item is sold from that warehouse in Accounts Receivable, Order Entry and Point of Sale. If the item has a price code, it is applied to the warehouse-specific prices when calculating the selling price.
Warehouse-specific prices can be entered using Item prices, only if you selected multi-warehouse pricing in Control information.
Sale prices are the prices charged for specific inventory items or groups of items, for a specific period of time. If a sale price is in effect when an invoice is entered in Accounts Receivable or an order is entered in Order Entry, the price used is the lower of the sale price and the price calculated based on item default or warehouse-specific prices.
Sale prices are entered using Sale prices. Six distinct types of sale prices can be defined for the stocking unit and for each alternate unit of an item, as shown below. However, A/R and Order Entry use only the types that are indicated for Use sale prices by in I/C Control information.
For Point of Sale you have two options, as determined by P/S Control information, for setting sale prices:
| • | Point of Sale has it's own setup called Special sale prices. It has the advantage of assigning a time of day range for a sale prices; not just a date range. You may also assign a Price code to a special sale price. |
| • | If you are using alternate unit sale prices, then you must use the I/C sale price setup. |
If multiple sale prices exist for an item, the type that appears highest on the following list is used by A/R and Order Entry.
| 1. | Sale price for an item at a specific warehouse |
| 2. | Sale price for an item at all warehouses |
| 3. | Sale price for a category/sub-category at a specific warehouse |
| 4. | Sale price for a category at a specific warehouse |
| 5. | Sale price for a category/sub-category at all warehouses |
| 6. | Sale price for a category at all warehouses |
Warehouse-specific sale prices may be set up only if you selected multi-warehouse pricing in I/C Control information.
Contract prices are the prices charged for specific items, or groups of items, to specific customers. They may be set up for a specific period of time, or to remain in effect until removed.
If a contract price exists for an item/customer when an invoice is entered in A/R or an order is entered in Order Entry, the contract price is used instead of any automatically calculated price. A contract price can instead be defined to only be active when it is the lowest price.
Contract prices are entered using Contract prices. Three distinct types of contract prices can be defined for the stocking unit and for each alternate unit of an item, as shown below. However, A/R and Order Entry use only the types that are indicated for Use contract prices by in Control information.
If multiple contract prices exist for an item, the type that appears highest on the following list is used by A/R and Order Entry:
| 1. | Contract price for a customer for a specific item |
| 2. | Contract price for a customer for a category/sub-category |
| 3. | Contract price for a customer for a category |
Warehouse-specific contract prices cannot be defined.
You may also set up contract prices for Point of Sale. However, Point of Sale has it's own setup for contract prices. You may use that if you wish. If you are using alternate unit contract prices, then you must use the I/C contract price setup.
Any of the prices that you define through this selection may be deleted by pressing <F3> when the individual price information is displayed. Sale prices and contract prices may also be deleted by using either Purge sale prices or Purge contract prices.
In addition, if you delete an item using either Items or Purge inactive items, any associated prices for the deleted items are also removed. If the status record for an item is deleted (using Status, Items, or Purge inactive items), warehouse-specific prices for the item in the related warehouse are deleted as well.
Select
Item prices from the Prices menu.
If you are using multi-warehouse pricing (as specified in Control information), you are asked if you wish to enter prices by warehouse. Follow the screen instructions to update item default prices or prices for a specific warehouse.
Select
Item prices from the Prices menu.
The following screen displays:
|
Note |
If you selected to enter prices by warehouse, the warehouse you specified is shown at the top of this screen. |
Enter the information as follows:
1. Item number
Options
Enter the item number or bar code or use one of the options:
|
<F1> |
For the next item number |
|
<SF1> |
For the previous item number |
|
Blank |
To look up the item by description |
The existing non-zero prices for the item display, along with the item's stocking unit, pricing unit, average cost (standard cost for standard valuation), and replacement cost.
Use Field number to change ? to change any of the displayed prices.
If the item has a pricing unit that is different from its stocking unit, enter the revised prices per pricing unit. The price per stocking unit is then calculated and displayed.
If all prices for an item are currently zero, the message displays No prices exist for this item.
To enter new prices for an item (for example, if Price-3, 4 and 5 are zero or alternate unit prices do not already exist), use the Items menu selection to enter the prices.
If you are entering prices for a specific warehouse, at Item number, enter the item number.
After the item is specified, enter each price to be used at that warehouse or press <Enter> for the current price in the Items (Item default).
If you press <Enter>, Item default displays as the price. The price in Items (Enter) will be used when the item is sold from this warehouse.
Use the Sale prices selection to enter sale prices and dates for inventory items or groups of items.
When entering A/R invoices, O/E orders or P/S transactions, if a sale price is in effect for an item, the lower of the sale price and the automatically calculated price will be used as the default for the item.
Sale prices that have expired may be cleared using this selection, or the Purge sales prices selection on the Utility menu. Refer to Purging Sale Prices.
Select
Sale prices from the Prices menu.
If you are using multi-warehouse pricing (as specified in Control information), you are asked if you wish to enter sale prices by warehouse. Follow the screen instructions to update item default sale prices or sale prices for a specific warehouse.
On the next screen that appears, you are asked to enter the following information:
*1. Sale type
Enter I to enter a sale price for a specific item, or enter C to enter a sale price for a category or sub-category of items.
Options
You may also use one of the options:
|
<F1> |
To scan through the sale prices |
|
<Enter> |
After entering the first sale price, to default to the last sale type entered |
|
Format |
One letter, either I or C |
|
Example |
Type I |
If you enter I, and did not select to use this type of sale price in Control information, a message displays to inform you that sale prices by item are not active.
If you enter C, and did not select to use either sale prices by category or sub-category, a message displays to inform you of this.
Sale prices may be entered by item, by category, or by sub-category, regardless of the types selected in Control information. However, these sale prices will not be used in A/R or Order Entry until they are also selected in Control information.
If you specify a Sale type of Item, the following screen displays:
Enter the information as follows:
*2. Item number
Options
Enter the item number or bar code, or use one of the options:
|
<F1> |
For the next item |
|
<SF1> |
For the previous item |
|
Blank |
To look up the item by description |
The item's stocking unit, pricing unit, average cost (standard cost for standard valuation), and replacement cost are displayed, along with its current regular price. If alternate units are defined for the item, the current alternate unit prices are also displayed.
3. Start date
Enter the date that the sale price becomes effective. After entering the first sale price, you may also press <Enter> to use the last sale price start date entered.
|
Format |
MMDDYY |
4. End date
|
Format |
MMDDYY |
Enter the last date that the sale price will be in effect. After entering the first sale price, you may also press <Enter> to use the last sale price end date entered.
Stock unit
Price Unit
The above fields will be filled automatically with the information selected in Control information.
5. Each sale price
Enter the price that will be used as sale price.
|
Format |
Up to ten digits |
If you specify a Sale type of Category, the following screen displays:
Enter the following information:
*2. Category
Enter the category of the items to be included in the sale price as defined in Control information.
|
Format |
Up to five characters |
|
Example |
Type MISC |
*3. Sub-category
Enter the sub-category of the items to be included in the sale price, or press <F5> for All sub-categories of the category.
|
Format |
Up to five characters or use the option |
|
Example |
Press <F5> |
An entry of All is considered a category sale price because it includes the entire category. An entry of a specific sub-category is considered a sub-category sale price.
If you enter a sub-category of All, and did not select to use sale prices by category (in Control information), a message displays to inform you that category sale prices are not active.
If you enter a specific sub-category, and did not select to use sale prices by sub-category (in Control information), a message displays to inform you that sub-category sale prices are not active.
4. Start date
Enter the date that the sale price becomes effective. After entering the first sale price, you may also press <Enter> to use the last sale price start date entered.
|
Format |
MMDDYY |
|
Example |
Enter the current date |
5. End date
Enter the last date that the sale price will be in effect. After entering the first sale price, you may also press <Enter> to use the last sale price end date entered.
|
Format |
MMDDYY |
|
Example |
Enter the current date |
6. Price basis
Specify the price to be used as a base for discounting.
Options
Enter one of the following:
|
1 |
To calculate the sale price by discounting Price-1 |
|
2 |
For Price-2 |
|
3 |
For Price-3 |
|
4 |
For Price-4 |
|
5 |
For Price-5 |
After entering the first sale price, you may also press <Enter> to use the last price basis entered.
|
Format |
One digit from above or use the option |
|
Example |
Press 1 |
7. Disc pct
Enter the percent by which to discount the price specified for Price basis when the item is sold by its stocking unit, or press <Enter> to indicate that the stocking unit price is not on sale.
|
Format |
Up to five digits or use the option |
|
Example |
Press <Enter> |
8. Alt-1 disc pct
Enter the percentage by which to discount the price specified for Price basis when the item is sold by its first alternate unit. You may also press <Enter> to indicate that the first alternate unit price is not on sale.
|
Format |
Up to five digits or use the option |
|
Example |
Press <Enter> |
9. Alt-2 disc pct
Enter the percentage by which to discount the price specified for Price basis when the item is sold by its second alternate unit. You may also press <Enter> to indicate that the second alternate unit price is not on sale.
|
Format |
Up to five digits or use the option |
|
Example |
Press 4.50 |
Use this selection to enter contract prices for items, or groups of items, for specific customers.
When entering an A/R invoice or O/E order, if a contract price is in effect for an item/customer, the contract price is used instead of the automatically calculated price. A contract price can instead be defined to only be active when it is the lowest price.
Contract prices that are no longer in effect may be cleared using this selection, or the Purge contract prices selection on the Utility menu. Refer to Purging Sale Prices.
Select
Contract prices from the Prices menu.
*1. Contract type
Enter I to enter a contract price for a specific item, or enter C to enter a contract price for a category or sub-category of items.
If you enter I, and did not select to use this type of contract price in Control information, a message displays to inform you that contract prices by item are not active.
Contract prices may be entered by item, by category, or by sub-category, regardless of the types selected in Control information. However, these contract prices will not be used in A/R or Order Entry until they are also selected in Control information.
Type I to display the following screen:
The following screen displays:
Enter the information as follows:
*2. Customer number
Enter the number of the customer to receive the contract price.
Options
You may also use one of the options:
|
<F1> |
To lookup by Contract ID |
|
Blank |
To look up the customer by name |
|
Format |
Up to 12 digits or use the options |
|
Example |
Type: 10 |
After entering the first contract price, you can also press <Enter> for the last customer number entered.
*3. Item number
Options
Enter the item number or bar code, or use Blank to look up the item by description.
|
Format |
Up to 20 digits or use the options |
|
Example |
Type: 1 |
4. Start date
Enter the date that the contract price becomes effective.
Options
You may also use one of the options:
|
<F2> |
For None if there is no specific start date |
|
<Enter> |
After entering the first contract price, to use the last contract start date entered |
|
Format |
MMDDYY |
|
Example |
Press <F2> |
5. End date
Options
Enter the last date that the contract price will be in effect, or use one of the options:
|
<F2> |
For None if there is no specific end date |
|
<Enter> |
After entering the first contract price, to use the last contract end date entered |
|
Format |
MMDDYY |
|
Example |
Press <F2> |
6. Contract ID
Options
Enter the identification information for this contract, or press <Enter> for subsequent contract prices and to use the last contract ID entered.
|
Format |
Up to 15 digits or use the options |
|
Example |
Press <Enter>. |
7. Use contract or lowest price?
Enter C (Contract price) or L (Lowest price) to indicate whether to always use the contract price or to use the lowest price, if a lower price exists for this item.
|
Format |
One letter, L or C |
|
Example |
Type C, then press <Enter> |
8. Each price
Enter the price that will be used as the Contract price.
|
Format |
Up to 10 digits |
|
Example |
Type: 25.50 |
If you specify a Contract type of Category, the following screen displays:
Enter the following information:
*2. Customer number
Enter the number of the customer to receive the contract price.
Options
You may also use one of the options:
|
<F1> |
To lookup by Contract ID |
|
Blank |
To look up the customer by name |
|
Format |
Up to 12 digits or use the options |
|
Example |
Press <Enter> for customer name |
After entering the first contract price, you may also press <Enter> to use the last customer number entered.
*3. Category
Enter the category of the items to be included in the contract price.
|
Format |
Up to five characters |
|
Example |
Type: Misc |
*4. Sub-category
Enter the sub-category of the items to be included in the contract price, or press <F5> for all sub-categories of the category.
An entry of All is considered a category contract price because it includes the entire category. An entry of a specific sub-category is considered a sub-category contract price.
If you enter a category of All, and did not select to use contract prices by category (in Control information), a message displays to inform you that category contract prices are not active.
If you enter a specific sub-category, and did not select to use contract prices by sub-category (in Control information), a message displays to inform you that sub-category contract prices are not active.
|
Format |
MMDDYY |
|
Example |
Press <F2> |
5. Start date
Options
Enter the date that the contract price becomes effective, or use one of the options:
|
<F2> |
For None if there is no specific end date. |
|
<Enter> |
After entering the first contract price, to use the last contract end date entered. |
6. End date
Enter the last date that the contract price will be in effect.
Options
You may also use one of the options:
|
<F2> |
For None if there is no specific end date |
|
<Enter> |
After entering the first contract price, for the last contract end date entered |
|
Format |
MMDDYY |
|
Example |
Press <F2> |
7. Contract ID
Enter the identification information for this contract, or press <Enter> for subsequent contract prices and to use the last contract ID entered.
|
Format |
Up to 15 characters or use the option |
|
Example |
Type: 12345 |
8. Use contract or lowest price?
Enter C (Contract price) or L (Lowest price) to indicate whether to always use the contract price or to use the lowest price, if a lower price exists for this item.
|
Format |
One letter, C or L |
|
Example |
Type C, then press <Enter> |
9. Price basis
Specify the price to be used as a base for discounting. Enter one of the following:
|
1 |
For Price-1 |
|
2 |
For Price-2 |
|
3 |
For Price-3 |
|
4 |
For Price-4 |
|
5 |
For Price-5 |
After entering the first contract price, you may also press <Enter> to use the last price basis entered.
|
Format |
One digit from above (1,2, or 3) |
|
Example |
Press 1 |
10. Disc price
Enter the percentage by which to discount the price specified for Price basis when an item is sold by its stocking unit, or press <Enter> to indicate that the stocking unit price is not on contract.
|
Format |
Up to five digits or use the options |
|
Example |
Press <Enter> |
11. Alt-1 disc pct
Enter the percentage by which to discount the price specified for Price basis when an item is sold by its first alternate unit. You may also press <Enter> to indicate that the first alternate unit price is not on contract.
|
Format |
Up to five digits or use the options |
|
Example |
Press <Enter> |
12. Alt-2 disc pct
Enter the percentage by which to discount the price specified for Price basis when an item is sold by its second alternate unit. You may also press <Enter> to indicate that the second alternate unit price is not on contract.
|
Format |
Up to five digits or use the options |
|
Example |
Type: 22.50 |
Use this selection to change existing prices for a group of items.
Select
Group price changes from the Prices menu.
If you are using multi-warehouse pricing (as specified in Control information), you are asked if you wish to change group prices by warehouse. Follow the screen instructions to change item default prices or prices for a specific warehouse.
|
Note |
If you selected to change group prices by warehouse, the warehouse you specified or All is shown at the top of this screen. |
Enter the information as follows:
1. Starting item # and
2. Ending item #
Enter the range of item numbers for which prices are to be changed or press <F2> for First and Last. Follow the screen instructions.
|
Format |
Up to 15 characters or use the option |
|
Example |
Press <F2> at both fields |
3. Category/sub-cat
Enter the category of the items for which prices are to be changed, or press <F5> for All categories.
|
Format |
Up to five characters or use the options |
|
Example |
Press <F5> for All categories |
4. Sub-category
Enter the sub-category of the items for which prices are to be changed or press <F5> for All subcategories.
|
Format |
Up to five characters or use the options |
|
Example |
Press <F5> for All categories |
5. Vendor #
Enter the vendor number to change item prices for a single vendor, or press <F5> for All vendors.
6. Change prices by
Prices can be changed by adding or subtracting a dollar amount to a base figure, or by computing a percentage of a base figure and adding or subtracting the result to the base figure.
Enter D (Dollar amount) to change prices by a dollar amount, or P (Percent) to change prices by a percentage.
The base figure can be any of an item's current prices or its replacement cost. For prices other than Price-1, the base figure can also be any of the item's new prices. You can specify a different base for each price to be changed.
|
Format |
One letter, D or P |
|
Example |
Type: D |
7. Rounding method
Specify the method to be used for rounding the newly calculated prices. Enter one of the following:
|
C |
To round the prices to the nearest cent |
|
P |
To round the prices to the nearest price point |
|
I |
To increase the prices to the next price point |
|
N |
To not round the prices |
If you enter C, the third decimal position of each new price is rounded up or down to the nearest cent. A value of 5 or greater is rounded up, and 4 or less is rounded down.
If you enter P or I to round or increase prices to the nearest or next price point, a window appears for you to enter the price points to be used, as shown below:
A price point is a particular price at which merchandise is sold. For example, the price points in your store might be $0.79, $1.79, $2.79.
By selecting a rounding method of P or I, you can ensure that each calculated price coincides with one of your price points.
In our example ($0.79, $1.79, $2.79), a two-digit price mask of 79 defines the price points. In other words, no matter what price was calculated, the last two digits of that price are masked with 79.
Some businesses require multiple price masks, or even different price masks for different price levels of goods. Price points allows you to define up to three distinct price levels and up to sixteen price masks within each level.
For example, your low-price goods are under $3.00 and you price them at $0.79, $1.79, and $2.79. Your moderate goods are more than $3.00 but under $9.00, and you price them at $5.95 or $8.95. The rest of your goods are over $9.00, and you price them in increments of $10.00, at $9.95, $19.95, $29.95 and so forth.
You would define your price points as follows:
|
|
Level-1 |
Level-2 |
Level-3 |
|
Cut-off price |
3.00 |
9.00 |
Unlimited |
|
# of digits |
2 |
3 |
3 |
|
Price masks |
***.79 |
**5.95 |
**9.95 |
|
|
|
**8.95 |
|
Price changes are calculated in the normal manner. Then, if you specified I as the rounding method, the price is rounded to the next higher price point. If you specified P, the price is rounded to the closest lower or higher price point.
Your entry for the Level-2 Cut-off price must be higher than the Cut-off price for Level-1, and Level-3 must be higher than Level-2. Press <Enter> for Unlimited when entering the cut-off price for the last level to be defined.
Your entry for # of digits to be entered for the price masks must be between 1 and 5, and cannot be greater than the number of digits entered for the value of Cut-off price.
For Price masks, up to 16 masks may be entered for each level and the masks within each level must be ascending. Press <Enter> when completed entering the masks in a level. If you specified 3 or more for # of digits, you must enter a decimal point in the appropriate position of each mask.
After defining price points, you may save them as default entries for use the next time you run Group price changes.
8. Print or change
Options
Enter one of the following:
|
P |
To only print a report showing all items for which prices would be changed, along with the old and new prices that would be changed. The prices are not actually changed. |
|
C |
To print the report and change the prices. |
|
<Enter> |
To indicate No change |
If you selected to change by dollar amount, for each price shown, enter the amount to be added to or subtracted from the base figure to calculate the new price. To subtract the amount, include a minus sign.
For example, an entry of 2.50 establishes a new item price of the specified base, plus $2.50. An entry of 2.50- establishes a price of the specified base, less $2.50.
If you selected to change by percentage, enter the percentage of the base by which to change the price. To use a price less than the base figure, include a minus sign.
For example, an entry of 10 establishes an item price of the specified base, plus 10%. An entry of 10- establishes a price of the specified base, less 10%.
For both dollar amount and percentage changes, you may also press <Enter> to indicate No change at any price.
For each price being changed, enter the base to use.
Enter O to use one of the item's old prices, or enter R to use the item's replacement cost. For prices other than Price-1, you may also enter N to use one of the item's new prices as the base.
An old price is a price for the item prior to the change you are making now. The replacement cost is the cost of the item at the last purchase. A new price is a price for the item that will be created by a change you have already made on this screen.
If you enter a basis of either O or N, a window displays for you to select which old or new price you wish to use.
|
Note |
For new prices, only those prices already specified on this screen are shown in the window. |
Select the old or new price to be used by using the arrow keys (or typing the first letter) to position the cursor and press <Enter>.
If you specified to print the report without changing prices, you can display the report to the screen or send it to a printer. The display option is not available if you are also changing prices.
If Price-1 was changed for any item, the change in retail value of the reported items is shown at the end of the report. The retail value is computed based on the current on-hand quantity of the item and Price-1.
If you specified to change prices, the screen displays each item for which prices are being changed.
If any errors occur when attempting to change prices for an item, no prices are changed.
Use this selection to purge sale prices that have expired.
Select
Purge sale prices from the Utility menu.
The following screen displays:
You are asked to enter an ending cut-off date. Enter the last date for which sale prices are to be purged, or press <F5> to purge all sale prices regardless of ending date.
Sale prices with an End date on or before the cut-off date will be purged.
Use this selection to purge contract prices that are no longer in effect.
Select
Purge Contract prices from the Utility menu.
The following screen displays:
1. Purge type
Enter the type that you want to purge from the following:
|
C |
To purge by customers |
|
I |
To purge by item |
|
D |
For contract ID |
|
Example |
Type: C |
2. Starting customer # and
3. Ending customer #
Enter the range of customers for whom contract prices are to be purged. Press <F2> to select First to Last customer numbers. Follow the screen instructions.
|
Format |
Up to 12 digits or use the option |
|
Example |
Press <F2> at each field to select All customers |
4. Ending cut-off date
Enter the last date for which contract prices are to be purged, or press <F5> to purge all contract prices regardless of ending date.
Contract prices with an End date on or before the cut-off date for the specified customer range will be purged.
|
Format |
MMDDYY or use the option |
|
Example |
Press <F5> to select All |