We have a similar issue assigning Ship-to numbers where we have a report (still RB in our case) that detemrines the highest currently used number and "suggests" the next one. Works OK where a limited number of people are entering new items and chance of two at once is slim.
For PartNum it might be a litle more tricky because it is a character field (despite the name) so with the grouping part (presumably at the beginning) you would have to strip off that part and get to the serialized part, sort that and then find the last one used.
Also, I didn't see it mentioned in other posts but because PartNum is character be sure if the first segment is numbers to pad in leading zeros on any number not using one or higher in the first position(s). It will save a LOT of grief with sorting.
-Todd C.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Chris Reed
Sent: Friday, September 29, 2006 12:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 6.1: Part Number Conventions
Guys
Thank you all for your input, it is much appreciated.
I think I'm going to advocate six digit codes with grouping, much the
same system as G/L coding. Now for the tricky bit - how to control the
raising of part numbers! Any thoughts on how to keep it in Vantage?
Chris
For PartNum it might be a litle more tricky because it is a character field (despite the name) so with the grouping part (presumably at the beginning) you would have to strip off that part and get to the serialized part, sort that and then find the last one used.
Also, I didn't see it mentioned in other posts but because PartNum is character be sure if the first segment is numbers to pad in leading zeros on any number not using one or higher in the first position(s). It will save a LOT of grief with sorting.
-Todd C.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Chris Reed
Sent: Friday, September 29, 2006 12:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 6.1: Part Number Conventions
Guys
Thank you all for your input, it is much appreciated.
I think I'm going to advocate six digit codes with grouping, much the
same system as G/L coding. Now for the tricky bit - how to control the
raising of part numbers! Any thoughts on how to keep it in Vantage?
Chris
--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Chris Reed" <crreed@...> wrote:
>
> Ok, this is the third company I've implemented Vantage.
[Non-text portions of this message have been removed]