You run the Project Cost and revenue by Project report with a specific selection and you can see that some rows have Not Assigned (#) Project, Project task and Project Status although the respective Key figures for the like of ITD Planned Cost, ITD Incurred Cost and ITD Incurred Cost Variance are showing some amounts. You would like the reason of such behavior and where the data, behind these amounts, is coming from.
Reproducing the Issue
- Go to Home work center then open the Project Cost and revenue by Project (FINCACU04_Q0003) report.
- From the variable selection you enter the mandatory fields:
- Company: XYZ
- Set of Books: XYZ
- Accounting Period/Year: XYZ
- Project Status: Leave it empty or choose Not Assigned.
- Characteristics: Project, Project task and Project Status.
- Key Figures: ITD Planned Cost, ITD Incurred Cost and ITD Incurred Cost Variance.
With the current version the system behavior is as designed.
From the Project Cost and revenue by Project (FINCACU04_Q0003) if you clear the project status selection the report will show every transaction available on the involved data sources like FINCACB01 (Cost Center - Line Items ) and FINPRFU24 (Sales Ledger Line Items).
This means that the report will also show non project based lines (transactions). For this reason the Project, Project task and Project Status field are shown as Not assigned although the respective Key figures for the like of ITD Planned Cost, ITD Incurred Cost and ITD Incurred Cost Variance are showing some amounts.
To see the details of the transactions associated to these amounts you may open report like the Cost Centers - Line Items (FINCACU01_Q0001) or Sales Documents - Line Items (FINPRFU24_Q0001) and using the filtering on the G/L Account characteristic you’ll be able to see all the transactions details. You will also be able to see that these activities are not related to any project.
In conclusion, if you don’t want to see the transactions which are coming from cost center, sales data sources you must have the selection for the project related fields filled. For example project status = 5;2;1 (started, release & planning).
KBA , AP-PRO , Project Processing , How To