SAP Knowledge Base Article - Public

3572255 - Revenue Recognition Run is Posting Revenue to Wrong G/L Account for Sales Order Item

Symptom

  • The revenue recognition run is posting to GL Account ABC instead of the expected G/L account DEF for the completed sales order item XYZ-XX (ABC and DEF represents two G/L account IDs, XYZ-XX represents a sales order item ID).
  • When checking the account determination settings for Sales Revenue you notice that G/L account DEF is maintained for the used account determination group XXXX (XXX is an account determination group assigned to the customer of sales order XYZ). 

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Cost and Revenue work center.
  2. Access the Revenue Recognition Sub view.
  3. Access application log of the respective run. 
  4. In the Postings tab, you notice the revenue is posted to account ABC, even even though the customer account determination group XXXX is assigned to G/L account DEF in Fine Tuning. 

To verify the correct account determination settings, 

  1. access the customer financial master data and take note of the maintained account determination group, XXXX. 
  2. Access the Charts of Accounts, Financial Reporting Structures, Account Determination fine-tune activity.
  3. Go to Account Determination Sales.
  4. In the Revenues tab, select Services or Material and find account determination group XXXX. 
  5. Verify that G/L account DEF is assigned to this account determination group. 

Cause

Option 1: The Account Determination setting in fine tuning has changed since the revenue recognition run: 

  • The assignment of the Sales Revenue G/L account to the account determination group XXXX was changed after the customer invoice for sales order item XYZ-XX was posted.
  • The G/L account (Origin)* of the Customer Invoice posting is account ABC.
  • After the G/L account assignment, change all periodic revenue for the contract item gets posted to the newly assigned account ABC.
  • However, during the final accrual posting, after the contract item has been completed, its total net value gets transferred from the new account ABC back to the original account DEF.

Option 2: The account determination setting for the involved service/material changed: 

  • For Materials:
    • Go to the Materials view of the Inventory Valuation data and find the respective product.
    • Press Maintain Valuation Data and choose Product Specification Valuation. 
    • In the new screen press View Changes. 
  • For Services it is not possible to identify valuation data changes from the frontend. If you need assistance in finding out if there was any change on the account determination group of the involved service, please contact your Product Support team through an incident.

*To verify the G/L account (Origin) of the customer invoice open the invoices Journal Entry. 
Find the Deferred Revenue line item and check the G/L Account (Origin). This will be the account where the revenue is going to be realized with the final accrual posting. 

Resolution

  1. Either reverse the customer invoice and re-create it so it gets posted with G/L account (Origin) DEF. Then execute the revenue recognition run. 
  2. Or create a manual journal entry voucher of type 00088 - Manual Entry for Sales Documents with screen variant 633 - Man. Adjusting Entry for Sales Documents for SO item XYZ-XX where you manually debit G/L account ABC again and credit G/L account DEF.

See Also

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

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

Keywords

Revenue Recognition, wrong GL Account, Account Determination, Incorrect Posting, wrong Sales Revenue G/L account, sales order , KBA , SRD-FIN-COR , Cost & Revenue , Problem

Product

SAP Business ByDesign all versions