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 PDW 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 Price Sheet Scan 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 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 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 option to select a different effective date or to assign a new effective date.

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 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.
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.

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.
Set All Last Dts	Copies the selected date in the Last Effective Datecolumn to all Last Effective Dateentries.
Set All Load Dts	Copies the selected date in the Load Effective Date column to all 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.