【開催報告】名古屋 ユーザー交流会 Vol.2 2025/11/21 Zoho Analytics / Inventory で実現する在庫の"未来予測"

【開催報告】名古屋 ユーザー交流会 Vol.2 2025/11/21 Zoho Analytics / Inventory で実現する在庫の"未来予測"

ユーザーの皆さま、こんにちは。コミュニティチームの中野です。

11/21(金)に名古屋 ユーザー交流会 を開催しました。
本投稿では、当日実施したセッションの様子及び投影資料をお届けします。
会場にて参加できなかった皆さまも、ぜひご参照ください。
(Zoho 社員セッションの登壇資料については、11/28(金)開催の東京回の開催報告で共有いたします)


今年2回目の開催となる名古屋 ユーザー交流会では、株式会社エンツナクリエイト 野末さんによる
Zoho Analytics / Inventory の活用事例セッションのほか、「Zoho で”見える化”した / したい自社のデータ」を
テーマに参加者同士でZoho の活用方法を共有し合うグループワークを行いました。

登壇いただいた野末さん、そして参加いただいたZoho ユーザーの皆さん、ありがとうございました!

ユーザー活用事例セッション:Zoho Inventoryでは見えない未来を、
Zoho Analyticsで描いた話 〜構成部品の在庫推移と”仕様の壁”を乗り越えて〜

株式会社エンツナクリエイトの野末様に、工場向け設備の製造販売を行うクライアント企業の
在庫管理(部品の仕入れから商品の製造・販売まで)をZoho Inventory / Analytics で実現した事例についてお話しいただきました。

 
1. 業務課題をZoho で解決
クライアント様は、Zoho 導入前はExcelでの在庫管理をしていましたが、部品点数の増加により運用を続けることが困難な状態でした。
具体的には以下キャプチャの通り5つの要望があり、それらをZoho Inventory / Analytics に
置き換えることで、業務改善に繋がった話を共有します。




2. 具体的なZoho 活用法
2-1. Zoho Inventory の活用
Zoho Inventory では、以下の機能を活用して在庫管理を実現しました。

商品登録機能
  1. 売上価格と仕入れ価格の両方を登録可能
  2. 先入れ先出し法、移動平均法などの在庫計算方法に対応
  3. 期首在庫数と基準在庫数の設定によるアラート機能
組み合わせ商品機能
  1. 部品の組み合わせによる商品作成が柔軟に設定可能
  2. 各部品の使用数量と金額の詳細設定が可能
受発注管理
  1. 取引先ごとの価格パターン設定
  2. 発注書・受領書・支払依頼書の帳票展開機能



2-2. Zoho Analytics :将来在庫推移表の作成
Zoho Inventory だけでは実現できなかった「将来的な在庫予測」について、Zoho Analytics を活用して解決しました。

Zoho Analytics で作成したレポート: 将来の在庫推移予測表を作成し、以下の項目を表示できるようにしました。
  1. 部品名・組み合わせ商品名
  2. 基準在庫数
  3. カスタムフィールド(必要納品数、SPQ(最小発注単位)、MOQ(最低発注数))
  4. 月別の出荷予定・入荷予定・在庫調整・在庫残数
技術的な実装: 在庫変動イベント(受注・出荷、仕入れ・納品、在庫調整、バンドル出荷、仮想出荷)を
統合したテーブルを作成し、全月・全商品の組み合わせテーブルと結合することで、動きのない月も含めた在庫推移を表示できるようにしました。
※実装にあたっては、Zoho Analytics の制約事項(ジョイン制限、NULL値の扱い、レポート列数制限など)を考慮した設計が必要でした。





まとめ

今回の取り組みにより、将来的な在庫見通しが可能になり、発注漏れが大幅に減少したと
クライアント様から高い評価をいただきました。 今後は発注数量などと在庫が連動してアラートを表示するなどの設計を進めていきたいと思っています。

野末さん資料:


グループワーク:Zohoで"見える化"した / したい、自社の数字

Zoho を活用して、自社で見える化したデータ・今後したいデータについて、参加者同士で共有していただきました。

共有内容 一部抜粋:
・Zoho PageSense: ヒートマップ等を利用して、サイト行動の可視化
・Zoho Social: 自社SNS投稿の反応を確認

最後に

今後のコミュニティイベントは、以下の通りの開催を予定しています。
枠に限りがありますので、参加を希望される方はお早めに参加登録をお願いします。

12/18(木)14:00~ ユーザー同士で課題解決! Zoho ワークアウト オンライン

今後取り扱ってほしいトピックや、今回参加した感想などについて、本投稿のコメントにいただけると励みになりますのでぜひお願いします。
SNSハッシュタグ:#Zugmeetup

今後ともZoho コミュニティをよろしくお願いいたします!

ゾーホージャパン コミュニティチーム


    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



                                                            • Sticky Posts

                                                            • 【6/22〜6/24開催】Zoho CRM 管理者向けトレーニングのご案内

                                                              「Zoho CRMを導入したばかりで、初期設定や基本操作に不安がある」、「短期間で基礎から理解を深め、運用開始までをスムーズに行いたい」「Zoho CRMを基礎から再度学び直したい」といった課題や要望をお持ちの管理者に向け、Zoho CRM 管理者向けオンライントレーニングを実施します。 2022年6月の開催回よりトレーニング内容を刷新し、有償にて実施いたします。   ─────────────────────────────────── >詳細・お申し込みはこちら:https://www.zoho.com/jp/crm/crmtraining/
                                                            • 【12/17(金)Meetup開催】参加者にはノベルティプレゼント!Zoho サービス相談会/情報交換会もあります

                                                              こんにちは、Zoho Japan コミュニティチームの今成です。 12月17日(金)16:00から、今年最後のMeetup(ユーザー交流会)を開催します! ●詳細はこちら:https://www.zohomeetups.com/ZohoJapanCommunityMeetup2021vol4/ 前半は今年9月にZoho サービスを導入したユーザー様のセッションとして、現状の利用状況とこれからどのようにZoho サービスを利用していくか、これからの構想談をお話いただきます。 後半では、Zoho CRM
                                                            • 【6/29(火) 初心者向け】カスタム関数勉強会のご案内

                                                              先日のMeetupでも告知しましたが、以前より多くのユーザーさまからご要望いただいていたZoho の「カスタム関数」に関する基本の勉強会を6/29(火) 17:00に、開催します! 関数の基本的な書き方や、Zoho CRM で活用できる関数例のデモなどについて、Zoho の技術メンバーがわかりやすく解説します。 関数の基本を掴みたい方はぜひ、ご参加くださいませ。 >>申し込みはこちら:‌attend.zoho.com/luy0 以下詳細です。 ーーーーーーーーーーー 日時:6月29日(火) 17:00~
                                                            • 【3/19(金)】Meetup(ユーザー交流会)開催のご案内。Zoho CRM ユーザー事例やZoho Sign の紹介、Zoho CRM 相談会など

                                                              こんにちは、Zoho Japan コミュニティチームの今成です。 2021年1回目となるMeetupを、3月19日(金)16:00~ 開催いたします! ●詳細はこちら:https://www.zohomeetups.com/ZohoJapanOnlineMeetup2021vol1 毎回好評のZoho ユーザーさまによる活用事例をはじめ、Zoho の電子署名ツール「Zoho Sign」の製品デモや、グループディスカッションをご用意しています。 前半/後半のみのご参加も可能ですので、お気軽にご参加ください!
                                                            • 【12/17(木) 16:00-】ユーザー同士で情報交換を行う、グループディスカッションもあります。オンラインMeetup Vol.4 開催のお知らせ

                                                              Zoho コミュニティチームの今成です。最近寒くなってまいりましたが、みなさまいかがお過ごしですか? Zoho Japan Communityでは、今年最後のオンラインMeetup(ユーザー交流会)を開催いたします!以下、詳細のご案内です。 ーーーーーーーーーーーーーーーーーーーーー <日時>2020年12月17日(木) 16:00-18:00 <参加費>無料 <開催方法>オンライン <概要> 前半(16:00〜17:00)  自社活用事例「Zoho 社員は、1日の中でどのサービスをどれくらい使っているのか」(ゾーホージャパン株式会社 コミュニティチーム)


                                                            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

                                                                                                              • 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
                                                                                                              • Allocating inventory to specific SO's

                                                                                                                Is there a way that allocate inventory to a specific sales order? For example, let's say we have 90 items in stock. Customer 1 orders 100 items. This allocates all 90 items to their order, and they have a back order for the remaining 10 items which could
                                                                                                              • Cancelled Transfer order problem

                                                                                                                Hello, We've canceled a transfer order, and we can't add the related items to a new Transfer Order. The system tells us that the bin doesn't have the required quantity, but when we check the item, it indicates that there are 2 units in the bin. It also
                                                                                                              • Creating a Chart from a Report

                                                                                                                In Zoho Analytics, is it possible to create a chart from a Pivot View report? We are looking to use Zoho Analytics to replace Excel for Sales reports and would like to be able to show both the table and the chart together.
                                                                                                              • Client Portal ZOHO ONE

                                                                                                                Dear Zoho one is fantastic option for companies but it seems to me that it is still an aggregation of aps let me explain I have zoho books with client portal so client access their invoice then I have zoho project with client portal so they can access their project but not their invoice without another URL another LOGIN Are you planning in creating a beautiful UI portal for client so we can control access to client in one location to multiple aps at least unify project and invoice aps that would
                                                                                                              • Email Insights included in Bigin emals are marked as SPAM everywhere

                                                                                                                Today I noticed that email recipients who use Office 365 never receive emails sent from Bigin. Further examination showed that all Email Insights links in email headers are marked as spam/phishing by Office 365. Example screen included. The problem is
                                                                                                              • Data Import | Zoho Analytics Custom Query Window Size

                                                                                                                Please increase the window size for the Custom Query Data Import. It's impossible to work with such a small query window.
                                                                                                              • Name changed in settings for mailbox but still not changed when typed in To field

                                                                                                                In the email account secretary@ i have updaetd the new staff members details but the old members name still appears when I type secretary@ in the To field. I cant work out where Zoho is finding the old name from. I have deleted the browser cache. If I
                                                                                                              • Cannot add my name to my domain name

                                                                                                                I want to have My name@mydomain.com and it says my name is linked to another account already. Please fix it since I do not have another account.
                                                                                                              • Invoice status on write-off is "Paid" - how do I change this to "Written off"

                                                                                                                HI guys, I want to write off a couple of outstanding invoices, but when I do this, the status of the invoices shows as "Paid". Clearly this is not the case and I need to be able to see that they are written off in the customer's history. Is there a way
                                                                                                              • Establishing new Zoho email account on laptop

                                                                                                                Good Morning: I am very long time Outlook business user and decided to try your email service last night and had established an account. I am trying to verify my account; how do I establish my Zoho email account on my laptop? I opened the account with
                                                                                                              • unable to send message reason 550 5.4.6 unusual sending activity

                                                                                                                My email account can't send message. It shows unable to send message reason 550 5.4.6 unusual sending activity detected
                                                                                                              • how to add email to existing organization i w

                                                                                                                I am already registered my organization and i have an email id. I need one more email id but i can't find anywhere .i want the cheapest email id . how to add ?
                                                                                                              • e-mail bloqueado

                                                                                                                Estou com meu e-mail lucas@peplus.me bloqueado, preciso desbloquear para retorno de usos em minhas atividades.
                                                                                                              • zoho labels api not working

                                                                                                                We're using n8n to automte email reply using zoho api. I'm facing issue with label api. I added the required scopes but its not working. i followed zoho api documentation but didn't work. also, where do i find/how do i create zoho oauth token mentioneeed
                                                                                                              • Desk DMARC forwarding failure for some senders

                                                                                                                I am not receiving important emails into Desk, because of DMARC errors. Here's what's happening: 1. email is sent from customer e.g. john@doe.com, to my email address, e.g info@acme.com 2. email is delivered successfully to info@acme.com (a shared inbox
                                                                                                              • Streams/Shared email doesn't show up in windows trident app. It works fine on MAC. Is there any difference between 2 install ?

                                                                                                                I can see streams/share email boxs on my MAC version of trident app but i can't see them in windows version of trident app. Is there any difference between 2 install? I try to find setting but not able to see any setting to add stream/share email boxes.
                                                                                                              • add zoho account

                                                                                                                How to add a zoho mail to previous zoho account? I have two
                                                                                                              • Zoho Desk Mobile App Year-End Roundup - 2025

                                                                                                                Dear Zoho Desk users, Greetings! As you gear up for the festive season, we are excited to share a quick journey into all that is released in 2025! Zia's generative AI capabilities Zia insights can be highly beneficial in helping agents manage daily support
                                                                                                              • Narrative 17: The role of Zia AI in customer support

                                                                                                                Behind the scenes of a successful ticketing system: BTS Series Narrative 17: The role of Zia AI in customer support Overview Zia in Zoho Desk is a layered AI assistant that combines generative AI, prediction, and automation to support agents, automate
                                                                                                              • Domain Transaction

                                                                                                                I have purchased a domain name called trainedworkforce.co.in I made the payment got the receipt but the domain is still not purchased after successful transaction .
                                                                                                              • Ability to Set a Unified Tab Order/View for All Users in Zoho Projects

                                                                                                                Hello Zoho Projects Team, We hope you are doing well. We would like to submit a feature request regarding tab/menu organization in Zoho Projects. Current Behavior: The tab (module) order in Zoho Projects is user-specific. Each user (internal or external)
                                                                                                              • Zohomail - The "All Messages" vs "In Box"

                                                                                                                Why do some new email message appear under the all messages view but not in my inbox? That's really annoying but to be fair I've experienced the same with gmail.
                                                                                                              • error while listing mails

                                                                                                                I can't access email in any of my folders: Oops, an error occurred - retry produces the second error response: error while listing mails (cannot parse null string). I've signed in and out of Zoho, restarted my iMac.
                                                                                                              • Introducing the Zoho Projects Learning Space

                                                                                                                Every product has its learning curve, and sometimes having a guided path makes the learning experience smoother. With that goal, we introduce a dedicated learning space for Zoho Projects, a platform where you can explore lessons, learn at your own pace,
                                                                                                              • Where to show Customization Field ?

                                                                                                                Dear Sir, I have made some New Field in Item Field Customisation. Now I don't require that field in Estimate, Sales Orders etc. I just wants that field in Sales Invoice to Show/Hide... Is that possible ?
                                                                                                              • Zoho Desk 2025 round-up: Key highlights on feature releases

                                                                                                                Hello everyone, As we gear up for 2026, here is a detailed round-up of all feature releases in Zoho Desk web throughout the year. For consolidated information on releases check out the What’s New page You can also watch these webinars. Zia in web Zia
                                                                                                              • Print Sales Orders, Purchase Orders or Invoices from API

                                                                                                                Hello, Is it possible to use the print option that is available in Sales Orders Purchase Orders and Invoices with the API?. I don't see any information in the docs about this. Thanks
                                                                                                              • How to show a hided report??

                                                                                                                in CRM Report , I clicked Hide incidently , how to show the floder again? Nowhere I can find the hided report floder...
                                                                                                              • Converting Customer Invoice to Purchase Bill

                                                                                                                Hi, In my service-based business, I sometimes create the customer invoice first, and later I receive the purchase bill from the vendor for the same job. Is there any option in Zoho Books to: Convert a customer invoice into a purchase bill, or Link/associate
                                                                                                              • Email tracking inquiry

                                                                                                                I am trying to track when my emails are opened and clicked like I previously did in HubSpot. HubSpot pretty much did the entire process automatically. After digging through, I finally found in settings --> emails --> BCC Dropbox there is an email I can
                                                                                                              • Mass Update of Lookup Fields not possible

                                                                                                                Hello List I've created a custom field for Leads and Contacts 'Current Campaign'. This is very Handy as I can filter leads and then related them to a campaign. Everything ready, but then I realized that mass update doesn't work for lookup fields... a
                                                                                                              • Collapsible Sections & Section Navigation Needed

                                                                                                                The flexibility of Zoho CRM has expanded greatly in the last few years, to the point that a leads module is now permissible to contain up to 350 fields. We don't use that many, but we are using 168 fields which are broken apart into 18 different sections.
                                                                                                              • Quick Create needs Client Script support

                                                                                                                As per the title. We need client scripts to apply at a Quick Create level. We enforce logic on the form to ensure data quality, automate field values, etc. However, all this is lost when a user attempts a "Quick Create". It is disappointing because, from
                                                                                                              • Download Attached Files

                                                                                                                Hi everyone, Brand new to Zoho Creator.  I have a form with a subform. The subform has a field for "File Upload"   I have this in a subform to allow multiple files to be uploaded to the parent form. Once the files are uploaded, how can i download or view them?   Is this a setting I am just not seeing? If there isn't a way to download them, could i create another form field that dynamically creates the file's URL?  That way a user can click the URL to get to the file? Any help with this would be greatly
                                                                                                              • Ticket layout based on field or contact

                                                                                                                Hi! I want to support the following use-case: we are delivering custom IT solutions to different accounts we have, thus our ticket layouts, fields and languages (priority, status field values should be Hungarian) will be different. How should I setup
                                                                                                              • No funcionan correctamente el calculo de las horas laborales para informe de tickets

                                                                                                                Hola, estoy intentando sacar estadísticas de tiempo de primera respuesta y resolución en horario laboral de mis tickets, pero el calculo de horas en horario laboral no funciona correctamente cree los horarios con los feriados : Ajusté los acuerdos de
                                                                                                              • Zoho Mail Android app update: Set out of office response exclusively for organization members and external users, response interval

                                                                                                                Hello everyone! We have now introduced an option to configure out of office messages exclusively for organization members and external users within the Zoho Mail app. Additionally, now you can also customize response intervals for the Out of office messages.
                                                                                                              • Feature Request: Detailed View - Related Block Links!

                                                                                                                Desperately need a view record link option on records displaying in the related blocks on a Detail View. For the love of god, please add this feature. Thank you!
                                                                                                              • Sub-Form Padding in CSV Export

                                                                                                                Hi, When you use the Sub-Form, and for example you have a Date Field on the Main Page, then Option 1 and Option 2 fields on the Subform, when you export this to CSV the Date column will only have the Date in 1 row, the first row, it would be nice to pad
                                                                                                              • Next Page