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) / How to add 00 in from ...
Microsoft Dynamics SL (Archived)

How to add 00 in from of check numbers

(0) ShareShare
ReportReport
Posted on by Vicky.Patel 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

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

    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.

  • Ajit Kannan Profile Picture
    Ajit Kannan 1,246 on at

    Hello VICKY.PATEL,

           Call IncrStrg(strLastnbr, 6, 1)

           strGenNbr = "00"  & strLastnbr

           bTable.FieldName= strGenNbr

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