Inqty layer info on goods issue and goods return

[former_member304491]

Hello all,

Our clients needs an information on documents that are decreasing

stock level, which incoming layer outgoing layer comes from.

I know that information about outgoing layers is stored in table OIVE.

In column EntryTreeI there is information about TreeID from OIVQ (where all incoming quantity in

warehouse is stored).

This is very important information for us.

But in OIVE table there is no entries for Goods issue (transtype 60) and goods return (transtype 21).

Probably there will be no entries for AP Credit Notes too.

There is only information for Delivery and Stock transfer documents as far as I can see.

My question is:

Is there any other place or method (maybe function?) to get this information? We have to get information from

which layers outgoing quantity comes from.

[former_member304491]

I know there are new tables insetead of OINM (which is view now).

There is new table OIVE, which contains information about outgoing stock. In EntryTreeI column therre is information about entry treeid, but not for all documents that have outqty>0 ( for example no entries for goods issue).

How can I find which stock (which Goods Receipt PO it comes from) has been issued?

[Former Member]

You may run Item Audit Report and enable SQL Profiler to trace the table.

[Former Member]

Hi,

You may check this:

However, goods issue should only have Outqty.

Thanks,

Gordon