【開催報告】名古屋 ユーザー交流会 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 コミュニティをよろしくお願いいたします！

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




      • 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日の中でどのサービスをどれくらい使っているのか」（ゾーホージャパン株式会社　コミュニティチーム）

        • Recent Topics

        • Tax Deductible Donations to a Charity Organisation

          For Australia, what's the best/proper method for entering an expense that is a tax deductible donation to a charitable organisation. And thus is appears correctly in Accounts and BAS as a GST payable deduction?

        • Simultaneous use of WhatsApp Account in SalesIQ and ZohoDesk

          Hi, We have only one number registered in Meta, it's possible use same account for two apps? All times here we try is stopping in SalesIQ. Regards,

        • External lookup fields to synchronise with Analytics

          Hello. I suggest adding external lookup custom fields to the Zoho Analytics integration settings. Currently, these types of fields are not available for synchronisation, so they cannot be used to generate reports with related tables in Analytics. Thank

        • We should have an option to Toggle Off KB Article Links in AI Answer Bot Replies

          Hi everyone, I'm creating this topic to share a feature idea that I think would improve the customer experience when using the AI Answer Bot for self-service. The Current Behavior (The Problem) Currently, when the AI Answer Bot generates a summary or

        • Boot Loop After Removing Service from Client via Admin

          We have multiple laptops experiencing a boot loop / unable to login after the Zoho Remote service was removed from their machine remotely via the desktop client. The Windows sign-in screen is not available, and users are unable to login. This seems like

        • Request Backend Correction — Domains Mapped to Same Help Center (Multi-Brand Setup Failure)

          Hello Zoho Desk Support Team, I need assistance correcting a domain-to-brand mapping issue in our Zoho Desk instance (The Blue Ribbon Project). Both of our verified domains currently point to the same Help Center instead of separate brand portals. Current

        • is there any option to enable the participants interact - can write on the screen, while the screen is shared by the host?

          this is most expected features - for teaching children. is there any option to enable the participants interact - can write on the screen, while the screen is shared by the host?

        • How to disable the Login button in Desk Helpcenter

          Hey there, I'm testing out whether the help center within Zoho Desk could replace our existing Customer FAQ. I tried to customize the themes for the public help center frontend, but stumbled across the login button in the navigation bar. Is there any

        • Subforms in stateless forms

          I think the title says it all. We need to be able to add subforms to stateless forms. Currently the only workaround is to create a Form and delete each record upon submission of the form. I need to build an interface to update our inventory. Basically

        • Standard Payment Term is not pulled from account to quotation

          Hey Team There seems to be something off. I do have "Net 30" as my default payment term in Zoho Books for my customers. If, from the customer overview or quote section, I create a new Quotation, the payment terms field stays blank and doesn't get the

        • Best way to display complex Bookings Consultation Descriptions on Zoho Site?

          I am a new user so apologies if this has been asked before. I couldn't find any answers in the forum. We offer 18 complex Consultations to our subscribers. Our current platform lets me put detail on these Consultations thoroughly (200-300 words) during

        • Gmail is ramping up its email sender policy as of November 2025

          Hello marketers, As you may be aware, Gmail introduced a guideline for bulk senders starting February 2024. If not, here's a quick refresher straight from Google: After this policy was announced first in 2023 and soft-implemented in February 2024, we

        • Modifying iframe data of Zoho booking iframe

          Hello, I have integrated a Zoho Bookings embedded iframe into my website. Currently, I am pre-filling the booking form with default values as part of our process flow. However, I want to ensure that if an input field is already populated with a default

        • Zoho CRM Workflow and Function Backup Options

          Hi everyone! I have been able to make several backups of my CRM data and noticed that the Workflows and Functions are not included in these backups. To my knowledge, there is no backup feature for workflows and functions, which is problematic in of itself.

        • Enhance Sign CRM integration

          Hello all, I'm working on a custom Deluge script to enhance the integration between Zoho CRM and Sign by using a writer merge template for additional flexibility. I want to replicate the post-sign document integration that exists between CRM and Sign

        • YouTube Live streaming? how to? Zoom has this feature, built-in. Can't find it on zoho meetings.

          YouTube Live streaming? how to? Zoom has this feature, built-in. Can't find it on zoho meetings.

        • Is or will be possible to associate meeting transcription and summary, made by Zia, to meeting/contact/account record in CRM?

          Would be useful to keep context and track jobs, better if it will be auto

        • Desk Field Not Showing in Analytics

          Hi there, I recently added a field to our Zoho Desk Ticket Information. I went and added the data retrospectively to the tickets. It is also marked as required, so all new tickets cannot be closed off without it being filled in. When I try to run a report

        • Export data using advanced export options and customizable settings

          Hello everyone, The user interface for exporting data has been revamped with updates to make data exports more flexible and efficient for users. These updates not only enhance usability but also bring advanced capabilities to help users extract precise

        • Moving data from one pipeline to another

          Hey all, I've got some complex pipelines to build and I'd like to seperate them into seperate pipelines rather than have one mammoth one. If I create 2 pipelines, is there any easy way to use the output of Pipeline1 to be the input into Pipeline2? Or

        • How to export/find all deluge code.

          Hi, I have a large app wich contains several forms, reports, html views, I need to find thow my application if any contains specific word, I could find it manually by editing app and see on every section(field code, on succes, on load, etc) but I would like to do it faster. Is there a way to at least export it to a file the whole deluge code on my application?

        • Have Some Bugs in Zoho CRM Ask Zia Assistant

          Hi Support Team, I have found some bugs in Zoho CRM Ask Zia Feature Please Check below screenshot, insight option is showing twice i think its in early access that's why its have some bugs .

        • COD with Partial payment

          Two reasons why we need COD with partial payment option. 1) Since we deal heavy weight products our shipping costs are too high. If shipment is rejected by customer we incur huge loss. 2) Some competitors place fake orders with different names and return

        • Slicers are now available in Zoho Sheet—filter your data interactively

          At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,

        • Resizing a Record Template Background Inage

          Hi everyone, I have an issue which I can't seem to resolve: Basically, I'm designing a record template in certificate form. I've specified A5 landscape. I've set my background image the same dimensions with total pixels at 443,520. Whatever I try, when

        • Updated font library: New font styles and custom font options in Zoho Sheet

          Zoho Sheet's font library now supports 500+ font styles in 60+ languages! The updated font library is stacked with new font styles, and some of the previously available font styles have been replaced with equivalent options. There are two ways you can

        • Introducing Data Bars: Graphically represent changes in data within the cells

          Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient method

        • Default Font Size in Desk

          How do I set my default font size in Desk? It takes me about 45 minutes to find the place to set it, then, when I sign out of Zoho and log back in, it's back to font 10 again. Seems like this would be simple, but like everything with Zoho, it's buried

        • Tip #19 - Create checkbox tracker in your spreadsheet

          Hello Sheet users! We are here with yet another tip to help you get the most out of Zoho Sheet. Spreadsheets can be used to handle a variety of tasks, but ever tried using checkboxes to track the progress of your action items dynamically? Here's a sample

        • Tip #20 - Three things you probably didn't know you can do with picklists

          Hello Zoho Sheet users! We’re back with another quick tip to help you make your spreadsheets smarter. Picklists are a great tool to maintain consistency in your spreadsheet. Manually entering data is time-consuming and often leaves typos and irregular

        • Per Level Approval for admins

          We need Process admins like Zoho CRM in Zoho Books for per stage approval Currently in books, admins only have the option for Final Approval But for example, in cases like when an employee is on leave, we can't just approval one level we only have option

        • Feature enhancement: Highlight rows based on a cell value

          Hello Sheet users, We're excited to announce a new feature enhacement, shaped directly by your valuable feedback! As you might know, conditional formatting is a great tool for anyone dealing with large data sets. Previously, if you’ve ever wanted to draw

        • Updating custom fields in Zoho Projects

          Hi I am wondering if anyone has experience with custom fields in Zoho Projects. I am struggling to update the field using either deluge or the api endpoint. My code is: //custom_Map = map(); custom_Map = {"UDF_DOUBLE_1":"0.27"}; update_Map = map(); update_Map.put("custom_fields",custom_Map.toList());

        • Markdown for Desk?

          Hi, my company wants to use markdown for formatting text in Desk (in all modules there, especially Tickets and Helpcenter). Zoho already offers use of markdown in several products (see https://help.zoho.com/portal/en/kb/backstage/microsite-guide/formatting-with-markdown/articles/formatting-with-markdo)

        • Change Currency symbol

          I would like to change the way our currency displays when printed on quotes, invoices and purchase orders. Currently, we have Australian Dollars AUD as our Home Currency. The only two symbol choices available for this currency are "AU $" or "AUD". I would

        • Calendar not working

          Are we the only ones. On any browser we cannot click on any of our calendar appointments and get them to open. They just make the browser loop. WE have reached out and have been told they are working on it. The office staff are really stuck. The point

        • Tip of the week #16 - Search and filter threads based on criteria

          Zoho TeamInbox lets you search and filter threads with any information that you have about the thread. You just have to input the criteria and Zoho TeamInbox will list all the threads that match the condition.   Firstly, there is a global search you can

        • WhatsApp Message Template Quick Reply Buttons

          Hello, I created my first Message Template to overcome the 24-hr messaging window and it was approved by WhatsApp/Meta. When I go to Meta, I also see that template brought from Zoho Desk, and used it via Zoho Desk IM. However, I notice that when in Meta's

        • Account in Quick View Filter

          I have a report that I often run against a specific Account. Every time, I have to go into the edit menu and change the Advanced Filter. I would prefer to use the Quick View Filter, but it does not allow me to use the one and only field that makes any

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

        • Next Page