Document already exist error for our user screen

[Former Member]

Hi All,

In SAP 2007 PL 13,after Removing record by right click remove ,I am not able to add the document. It gives error "Document no already exist". After diagnosis Of ONNM and NNM1 table ,I got that next no does not increases in NNM1and ONNM Table.

but this problem came after upgrading from 2005 to 2007.

it happens for some times.

I could not find any reason because I had generated Document no by sap object.

Is it any patch required,I had already run PL 09,10,13

please help me

thanks in advance.

[Former Member]

Hi Atanu,

That problem occurs if you remove the last record of a UDO Document. To correct the problem you must run the following update SQL statement.

UPDATE [@UDO_TABLE] SET DocNum = DocNum + 1 WHERE DocNum = (SELECT MAX(T0.DocNum) FROM [@UDO_TABLE] T0)

Regards,

Vítor Vieira

[Former Member]

Hi

thanks for replly, but is it any specific reason behind it or it is bug in SAP 2007B PL 13

[Former Member]

Hi Atun,

This issue comes if the connectivity is poor.

Standard procedure.

Step 1

open SAP Business one

check the last added record.

Note down the number.

Step 2

Open SQL server

open the table ONNM

Check for the specific number of the object(your user documents)

Note down the number.

The number in this table should be (last addded record in SAP business one + 1)

Generally this error comes when the ONNM table number and SAP business one last added record number is equal.

[Former Member]

Hi Atanu,

I've noticed the problem on all B1 2007A patch levels I've worked with.

I've never reported the problem in SAP support or checked the SAP Messages it either, so it's possible the development team doesn't even know about it.

Regards,

Vítor Vieira