Assuming currency is required, the following 22 results were found.
-
A quick note for when I want to quickly generate maps of a currency or a tax from a client's Zoho Books. Why? The use-case here is that we are creating a Sales Order in Zoho Books from Zoho CRM and want to map the correct currency and tax by their ID...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
website so we'll skip to the COQL query. This is what I have: // // build up COQL query v_CoqlQuery = "select distinct Currency from Quotes where Subject!=''"; // // build up parameters m_Params = Map(); m_Params.put("select_query",v_CoqlQuery); // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
+ v_BooksOrgID type :GET connection:"zbooks" ]; for each m_Currency in r_Currencies.get("currencies") { m_Currencies.put(m_Currency.get("currency_code"),m_Currency.get("currency_id")); } info m_Currencies; // // --------------------------------- // get...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS Excel stop understanding what a NUMBER was? I have a...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
or not). console.log("Joel Lipman - 20221018 -------------------------"); // get some values from the current record var v_CurrencyCode = ZDK.Page.getField('Currency').getValue(); var v_ConsultantLocation = ZDK.Page.getField('Location').getValue(); //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
for "Alt Codes" or "Symbol Codes" in a search engine for a full list. Meanwhile, here's some that you may need frequently: Currency ¢ Cent sign 0162 £ British Pound 0163 € Euro currency 0128 ¥ Japanese Yen 0165 ƒ Dutch Florin 0131 ¤ Generic currency...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
v_QuoteStage = ifnull(r_Result.get("Quote_Stage"),"-"); 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);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
data types are picklist, id, owner_lookup, user_lookup, lookup, phone, email, date, datetime, text, textarea, integer, currency, decimal and double. You can search for a maximum of 10 criteria (with same or different columns) with equals and starts_with...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= o_ThisLineItem.VAT1; o_NewLineItem.VAT_Line_Item_Total = o_ThisLineItem.VAT_Line_Item_Total; o_NewLineItem.Vendor_Currency = o_ThisLineItem.Vendor_Currency; // going to create a new set of line items a_NewSuformRows.push(o_NewLineItem); } } } //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
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 (06/07/2011) -...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Note(s): Just a list of fields to build up a Product Line Item: "Product_Details": [ { "product": { "Product_Code": null, "Currency": "USD", "name": "Test Product", "id": "1642130000000104087" }, "quantity": 1, "Discount": 0, "total_after_discount": 0,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
like the following request: { "Subject": "My Test Quote", "Product_Details": [ { "product": { "Product_Code": "TEST1", "Currency": "GBP", "name": "My Test Product", "id": "123456789012345678" }, "quantity": 5, "Discount": 0, "Tax": 0.99, "list_price":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to create a Sales Order in Zoho Books would be enough: { "date": "2021-09-08", "zcrm_potential_id": "123456789012345678", "currency_code": "GBP", "reference_number": "Salespersons Test Reference", "terms": "These are our test terms and conditions",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= "https://api.stripe.com/v1/payment_intents"; m_Params = Map(); m_Params.put("amount",v_StripeAmount); m_Params.put("currency","gbp"); //m_Params.put("automatic_payment_methods[enabled]", false); m_Params.put("payment_method_types[]","card_present");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
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: *
-
set the field value to the formatted value ZDK.Page.getField("Weight_kg").setValue(v_ProductWeightFormatted); // now for currency fields var v_ProductPrice = ZDK.Page.getField('Unit_Price').getValue(); var v_ProductPriceFormatted =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
v_TotalQuantity = v_TotalQuantity + v_ThisQuantity; // v_PriceDisplay = if(c_Quote.Unit_Price && c_Quote.Unit_Price > 0,v_CurrencyHtmlEntity + c_Quote.Unit_Price.round(2),"-"); v_PriceValue = if(c_Quote.Unit_Price && c_Quote.Unit_Price >...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
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 Total","align":"right"});...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
ZDK.Page.getField('Shipping_Street').setValue(o_QuoteDetails._Shipping_Street); ZDK.Page.getField('Currency').setValue(o_QuoteDetails._Currency); ZDK.Page.getField('Terms_and_Conditions').setValue(o_QuoteDetails._Terms_and_Conditions);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
m_UpsertCrmInvoice.put("Due_Date",d_XeroInvoiceDueDate.toString("yyyy-MM-dd")); m_UpsertCrmInvoice.put("Currency",m_ThisInvoice.get("CurrencyCode")); // // some custom fields I created in CRM to store the data...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *