Invoiced sales report

I would typically run the non-summarized version and spot check the data first, that may help (throw an * after your last field). You may have multiple shipments on an invoice so I would summarize your miscellaneous charge table first (or use the miscellaneous charge off the invoice header). It could be sales is only interested in Shipments and you're including advanced billing and deposits. There is also a posted flag. For our reports I exclude non-posted as well as advanced billing and deposit invoices.


[Non-text portions of this message have been removed]
We are looking to get the invoiced sales of closed invoices, minus misc charges, filtering our house accounts (CheckBox01 denotes a house account when true). Please look at my SQL below and see if I am going to get the desired result. Sales is telling me all my numbers are off and too high.

SELECT
SUM(i.InvoiceAmt) AS "InvoiceTotal",
SUM(ABS(m.DocMiscAmt)) AS "MiscChrgs",
(SUM(i.InvoiceAmt) - SUM(ABS(m.DocMiscAmt))) AS "InvoiceSales - Misc",
s.TerritoryDesc,
MONTH(i.InvoiceDate) AS "InvoiceMonth"
FROM
InvcHead i
LEFT OUTER JOIN
Customer c ON i.CustNum = c.CustNum
LEFT OUTER JOIN
InvcMisc m ON i.InvoiceNum = m.InvoiceNum
LEFT OUTER JOIN
SalesTer s ON c.TerritoryID = s.TerritoryID
WHERE
c.CheckBox01 = 0 AND
i.OpenInvoice = 0 AND
i.InvoiceDate BETWEEN '2012-01-01 00:00:00.000' AND '2012-12-31 00:00:00.000'
GROUP BY
s.TerritoryDesc, MONTH(i.InvoiceDate)
ORDER BY
MONTH(i.InvoiceDate) ASC