Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Bank Reconciliation - Outstanding Bank Transactions amount problem

Posted on by 4
Hi everyone,
 
Recently, when I do the bank reconciliations, I found out there is a unreasonable amount appear on the report's "Outstanding Bank Transactions".  In fact, the actual amount for this item shall be zero. No adjusting entries have been made.  
 
The bank reconciliation seems have no other problem, except the report shows this unreasonable amount.  And this same issue appears on all our other Bank Reconciliations.
 
This seems to me a system error.  Are any of you encounter the same issue?  Is there a way to fix it?  Thank you.
  • tb513 Profile Picture
    tb513 21 on at
    Bank Reconciliation - Outstanding Bank Transactions amount problem
    So the problem just seems to be with the reporting - is that correct?  When the bank rec is posted, yet the report is showing all the outstanding transactions (at least until the but is fixed), there shouldn't be any long term issues because it has been posted?
  • Suggested answer
    DB-14061304-0 Profile Picture
    DB-14061304-0 18 on at
    Bank Reconciliation - Outstanding Bank Transactions amount problem
    This is a known bug that came out with the latest update. It has to do with the fact that all manual matches do not fully close out the entry on the back end. Currently Microsoft is aware but the only fixes at the moment are to wait for them to fix it or hire a back end developer to create a bank rec report that doesn't pull these in. Our company is opting for the first and just waiting for Microsoft to fix. They have had a lot of complaints I could see them patching soon. 
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 63,992 Super User on at
    Bank Reconciliation - Outstanding Bank Transactions amount problem
  • JS-13061735-0 Profile Picture
    JS-13061735-0 4 on at
    Bank Reconciliation - Outstanding Bank Transactions amount problem
    No, Valentin.  There are no entries sum up to $421,562.43.  It should be "0".
     
    And I just make this as an example, All our other bank accounts reconciliations have the similar issues recently.  However, all bank accounts' early  reconciliations are good.
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 6,993 Super User on at
    Bank Reconciliation - Outstanding Bank Transactions amount problem
    If you go to the Bank Account Ledger Entries, do you see any entries that have a check mark in the open field? If so, do the entries sum up to 421,562.43?
     

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,835 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans