regarding "Discrete Job Pick List Report"
I will zero the on hand of revision B and move it to revision A. In this test case, the two lines should continue to display- Revision A should display because we have a quantity on hand, and Revision B should display because it is the current revision listed in the Discrete Job (even though there is no on hand for this revision.
example:-
how to write any condition/query?