SELECT AmountOwed, TempSalesID, TheName, Company, UserName, SalesDate
FROM (
SELECT (SELECT SUM(SalesPrice) FROM tempSalesDetail 
        WHERE (tempsales.tempSalesID = tempSalesDetail.tempSalesID)) -
       (SELECT SUM(paymentAmount) FROM Payment 
        WHERE (tempsales.tempSalesID = Payment.tempSalesID)) + 
        tempSales.totalShipping + tempSales.taxableAmount AS AmountOwed,

        tempSales.tempSalesID, 
        Contacts.FIRST_NAME + ' ' + Contacts.LAST_NAME AS theName, 
        company.COMPANY, 
        Users.First_Name + ' ' + Users.Last_Name AS userName, 
        tempSales.SalesDate
  FROM tempSales
  INNER JOIN Contacts ON tempSales.CONTACT_ID = Contacts.CONTACT_ID
  INNER JOIN company ON Contacts.COMPANY_ID = company.COMPANY_ID
  INNER JOIN Users ON tempSales.sentByID = Users.UserID
  WHERE (tempSales.SalesActive = 1) AND (tempSales.salesStatusID = 1)
) X
WHERE X.AmountOwed <> 0