Financial Management - PSFT (MOSC)

MOSC Banner

Does anyone use Cash Management to reconcile Multi-currency accounts/payment?

edited Jul 15, 2019 3:04PM in Financial Management - PSFT (MOSC) 4 commentsAnswered

Does anyone use Cash Management to reconcile Multi-currency accounts/payment? For example:

1) Bank currency USD and Business unit currency USD

2) Payment currency GBP

3) Payment created on 06/03/2019 with a payment date of 06/04/2019 (Do you use future dates for payments?)

3) Bank coverts GBP to USD automatically since this is a USD account

4) AP records this as GBP transaction currency and USD base currency using Payment date or most current rate available (Mostly uses payment creation day -1 rates since we don't have future FX rates and payment date is in the future)

This scenario records payment in AP with FX rates of 06/02/2019 but the cash management shows or coverts the payment using 06/04/2019 date. This is causing AP table and reconciliation screen to have two different USD amounts for the same payment. I understand that bank statement will have different amount since bank will use different rate than the rates we import but our issue is with system side transaction in semi-manual page not matching what AP is sending to GL.  

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center