Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming cancelled is required, the following 10 results were found.

  1. ZohoCRM GetRelatedRecords INVALID_DATAhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-getrelatedrecords-invalid_data.html

    Function: string standalone.fn_Deal_UpdateRelatedToCancelled() Label: Fn - Customer Deals - Cancel Related Records Trigger: Standalone Purpose: For any deal which is cancelled, cancel its related sales orders. Inputs: - Outputs: - Date Created:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    v_ThisTill = r_TimeOff.get("To").toDate(); v_ClashOrNot = "NO Clash with "; if(v_ThisStatus!="Cancelled") { if(v_CompareDateFrom = v_ThisFrom || v_CompareDateFrom = v_ThisTill) { v_TotalClashes = v_TotalClashes + 1; v_ClashOrNot = "Clashes with "; }...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  3. Zoho CRM Client Script: Map Quote to Invoicehttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-map-quote-to-invoice.html

    // loop through related sales orders for (var i = 0; i...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. ZohoCRM & Xero: Function to pull most recent invoiceshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    to Customer"); m_TranslateStatuses.put("PAID","Paid in Full"); m_TranslateStatuses.put("DELETED","Cancelled"); m_TranslateStatuses.put("VOIDED","Cancelled"); // // Xero Tax Rates translated to Zoho Tax Rate (manual reference) r_ZohoTaxRates =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    m_TranslateStatuses.put("SENT","Sent to Customer"); m_TranslateStatuses.put("DECLINED","Cancelled / Rejected"); m_TranslateStatuses.put("ACCEPTED","Approved by Customer"); m_TranslateStatuses.put("INVOICED","Converted to Sales Order");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. Parameters not being used in report processinghttps://joellipman.com/component/content/article/parameters-not-being-used-in-report-processing.html?catid=75&Itemid=165

    - 1, @baseDate) = @SelectedDate AND wm.[WeekNumber] = @weekNumber AND tt.[SiteId] = @siteId AND tt.[Status] 3 -- Remove cancelled bookings AND upper(sd.[Descrip]) not like 'ADDITIONAL TIMETABLE%' ORDER BY Date ASC, Room ASC, tt.[StartTime] ASC,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  7. Joe's Unduplicater (JUD)https://joellipman.com/component/content/article/joes-unduplicater.html?catid=53&Itemid=165

    send them to the "Recycle Bin". Say you've got 100 media files, you sat there patiently waiting for 50 to convert and then cancelled the process for some reason. Your option is then to manually go through both folders and check which ones have already...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  8. Zoho Deluge: Get All Orders from eBayhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-all-orders-from-ebay.html

    estimates v_MaximumOrders = 10000; v_Year = 2022; // // set the filter for orders by status to return: All, Active, Cancelled, CancelPending, Completed, Inactive, InProcess v_OrderStatus = "All"; // // calculate from and till v_OrdersFrom = v_Year +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  9. ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://joellipman.com/articles/crm/zoho/zoho-inventory/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

    SO (fix to invoice only generated on edit) Date Modified: 2023-03-29 (Joel Lipman) - If an eBay order comes through as cancelled, then void the sales order, void the invoice, delete the package and shipment. - Added chart of accounts lookup to set...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  10. Zoho CRM: Remove Duplicate Product Recordshttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-remove-duplicate-product-records.html

    be deleted") && r_Delete.containsIgnoreCase("involved in inventory record")) { l_DebugNotes.add("CANCELLED DELETION. Deleting Keep ID: " + v_KeepID); m_Delete = Map(); m_Delete.put("module","Products"); m_Delete.put("id",v_KeepID.toString()); r_Delete =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
Results 1 - 10 of 10