Search - Joel Lipman .Com

1. Static Items: / Category /; Created on 05 March 2020
2. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; What? This is a quick article documenting how to update custom fields in a line items or product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. ...; Created on 17 May 2021
3. Zoho Deluge - Modify the product line items in an invoice module: / Zoho /; ... record: v_Index = 0; m_Update = Map(); l_ProductItems = List(); r_InvoiceDetails = Map(); r_InvoiceDetails = zoho.crm.getRecordById("Invoices",p_InvoiceID); for each r_ProductLineItem in r_InvoiceDetails.get("Product_Details") { ...; Created on 22 August 2019
4. Ordered List of over 1000 Items: / Cascading Stylesheets /; What? So many people asking this when the solution is a bit of aesthetic styling. ol -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item ...; Created on 08 February 2013
5. K2 Items disappear: / Joomla /; Basically you've woken up this morning, visited your website, and all your K2 articles are gone !!!! If you login to your Joomla! administration panel (back-end) and look under k2 items, you should ...; Created on 27 August 2010
6. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... include fixed price items m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page); m_Pagination.put("EntriesPerPage",v_PerPage); m_Params.put("Pagination",m_Pagination); //m_ActiveList.put("Sort","ItemID"); m_Params.put("ItemID",p_ItemID); // // ...; Created on 22 January 2022
7. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an order ...; Created on 21 January 2022
8. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... e = "My Test Document"; r_DownloadResponse.setFileName(v_Filename + ".pdf"); r_AttachResponse = zoho.crm.attachFile("Quotes",p_QuoteID,r_DownloadResponse); Use a subform (eg. Product Line Items) ...; Created on 21 October 2021
9. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... // deprecated // use inventory_levels m_Variant.put("inventory_policy","deny"); m_Variant.put("inventory_management","shopify"); m_Variant.put("inventoryItem",); // not working // use inventory_items l_Variants.add(m_Variant); m_Product.put("variants",l_Variants); // / ...; Created on 17 October 2021
10. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... include fixed price items m_ActiveList = Map(); m_ActiveList.put("Include","true"); m_ActiveList.put("ListingType","FixedPriceItem"); m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page); m_Pagination.put("EntriesPerPage",v_PerPage); m_ActiveList.put("Pagination",m_Pagination); // ...; Created on 13 October 2021
11. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... line item l_LineItems = List(); r_SoDetails = zoho.crm.getRecordById("Sales_Orders",0123456789012345678); for each r_LineItem in r_SoDetails.get("Product_Details") { m_LineItem = Map(); if(r_LineItem.get("Tax") ...; Created on 24 September 2021
12. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... Test Reference", "terms": "These are our test terms and conditions", "customer_id": "234567890123456789", "payment_terms": 30, "salesperson_id": "345678901234567890", "line_items": [ { ...; Created on 22 September 2021
13. Zoho CRM: Standard Setup for Tax Rates: / Zoho /; ... and select both tax rates Now go to a transactional module that has line items and use the product When you click on the edit icon in the line item "Tax" you will see both options available to be ...; Created on 02 September 2021
14. Xero API: Send Multiple Invoices: / Xero /; ... "Date": "2021-08-13", "LineItems": [ { "Description": "My expensive product #1", "Quantity": 1, "UnitAmount": 240, "TaxType": "OUTPUT2", ...; Created on 15 August 2021
15. Zoho Creator: Add a subform while creating a record: / Zoho /; ... a quote record and include a subform containing the line items. You may have tried code where you add a record first and then add the subform afterwards (insert into [...]) but it can be done all in one ...; Created on 14 July 2021
16. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... all the selected (ticked) records. The example below documents a report of Quotes where we want to merge all the product line items of each quote into one single quote. Why? I've written this ...; Created on 06 December 2020
17. Zoho Deluge: Associate/Link an Invoice to a Sales Order: / Zoho /; ... updating multiple fields at the same time. How? Through sweat and perseverance. The trick is to update both the sales order id and to update the invoice line items with their respective sales ...; Created on 10 March 2020
18. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... = "https://inventory.zoho.com/api/v1/items?organization_id=123456789"; r_Response = invokeurl [ url :v_DataEndpoint type :POST parameters:m_CreateRecord headers:m_Header ]; Solution: My endpoint ...; Created on 06 February 2020
19. Zoho Deluge: Adding / Removing Total Tax from a Quote Record: / Zoho /; What? A quick reminder on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it ...; Created on 20 August 2019
20. Zoho Deluge - Store and repopulate a multi lookup list in Creator: / Zoho /; ... l_AllowedEntries.add(v_thisID); } // // restore item in lookup input.myLookup = l_RememberLookup; // // repopulate lookup options (not selected items) for each r_EntryID in l_AllowedEntries { ...; Created on 28 June 2019