Untitled

 avatar
unknown
plain_text
2 months 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,'') = ''"
Editor is loading...
Leave a Comment