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) / Missing A/P check - SL...
Microsoft Dynamics SL (Archived)

Missing A/P check - SL 2011

(0) ShareShare
ReportReport
Posted on by Julie B 175

In the middle of an A/P check batch, SL skipped a check.  So when printing the check number on the check, SL increased the the check number by one.  We use pre-printed checks, so now the pre-printed check number does not match the check number in SL for the remaining checks in that batch.  The skipped check is listed as Missing on the check register.

Has anyone else experienced this?  How is that even possible?  My A/P clerk processed the batch and didn't notice the different check numbers.  We didn't notice this until the bank reconciliation was done.  So I don't know if he received any warning or error when processing the batch.    If he had received a warning, I would have expected him to bring it to my attention.  So I assume that this happened without any warning.

Anyone have any experience or advice?

thanks.

*This post is locked for comments

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

    Hi Julie,

    We have bug 19556 which says this:

    A vendor with seperate check = YES and an open debit adjustment will eat up a check number without anything printing.  User may see check numbers skipping.  

    This was first reported in 7.0 sp2 and fixed in 8.0 sp1.  Our workaround has been to run this proc to recalc  the checklines at the time the Next check number displays in the Check Printing screen.  Run this against your application database.

    This script is for ver 8.x

    /****** Object:  Stored Procedure dbo.FindLastAPCheck     ******/  

    alter Procedure FindLastAPCheck @parm1 varchar ( 10), @parm2 varchar ( 24) As  

    update apcheck set checklines = (select count(*) from apcheckdet where apcheck.checkrefnbr=apcheckdet.checkrefnbr) from apcheck

    delete from apcheck where checkrefnbr not in (select distinct checkrefnbr from apcheckdet)

    Select ISNULL(MAX(refnbr) ,'0')  

    FROM APDoc a (NOLOCK)  

    Where a.DocClass = 'C'  

    AND a.Acct = @parm1  

    AND a.Sub = @parm2  

    AND  

    (a.DocType in ('CK', 'MC', 'SC', 'ZC')  

    OR  

    ((a.DocType = 'VC')  

    AND NOT EXISTS (SELECT 1 FROM APDoc b (NOLOCK) WHERE a.refnbr = b.refnbr AND a.VendId = b.VendId and a.Acct = b.Acct and a.Sub = b.Sub and (b.DocType = 'HC' or b.DocType = 'EP'))))  

  • Julie B Profile Picture
    Julie B 175 on at

    Elaine,

    thanks for your suggestion.  But an open debit adjustment did not cause our problem.

  • Julie B Profile Picture
    Julie B 175 on at

    This happened again, so I am bumping this topic in the hope that someone has some advice about this problem.  It happened again, but with many more skipped checks.  in a batch of 19 checks, 10 were fine. But the others skipped multiple checks and there is no pattern to the number of checks skipped.

    We have 7 companies using our SL 2011 and this only happens for the one company.  has anyone else had this problem and do you have a fix?

    thanks.

  • Community Member Profile Picture
    Community Member on at

    How far back / forward was the period range you used on the AP check register?

    Entering a wide range for the check register's perpost filter would list any stray entries with a higher number than your last preprinted check number. You could also review the AP Documents Quick Query for reference numbers of checks higher than your current check sequence.

  • Julie B Profile Picture
    Julie B 175 on at

    I'm sorry, but I don't understand your question Brian.

    this issue occurs when printing checks.  some check numbers are skipped when printing checks.  those skipped checks are listed as missing on the check register.  

    What would cause SL 2011 to skip checks?

    thanks.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    The check numbers skipped may be due to past check entries, where the check number used was out of sequence with your pre-printed checks. If your check printing procedure requires the AP clerk to enter the next printed check number, it seems likely that higher check numbers were entered at one time.

    The opening tab of the check register report has beginning and ending periods, which will filter out checks printed if not posted to that period range. A check number that was used but has a period to post outside of the report's period range will appear as "missing". Entering a period range from 01-1900 to period 12-9999 effectively removes the perpost filter from the report, so checks from any period will appear on the report.

    When running the check register for all periods, if numbers that are out of sequence with the preprinted checks were used, they will appear on the report.

  • Julie B Profile Picture
    Julie B 175 on at

    that's it....thanks so much for your help.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Julie,

    Some of my clients have run into this issue when the number of vouchers being paid exactly matches the maximum number of vouchers that will fit on a check stub.  It appears that the stub overflow logic gets confused in such a case and thinks that it will be into a stub overflow when, in reality, it does not need a second check.  I am looking through my issue notes and it appears that this was occurring with SL 6.5.  I am not sure if it continues into SL 7.0 and SL 2011 or not but you might want to see if this just might be your issue.  I do not have a fix but the workaround is to look for such a condition before printing checks and add a debit adjustment and credit adjustment for the same amount to such a vendor such that check process truly goes into stub overflow.

    Fixing up the incorrect check numbers used within SL requires a set of update queries to be run.  If you or someone available to you has access to the SQL Management Tool and is comfortable running queries, I can provide those.

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