Collection Management: Incorrect local currency amount showed on Worklist

[Former Member]

Hi All,

Please I need your help for this issue.

Let me talk you about an error detected on the Collection Management worklist.

Our local currency is the EUR, and we have some Business Partners with invoices posted with USD as document currency. We do not have any problem when the FI invoices have Local currency=Document currency (in most cases). Worklist shows amounts accordingly, of course.

However, we notice now that those BP with invoices posted in different currencies (both EUR as local and USD as document), do not present any correct EUR amount on Workist (despite the strategy is running under EUR). We don´t know how it is calculated. On Process Receivables screen, details are shown perfectly well under USD.

Let we show you:

Open items (invoices for this client):

Please see above the total amount in local currency: 107.407,93 EUR and the total amount in document currency: 123.703,05 USD.

Let us see the Worklist now:

You can see above that Worklist is showing 110.924,55 EUR!!!!. Obviously, we don´t know how the calculation has been done, when you see in Open Items  transaction (FBL5N, including special g/l transactions) that the amount to show on Worklist should be 107.407,93 EUR

Worklist is completely updated, as well as the Exchange rates.

When you enter process receivables for this BP, system shows the documents under correct USD amounts:

The problem is located on Worklist.

Please, we need help to solve this important issue, as we are under LIVE system. I have been trying to find any SAP notes regarding this but found nothing. Help will be well rewarded.

Thanks in advance

[Former Member]

Hi all again...

Now we know that the differences are because when the worklist is updated, system gets the last Exchange rate (the exchange rate of the date in which the worklist is updated), instead of mantaining the historic exchange rate when the invoices were posted!!...

For sure this is a wrong system performance: system should update the worklist with the original exchange rate of the invoice document.

Does anybody know if there is a SAP note to fix this? or is there any other workaround to fix this?

Thanks!

[Former Member]

Please, any help?

How can I make system mantain exchange rates of invoice date on worklist, instead of getting the ratio of the day when worklist is updated?

Thanks

[henk_hoogerbrug]

Hi Patxi Albisu,

Maybe it's already too late for you. But, if the standard SAP calculation doesn't fit your requirements (I assume you're currently using standard SAP), you can use the BAdI "Amount to be collected".

You will find it in transaction SPRO: Financial Supply Chain Management > Collections Management > Basic Settings for Collections Management > Worklist > BAdI: Amount To Be Collected

(please check the img help text)

With the help of an ABAP consultant you can create some logic to get the local currency amount from the original documents.

Best Regards,

Henk

[Former Member]

Many thanks Henk!