SAP Knowledge Base Article - Public

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

Symptom

  • Customer sales project ABC is closed. All associated sales order items have been completed for invoicing. 
  • In Financials a final delivery or invoice date is set (Cost and Revenue > Sales Document Items > Dates tab. 
  • The revenue recognition run realises revenue on account XYZ (XYZ represents a G/L account ID) for project ABC (ABC represent the project ID). 

But you expect the revenue to be posted to account DEF instead (DEF 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 ABC. 
  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 during the final clearing, after the project is closed and associated sales order items are completed, the revenue recognition run realises revenue on account XYZ. 

Cause

There are customer invoices created with a different revenue assignment.

In the project invoice request, under Step 5 – Refine Invoice Items, an account determination group linked to G/L account XYZ is maintained. This manual setting overrides the account determination derived from the customer assigned to the related sales order.

To verify this: 

  1. Open the Sales Document - Line Items report and identify the customer invoices created for the project.
    You will notice G/L account (origin) XYZ.
  2. Open one of the invoices, for example via the Journal Entry ID.
  3. In the Items tab, open the Revenue Assignment sub-tab.
    Here, you can see account determination group X-XXXX assigned.

To verify the corresponding G/L account assignment:

  1. Go to Fine Tuning → Charts of Accounts, Financial Reporting Structures, Account Determination.
  2. Select Account Determination and choose Sales.
  3. Open the Other Income tab.
    Since the revenue account was manually specified in the invoice request, the revenue is treated as Other Income.
  4. Locate account determination group X-XXXX in the Account Determination Group: Other Income column.
  5. In the corresponding Other Income column, you will find G/L account XYZ assigned.
  • As long as the customer project remains open and the related sales order items are not completed for invoicing, the revenue recognition run continues to recognize revenue using the standard G/L account (DEF) derived from the account determination group maintained for the customer.

  • During final clearing, however, once the project is closed and all related sales order items are completed for invoicing,  the revenue recognition run always aligns revenue with the actual customer invoices. Therefore, if a different G/L account was specified in the invoice, the revenue is transferred from the standard G/L account (DEF) to the G/L account maintained in the invoice (XYZ). 

Resolution

The system works as designed: Upon final clearing, the revenue recognition run aligns the revenue postings with the actual customer invoices and transfers the revenue to G/L account XYZ, as maintained in the invoice/s. 

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