Manually Updating Prices

Each time you receive new pricing data for a price line, assign a new effective date to the price sheet to create a new price sheet to store with previous price sheets for the price line.

Use a calculation basis and a formula to calculate the prices or costs for a basis on a price sheet. Then manually enter prices into the system.

To verify that calculation bases, formulas, and prices are calculating the end prices correctly, view the new price sheet in the product file.

This topic contains the following procedures:

Entering bases and formulas to determine the calculation for final costs and prices.
Entering prices manually on the update window.
Viewing price sheets for products.

Important: Pressing Enter in the Price Sheet Entry/Update window causes dependent costs to update. That is, when the cursor moves right after pressing Enter, the cost on the newly highlighted cell updates. If you move the cursor down, the entire row is updated.

Use the Tab key and the arrow keys to move your cursor through the table without updating.

To set up a price sheet for update:

From the Maintenance > Price Maintenance menu, select Price Sheet Entry to display the Price Sheet Entry window.

In the PriceLine field, enter the price line ID and select the price sheet and discount class.
Select one of the following:

New/Change - To enter the new effective date.
An existing effective date - To display a price sheet.

In the Price Change Variance Checking area, enter the percentage limits for the high and low end for this price sheet in the fields provided. Example

For example, a vendor's prices are increasing 5 percent. To help avoid making errors, set the Variance % low end to 0% and the high end to 6%. When entering prices with these settings in the Price Sheet Entry/Update dialog box, you accidentally enter a price that is 7 percent higher than the previous price. The system warns that you have exceeded the variance allowed. At that point you can double check the price you entered, or you can press any key to accept the price and continue.

In the Calculation Basis field, enter the action for each basis name listed:

Options	Descriptions
ENTER	Displays this basis name as a column heading on the Price Sheet Entry/Update window, where you manually assign a new value to that basis name, for example: In the Calculation Basis field for LIST, type enter. Select File >Enter Prices to display the Price Sheet Entry/Update dialog box. In the LIST column, update the prices as listed on the vendor's price sheet. Note: You are not required to enter a formula for basis names with a calculation basis of ENTER, because you manually enter prices for these basis names.
PREVIOUS	The system checks each of the price sheet's effective dates beginning with the most recent, and applies the formula and the basis name for the most recent price sheet that contains a value.
NO UPDATE	The formula and the basis name for the new effective date remain the same as on the previous effective date. If the previous price sheet contains a null entry, when a price search is in process for a product, the system checks the price sheets beginning with the most recent effective date, and applies the price from the most recent effective date that contains a value.
Basis name	Enter one of the following: A basis name that is different from that entered in the Basis Names column, but is associated with this price line. This entry includes the added basis name's formula in the value. For example, a price sheet from a vendor shows that all REP-COSTS are increasing, and lists the individual price changes. You want to calculate your LIST price from the vendor's REP-COST for the products in this price line. The same basis name as the basis name in the Basis Names column. This entry takes the basis name times 1 (*1).

In the Formula field, enter the formula you want the system to use with the entry in the Calculation Basis field to calculate the selling price.
In the Round-To field, enter the number of decimal places for rounding cents. Valid entries are 0 to 3; 0 does not round cents, 1 rounds to a hundredth, 2 rounds to whole cents, 3 rounds to the tenth of a cent.
Select the Display check box to display this basis name in the Price Sheet Entry/Update dialog box. otherwise leave it unchecked.

This field is active only for lines with PREVIOUS, NO UPDATE and basis name entries in the Calculation Basis column. If you leave the box unchecked for PREVIOUS, or NO UPDATE, entries in the Calculation Basis column are calculated but do not display in the update dialog box.

Save your changes and exit the dialog box.

To enter prices on the update window:

Set up the price sheet for update.

Note: You must be assigned the PRICE.SHEET.UPDATEauthorization key to edit prices.

Select File >Enter Prices on the Price Sheet Entry window to display the Price Sheet Entry/Update dialog box. The following information displays:

The view-only Status and UM columns display the product's status and unit of measure.
The basis name column headings on the right side of the dialog box are defined by the entries in the Calculation Basis and Display fields on the Price Sheet Entry window, described above.
Select Views > Expanded to add the following columns to the table.

Sort Code - Assigned to the product in Product Maintenance.
Product ID - Assigned to the product in Product Maintenance.
Product Sequence - Determined by the product ID sequence.

To sort the items by any of the column headings, right-click on the table heading and select the intended sort method. For example, to sort the list to display the items with the smallest LIST price first, right-click on the LIST table heading, and select Sort By Descending.
In each basis name column (for example, LIST and REP-COST), enter the vendor's price for each product.
Save and exit the dialog box when finished entering prices to update the prices.

To view price sheets for products:

From the Maintenance menu, select Product to display the Product Maintenance window.
Select Pricing > ProductPriceMaintenance to display the Product Price Maintenance dialog box.

Price sheets display in the columns in consecutive order starting with the most recent.

Save your changes and exit the dialog box.