Author Topic: Counter Range. aka: the sequence range of order numbers  (Read 3833 times)

DonQuixote

  • Rock Star
  • *****
  • Posts: 205
  • To Dream the Impossible Dream...
Counter Range. aka: the sequence range of order numbers
« on: October 30, 2013, 01:04:06 PM »
Counter Ranges are maintained in the CONTROL file. 
One record '001ORD#'  sets the standard for each warehouse like '001ORD#001'  '001ORD#002'   etc
'001ORD#'
1:   1
2: 00001            starting seq number
3: 99999            ending seq number
4:   6                 ?????????????????????    what does this represent    ??????
5:   8                 total length
6:   Y                 okay to use alpha sequential

'001ORD#002'
1:    1
2:  001
3:  999
4:  002AB
5:  5 ] 3 ] 6 ] 8                '5' is length of line 4.  '3' is length of line 3.  '6' & '8' from '001ORD#'
...
8:  Y] 002] A] B


Tom Pellitieri

  • Rock Star
  • *****
  • Posts: 224
  • Tom Pellitieri - Toledo, Ohio
Re: Counter Range. aka: the sequence range of order numbers
« Reply #1 on: October 31, 2013, 06:57:16 AM »
You should use the maintenance screen to update this information.  It's in the Systems | System Parameter | Maintenance... | Counter/Range Setup... | Order Processing Module... menu

Attribute 4 of 001ORD# represents the length of the shortest sales order number.  Prelude uses 6 as a default for most setups.  We increased it to 7 when it became obvious we would loop the range.

The Warehouse records include the following attributes in our system:

1: Current Document Sequence
2: Lowest Document Number
3: Highest Document Number
4: Prefix Text
5: Prefix Length ] Doc# Length ] Shortest Length ] Longest Length
8: N = Do Not Use Alphabetic

It appears on your system that 8 is a "use alphabetic", so the additional fields are the numeric prefix and the additional alphabetic digits.  This sequence is stored in Attribute 4, but the fields in Attribute 8 will help "roll" that to the next level.

We don't use the alphabetics, so without examining your document numbers, I can't advise you beyond that.  However, I strongly recommend that you use Prelude's maintenance screens if you need to make changes.

DonQuixote

  • Rock Star
  • *****
  • Posts: 205
  • To Dream the Impossible Dream...
Re: Counter Range. aka: the sequence range of order numbers
« Reply #2 on: October 31, 2013, 09:54:32 AM »
Thank you!
   But, after checking I remembered why I can't use the entry screen. 
The only thing it changes are the start/end/current number.
There is no way to adjust the letters or fix a flawed rollover.
btw. the letters must be fixed in both attribute 4 & 8, if there is a problem