Stage 1: Filtering and Grouping Your Data

The process to recognize revenue and amortize costs can be divided into three main stages:

  1. Filtering and grouping your data.
  2. Selecting revenue to recognize and costs to amortize.
  3. Creating a revenue recognition transaction that contains one or more transaction lines.

This topic describes the first stage.

To filter and group your data

  1. Click the Recognize Revenue tab.
  2. [Optional] Select a shared recognition view from the picklist then click Load. The default view is your own working copy recognition view. See What is a Recognition View? for more information.
  3. [Optional] Select a source object tab or click the plus sign on the right to open another tab. The plus sign is not displayed if all source object tabs are already open.
  4. Review the information in the data preparation panel:

    This tells you the recognition date that staging data is already available for. Either accept this date or enter the recognition date on which to base revenue recognition calculations. The date defaults from the recognition view (if available), otherwise it defaults to today.
  5. Select a currency from the Currency picklist, or leave it at the default currency shown. Staging data will only be generated for source records using this currency. This prevents you from selecting revenue amounts in a mix of currencies.
  6. Add or remove filter criteria as required. See Filtering your Source Data for more information.
  7. [Optional] Deselect the Create Data for Parallel Reporting? checkbox to run revenue recognition on source records that are not linked to revenue contracts. Any source records that have a "Use in Revenue Contract" templateClosed A template that has the Use in Revenue Contract checkbox enabled. will be ignored. This is how revenue recognition worked in versions of Revenue Management prior to V4.1. The checkbox is deselected by default.

    Select the Create Data for Parallel Reporting? checkbox if you want to run revenue recognition for source records linked to revenue contracts for the purpose of parallel reporting. Only source records that have a "Use in Revenue Contract" template will be processed. These source records should be linked to performance obligations so that their revenue can be recognized as part of the revenue contract. See About Parallel Reporting for more information.

  8. [Optional] Apply grouping if you want to view the data in a summarized format. See Grouping your Source Data for more information about grouping.
  9. Click Generate Data. Staging data is only generated for source records that match the recognition date, currency and filter criteria. Revenue values are generated for source records linked to settings records where Revenue is included as a value type. Cost values are generated for source records linked to settings records where Cost is included as a value type.

If matching data is found, move onto Stage 2: Selecting Revenue to Recognize and Costs to Amortize. If matching data is not found, adjust your filter criteria and try again.

Note:

If high volume of data means that all matching records cannot be retrieved, a single read-only line is displayed showing the total value of all the matching records. You can select the All Records row to commit the total Recognize/Amortize This Period values without reviewing any detail.