Default number higher than expected in new records using NEXT
Description
Starting in version 25.2, fields that use the NEXT default generate higher numbers than expected.
This affects fields like Invoice #, Order #, and other numeric identifiers.
Cause
Version 25.2 corrected the method that determines the NEXT default value.
The previous method didn't function as intended and sometimes produced unreliable sequences.
Resolution

Starting in version 25.2, released on 10/5/2023, the program uses the intended NEXT numbering method.
The program finds the highest purely numeric value and adds 1 for the next record.
The program ignores values containing letters, spaces, or special characters.
This method enforces a true sequence and prevents accidental duplication.

If you now see unusually high numbers, one or more records contain unusually high numeric values.

How the NEXT default works

The NEXT default evaluates only characters 0 through 9.
The program excludes any value containing non-numeric characters, including letters, spaces, dots, dashes, or slashes.

Example

Ignores an invoice number of 123456789-A.
Evaluates an invoice number of 123456 to determine if it's the highest numeric value.
The next new record uses invoice number 123457.

Option to restore the previous method

Installing update 25.2.162 or later lets you switch back to the older numbering method.
This option maintains your existing numbering sequence.

Steps to duplicate
Related Solutions

Sage 100 Contractor: Download Portal

Changing the method to determine the next invoice or PO number