Search - Joel Lipman .Com

1. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... at least 1 line item is mandatory l_CrmProductLineItems = r_CrmProductLineItems.get("data").get(0).get("Quoted_Items"); for each r_CrmLineItem in l_CrmProductLineItems { m_BooksLineItem = Map(); v_BooksItemID ...; Created on 18 September 2023
2. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... "ITEM CREATE RESPONSE FOR " + v_ItemID; info r_CreateItem.get("message"); Error(s) Encountered items with opening stock cannot be deleted, set the opening stock to zero: Guess who's going to hav ...; Created on 04 May 2023
3. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
4. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
5. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonProducts = List(); // // start preparing CSV file to email for export v_ReportCSV = "ItemID,ItemName,Price,CurrencyCode,QuantityAvailable,SKU,DateCreated"; l_CsvFileRows ...; Created on 01 March 2023
6. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
7. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... ntity") OR invitm."SO ItemID" = t1."SO Item ID" LEFT OUTER JOIN( SELECT i2."Invoice ID" AS "Invoice ID", COUNT(ii2."Quantity") AS "InvItm Line Count" FROM "Invoice Items" ii2 LEFT JOIN "Inv ...; Created on 03 November 2022
8. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... Upgrade // // ZohoBooks Organization ID v_BooksOrgId = 12345678; // // Zoho Books Item ID v_ZB_ItemID = 123456000000789012; // // download photo v_ImageSrc = "https://picsum.photos/200"; r_DownloadedPhoto ...; Created on 21 June 2022
9. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... Name: fn_eBay_UploadPhoto Display Name: Fn - eBay - Upload Photo Description: What it says on the tin Category: Standalone Click on Create Give it the parameter/argument p_InventoryitemID as ...; Created on 31 March 2022
10. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... can use the following code, note that the parameter is the eBay Item ID: void API.fn_eBayQuery_GetItemTransaction(int p_ItemID) { /* Function: fn_eBayQuery_GetItemTransaction() Input: ...; Created on 22 January 2022
11. 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 ...; Created on 21 January 2022
12. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... uncomment this when all products retrieved and to run this to just get latest products // m_ActiveList.put("Sort","ItemIDDescending"); m_ActiveList.put("Sort","ItemID"); m_Params.put("ActiveList",m_ActiveList); // // ...; Created on 13 October 2021
13. Zoho Deluge: Associate/Link an Invoice to a Sales Order: / Zoho /; ... up a reference map from the line items of the newly created sales order m_NewLineItems = Map(); for each r_NewLineItem in r_NewSoDetails.get("line_items") { v_NewSoItemID = r_NewLineItem.get("item_id"); ...; Created on 10 March 2020
14. SSRS Dropdown parameter cannot be blank!: / SQL Server Reporting Services /; ... entry and the end-user will be none the wiser. OLD: Dataset to populate the dropdown SELECT Name, ItemID FROM Catalog WHERE Type = 2 ORDER BY Name ASC NEW: ...; Created on 14 December 2011
15. Performance Report - Background colors based on dataset values: / SQL Server Reporting Services /; ... c ON e.ReportID = c.ItemID WHERE e.[ReportID] = @ReportParameter1 union all SELECT TOP 1 c.[Name] AS [ReportName] , e.[ReportID] AS [ReportID] , e.[TimeStart] AS [TimeStamp] , e.[Parameters] ...; Created on 02 December 2011
16. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; ... e.TimeDataRetrieval + e.TimeProcessing + e.TimeRendering AS TotalTime FROM [ExecutionLog] e INNER JOIN [Catalog] c ON c.ItemID=e.ReportID WHERE c.Name='My Amazing Report' -- just change the value ...; Created on 17 November 2011
17. The ReportServer Database: / Databases /; ... ,a.[Status] ,a.[ByteCount] ,a.[RowCount] FROM [ReportServer].[dbo].[ExecutionLog] a INNER JOIN [ReportServer].[dbo].[Catalog] b ON a.ReportID = b.ItemID The Top 5 Most ...; Created on 08 August 2011
18. Before and After, Highs and Lows: / SQL Server Reporting Services /; ... AS YearRun, COUNT(Catalog.Name) AS Counter FROM ExecutionLogStorage INNER JOIN Catalog ON ExecutionLogStorage.ReportID = Catalog.ItemID WHERE (Catalog.Type = 2) AND ...; Created on 03 August 2011
19. How to redirect the visitor after the contact page: / Joomla /; ... .’&Itemid=’. $Itemid; mosRedirect( $link, _THANK_MESSAGE ) replace that code with the URL for the contact Thank-you page as defined as follows: $link = sefRelToAbs( 'index.php?option=com_contact&task=view&contact_id='. ...; Created on 06 September 2009
20. Header (Transparent): Created on 01 January 2018