SAP Knowledge Base Article - Public

1309744 - The switch +/ - Sign is not applied to the analytics reports

Symptom

In the Financial Statement report the Income from Operations values and all other income values, such as Net Revenue, Gross Revenue, Operating Profit and Gross Profit, are displayed negatively while all Cost of Goods Sold values show a positive figure.  
The expectation is that if the Switch +/-Sign field is ticked for the financial reporting structure item, it should reverse the sign of the respective amount in the financial statement report.

Reproducing the Issue

Viewing the report:

  1. In the General Ledger workcenter navigate to the Report view 
  2. Choose the Financial Statements report
  3. In the Edit Selection tab select the respective financial reporting structure and click Go.  
  4. You notice that the Income from Operations values on the report, and, in fact, all other income values (such as Net Revenue, Gross profit etc.) are displayed negative, and that all Cost of Goods Sold values are positive.
  5. But you expected them to appear the other way around as you have ticket the Switch +/- sign box for these items in the financial reporting structure:

Financial Reporting Structure Settings:

  1. Navigate to the Business Configuration workcenter and there to the Implementation Projects view and open the Activity List.
  2. Choose the Fine-Tune phase and find the activity Charts of Accounts, Financial Reporting Structures, Account Determination.
  3. Open this activity and then choose Edit financial reporting structures.
  4. Select a structure of type Income Statement and click Edit or View.
  5. For all income related items, such as Operating Profit, Gross Profit, Net Revenue or Gross Revenue you tick the box in the Switch +/-Sign column.
  6. Click OK and then Save and Close.
  7. The expectation is that in the Financial Statement report all income related items are displayed positively and all cost related items are displayed negatively.
  8. Instead, the setting has no influence on the figures in the report.

Cause

The Switch +/- Sign feature is not available in analytical reports but is only intended for Statutory Reports.

Resolution

  1. In the General Ledger workcenter navigate to the Periodic Tasks view and select the subview Statutory Reports.
  2. To create an income statement report click on the link Balance Sheet and Income Statement report.
  3. Here you can create your report according to your own requirements.

Keywords

KBA , SRD-MD-OM , Organizational Management , How To

Product

SAP Business ByDesign all versions