I would appreciate some help with making a query for the following scenario:
Is it possible to show all items where on hand is larger than 0 and has no inventory transactions for a given period of time.
I'm really looking for all items that are in-active - that only lies still in the wearhouse.
Please tell me if any clarifications is needed.
Thanks and regards.