Verifying Price Sheets for PDW Price Updates

Use the PDW Price Update Scan Screen before you run a batch update to verify that the correct price sheets and discount classes are being used for price lines that you are updating. You want to verify the price sheets and discount classes to which a price line applies in order to make sure that the correct formula is being used in the update. From this screen, you can also view and edit the actual price sheet formulas being applied to the price line and the actual items being affected by the update.

You only need to access this screen when you are running pricing updates from Eclipse Product File Batch Update.

To verify that correct price sheets are being used:

From the Tools > Product Data Warehouse (PDW) menu, select Eclipse Product File Batch Update to display the Eclipse Product File Batch Update screen.

In the Price Line field, enter the price line you want to update.
From the File menu, select Use the Price Sheet Scan hot key to display the PDW Price Update Scan screen.
View the data in the following columns to verify the price sheets:

Column	Displayed Data
Line	The price line entered on the Eclipse Product File Batch Update screen. If an asterisk (*) is next to a price line, either the price sheet does not have an effective date or the price sheet has a calculation status of No Update. Verify that these price sheet formulas are correct. Use the Formulas hot key option to display the PDW Price Export Maintenance screen and view the price sheet formulas.
Price Sheet	The price sheet being used to update the product pricing within the price line. If this column is blank, then the default price sheet is being used.
Discount Class	If discount classes are assigned to the price sheet and product, the discount class being used.
Item Ct Count	The number of products being updated using the respective price sheet and discount class, if applicable.
Update	See step 5.
Last Effective Date	The most recent effective date for the respective price sheet. The system uses the effective date's formulas for the pricing update. Use the Effective Date hot key option to select a different effective date or to assign a new effective date.
Load Eff	The most recent effective date for the respective price sheet. The system uses the effective date's formulas for the pricing update. Enter a new date to create a new price sheet effective date. The formulas from the price sheet's last effective date is copied to the new effective date. If you select PDW Effective Date in the Date Type field in the Eclipse Product File Batch Update process, the system uses those dates to populate this field and this automatically populates the dates in the Eff Dates hot key list.

In the Update column, enter Y or N for each line item to indicate if you want the price class and sheet updated.
From the File menu, select Effective Dates Use the Eff Dates hot key to display effective dates for the price sheet based on the All Dates or Load Dates in the Date Type field in the Eclipse Product File Batch Update process.
Press Esc to save Save your changes and return to the Eclipse Product File Batch Update screen.

More Options for Verifying Price Sheets

The PDW Price Update Scan screen also offers these options.

Hot Key Menu Option	Function
Formulas	Displays the PDW Price Export Maintenance screen. Use this hot key to create an override map for the selected price line and price sheet. Note: This hot key is continually highlighted. There is no trigger to activate the highlight.
Set All Last Dts	Copies the selected date in the Last Eff Dt Last Effective Date column to all Last Eff Dt Last Effective Date entries.
Set All Load Dts	Copies the selected date in the Load Eff Dt Load Effective Date column to all Load Eff Dt Load Effective Date entries.
Report	Prints a report listing all data displayed on the PDW Price Update Scan screen.
Items	Displays the PDW Price Update Scan Items screen. Use this screen to view the associated items being updated for the selected price sheet.