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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Voided checks cannot b...
Microsoft Dynamics SL (Archived)

Voided checks cannot be cleared

(0) ShareShare
ReportReport
Posted on by Janet Heeke 645

We recently upgraded to SL 2011.  In the bank reconciliation, a voided check is represented by 2 entries.  For example, the original check is -200.00 and the entry to void the check is listed as +200.00.  Before upgrading, I would simply check the cleared box next to both of these entries to remove these items from the outstanding check and deposit lists.  Since the upgrade, when I attempt to check the cleared box, the system returns a message that says "voided checks cannot be cleared".   How do I now get these items cleared and off my outstanding lists?

*This post is locked for comments

I have the same question (0)
  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    Hi Janet,

    Are you using the Bank Reconciliation module?  Also, I assume you are using SL 2011 SP1.  Is that correct?

    If so, there are a couple of bugs that you will want to apply hot-fixes to correct.  You will need to apply the hot-fixes in KB articles 2656101 and 2790322.  

    KB article 2656101 address bug 24005 which reports the issue that the check and void check don't fall off the screen.  The fix is for the GL Closing screen.  The next time you close the BR module, the items will not appear on the BR screen.

    KB article 2790322 address bug 25005.  This reports that those checks don't get removed from the outstanding checks total.  This hot-fix will correct that issue.

    Please let me know if the hot-fixes correct this issue.

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    Hi Janet,

    Did the recommendations above resolve the issue for you?

  • Janet Heeke Profile Picture
    Janet Heeke 645 on at

    Hi Carolyn,

    Thanks for checking back.

    Yes,I am using the Bank Reconciliation module, and yes, we are using SL 2011 SP1.  

    We haven't applied the hot fixes yet.  I won't be working in the bank rec module again until after Jan 1. I thought it might be best to apply the hot fixes at that time so there would be some continuity in applying the fixes and then going right into a bank reconciliation.  What do you think?

    Janet

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    Hi Janet,

    That sounds fine - it's really up to you.  Just let me know if you need help at the time you apply the hot-fixes.

  • Janet Heeke Profile Picture
    Janet Heeke 645 on at

    Hi Carolyn,

    We applied both hot fixes but now I'm having a new problem....

    A check voided in a period subsequent to the period that it was written should stay in the outstanding check list until the period that it is voided.  In our case it is not and it creates a GL difference in our bank reconciliation.  

    For example, a check was written in period 7 and was voided in period 8.  The check is not on the outstanding check list for period 7 and the amount of the check appears as a GL difference in the period 7 bank reconciliation.

    Any ideas?  Thanks again!

    Janet

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    Hi Janet,

    Unfortunately, it is another bug - number 25063.  We needed to correct a stored procedure which I have pasted in below.  Execute it against your application database.  It won't correct the issue you are seeing this this period but should prevent it going forward.  I'm sorry for the inconvenience.  

    alter Procedure BR_BRTran_DeleteVoidAPChks  

    @CpnyId char(10),  

    @AcctID char(10),  

    @BegPer char(6),  

    @EndPer char(6)  

    AS  

    DELETE BRTran from BRTran  

         inner join (SELECT BRTran.MainKey, apdoc.perclosed from BRTran  

    JOIN APDoc ON APDoc.BatNbr = BRTran.OrigBatNbr AND APDoc.RefNbr = BRTran.OrigRefNbr AND APDoc.Status = 'V' AND APDoc.Rlsed = 1)

         x on  BRTran.MainKey =x.MainKey

    Where BRTran.CpnyId = @CpnyId and BRTran.AcctID = @AcctID and BRTran.CurrPerNbr BETWEEN @BegPer AND @EndPer  

    and CurrPerNbr>=x.perclosed

    Let's see how it looks next period.  

  • Janet Heeke Profile Picture
    Janet Heeke 645 on at

    Hi Carolyn,

    My IT department executed the fix and this is the message I received back from them:

    When I debut the query against the NAVCApp SL database I get the following errors:

    Msg 102, Level 15, State 1, Line 2

    Incorrect syntax near ' '.

    Msg 102, Level 15, State 1, Line 8

    Incorrect syntax near ' '.

    Msg 102, Level 15, State 1, Line 9

    Incorrect syntax near ' '.

    Janet

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    Hi Janet,

    I copied the statement from this forum posting to SQL Server Management studio and it ran without errors.  Is this script the only text in the query window?  

    Maybe copy and paste the script into Notepad first to make sure it looks exactly like what I sent you.  The only character with a single quote around it is a V.  

    Or you can copy into this posting exactly what you have in the query window and I'll see if I can see anything wrong.

  • Janet Heeke Profile Picture
    Janet Heeke 645 on at

    Hi Carolyn,

    Here's what my IT dept said:

    "Can you please send the .sql query via email.  We are still having the same error when we copy from the forum into Notepad and then run the query."

    Janet

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    Hi Janet,

    The forums don't support email responses.  You would need to open a support case with us.  There would be no charge to you since it relates to a bug.

    Have you submitted support requests in the past?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans