SAP Knowledge Base Article - Public

3557795 - Unexpected Value in 'Amount - Not Yet Invoiced' and 'Amount - Invoiced' in Project Related Reports

Symptom

In project related reports and data sources, the 'Amount - Not Yet Invoiced', 'Amount - Invoiced', 'Amount - Invoiced (Source Document)' key figures are showing unexpected value.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Project Management Work Center.
  2. Go to Report - List View.
  3. Open Report: Customer Project Overview (PROCPIU02_Q0001) as an example.
  4. Select project ABC.
  5. Add key figure 'Amount - Not Yet Invoiced' and 'Amount - Invoiced' into the report and execute.
  6. These figures are showing unexpected value like 0.

However, the project is already invoiced with an actual amount.

Cause

Key figure 'Amount - Invoiced' and 'Amount - Invoiced (Source Document)' means the amount of expenses assigned to the project (task) in the project invoice request, not the sale order invoiced amount. 

This can be checked by below steps:

  1. Open the project invoice request associated with project ABC.
  2. Go to items tab and click on Time and Expenses subtab. 

Key figure 'Amount - Invoiced' is showing 0 value when no time and expense items are assigned here.

Key figure 'Amount - Not yet Invoiced' is calculated by below formula:

([Amount - Invoice Request] + ([Amount - Open] + [Amount - Deferred]))

means the amount of expenses assigned to the project (task) but open or deferred. It shows 0 value when the expenses are fully invoiced, or when the not invoiced expenses have no value. 

Resolution

This is the standard system behavior for data sources:

  • Customer Projects (PROCPIU02)
  • Revenue Contribution (PROCPIU03)

and the reports based on above data sources:

  • Customer Project Overview (PROCPIU02_Q0001)
  • Revenue by Team Member (PROCPIU03_Q0001)

Keywords

Project Invoiced Amount, Amount - Not Yet Invoiced,Amount - Invoiced,Project Report, Customer Project Overview , KBA , AP-PRO , Project Processing , Problem

Product

SAP Business ByDesign all versions