SAP Knowledge Base Article - Public

3737479 - Sales Accruals Report Does not Show any Deferred Revenue when filtering by Sales Document ID

Symptom

  • Sales Accruals report shows no (zero) deferred revenue when searching by Sales Document ID.
  • Deferred revenue exists for the relevant sales orders when the report is run with other selection criteria (for example, by G/L account or broader filters).
  • No error messages are displayed.

Environment

  • Product: SAP Business ByDesign
  • Cost & Revenue

Reproducing the Issue

  1. Open the Cost and Revenue work center and navigate to Reports > Sales Accruals.
  2. Run the report with a broad selection (for example, include the deferred revenue G/L account) and verify that deferred revenue appears for certain sales orders.
  3. Return to the report selection and filter specifically by Sales Document ID for one of those sales orders.
  4. Observe that the deferred revenue for that sales order now appears as zero.

Cause

  • The Sales Document ID selection attribute retrieves postings from the sales documents that actually created the revenue.
  • When revenue is not created through the sales order itself, filtering by Sales Document ID returns no deferred revenue for that sales order, resulting in a zero value.

Resolution

  1. In the Sales Accruals report, open the selection screen.
  2. Instead of using Sales Document ID, use the selection attributes “Associated Sales Order” and/or “Associated Sales Order and Item”.
  3. Run the report with these associated attributes to include all postings linked to the sales order, ensuring deferred revenue is displayed.
  4. Optionally verify which subsequent document (for example, invoice or confirmation) created the revenue to understand posting origins.

See Also

refer to: Business ByDesign community topic

Keywords

sales accruals report, deferred revenue, zero deferred revenue, sales document id, associated sales order, associated sales order and item, revenue recognition, cost & revenue, report filter, posting origin, analysis by sales order, report selection issue, revenue postings, filter returns zero, bydesign reports , KBA , SRD-FIN-COR , Cost & Revenue , Problem

Product

SAP Business ByDesign all versions