SAP Knowledge Base Article - Public

3472218 - Revenue Recognition run Realises Revenue on Wrong G/L Account for Customer Sales Project

Symptom

The revenue recognition run realises revenue on account XYZ (XYZ represents a G/L account ID). 

But you expect the revenue to be posted to account ABC instead (ABC represents a G/L account ID) according to the account determination group assigned to the customer of the associated sales order and customer sales project. 

Environment

SAP Business ByDesign

Reproducing the Issue

  1. In the Cost and Revenue work center go to the Sales Document Items view.
  2. Open the Advanced search.
  3. In the Project ID field enter project ID DEF (DEF represents the project ID). 
  4. All sales order items associated with the project appear.
  5. Press Reports and choose Sales Document - Line Items for Project. 
  6. You notice that the revenue recognition run realised revenue on account XYZ. 

Cause

There is a/are customer invoice(s) created with a different revenue assignment: In the project invoice request, in step 5 - Refine Invoice Items, you maintained an account determination group associated with G/L account XYZ. This setting takes priority over the account determination assigned to the sales order's customer: 

  1. In the Sales Document - Line items report find the customer invoice(s) created for the project. You notice G/L account (origin) XYZ.
  2. Open the invoice, for example through the Journal Entry ID attribute.
  3. In the Items tab check the Revenue Assignment sub-tab.
  4. You notice account determination group X-XXXX (X-XXXX represents an account determination group ID). 

Now, to verify the assigned G/L account

  1. access the Charts of Accounts, Financial Reporting Structures, Account Determination activity in Fine Tuning.
  2. Go to Account Determination and select Sales. 
  3. Go to the Other Income tab (Due to the manual setting in the invoice the revenue is considered other income). 
  4. Find account determination group X-XXXX in the Account Determination Group: Other Income column. 
  5. In the Other Income column you find G/L account XYZ assigned. 

Resolution

The system works as designed: If you select an account determination group in the G/L account field of a project invoice request then this setting overwrites the account determination of the sales orders/projects customer. 

See Also

  3017640 - Revenue Recognition Run Realizes Revenue of Contract Item on the Wrong G/L Account 

Keywords

revenue, wrong G/L account, revenue recognition run , KBA , SRD-FIN-COR , Cost & Revenue , Problem

Product

SAP Business ByDesign all versions