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
- Open the Customer Invoicing work center.
- Find the Invoice Documents view.
- Open Customer Invoice ABC (Where ABC Represents the Customer Invoice ID).
- 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:
- Go to Audit work center.
- Open the View Exchange Rates Task.
- Click the View Exchange Rate History button.
- 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:
- Go to the Sales Orders work center.
- Open the Sales Orders view.
- Find Sales Order JKL (Where JKL represents the Sales Order ID).
- Edit the document and click View All.
- 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