Create Standalone Selling Prices Using a Spreadsheet

This example shows you how to manually upload new standalone selling prices to Revenue Management.

The following steps are covered in this example:

• Downloading the Create Standalone Selling Prices spreadsheet.

• Entering standalone selling prices for the item, item group, memo line, or performance obligation template.

• Uploading the entered standalone selling prices into Revenue Management.

• Verifying that the uploaded standalone selling prices are registered in the application using the Manage Standalone Selling Prices spreadsheet.

Create Standalone Selling Prices

Your company has just launched a new hardware product in August 2016. The product is targeted at only large and medium enterprise customers in the US market. The product has never been available to the general public before and therefore, there are no standalone selling prices. No other competitors sell similar or comparable products. The revenue manager has worked with the sales director who owns this product and the internal compliance team and obtained an approved selling price list on August 14, 2016.

Tools

Spreadsheet	Use
Create Standalone Selling Prices	Enables you to enter standalone selling prices directly into Revenue Management. The spreadsheet facilitates data entry by populating the list of items, item groups, memo lines, and performance obligation templates defined for a selected Standalone Selling Price Profile.
Manage Standalone Selling Prices	Enables you to query existing established standalone selling prices in Revenue Management. You can also update standalone selling prices directly using this spreadsheet if the standalone selling prices aren't yet being used in the revenue recognition process. Note: You can update standalone selling prices only if they were uploaded through the Create Standalone Selling Prices spreadsheet. Observed standalone selling prices can't be updated in this spreadsheet. Observed standalone selling prices are standalone selling prices that were calculated by the Calculate Observed Standalone Selling Prices process.

Note: It is assumed that the standalone selling prices were approved offline before uploading.

1. On the Setup and Maintenance page, enter Define Observed and Estimated Standalone Selling Prices in the Search field and click the Search icon.

2. Click the Define Observed and Estimated Standalone Selling Prices link.

3. Click the Manage Standalone Selling Price Profiles link.

4. On the Manage Standalone Selling Price Profiles page, enter Hardware Business in the Name field and click Search.

5. Click the Hardware Business link in the Search Results table.

6. On the Edit Standalone selling Price Profile page, scroll down to the Assignments section and select the first item in the search results table.

7. Click the Create SSP button.

8. On the Create Standalone Selling Prices popup window, enter the current period for the Effective Period, and USD as the Default Currency.

9. Click Save and then click Open.

10. Enter user name and password.

11. On the Create Standalone Selling Prices spreadsheet, notice that the application has populated the Item ID, description, and other relevant information. Enter all required information and any additional information in the optional columns, such as the unit of measure or pricing dimension.

12. Once completed, click Create SSP and click Upload. Note that you may be prompted to reenter your user name and password again if you work on the spreadsheet for too long.

13. In the Upload Options dialog box, accept the default option and click OK.

14. Verify the status of the standalone selling price for each row in the Status column to confirm that each row was inserted successfully.

15. Verify the standalone selling prices you have uploaded using the Manage Standalone Selling Prices in Spreadsheet task.