Skip to Content

How to know Itemcode used in any transaction or not by SQL?

Mar 11, 2017 at 08:38 AM


avatar image
Former Member


I want block updation of item master once it used in any document transactions.

In sql found OINM table but this table reflect only these transactions which has item stock in,out & moved from warehouse to warehouse.

E.g. if Inventory GR created then will get entry in OINM but SO or PO created against same item then it will not reflect in OINM.

May i know how will find

Thanks in advance...

Kind Regards,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Rizki Wicaksana Mar 12, 2017 at 02:51 PM


To achieve your goal, you need to check in both of OITL and OILM tables.

OILM - it records all the information regarding the documents. It is pretty similar to OINM, but it records Sales and Purchase orders.

OITL - it records inventory movement.

Hope this helps :)



10 |10000 characters needed characters left characters exceeded