SAP Knowledge Base Article - Public

2941020 - Unexpected Value in Customer Invoice Resulting from Currency Conversion

Symptom

When Invoicing a Sales Order, you expect the Net Price of your Customer Invoice to take the Currency Conversion value of the Customer Invoice's Posting Date, but this is not happening.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Open the Customer Invoicing work center.
  2. Find the Invoice Documents view.
  3. Open Customer Invoice ABC (Where ABC Represents the Customer Invoice ID).
  4. Edit the document and click View All.

You see that the Posting Date for this document is DD.MM.AAAA and the Net Price for a Product is GHI. However, when checking the Exchange Rate History:

  1. Go to Audit work center.
  2. Open the View Exchange Rates Task.
  3. Click the View Exchange Rate History button.
  4. For Date DD.MM.AAAA, you see that the value does not match the one used in the Currency Conversion of Product GHI.

(DD.MM.AAAA Represents the Posting Date).
(GHI Represents the Product ID in the Customer Invoice).

Cause

This happens because the Currency Conversion happens based on the Pricing Date of the Sales Order, rather than the Posting Date of the Customer Invoice. You can check the Pricing Date in the Sales Order by following these steps:

  1. Go to the Sales Orders work center.
  2. Open the Sales Orders view.
  3. Find Sales Order JKL (Where JKL represents the Sales Order ID).
  4. Edit the document and click View All.
  5. Navigate to the Pricing and Invoicing tab.

There you will be able to see the field Pricing Date.

Resolution

This is the expected system behaviour.

An alternative option may be to check the SAP Business ByDesign Influence Platform to submit an idea:.

See Also

2827196 - Customer Invoice Total Value does Not Match with Service Order Total Value.

Keywords

Sales Order, Customer Invoice, Pricing Date, Posting Date, Exchange Rate , KBA , AP-CI-CI , Customer Invoice , How To

Product

SAP Business ByDesign all versions