SELECT DISTINCT
 tCustomer.Shipto AS Div,
 tInvoice.PlatinumFileName,
 tInvoice.PlatinumInvoiceNo,
 tFinalisedtransaction201107.BatchID AS Sundry,
 tSupplier.SupplierName AS Supplier,
 tInvoiceDetail.ElementID,
 tElement.Description,
 tInvoiceDetail.Period,
 tFinalisedtransaction201107.InvoiceDetailID,
 tInvoice.InvoiceDate,
 tInvoiceDetail.Description AS InvParticular,
 tElement.ReportGroupID,
 tInvoiceDetail.GSTAmount
FROM tFinalisedtransaction201107
INNER JOIN tBatch ON
        tBatch.ID = tFinalisedtransaction201107.BatchID
INNER JOIN tSupplier ON
        tSupplier.ID = tBatch.SupplierID
INNER JOIN tElement ON
        tElement.ID = tFinalisedtransaction201107.ElementID
INNER JOIN tInvoiceDetail ON
        tInvoiceDetail.ID = tFinalisedtransaction201107.InvoiceDetailID
INNER JOIN tInvoice ON
        tInvoiceDetail.InvoiceID = tInvoice.ID
INNER JOIN tCustomer ON
        tInvoice.CustomerID = tCustomer.ID
WHERE
 tInvoice.PlatinumInvoiceNo IS NOT NULL
 AND tInvoiceDetail.Period = '2011/07'
 AND tInvoice.InvoiceDate > dateadd(dd,9,'20110731')
 AND tInvoice.InvoiceDate <= dateadd(mm,1,dateadd(dd,9,'20110731'))
ORDER BY
 Div,
 tInvoice.PlatinumFileName,
 tInvoice.PlatinumInvoiceNo,
 tInvoice.InvoiceDate,
 Sundry,
 Supplier,
 tInvoiceDetail.ElementID