SAP Knowledge Base Article - Public

2685277 - Project Cost and Revenue by Project Report does not show General Ledger Accounts of type Cost and Revenue with Transaction Amount Zero.

Symptom

  •  You run the report Project Cost and Revenue by Project and you notice that only General Ledger accounts of type Cost and Revenue with a transaction amount are visible.
  •  You want all General Ledger accounts of type Cost and Revenue independent of their value to show in the report.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Project Management work centre.
  2. Go to the Reports view.
  3. Go to the List sub view.
  4. Search and select the report Project Cost and Revenue by Project.
  5. Select the button Click here to start the report.
  6. Under the Selection tab, select Selection: Budgeting-Project Budgeting.
  7. Under the View tab, select View: Budgeting-Project Budgeting.


Only G/L accounts of type Cost and Revenue with a transaction/posting show. G/L accounts of type Cost and Revenue with zero amount do not show.

Resolution

This is the normal system behaviour for this report.

  • In the report Project Cost and Revenue by Project, only G/L accounts of type Cost and Revenue for which there exists a posting that uses the project task and is in the given period are shown.
  • If for an account, the debit and credit value balances to zero (for example: debit transaction equal 100 and credit transaction equals 100), the account will show in the report if the setting Apply Suppression to Key Figure Group box is ticked. But, if the setting Apply Suppression to Key Figure Group box is unticked, the account will not show in the report.

To see the box, Apply Suppression to Key Figure Group

  1. Go to Key Figure.
  2. Select Key Figure Settings.
  3.  Select the General tab.
  • It is not possible to show all G/L accounts of type Cost and Revenue for which there is no transaction/posting.

Keywords

Project Cost and Revenue by Project Report, General Ledger Account in Project Cost and Revenue by Project Report, General Ledger Account of Type Cost and Revenue. , KBA , SRD-FIN-ANA , Analytics Content , Problem

Product

SAP Business ByDesign all versions