SAP Knowledge Base Article - Public

3681628 - Sales Accruals Report Displays Manual Customer Invoice

Symptom

The Sales Accruals report displays manual customer invoices which are not related to any sales order and not subject to revenue-recognition appears in the list.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Cost and Revenue work center.
  2. Go to the Reports view.
  3. Select the Sales Accruals report.
  4. Select the relevant parameters.
  5. Notice, manual customer invoice(s) (that are not linked to any sales document item and are not revenue recognition relevant) appear in the Sales Accruals report.

Cause

The manually created customer invoices were posted to a balance-sheet account, such as an OLIAB-Other Liabilities account, specified in the Revenue Assignment tab. 

Because any source document posted to a balance-sheet account is treated by the system as an accrual entry, these invoices are automatically included in the Sales Accruals report, even though they are not subject to revenue recognition. 

To verify the G/L account follow the below steps:

1. Find out which G/L account is used for the posting: 

  1. Go to the Customer Invoice work center.
  2. Go to the Invoice Documents view.
  3. Search and select the open invoice XXX (XXX refers to Invoice ID).
  4. Click View All and go to Items tab, select the Line Item and move to Revenue Assignment sub tab.
  5. Notice the accounted account determination group ABC (associated with G/L account DEF) (ABC represents the account determination group selected, DEF represents the G/L account ID assigned to it). 

2. Find out the G/L account type: 

  1. Go to the Business configuration work center and access the Charts of Accounts, Financial Reporting Structures, Account Determination fine-tune activity. 
  2. Here, choose Edit Chart of Accounts. 
  3. Find G/L account DEF and notice the G/L account type, for example OLIAB-Other Liabilities. 

Resolution

Any source document accounted to a balance sheet account will appear in the sales accruals report. This report lists all sales relevant balance sheet postings. 

See Also

Sales Accruals | SAP Help Portal

Keywords

manual invoice, sales accruals, balance sheet, revenue recognition , KBA , SRD-FIN-COR , Cost & Revenue , Problem

Product

SAP Business ByDesign all versions