We discovered a bug in our program where there are some instances of a doubled value. I am trying to write a query to find all instances of this doubled value.
Right now I am using
WHERE (GRIR.ReceivedQty > GRIR.OrderedQty)
And this shows any instance where the "Received" is greater than the "Ordered" but it's returning lots of data that I don't need. (e.g. 41 received where 40 ordered, this is fine and non-issue)
How can I compare my Received against Ordered where the Received is exactly double the Ordered value. (e.g. 8 received and 4 ordered)
Thank you for your time.