Assuming order is required, the following 126 results were found.
-
that comes with Zoho Books. We needed a dataset that took into account "Delivery" as a separate line item on the purchase order. I'm writing this article as it had gone through several partners before us and even Zoho themselves without a solution. This...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a reminder on how to read a table from ZohoAnalytics. Why? My use-case here is that we have a client who uses their purchase orders and sales orders as part of a logistics solution where items are purchased from a supplier, sent to another supplier for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
how to use Zoho Deluge to download a file that was uploaded into a Zoho Creator form and then to attach it to a Sales Order in Zoho Books. Why? Because it took me so long to find out how to do this even after reading the official documentation and going...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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? I'm storing this here as a reference and taking the bits that I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
It took a few google searches until I could find out how to change the default weblinks order. A lot of websites showed how to do this via the admin back-end panel in the advanced configuration... I can't see this panel, there is no advanced parameters...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
the week generally starts on a Monday. So let's say there's a schedule that has to be run weekly and include all the orders of a specific week... Just to confuse everyone in the world, the day index for a Sunday is 7 (ie. myDate.toString("u") returns 7)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
(SUBSTRING_INDEX(`name`, '.', -1)*1) AS lastcatid FROM `my_new_database`.my_prefix_assets WHERE `name` LIKE '%.category.%' ORDER BY `lastcatid` DESC LIMIT 0,1); SET @new_jos_assets_last_inc=( SELECT IFNULL(@new_jos_assets_last_inc, 0)); SET...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
that I could find that describes how to do this. When an invoice is created, not by clicking on the "convert sales order to invoice" button, I needed a way to programmatically link the sales order to the invoice. Why? The documentation around the API...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
that's different. So for example, I have data like the following: SELECT DATENAME(dw, StartDate) AS 'Day' FROM Timetable ORDER BY StartDate ASC, AnotherOrderByCol ASC, AndAnotherOrderByCol ASC -- Yields /* Day ---------------- Monday Monday Monday...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
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 record in Zoho Creator. We did the same for when Shopify would...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the Shopify Admin interface, then the following code won't be able to check and restore them. The Code Snippets: The Shopify Order Update notification First create a CRM function called Shopify - Webhook - Order Notification. It's a standalone function...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
API... Why? A follow on from my article Zoho Creator: Push to eBay Listings. I have a Creator app that needs to receive the orders from an eBay account as soon as the order or transaction is made on a Fixed Price item. How? So first of all, you'll need...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
creating a SharePoint List (datasheet) and when I made my form dropdown read from the list, it just put elements in the order that I entered them in the datasheet. Googling this led me to browse MSDN for an hour before I realised all those experts were...
- Type: Article
- Author: Joel Lipman
- Category: Infopath
- Language: *
-
to create a standalone application which lists all the Google Chrome Profiles on your Windows 10 workstation in alphabetical order. Why? This program will be redundant if Google ever update their Chrome browser to list the multiple profiles in...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
probably won't forget this but just in case I do, this is an article to explain how I got the shipping address from a sales order in Zoho Books into the template of the Package Slips. Why? It took me a while of playing about with the placeholder...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL and MySQL, this is not so much of an issue. I get this error when having to use an...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
[IfExists] \modules\mod_rokajaxsearch\mod_rokajaxsearch.xml Stage 1: Add Relevance [Mandatory Stage] We want to order by more than just popularity and/or date, but also by our own relevance heuristics. The following change would give radically high...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
created or date modified - Parameter: Parameter "More Links" prefix text (moved from language file) - Critical: Fixed Custom Order by Weblink ID - Date Uploaded: Thu, 2nd May 2013 2.1.2- Moved "More Links" text to Joomla language file (translatable) -...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
I didn't realize I needed: How to address the above error and how to update a Shipping Address for a specific Sales Order in Zoho Books. Why? You might think the following request to create a Sales Order in Zoho Books would be enough: { "date":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
have -- the same date then they will be numbered the same. Used in -- calculation to determine row record is to display on. [Order] = DENSE_RANK() OVER (ORDER BY d.[Date]), -- date used in all calculations for date d.[Date], --generates matrix columns...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB