Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 12, 2017 at 02:51 PM

    Hi,

    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 :)

    Regards,

    Rizki

    Add comment
    10|10000 characters needed characters exceeded