いよいよインボイス制度始まりますね。そこで。。。。

いよいよインボイス制度始まりますね。そこで。。。。

おはようございます
10/1からインボイス制度がスタートします。以前お伝えしたように
インボイス登録番号は国税庁の
ここで検索したり
こちらからAPIで取得したりできますがAPIの利用申請には間に合わないかもしれないし関数の開発もちょっと大変という人は
こちらからCSVファイルのダウンロードができます。(XMLやJSONも)
流石に日本中ダウンロードは大変なので弊社の主な営業地域の神奈川県だけ12万件(大したことない)ダウンロードして
とりあえずCRMに新しいタブをつくって

取り込んでみました
これは地方の方のほうが有利かなと思いますが、調べてないけど東京でも30万件くらいでしょうか?
じゃあこれをどう活用するの????
というところですが
弊社では取引先タブにインボイス登録番号という項目を作って

ちょっと簡単なボタンを作ってみました

こちらで先程のインポートしたタブから会社名で照合してインボイス登録番号を取得して転記してます
同一会社名どうするとか、いろいろ問題はありますが、とりあえず既存顧客または仕入先(こっちは重要)のインボイス番号は得られます。まだ未登録の取引先仕入先がわかるのはちょっt10月1日に向けて安心材料でもあります。全件ボタン押すのは大変ですが弊社では数百件程度ならビール片手にぽちぽちして、あまだあの会社さん未登録なんだとか記憶するのは悪くなかったです
あとインポートの注意点はCSVファイルなら30,000件までインポート可能です。マニュアルには5000件以上はCSVでと書いてあるのですが上限もあります。

一応軽くエラー処理と、空のメッセージは出してみました。
連続処理したいならメッセージ無い方がいいかもしれませんね。
コードはこんな感じ
result = zoho.crm.searchRecords("InvoiceNo","CName:equals:" + CompanyName);
info "入力=" + CompanyName + "結果" + result;
m = Map();
i = 0;
for each  i in result
{
invno = i.get("Name");
}
//インボイス番号
m.put("InvoiceNo",invno);
resp = zoho.crm.updateRecord("Accounts",recordID.toLong(),m);
if(resp.containValue("error"))
{
return "インボイス番号を更新できませんでした" + resp;
}
else if(invno = NULL)
{
return "該当するインボイス番号がありませんでした";
}
return "インボイス番号を更新しました";
メッセージ処理なしなら10行程度です。同一会社名あったらどうなんねん!みたいなのはこのコードでは考慮してません。ちなみに住所も取引先情報に転機も可能ですが、名刺情報の住所と登記上の住所が違っていたりするので今回は行いませんでした。
もしご興味あって教えてほしいという方はお気軽にご質問ください。
ご希望者多いようでしたら勉強会してもいいかなと思います。次回ワークアウトはほんとにインボイス制度開始直前の9月29日ですので、それでもいいやという方はワークアウトご参加の上ご相談ください
または9月22日のZoholicsでお声掛けください

    Zoho Desk Resources

    • Desk Community Learning Series


    • Digest


    • Functions


    • Meetups


    • Kbase


    • Resources


    • Glossary


    • Desk Marketplace


    • MVP Corner


    • Word of the Day


      Zoho CRM Plus Resources

        Zoho Books Resources


          Zoho Subscriptions Resources

            Zoho Projects Resources


              Zoho Sprints Resources


                Zoho Orchestly Resources


                  Zoho Creator Resources


                    Zoho WorkDrive Resources



                      Zoho Campaigns Resources

                        Zoho CRM Resources

                        • CRM Community Learning Series

                          CRM Community Learning Series


                        • Tips

                          Tips

                        • Functions

                          Functions

                        • Meetups

                          Meetups

                        • Kbase

                          Kbase

                        • Resources

                          Resources

                        • Digest

                          Digest

                        • CRM Marketplace

                          CRM Marketplace

                        • MVP Corner

                          MVP Corner




                          Zoho Writer Writer

                          Get Started. Write Away!

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

                            Zoho CRM コンテンツ






                              ご検討中の方

                                • Recent Topics

                                • Does Zoho campaign de-duplicate based on mobile for SMS campaigns?

                                  Hi - We recently sent our first SMS campaign using Zoho Campaign integrated into Burst SMS and got feedback that some of our customers received multiple messages. Upon inspection, this was due to multiple contacts in our list containing the same mobile
                                • Multilingual Newsletter

                                  Hi, Can Zoho campaign give the possibility to create and send a campaign in English and French, giving the possibility to the person receiving it to switch from default language chosen for a campaign? thnaks
                                • Top Menu Disappeared from Blog Page

                                  Hi, Our top menu disappeared at Blog Posts page. However, it's still visible any other page on the website. I attached two screenshots, so it can be understood clearly. How can we bring back top menu? Thanks, K.
                                • Add Comment/Notes to Each Action in Zoho Flow for Internal Documentation

                                  It would be great if Zoho Flow could introduce a field to every action where we can make an internal note about why we are doing something with a specific action. This is especially helpful if more than one person from the organization handles automation
                                • Questions about To Do

                                  1. I created a To Do note on Android and there is a line sorting option in the options drop down menu. But I didn’t find such an option in the PC client. I really need this option. 2. Why is there no search in To Do on the PC client? 3. Why is there no
                                • Tip of the week 03 - Sending emails in batches

                                  Today's marketers not only want their email marketing to be efficient, but also smart. For an email campaign, you may think you have all the essential elements for lead conversion—a big mailing list, an attractive template design, and the most-engaging message content, but after hitting the ‘send’ button, you may not get the expected conversions. Wondering why? Here’s one of the major reasons. Many marketers miss out on sending the email campaign the right way. Did you know that you should not be
                                • Sites Speed and Performance Grades

                                  I noticed that there are no recent inquiries or complaints about load speed or performance issues with Zoho Sites websites. However, I wanted to understand what Zoho has done to ensure that speed remains optimized, images are compressed and lazy loaded,
                                • Feature Request - Configurable Payment Icons + Pay Now link in email.

                                  The PAY NOW buttons (icons) on invoices are really small. It would be great if we could make that a big, colored icon. Better would be to add a button to emails as well. 
                                • Survey end date extension

                                  Hi, Is there any way to extend the end date of my survey? I needed more time in finding respondents that is why I need to extend the end date of my survey. Help. Thanks
                                • AI read notes or explanation

                                  It would be such a great feature to have AI voices be able to read our Notes or Explanation If not having the AI speak the notes at run time, how about a feature where inside of Zoho Show you can have it look at all the notes of all the slides and have
                                • Help with technical problem

                                  Hello, I want to make it so I can say how many days are left until a date is reached, and for it to give me a status on if its VALID, EXPIRED, or ABOUT TO EXPIRE, but the problem I'm having is I want it to be compared to the date every day, not just the
                                • Managing Prepaid Hours for Consulting

                                  We are a consulting firm that bills clients a flat upfront annual fee plus an hourly rate and offer a discount for pre-paying a block of hours. Hours that surpass the pre-paid block are billed monthly at the normal rate. If there are any pre-paid hours remaining at the end of the project they are banked for future use. I'm not seeing a method of doing this in Projects/Books/CRM... thoughts?
                                • Email Verification Tool

                                  Hi there, just came across this tool for Google Sheets https://www.producthunt.com/posts/email-verification-tool-for-google-sheets-2 How would one do to automatically verify/validate email addresses entered on the CRM in a similar way?
                                • Get DealID when Deal Created?

                                  Hi What's the easiest way to grab the DealID when a deal is created?  I want to add it to a custom field on the deal. Thanks
                                • ZOHO Widget SDK not loading in html

                                  I have this code below, I have imported the widgetsdk however I get the error shown in the image, I have tried many different ways of importing and initiating the function ZOHO but nothing is working. can someone explain what I'm doing wrong, if I am
                                • Enhancements to Zoho Corp Help Center "Team Requests" View

                                  Dear Zoho Team, I hope this message finds you well. The ability to view both my tickets and my team’s tickets in the Zoho Corp Help Center is a fantastic feature, especially as the focal point for Zoho in our organization. However, we’ve encountered a
                                • Allow Multiple Scheduled Appointments with Zoho Support

                                  Dear Zoho Team, I hope you're doing well. First, thank you for introducing the option to schedule support calls via the Zoho CRM booking link. This has been a fantastic enhancement, eliminating the need for back-and-forth coordination when scheduling
                                • In Zoho Projects, is there a way to create a folders template under documents that can be used once a project is created?

                                  We have a specific folder structure that we would like to use that is standard across every project. Instead of having to create this structure every time a project is created, is there a way to create a template for the folders that can be added?
                                • Projectwise budget ---

                                  Can we have a Project wise subject in addition to the Monthly, and quarterly ACCOUNT LEVEL budget?
                                • WorkDrive API Documentation

                                  WorkDrive provides users and developers an extensive set of APIs to help integrate functionalities of Zoho WorkDrive with other Zoho applications and third-party tools. We have published the official WorkDrive API Documentation page for all external users.
                                • Welcome Link Expired

                                  Hi The links sent to the users didn't get clicked on in time and now all the links have expired. Is there a way to send a new link without deleting them and re-adding them>
                                • Error 403: Forbidden When Updating Email Signature via API

                                  Hi Zoho Desk team, First, congratulations again on the excellent Zoho API. But, I’m encountering an issue while attempting to update an email signature via the API. Whenever I make a request to update the signature, the response returns an HTTP 403 Forbidden
                                • Who can see draft replies on tickets?

                                  We have noticed that we are able to see draft replies made by other agents. Which settings can limit this visibility? It makes sense to me that admins and the agent who created the draft would be able to see the draft, but no one else. How can we make
                                • Serious question: Are there actually "solo-preneurs"/small business owners who made Zoho-one work well for them?

                                  L.S. After already many years of continued struggle with Zoho-One, I am seriously wondering if there are actually solo-preneurs (one person small business owners - without a large, dedicated IT dept.) who got it (Zoho-One) to work well for their businesses.
                                • Major iOS issues when accessing forms via the browser

                                  Hi, We have been using forms for some time, while the office staff are accessing the forms via the app on Android mobiles, we have a fleet of sub contractors that we would not like them having access to the main app as some of the forms are confidential
                                • All notes disappeared

                                  I've been using the notebook app for over five years on my phone without being logged into an account. A few days ago I opened the app and all my notes had disappeared. Since then I tried restarting my phone, updating the app and logging into my account,
                                • Leads and Deals Issue

                                  Hi! Is Zoho having trouble today? I've been experiencing issues today. When I move a deal to closed/won, it previously would require a closing date but today the screen just went blur and the closing date did not pop up. And then under leads, I was trying
                                • How to Iterate a Function in Zoho Desk Workflow with Delay Between Calls?

                                  Hi everyone, I’m working on a function in Zoho Desk that searches for a specific ticket record. If the ticket is not found, I need to retry the search multiple times with a delay between each attempt until the ticket is located or a maximum number of
                                • How to Iterate a Function in Zoho Desk Workflow with Delay Between Calls?

                                  Hi everyone, I’m working on a function in Zoho Desk that searches for a specific ticket record. If the ticket is not found, I need to retry the search multiple times with a delay between each attempt until the ticket is located or a maximum number of
                                • Zoho Books API Limit Is RIDICULOUS!!!!!!!!!!!!!

                                  The 2,500 API call limit in Zoho Books is about as useful as AOL dialup.  Seriously Zoho, not only can I use up 2,500 API calls in no time with my own app but YOUR OWN STUPID IPAD APP blows through them super fast too, so if any one of my clients wants
                                • QR codes in templates

                                  I'm excited about the new QR code generator. I have included a QR code that contains the record ID setting "${ID}" as input data. In the report detail it works perfectly but when printing it in a template the code is not shown.
                                • Button Display Conditions

                                  Hi Guys, Is it at all possible to have extra button conditions? Context: We have data in our deals module which has a custom button which converts the deal into contacts + set up relationships between them. At the end of the conversion we set a field
                                • Knowledge base: The nitty-gritty of SEO tags

                                  A well-optimized knowledge base with great SEO can benefit your company by allowing customers to find help articles and support resources using search engines. This enables customers to quickly and efficiently find the information they need without direct
                                • Social Media Simplified with Zoho Social: Make the best out of the publishing calendar

                                  Are you a marketer who likes visualizing your plan of action before you start social media posting? Are you part of a team that works on social media on a rotational basis, so the most important task is to collaborate to avoid overlap and confusion? Or
                                • Custom function daily limit and procedural programming

                                  Dearest Zoho Today, support confirmed that if I call a custom function from another custom function then I will use up two, with regards to my daily limit. A few times, we have blown our daily limit and that means that ordinary business processes don't run for the rest of the day. I have to mop these up the following day and there is no guarantee that I will get it right. Therefore, I can't afford to waste any. Procedural programming has been around for over 50 years now and it greatly simplifies
                                • New enhancements: Changing portal users' email addresses and new customization options for templates

                                  Dear All, Portals have enabled organizations to extend access to various CRM modules to their customers, vendors, partners, and end users, per their business requirements. When a portal is created, an invitation email is sent to portal users with a link
                                • Granular Time Frame Settings for Message Deletion and Editing in Zoho Cliq

                                  Dear Zoho Team, I hope you're doing well. Currently, the settings for message deletion and editing in Zoho Cliq are configured globally under: Admin Panel > Organisation > Configurations > Conversations Delete messages: Time frame to allow message deletion
                                • New Built In QR/Barcode Generator Print Settings

                                  I'm trying out the new QR/Barcode generator field in Creator. I would think most people will want to print these, like I do. I am not seeing any way to control the height or width of the barcode for printing (inside the print/pdf template builder). The
                                • Zoho One. Client Script

                                  Hi, I would like to know if the Client Script feature is available in Zoho One. If it's, how can I enable it?
                                • Calendar View for Zoho Tickets

                                  Is there a way to view your tickets with due dates on a calendar view? I can not find a way to merge my Zoho Calendar and Tickets. This would be extremely helpful to my team.
                                • Next Page