SAP Knowledge Base Article - Public

2464846 - Net Value Showing in Different Currency in Sales Order Item Data Source and Sales Order Document or Customer Invoice Item Data Source and Invoice Document

Symptom

Currency maintained in the Sales Order Item data source and in the sales order document are different for the field Net Value.

or

Currency maintained in the Customer Invoice Item data source and in the Invoice document are different for the field Net Value.

Environment

SAP Business  ByDesign

Reproducing the Issue

This applies to both the Sales Order Item data source and the Customer Invoice Item data source. We will use Sales Orders as an example.

  1. Go to the Sales Orders work center.
  2. Select the Sales Orders view.
  3. Open the sales order XYZ (XYZ represents the sales order ID).
  4. Naviagte to the Items tabs.
  5. The Net Value currency is ABC (ABC represents the currency in the sales order document).

 

  1. Go to the Business Analytics work center.
  2. Select the Design Data Sources view.
  3. Open the Sales Order Item report.
  4. Select the sales order XYZ.
  5. Net Value currency is DEF (DEF represents the currency in the report).

Cause

In the report the Net Value key figure always fetch the currency based on the country of the company.

Resolution

To fetch the same currency in the data source select the field Net Value (Transaction Currency) instead of Net Value.

Keywords

CRMCIVIB; CRMCIVIB_Q0001; Invoice Volume; Sales Oder Volume; Data Source; CRMSLOIB_Q0001; CRMSLOIB; , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions