Symptom
You have created one invoice XYZ (XYZ represents the supplier invoice ID) with currency ABC, and your company currency is DEF.
You would like to know how the value of field Net Amount in Company Currency on report Monitoring Invoices is generated.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Supplier Invoicing Work Center.
- Go to Report - List View.
- Open report Monitoring Invoices.
- Enable the key figure Net Amount in Company Currency, and enter invoice XYZ.
- Display Currency - Conversion Date as Today.
- You find the outcome value is not using the valid exchange rate of today.
- You would like to know how the exchange rate of this field is determined and how the value of this field is generated.
Cause
- Go to General Ledger Work Center.
- Go to Edit Exchange Rates View under Common Tasks.
- Click View Exchange Rates History button.
- Search Source Currency - ABC, Target Currency - DEF.
- Sort Ascending for field Created On.
- Locate the latest created record with valid from date before the posting date of invoice XYZ.
- Here you will find the Ask Rate as the correct exchange rate for this field.
Resolution
This is current system design. System will always locate the latest valid exchange rate for the posting date of the invoice.
Keywords
Net Amount in Company Currency, Monitoring Invoices, Currency, Conversion Date, Exchange Rate , KBA , SRD-SRM-SI , Supplier Invoicing , Problem
Product
SAP Business ByDesign all versions