Assuming price is required, the following 32 results were found.
-
"PO Ref", poi."Product ID" AS "PO Product ID", poi."Item ID" AS "PO Item ID", poi."Item Name" AS "PO Item Name", poi."Item Price (BCY)" AS "PO Item Price", poi."FCY Tax Amount" / if(poi."Quantity" = 0, 1, poi."Quantity") AS "PO Item Tax", poi."Quantity"...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
A quick article on how to get the pricebook entry using Zoho Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine by going through forum posts from 7 years to 2 years ago. The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
(0)1234 567890 info@mycompany.com www.mycompany.com QUOTE Quote For: Quote Date: Quote By: Item Description Quantity Unit Price Unit Discount 0) { v_LineItemTotal = 0.00; v_ThisQuantity = ifnull(c_Quote.Quantity,1).toLong(); v_TotalQuantity =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
= ifnull(p_SKU,""); v_GraphQl = "{ productVariants(first: 1, query: \"sku:'"+v_SearchSKU+"'\") { edges { node { id price sku title barcode inventoryItem { id } product { id } } } } }"; m_GraphQl = Map(); m_GraphQl.put("query", v_GraphQl); // // Send...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
o_NewLineItem.Exchange_Rates_1 = o_ThisLineItem.Exchange_Rates_1; o_NewLineItem.List_Price = o_ThisLineItem.List_Price; o_NewLineItem.Manufacturer = o_ThisLineItem.Manufacturer; o_NewLineItem.Margin = o_ThisLineItem.Margin; o_NewLineItem.Net_Total =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
of truth and Zoho is the data to be overwritten, ensuring that Product IDs, Variant IDs, Inventory IDs, Current Selling Price, Inventory Level, and Barcode all match. Our problem is that sometimes more than 100 products are modified in a day... We need...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
progress eg. ($8 / $10) * 100 = 80% ie. $8 of $10 is 80% To determine the percent (adjustment level) given the RRP and the price you're selling at: ((Agreed Price - Usual Price) * 100) / Usual Price = % eg. ($10 - $8) * 100 / $8 = +25% ie. selling an $8...
- Type: Article
- Author: Joel Lipman
- Category: eCommerce Systems
- Language: *
-
print, Zoho had recently introduced the ability to have custom fields in your line items, alongside the product name, list price, quantity, tax, etc. In the example below, we have added a column called "Group Name" in the CRM Quote module as per the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
way by its authors. You can apply it to your programs, too. When we speak of free software, we are referring to freedom, not price. Our General Public Licenses are designed to make sure that you have the freedom to distribute copies of free software...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
}, "data": { "member_id": "123456", "channel_name": "shopify", "item_name": "Joel's Awesome Life", "item_price": "priceless" } } What Zoho sends to the 3rd-party API: Sending a map request using the invokeUrl() function, the odd thing is that Zoho's...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
po."Purchase Order Date" AS "PO Date", po."Purchase Order Status" AS "PO Status", poi."Item Name" AS "PO Item", poi."Item Price (BCY)" AS "PO Item Price", poi."Graded Score" AS "PO Item Grade", poi."Quantity" AS "PO Item Qty", poi."Quantity Billed" AS...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
m_NewLineItem.put("Quantity",m_LineItem.get("Quantity")); m_NewLineItem.put("List_Price",m_LineItem.get("List_Price")); l_NewLineItems.add(m_NewLineItem); } } } // // if there is reason to update it then let's update CRM API v7 style...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
.sub-content{ margin-left: 14px; } Photo View List View Product Name #1 Product SKU #1 Product Description #1 Product Price #1 Product Name #2 Product SKU #2 Product Description #2 Product Price #2 Product Name #3 Product SKU #3 Product Description #3...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
v_LineItem_Name = r_QuoteDetails.Product_Name; v_LineItem_Desc = r_QuoteDetails.Product_Description; v_LineItem_Price = r_QuoteDetails.Product_List_Price; v_LineItem_Quantity = r_QuoteDetails.Product_Quantity; v_LineItem_TaxAmount =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
This is an article to document how I got a client's eBay to notify the seller every time a buyer bought a fixed price item. This uses the Trading API even though I'm aiming for the Platform Notifications API... Why? A follow on from my article Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
get a validation error on the decimal field even if that's not the field that is being changed: Decimal places for the Unit Price field should be less than or equal to 6 . How? The workaround for staff is to round this up manually and then save the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
an invoice, there's a strong chance of being a cent/penny off. Let's take the following example of an item with a list price of 12345.545: ZohoCRM Line Item ZohoBooks Line Item How? Here's the immediate solution I have applied now until Zoho enable an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
}, "quantity": 1, "Discount": 0, "total_after_discount": 0, "net_total": 0, "book": null, "Tax": 0, "list_price": 0, "unit_price": 0, "quantity_in_stock": 0, "total": 0, "id": "1642130000047106029", "product_description": null, "line_tax": [] } ],
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= Quotes.Line_Items(); r_Row.Product = m_LineItem.get("Product"); r_Row.Quantity = m_LineItem.get("Quantity"); r_Row.List_Price = m_LineItem.get("List_Price"); r_Row.Tax = m_LineItem.get("Tax"); r_Row.Discount = m_LineItem.get("Discount"); r_Row.Total =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
a client's eBay store. Why? The use-case was that I wanted to retrieve a list of all the listed active products in a fixed price item listing. The example below is a function which, if given the page number and the number of entries per page, returns...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *