Kaizen #52 - Currencies #API

Kaizen #52 - Currencies #API

Hello everyone!
Welcome back to another post in the Kaizen series!
This week, we will discuss Multi-currency in Zoho CRM.

What will you learn from this post? 
  1. Multi-currency in Zoho CRM
  2. Managing multiple currencies via Zoho CRM API
    • Enabling multi-currency for your organization
    • Retrieve currency details
    • Add new currencies to your organization
    • Update currencies
  3. Multi-currency and Inventory modules in Zoho CRM
1. Multi-currency in Zoho CRM
Multi-currency support in Zoho CRM lets you carry out business transactions with multiple currencies in the global marketplace.
As the Administrator, you can activate this feature by adding the home currency. Once the multi-currency is activated, it cannot be deactivated. To know more about the multi-currency feature, click here.

Pre-requisite
Only the users who have subscribed to the Enterprise or Ultimate editions can access this feature.

Before you start using the multi-currency feature, you must enable it for your organization.

Note: 
The oauth scopes required to access currencies API: 
ZohoCRM.settings.currencies.{operation_type}

Possible operation types
READ - Get currencies data
UPDATE - Update currencies data
CREATE - Add currencies

2. Managing multiple currencies via Zoho CRM API

2a. Enabling multi-currency for your organization

Request URL: {{api-domain}}/crm/v2/org/currencies/actions/enable
Request Method: POST

Sample Input
{
    "base_currency": {
        "format": {
            "decimal_separator": "Period",
            "thousand_separator": "Comma",
            "decimal_places": "2"
        },
        "prefix_symbol": true,
        "name": "Indian Rupee - INR",
        "iso_code": "INR",
        "symbol": "₹",
        "exchange_rate": "50",
    }
}

Input JSON
Key
Description
prefix_symbol
Boolean, Optional
Represents the position of the ISO code in the currency.
true: Display ISO code before the currency value.
false: Display ISO code after the currency value.
name
String, Mandatory
Represents the name of the currency.
iso_code
String, Mandatory
Represents the ISO code of the currency. You can get the available ISO codes from CRM UI. Go to Setup > Company Details > Under Currencies tab > Click Add. You will get the list of currencies available along with their respective ISO codes. 
symbol
String, Mandatory
Represents the symbol of the currency.
exchange_rate
String, Mandatory
Represents the rate at which the currency has to be exchanged for home currency.
is_active
Boolean, Optional
Represents the status of the currency.
true: The currency is active. This is the default value. 
false: The currency is inactive.

The "format" key
The following table represents the keys in "format" JSON object. It is a mandatory key.

Key
Description
decimal_separator
String, Mandatory
The decimal separator separates the integer part of the currency from its fractional part. It can be a Period or Comma, depending on the currency.
thousand_separator
String, Mandatory
The thousand separator separates groups of thousands in a currency. It can be a Period, Comma, or Space, depending on the currency.
decimal_places
Integer, Mandatory
Represents the number of decimal places allowed for the currency. It can be 0, 2, or 3.

Sample Response



Request URL: {{api-domain}}crm/v2/org/currencies
Request URL to get a specific currency: {{api-domain}}crm/v2/org/currencies/{currency_id}

Request Method: GET

Sample Response to get all the Currencies of an Organization:


2c. Add new currencies to your organization

Request URL: {{api-domain}}/crm/v2/org/currencies
Request Method: POST

Sample Input
{
  "currencies": [
    {
      "format": {
        "decimal_separator": "Period",
        "thousand_separator": "Comma",
        "decimal_places": "2"
      },
      "prefix_symbol": true,
      "name": "Saudi Riyal - SAR",
      "iso_code": "SAR",
      "symbol": "SR",
      "exchange_rate": "1.0000000",
      "is_active": true
    }
  ]
}

Sample Response



You can update all the properties of a currency except the name and ISO code. It is mandatory to specify the unique ID of the currency. You can specify it either in the request body or the request URL.

Request URL to update home currency:
{{api-domain}}/crm/v2/org/currencies/actions/enable

Request URL to update currencies other than home currency:
{{api-domain}}/crm/v2/org/currencies

Request URL to update a specific currency:
{{api-domain}}/crm/v2/org/currencies/{currency_ID}

Request Method: PUT

Sample Response to update home currency:


Sample Response to update currencies other than home currency:


Until now, we discussed how to manage currencies for your organization. Next, let us see how to use currencies when you add/update records in inventory modules (Quotes, Sales Orders, Purchase Orders, Invoices, and Vendors) in Zoho CRM.

For other inventory modules like Products and Price Books, the rate will be considered in home currency.

3. Multi-currency and Inventory Modules

You must add the ISO code of the currency in the "Currency" key in request JSON. It applies to adding/updating/upserting records in the inventory modules.

3a. Adding a currency when you create a Quote

Request URL: {{api-domain}}/crm/v2/Quotes
Request Method: POST

Sample Input
{
    "data": [
        {
            "Currency": "SAR",
            "Subject": "Sample Quote2",
            "Account_Name": {
                "name": "Zylker",
                "id": "575465000000657030"
            },
            "Product_Details": [
                {
                    "product": 575465000000653001,
                    "quantity": 10
                }
            ]
        }
    ]
}

Sample Output


We hope you found this post useful.

Write to us at support@zohocrm.com if you have any questions, or let us know in the comment section.
Cheers!

    Access your files securely from anywhere









                          Zoho Developer Community




                                                • Desk Community Learning Series


                                                • Digest


                                                • Functions


                                                • Meetups


                                                • Kbase


                                                • Resources


                                                • Glossary


                                                • Desk Marketplace


                                                • MVP Corner


                                                • Word of the Day


                                                • Ask the Experts





                                                          Manage your brands on social media



                                                                Zoho TeamInbox Resources



                                                                    Zoho CRM Plus Resources

                                                                      Zoho Books Resources


                                                                        Zoho Subscriptions Resources

                                                                          Zoho Projects Resources


                                                                            Zoho Sprints Resources


                                                                              Qntrl Resources


                                                                                Zoho Creator Resources



                                                                                    Zoho CRM Resources

                                                                                    • CRM Community Learning Series

                                                                                      CRM Community Learning Series


                                                                                    • Kaizen

                                                                                      Kaizen

                                                                                    • Functions

                                                                                      Functions

                                                                                    • Meetups

                                                                                      Meetups

                                                                                    • Kbase

                                                                                      Kbase

                                                                                    • Resources

                                                                                      Resources

                                                                                    • Digest

                                                                                      Digest

                                                                                    • CRM Marketplace

                                                                                      CRM Marketplace

                                                                                    • MVP Corner

                                                                                      MVP Corner







                                                                                        Design. Discuss. Deliver.

                                                                                        Create visually engaging stories with Zoho Show.

                                                                                        Get Started Now


                                                                                          Zoho Show Resources

                                                                                            Zoho Writer

                                                                                            Get Started. Write Away!

                                                                                            Writer is a powerful online word processor, designed for collaborative work.

                                                                                              Zoho CRM コンテンツ






                                                                                                Nederlandse Hulpbronnen


                                                                                                    ご検討中の方




                                                                                                          • Recent Topics

                                                                                                          • Narrative 13: Importing your data

                                                                                                            Behind the scenes of a successful ticketing system: BTS Series Narrative 13: Importing your data When importing data into an application, it is crucial to prevent data loss or duplication. These types of errors can hinder the development of a clean and
                                                                                                          • Blueprint Not Triggering When Lead Status Is Updated by Workflow (IndiaMART Integration)

                                                                                                            I have set up a blueprint that triggers when a lead’s status is “New Lead.” Our CRM is integrated with IndiaMART, and when leads are created from IndiaMART, their Lead Status is initially set to None. To handle this, I created a workflow that automatically
                                                                                                          • Update Subform in specific field(Status) without affecting other fields in Zoho CRM using Deluge?

                                                                                                            Scenario: PRODUCT Module(change name Plot) in any product status change From Available to Booked then on PROJECT Custom Module have Subform So, Subform name is Property Details now in that Subform 1 field is STATUS that update according to  product status
                                                                                                          • YouTube Live #2: Agreement Intelligence with Zoho Sign's eSign AI assistant

                                                                                                            Hi there, We're back again with our YouTube live series and this time, we'll take you through our holistic agreement intelligence powered signature workflows. Struggling to draft an agreement? Need help double-checking clauses and going through complicated
                                                                                                          • Can I Build a POS using ZOHO creator and integrate it with ZOHO Books?

                                                                                                            Hello,  I have a Zoho Books account and I was wondering if I can have a POS system that integrates with it. Primarily with Inventory, Customers and Payment and ofcourse Create invoices and credit notes.   So, would Zoho creator provide me with this solution?  Thank you, 
                                                                                                          • An important update for Zoho Cliq desktop users

                                                                                                            The latest version of the Zoho Cliq desktop app (v1.8.0) will no longer be supported on macOS 10.15 Catalina and earlier versions. This is because the framework we use (Electron) no longer supports some older macOS versions. If you’re using macOS 10.15
                                                                                                          • Zoho Projects - Visual improvement to parent and sub-task relationship

                                                                                                            Hi Projects Team, My feature request is to improve sub-task visibility. Please see screenshot below. I really think parent child relationships could be visually improved. Even if the first letter of the parent task was inline with other same level tasks
                                                                                                          • Items Below Reorder Point Report?

                                                                                                            Is there a way to run a report of Items that are below the Reorder Point? I don't see this as a specific report, nor can I figure out how to customize any of the other stock reports to give me this information. Please tell me I'm missing something s
                                                                                                          • New Toolbar in Zoho Sheet

                                                                                                            We have revamped our toolbar design in this new version of Zoho Sheet. Below are some screenshots to help you get accustomed to this new interface. Click on the picture below to view the animated image in its original size. Scroll down this post to learn about the changes. Highlight of Changes: The previous format tab is now split into 2 tabs - Home and Format. The Home tab contains the commonly used functions and the Format tab holds formatting related options. Under the Home tab towards the far
                                                                                                          • Zoho inbuilt Telephony made a lot of issues!

                                                                                                            Hi there, I am a user that I am working with zoho inbuilt telephony around 1 month. Non of my colleagues are happy with this app! most of the time customer cannot hear my customer service team, customers say our voice is breaking. whenever Telephony support
                                                                                                          • Sending workflow notifications using popular chat services

                                                                                                            Hello everyone, We have introduced instant and scheduled notifications on some of the most popular chat platforms to facilitate easy collaboration, quick action, and wider reach. Workflow notifications can be sent to the following chat platforms: Zoho
                                                                                                          • Webhook not firing.

                                                                                                            I created a webhook using the Web UI, it looks very nice and the testing worked without an issue, but when i save/ update a ticket, the webhook is not firing. Here are the details of the web-hook i get from using the API "modifiedTime": "2019-10-22T09:23:37.380Z",
                                                                                                          • Adding Images to a Quote in Zoho CRM

                                                                                                            We are currently preparing to use Quotes in Zoho CRM and we are building out our Quote templates.  We came across an issue of not being to add Images of the products to the Quote - specifically in the body of the Quote templates.   This is a problem,
                                                                                                          • Applications built with Zoho Creator

                                                                                                            Hi, I’m really interested in seeing how others have built their application using Zoho Creator, especially those designed for external users (clients, vendors, or the public). If you’ve developed something along those lines and don’t mind sharing, I’d
                                                                                                          • Is it posssible to add Asap Widget on Wordpress?

                                                                                                            I have tried to add the ASAP widget so users could iniciate chats and see the KB information but nothings seems to work. I have tried to add the script using a php snippet that adds the to the footers and also tried one for the header in the functio
                                                                                                          • Require ticket resolution

                                                                                                            Hi Zoho team, Is there a way to require resolution even if an agent did not use a blueprint? for example, our blueprint has a "resolve" transition but what if agent revoked blueprint and manually set the status of ticket to closed? Is there a way where
                                                                                                          • Tables from ZohoSheets remove images when updated from source

                                                                                                            I have a few tables from a ZohoSheet in a ZohoWriter document that will remove the images in the cells when I refresh from the source. The source still has the images in the table when I go to refresh. After updating from the source, as you can see the
                                                                                                          • API Pagination Error: 'from' Parameter Limit

                                                                                                            Hello, I am encountering an error while paging through the Zoho Desk API results: Status code: 422 - {"errorCode":"UNPROCESSABLE_ENTITY","message":"The value passed for field 'from' exceeds the range of '0-4999'."} Is 5000 the maximum number of records
                                                                                                          • How to go to the next open ticket in the queue when agents closes ticket

                                                                                                            Zoho Desk When agent closes a ticket - eg when they choose 'Send and Close" - where is the setting that automatically redirects them to the next open ticket in the queue?
                                                                                                          • External download link limit

                                                                                                            Can You please help us to understand this For Zoho WorkDrive external users, the download limit is a maximum of 5 GB total download size and a maximum of 50 first-level files and folders What is the meaning of first level? We are using these files in
                                                                                                          • CRM verify details pop-up

                                                                                                            Was there a UI change recently that involves the Verify Details pop-up when changing the Stage of a Deal to certain things? I can't for the life of me find a workflow or function, blueprint, validation rule, layout rule ect that would randomly make it
                                                                                                          • Custom templates for calendar report

                                                                                                            What about being able to design custom templates for the calendar report, as well as for other types of reports? I think more users are waiting for this.
                                                                                                          • Print a price list or price book

                                                                                                            Hi Community. Am I right in concluding that Zoho has no functionality to print a price list from either Zoho CRM, Zoho Inventory or Zoho Books? I won't get stuck on the fact that Zoho doesn't sync price books between Zoho CRM and Books/Inventory (more
                                                                                                          • Disable payment thank-you emails

                                                                                                            Hello, can someone please tell me how to disable sending of the "Payment Thank-You" emails? 
                                                                                                          • Maximum tags possible in Contacts Records

                                                                                                            I read in some documentation that Zoho allows a total of 200 tags across all records. Is this correct? So is it not possible to have one tag per record for 500 records?
                                                                                                          • Any way to "Pay with Check" or "Refund with Check" for Credit Notes?

                                                                                                            When we have a Bill in Zoho Books, we can select the "Pay with Check" option which then allows us to print/cut the check directly out of Zoho Books. When we created a Credit Note and want to refund the customer, is there any way to Refund with Check,
                                                                                                          • CRM Mobile reports

                                                                                                            When our engineers finish a job they like to email the customer a job report. This is best done todate as an email template but we can find no way to include an image field from that module. Is there any other options?
                                                                                                          • When Zoho Tables Beta will be open to EU data center

                                                                                                            Hello all, We in EU are looking at you all using and testing and are getting jealous :) When we will be able to get into the beta also? We don't mind testing and playing with beta software. Thank you!
                                                                                                          • Start Form on a different page (i.e., hide form pages)?

                                                                                                            I have a Zoho form that uses the `Field Alias - Prefill URL` feature. My goal is to have a pre-filled field that directs the user to a specific starting page in the form. For example: The URL will have a field alias that will auto-populate a field with
                                                                                                          • How can we disable "My Requests"?

                                                                                                            We are not using this functionality in our system at all and our users get confused.
                                                                                                          • PayPal payment received recording problem

                                                                                                            Hi, A little while back one of our customers used the PayPal payment option to pay an invoice For some reason though the payment is showing up twice within the Payments section of the invoice! Instead of setting the invoice value to ZERO, it now shows a negative value Anyone else face this problem? I've checked PayPal and there is only 1 payment in reality... A bug? Actonia ps: for anyone from Zoho Customer Service or tech team,  its Invoice 785 in our account
                                                                                                          • string(87) "{"code":"INVALID_TOKEN","details":{},"message":"invalid oauth token","status":"error"} " grtting this error

                                                                                                            Using access token i am trying to add sales orders through api but it is throwing errors like the above i have mentioned. Please help me for that
                                                                                                          • How to mute chat notification sound by default in Zoho SalesIQ?

                                                                                                            We’ve recently embedded the Zoho SalesIQ chatbot on our website, and we’ve noticed that notification sounds sometimes play even when the visitor hasn’t interacted with the chat widget yet. We’re trying to understand two things: Why do these sounds occur
                                                                                                          • Kanban View for Projects.

                                                                                                            At our organization, we describe active projects with various statuses like "In Proofing" or "Printing" or "Mailing". In the Projects view, one can set these project statuses by selecting from the appropriate drop-down. While this works, it's difficult to view and comprehend the progress of all of your projects relative to each other in a table. Creating a Kanban view for projects where I can move them from one status to another allows me to see where each project is in the order of our workflow.
                                                                                                          • How to Hide Article Links in SalesIQ Answer Bot Responses

                                                                                                            I have published an article in SalesIQ, and the Answer Bot is fetching the data and responding correctly. However, it is also displaying the article link, which I don’t want. How can I remove the link so that only the message is shown?
                                                                                                          • Add RECURRING option when adding email to calendar events

                                                                                                            When you add an email to a calendar event, there is no option to make that new calendar event into a recurring event.  It is counterproductive to make an event from your email to then have to go to your calendar, find the event, and make it recurring. 
                                                                                                          • LINE Auto Message Connect to Zoho

                                                                                                            When I integrated LINE into the CRM, I was prompted to disable “Chat,” “Auto Response,” and “Greeting Messages,” and to enable the webhook. However, since I have already set up some auto-reply features in LINE, including Rich Messages and greeting automation,
                                                                                                          • Option to block bookings from specific email address or ip adresss in zoho booking

                                                                                                            Sometime few of our client keep booking irrelevant booking service just to resolve their queries and they keep booking it again and again whenever they have queries. Currently its disturbing our current communication process and hierarchy which we have
                                                                                                          • Threaded conversations for emails sent via automation

                                                                                                            Hi Guys, I hope you are doing well. Don't you guys think we should have an option in a workflow to notify users either as a new email or the previous email thread. For example, if you have one deal in the process and there are 10 different stages during
                                                                                                          • Create folder is fetch fails

                                                                                                            coming from zapier... zapier has a google drive task that searches for a specific folder in google drive, and if it fails to find the folder it will create a folder based on the search criteria, and contine along the singluar path of the flow. Trying
                                                                                                          • Next Page