Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Statement Status must be open - cannot void check that is on bank recon but not cleared

    [quote]Regulation CC states when deposits of various types must be made available to your customers, measured in business days following the banking day on which the deposit is made. Business days are defined as Mondays through Fridays except federal holidays. A banking day is any business day (up to the bank's cut-off hour) when your institution is open for substantially all of its banking activities. All references to the number of days to funds availability in this guide indicate maximum time limits for making funds available; your institution may provide earlier availability of funds if it chooses and may extend the time when funds are available up to periods set by Regulation CC on a case-by-case basis. [/quote]

    US law requires the check value to be credited within days, regardless of whether the account has been confirmed to be active and to have sufficient funds available.

    That is why a check can be deposited and then days later the deposit is reversed when the account is found to be closed or to have insufficient funds.

    This bank reconciliation process as designed is pie-in-the-sky full of overweening optimism.  

  • Tamcor73 Profile Picture
    Tamcor73 10 on at
    RE: Statement Status must be open - cannot void check that is on bank recon but not cleared

    My apologies, it was an EFT not a check

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Statement Status must be open - cannot void check that is on bank recon but not cleared

    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?

  • Alex Chow Profile Picture
    Alex Chow 4,481 on at
    RE: Statement Status must be open - cannot void check that is on bank recon but not cleared

    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.

  • Tamcor73 Profile Picture
    Tamcor73 10 on at
    RE: Statement Status must be open - cannot void check that is on bank recon but not cleared

    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

  • Daniel butler Profile Picture
    Daniel butler 5 on at
    RE: Statement Status must be open - cannot void check that is on bank recon but not cleared

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Statement Status must be open - cannot void check that is on bank recon but not cleared

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Statement Status must be open - cannot void check that is on bank recon but not cleared

    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 Microsoft Employee on at
    RE: Statement Status must be open - cannot void check that is on bank recon but not cleared

    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 Microsoft Employee on at
    RE: Statement Status must be open - cannot void check that is on bank recon but not cleared

    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 ?

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