2768911 - Transaction Amount wrong in Cash Position - Transaction Details Report

• You manually change the exchange rate when posting a bank-to-bank transfer AAA(AAA represents the payment ID).
• For example, you transfer 250.00 USD (200.00 EUR) from a USD bank account to EUR bank account with user defined exchange rate of 0.8. However, the default system exchange rate, as maintained in the General Ledger,  is 0.9.
• When you check payment AAA in the 'Cash Position - Transaction Details' report, you notice that the Transaction Amount is not 200.00 EUR, but 225.00 EUR.

SAP Business ByDesign

To check the amounts in the Payment Monitor view:

1. Go to the Liquidity Management work center.
2. Go to the Payment Monitor view.
3. Show All Payments and search AAA.
4. You can see:

• Incoming Bank Transfer, Document ID AAA, EUR bank account.
• Payment Amount in Transaction Currency: 250.00 USD; Payment Amount in Cash Location Currency: 200.00 EUR.

To check the amounts in the 'Cash Position - Transaction Details' report:

1. Go to the Liquidity Management work center.
2. Go to the Reports -List view.
3. Open the Cash Position - Transaction Details report.
4. Enter EUR as Display Currency, In the Display Currency - Conversion Date enter the posting date of Payment AAA.
5. Enter all other required parameters and then press Apply.
6. You can see:

•         EUR bank account, Intra-/Intercompany Bank Transfer AAA, Transaction Amount 225.00 EUR.

The 'Cash Position - Transaction Details' report considers the transaction currency as the source currency and the Display Currency as target currency for the exchange rate calculation (for example:  250.00 USD * 0.9 (system exchange rate)) . This report is not intended to show cash position transaction currency with user defined exchange rate bank-to-bank transfers.

This is expected system behavior.

Cash Position, Bank-to-bank transfer, Exchange rate , KBA , AP-PAY-ANA , Analytics , Problem