Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

How to add 00 in from of check numbers

(0) ShareShare
ReportReport
Posted on by 140

we had 6 digit check numbers earlier and now we changed it to 8 digits. How can we add 00 in front of all the old 6 digit check numbers?

we have around 150 of them that we need the rest could stay 6 digit or change either way.

Thanks for your time and responses in advance.

VIC PATEL

773-724-6321

*This post is locked for comments

  • Ajit Kannan Profile Picture
    1,246 on at
    RE: How to add 00 in from of check numbers

    Hello VICKY.PATEL,

           Call IncrStrg(strLastnbr, 6, 1)

           strGenNbr = "00"  & strLastnbr

           bTable.FieldName= strGenNbr

  • Community Member Profile Picture
    on at
    RE: How to add 00 in from of check numbers

    There is no screen that you can do this with but it could be done with some SQL queries.  You did not indicate whether you are talking about AP checks or PR checks.  If you clarify which and are comfortable running SQL queries I can provide then for you.  You have to make sure you hit all the table involved when doing this but it is not difficult.

    The other issue you might run into depends on what version of SL you are running.  Earlier versions only supported a 6 character check number on the void check screen so changing to a 8 character check number could result in you not being able to void one of those checks.  You probably do not have this issue but you might want to start a dummy void check screen and try entering more than 6 characters for the check number (i.e., 1234567) and see if it will take the 7th digit before attempting this.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

#1
Community Member Profile Picture

Community Member 136

#2
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 102 Super User 2025 Season 1

#3
REUser Profile Picture

REUser 8

Featured topics

Product updates

Dynamics 365 release plans