Viewing and Editing Price Sheets in Product Pricing

All the products in a price line typically experience price changes as a group. Maintain a record of the old prices and retain the prices on previous dates by creating a new effective date for the price sheet, instead of overwriting and losing the old prices. When you enter a new price sheet for a product, the system inserts the row at the top of the window. So, the most recent effective price sheet displays first.

Each price sheet can have any number of effective dates. For example the price sheet DEL~ has three price sheets on file, one each for effective dates 01/01/06, 01/01/08, and 01/01/09. On each effective date the system starts to use the price sheet with that date's cost and prices. You can retain price sheets with expired effective dates for up to 999 days.

You must have the NONSTOCK authorization key to access the Product Price Sheet Maintenance window for a nonstock.

To create a new effective date or edit an existing effective date on a price sheet:

From the Maintenance menu select Product to display the Product Maintenance window.

In the Product field enter a product ID to display the product record.

Select Pricing > Product Price Maintenance to display the Product Price Maintenance dialog box.

Select Pricing > Price Sheet to display the Price Sheet Maintenance dialog box.

The system displays all price sheets assigned to this product and determines the columns to display based on the settings in Price Line Maintenance.

Note: If the UOM or Per Qty rows are blank, the row inherits the values from the previous (earlier) price sheet. If your cursor is on the blank row, the Per UM and Per Qty display in the status bar.

Adjust information in the cost columns, as needed, for the current price sheet associated with this product.

To edit effective dates for the price sheet, select Edit > Effective Dates to display the Price Line Dates dialog box and complete the following fields:

Field

Description

Purge Age (days)

Enter the number of days to retain the effective date list before it is purged (up to 999 days). The default is 365 days.

Effective

Do one of the following:

To create a new effective date for this price sheet, select the first blank line of the Effective column, and enter the new date.
To edit an effective date, select the date you want to change, and enter the new date.
The columns to the right of the Currency field on the Product Price Sheet dialog box are used to assign and display the values for the cost or price bases for the product that go into effect on the displayed date.

Since replacement cost is typically the cost assigned by the system to a product on a purchase order, every time there is a price change by a vendor, update the replacement cost so that the next time you purchase the product, the correct cost displays on the purchase order.
- If you have entered prices in advance of the actual effective date, the system uses the costs and prices associated with the current effective date, unless overridden, until the date with the new costs and prices arrives.
- If a cost or price is missing from the current effective date, the system uses the values on the previous effective date.
- If you make a change to information on this window, the system displays a Reason for Change prompt where you can enter why you made the change. If you supply a reason, it will follow the Eclipse supplied log comment on the Maintenance Log Viewing window.

Note: To delete old price sheet formulas in the Eclipse Product File use the Rebuild Price Sheet/Discount Class Cache Utility. For example, if a vendor gives you disks with new price sheets and discount classes, run this utility to delete the old price sheets and discount classes in your Eclipse Product File.