Assuming accounts is required, the following 40 results were found.
-
procedure to return no rows without erroring (ie. where rownum/rowcount = 0). Consider the following: SELECT NVL(student_accounts.studentID, 0) INTO v_studentreference FROM student_accounts WHERE student_accounts.studentUsername =...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
into this field. Authorize URL: Enter the Zoho authentication URL based on the client's datacenter: US datacenter: https://accounts.zoho.com/oauth/v2/auth EU datacenter: https://accounts.zoho.eu/oauth/v2/auth CN datacenter:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
// can be any endpoint that does not redirect or reformat the resulting URL // // get Grant Token v_EndPoint = "https://accounts.zoho.com/oauth/v2/auth"; v_Scope = "ZohoBooks.contacts.ALL,ZohoBooks.invoices.ALL,ZohoBooks.purchaseorders.ALL"; v_State =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
Yields: { "TEST001": 6, "TEST002": 1 } Counting total products per account: // // count total products per account m_Accounts = Map(); m_Products = Map(); // // loop through each row for each r_StockRecord in Stock_Upload[ID != 0] { // // create map...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
and pass the record ID via a button to it, I'm adding it here in case I need to refer to it in future. Why? We have an Accounts module which holds all the companies we deal with in our Zoho CRM. I want our sales team to be able to click on a button off...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Zoho Apps. Prerequisites: Setup a connection called "joel_books" that has the necessary scopes to view taxes and chart of accounts Setup a connection called "joel_inventory" that has the necessary scopes to do everything under the sun Setup a function...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
But to flesh that out a little more along with setting the other options under "Advanced Tracking" // // get chart of accounts to use r_ChartOfAccounts = invokeurl [ url :"https://books.zoho.eu/api/v3/chartofaccounts?organization_id=" + v_BooksOrgID...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
from my previous article ZohoCRM & Xero: Function to pull most recent invoices - along with their Contacts and Items (accounts/contact & products respectively). Why? This took me so much longer than I thought it would. It was meant to be based on the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
) ) AS "Status" FROM "Accounts" ORDER BY "Modified Time" DESC /**** Pseudo: Select Modified Time of Record If Modified Time is greater than yesterday's date (today) Use URL of the image representing OK Else If Modified Time is greater than 5 days ago...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
when I get this request again. The additional benefit of having this template is that it includes creating contacts, accounts, and products on-the-fly as well as recording payments and checks as to which record is more up to date between ZohoCRM and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
this was never meant to work in the first place. When did the connection last work? Within ZohoBooks > Banking > Active Accounts > Account > Filter by "Matched Transactions" Bank Issue: Check with client which bank they use, type in the "Search" when...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
only one open parameter, the OR clause just compares against the same parameter. So for example: Instead of... (student_accounts.student_name=@StudentName or student_accounts.student_id=@StudentID) I set this to......
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
errors (with an end!) BEGIN -- initial query to get me the student ID based on the inputted parameter SELECT student_accounts.student_id INTO p_STUDENT_REF FROM student_accounts WHERE student_accounts.student_username = p_STUDENT_ADNAME; -- opening...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
type the value in the 2nd column "App to Run" then OK to run it: Settings Page App to Run Settings Homepage ms-settings: Accounts Access work or school ms-settings:workplace Email & app accounts ms-settings:emailandaccounts Family & other people...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
on the Deal/Opportunity record, I have an Account Name field (the end customer), and a "Distributor" (lookup to the Accounts) as well as a "Reseller" (another lookup to Accounts) field. EITHER the Distributor or Reseller field will be populated but this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
"Success" } Method #2: Using API v1 (using JSON not XML) Generate AuthToken: Browser Mode: Open a browser to https://accounts.zoho.com/apiauthtoken/create?SCOPE=ZohoCreator/creatorapi OR API Mode:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
for latest endpoint) v_Endpoint = "https://" + v_Account_SID + ":" + v_Auth_Token + "@api.twilio.com/2010-04-01/Accounts/" + v_Account_SID + "/Messages.json"; // // build up the JSON request m_Data = Map(); m_Data.put("Body",v_Message);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
to get your Client ID and Client Secret. (Login as the client super admin or ascentcloud admin account) Log in to https://accounts.zoho.com/developerconsole Click on Add Client ID Select "Self Client" Provide the details and register your application...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Sign
- Language: *
-
= v_CandidateGraduatingNextCount + 1; } } } } // m_Blank = Map(); l_SchoolSearch = zoho.crm.searchRecords("Accounts","Account_Name:equals:" + v_SchoolName,1,10,m_Blank,"zcrm"); for each r_School in l_SchoolSearch { // check no search error and valid...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
of code to get dynamic maps of system values Purpose: Taxes, Currencies, Payment Terms, Sales Persons, and Nominal Accounts Inputs: - Outputs: - Date Created: 2021-09-24 (oel Lipman) - Initial release Date Modified: 2024-05-21 (Joel Lipman) - Change of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *