Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Supplier Number Limit

Supplier Number Limit

Supplier Number Limit

Anyone out there reached the 999999 Number limit for Suppliers....and if so how did you get around it?

RE: Supplier Number Limit

If you have 999,999 suppliers, the 6-character limit is the least of your problems...or you must have huge gaps in the numbering sequence. try finding those gaps and set your last supplier number (SCF) at the beginning  of one of those gaps. You might also want to archive those you are not using.

RE: Supplier Number Limit

We have legitimate reasons for having that many Suppliers and we have Archived. Since my query we have developed a method that solves the problem very well.

RE: Supplier Number Limit

Since you developed the method and got us very curious, you might as well share it with us?

RE: Supplier Number Limit

We can use A - Z, can't we?

RE: Supplier Number Limit

Just another note as Archiving has been mentioned in the context, Lewchow apparently suggesting that the archived id's could be re-used? I believe this is not the case: archived supplier id's cannot be re-used by assigning new suppliers to them and it would be a grave mistake to do so, even if MIMS allowed it to happen.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close