Record Already Exist

[erprider]

Guys..

When i post the shippment am getting error like
" Shipment. Record already exists.Posting failed. You must enter the shipment again."

Note: i entered the shippment again and i gave different shippment and invoice no as well

i am little bit apprehensive of this error perhaps my data corrupt


Any idea?

 

[Jay Converse]

O/E Setup
Options
Documents
Change the next shipment number

 

[erprider]

No Luck. i changed but still same error message.

 

[Jay Converse]

Manually increment OEOPT.NEXTSUNIQ

 

[erprider]

I update table oeopt.nextsuniq next sequence number but no luck

update oeopt set nextsuniq='1912963'

 

[Jay Converse]

Then run RVSPY to diagnose what .Insert is failing.

 

[erprider]

i ran the rvspy. in that log there is no .insert, it shows only oeshih table

 

[erprider]

recently dayend processing error has been occured. i fixed the dayend processing error by using rvspy by the way i was deleted few shippment records after that i've been facing this error.