Starting from version 25.2, if you have set the default entry for a particular field (such as Invoice# or Order#) to NEXT in its properties, you may notice that the default number generated for that field on a new record is higher than you anticipated.

This is a result of a corrective change made in version 25.2 to the method used for the NEXT default.

Starting from version 25.2, released on 10/5/2023, we have corrected the method for determining the next number in a field. The new method only considers the highest purely numeric value (without any letters, spaces, or special characters) for that field and adds 1 to it for the next new record. The previous method was not functioning as intended. This change aligns with the intended use of the NEXT default, which is to use the next highest number. If you are now seeing unusually high numbers compared to previous versions, it is because you have one or more records that have unusually high values.

Please note that this function considers only values containing numbers from 0 to 9. Therefore, any fields in records that include non-numeric characters such as letters, spaces, dots, dashes, slashes, and others are disregarded when determining the next number to use for that field in a new record.

 EXAMPLE: If there is a record with the invoice number 123456789-A, it will be ignored. On the other hand, if there exists an invoice record with the invoice number 123456 and it is also the highest purely numeric value in that field, then the next new record will use invoice number 123457.

Attention! Installing the 25.2 Update 2 (25.2.162) or later will give you the option to switch back to the previous numbering method used in older versions of the software. By doing this, you can maintain your current numbering sequence. 

See Solution: How to change the method to determine the next number to use in a character field for a new record

Sage 100 Contractor: Download Portal