Does anyone use Cash Management to reconcile Multi-currency accounts/payment?
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.