Symptom
You run the Project Cost and Revenue Details by Project report in the Cost and revenue workcenter.
When checking the revenue details view you notice that the Actual Entry Quantity is doubled.
Environment
SAP Business ByDesign
Reproducing the Issue
- In the Cost and Revenue workcenter go to the Reports - List view.
- Find the Project Cost and Revenue Details by Project report.
- In the View field select Revenue Details.
- Filter for the Customer Project in question.
- Sort the Key figures to show
- Actual Entry Quantity
- Total Invoiced Revenue
- Total Invoiced Revenue Quantity - You notice that the Actual Entry Quantity is double the amount of the Invoiced Revenue Quantity.
Cause
The Actual Entry Quantity figure is based on the Business Transaction Types involved in all quantities posted for the Customer Project.
It displays
- the Business Transaction type resulting in the invoiced Revenue, the quantity invoiced to the Customer in the Customer Invoice.
- the Business Transaction to create the Actual entry quantity, meaning the incurred quantity from Internal Service confirmations, External Service Confirmations, Supplier Invoices or any further expense related to the Project.
- the Business Transaction to display the Expense Assignment to Sales Document (the unassigned and assigned amounts and quantities usually clear to 0,00).
Resolution
Add the Business Transaction Type characteristic to the Rows.
You will now notice all business transactions documenting any transactions of quantities, such as
- Customer Invoice to display the Invoiced Quantity
- Project Expenses, such as Internal Service Confirmations to display the reported quantities
- Expense Assignment to Sales Documents to displays the project expense quantities assigned to the respective sales document item.
You can add further characteristics such as Sales Order and Sales Order item to compare the assigned and unassigned quantities and amounts.
Keywords
Project Cost and Revenue Details by Project, Actual Entry Quantity, Projectkosten und - erlöse nach Projekt, Tatsächliche Erfassungsmenge , KBA , SRD-FIN-COR , Cost & Revenue , Problem