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