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
- Go to Project Management Work Center.
- Go to Report - List View.
- Open Report: Customer Project Overview (PROCPIU02_Q0001) as an example.
- Select project ABC.
- Add key figure 'Amount - Not Yet Invoiced' and 'Amount - Invoiced' into the report and execute.
- 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:
- Open the project invoice request associated with project ABC.
- 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