SELECT
 dbo.tInvoiceDetail.ID,
 dbo.tInvoice.PlatinumInvoiceNo AS InvoiceNo,
 dbo.tInvoice.CustomerID, dbo.tCustomer.ShipTo, dbo.tCustomer.FullName AS Customer,
 dbo.tBatch.ID AS BatchID,
 dbo.tBatchType.Description AS BatchType, 
 dbo.tInvoiceDetail.ElementID,
 dbo.tSupplier.SupplierName,
 dbo.tBatch.BillingPeriod,
 SUM(dbo.tInvoiceDetail.AmountExGST)
FROM 
 dbo.tInvoice INNER JOIN
 dbo.tInvoiceDetail ON dbo.tInvoice.ID = dbo.tInvoiceDetail.InvoiceID INNER JOIN
 dbo.tBatch ON dbo.tInvoiceDetail.BatchID = dbo.tBatch.ID INNER JOIN
 dbo.tBatchType ON dbo.tInvoiceDetail.BatchTypeID = dbo.tBatchType.ID INNER JOIN
 dbo.tCustomer ON dbo.tInvoice.CustomerID = dbo.tCustomer.ID INNER JOIN
 dbo.tSupplier ON dbo.tBatch.SupplierID = dbo.tSupplier.ID
WHERE  (1=1)
--#  and (dbo.tInvoice.PlatinumInvoiceNo = 'INV018687')
--#  and tCustomer.ShipTo = "HWL"
--#  and tBatch.Id = 39305
GROUP BY 
 dbo.tInvoicedetail.ID,
 dbo.tInvoice.PlatinumInvoiceNo,
 dbo.tInvoice.CustomerID, dbo.tCustomer.ShipTo, dbo.tCustomer.FullName,
 dbo.tBatch.ID,
 dbo.tBatchType.Description,
 dbo.tInvoiceDetail.ElementID,
 dbo.tSupplier.SupplierName,
 dbo.tBatch.BillingPeriod