3633758 - How exchange rate conversion type derived in the different reports such as Monitoring Invoices and All VAT / Sales Tax Items

Exchange rate conversion type works in different reports such as,

1. Monitoring Invoices and 
2. All VAT / Sales Tax Items

SAP Business ByDesign

1. Go to Business analytics work center.
2. Go to Design reports sub view.
3. Search for the below mentioned reports,
4. Monitoring Invoices.
5. All VAT / Sales Tax Items.
6. Give the relevant Supplier invoices in the Data selection field and apply for the mentioned reports.
7. System is considering exchange rate as Ask Rate for Supplier Invoices (Report: Monitoring Invoices) and Bid Rate in the Tax Register (All VAT / Sales Tax Items).

The configuration in Currency conversion profiles is maintained as below and to check that follow the steps,

1. Go to the Business Configuration work center.
2. Go to the Overview sub view.
3. Search for the Tax on Goods and Services activity.'
4. Under Currency Conversion Type, search for the Currency conversion profiles activity. And the conversion types have been maintained according to the different transaction types.

Business Transaction Type                 Conversion Type
Supplier Invoice                                 Ask Rate
Tax Dif Posting for Summary Invoice    Bid Rate

Due to this the system is considering exchange rate as Ask Rate in Supplier invoice Journal entry and Bid Rate in the Tax Register. 

This can be corrected by following the below mentioned steps.

1. Go to Business Configuration work center.
2. Go to the Overview sub view.
3. Search for the Tax on Goods and Services activity.'
4. Under Currency Conversion Type, select 'Define Currency Conversion Type
5. Filter with the relevant country.
6. The conversion type is mentioned as Bid-rate for 'Tax Dif Posting for Summary Invoice' (so this is the reason system picks bid-rate for all tax postings and in reports). 
7. This can be also changed as per the requirement either to Mid-Rate/Ask Rate

Exchange rate, conversion type, supplier invoice, tax postings, Business Configuration, Mid-rate, Ask rate, Monitoring Invoices, VAT, Sales Tax Items. , KBA , SRD-FIN-TAX , Tax Management , Problem