I am trying to write a query that will mimic OINM (the old warehouse journal) or OIVL (the new warehouse journal) - and adapt it to my requirements.
Since OINM is a view, it should be possible to write a query to generate it.
Does anybody have such a query? or refer me to a relevant thread? or a place where I can get ideas? or even outline the strategy to develop it?
This will help me greatly as a starting point so that I can develop mine.
Any help will be much appreciated.