SAP Knowledge Base Article - Public

2688779 - Incorrect Exchange Picked For Invoice Payments

Symptom

You are trying to clear the invoice with the existing payments through clear manually option and upon selecting the invoices for the clearing, the Exchange rate is not what you expected.

Environment

sap business bydesign.

Reproducing the Issue

  1. Go to the Payables work center.
  2. Supplier Accounts view and select the supplier account.
  3. Click on view and in the supplier account monitor.
  4. Click on the open invoices and click on clear manually.
  5. Document/posting date entered is DD-MM-YYYY.
  6. Click on Currency Conversion Information, a popup appears and displays that

    Exchange rate is 0.25 ( 0.25 Indicates exchange rate )
    Exchange rate date DD-1-MM-YYYY.
    Exchange rate type Mid Rate

Cause

For the Clearing process, system would pick the exchange rate from the Rate Type - Default Exchange Rate Type - 0001 , which has the last maintained rate and date i.e., DD-1-MM-YYYY and 0.25.


Currency conversion profile is not considered for the clearing process.

Resolution

  1. Go to the General Ledger work center.
  2. Open the Edit Exchange Rates view in the Common Tasks section.
  3. Maintain the relevant exchange rate between Source Currency:PQR to Target Currency:XYZ. ( PQR indicates company, XYZ indicates currency )
  4. Confirm the entries by clicking Save and Close.

The Clearing process would pick the exchange rate from the Rate Type - Default Exchange Rate Type - 0001 , which has the last maintained rate on i.e.,  DD-1/MM/YYYY with 0.25.
Currency conversion profile is not considered for the clearing process but is only for Financial Accounting process hence for the creation of Journal Entry.
If you want an updated exchange rate to be considered for clearing process, You need to maintain that rate for Default Exchange rate type.

Keywords

exchange rate during clear manually of invoice , KBA , exchange rate during invoice payment , AP-DUE , Due Item Processing , Problem

Product

SAP Business ByDesign all versions