D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Clear of Debits/Credits Bank Rec Module

  • 1.  Clear of Debits/Credits Bank Rec Module

    Posted Jul 03, 2019 03:50 PM

    In the cash and bank module - Bank reconciliation worksheet.

    We have situations where an entry was made in the General Journal and then immediately reversed out which would reflect Debit/Credit on the bank transactions side.  We are not able to clear the entries off the reconciliation worksheet.

    I have been told that a fix was coming in upgrades 10.2.  Has anyone else heard this and can confirm?  Or is there a workaround for this?

    Any assistance is greatly appreciated!  

    Jolie Arteno
    Vista Proppants and Logistics
    Fort Worth TX

  • 2.  RE: Clear of Debits/Credits Bank Rec Module

    Posted Jul 04, 2019 03:21 AM
    Have you tried to reconcile the transactions against an unrelated bank statement transaction which is also included on the rec. As the net effect of the posting is zero the overall match should work out and the system should allow you to match.

    Bank Statement line = 500
    Related transaction & GL Journal Credit & debit = 500+100-100 = 500.

    Mark Bailey
    Application Consultant

  • 3.  RE: Clear of Debits/Credits Bank Rec Module

    Posted Jul 04, 2019 02:03 PM
    We have created an automatic matching rule for "cancellations" that would mark those 2 transactions as reconciled.

    Zvika Rimalt
    Functional Consultant
    Vancouver BC

If you've found this thread useful, dive deeper into User Group community content by role