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

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

223 Views

Hi,

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,

Amol