Setting up the RT to Journal Integrations

The RT to Journal Integrations between Revenue Management and Accounting allow you to create Accounting journals for revenue and cost amounts on committed recognition transactions. There are dependencies between the two integrations, so if you enable one you must also enable the other. For more information about these integrations, see RT to Journal Integrations Overview.

To set up the RT to Journal Integrations you must enable the following Feature Console features in the order specified:

  1. Accounting - Journal Integration with Return Data. This feature creates publications and subscriptions required by Revenue Management's RT to Journal Integration features and adds required journal types to Accounting. For details, see Enabling the Journal Integration with Return Data.
  2. Revenue Management - RT to Journal Integration. This feature creates publications and subscriptions to connect with those created by the Journal Integration with Return Data feature. It also creates fields and permissions used when creating journals for either revenue or cost. Therefore you must enable this feature even if you only intend creating cost journals. For details, see Enabling the RT to Journal Integration.
  3. Revenue Management - RT to Journal Integration for Cost. This feature extends the RT to Journal Integration feature to support cost journals. You must enable this feature even if you do not intend creating cost journals because it is required for validation. For details, see Enabling the RT to Journal Integration for Cost.

If you are upgrading and your org is configured with a custom solution for creating journals from recognition transactions (such as ClickLink), deactivate your custom solution when the RT to Journal Integrations are set up.

Note:

Make sure the Override Currency Values on Journal Line field in the Accounting Settings custom setting is selected. This is required to allow Revenue Management to pass Document Rate and Dual Rate values to the journal line items.

Recognition Transactions Must Be Grouped by Company

In the FFA subscription to the Journal.Create message type, the mappings for Journal Currency and Period are resolved in relation to Company. Therefore it is imperative that recognition transactions are grouped by a field that identifies a source record's company.

  • If you intend creating recognition transactions using the Recognize Schedules process, the recognition settings records for your source objects must have Company mapped to a field that identifies a source record's company.
  • If you intend creating recognition transactions using Recognize All, the recognition settings records for your primary source objects must have Grouped By mapped to a field that identifies a source record's company.
  • If you intend creating recognition transactions from the Recognize Revenue page, the RM Grouped Transactions feature in Feature Console must be enabled, and you must group your source data on the Recognize Revenue page by a field that identifies a source record's company.

The process to create journals will fail if the correct company cannot be identified on recognition transactions.