Manage Standalone Selling Prices Using a Spreadsheet

This example shows you how to review and manually edit standalone selling prices in Revenue Management.

Use the Manage Standalone Selling Prices spreadsheet for the following:

• Review all standalone selling prices in a given period.

• Analyze standalone selling prices for a given item (good or service) across periods.

• Change existing standalone selling prices that were manually uploaded but aren't yet being used in the revenue recognition process.

Review and Edit Standalone Selling Prices

1. From the Revenue Management Overview page, click the Manage Standalone Selling Prices in Spreadsheet panel tab.

2. Click Yes to connect to the server.

3. Enter your user name and password.

4. In the Manage Standalone Selling Prices spreadsheet, enter the previous period as the Effective Period.

5. Click Search.

6. The search results return standalone selling prices for all items, item groups, memo lines and performance obligation templates that are already established for the given period.

   You can't make any changes to the observed standalone selling prices calculated by the Calculate Observed Standalone Selling Prices process. The User Defined column indicates if the standalone selling price was entered manually by the user or calculated by the application. You can make changes to any manually entered standalone selling prices as long as they haven't yet been used by the revenue recognition processes.

   Notice the list of all standalone selling prices for all items that have already been established.

7. Make the required changes to your standalone selling prices.

8. When you are finished, click the Manage SSP tab, then click Upload.