I am having batachable item while creating inventory transfer i am getting the following error message:
[Stock Transfer - Rows - Warehouse Code][line: 1] , 'This entry already exists in the following tables 'Stock Log Message' (OILM) (ODBC -2035)' [Message 131-183]
From referential post i run the query
select distinct t0.itemcode, t0.batchnum from ibt1 t0 where batchnum not in (select batchnum from oibt where itemcode = t0.itemcode)
but got the no result(means no problem in database consistency)
Even i changed the status of the batch from released to not accessible /locked but hard luck.