How would I go about constructing a query to display batch quantity by bin location AND the date the quantity moved to that bin location. I've been able to build query that displays the date the batch was created but now I really need to see the date the batch quantity moved to the latest bin location. I assuming the data is stored in OBTN and RBTN and do I just need to come up with a way to show the last date associated with the batch?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.