# 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