You are using a report for Project Cost and Revenue and are not sure of how is the value of Remaining Planned Cost field calculated.
SAP Business ByDesign
Reproducing the Issue
- Go to the Business Analytics work center.
- Go to the Design Reports view.
- Search and open any report for Project Cost and Revenue (this applies to FINCACU04_Q0001, FINCACU04_Q0002, FINCACU04_Q0003 or FINCACU04_Q0004).
- Provide the Selection Criteria.
- Click on Go.
You are not sure about how is the value for Remaining Planned Cost calculated.
The field calculates the Remaining Planned Cost based on the Remaining Quantity you can find under Products tab of the respective project.
For example Project ABC has the product XYZ assigned under Products tab (ABC corresponds to the Project ID and XYZ to the Product ID).
If there is 50h of Planned Quantity, however Actual Quantity is 5h, this will result on 45h of Remaining Quantity.
If we open product XYZ and go to Valuation tab, for the respective company and set of books, we can find the Cost Rate. Let's assume the Cost Rate is 50 USD / h.
If we multiply the Planned Quantity with the Cost Rate, we have 50 * 50 = 2500 USD, this is the Planned Cost.
Now we do the same for Remaining Quantity: 45 * 50 = 2250 USD, which is the Remaining Planned Cost.
Project, Cost and Revenue, report, planned cost, Remaining Planned Cost , KBA , AP-ACC , Business ByDesign: Financial Accounting , How To