SAP Knowledge Base Article - Public

2766793 - Revenue Recognition Error - Determination is Missing For Item Type Sales Revenue

Symptom

You execute the Revenue Recognition run. It finishes with errors for Sales Order Item XYZ-XX (XYZ-XX represents the Sales Order Item ID):

  • Cannot determine account (origin)...'
  • 'Account determination is missing for item type Sales Revenue.
  • Specify account determination in chart of accounts  and account determination profile ABC'. Column Path Sales->Revenues (Service)->Sales ...' (ABC represents the Account Determination Profile ID)

Environment

SAP Business ByDesign

Reproducing the Issue

  1. In the Cost and Revenue work center go to the Revenue Recognition Runs view.
  2. Show All Revenue Recognition Runs, find Run 'YYY' (YYY represents the Revenue Recognition Run ID of the run that finished with errors).
  3. Press Log Result.
  4. Switch to the Messages tab: Three error messages are displayed:
  • 'Cannot determine account (origin) ...'
  • 'Account determination is missing for item type Sales Revenue. Specify account determination in chart of accounts  and account determination profile ABC. Column Path Sales->Revenues (Service)->Sales ..'
  • 'Account determination missing for item type Sales Revenue.'

   5.  Navigate to the Processed with Errors tab to identify the affected Sales Order Item XYZ-XX.

Cause

The Account Determination Group assigned to the Customer associated with the Sales Order Item XYZ-XX is not maintained in the Revenue Recognition relevant Account Determination setting for Sales Revenue involving Service transactions.

A.) To identify the Customer:

  1. In  the Cost and Revenue work center go to the Revenue Recognition view.
  2. Show All Revenue Recognition Runs, find run YYY.
  3. Click on Log Result.
  4. Switch to the Processed with Errors tab.
  5. Click on the Sales Document Item ID, here XYZ-XX, to open the Sales Order overview.
  6. Here, under Account the Customer Name is visible.

B.) Determine the Account Determination Group for this particular Customer:

  1. Click on the Account Name to open the Account Master data.
  2. Press View All and navigate to the Financial Data tab.
  3. In the Payment Data sub-tab note down the Account Determination group GHI assigned to the relevant Company for which the Revenue Recognition run was executed. (GHI represents the Account Determination Group ID)

Resolution

Maintain the Account Determination Group and assign a Revenue Account to it in Fine Tuning:

  1. Go to the Business Configuration work center.
  2. Find and open the Charts of Accounts, Financial Reporting Structures, Account Determination activity (either via Overview, if your system is live, or through the Activity List of the First Implementation Project).
  3. Under Account Determination select the Sales link.
  4. In the Revenues tab select Services.
  5. Choose Add Row.
  6. Now select the Account Determination Group GHI and assign a Sales Revenue G/L Account.
  7. Press Save and Close.
  8. then, execute the Revenue Recognition Run for Sales Order XYZ again.

Keywords

Revenue Recognition Error; Account determination missing for item type Sales Revenue; Erlösabgrenzungslauf; Kontenfindung; Specify account determination in chart of accounts and account determination profile , KBA , SRD-FIN-COR , Cost & Revenue , Problem

Product

SAP Business ByDesign all versions