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

    • Double opt-in notifications and customizable confirmation messages for your webforms

      Dear CRM Community, We are excited to announce a major upgrade to our Webforms feature. You can now customize the confirmation message shown to your users who double opt-in from your webform and also customize your confirmation emails when they submit

    • Has Anyone successfully integrated Zoho and Sage Intact?

      Hey all, We’re evaluating Zoho One + Sage Intacct and I’m trying to connect with anyone who has actually implemented the two together.Specifically, I’d love to know: -- Which functions you kept in Zoho vs. Intacct (e.g., Product Catalog, AR/AP, invoicing,

    • Introducing Image Upload Field

      Hello everyone, In this post we will discuss about the benefits and usage of the Image upload field. The field is available for standard and custom modules.  Usage: This field can be used to upload a gallery of images to a record and share the record with peers or customers. The record can be made accessible to users outside of Zoho CRM via Portals, where they can upload the necessary images. Preview, editing, and deleting images: The uploaded images can be directly edited and saved from the record

    • Trigger a Workflow Function if an Attachment (Related List) has been added

      Hello, I have a Case Module with a related list which is Attachment. I want to trigger a workflow if I added an attachment. I've seen some topics about this in zoho community that was posted few months ago and based on the answers, there is no trigger

    • Free webinar alert on November 19 - Email driven strategies - Master personality based styles

      Hello Zoho Community! Want to make email management easier, smarter, and more you? We’ve got just the session for you! Join our interactive, game-based webinar to discover how Zoho Mail adapts to your personality and work style. Learn practical hacks,

    • AI generated meeting notes associated to Account or Deal

      As our organization works to improve efficiency we are looking for a solution to leverage AI to generate meeting notes and then add those notes to a CRM record such as an Account or Deal. I see Zoho has a Notebook AI offering that talks about the ability

    • due date on cheue

      how to handle cheque in zoho books for customers and vendors including due date

    • Zoho CRM Portal Field Level Permission Issue

      Hi Support Team, I am using the Zoho CRM Portal and configuring field-level editing permissions. However, we are unable to restrict portal users from editing certain fields. We have created a portal and provided View and Edit (Shared Only) access for

    • 'Statement of Accounts does not exist' error received, when creating PO using api in Zoho Inventory

      Here is request json -- JSONString = { "date": "2019-09-24", "purchaseorder_number": "PO-6-1", "delivery_date": null, "delivery_org_address_id": 36221200000056XXX, "vendor_id": 362212000000564XXX, "attention": "Testing", "line_items": [{ "unit": "Pieces", "account_id": 36221200000003XXX, "quantity": 1, "item_id": 362212000000049XXX, "tax_type": "", "tax_name": "", "name": "One HD", "purchase_rate": 85, "tax_percentage": 0, "item_total": 85.00, "tax_id": "", "warehouse_id": 362212000000564XXX }] }

    • Zoho Projects API 100 requests/2 min. Limit

      Hi Requesting clarification on the API documentation. "You can invoke or call an API for 100 times in a span of two minutes. If you invoke more than 100 times, the particular API request will be locked for the next 30 minutes. " Does this limit apply

    • 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

    • Zoho Projects - Attachments added to Task and Bug emails are not saved

      Hi Projects team, I have been experimenting with emails into projects to create tasks and bugs. I have noticed that attachments added to the emails are not saved to the task or bug. Is this normal behaviour? Thanks, Ashley

    • Zoho Inventory's latest shipping integration updates at a glance.

      Hello Users, We would like to share some important news about our latest improvements in the Shipping integration capabilities of Zoho Inventory that we achieved in 2024 with some of our major integration partners in key editions across APAC, North America,

    • Sorting a list of record acquired from the zoho.crm.searchRecords function.

      This is something for which I'm trying to figure out a straightforward way to do. The searchRecords does a great job fetching me the records that I want. However, in some cases, where it returns multiple records, I want it to sort the returned list by date of creation of that record, so that when I do records.get(0), I get the most recent record.  As an example, here's my sample pseudo code: records = zoho.crm.searchRecords("Clients", "Office_Number:equals:123456"); Now the "records" list above contains

    • Zoho Inventory Custom Field Update

      Hello All, In this post I am describing how can we Update the Custom Field Value in Zoho Inventory. // Get Org ID orgid = organization.get("organization_id"); // Field Value resvp = ifnull(item.get("purchase_rate"),null); // Record ID iid = item.get("item_id");

    • Deprecation of the Zoho OAuth connector

      Hello everyone, At Zoho, we continuously evaluate our integrations to ensure they meet the highest standards of security, reliability, and compliance. As part of these ongoing efforts, we've made the decision to deprecate the Zoho OAuth default connector

    • Alphabetically

      How can i arrange alphabetically - (Manage Manufacturer) Field in Item Master 

    • Spotlight series #6: The Show app for Android TV has a new look!

      Hello everyone! We are delighted to introduce our revamped and redesigned Show app for Android TV.  Smart TVs are exploding in popularity. Android TV alone has over 110 million active monthly devices. Zoho Show, as part of a constant effort to improve

    • Can i set a default value for country and state in address field in zoho creator?

      Can i set a default value for country and state in address field in zoho creator?

    • Convert HTML to PDF & Send as Email Attachments in Zoho Creator (Deluge)

      This approach is useful for sending welcome letters, instructions, or promotional offers after order creation. // 1. Define the variables using the submitted input customerName = input.Customer_Name1; orderID = input.ID; customerEmail = input.Email_Address; //

    • Redirect after submission is not working after a few submission

      I have setup redirect url correctly and everything works as expected. However, it seems that there's a limit to the number of submissions before the redirect stops working. After the "limit" is reached, the page redirects to a seemingly zoho hosted page,

    • Enhancement Request for Multi-Asset Work Order Feature

      Hello Latha, Thank you for your continued support. The multi-asset Work Order feature is extremely helpful. I did some testing based on our requirements, and during the process, I noticed a few areas where we need your team’s support to improve the feature

    • Marketing Tip #8: Run limited-time offers

      Exclusive offers that don't last long make shoppers purchase right away instead of waiting. Run a flash sale or limited-time discount to convert interest into sales. Try this today: Set up a "Buy X Get Y" coupon in Zoho Commerce valid for a limited time

    • Add Option to Mass Dispatch by User

      Hello! We are using the dispatch console to dispatch service appointments to our service ressources. Right now, the process is our dispatcher verifies each ressource's route for the day and dispatches it after validation. Sadly, there doesn't seem to

    • Free webinar: Zoho Sign unwrapped – 2025 in review

      Hey there! 2025 is coming to an end, and this year has been all about AI. Join our exclusive year-end webinar, where we'll walk you through the features that went live in 2025, provide answers to your questions, and give you a sneak peek on what to expect

    • Zoho Projects - Email notification relabelling of modules not present on default templates

      Hi Projects Team, I noticed that in the default email template notification, the word "bug" was not renamed to the lable I am using in my system. As many users may used the Bugs modules for various purposes including Changes, Revisions, Issues, etc...

    • Publish to LinkedIn via API

      Hi, Is it possible to publish a job opening to LinkedIn (paid job slots) if creating a job opening via api / deluge function? Or is the user required to manually publish via the job boards process? Many Thanks Adrian

    • Include the "Added Email ID" to the Filters of a Report

      Hi, With a Report and lots of entries, a normal thing is to filter entries by the submitter, but that is not included in the Auto Filter of Reports and you can't add a custom filter to a Report without specifying the actual value. I would like to be able

    • Loops in Deluge

      Hi, Can someone tell me how I do a simple loop in deluge? For example, if i have a variable "X" containing a number of loops to perform, i would like to perform an action X amount of times. X = 10; do while (Y < X){       // ... do something } to further explain, the equivalent in PHP of what i am trying to acheive would be: $X = 20; for($Y = 1; $Y < $X; $Y++ ){       // ... do something } Thanks

    • I am facing a problem with an if-else condition

      If I use if, else if, and else conditions in Deluge with the same variable name, sometimes the variable causes an error because the same variable name is present in every block

    • Zoho Projects - Reply by email to @ mentions posted on the Feed.

      When mentioning someone on the Feed (Status), it would be great if that mentioned person could reply to the email notification to update the Feed thread.

    • Zoho Analytics Bulk Api Import json Data

      HI, I’m trying to bulk-update rows in Zoho Analytics, and below are the request and response details. I’d like to understand the required parameters for constructing a bulk API request to import or update data in a table using Deluge. Any guidance on

    • Record Overseas Transactions Along with CC charges

      Hi All, We receive payments via stripe in multiple currencies and stripe takes around 2.5% fees. The amount is settled in INR into our local bank. What should be the currency of the income account used for Stripe payments? Here is a sample flow that we

    • Product Updates in Zoho Workplace applications | October 2025

      Hello Workplace Community, Let’s take a look at the new features and enhancements that went live across all Workplace applications this October. Zoho Mail Create Signature from Compose window You can now effortlessly create a Signature using the Create

    • Subform data to Sheets

      I have been trying to setup a Zoho Flow automation to bring any Subform input to a Zoho Sheets but it seems impossible to post the subform entries to a Zoho Sheet. Is there any way to do it via Zoho Sheet API? https://www.zoho.com/sheet/help/api/v2/#CONTENT-Insert-row-with-JSON-data

    • Edit Contact Roles in the Potentials Mod

      New to ZOHO so I need some help. I work the same people on different projects concurrency. Their contact info remains the same but their role changes from project to project. In the Potential Mod you can pick contacts and assign a Role to them. I know

    • Is there a way to disable the Activity Reminders Pop-Up Window every time I log in?

      Just wondering if there is a setting to disable the window from opening every time I open my CRM? Thanks Chris

    • Auto-sync field of lookup value

      This feature has been requested many times in the discussion Field of Lookup Announcement and this post aims to track it separately. At the moment the value of a 'field of lookup' is a snapshot but once the parent lookup field is updated the values diverge.

    • Hide fields only for creation

      Hello, I'd like to hide some fields only during the creation of a contact in Zoho CRM. In fact I have some fields that are automatically calculated thanks to an automation, so when my users create a contact I don't want them to fill those fields. I know

    • Rich-text fields in Zoho CRM

      Hello everyone, We're thrilled to announce an important enhancement that will significantly enhance the readability and formatting capabilities of your information: rich text options for multi-line fields. With this update, you can now enjoy a more versatile

    • Next Page