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

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

おはようございます
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 Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          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 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

                                  • Conditional formatting: before/after "today" not available

                                    When setting conditional formatting, it only allows me to set a specific calendar date when choosing "Before" or "After" conditions. Typing "today" returns the error "Value must be of type date". Is there a workaround? Thanks for any help!
                                  • Text snippet

                                    There is a nice feature in Zoho Desk called Text Snippet. It allows you to insert a bit of text anywhere in a reply that you are typing. That would be nice to have that option in Zoho CRM as well when we compose an email. Moderation Update: We agree that
                                  • Analytics <-> Invoice Connection DELETED by Zoho

                                    Hi All, I am reaching out today because of a big issue we have at the moment with Zoho Analytics and Zoho Invoice. Our organization relies on Zoho Analytics for most of our reporting (operationnal teams). A few days ago we observed a sync issue with the
                                  • I'm getting this error when I try to link an email to a deal inside the Zohomail Zoho CRM extension.

                                    When I click "Yes, associate," the system displays an "Oops!! Something went wrong" error message. I have attached a screenshot of the issue for reference.
                                  • CRM gets location smart with the all new Map View: visualize records, locate records within any radius, and more

                                    Hello all, We've introduced a new way to work with location data in Zoho CRM: the Map View. Instead of scrolling through endless lists, your records now appear as pins on a map. Built on top of the all-new address field and powered by Mappls (MapMyIndia),
                                  • Adding custom "lookup" fields in Zoho Customization

                                    How can I add a second “lookup” field in Zoho? I’m trying to create another lookup that pulls from my Contacts, but the option doesn’t appear in the module customization sidebar. In many cases, a single work order involves multiple contacts. Ideally,
                                  • Zoho Sheet - Desktop App or Offline

                                    Since Zoho Docs is now available as a desktop app and offline, when is a realistic ETA for Sheet to have the same functionality?I am surprised this was not laucned at the same time as Docs.
                                  • ZOHO add-in issue

                                    I cannot connect ZOHO from my Outlook. I am getting this error.
                                  • Issues with Actions By Zoho Flow

                                    Hi, I have a workflow that fires when a deal reaches a stage. This then sends out a contract for the client to sign. I have connected this up through Actions by Zoho Flow. Unfortunately this fails to send out. I have tracked it down to the date fields.
                                  • Proactive Alert for Existing Open Tickets per Contact / Account

                                    Hello Zoho Desk Team, Greetings, and hope you’re doing well. We would like to submit a feature request aimed at improving agent awareness and efficiency when handling tickets in Zoho Desk. Use case When an agent opens a ticket (new or existing), it is
                                  • Special characters (like â, â, æ) breaking when input in a field (encoding issue)

                                    Hey everyone, We are currently dealing with a probably encoding issue when we populate a field (mostly but not exclusively, 'Last Name' for Leads and Contracts). If the user manually inputs special characters (like ä, â, á etc.) from Scandinavian languages,
                                  • Set Custom Icon for Custom Modules in new Zoho CRM UI

                                  • Which WhatsApp API works seamlessly with Zoho CRM?

                                    I’m exploring WhatsApp API solutions that integrate seamlessly with Zoho CRM for customer communication, lead nurturing, and automation. I would love to hear insights from those who have successfully implemented WhatsApp within Zoho CRM. My Requirements:
                                  • Marketing Automation

                                    L.S. Marketing Automation is and has always been part of the Zoho One bundle - according to the information provided on the Zoho Website. Why when I open Marketing Automation do I get the following message?: "Your trial has expired. We hope you enjoyed
                                  • What's New in Zoho Analytics - January 2026

                                    Hello Users! We are starting the year with a strong lineup of updates, marking the beginning of many improvements planned to enhance your analytics experience. Explore the latest improvements built to boost performance, simplify analysis, and help you
                                  • Can I convert multiple OLM files to Thunderbird at once?

                                    Yes, you can convert multiple OLM files to Thunderbird at once using the Aryson OLM file Converter. The tool supports bulk OLM file conversion, allowing users to select multiple OLM files in a single process. It preserves the original folder structure,
                                  • Translation from Chinese (Simplified) to Chinese (Traditional) is not working. It randomly translated. Google Translate accurately but zoho translate is not working at all

                                    Hi friends, The newly added language for translation. https://www.zoho.com/deluge/help/ai-tasks/translate.html "zh" - Chinese "zh-CN" - Chinese (Simplified) "zh-TW" - Chinese (Traditional) my original text: 郑这钻 (and it is zh-CN) translated traditional
                                  • The Social Playbook - January edition: Getting started with content creation

                                    Social media isn’t just about posting some random content. It’s about why certain content works, how brands stand out, and what makes people pause mid-scroll. The Social Playbook is a monthly community series where we break all of that down. Through real
                                  • Support for Custom Fonts in Zoho Recruit Career Site and Candidate Portal

                                    Dear Zoho Recruit Team, I hope you're doing well. We would like to request the ability to use custom fonts in the Zoho Recruit Career Site and Candidate Portal. Currently only the default fonts (Roboto, Lato, and Montserrat) are available. While these
                                  • Adding bank details to the contact through API

                                    How to add bank-related information to the contact while creating it using API? The account number needs to be encrypted before sending it through API but not sure how to encrypt and get those values. Please guide me in this.
                                  • Ticket Resolution - Add rich formatting, screenshots and attachments

                                    The resolution field only allows plain text at the moment. Many of our resolutions involve posting screenshots as evidence, it would be great for us to be able to have rich text formatting, be able to paste screenshots and add attachments in the solution
                                  • Ticket resolution field - can you add links, video, and images?

                                    Seems like the ticket resolution fields is just a text field. Any plans to add the ability to add links, images...the same functionality in the problem description box? I would like to send the customer a link to a KB article, a link to our Wiki, embed an image, or use HTML to pass on a short how to video from YouTube.  Is their plans to add this functionality? You should also be able to complete formate the response from the ticket and then save and add to KB.  Thanks
                                  • CRM x WorkDrive: We're rolling out the WorkDrive-powered file storage experience for existing users

                                    Release plan: Gradual rollout to customers without file storage add-ons, in this order: 1. Standalone CRM 2. CRM Plus and Zoho One DCs: All | Editions: All Available now for: - Standalone CRM accounts in Free and Standard editions without file storage
                                  • Font breakage in Zoho Mail Desktop Lite application for Mac

                                    Dear Zoho Mail and Workplace Community, With the latest update of macOS Sequoia and macOS Tahoe, there has been font breakages in the email preview of Zoho Mail Desktop Lite application for Mac. This breakage is due to the corruption of the System fonts
                                  • Feature request - image resizing on sales orders

                                    I need to be able to show the items on the sales orders, currently the item image shows really small and no way to resize it, need the ability to make the image larger to showcase the product on the pdfs
                                  • Mail Merge is not working properly as far as the AUTOMATE section is concerned

                                    Hi there, I created a Mail Merge template for the Deal module. I would like Deal owners to mail merge their Deal records, download the Mail Merge document as a Word doc and make a few changes before sending it to the customer. Thing is, neither the "Merge
                                  • What's new in Zoho Sheet: Simplify data entry and collaboration

                                    Hello, Zoho Sheet community! Last year, our team was focused on research and development so we could deliver updates that enhance your spreadsheet experience. This year, we’re excited to deliver those enhancements—but we'll be rolling them out incrementally
                                  • Nueva edición de "Ask The Expert" en Español Zoho Community

                                    ¡Hola Comunidad! ¿Te gustaría obtener respuestas en directo sobre Zoho CRM, Zoho Desk u otra solución dentro de nuestro paquete de CX (Experiencia del Cliente? Uno de nuestros expertos estará disponible para responder a todas tus preguntas durante nuestra
                                  • Automation Series: Auto-Notify External Users on Issue Closure

                                    Hello Folks! In Zoho Projects, you can notify external issue reporters via email when an issue is marked as Closed. This helps the users avoid manual follow-ups and keeps the reporter updated. In this post, we’ll walk through a simple setup using a Web
                                  • Issue with open-rate reporting in Zoho Campaigns

                                    Hello, Since yesterday I’ve been experiencing an issue with the open-rate reports in Zoho Campaigns. The campaigns I send appear in the reports as if none of the emails have been opened, even though I know they have. To verify this, I replicated the campaign
                                  • Turn chat conversations into real action with Integration Blocks in Guided Conversations

                                    When a Guided Conversation fails, it's usually not because the logic is wrong. They fail because the conversation stops moving. A customer starts a chat with a clear goal: report an issue, check a status, or confirm something. At first, the flow does
                                  • Basic Mass Update deluge schedule not working

                                    I'm trying to create a schedule that will 'reset' a single field to 0 every morning - so that another schedule can repopulate with the day's calculation. I thought this would be fairly simple but I can't work out why this is failing : 1) I'm based in
                                  • click to call feature

                                    I've Zoho CRM and in that i want click to call feature.
                                  • We Asked, Zoho Delivered: The New Early Access Program is Here

                                    For years, the Zoho Creator community has requested a more transparent and participatory approach to beta testing and feature previews. Today, I'm thrilled to highlight that Zoho has delivered exactly what we asked for with the launch of the Early Access
                                  • From Zoho CRM to Paper : Design & Print Data Directly using Canvas Print View

                                    Hello Everyone, We are excited to announce a new addition to your Canvas in Zoho CRM - Print View. Canvas print view helps you transform your custom CRM layouts into print-ready documents, so you can bring your digital data to the physical world with
                                  • Can the Product Image on the Quote Template be enlarged

                                    Hello, I am editing the Quote Template and added ${Products.Product Image} to the line item and the image comes up but it is very tiny. Is there anyway that you can resize this to be larger? Any help would be great! Thanks
                                  • Creating Parent Child relationship in Accounts

                                    We have customers with multiple locations, I setup the HQ as an account, then I setup the different sites marking the HQ as the parent to that location. If I then do a Deal for one of the locations, is there a way to show by looking at the parent account
                                  • Learner transcript Challenges.

                                    Currently i am working on a Learner Transcript app for my employer using Zoho Creator. The app is expected to accept assessment inputs from tutors, go through an approval process and upon call up, displays all assessments associated with a learner in
                                  • Client and Vendor Portal

                                    Some clients like keeping tabs on the developments and hence would like to be notified of the progress. Continuous updates can be tedious and time-consuming. Zoho Sprints has now introduced a Client and Vendor Portal where you can add client users and
                                  • #7 Tip of the week: Delegating approvals in Zoho People

                                    With Zoho People, absences need not keep employees waiting with their approval requests. When you are not available at work, you can delegate approvals that come your way to your fellow workmate and let them take care of your approvals temporarily. Learn more!
                                  • Next Page