Sage X3

Trying to create a query based on items that are out on loan to customers. My query includes an Expression calculation based on what has been delivered to a customer minus what has been returned. So using two tables QTY on SORDERQ-RETURND, therefore…

I have the following Graphical query, the two tables are BPCUST AND SINVOICE. How can I set a criteria for it to pull invoices that have a date of 5/01/2018 to 5/30/2018. When I search for this its outputting all the invoices and duplicating…