Unknown Outstanding Transactions/Checks amount on Bank Account Statement

(1) Share

Report

Posted on by CM-13062325-0

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:

Dynamics 365 Business Central

All responses (3)

Answers (2)

Verified answer

CM-13062325-0 21 on at

Like (0)

Report

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 24,910 Super User 2024 Season 2 on at

Like (0)

Report

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.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
RB-14061225-0 8 on at

Like (0)

Report

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.