【開催報告】名古屋 ユーザー交流会 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

        All-in-one knowledge management and training platform for your employees and customers.






                              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

                                                              • 普段使っているAI、Zohoと繋げてもっと便利にしませんか?【Zoho MCP】

                                                                みなさんこんにちは、ゾーホージャパンの岸本です。 ChatGPTなどのAI、普段から使っていますか? 最近は「AIを使う」だけでなく、 普段利用している業務ツールとAIを繋げて活用するケースが増えてきています。 そこで6月のコミュニティイベントでは、Zoho社員セッションでZoho MCPを取り上げようと思います。 【Zoho MCPって?】 Zoho MCPは、AIとSaaSアプリケーションを連携するための仕組みです。 ----------- MCPプロトコルをサポートしているLLM(一例):
                                                              • 【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」の製品デモや、グループディスカッションをご用意しています。 前半/後半のみのご参加も可能ですので、お気軽にご参加ください!


                                                              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

                                                                                                                • Modify logo on exported PDF article

                                                                                                                  Hello, I have to 2 Help Center with 2 different brands. If I try to download an article from Help Center Brand #2 as a PDF file, I see the Brand #1 logo on it. Is there a way to modify or hide the logo in the pdf? Thank you Antonio
                                                                                                                • Pasting Images in Zoho Desk ignores cursor location

                                                                                                                  My team has reported an issue which started recently where when we paste an image into a new or existing reply or comment, the pasted image seems to ignore the current cursor location instead paste itself at the last character present in the reply/comment,
                                                                                                                • Lost the ability to sort by ticket owner

                                                                                                                  Hi all, in the last week or so, we have lost the ability to sort tickets by Ticket Owner. Unlike the other columns which we can hover over and click on to sort, Ticket Owner is no longer clickable. Is it just us, or are other customers seeing this too?
                                                                                                                • Zero Customer Support

                                                                                                                  I have been a paying customer on Zoho Mail Premium, which clearly advertises a 40MB attachment limit. However, for a long time now, I have been experiencing ongoing issues sending PDF attachments over 10MB. Instead of sending properly as attachments,
                                                                                                                • Unable to send message;Reason:554 5.1.8

                                                                                                                  Dear Zoho Support Team, I have attempted to send multiple documents in several different ZIP files containing PDF and Word documents. Initially, I received the following notification: “When Office 365 tried to send your message, the receiving email server
                                                                                                                • SOLVED - Unsubscribe Feedback Page inexplicably presenting in French, German, etc. not default language of English

                                                                                                                  As the titles says, had the "Unsubscribe Feedback Page" for two different clients presenting the feedback options to unsubscribers in French, German, etc., not in English like it should. And no, it wasn't due to user preferences, embedded web translators,
                                                                                                                • Identify and clean hard bounce lists in Automation 2.0

                                                                                                                  Hello. 1. I want to know how I can identify hard bounces in the lists I created to clean them before sending an email, given that the bounce rate has increased and it is necessary to clean the lists. 2. How can I exclude hard bounces and invalid emails
                                                                                                                • Catalyst DB is insufficient for many use cases

                                                                                                                  Hi all: I've been diving deep on full stack application development inside Zoho Catalyst. I've been using catalyst for serverless compute and API gateway for a few years, but I haven't used the DB beyond simple storing of app data. As I was working through
                                                                                                                • Edit a previous reconciliation

                                                                                                                  I realized that during my March bank reconciliation, I chose the wrong check to reconcile (they were for the same amount on the same date, I just chose the wrong check to reconcile). So now, the incorrect check is showing as un-reconciled. Is there any way I can edit a previous reconciliation (this is 7 months ago) so I can adjust the check that was reconciled? The amounts are exactly the same and it won't change my ending balance.
                                                                                                                • How to change column headings in pivot table?

                                                                                                                  Hi, Is there a way to rename the column headers of a pivot table? Now some the columns are named with value labels: 'SUM of .....'. We would like to rename those headers. As of now we couldn't find any direct solution to adjust the headers, besides copying and reformat. We want to avoid these extra steps. Best, Tiemen
                                                                                                                • Native QuickBooks integration for Zoho CRM: Connecting sales and finance

                                                                                                                  Greetings, I hope all of you are doing well. We're excited to announce Zoho CRM's integration with QuickBooks Web, which is designed to synchronize your CRM data with your QuickBooks accounting records and bridge the gap between sales and finance. This
                                                                                                                • Rename system-defined labels in Zoho CRM

                                                                                                                  Renaming system-defined labels is now available across all DCs. Hello everyone, Zoho CRM includes predefined system fields across modules to support essential CRM operations. Until now, the labels of these fields were fixed and could not be edited from
                                                                                                                • Push conversation to operator in guided conversations

                                                                                                                  I really would like to push the conversation to an operator from a specific deppartment in guided conversations, just like Zobot in sales iq. It would help a lot. For me it does not make sense to use sales iq for messenger, instagram and others, because
                                                                                                                • Report/All Entries Filter Contains to support multiple values

                                                                                                                  Hi, I use different fields to filter All Entries before Export, one is the Added Email ID (May soon replace with the new Logged in User Name Field!!), and I want to filter for more than one person, so select "Contains", but I try with a comma seperating
                                                                                                                • Marketing Tip #32: Improve SEO and customer confidence with an FAQ section

                                                                                                                  Before making a purchase, customers often have simple questions about delivery times, returns, product usage, or sizing. If they can’t quickly find answers, they may leave your store without buying. Adding a clear FAQ (Frequently Asked Questions) section
                                                                                                                • Zobot with Plugs

                                                                                                                  Hello, I am having a problem with Zobot using Plugs. Here is my current flow: When I run the flow, I should immediately see the messages from the initial cards (Send Message cards), then after running the plug, and finally, see the messages after the
                                                                                                                • Zoho Creator é para você? Saiba quando escolher (e quando não escolher) essa plataforma

                                                                                                                  Todo mês alguém me pergunta: "Leandro, vale a pena usar o Zoho Creator para o meu projeto?" A resposta honesta é: depende. E neste artigo vou te dar os critérios reais que uso para tomar essa decisão — sem marketing, sem generalização. O que é Zoho Creator,
                                                                                                                • Control Fields on Mobile App

                                                                                                                  On the mobile app, how do we control which fields appear on the screen for records that have a related list? In the example below I want the Inspection Stage and Inspection Type fields to appear, not the record owner (Dev Admin). I changed the Inspections
                                                                                                                • Show Zoho Marketing Automation Messages in SalesIQ Chat

                                                                                                                  When the same number is used in Zoho Marketing Automation and SalesIQ, campaign messages should be visible inside the SalesIQ chat. Currently, when customers reply to marketing campaign messages, SalesIQ chat owners get confused because they cannot see
                                                                                                                • Switch between multiple LLMs instantly for tailored Zia experiences

                                                                                                                  Availability Editions: Professional , Enterprise, Ultimate , CRMPlus , ZohoOne Release Plan: Available for all DCs Hello everyone. Earlier, the Multi-LLM feature supported only one LLM at a time for Zia Record Assistant bot restricting flexibility from
                                                                                                                • SalesIQ Chat Owner to CRM Lead Owner Mapping

                                                                                                                  There is no proper mapping between the SalesIQ chat owner and the CRM lead owner. When a chat is assigned to an agent, the lead created in CRM is often assigned to a different user, forcing admins to manually change ownership every time. This creates
                                                                                                                • Automatic Email Alerts for Errors in Zoho Creator Logs

                                                                                                                  Hello, We would like to request a feature enhancement in Zoho Creator regarding error notifications. Currently, Zoho Creator allows users to view logs and errors for each application by navigating to Zoho Creator > Operations > Logs. However, there is
                                                                                                                • [Webinar] Agentic AI and its influence on analytics and autonomous decision-making

                                                                                                                  Analytics is evolving from passive reporting to proactive, intelligent systems. Agentic AI is at the center of this shift, bringing context-aware reasoning, continuous learning, and the ability to act on data in real time. Join this webinar with Michael
                                                                                                                • Zoho One: books and inventory working together

                                                                                                                  Hi, I was very pleased when I saw that in Zoho Inventory can now pull the orders from Woocommerce. They are now fed in Inventory as Sales order and with choosing convert invoice as Instant Invoice I am getting the exact data as they appear in Woocommerce.
                                                                                                                • Zoho Forms - Form Availability Redirect Option

                                                                                                                  Hi Forms Team, It would be great if there was a redirect URL option on the Form Availability settings. For example, I would like to create a support form which is only available outside business hours and if the current data and time is not Mon-Fri 9-5
                                                                                                                • VAT and Taxes option not available

                                                                                                                  Dear ZOHO Team , The VAT and Taxes options in my ZOHO books account not available,I tried to find how to enable or check the way to use this option but unfortunately couldn't find it anywhere ,I'm in UAE ,kindly let me know what to do to solve this issue
                                                                                                                • Syncing zoho books into zoho crm

                                                                                                                  I was wondering how I can use zoho books in crm as I have been using them separately and would like to sync the two. Is this possible and if so, how? Thanks
                                                                                                                • Client requests I submit invoices using bill.com

                                                                                                                  The title states it all. I have a reoccurring invoice setup for this client who has been manually paying by credit card. We are both experiencing merchant costs/fees. The use of bill.com's direct deposit is not far removed from Zoho's, only the client
                                                                                                                • Zoho Inventory Feature Roadmap Visible To All

                                                                                                                  Hello, please consider making your feature roadmap visible to us users so that we know what to expect in future. This may appease current users who are seeking clarification on feature implementation dates, so that they can make an informed decision whether
                                                                                                                • Can't Remove Payment Gateway

                                                                                                                  I am getting the error "Settings cannot be cleared as some of the transactions are still in progress." when trying to remove the PayGate payment gateway which I was unable to get working. I am now using paystack and I want to remove Paygate.
                                                                                                                • Improve Zoho Vault search

                                                                                                                  Hello, we started using Zoho Vault and we really appreciate the app. At the moment, when searching passwords, the search query only targets the password name. I think having the query search among Name, User name, URL, Notes and Tag would be a better
                                                                                                                • New in WorkDrive: Personalize your file system with Labels

                                                                                                                  Data is the driving force behind every decision made by businesses today. We at WorkDrive know every employee needs reliable access to their information and be able to locate the data they need at the right time.  Introducing Labels: organize your files in a way that's personal to you.  While WorkDrive's Data Templates feature focuses on adding structure to your organization's data, Labels help your team members classify files based on their preference. The Labels created will appear only to the
                                                                                                                • Custom Buttons & Links Now Supported in Portals

                                                                                                                  We’ve just made portals in Zoho Recruit more powerful and customizable than ever! You can now bring the power of Custom Buttons and Links to your Candidate, Client, Vendor, and Custom Portals, enabling portal users to take direct action without recruiter
                                                                                                                • No Ability to Rename Record Template PDFs in SendMail Task

                                                                                                                  As highlighted previously in this post, we still have to deal with the limitation of not being able to rename a record template when sent as a PDF using the SendMail Task. This creates unnecessary complexity for what should be a simple operation, and
                                                                                                                • Integrate your Outlook/ Office 365 inbox with Zoho CRM via Graph API

                                                                                                                  Hello folks, In addition to the existing IMAP and POP options, you can now integrate your Outlook/Office 365 inbox with Zoho CRM via Graph API. Why did we add this option? Microsoft Graph API offers a single endpoint to access data from across Microsoft’s
                                                                                                                • Work Type Section in Field Service Settings

                                                                                                                  Hello Team, We are trying to understand how skills are managed in the system. During our review, we found an article mentioning a section called Work Type, which is used to manage skill assignment. According to the documentation, this section should be
                                                                                                                • Mirror Component in Zoho CRM: Access real-time related data without leaving your record

                                                                                                                  Hi everyone, This feature is now available for the JP, CA, SA, UAE, and AU DCs. We're excited to bring to you Zoho CRM's mirror component, which presents relevant data on a record's details page and keeps everything users need in one place without having
                                                                                                                • Clone a Module??

                                                                                                                  I am giong to repurpose the Vendors module but would like to have a separate but very similar module for another group of contacts called Buyers. I have already repurposed Contacts to Sellers. Is it possible to clone (make a duplicate) module of Vendors
                                                                                                                • Is there lead tracking in Bigin? There should be.

                                                                                                                  Is there a way to track leads before they are ready to be added to Pipelines? I'm afraid we're going to lose opportunities. Example: We're sending out small batches of 25 emails to those we collected at tradeshows. They are all qualified leads. Out of
                                                                                                                • How to get static reports via Desk API

                                                                                                                  Hello, we are hoping to use the Desk API to automatically export the default static reports in Zoho Desk, or reconstruct them via other API calls. What's the best way to do this? For example, if I want to recreate the Response Time static report via the
                                                                                                                • Next Page