Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    Kevin McCulley
    19B feature - Unreconcile single transaction from a group in...
    Topic posted May 9, 2019 by Kevin McCulleyBronze Medal: 1,250+ Points, tagged Cash Management, Financials 
    146 Views, 3 Comments
    Title:
    19B feature - Unreconcile single transaction from a group in Cash Management
    Summary:
    How to treat the bank statement line for a payment rejection
    Content:

    When we process a BACS payment run we have one bank statement line for the full batch which we reconcile to the 100 or so system transactions included in the batch.

    Using the new 19B feature to unreconcile a single transaction in a batch we can avoid having to unreconcile then re-reconcile the other 100 or so transactions in the batch which is a good feature so that the GL accounting is tidier.

    Having now tested the feature, the GL accounting Dr Bank Cr Cash Clearing is occurring when the transaction is unreconciled, which is what we want, however the bank statement line for the returned cash cannot be reconciled to anything. I think the only solution is to create an external transaction without accounting to reconcile the bank statement line to - which seems to be a bit of an oversight in the solution provided in 19B since an external transaction without accounting is already being created and reconciled by the system to keep the group balanced.

    Am I missing something here? How are we supposed to be dealing with the bank statement line for the cash returned to the bank?

    Version:
    19B

    Comment

     

    • Sriram Sahoo

      For the Cash Return to Bank . We should be creating a Supplier Refund Payment using Create Payment task in Payables. Then this Refund will be available in the cash management for reconciliation for the statement lines to be reconciled. 

    • Harold Lecomte
      Hi Kevin, I totally agree with your comment.The 19B functionality is a step in the right direction but it does not close the loop in the unreconciliation process as it does not cover the statement line for the failed payment. I raised an idea on this issue: https://cloudcustomerconnect.oracle.com/posts/2ec6c5f246 Thanks, Harold
    • Kevin McCulley

      Great post in the ideas forum. I have upvoted it.