Untitled

Anonymous
plain_text
01/09/2025 7:43 PM
600 B
11
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