ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 2023-03-22 (Joel Lipman) - On creation of Sales Order, create map of line items and created 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...

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

Zoho Books: Generate Bank Text File for Downloadhttp://mail.joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 it: Staff member clicks on button File downloads to their workstation Here's what's happening in the background: File is generated FIle is attached to the last record of the source data File identifying number is returned from being attached File is...

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

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttp://mail.joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 are no contact persons associated with this Invoice. - Encountered when trying to use the send an invoice API - Need the generated invoice to pre-select a contact person to email - Superceded by including "send=true" in the invoice creation request More...

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

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttp://mail.joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 c_ExistingDocument = Document[ID == v_ZC_DocumentRecordID]; info c_ExistingDocument.Document_File; Upload the generated file to the record Note that this is overwriting the existing record and associated file. We have no intention of creating a new...

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

PHP Script: Make your own Thumbnail Generator via APIhttp://mail.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 mobile devices as some images are over 1Mb. So I needed a tool that every time a new product is added, a thumbnail gets generated and stored in the same application. Trawling through the first few pages of Google, all the online tools that did the same...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 as recording payments and checks as to which record is more up to date between ZohoCRM and Xero. How? The access token is generated by a function documented in my previously mentioned article Zoho Deluge - Connect to Xero API so here's the pull of the...

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

Change Regional Settings for your Reporthttp://mail.joellipman.com/articles/microsoft/ssrs/change-regional-settings-for-your-report.html

17 May 2010 Basically I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a...

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

Invalid arguments passed in router.php on line 325http://mail.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 the path on your server. If you're writing a component, then ask yourself if you really need the router.php file. Mine was generated by "http://www.notwebdesign.com/joomla-component-creator/". I don't need one because although I rely on data submitted...

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