# getinv6 
# is called for each relevant PERIOD
# its SQL is...

SELECT DISTINCT
 tCustomer.Shipto AS Div,
 tInvoice.PlatinumFileName,
 tInvoice.PlatinumInvoiceNo,
 ${transactiontable}.BatchID AS Sundry,
 tSupplier.SupplierName AS Supplier,
 tInvoiceDetail.ElementID,
 tElement.Description,
 tInvoiceDetail.Period,
 ${transactiontable}.InvoiceDetailID,
 tInvoice.InvoiceDate,
 tInvoiceDetail.Description AS InvParticular,
 tElement.ReportGroupID,
 tInvoiceDetail.GSTAmount
FROM ${transactiontable}
INNER JOIN tBatch ON
	tBatch.ID = ${transactiontable}.BatchID
INNER JOIN tSupplier ON
	tSupplier.ID = tBatch.SupplierID
INNER JOIN tElement ON
	tElement.ID = ${transactiontable}.ElementID
INNER JOIN tInvoiceDetail ON
	tInvoiceDetail.ID = ${transactiontable}.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 = "$tbsbillingperiod"
 AND tInvoice.InvoiceDate > dateadd(dd,$IOFFSETDAYS,'$IYYYYMMDD')
 AND tInvoice.InvoiceDate <= dateadd(mm,1,dateadd(dd,$IOFFSETDAYS,'$IYYYYMMDD'))
 $EXCLUDEINVBIT
 $EXCLUDEBATCHIDBIT
ORDER BY
 Div,
 tInvoice.PlatinumFileName,
 tInvoice.PlatinumInvoiceNo,
 tInvoice.InvoiceDate,
 Sundry,
 Supplier,
 tInvoiceDetail.ElementID