CLeaning up DBC prior to moving an app into VFP8, and the following view is giving me grief as far as the grouping. Can someone let me know what the problem is?

SELECT facilitydata.facilityname AS facility_name, invoices.invdate AS show_date,  ;
  SUM(invoices.cashpaid+invoices.payroll+invoices.ccard+invoices.pcheck-invoices.salestax-invoices.shipcost) AS TOTAL,  ;
  ROUND(SUM(invoices.cashpaid+invoices.payroll+invoices.ccard+invoices.pcheck-invoices.salestax-invoices.shipcost)*facilitydata.facrebate*0.01,2) AS facility_rebate,  ;
  ROUND(SUM(invoices.cashpaid+invoices.payroll+invoices.ccard+invoices.pcheck-invoices.salestax-invoices.shipcost)*facilitydata.discountrate*0.01,2) AS employee_disc,  ;
  IIF(facilitydata.payroll,"Yes","No ") AS payroll ;
  FROM  lposdata!facilitydata ;
  inner JOIN lposdata!customers    ;
  inner JOIN lposdata!invoices    ;
  ON  customers.custnumid = invoices.custnumid    ;
  ON  facilitydata.facilityid = customers.facilityid;
  GROUP BY 1,2 ;
  ORDER BY facilitydata.facilityname, invoices.invdate