Untitled

 avatar
unknown
plain_text
a month ago
450 B
0
Indexable
If UCase(Left(GetSystemSetting("RequireCallTypeToInvoice"), 1)) = "Y" Then
        strSQL = "SELECT ExportInvoiceList.InvoiceNumber AS InvoiceNumber " _
        & "FROM ExportInvoiceList INNER JOIN Dispatch ON ExportInvoiceList.InvoiceNumber = Dispatch.InvoiceNumber " _
        & "LEFT JOIN CallTypeList ON Dispatch.CallType = CallTypeList.CallType " _
        & "WHERE ExportInvoiceList.Selected <> 0 AND ISNULL(CallTypeList.AccountNo,'') = ''"
Leave a Comment