Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Unknown Outstanding Tr...
Small and medium business | Business Central, N...
Answered

Unknown Outstanding Transactions/Checks amount on Bank Account Statement

(1) ShareShare
ReportReport
Posted on by CM-13062325-0 21
We have several tenants that having the bank account statement does not calculate the outstanding transactions/checks amount correctly. 
Below is one of the bank accounts having the issue. The outstanding bank transactions amount and outstanding checks amount should be the amount calculated on the bottom of the report. When I compared with the bank ledger entries, these transactions shown on the detail as outstanding were ones with Open status. There was no issue on last month closing but started to have these issues on multiple tenants recently. 
I'm not sure which table data I can look to get these outstanding bank balances. Does anyone have the same issue? All tenants are on current version 24.4.22295.22393.
Below is another bank account that there weren't any outstanding bank transactions as of 8/31/24. There was no issue to run the bank reconciliation as of 7/31/24. At the end of July, this bank account didn't have any outstanding transactions either. However, in August report, unknown outstanding amounts stated to show on the report. 
Categories:
Business Central
  • Verified answer
    CM-13062325-0 Profile Picture
    CM-13062325-0 21 on at
    Unknown Outstanding Transactions/Checks amount on Bank Account Statement
    Thank you for your responses. 
     
    We investigated further and also concluded that the issue was caused by closed bank ledger entries with no closed at date. We waited for MS hotfix last time, so we'll reach out and see if they are going to publish the hotfix soon. Otherwise, we probably need to modify the report on our end. 
     
  • Verified answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,793 Super User 2024 Season 2 on at
    Unknown Outstanding Transactions/Checks amount on Bank Account Statement
    The previous issue a few months ago with the bank reconciliation report was that the older method of reconciling bank statements without auto match would not populate the 'Closed at Date' field in the bank ledger entries for reconciled entries.
     
    As a result, when printing a bank reconciliation report, it filters based on this field, but since the field was empty for old reconciled entries, the report displayed them incorrectly as outstanding, which it shouldn't have. You can check in the bank ledger entries if the entries that are incorrectly being displayed as outstanding have the 'Closed at Date' field empty. If that's the case, you can modify the report to ignore this filter, or wait for Microsoft to fix it again.
     
     
     
     
  • RB-14061225-0 Profile Picture
    RB-14061225-0 8 on at
    Unknown Outstanding Transactions/Checks amount on Bank Account Statement
    We had this issue in June this year, and then an update was put through to fix it, and it was ok for the past few months but it seems like it is back again.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans