Assuming amount is required, the following 24 results were found.
-
or on the phone. They bring up the invoie in ZohoBooks, click on the button, and the Stripe terminal will ask for the amount on the invoice. Well almost. We've gone the extra step in that we added a custom field that can override the full balance, to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
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" AS "PO Qty", poi."FCY Tax Amount" AS "PO Line...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
* v_ThisQuantity; v_TotalPrice = (v_TotalPrice + v_PriceTotal).round(2); // v_DiscountDisplay = if(c_Quote.Discount_Amount && c_Quote.Discount_Amount > 0,v_CurrencyHtmlEntity + c_Quote.Discount_Amount.round(2),"-"); v_DiscountValue =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Use parenthesis for precedence. Pagination: LIMIT offset, limit: v_CoqlQuery = "select id, Deal_Name from Deals where ((Amount=0) and (Stage != 'Cancelled')) limit 400,2"; // returns 2 deals after the first 400 records // OR v_CoqlQuery = "select id,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
To determine what percent a number is of a total number: (Progress So Far / Total Progress Units) * 100 = % or (Net Amount / Gross Amount) * 100 = % eg. (12 steps / 30 steps) * 100 = 40% ie. 12 steps of 30 is 40% progress eg. ($8 / $10) * 100 = 80% ie....
- Type: Article
- Author: Joel Lipman
- Category: eCommerce Systems
- Language: *
-
into your bank account, only to be refused weeks later. At this point, the bank/building society will take the full cheque amount back out of your account. This would then leave you out of pocket for the amount on the cheque and the amount you passed on...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
l_HeaderColumns.add({"key":"po_ref","value":"Ref"}); l_HeaderColumns.add({"key":"po_status","value":"Status"}); // amount/total is a currency column we want aligned on the right l_HeaderColumns.add({"key":"po_amount","value":"PO...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
{ if(!isNull(m_XeroPayment.get("PaymentID"))) { v_PaidTotal = v_PaidTotal + m_XeroPayment.get("Amount"); } } v_CrmInvoiceStatus = if(v_PaidTotal == v_InvoiceTotal,"Paid in Full","Partially Paid"); } m_UpsertCrmInvoice.put("Status",v_CrmInvoiceStatus);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
// going to create a new set of line items a_NewSuformRows.push(o_NewLineItem); } } } // determine deposit amount // get grand total (note that formula for grand total excludes line items which were optional) v_QuoteGrandTotal = 0.00; r_QuoteDetails =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
A ternary operator for those who are unfamiliar with this is an "If...Then...Else..." statement written in a small amount of code, usually on one line, and exists in most programming languages. For Example, the statement: If (ThisCondition = true)...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
on one page. CHANGELOG v? (?) - Support for Joomla! FTP upload. - File Download: Payment Options --- merchant ID, --- amount --- currency, --- paypal, google, --- order ref, --- download limit, --- download period, --- thank you message v0.1...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
v_LineItem_Price = r_QuoteDetails.Product_List_Price; v_LineItem_Quantity = r_QuoteDetails.Product_Quantity; v_LineItem_TaxAmount = r_QuoteDetails.Product_Tax_Amount; // v_LineItemTotalExclVat = v_LineItem_Price * v_LineItem_Quantity; v_LineItemTotalVat...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
v_QuoteCurr = ifnull(r_Result.get("Quote_Currency"),"GBP"); v_QuoteTotal = ifnull(r_Result.get("Total_Amount"),0.0).toDecimal(); v_ExchangeRate = ifnull(r_Result.get("Exchange_Rate"),1); v_ModifiedTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
criteria to only return the active listings as well as specific fields so my function doesn't get overwhelmed with the amount of data in the response: map API.fn_eBayQuery_GetActiveProducts(int p_Page, int p_PerPage) { /* Function:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
so let's double-check if(r_Result.get("invoice_numbers").containsIgnoreCase(v_InvoiceRef)) { // retrieve payment mode, amount and date v_PaymentMode = ifnull(r_Result.get("payment_mode_formatted"),""); v_PaymentDate = r_Result.get("date"); v_Last4Digits...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= Map(); l_JsonOrders = List(); // // start preparing CSV file to email for export v_ReportCSV = "Date,Order ID,Status,Amount,Currency,Notes"; l_CsvFileRows = List(); l_CsvFileRows.add(v_ReportCSV); // // get access token v_AccessToken =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
than StaticAlias) - Resolved fix of inventory adjustment level (Error:9205:Insufficient Stock) - Resolved fix of overpaid amount (Include Shipping Cost in SO) Date Modified: 2023-03-16 (Joel Lipman) - Resolves issue of SO / Invoice / Package / Shipment...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
(Joel Lipman) - Initial release - Forwards webhook to Zoho Creator Date Modified: 2024-04-22 (Joel Lipman) - Minimized amount of processing to simply storing the record in Zoho - Run HMAC SHA 256 verification...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
of logged-in user, and authorized as the system account (a separate Zoho user we have named SYSTEM ADMIN); this reduces the amount of blame on the system manager believed to be assigning these manually. Source(s): Zoho Community - Zoho CRM - Zoho CRM...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to get whatever the Zoho Deluge CRM function returns. Create a JS Widget on your device (MacOS) These steps are the minimal amount of information I need to quickly set up a JS widget: Open a MacOS Terminal sudo npm install -g zoho-extension-toolkit...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *