Price Adjustment Settings - Read Only

(Product Adjustment)

Access

Support Files: Category, Group, Vendor

Tabs:  General, Adjustments, Products, Import/Export

 This is a read-only screen. You cannot edit any data on this screen. The documentation below describes the entry version of this routine. You can use it for reference purposes.

Use this routine to mass-update selected products to which you want, for example, to apply a sale or promotion price. You can specify a period of time in which to apply the adjustment, as well as a future date on which to begin applying the adjustment. You can apply product adjustments to

• vendor product lists,

• product groups,

• product categories

• product collections,  

• products in a district, or

• individual products.

Header Area

For each tab in this routine, the following information appears at the top of the screen:

Adjustment CodeEnter the code you want to identify this product adjustment. You can enter a maximum of 10 alphanumeric Consisting of both letter and number characters and often other symbol characters such as punctuation marks. characters.

TypeThe type of adjustment as defined at the Type field.

Adjustments Loaded  The date the selected products were loaded with the current pricing adjustment.

Tags Printed  The last date on which tags were printed for this adjustment.

General

Use the fields on this tab to specify general information on the product adjustment including the products you want to adjust and the date range in which to apply the adjustments. Use this screen to apply district pricing.

You can use several of these fields, for example Vendor and Group, to specify multiple products for product adjustment. To specify individual products, use the Product tab.

DescriptionEnter the description for this product adjustment. You can enter a maximum of 30 alphanumeric characters.

Type

VendorUse this field to specify one or more vendors whose products you want to include in this product adjustment. Otherwise, leave the field blank.

If you click on the Search button, you access the Vendor Cross Reference window, from which you can make a selection. If you click on the Action button An outlet to additional routines and functions. Identified by a blue button with a white ellipsis, Action buttons appear next to fields., you access the Multiple Vendor Selection window.

GroupUse this field to specify one or more product groups whose products you want to include in this product adjustment. Otherwise, leave the field blank.

If you click on the Search button, you access the Multiple Selection Lookup Window, from which you can select one or more groups. If you click on the Action button, you access the Multiple Product Group Selection window.

CategoryUse this field to specify one or more product categories whose products you want to include in this product adjustment. Otherwise, leave the field blank.

If you click on the Search button, you access the Multiple Selection Lookup Window, from which you can select one or more categories. If you click on the Action button, you access the Multiple Category Selection window.

CollectionUse this field to specify one or more product collections whose products you want to include in this product adjustment. Otherwise, leave the field blank.

If you click on the Search button, you access the Multiple Selection Lookup Window, from which you can select one or more collections. If you click on the Action button, you access the Multiple Product Collection Selection window.

Include ObsoleteTo include obsolete products (defined on the Settings tab of the Product file), check the box. Otherwise, leave the box blank.

Include Zero QuantityTo include products with zero quantity-on-hand and zero quantity-on-PO, check the box. Otherwise, leave the box blank.

Zero quantity refers to both quantity-on-hand and net PO quantity.

Discountable OnlyTo include products flagged as discountable in the Product file, check the box. Otherwise, leave the box blank.

This field is active only for Adjustment type PP - Promotional price.

Product Type

Change District PriceThis field is active for Adjustment types PP (promotional price) and SP (selling price) only. To activate the District field, check the box. Otherwise, leave the box blank.

DistrictThis field is active for Adjustment types PP (promotional price) and SP (selling price) only. To access this field, a check must appear in the box at the Change District Price field.

Enter the district whose products, specified in the Product Subsidiary Regional file, you want to adjust. If you click on the Search button, you access the Regional Read-Only Lookup window, from which you can make a choice. The system updates the Product Subsidiary Regional record for each product in the specified district.

The system updates district pricing only if the previous two fields are populated. Therefore, if a district price exists for a product included in an adjustment, the district price always takes precedence over the product promotional price. The district price does not reflect any promotional or price adjustment. The system uses the following hierarchy:

1. Use price from pricing matrix

2. Use district promotional price

3. Use product promotional price

4. Use price from warehouse inventory

5. Use district standard price

6. Use product standard price

Date to LoadEnter the future date on which you want to load the product adjustments specified for this adjustment code. The system loads the adjustments during your day-ending process on the specified date. Otherwise, leave the field blank. To load the adjustments immediately, click on the Actions button and select Load Adjustments from the menu that appears.

Starting DateThis field is active only if you specify PP (promotional price) at the Type field. Enter the starting date of the range in which you want to apply promotional pricing to the selected products. The date must be greater than or equal to the current date.

Ending DateThis field is active only if you specify PP (promotional price) at the Type field. Enter the ending date of the range in which you want to apply promotional pricing to the selected products. The date must fall after the starting date.

Commission PercentThis field is active only if you specify PP (promotional price) at the Type field. Enter the percent of commission to be calculated if no individual Price/Spiff/Commission table exists for the product. The system updates the Promotional Pricing fields in the Product and Product Subsidiary Regional files.

Spiff AmountThis field is active only if you specify PP (promotional price) at the Type field. Enter the Spiff amount to be used if no individual Price/Spiff/Commission table exists for the product. The system updates the Promotional Pricing fields in the Product and Product Subsidiary Regional files.

Adjustments

After you use the General tab to specify the products you want to adjust, use this tab to specify the adjustment you want to apply to the selected products. For the products whose prices you adjust here, the system updates the following fields on the Pricing tab of the Product file record:

• Promotion Code

• Sale Starting Date

• Sale Ending Date

• Promotion Selling Price

TypeTo identify the number in the Discount Factor field as a dollar amount, select Dollars. To identify the number in the Discount Factor field as a percentage, select Percent. For example, if you select Percent at the Type field and enter 15.00 in the Percentage field, the system discounts the regular selling price by 15 percent.

Percentage/AmountThe name and function of this field is determined by the response in the Type field. The default response is zero.

If you specify Percentage at the Type field, the system names this field "Percentage" and you use it to specify the percentage amount by which you want to adjust the product price. If you specify Dollar at the Type field, the system names this field "Amount" and you use it to specify the dollar amount by which you want to adjust the product price.

DirectionUse this field to specify whether to add (Increase) or subtract (Decrease) your adjustment from the Basis. The default is Increase.
 

Rounding Method

Round toEnter the dollar amount you want to use (along with the Rounding Method) to determine the format of the sale price. For example, if you enter 4.99 in this field and selecting Up in the Rounding Method field, the system rounds each sale price to the next highest number that ends in 4.99. That is, a sale price calculated by the system as $24.31 would be changed to $24.99. If you enter .99 in this field and select either Down or Nearest in the Rounding Method field, the $24.31 price would be lowered to $23.99.

Basis

For information on loading adjustments, view the topic on Product Adjustments - Actions.

Products

After you use the Adjustments tab to specify the adjustments you want to make to product prices, use this tab to load into the grid the products whose prices you want to adjust. To mass-update multiple products at once (for example, products from a vendor), use the General tab to specify the products, then click on the Actions button at the bottom of this tab and select Load Products from the menu that appears. To add individual products to the grid, use the Product field described below.  

Important Pricing for soft kit A kit with fewer selling and stocking restrictions than a hard kit, allowing you to treat the components as individual line items. For example, STORIS allows partial shipments of soft kits. masters cannot be adjusted using this process. Promotional pricing is not permitted with products designated as soft kit A group of stock products organized into a set so as to be sold as a package or suite. In STORIS, you can create hard or soft kits. masters.

ProductEnter the code of, or select from the grid, the product you want to change. If you click on the Search button, you access the Search for a Product screen, which you can use to search for and select products and/or create a list of products to be changed.

A counter next to the Product field indicates a product list is currently active. The counter indicates which record in the list is currently being edited and the total number of records in the list.  

BasisThe amount on which the calculation is based appears.

CurrentThe current price or cost appears. Note that if no promotion is currently active, this field is blank.  

Adjusted  The adjusted price or cost appears. If you specify an existing product, the adjusted price or cost appears from the grid. If you are adding a new product not yet selected, the system calculates and displays the adjusted price or cost. You can override the calculated adjusted price or cost manually. The  amount you enter must be greater than zero.

Import/Export

Use this tab to import or export product adjustment data to or from Excel®.

PathThe standard PC path for all STORIS exports appears. You cannot edit this field.   

File NameEnter the name of the file you want to import or export. STORIS provides a default filename to use if you want to.