SSRS Stop Scrolling Behindhttps://joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 mode is switched on as per the following image: Cycle through each static object and set FixedData to False (ensure all items are set to false or it will error): Save and test on the ReportServer. Background: If you need to visualize how I could have...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

AHK Countdown Tooltiphttps://joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 TrayMenu: Menu, Tray, NoStandard ; Disable standard menu items Menu, Tray, Add, Restart, Restart ; Restart/Reload Script Menu, Tray, Add, Exit, GuiClose ; Terminate script Return ;...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 Joomla v2.5.x database and website files Note the CURRENT super user identification number "ID" and alias (name) Ensure all items are "checked-in" (Do a "Global Check In") Install new Joomla: Install Joomla! CMS v3.4.x with Demo Content (eg. 3rd-party...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Zoho Deluge: Adding / Removing Total Tax from a Quote Recordhttps://joellipman.com/articles/crm/zoho/zoho-deluge-adding-removing-total-tax-from-a-quote-record.html

20 August 2019 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 modified the record, the tax wouldn't apply both visually and...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Standard Setup for Tax Rateshttps://joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

02 September 2021 Information, edit the field "Tax" (multi-select) 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 ticked,...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 and conditions", "customer_id": "234567890123456789", "payment_terms": 30, "salesperson_id": "345678901234567890", "line_items": [ { "item_id": "456789012345678901", "discount": 0, "quantity": 1, "description": "A test product description" } ],...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 // not working // use inventory_items l_Variants.add(m_Variant); m_Product.put("variants",l_Variants); // // do photos if(input.Photos_Changed) { l_AllImages = List(); v_PositionIndex = 0; for each v_ShopifyImageSrc in l_ShopifyPictures {...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: eBay: Get Item Transactionhttps://joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-item-transaction.html

22 January 2022 m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ItemReturnCategories"); // // include fixed price items m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page); m_Pagination.put("EntriesPerPage",v_PerPage);...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Populate a Multi-Lookuphttps://joellipman.com/articles/crm/zoho/zoho-creator-populate-a-multi-lookup.html

18 August 2022 somewhat better to use the built-in interfaces provided by Zoho Creator. What I really needed was a way to display the line items from a package slip taken from Zoho Inventory. I'd prefer if it was included in the list view or a Zoho Creator report....

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoDeluge: Check Shipment Status via DHL APIhttps://joellipman.com/articles/crm/zoho/zohodeluge-check-shipment-status-via-dhl-api.html

21 March 2023 I've set up a nightly schedule which checks on all the shipments from a certain date and updates the shipment status for items that have been delivered: Login to ZohoInventory > Setup (Cog Icon) > Automation > Schedules > New Schedule > I'm calling mine...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Render to PDF with margins and page numbershttps://joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 display:inline-block; min-width:100px; } #my-content table:first-child tr td:nth-child(2){ width: 240px; } /* line items */ #my-line-items thead tr th{ color: #777; text-align:right; text-transform: uppercase; vertical-align: bottom; border-bottom: 1px...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 as an adjustment with the description "Rounding Off": v_TotalAdjustments = 0.00; for each m_ZCrm_LineItem in l_ZCrm_LineItems { v_ListPrice = ifnull(m_ZCrm_LineItem.get("List_Price"),0); if(v_ListPrice.toString().contains(".")) {...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://joellipman.com/articles/crm/zoho/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

28 June 2019 } // // restore item in lookup input.myLookup = l_RememberLookup; // // repopulate lookup options (not selected items) for each r_EntryID in l_AllowedEntries { input.myLookup:ui.add(r_EntryID); } Additional Note(s): If removing elements, even if you are...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB