Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

Unknown Outstanding Transactions/Checks amount on Bank Account Statement

Posted on by 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. 
  • 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 22,285 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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans