Skip to Content
0
Former Member
May 19, 2010 at 11:13 AM

BOM item update issue in SO

152 Views

Dear Frnds,

While updating SO, i m getting error in below of screen in red strip color that "19/05/2010 16:32:01: 1). [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'DocEntry', table "TESTDB".dbo.RDR4;column doesnot allow null. Insert Fails".

This error only comes when i am updating those SO which have items of BOM Sales type.

I have noticed that suppose in SO i have selected one BOM item and its automatically included sub 5 items.

So total 6 entries has been inserted into RDR1 table, but in RDR4 table there are only one row has been inserted.

When I have added SO then there is not any problem, but when im updating then its indicating error of insert null error of RDR4 table.

Is it because there are only one entry entered in RDR4 table at the time of creating SO?

Please guide me?

Regards,