3545019 - System Crashes Upon Posting Payment Allocation

System crashes upon attempting to post payment allocation.

SAP Business ByDesign

1. Navigate to the Payment Management work center.
2. Open the Payment Allocation view.
3. Find and open Payment Allocation XXX (XXX means the Payment Allocation ID).
4. Notice that Open Amount is zero.
5. Click the Post button.
6. The system crashes.

One possible cause for the issue is the existence of duplicate exchange rate data sets having the same external key (Unit Currency, Quoted Currency, Quotation Date/Time). This should not occur and leads to inconsistencies in the system.

To confirm the cause, proceed as follows:

1. Go to the General Ledger work center.
2. Go to Common Tasks view -> Edit Exchange Rates.
3. Click View Exchange Rate History button.
4. Click 'Click here to execute the query'
5. System will return at least one error as the one below:

"Data inconsistent - create case - internal key ABC"

ABC means the internal key.

Open a case to SAP Support giving your permission to delete all exchange rates duplicate entries from backend system.

Once the entries are deleted, both issues will be resolved, meaning the errors in the Exchange Rate History view and the system crash upon posting payment allocation XXX.

Internal KBA 2251087 - Error: Data inconsistent - create case - internal key XYZ.

posting, bank statement, error, duplicate, exchange rate, data inconsistent, internal key, backend correction, Payment Allocation. , KBA , AP-RC-CER , Currency Conversion & Exchange Rates , Problem