In this blog we will see the many reasons for the error 'Invalid Series Next Number'. It can come from a Business One setting, application error or general usage.
Symptoms
1- Access the "Document Numbering - Setup" function.
2- Select a marketing document for creation of a new document series.
3- Create or update a series in the "Series -Setup" window.
4- Click on "Update" to go back to the main "Document Numbering - Setup" function window.
5- Click on Update.
System Behaviour: Invalid series next number.
Note: The error does not necessarly indicate a DB corruption.
This issue can be caused by the following influences below.
| Missing Numbers |
What to do/check?
Check for missing values in the Numbering Series.Use the following queries:
- Missing Initial Number Select ObjectCode, SeriesName from NNM1 where InitialNum = 0 or InitialNum = '' or InitialNum is NULL
- Missing Next Number Select ObjectCode, SeriesName from NNM1 where NextNumber = 0 or NextNumber = '' or NextNumber is NULL
Resolution
Fill in the missing gaps in the numbering series.The query will show the object code and the series name with missing values.
In the above, 'Object Code' 132 refers to A/R Correction Invoice.
For this document, the next or initial number is missing. Access the Document Numbering to define the values.
| Overlapping Series |
What to do/check?
Verify that First and Last Numbers in the series do not overlap especially if a document uses multiple series.
In this screenshot, the A/R Invoice document uses series: INV-DN and INV-2008:
In this screenshot, the INV-DN's Last Number is higher than the INV-2008's First Number:
In this screenshot, the A/R Invoice document uses series: INV-DN and INV-2008:
In this screenshot, the INV-DN's Last Number is higher than the INV-2008's First Number:
Solution:
Change the last number of the numbering series INV-DN to a lower number than first number of the series INV-2008. In this screenshot, the 'Period Indicator' Default is set for both 2006 and 2007 series:
You need to fill in the 'Last No.' of the 2006 Series so it will not overlap with the 'First No.' of the 2007 Series.
You need to fill in the 'Last No.' of the 2006 Series so it will not overlap with the 'First No.' of the 2007 Series.
| Incorrect Numbers |
What to do/check?
1- Check that the Next Number is not greater than the Last Number. Use this query:SELECT * FROM NNM1 T0 WHERE T0.[LastNum]
+1<T0.[NextNumber]
2- Update the Next Number or Last Number for Object Type 22 (Purchase Order).
3- Check if the Initial Number is not larger than the Next Number or the Last Number. Use this query:
SELECT * FROM NNM1 T0 WHERE T0.[initialnum]
> T0.[NextNumber] or T0.[initialnum] > T0.[lastnum]
4- Change the Initial Number to the correct Initial Number which should be lower than the Next Number and Last Number.
| Application Error |
You would need to look at a customer database and follow the steps in these Notes:
- SAP Note 946359 - 'Object overlaps' or update does not respond updating series
- SAP Note 973146 - 'Object overlaps' Regarding Deposits Series
- SAP Note 947746 - ?Duplicate key OWOR error? when editing Work Order
- SAP Note 957586 - Series window cannot be edited and overlapping series
- SAP Note 1141474 - Error message: series overlapping, invalid series next number
- SAP Note 1128871 - "Another user modified table" when update document numbering
| Codes in Stored Procedures |
If none of the solutions mentioned match the Customer database situation, please check for additional codes in the Transaction Notification Stored Procedure.