Skip to Content
0
Feb 22, 2011 at 07:13 AM

Query on item with ST Transactions

209 Views

hello all,

i have created the ff. query

SELECT * FROM OINM T0 WHERE T0.[TransType] = '58' and T0.[DocDate] between '[%0]' and '[%1]'

to check inventory posting in WH. am i making a query in the right table?

we are currently doing an inventory count in our WH, since we are still correcting our count i want to know which items has already have an ST transactions (Inventory Posting) and also i want to know which items that still do not have an ST Transactions, the reason i want to know the ff. details becaus some of our items have count in WH but no actual was counted during the physical count, so if i will know which items has a count in sbo but no ST transactions meaning the count should be Zero since no actual counted.

please help.

thanks.

Fidel