Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

AP Check Numbering Changed

Posted on by 300

Client uses two separate GL account/subaccount combinations for AP Checks.  One for  physical checks and one for wire transfers, each has a separate numbering convention.  Recently, the account/subaccount combination for the wire transfer account began defaulting the check numbers of he physical check account.  Any suggestions on how I can update so that each account/subaccount combination defaults to each own separate numbering convention again?

*This post is locked for comments

  • C Conner Profile Picture
    C Conner 300 on at
    RE: AP Check Numbering Changed

    Thank you.  that is what I suspected, as well as the solution.

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: AP Check Numbering Changed

    Someone probably manually changed the starting check number of Wire Acct/Sub combo to the numbers for the Check Acct/Sub combo. Those numbers then became the highest in the series even when the Wire Acct/Sub combo is selected.

    Check out the Stored procedure FindLastAPCheck to see how the next number is determined.

    The only way to really fix it is to change the offending checks in DocType = 'HC' or DocType = 'EP' in the SQL tables.

    That's not a recomendation, it's just an observation. :)

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans