Is there a way to fix the document numbering error SAP 9.3

[jbrotto]

I updated SAP B1 from 8.82 to 9.3 and noticed the document number window has an error when I try to update.

Invalid series next number [Message 3535-3]

Is there a way to fix that? A query? Know which menu/document might be the issue?

[jbrotto]

I am thinking a query with table nnm1 and nnm3 have to be used.

[JesperB1 · Accepted solution]

Hello Jonathan,

Check the SAP Note 2743634.

If you still cannot resolve this issue, it is very often due to a corruption. Maybe you should contact SAP Support.

Please note that when sending an incident to SAP Business One support you should first perform Level 1 and 2 support steps as described in the Maintenance Policy (SAP Note 1426165) which among other things include:

- Test in the latest patch and in a database without user alterations (formatted searches, Add-Ons, Transaction Notifications etc)

- Have a scenario that is clear and that is reproducible also on a demo, see SAP Note 1095532.

- Document all steps taken - screenshots are very helpful, documentation search terms and documentation used.

- Log with correct priority, SAP Note 795206.

- One issue per incident, see SAP Note 1038290.

I hope that helps,

Jesper

[PierreBrothier]

Hi,

there's a note about this problem :

1534463 - Invalid Series Initial Number / Invalid Series Next Number

https://launchpad.support.sap.com/#/notes/1534463

As said in the note, if the following queries give result, log a support ticket

Select * from nnm1 where (("InitialNum" is NULL or "InitialNum" = ' ') or ("NextNumber" is NULL or "NextNumber"=' ')) and IsManual='N';
select * from nnm1 where "NextNumber"-1>"LastNum";
select * from nnm1 where "InitialNum">"NextNumber";

[jbrotto]

No results thank goodness.

[kothandaraman_nagarajan]

Hi,

Use this query to find,

select Series,NumSize,LEN(CAST(NextNumber as bigint)) from nnm1
where SeriesType in ('I','B') and IsManual='N' and LEN(CAST(NextNumber as float))>NumSize

Regards,

Nagarajan

[jbrotto]

no results were returned