Invalid Series Next Number

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.

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:

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.

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.

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

 

If none of the solutions mentioned match the Customer database situation, please check for additional codes in the Transaction Notification Stored Procedure.