SELECT
 tElement.Description AS Element,
 tServiceID.ServiceID AS ServiceIDDesc,
 tFinalisedTransaction201008.BatchID AS Batch,
 tBatchType.SupplierDisplayedName,
 tLocation.Description AS Location,
 tPerson.Person,
 tCentre.Description AS CustCentre,
 tActivity.Description AS CustActivity,
 tElement_1.Description AS CustElement,
 tSubledger.Description AS CustSubledger,
 tFinalisedTransaction201008.PayType,
 tServiceType.Description AS ServiceType,
 'Victrack' AS InvDetailDesc,
 tBatch.BillingPeriod AS Period,
 tCustomer.ShipTo,
 'VRT999999' AS PlatinumInvoiceNo,
 SUM(tFinalisedTransaction201008.AmountExGST) AS ExGST,
 SUM(tFinalisedTransaction201008.GSTAmount) AS GST,
 SUM(tFinalisedTransaction201008.AmountIncGST) AS IncGST,
 tTransactionGroup.Description AS TxnGrp,
 tFinalisedTransaction201008.Var01,
 tFinalisedTransaction201008.Var02,
 tFinalisedTransaction201008.Var03,
 tFinalisedTransaction201008.Var04,
 tFinalisedTransaction201008.Var05,
 tBatchType.Description,
 tReportGroup.GroupDesc,
 tDepartment.Description AS DeptDesc
FROM
 tServiceType
 RIGHT OUTER JOIN tElement
 RIGHT OUTER JOIN tLocation
 RIGHT OUTER JOIN tPerson
 RIGHT OUTER JOIN tTransactionGroup
 RIGHT OUTER JOIN tTransactionType
 ON tTransactionGroup.ID = tTransactionType.TransactionGroupID
 RIGHT OUTER JOIN tElement tElement_1
 RIGHT OUTER JOIN tInvoice WITH (NOLOCK)
 LEFT JOIN tInvoiceDetail WITH (NOLOCK)
 ON tInvoice.ID = tInvoiceDetail.InvoiceID
 RIGHT OUTER JOIN tCustomer
 ON tInvoice.CustomerID = tCustomer.ID
 INNER JOIN tFinalisedTransaction201008
	INNER JOIN tBatch
	 ON tBatch.ID = tFinalisedTransaction201008.BatchID
 ON tInvoiceDetail.ID = tFinalisedTransaction201008.InvoiceDetailID
 RIGHT OUTER JOIN tBatchType WITH (NOLOCK)
 ON tInvoiceDetail.BatchTypeID = tBatchType.ID
 ON tElement_1.ID = tFinalisedTransaction201008.CustomerElementID
 LEFT OUTER JOIN tActivity
 ON tFinalisedTransaction201008.CustomerActivityID = tActivity.ID
 LEFT OUTER JOIN tSubledger
 ON tFinalisedTransaction201008.CustomerSubledgerID = tSubledger.ID
 LEFT OUTER JOIN tCentre
 ON tFinalisedTransaction201008.CustomerCentreID = tCentre.ID
 LEFT OUTER JOIN tDepartment ON tCentre.DepartmentID = tDepartment.ID
 ON tTransactionType.ID = tFinalisedTransaction201008.TransactionTypeID
 ON tPerson.ID = tFinalisedTransaction201008.PersonID
 ON tLocation.ID = tFinalisedTransaction201008.LocationID
 ON tElement.ID = tFinalisedTransaction201008.ElementID
 ON tServiceType.ID = tFinalisedTransaction201008.ServiceTypeID
 LEFT OUTER JOIN tReportGroup
 ON tBatchType.ReportGroupID = tReportGroup.ID
 FULL OUTER JOIN tServiceID
 ON tFinalisedTransaction201008.ServiceID = tServiceID.ID
GROUP BY
 tElement.Description, tServiceID.ServiceID,
 tFinalisedTransaction201008.BatchID,
 tBatchType.SupplierDisplayedName, tLocation.Description, 
 tPerson.Person, tCentre.Description, tServiceType.Description,
 tSubledger.Description, 
 tBatch.BillingPeriod, tCustomer.ShipTo,
 tFinalisedTransaction201008.Var01, tFinalisedTransaction201008.Var02,
 tFinalisedTransaction201008.Var03, tFinalisedTransaction201008.Var04, 
 tFinalisedTransaction201008.Var05,
 tBatchType.Description, tReportGroup.GroupDesc, tTransactionGroup.Description, 
 tDepartment.Description, tFinalisedTransaction201008.PayType,
 tActivity.Description, tElement_1.Description
HAVING
 (tCustomer.ShipTo = 'VRT')
ORDER BY
 tCentre.Description