【開催報告】名古屋 ユーザー交流会 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 では、以下の機能を活用して在庫管理を実現しました。
商品登録機能
- 売上価格と仕入れ価格の両方を登録可能
- 先入れ先出し法、移動平均法などの在庫計算方法に対応
- 期首在庫数と基準在庫数の設定によるアラート機能
組み合わせ商品機能
- 部品の組み合わせによる商品作成が柔軟に設定可能
- 各部品の使用数量と金額の詳細設定が可能
受発注管理
- 取引先ごとの価格パターン設定
- 発注書・受領書・支払依頼書の帳票展開機能
2-2. Zoho Analytics ：将来在庫推移表の作成
Zoho Inventory だけでは実現できなかった「将来的な在庫予測」について、Zoho Analytics を活用して解決しました。
Zoho Analytics で作成したレポート： 将来の在庫推移予測表を作成し、以下の項目を表示できるようにしました。
- 部品名・組み合わせ商品名
- 基準在庫数
- カスタムフィールド（必要納品数、SPQ（最小発注単位）、MOQ（最低発注数））
- 月別の出荷予定・入荷予定・在庫調整・在庫残数
技術的な実装： 在庫変動イベント（受注・出荷、仕入れ・納品、在庫調整、バンドル出荷、仮想出荷）を
統合したテーブルを作成し、全月・全商品の組み合わせテーブルと結合することで、動きのない月も含めた在庫推移を表示できるようにしました。
統合したテーブルを作成し、全月・全商品の組み合わせテーブルと結合することで、動きのない月も含めた在庫推移を表示できるようにしました。
※実装にあたっては、Zoho Analytics の制約事項（ジョイン制限、NULL値の扱い、レポート列数制限など）を考慮した設計が必要でした。
まとめ
今回の取り組みにより、将来的な在庫見通しが可能になり、発注漏れが大幅に減少したと
クライアント様から高い評価をいただきました。 今後は発注数量などと在庫が連動してアラートを表示するなどの設計を進めていきたいと思っています。
クライアント様から高い評価をいただきました。 今後は発注数量などと在庫が連動してアラートを表示するなどの設計を進めていきたいと思っています。
野末さん資料：
グループワーク：Zohoで"見える化"した / したい、自社の数字
Zoho を活用して、自社で見える化したデータ・今後したいデータについて、参加者同士で共有していただきました。
共有内容 一部抜粋：
・Zoho PageSense: ヒートマップ等を利用して、サイト行動の可視化
・Zoho Social: 自社SNS投稿の反応を確認
最後に
今後のコミュニティイベントは、以下の通りの開催を予定しています。
枠に限りがありますので、参加を希望される方はお早めに参加登録をお願いします。
12/18（木）14:00～ ユーザー同士で課題解決！ Zoho ワークアウト オンライン
今後取り扱ってほしいトピックや、今回参加した感想などについて、本投稿のコメントにいただけると励みになりますのでぜひお願いします。
SNSハッシュタグ：#Zugmeetup
今後ともZoho コミュニティをよろしくお願いいたします！
ゾーホージャパン コミュニティチーム
Access your files securely from anywhere
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Junya Nakano
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日の中でどのサービスをどれくらい使っているのか」（ゾーホージャパン株式会社 コミュニティチーム）
New to Zoho TeamInbox?
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
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Automate timeout chat tracking with Workflows in SalesIQ
With our feature-packed Nova release, Workflows has become one of the most powerful tools in Zoho SalesIQ. They let you automate follow-up actions when key events occur, such as when a chat ends, a visitor leaves a bad/good rating, or a lead is updated.Mass edit / Mass update products
Hi, Is there any way to mass update or bulk edit product fields in Zoho Inventory?Automatic Verification of IMAP Integration Status
Our sales staff have their O365 email integrated with CRM, over time this integration requires re-authentication via the UI. I can manually check the integration status by accessing Settings -> Channels -> Email -> Email Sharing -> "Configuration Type"Tip of the Week #68– Share and access files faster with Zoho WorkDrive extension.
Have you ever wasted time searching for the right file to attach to your emails—or worried whether the right people could access it? Without proper sharing settings, files might end up inaccessible to teammates or, worse, visible to people who shouldn’tCV-Library: The Newest Source Booster in Zoho Recruit!
We’ve expanded your sourcing toolkit — CV-Library, one of the UK’s largest and most trusted online job boards, is now available as a Source Booster in Zoho Recruit. This gives recruiters instant access to millions of UK-based candidate profiles, all withoutIs there the possibility to book less than 250 customer portal users?
If you use the Creator, which is included in Zoho ONe, you can create a customer portal and give access to a maximum of 3 external people / customers, right? On the Creator website I saw that you can add 250 users for 100€/month. However, we don't needDisplay Parts custom fields in the Work Order
Hello, I see that is it possible to add custom fields in the Parts module. Would it be possible to also add those custom fields in the Work Order Module under Parts? This would be very useful for customer who want to showcase more information about parts.Unable to edit Saved Estimates
We are facing issue with editing the price or discount for a saved estimate for nearly 1 week.Translation Blueprint & Picklists with Custom Values
Hello everyone, I downloaded the translation file and I'm not finding the blueprint transitions. Does this means that the transitions cannot be translated? Also, the picklist values to be translated in the document are not the same that are actually used the in module. For exemple, for my lead module, the picklist values for Lead Status are : Not-contacted, contacted, junk and lost lead. In the translation document (English to French), this is what I see: PicklistValues.Leads.Lead_Status.ContactHow to create a custom sales signal?
I want to create a custom sales signal for a custom module. is it possible to create one? If anyone know please let me knowOnly show products in offers based on lead source
We work with several lead sources, each with their own products and different pricing. For example, one product might have two or three different prices. Sometimes, when creating a quote, the wrong product is accidentally selected. Is there a way to onlyNarrative 7 - The importance of data sharing
Behind the scenes of a successful ticketing system - BTS Series Narrative 7 - The importance of data sharing Definition Data sharing requires a commitment to preserving the integrity and dependability of shared data throughout its entire lifecycle. ThisCheck out in Meetings
Why there is no check out in Meetings of Zoho CRM, very difficult to trackIssue with Zoho Projet
Zoho Project on all the cellphones of my customer is crashing. He has mixed brands (Samsung and Pixel). Everything is fine on website and mobile website. Could not reproduce the issue in workshop using Samsung/Pixel/iPhone Uninstallation of Zoho ProjectSecurePass email English language issue -- please hire someone to correct the English language issues sprinkled throughout your interface
I wrote previously about some incorrect English in your SecurePass offering. After about six months it was corrected. I have never revoked permission before today and just discovered another language mistake that was not corrected. When you revoke a SecurePassPublished Components
@zoho team, Checking if we can add a password for the public links as we have non-licensed usersPlease Enable Snippets for Agents Adding Comments
Snippets and templates are currently enabled for agents when they use the reply functionality. There is currently no way to add a template or snippets when an agent comments. This is really weird. Our agents don't use the reply functionality, only theTip of the Week - Extracting Data from JSON Columns
Let's say you are importing a CSV or Excel file into Zoho Analytics. What if the file contains a few columns in JSON format? This is where Zoho DataPrep, embedded right within Zoho Analytics, comes in handy. This week's tip explains how to extract dataDeluge UI Updates
Are there any updates planned for the Deluge UI in Zoho Desk? It feels quite dated and lack-lustre after you've spent some time in the CRM Deluge UI.Zia Agents - Follow Ups
It would be nice to have Zia Agents do follow ups. A lot of times agents are trying to schedule things with users and they say "can we set your printer up tomorrow?" and the user never says anything. A way to have a personalized reminder to the user automaticallyHide Agents name in Ticket Responses in "My Area"
We were able to hide the agents name in the emails, however, the customer is able to see which agent has responded to a ticket in the thread of emails by going into their Help Center thread. Is there any way we can hide that information?Option to Automatically Update Extensions
Hello Zoho Desk Team, We recently received an email notifying us about an extension update that must be done manually. We’d like to request a feature that allows extensions to be updated automatically without requiring manual intervention. This wouldEmbed Report with Auto Height
Hello Developers, When we embed report within Page, we are getting one awesome feature to adjust the report height. "Auto" and "Custom' height. This "Auto" option works well when we have no records. But I want to embed report based on some conditionsZoho Payroll: Product Updates - August 2025
This month’s updates to Zoho Payroll bring enhanced efficiency and smarter features, simplifying payroll management for users in India, UAE, KSA, and US. Read on to explore how these updates can streamline your workflow. Filter Pay Runs by Type (India,Numerical Rating for Interviewer Assessments
Introducing Numerical Rating, a powerful new addition to interviewer assessments that brings precision and flexibility to candidate evaluations. ✅ What is Numerical Rating? Numerical Rating lets interviewers assign a score for each question in the assessment,User Tips: Adding Multiple Products (Package) to a Quote v2.0 (with Client Script)
This solution is an improvement on the original idea which used deluge. My solution was posted in the comments are: https://help.zoho.com/portal/en/community/topic/adding-multiple-products-package-to-a-quote The updated version uses client script insteadAre downloadable product available in Zoho Commerce
Hi all. We're considering switching to Zoho Commerce for our shop, but we sell software and remote services. Is there a features for downloadable products? I can't find any information about this. Thank you very much AliceCustom image for each contact using merge tag
Hi, I'm wondering if it's possible to set up an email campaign to display a different image for each contact using a custom field for the image url. I tried inserting custom html: <img src='$[UD:APP_IMAGE_URL||]$'/> but the editor seemed to reject this and did not actually add anything to the email template. Has anyone got any ideas? cheers, JeremyComment Reactions like a Thumbs Up
Can we please have the ability to emoji react on comments or at the very least, thumbs a comment up? Literally every other project management system out there can support this and it is very much needed to just acknowledge a comment instead of completelyZoho Mail Search Engine Sucks
Hello There! I really like all the features of Zoho Mail and I believe is way better than Gmail except for the Search Function. I believe Zoho Mail has a very poor search function, if you misspelled a word in the search box, Zoho Mail won't display anyAllow Subtasks and Task Lists to have their own Layout
I'd like to have the ability for subtasks and task lists to have their own layout. A subtask for us doesn't require all the fields that a parent task has. The subtask seems cluttered with all the extra fields. Within a project Task List had different purposes. I'd like the task layout to be different for some task lists.How to update Customers in Zoho Books through Zoho Flow?
Updating customers in Zoho Flow using a "update customer" action is deleting contact persons in Zoho Books.How to transfer credit between customers?
Hi All, We have a slightly odd situation. It happens that we have two separate customers that are related to each other personally. One customer has an amount of credit, and would like to use that credit to pay the *other* customers invoice. How wouldZoho Books Reports: Basic report with total items sold and Cost of goods sold
How can books show a report with Item Name || Qty Sold || Total Revenue || Total Cost of Goods Sold || Margin I need to factor in also invoices that have been credited where customers returned good. This seems like such a basic report, I'm sure I'm missingThe amount entered is more than the balance due for the selected bills."
Hi Team i am trying to record payments for vendors using API and getting this error in response as { "code": 28011, "message": "The amount entered is more than the balance due for the selected bills." } JSON is prepared according to Documentation andVBA handling named ranges
In VBA I'm able to work with a single cell named range. E.g. Set Jr = Range ("Year").Value. Also other options are working fine, like Range("Year").Address shows $L$3. However a named range refering to multiple cells is not working for me. Eg. tbl_TestKaizen #176 - Optimizing the Use of Record ID Variables in Zoho CRM Queries
Hello everyone! Welcome to another week of Kaizen! Since the release of Queries, we have covered Handling Query Variables in Zoho CRM, Serialization and Schema Management, and Leveraging the 'crmAPIResponse' object in Queries in previous posts. Today,Unbilled Items Report?
Hello! Is there any way to display a list of items that remain unbilled, without creating an invoice for each customer to see if the unbilled items box is displayed? ;-) BenConsolidation of Multi currency
Would like to discuss on the possibility of consolidating the ZOHO companiesLanded Cost Allocation / Custom Duty manual data entry
My client is an import business. They must manually enter the duty for each item with landed cost allocation in Bill. This is because customs duties cannot be allocated based on Quantity, Value, Weight, and Dimensions. Manual data entry is highly time-consumingNext Page