web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Statement Status must ...
Microsoft Dynamics NAV (Archived)
Answered

Statement Status must be open - cannot void check that is on bank recon but not cleared

(0) ShareShare
ReportReport
Posted on by Community Member

We are trying to void a check no. 506321 that was issued in Dec 19, 2013 but it was not cleared yet as of 01/20/14 - when we tried to void the check - we got an error message "Statement Status must be open in Check LedgerEntry Entry No. = 9658" - when we looked at the check ledger entries for this bank to find the check - there is a statement no. of 01022014 and the Open Field is checked. When we looked at the Bank Recon for this bank - we see this check is part of the Check List but it has not been clear yet - so under this assumption - we should be able to void the check# 506321 but we cannot do it - somehow it seems to think it is tied to the bank recon statement that was done on 01/02/2014 and will not let us void this check. How do I open the Bank Recon Statement but if I do that, will this cause an issue with the bank recon we did for the cleared checks as of 01/02/2014?

What is the best way for us to handle this issue?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi Berlinda,

    Do you have any active/open bank reconciliations that have not been posted yet?  If so, look to see if this check has been added to the open bank rec. and if it's there delete the line for it.  The system should then allow you to process the void.

    Regards,

    Rob

  • Community Member Profile Picture
    Community Member on at

    Dear Rob:

    Yes, It seems we have an active/open bank reconciliations that have not been posted yet.

    I have seen this check on it but I also seen a lot of other checks that are not cleared yet on the Open bank reconciliation - close to around 600 entries.

    Would be it be better to post the open bank reconcilation rather than deleting each one of those uncleared checks ?

  • Community Member Profile Picture
    Community Member on at

    Hi Berlinda,

    With a large number of cheque entries it's probably easier to delete the unposted bank rec., void the cheque(s), and the recreate the rec.  This is one of the downsides with NAV's bank rec. process in that the cheque entries are essentially "locked" when they are brought into a bank rec. worksheet.  

    I guess Microsoft assumed most users would be completing and posting the reconciliation right away, but in practice I've seen a lot of clients who prefer to start the rec. at the beginning of the month and then continually work on it for a period of time.  In fact, there is a suggestion submitted on Microsoft Connect from another user to change this behaviour so that cheques in unposted bank rec.'s may be voided without having to go through this workaround.

    Regards,

    Rob

  • Community Member Profile Picture
    Community Member on at

    Dear Rob:

    I have discussed this with our accounting dept. They will post the unposted bank rec first. This would solve the issue of the cheque entries being "locked" for those unclear checks.

    We assume that the bank rec will be completed and posted right away. I agree that there should be some changes made to avoid this issue.

    Thanks for your help on this.

  • Community Member Profile Picture
    Community Member on at

    We have the user post the open Bank Reconciliation and it is now fine. Thanks for the help.

  • Daniel butler Profile Picture
    Daniel butler 5 on at

    Thank you this also helped me solve a similar problem to what the original posted had.

  • Tamcor73 Profile Picture
    Tamcor73 10 on at

    I also have a similiar problem. The check cleared the account in December so I was able to post my bank rec. A few days later, the check was returned because the account was closed. I'm trying to void the check but I can't.  Thanks

  • Alex Chow Profile Picture
    Alex Chow 4,481 on at

    How did it clear with the bank if the account was closed?

    Once the check has been reconciled, you will not be able to void the check.

  • Suggested answer
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,118 on at

    If the entry is reconciled that means you have accepted that your bank statement entry and system entries are tallied. Once the entry is reconciled you will not be able to void or reverse any entry. Best option you have is to post a separate entry to reverse the cheque.

    As Alex said if the account was closed how did the cheque got cleared?

  • Tamcor73 Profile Picture
    Tamcor73 10 on at

    My apologies, it was an EFT not a check

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
TAHER_El_Mehdi Profile Picture

TAHER_El_Mehdi 2

#1
sliderxb Profile Picture

sliderxb 2

#1
broberts Profile Picture

broberts 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans