JOEL LIPMAN Systems / Automation / AI

Knowledge base / Since 1999

Scripts, systems & field notes.

Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.

Advanced search

480 entries / matching AI

Clear filters
Zoho Books: Improper Statement Error might be due to missing ';'
Zoho Books

Zoho Books: Improper Statement Error might be due to missing ';'

A quick article on a misleading error when saving a Deluge custom function in Zoho Books: Check and update the code in line 122 as there is a Exception : Error at line :124 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression Another variation encountered during troubleshooti...

Read note 77 hits
Zoho MCP in 2026: What Claude Can Actually Do Inside Zoho CRM
Zoho CRM

Zoho MCP in 2026: What Claude Can Actually Do Inside Zoho CRM

Zoho's MCP (Model Context Protocol) server lets AI assistants such as Claude connect directly to Zoho CRM and work with your live data through natural language. Rather than you clicking through views and filters, the AI can read your pipeline, summarise deal status, flag stale records, bulk-update f

Read note 103 hits
Zoho Books: Change a Purchase Order's Delivery Address over API
Zoho Books

Zoho Books: Change a Purchase Order's Delivery Address over API

A note on changing a Zoho Books purchase order's delivery address while creating supplier orders from an accepted Zoho CRM Quote. My original method created an organisation address in Books and assigned its ID to a purchase order. This updated version adds a delivery address to the customer instead, then uses that cust...

Read note 195 hits
Zoho Billing: Workflow does not exist!
Zoho Books

Zoho Billing: Workflow does not exist!

This is an article about a Zoho Billing custom function that worked when it was executed manually but did not run automatically when a new invoice was created. The custom function was configured with the Invoice Created trigger. However, opening the function displayed the following message: Workflow does not exist! Inv...

Read note 265 hits
Zoho Deluge - Calculate Portion Count
Zoho Deluge

Zoho Deluge - Calculate Portion Count

A function to calculate how many trays of each available size are needed for a requested number of portions. Pass in the portion count and a list of tray capacities, and Ascent.fn_CalculatePortionCount returns a map of tray sizes to quantities. The important detail is what “best” means: first minimise surplus capacity...

Read note 278 hits

Working principle

Our Purpose

This site exists as a practical knowledge base built from real-world experience across systems, platforms, and technologies since 1999. Much of the content documents solutions, edge cases, and working patterns that were learned through investigation where documentation was incomplete or absent, and is shared to reduce the same friction for others.

27 Years in IT
1021 CRM clients
819 Site articles
30.1m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.