Skip to Content
author's profile photo Former Member
Former Member

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


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,


Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on 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 :)



    Add comment
    10|10000 characters needed characters exceeded