Skip to Content
Former Member
Mar 11, 2017 at 08:38 AM

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,