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.
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.
What to do/check?
Check for missing values in the Numbering Series.
Use the following queries:
- Missing Initial Number
- Missing Next Number
Select ObjectCode, SeriesName from NNM1 where InitialNum = 0 or InitialNum = ” or InitialNum is NULL
Select ObjectCode, SeriesName from NNM1 where NextNumber = 0 or NextNumber = ” or NextNumber is NULL
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.
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:
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.
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]
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.
- 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|