SELECT     dbo.SalesInvoice.SalesInvoiceID, SUM(dbo.SODISPATCHDET.QTY * dbo.SALESORDERDET.UNITCOST) AS Total, dbo.SALESORDER.EXCHRATE, 
                      dbo.INCOTERMS.TRADENAME, dbo.CURRENCIES.CURRENCYNAME, dbo.CUSTOMER.COUNTRY, dbo.PACKING.RemovalTime, 
                      dbo.CURRENCIES.PRECISION, dbo.PACKING.PACKINGID, dbo.INCOTERMS.TRADETERMS, dbo.SalesInvoice.SalesInvoiceNO
FROM         dbo.SalesInvoice INNER JOIN
                      dbo.SODISPATCH ON dbo.SalesInvoice.SODISPATCHID = dbo.SODISPATCH.SODISPATCHID INNER JOIN
                      dbo.SODISPATCHDET ON dbo.SODISPATCH.SODISPATCHID = dbo.SODISPATCHDET.SODISPATCHID INNER JOIN
                      dbo.SALESORDERDET ON dbo.SALESORDERDET.SALESORDERDETID = dbo.SODISPATCHDET.SALESORDERDETID INNER JOIN
                      dbo.SALESORDER ON dbo.SALESORDER.SALESORDERID = dbo.SALESORDERDET.SALESORDERID INNER JOIN
                      dbo.CURRENCIES ON dbo.CURRENCIES.CURRENCIESID = dbo.SALESORDER.CURRENCIESID INNER JOIN
                      dbo.INCOTERMS ON dbo.SALESORDER.INCOTERMSID = dbo.INCOTERMS.INCOTERMSID INNER JOIN
                      dbo.CUSTOMER ON dbo.SALESORDER.CUSTOMERID = dbo.CUSTOMER.CUSTOMERID INNER JOIN
                      dbo.PACKING ON dbo.PACKING.SALESINVOICEID = dbo.SalesInvoice.SalesInvoiceID
WHERE     (NOT (dbo.PACKING.Remarks IS NULL))
GROUP BY dbo.SalesInvoice.SalesInvoiceID, dbo.SALESORDER.APPROVE, dbo.SALESORDER.EXCHRATE, dbo.INCOTERMS.TRADENAME, 
                      dbo.CURRENCIES.CURRENCYNAME, dbo.CUSTOMER.COUNTRY, dbo.PACKING.RemovalTime, dbo.CURRENCIES.PRECISION, 
                      dbo.PACKING.PACKINGID, dbo.INCOTERMS.TRADETERMS, dbo.SalesInvoice.SalesInvoiceNO
HAVING      (dbo.SALESORDER.APPROVE = 1)