Chapter 4. Price, Cost and Discounts
This chapter has information about Price, Cost and Discounts. Information and tasks related to these three key topics overlap multiple areas of Prism; therefore, they are grouped in this chapter.
Price is the amount that you charge a customer for an item or service. When adding a new item to Prism Inventory, you will enter a Price and Cost for the item. The difference between the Price and Cost is recorded in the Margin % field. Prism has several price-related preference settings as well as permissions that control employee ability to edit price. This topic has information about:
- Price Fields
- Price-Related Preferences
- Price-Related Permissions
- Price Levels
- Price Adjustments
- Price Manager
- Seasonal Pricing
The following table lists price-related fields found in Prism. In Inventory Item Details, there is a Price/Cost tab where price-related fields are grouped.
|Price||The selling price for the item.|
|Price with Tax||In VAT environments, Price with Tax is used instead of Price to indicate the selling price for the item.|
|Margin %||The difference between the Price and the Cost. The cost is expressed as a percentage of the price.|
|Ext Price (Store and Company)||You can view the extended price for the item at the store and company level. Store: Price x Store OH Qty; Company: Price x Company OH Qty|
|Ext Price WT (Store and Company)||Same as above, except using Price with Tax.|
|Store Min Ext Price||The extended price for item at its minimum stock level.|
|Store Max Ext Price||The extended price for item at its maximum stock level.|
Sample Inventory Price and Cost Tab showing extended cost, extended price and margin
|Bring original price from Price Level||Node Preferences > Transactions
(Must be set at the Store level or lower)
|Create price adjustments for items with zero OH Qty||Node Preferences > Merchandise > Adjustments
If selected, price adjustments will be applied to items with a current on-hand quantity of zero. If not selected, price adjustments will not be applied to items with a current on-hand quantity of zero.
|Require Price Adjustment Reason||Node Preferences > Merchandise > Adjustments
If selected, users must select an adjustment reason to update a price adjustment memo
|Margins Affect||Node Preferences > Merchandise > Inventory > General
Select either Price or Cost to have changes to Margin affect that value.
|Alert when Item Price differs from Style Price||Node Preferences > Merchandise > Inventory > General
If selected, an alert will be displayed to users when a change is made to an item's price such that the price is different from other members of the same style.
|Use Seasonal Pricing||Node Preferences > Merchandise > Inventory > Pricing > Price Levels
|Adjustments - Create Price Memo||Allows group members to create price adjustment memos to change the price of one or more items.|
|ASN Vouchers - Change Price||Allows group members to change the Voucher Price on ASN Vouchers.|
|Customers - Change Price Level||Allows group members to change the price level assigned to customers.|
|Inventory - Edit Item Prices||Allows group members to edit the Price (or Price with Tax) field in Inventory.|
|POS - Change Price Level||Allows group members to change the price level on a transaction.|
|Lookup Zero-Priced Items||If selected, zero-priced items are included in item lookups done by group members.|
|Vouchers - Change Price||Allows group members to change the Voucher Price of items as they are being received.|
You can assign multiple prices to inventory items by creating price levels. Each price level is a complete set of inventory prices that you can assign to a specific group of customers, or use for a sale or promotion.
You define price levels in System Preferences > Local Preferences > Merchandise > Pricing > General.
When defining price levels, you can optionally select one of the price levels to be a default discount price level.
Old Price/Adjusted Price
When making a Price Adjustment Memo, the Old Price is the current Price (before the adjustment). The user enters the new Price of the item as the Adjusted Price. After the memo is updated, the Adjusted Price becomes the Price at the currently active Price Level.
Price Manager makes it easy to change the prices of selected items or styles for things like sales events or to increase sales of slow moving merchandise. When changing prices, you can let Prism adjust prices based on your instructions (calculating the new prices in a variety of ways from the current price or cost) or you can enter the new prices manually. The price changes can take effect immediately or at a future date, and former prices can be restored, if needed.
With seasonal pricing, you assign a season to inventory items. When the season's Start Date arrives, the item's price is automatically updated. When the season ends, the price reverts automatically to whatever it was before, unless there is another season starting, in which case the seasonal pricing for the new season will be applied. When updating a scheduled markdown, you can select a season to apply the markdown to prices for that season.
A package is a group of two or more individual items priced as a single inventory item. A customer can buy any of the packaged items individually or in different sizes, colors, or styles, but still receive the package price when the items are all purchased together as a package. Packages are ideal when you want to offer grouped components at a discount, but also want to give customers the option to buy one or more of the items individually.
When a package item is listed on a receipt or sales order, all the component items are automatically listed as well. The package price specified in inventory is listed on the sales document. Individual component prices are automatically discounted proportionally to their normal prices; Prism applies a multiplier so that when the discounted prices are summed, they equal the specified package price.
The package quantity and price on a sales document are for display purposes only and are not carried to the totals area of the document. The totals information is calculated from the component item quantities and discounted prices. The multiplier used to determine discount item prices is calculated with this formula:
Package Price /(Item 1 Price + Item 2 Price + … + Item x Price) = Proportional Multiplier
The multiplier is then applied to each individual component's normal price to arrive at a discounted price for each item. The sum of these discounted prices equals the defined package price.
For example, imagine that you have a package made up of two component items. Item 1 has a normal inventory price of $50 and Item 2 has a normal price of $100. You are going to offer the two items in a package, with the package priced at $75 total. Applying the calculations looks like this:
Predefined Package Price = $75.00
Proportional Multiplier = 75 / (50 + 100) = .50
Item 1 $50.00 with a multiplier of .50 applied is Discount Price of $25.00
Item 2 $100.00 with multiplier of .50 applied is Discount Price $50.00
The Cost field represents the amount paid to the vendor per unit for the item. When adding a new item to Prism Inventory, you will typically enter both a Price and Cost. The Price and Cost are used to calculate the item's Margin. When you order items from vendors on POs and receive items on Vouchers, each item's PO Cost is automatically entered. If the amount charged by the vendor has changed, the user can edit the PO Cost and the change will be carried to the voucher. When the voucher is updated and the system is set to use the default Inventory Costing Method of "Average", the item's Cost in Inventory will be updated. The Cost topic has information about:
- Cost Fields
- Cost-Related Preferences
- Cost-Related Permissions
- Inventory Costing Method (Average, Overwrite, Leave)
Here are the key cost-related fields available in Prism. You can add these fields to screen designs by configuring Grid Format preferences. Note: The ability to view cost-related fields is controlled by the following permissions: Common > See Item Cost
|Alt Cost||Adjustment Memo Items, Voucher/ASN - PO Items||When items can be ordered from multiple vendors, Prism enables you to assign a separate Cost, Vendor Code and UPC (or ALU) to the item. For these multi-vendor items, the primary vendor's information is entered in the Cost, Vendor Code and UPC (or ALU) fields. Each additional vendor's information is entered in the Alt Cost, Alt Vend Code and Alt UPC fields. Currently, alternate vendors must be defined in RIL Management.|
|Cost||Adjustment Memo Items, Inventory Lookup, Inventory Search, Voucher/ASN||The cost paid to the vendor for each unit of the item.|
|Ext Cost||Purchase Order, Voucher/ASN, Voucher/ASN - PO Items||The extended cost for the item on the document. Cost x Doc Qty|
|Ext FC Cost||Purchase Order, Voucher/ASN - PO Items||Extended cost in the vendor's assigned currency.|
|FC Cost||Purchase Order||The cost for the item in the vendor's assigned currency.|
|Orig Cost||Adjustment Memo Items, Voucher/ASN||The cost before any changes or adjustments|
|Order Cost||Inventory Lookup, Inventory Search||Order Cost provides an alternative field for storing cost information. In addition, the Order Cost field is used by the Trade Discounts and Foreign Currency Order features.|
|PO Cost||Purchase Order, Voucher/ASN - PO Items||The cost for the item on this purchase order. By default, the item's Cost in inventory is entered; however, you can edit the PO Cost for specific orders as needed.|
|Trade Discount %||Inventory Lookup, Inventory Search, Purchase Order||The Trade Discount % entered in the vendor record. When using trade discounts, the discount is applied to the Vendor List Cost to determine the Order Cost.|
|Vendor List Cost||Purchase Order, Voucher/ASN - PO Items||The vendor's list cost before any trade discount is applied. When using trade discounts, the discount is applied to the Vendor List Cost to determine the Order Cost.|
|Old Cost/Adjusted Cost/Cost Difference||These fields are on Cost Adjustment Memos and show the difference between the current cost, the new cost, and the difference between the two.|
Voucher Cost is an important value because of its potential impact on Inventory Cost and ultimately on the inventory valuations that are entered on financial reports.
There are two primary questions that need to be answered regarding Voucher Cost:
1. How is the Voucher Cost field populated?
2. What happens if I receive items into Inventory at a Voucher Cost different from current Inventory Cost?
Cost to Use for POs and Vouchers
The Cost field in the item's Inventory record is the main field for tracking cost. However, there is also an Order Cost field in the item record. The Order Cost field provides an additional field for tracking cost and is used with the Trade Discounts and Foreign Currency Orders features. So which field will be used to populate PO Cost when a user creates a PO (or Voucher Cost when a user creates a voucher)? That will be determined by the "Cost to Use for POs and Vouchers" preference. The default setting for the preference is to use Order Cost on POs and Vouchers. However, the default value for Order Cost field is 0.00; therefore, unless you are doing something special with the Order Cost field, like using Trade Discounts or Foreign Currency Orders, the Order Cost field will be actually be populated from the Cost field.
The following table lists the available options for the "Cost to Use for POs and Vouchers" preference.
|Cost to Use for POs and Vouchers||Order Cost: If the item has an Order Cost entered in the Inventory record, then use Order Cost on Purchase Orders and Vouchers. If no Order Cost has been assigned to the item (i.e. the item still has the default Order Cost of 0.00), the when creating a PO or Voucher, the item's Inventory Cost will be used instead.
Inventory Cost: Always use the item's Inventory Cost for PO Cost and Voucher Cost.
Trade Discounts: The Trade Discounts option is for a future release feature.
Inventory Costing Method
Whether the Voucher Cost is populated by Order Cost or Inventory Cost, what happens when the voucher is updated the Voucher Cost differs from the Inventory Cost? That question is answered by the "Inventory Costing Method" preference. By default, the quantities received at the new cost are averaged in with the quantities at the existing cost.
The following table lists the available options for the "Inventory Costing Method" preference.
|Inventory Costing Method||Average: This is the default setting. If items are received at a Voucher Cost that is different than the current cost in inventory, the new quantities at the new cost are averaged in with the existing quantities at the old cost.
Leave: If selected, inventory Cost is always left unchanged.
Overwrite: If selected, the Voucher Cost becomes the new Cost in Inventory.
Cost Difference Threshold
In addition, to the preferences in Purchasing > General, you need to know about the Cost Difference Threshold preference in Node Preferences > Merchandise > Inventory > General. Select to enable the Cost Difference Threshold feature, then enter a percentage in the Provide Warning When New Cost Differs From Old Cost By field. If this preference is selected, when receiving items, if the new cost differs from the old cost by more than the specified percentage, a warning will be issued. You will still be allowed to complete and update the voucher. Default = 100 (meaning there can be a 100 percent difference between the item's old cost and new cost.
Cost Adjustment Memos
If necessary, you can update item cost by creating a cost adjustment memo. If you edit Cost, an adjustment memo is created automatically.
Updating Cost using Price Manager
Price Manager is typically used to mark prices up or down; however, you can also use Price Manager to adjust costs of a group of items.
|Adjustment Memos - Create Cost Memo||Allow group members to create cost adjustment memos.|
|ASN Vouchers - Change Cost||Allow group members to change the Voucher Cost for items on ASN Vouchers|
|Common - See Item Cost||Allow group members to view cost-related fields, whatever the document.|
|Inventory - Edit Item Cost||Allow group members to edit the Cost field in the item's Inventory record.|
|Inventory - Edit Item Order Cost||Allow group members to edit the Order Cost field in the item's Inventory record.|
|Vouchers - Change Cost||Allow group members to edit the Voucher Cost of items on receiving vouchers.|
Users can apply a variety of discounts at POS. The following table lists the types of discounts that can be applied:
|Transaction||Applied to the transaction subtotal. If the transaction includes both sale and order items, you can apply a separate transaction to each. You can discount the transaction by a certain percentage or by a certain amount. A transaction discount can optionally be spread across the items on the document. Spreading a discount distributes the transaction discount amount among the individual items.|
|Item||Applied to individual items on the transaction. Enter item-level discounts via the Item Details dialog. You can discount an item by a certain percentage, a certain amount, or set a specific Price for the item. Select a Discount Reason. See Chapter 5. Item Details (Item Discounts)|
|Customer||If a customer has a Discount % assigned in the customer record, then when the customer is entered on the transaction, a prompt is displayed, asking if the customer's assigned discount should be applied. Customer discounts are applied to the individual items on the transaction. If a customer discount is applied, you can view the discount details by going to Item Details > Discounts and click the Show Discounts button.|
|Promotions||How promotion discounts are applied depends on your Prism preference settings. By default, when promotions are enabled the promotions will be applied automatically; however, if the preference "Manually Apply Promotions" is selected, then the user must apply the discount manually via the Options button on the transaction form. Whether the promotion discount is applied automatically or manually, you can view discount details in Item Details > Discounts. Click the Show Discount button.|
You can set up a special price level with discount prices and then apply the price level on the transaction or item level. The item price(s) will be changed to the price defined in the new price level. An important consideration with this method is the price change is technically not a discount, meaning you won't be able to use the Show Discount button to view the discount amount and percentage. See the Price Levels topic for more information.
Sample Item Details - Discounts
Discount-related preferences are found in the Transactions > Discounts area in Prism preferences. The General area has preferences for rounding discounts and accumulated discounts. The Item Discount Settings area has preferences for editing item discounts.
|Default Discount Type||This preference controls which type of discount is selected by default: Amount, Percentage, or Price. For example, if your business only gives percentage discounts, you can set this preference to "Percentage".|
|Show One Item Discount Option||If selected, the user can choose a discount type. Select the check box and then select the desired discount type.|
|Show Reason Prompt||If selected, when a user edits an item's discount, then a prompt is automatically displayed for selecting a reason. Note: Discount Reasons are defined in Preferences > Transactions > Reasons and Notes.|
Preferences & Settings > Transactions > Discounts
Editing Discounts In-Line
Users can edit the Discount $ or Discount % directly from the main transaction form. To edit the item discount, click in the Discount field. Select the desired discount type from the menu (You can set a default discount type in Prism Preferences > Transactions > Discounts).
- Select an item in the item grid and then click the Discount Button
- Select a discount option. Type the discount amount or percentage. Press
or tap the checkmark to apply the discount.
- If the "Show Discount Reason" preference is selected, then users must select a discount reason.
- The entered discount is applied. Complete the rest of the transaction.
Item Details > Discounts
The Item Details screen includes a discounts tab where users can view/add/edit discounts.
- Select an item on the transaction. Click the Discounts button.
- The Item Details screen opens to the Discounts tab.
- To enter a discount percentage, enter the value (e.g. 10) in the text box and then tap or click the Discount % button. Alternatively, you can enter a discount amount or a specific price.
- Select a Discount Reason.
- Click the Apply button.
- If using accumulated discounts, you can enter additional item discounts in the same manner.
- Click the Show Discount button to view the discount(s). Click Cancel to exit the dialog.
Show Discount Button
When a user selects the Show Discounts button, the discounts applied to the item or transaction are displayed. Users with the required permission can remove individual discounts as needed.
When multiple discounts are being applied, Prism will apply three levels of sorting:
- The first level sorts discounts by the "Spread" flag.: 1 - Non-Spread, 2 - Spread
- The second level sorts discounts according to the source of the discount: 1 - Price Level, 2 - Customer, 3 - Manual, 4 - Promotion
- The third level of sorting is by order of operation (time discount was applied)
When a user applies a discount at POS, the user must select a reason. In Prism, Node Preferences > System > Reasons and Notes, users can work with the reasons copied during initialization and define additional reasons, if needed. In Prism, if the Reason Required checkbox is selected in Prism preferences, when a user applies an item or a transaction discount, the user must select a discount reason. If the Reason Required checkbox is not selected, the reason is optional.
Sample Discount Reasons:
The Manual flag on Discount Reasons that controls whether employees can manually select reason at POS. Only reasons that have the "Manual" flag selected in preferences can be selected manually at POS by users. If the reason does not have the Manual flag selected in preferences, then it can only be assigned by the program (automatically) as part of a POS event. This feature is especially useful when retailers use different reasons for discounts applied manually versus those applied automatically. For example, retailers may have special Discount Reasons that are applied by a customer loyalty plugin. The preference prevents automated reasons from being accidentally chosen at POS. By default, the Manual checkbox is selected for all Discount Reasons. Clear the checkbox as needed for any reasons that should only be applied automatically.
Multiple Discounts and Reasons (Accumulated Discounts)
When using the Accumulated Discounting feature in RP Prism, users can assign multiple discounts at either the item level or the transaction level. Users assign a Discount Reason to each individual discount. The same reason can be used for multiple reasons (see illustration below). When multiple discounts are applied, when viewing the consolidated discount info for the transaction, "Multi" will be displayed as the Discount Reason.
Replication of Discount Reasons between RP Prism and RIL
When transaction with multiple discounts are sent to Retail Pro Integration Layer (RIL), the Discount Reason field at the item level will also display "Multi." There is not a specific "Discount Reason" field at the transaction level in RP 9, so if the discount is not spread, there will be no indication that the transaction had multiple discounts applied.
Editing Discount Reasons in RIL
If you edit a discount reason in RIL, the new reason will be replicated to Prism during day-to-day replication; however, any existing transactions will retain the old reason.
Security for Discounts
|POS - Remove Discounts||Only users who belong to a group assigned the Remove Discounts permission will be able to use the Remove Discounts button to remove a discount.|
|POS - Show Discounts||You can view accumulated discounts using the Show Discounts button. This button is available in the Item Details dialog (for viewing accumulated item discounts) and in the Transaction Details dialog (for viewing accumulated spread discounts).|
Alerting User when Max Discount Reached
When the item's max discount is reached, a flag is displayed next to the discount percentage. If the user sees the word "Max" in red beside the discount, the user can assume that the discount has reached its maximum amount and part of a discount may not have been applied. Associates can see the flag and quickly understand why some part of a discount was not applied. There are many ways that the maximum discount for an item can be reached: Item Max Discount, Customer Max Discount, or Employee Max Discount. Note: The max discount value can be based on either the Max Discount % or Max Accumulated Discount % (see the previous section on the new preference related to this).
Item Max Discount
In each item's inventory record, the Max Discount field can be used to limit the amount of discount applied to an item. This is especially useful when vendors place restrictions on discounts.
Employee Max Discount
The Employee Max Discount field can be used to limit the discounts granted by employees. By default, this field is set to 100, meaning employees can grant discounts up to 100 percent. If the maximum discount percentage is exceeded, a prompt is displayed. A manager or other override user can override the discount if necessary. Otherwise, clicking Apply Maximum will overwrite the entered discount percentage with the maximum discount percentage in the employee record.
Prism includes a Discount Rounding Method preference to control how percentage discounts are rounded: Up, Down, or Normal (whichever is closest). This preference is especially useful for handling the rounding of decimal amounts (e.g. half-cent) when applying a discount percentage. The preference is found in Preferences & Settings > Transactions > Discounts. IMPORTANT: This preference is for rounding DISCOUNTS, not PRICES.
|Normal||(Default) Round to the nearest multiple. Example: .27 rounds to .30, .22 rounds to .20.|
|Up||Round up to the next higher multiple. Example: Both .27 and .22 round to .30.|
|Down||Round down to the previous lower multiple. Example: Both .27 and .22 round to .20.|
Here is an example of how this preference can be used to apply fine-grained control to the rounding of discounts, especially when dealing with "half-cent" amounts.
|Price||Discount||Calc. Disc||Rounded Disc||Final Price|
Issues with Rounding Discounts
When rounding discounts, the result will sometimes not be what you expect. In other words, when rounding down, the price will go up, and when rounding up, the price will actually go down. Let's look at two examples to illustrate the point.
- Example 1: An item's original price is $1.00 and you are set to round discounts DOWN. You give it a 10.6% discount. This results in a discount amount of $0.106 and price of $0.894. After rounding, you end up with a discount amount $0.10 and price $.90. As you can see, when the discount amount was rounded DOWN, the price ended up looking like it was rounded UP.
- Example 2: A similar inversion happens when you deal with half a cent when using NORMAL rounding method (to the nearest value). Rounding a discount amount of 0.005 will be rounded UP, but the price will look like it's rounded DOWN. For example, let's take a $1.00 item and give it 10.5% discount. This translates to a $0.105 discount amount and $0.895 price. Rounding the discount using the NORMAL method will round the discount amount to $0.11, so the price becomes $0.89. As you can see, the price went DOWN, not UP.
The Accumulated Discounts feature enables retailers to apply multiple discounts to an item, with each discount affecting the already discounted price. Example: A 20% discount followed by a 10% discount, results in a 28.01% accumulated discount.
Basic Steps for Accumulated Discounts
- Define a Max Accumulated Disc % for individual items in RP 9 Inventory, as needed.
- Configure RP Prism Permissions related to discounts.
- Enable accumulated discounts in RP Prism Preferences.
- Create transactions and add discounts as needed.
- Use the Show Discounts button to view (or remove) discounts.
Preferences for Accumulated Discounts
Accumulated discounts must be enabled in preferences. Separate preferences control accumulated discounts for manual discounts (transaction-level and/or item-level) and spread discounts (when a transaction discount is spread across the items/quantities). To enable accumulated discounts, navigate to Preferences & Settings > Transactions > Discounts.
|Accumulate Manual Discounts||When enabled, manual discounts are accumulated. When disabled, entering a manual discount replaces the existing manual discount. Note: Price Level and Customer discounts always accumulate, regardless of the Accumulate Manual Discounts preference setting|
|Accumulate Spread Discounts||When enabled, spread discounts are accumulated. When disabled, spreading a discount replaces the existing spread discount, if one exists.|
Accumulate Spread Discounts
When a user applies a transaction level discount, the user can spread the discount amount. Spreading a discount distributes the discount amount among the items and quantities on the transaction. To accumulate spread discounts, first enable the feature in Prism Preferences & Settings > Transactions > Discounts. If a Transaction Level Discount is spread, then the discounts are applied to the item(s), reducing the item price. Note: An additional preference option can be set to automatically spread discounts.
- On a transaction in progress, tap or click the Transaction Details button.
- Click the Discounts tab.
- Enter a discount value. You can enter an amount or a percentage. To enter a percentage, enter the value and then tap the Percent% button.
- Click the Apply button.
- Click the Spread button.
- Add and spread additional transaction discounts in the same manner. Click the OK button to exit Transaction Details.
- To view details for the spread discounts, select an item and then tap or click the Item Details button.
- The Discounts tab is displayed by default. Click the Show Discount button.
- Details for each of the spread transaction discounts are displayed. Click Cancel to exit the discounts dialog. Click OK to exit Item Details.