Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Suppress Leading Zeros for Check Numbers in Vendor Check Register Report

Posted on by Microsoft Employee

We have multiple companies setup in Dynamics GP 2015 R2 that was done by a contractor we no longer use.

Our new controller noticed that when they print a Vendor Check Register Report, that the check numbers for one company are displayed without any leading zeros.  In the second company when they run the Vendor Check Register Report, the check numbers are padded with leading zeros.

For example

Company 1

Check Number

12345

Company 2

Check Number

00000000000000012345

Where is the setting to change Company 2 to display check numbers like Company 1?

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Suppress Leading Zeros for Check Numbers in Vendor Check Register Report

    Thanks - this is the solution we did implement.  The controller reviewed how many checks each account writes to determine how many numerical units each check numbers scheme should be.

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Suppress Leading Zeros for Check Numbers in Vendor Check Register Report

    For future checks, you should change the Next Check Number field on the next check number field on the Checkbook Maintenance  Window of the specific checkbook account.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Suppress Leading Zeros for Check Numbers in Vendor Check Register Report

    Thank you so much for your response.

    It turns out that the check number series for the first company was 5 numbers  while the second company had the program default.  Our controller adjusted the check number series for the second company to 6 numbers.

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    RE: Suppress Leading Zeros for Check Numbers in Vendor Check Register Report

    There is no setup for this, however you can modify the way check Number print on reports by using RW_Value function for Check Number field on desire report.

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans