Inventory Inquiry Device, Inventory Inquiry Method, and Inventory Inquiry Program

The inventory inquiry device secures inventory data access by associating user roles with permitted targets, addressing unauthorized access and improving inventory management efficiency.

JP7701308B2Active Publication Date: 2025-07-01OBIC CO LTD
View PDF 4 Cites 0 Cited by

Patent Information

Application Number
JP2022081471
Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
Filing Date
2022-05-18
Publication Date
2025-07-01
Estimated Expiration
2042-05-18

AI Technical Summary

Technical Problem

Existing inventory management systems lack security measures to prevent unauthorized access to inventory data, particularly in scenarios where inventory data of one party is not queryable to unrelated parties.

Method used

An inventory inquiry device that associates user identification information with permitted inventory inquiry targets, allowing secure display and acquisition of inventory data based on user roles, distinguishing between manufacturer-managed and sales agency-managed inventories.

Benefits of technology

Ensures secure inventory inquiries by limiting access to authorized users, enhancing data privacy and enabling efficient inventory management across multiple entities.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007701308000001
    Figure 0007701308000001
  • Figure 0007701308000002
    Figure 0007701308000002
  • Figure 0007701308000003
    Figure 0007701308000003
Patent Text Reader

Abstract

To enable inventory inquiring in which security is ensured.SOLUTION: A security display control unit detects an inventory inquiring object user associated with inputted user identification information to display the user on a display unit, from a storage unit in which the inventory inquiring object users of an inventory for which inventory inquiring is permitted are stored in association with each other, respectively, for each user identification information of each user. An acquisition unit acquires inventory data of the detected inventory inquiring object user from an inventory database. A display control unit displays the acquired inventory data on the display unit. Thereby, each user can perform the inventory inquiring in which security is ensured, because inquiring of the inventory data other than the inventory data of previously associated inventory inquiring object user is not obtained.SELECTED DRAWING: Figure 4
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to an inventory inquiry device, an inventory inquiry method, and an inventory inquiry program.

Background Art

[0002] Today, in many cases, a sales form is adopted in which while selling products, the products stored in a warehouse are replenished to a store according to the number of products sold at the store. Therefore, inventory management of products is important for smooth sales of products.

[0003] As a prior art related to inventory management, Patent Document 1 (Japanese Patent Application Laid-Open No. 2003-150856) discloses a product inventory inquiry system. This product inventory inquiry system includes a product inventory information database that accumulates the inventory quantity of products for each business office in association with product identification information for identifying products. The product etc. designation means designates the product and quantity desired by the user from among the product identification information. The host computer for inventory inquiry extracts the inventory quantity associated with the product identification information from the product inventory information database based on the product identification information designated by the product etc. designation means, determines whether there is inventory equal to or more than the designated product quantity, and displays the result.

[0004] The product etc. designation means has a user computer connected to a public communication line available to the public, and inputs the product identification information and product quantity transmitted by the user computer via the public communication line to the host computer for inventory inquiry. The product etc. designation means displays the determination result of the host computer for inventory inquiry on the user computer. Thereby, a highly convenient product inventory inquiry system can be provided for both the user and the manufacturer.

Prior Art Documents

Patent Documents

[0005]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0006] Here, in performing inventory management, for example, making the inventory of one queried party queryable to another unrelated queried party is not preferable in terms of security.

[0007] The present invention has been made in view of the above problems, and an object thereof is to provide an inventory inquiry device, an inventory inquiry method, and an inventory inquiry program that enable inventory inquiries while ensuring security.

Means for Solving the Problems

[0008] In order to solve the above problems and achieve the object, an inventory inquiry device according to the present invention includes a security display control unit that detects, from a storage unit in which inventory inquiry target users who are permitted to make inventory inquiries are respectively associated and stored for each user identification information of each user, an inventory inquiry target user associated with the input user identification information and displays it on a display unit, an acquisition unit that acquires inventory data of the detected inventory inquiry target user from an inventory database, and a display control unit that displays the acquired inventory data on the display unit It has [specific elements not provided in the text]. In the inventory database, at least the inventory quantity of the product for which an inventory inquiry is made, the asset company that is the target user of the inventory inquiry, and the seller of the product are respectively associated and stored. Among the inventories of the products for which the sales agency is the sales manager, some inventories are managed by the manufacturer, and the remaining inventories are managed by the sales agency. When the detected inventory inquiry target user is the asset company that is the manufacturer of the product, the acquisition unit acquires the inventory data of all asset companies stored in the inventory database. When the detected inventory inquiry target user is the asset company that is the sales agency of the product, as the inventory data for which the detected inventory inquiry target user is the seller, the acquisition unit acquires the inventory data of the inventories managed by the manufacturer and the inventory data of the inventories managed by the sales agency from the inventory database.

[0009] Also, in order to solve the above problems and achieve the object, an inventory inquiry method according to the present invention includes a security display control step in which a security display control unit detects, from a storage unit in which inventory inquiry target users who are permitted to make inventory inquiries are respectively associated and stored for each user identification information of each user, an inventory inquiry target user associated with the input user identification information and displays it on a display unit, an acquisition step in which an acquisition unit acquires inventory data of the detected inventory inquiry target user from an inventory database, and a display control step in which a display control unit displays the acquired inventory data on the display unit It has [specific elements not provided in the text]. In the inventory database, at least the inventory quantity of the product for which an inventory inquiry is made, the asset company that is the target user of the inventory inquiry, and the seller of the product are respectively associated and stored. Among the inventories of the products for which the sales agency is the sales manager, some inventories are managed by the manufacturer, and the remaining inventories are managed by the sales agency. In the acquisition step, when the detected inventory inquiry target user is the asset company that is the manufacturer of the product, the acquisition unit acquires the inventory data of all asset companies stored in the inventory database. When the detected inventory inquiry target user is the asset company that is the sales agency of the product, as the inventory data for which the detected inventory inquiry target user is the seller, the acquisition unit acquires the inventory data of the inventories managed by the manufacturer and the inventory data of the inventories managed by the sales agency from the inventory database. .

[0010] Also, in order to solve the above-described problems and achieve the object, the inventory inquiry program according to the present invention causes a computer to detect, from a storage unit in which inventory inquiry target users who are permitted to inquire about inventory are respectively associated and stored for each user identification information of each user, an inventory inquiry target user associated with the input user identification information and display it on a display unit, an acquisition unit that acquires inventory data of the detected inventory inquiry target user from an inventory database, and a display control unit that displays the acquired inventory data on the display unit Function, and in the inventory database, at least the inventory quantity of the product for which inventory inquiry is made, the asset company that is the inventory inquiry target user, and the seller of the product are associated and stored respectively. Among the inventories of the products for which the sales agency is the sales manager, some inventories are managed by the manufacturer, and the remaining inventories are managed by the sales agency. When the detected inventory inquiry target user is the asset company that is the manufacturer of the product, the acquisition unit acquires the inventory data of all asset companies stored in the inventory database. When the detected inventory inquiry target user is the asset company that is the sales agency of the product, as the inventory data for which the detected inventory inquiry target user is the seller, the inventory data of the inventories managed by the manufacturer and the inventory data of the inventories managed by the sales agency are acquired from the inventory database. 。

Effect of the Invention

[0011] The present invention can perform an inventory inquiry while ensuring security.

Brief Description of the Drawings

[0012]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Figure 13

Figure 14

Figure 15

Figure 16

Figure 17

Figure 18

Figure 19

Embodiments for Carrying Out the Invention

[0013] Hereinafter, an inventory inquiry device according to an embodiment to which the present invention is applied will be described in detail with reference to the drawings. This embodiment is an example in which the present invention is applied to an inventory inquiry device for inquiring about the inventory of products such as toilet paper produced by a manufacturer engaged in the paper manufacturing industry. Note that the present invention is not limited to such an embodiment.

[0014] First, FIG. 1 is a system configuration diagram of an inventory inquiry system including an inventory inquiry device 1 according to an embodiment. As shown in this FIG. 1, the inventory inquiry system is configured by connecting an inventory inquiry device 1 according to the embodiment, one or more manufacturer terminal devices 50 of a product manufacturer, and one or more distributor terminal devices 60 of a product distributor to each other via a network 8. As the network 8, a wide area network such as the Internet or a private network such as a LAN (Local Area Network) can be used.

[0015] Here, in the paper industry, there is an industry culture in which the manufacturer side has the responsibility for inventory of products until the products are sold. For example, as shown in FIG. 1, when there are a plurality of distributors such as Distributor A and Distributor B for one manufacturer, the manufacturer side needs to manage the inventory of the same product and the same lot managed on the manufacturer side separately for each distributor with the right to sell. For this reason, the manufacturer terminal device 50 includes an inventory database (inventory DB) 51 in which inventory data of the inventory on the manufacturer side of the product and inventory data of a part of the inventory of each of Distributors A and B managed on the manufacturer side are stored.

[0016] Further, the distributor terminal device 60A of Distributor A includes an inventory DB 61A in which inventory data of the inventory of Distributor A (inventory data of the inventory of Distributor A other than the inventory of Distributor A managed on the manufacturer side) is stored, and the distributor terminal device 60B of Distributor B includes an inventory DB 61B in which inventory data of the inventory of Distributor B (inventory data of the inventory of Distributor B other than the inventory of Distributor B managed on the manufacturer side) is stored.

[0017] The inventory inquiry device 1 operates based on an inventory inquiry program to acquire inventory data from each of the inventory DBs 51, 61A, and 61B of the manufacturer terminal device 50, the distributor terminal device 60A, and the distributor terminal device 60B, respectively, and perform an inventory inquiry.

[0018] As for the timing of acquiring inventory data, it may be acquired each time an inventory inquiry request is made, or the inventory data acquired from each inventory DBs 51, 61A, and 61B periodically or irregularly may be stored in the storage unit (storage unit 2 in FIG. 2) of the inventory inquiry device 1, and the inventory inquiry may be performed based on the inventory data stored in this storage unit. In the following description, it is assumed that the inventory data has been acquired in advance from each inventory DBs 51, 61A, and 61B and stored in the storage unit for the purpose of explanation.

[0019] (Hardware Configuration of Inventory Inquiry Device) Next, FIG. 2 is a block diagram showing the hardware configuration of the inventory inquiry device 1 according to the embodiment. The inventory inquiry device 1 shown in FIG. 2 includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5. An input device 6 and an output device 7 are connected to the input / output interface unit 5.

[0020] As the output device 7, a display unit such as a monitor device (including a home television) can be used. As the input device 6, in addition to a keyboard device, a mouse device, and a microphone device, a monitor device that realizes a pointing device function in cooperation with the mouse device can also be used. The communication interface unit 4 is connected to the manufacturer terminal device 50 and the agency terminal devices 60 of each agency A and B via the network 8.

[0021] As the storage unit 2, for example, a storage device such as a ROM (Read Only Memory), a RAM (Random Access Memory), an HDD (Hard Disk Drive), or an SSD (Solid State Drive) can be used. In the storage unit 2, a login security master 11 and an inventory display target master 12, which are storage areas, are provided.

[0022] Also, the inventory data 13 acquired in advance from the inventory DBs 51, 61A, and 61B of the manufacturer terminal device 50, the agency terminal device 60A, and the agency terminal device 60B is stored in the storage unit 2 periodically or irregularly.

[0023] In addition, the storage unit 2 stores an inventory inquiry program that enables inventory inquiries for the manufacturer terminal device 50, the distributor terminal device 60A, and the distributor terminal device 60B. In this example, the inventory inquiry program is stored on the inventory inquiry device 1 side, and the control unit 3 of the inventory inquiry device 1 will be described as executing it. However, as shown by the dotted block in FIG. 1, an inventory inquiry program may be provided in a predetermined server device 9 and executed as a so-called Web (World Wide Web) application program. Even in this case, the operation and effect are the same as described below.

[0024] In addition, the storage unit 2 stores production result data indicating the production quantity of products, which is input based on the queried inventory data, and purchase data indicating the purchase quantity of products purchased by the distributor from the manufacturer side. The storage unit 2 also stores transfer data indicating the number of products transferred between distributors and movement data indicating the number of products moved between distributors. The storage unit 2 also stores sales data of the manufacturer and the distributor based on order sales input, purchase data of the distributor, and the like.

[0025] FIG. 3 is a diagram showing an example of the login security master 11. As shown in this FIG. 3, the login security master 11 includes "selectable companies" and "user identification information (user ID)". The "selectable companies" include manufacturer codes such as "001" and manufacturer names, and distributor codes and distributor names such as "002" and "003". In this example, "001" is the manufacturer code of the manufacturer, and "002" is the distributor code of Distributor A. Also, "003" is the distributor code of Distributor B.

[0026] As user IDs, the user IDs of users who can inquire about the manufacturer's inventory, the user IDs of users who can inquire about the inventory of Agency A, and the user IDs of users who can inquire about the inventory of Agency B are registered (stored). In the example of Fig. 3, the user ID "00001" is registered as the user ID of a user who can inquire about the inventory of all asset companies, namely the manufacturer, Agency A, and Agency B. The user with the user ID "00001" is, for example, the user ID of the "administrator" of the inventory inquiry system.

[0027] Also, in the example of Fig. 3, the user ID "00101" is registered as the user ID of a user who can inquire about the manufacturer's inventory. The user with the user ID "00101" is the user ID of a user belonging to the manufacturer. Also, in the example of Fig. 3, the user ID "00201" is registered as the user ID of a user who can inquire about the inventory of Agency A. The user with the user ID "00201" is the user ID of a user belonging to Agency A. Also, in the example of Fig. 3, the user ID "00301" is registered as the user ID of a user who can inquire about the inventory of Agency B. The user with the user ID "00301" is the user ID of a user belonging to Agency B.

[0028] The inventory inquiry device 1 of the embodiment thus associates and registers with the login security master 11 the asset companies (manufacturer, Agency A, and Agency B) for which inventory inquiries are possible and the user IDs of users for which inventory inquiries are possible. Then, based on the user ID input at the time of inquiry, the login security master 11 is referred to, and an inventory inquiry for which the input user ID is permitted is performed. As a result, only the inventory permitted for that user can be inquired about, and secure inventory inquiries can be enabled.

[0029] (Functional Configuration of Inventory Inquiry Device) Next, the control unit 3 functions as a security display control unit 21, an acquisition unit 22, a display control unit 23, a data generation unit 24, and a communication control unit 25 by executing the inventory inquiry program stored in the storage unit 2.

[0030] The security display control unit 21 detects an asset company (manufacturer, agency A, and agency B: an example of an inventory inquiry target user) associated with the input user ID and displays it on the output device 7 (an example of a display unit). The acquisition unit 22 acquires the inventory data of the detected asset company from the inventory databases 51, 61A, and 61B. In this example, the inventory data of each of the inventory databases 51, 61A, and 61B is acquired in advance and stored in the storage unit 2 of the inventory inquiry device 1 (inventory data 13). Therefore, the acquisition unit 22 acquires the inventory data 13 of the detected asset company from the storage unit 2. The display control unit 23 displays the acquired inventory data 13 on the output device 7.

[0031] As will be described later, at least the inventory quantity of the product for which inventory inquiry is to be made, the asset company, and the seller of the product are associated and stored in each of the inventory databases 51, 61A, and 61B. Also, as described above, in the paper manufacturing industry where inventory inquiry of products is performed by the inventory inquiry device 1, there is an industry culture in which the manufacturer side has the responsibility for product inventory until the product is sold. For example, when there are agency A and agency B for one manufacturer, the manufacturer side needs to classify and manage the inventory managed by the manufacturer side for each agency with the right to sell. Therefore, on the manufacturer side, in addition to the manufacturer's own inventory, the inventory of each agency A and B is also classified and managed. The remaining inventory of each agency other than the inventory managed by the manufacturer side is managed by each agency side as the inventory of each agency. Also, in each of the inventory databases 51, 61A, and 61B, the inventory quantity of products, etc. is stored for each base such as the Kanto branch of agency A and the Kansai branch of agency B.

[0032] When the detected asset company is the asset company (= manufacturer) that is the product manufacturer, the acquisition unit 22 acquires the inventory data 13 of all asset companies acquired from all the inventory databases 51, 61A, and 61B from the storage unit 2. In this case, the display control unit 23 displays the inventory data 13 of all asset companies on the output device 7 for inquiry.

[0033] In addition, when the detected asset company is an asset company that becomes a sales agent for products (Agent A or Agent B), the inventory data 13 in which the detected asset company is the seller is acquired from each inventory database 51, 61A, 61B (or the storage unit 2). In other words, the acquisition unit 22 acquires the inventory data 13 in which the detected asset company is the seller and which is managed by the manufacturer side, and the inventory data 13 in which the detected asset company is the seller and which is managed by the agent side, from each inventory database 51, 61A, 61B or the storage unit 2. The display control unit 23 displays the inventory data 13 in which the detected asset company is the seller on the output device 7 for inquiry.

[0034] The data generation unit 24 generates transfer data, movement data, sales data, etc. which will be described later, and stores them in the storage unit 2. The communication control unit 25 controls the communication interface unit 4 to communicate with the manufacturer terminal device 50, the agent terminal device 60A, and the agent terminal device 60B at a predetermined timing, acquires the inventory data 13 from each inventory DB 51, 61A, 61B respectively, and stores them in the storage unit 2.

[0035] (Inventory Inquiry Operation) Next, the inventory inquiry operation in the inventory inquiry device 1 of the embodiment will be described using the flowchart of FIG. 4. The control unit 3 operates based on the inventory inquiry program stored in FIG. 2 to execute each process of the flowchart of FIG. 4. This flowchart starts when the user ID and password are input on the login screen illustrated in FIG. 5(a) etc. In step S1, the security display control unit 21 refers to an authentication database (not shown) in which the user ID and password of a regular user are associated and stored, based on the input user ID and password, and performs user authentication processing.

[0036] When it is authenticated that the user is a regular user, the process proceeds to step S2, and the security display control unit 21 refers to the login security master 11 shown in FIG. 3, detects and displays the asset companies associated with the input user ID. The example in FIG. 5 is an example where the administrator of the inventory inquiry system with the user ID "00001" logs in. In this case, the security display control unit 21 refers to the login security master 11 shown in FIG. 5(c) to detect the asset companies of "Manufacturer", "Agency A", and "Agency B" associated with the user ID of "00001". The security display control unit 21 displays the detected asset companies of "Manufacturer", "Agency A", and "Agency B" on the login company selection screen as shown in FIG. 5(b).

[0037] The example in FIG. 6 is an example where a user belonging to a manufacturer with the user ID "00101" logs in. In this case, the security display control unit 21 refers to the login security master 11 shown in FIG. 6(c) to detect the asset company of "Manufacturer" associated with the user ID of "00101". The security display control unit 21 displays the detected asset company of "Manufacturer" on the login company selection screen as shown in FIG. 6(b).

[0038] The example in FIG. 7 is an example where a user belonging to Agency A with the user ID "00201" logs in. In this case, the security display control unit 21 refers to the login security master 11 shown in FIG. 7(c) to detect the asset company of "Agency A" associated with the user ID of "00201". The security display control unit 21 displays the detected asset company of "Agency A" on the login company selection screen as shown in FIG. 7(b).

[0039] The example in Fig. 8 is an example where a user belonging to Agency B with a user ID of "00301" logs in. In this case, the security display control unit 21 refers to the login security master 11 shown in Fig. 8(c) to detect the asset company of "Agency B" associated with the user ID of "00301". The security display control unit 21 displays the detected asset company of "Agency B" on the login company selection screen as shown in Fig. 8(b).

[0040] Next, the acquisition unit 22 determines whether the asset company detected based on the user ID is an asset company corresponding to the administrator or the manufacturer (step S3). If the asset company detected based on the user ID is an asset company corresponding to the administrator or the manufacturer (step S3: Yes), as described with reference to Figs. 5 and 6, it is possible to inquire about the inventory data 13 of all the inventories of the manufacturer and all agencies.

[0041] Therefore, in step S4, the acquisition unit 22 acquires the inventory data 13 of the manufacturer, the inventory data 13 of Agency A and Agency B managed by the manufacturer side, the inventory data 13 of Agency A managed by Agency A side, and the inventory data 13 of Agency B managed by Agency B side. The display control unit 23 displays the acquired inventory data 13 in a list on the manufacturer - agency inventory sharing screen as shown in Fig. 9.

[0042] The example in Fig. 9 is a diagram showing an example of the manufacturer - agency inventory sharing screen displayed when logging in with the user ID of the manufacturer. In this case, the display control unit 23 displays each asset company of "manufacturer", "Agency A" and "Agency B" detected as an asset company capable of inquiring about the inventory data 13 as exemplified in Fig. 9.

[0043] Incidentally, as will be described later, when Agency A is detected as an asset company capable of inquiring about the inventory data 13, the display control unit 23 displays, on the manufacturer-agent inventory sharing screen as the asset company, "Manufacturer", which means that the inventory data 13 of Agency A managed by the manufacturer side can be inquired, and "Agency A", which means that the inventory data 13 of Agency A managed by Agency A side can be inquired ( "Agency B" is not displayed as the asset company).

[0044] In addition, the display control unit 23 displays on the manufacturer-agent inventory sharing screen the acquired inventory data 13 according to the output classification indicating whether to display it "by product and lot number" or "by product", the warehouse code and name of the warehouse where the product is managed, the product number and name of the product, the asset company having the sales right of the product, and the lot number, etc.

[0045] Also, in this example, the login is performed using the user ID of the "Manufacturer". The acquisition unit 22 refers to the inventory display target master 12 shown in FIG. 10 to identify the asset companies of "Manufacturer", "Agency A", and "Agency B" as the asset companies capable of inquiring about the inventory data 13 using the user ID of the "Manufacturer". Then, as shown in FIG. 11, the acquisition unit 22 acquires the inventory data 13 of the identified asset companies of "Manufacturer", "Agency A", and "Agency B" from the inventory data 13 stored in the storage unit 2. In this case, all the inventory data 13 shown in FIG. 11 is acquired.

[0046] The display control unit 23 displays the acquired inventory data 13 in a list on the manufacturer-agent inventory sharing screen as shown in FIG. 9. As a result, by logging in with the user ID of the "Manufacturer", it is possible to inquire about the inventory on the manufacturer side managed by the manufacturer, the inventories of Agency A and Agency B managed by the manufacturer side, the inventory of Agency A managed by Agency A, and the inventory of Agency B managed by Agency B.

[0047] On the other hand, in step S3 of the flowchart in FIG. 4, when the asset company detected based on the user ID is determined to be the agent's asset company (step S3: No), as described with reference to FIGS. 7 and 8, it is possible to inquire about the inventory data 13 of the inventory of the agent managed by the manufacturer side and the inventory of the agent managed by the agent side. Therefore, in step S6, the acquisition unit 22 acquires the inventory data 13 of the inventory of the agent managed by the manufacturer side and the inventory data 13 of the inventory of the agent managed by the agent side. The display control unit 23 displays the acquired inventory data 13 in a list on the manufacturer-agent inventory sharing screen as shown in FIG. 12.

[0048] The example of FIG. 12 is a diagram showing an example of the manufacturer-agent inventory sharing screen displayed when logging in with the user ID of agent A. In this case, as illustrated in FIG. 12, the display control unit 23 displays "Manufacturer", which means that it is possible to inquire about the inventory data of agent A managed by the manufacturer side, and "Agent A", which means that it is possible to inquire about the inventory data of agent A managed by agent A side, on the manufacturer-agent inventory sharing screen as the asset company ( "Agent B" is not displayed as the asset company).

[0049] In addition, the display control unit 23 displays on the manufacturer-agent inventory sharing screen the output classification as "by product and lot number" or "by product", the warehouse code and name of the warehouse where the product is managed, the product number and name of the product, the asset company having the sales right of the product, the lot number, etc.

[0050] Also, in this example, logging in is performed with the user ID of "Agent A". By referring to the inventory display target master 12 shown in FIG. 13, the acquisition unit 22 identifies the inventory data 13 that can be inquired with the user ID of "Agent A", including the inventory data 13 of the inventory managed by the manufacturer side and having the sales right of the Kanto branch of Agent A, the inventory data 13 of the inventory managed by the manufacturer side and having the sales right of the Kansai branch of Agent A, and the inventory data 13 of the inventory of the Kanto branch and Kansai branch of Agent A managed by Agent A.

[0051] Then, as shown in FIG. 14, the acquisition unit 22 acquires the inventory data 13 of the inventory managed by the manufacturer side and held by the Kanto branch of Agency A, the inventory data 13 of the inventory managed by the manufacturer side and held by the Kansai branch of Agency A, and the inventory data 13 of the inventory of the Kanto and Kansai branches of Agency A managed by Agency A, among the inventory data 13 stored in the storage unit 2. The display control unit 23 displays the acquired inventory data 13 in a list on the manufacturer-agent inventory sharing screen as shown in FIG. 12.

[0052] As a result, by logging in with the user ID of "Agency A", it is possible to inquire about the inventory held by the Kanto branch of Agency A, which is managed by the manufacturer side and has the sales right, the inventory held by the Kansai branch of Agency A, which is managed by the manufacturer side and has the sales right, and the inventory of the Kanto and Kansai branches of Agency A managed by Agency A.

[0053] As described above, in the inventory inquiry device 1 of the embodiment, each user can inquire only about the inventory data of the asset company associated in advance. Thereby, it is possible to enable an inventory inquiry with security ensured.

[0054] (Production result input) Next, by inputting the production results of the product, it is possible to add the products of the desired production quantity to the inventory quantity for the desired asset company. FIG. 15(a) shows an example in which 100 production results are input by designating the Kanto branch of Agency A on the production input screen. In this case, as shown in FIG. 15(b), the data generation unit 24 updates the inventory quantity of the inventory data of the Kanto branch of Agency A managed by the manufacturer side to 100.

[0055] (Purchase input) Next, Fig. 16(a) shows a purchase input screen that is displayed when performing purchase input on the agency terminal device 60A of the Kanto branch of Agency A. The example in Fig. 16(a) is an example of purchase input when 100 purchases are made from the manufacturer side. In this case, the data generation unit of the agency terminal device 60A of the Kanto branch of Agency A generates inventory data with the asset company set as "Agency A" and the sales right set as "Agency A Kanto" as shown in Fig. 16(b), and inputs 100, which is the number of purchases of the product made from the manufacturer side, into the inventory quantity of this inventory data.

[0056] (Inventory transfer input) Next, Fig. 17(a) shows an example of an inventory transfer input screen for specifying that 30 items are to be transferred from the inventory of the Kanto branch of Agency A managed by the manufacturer side to the inventory of the Kansai branch of Agency A managed by the manufacturer side in the inventory inquiry device 1 of the embodiment. In this case, the data generation unit 24 of the inventory inquiry device 1 generates transfer data with the inventory quantity (transfer quantity) of the Kanto branch of Agency A set as "-30 items" and the inventory quantity (transfer quantity) of the Kansai branch of Agency A set as "+30 items" as shown in Fig. 17(b).

[0057] Also, as shown in Fig. 17(c), the data generation unit 24 updates the inventory quantity of the Kanto branch of Agency A, which was "100 items" before the transfer input, to "70 items (100 items - 30 items)" as shown in Fig. 17(d), and updates the inventory quantity of the Kansai branch of Agency A to "30 items".

[0058] (Inventory movement input) Next, Fig. 18(a) shows an example of an inventory movement input screen for specifying that 30 items are to be moved from the inventory of the Kanto branch of Agency A managed by the manufacturer side to the inventory of the Kansai branch of Agency A managed by the manufacturer side in the inventory inquiry device 1 of the embodiment. In this case, the data generation unit 24 of the inventory inquiry device 1 generates movement data with the inventory quantity (transfer quantity) of the Kanto branch of Agency A set as "-30 items" and the inventory quantity (transfer quantity) of the Kansai branch of Agency A set as "+30 items" as shown in Fig. 18(b).

[0059] In addition, as shown in FIG. 18(c), before the movement input, the data generation unit 24 updates the inventory quantity of the Kanto branch of Agency A, which was "100 pieces", to "70 pieces (100 pieces - 30 pieces)" as shown in FIG. 18(d), and updates the inventory quantity of the Kansai branch of Agency A to "30 pieces".

[0060] (Order / Sales Input) Next, FIG. 19(a) shows an example of an order / sales input screen input when the inventory inquiry device 1 of the embodiment places an order for 30 products from the manufacturer to the Kanto branch of Agency A and records the sales. In this case, the data generation unit 24 of the inventory inquiry device 1 generates sales data with the number of sales to the Kanto branch of Agency A being "30 pieces" as shown in FIG. 19(b).

[0061] In addition, the data generation unit of the agency terminal device 60A of the Kanto branch of Agency A that has made purchases generates purchase data with the supplier being the "manufacturer", the sales right being "Agency A Kanto", and the purchase quantity being "30 pieces" as shown in FIG. 19(c), and generates sales data with the sales right being "Agency A Kanto" and the number of sales being "30 pieces" as shown in FIG. 19(d).

[0062] Then, as shown in FIG. 19(e), before the sales input, the data generation unit 24 of the inventory inquiry device 1 updates the inventory quantity of the Kanto branch of Agency A, which was "100 pieces", to "70 pieces (100 pieces - 30 pieces)" as shown in FIG. 19(f).

[0063] (Effects of the Embodiment) As is clear from the above description, in the inventory inquiry device 1 of the embodiment, each user cannot inquire about inventory data other than the inventory data of the asset company associated in advance, so it is possible to ensure security for inventory inquiries.

[0064] Here, in the paper manufacturing industry, there is an industry culture where the manufacturer is responsible for the inventory of products until they are sold. For example, when there are multiple distributors for one manufacturer, the manufacturer needs to manage the inventory of the same product and the same lot under its management separately for each distributor with the right to sell. Such inventory management by the manufacturer for each distributor is cumbersome.

[0065] However, in the case of the inventory inquiry device 1 of the embodiment, the following various types of information are attached to the inventory for inventory management.

[0066] 1. Information indicating which company's assets the inventory belongs to among the manufacturer and each distributor (asset company) 2. Information indicating the inventory quantity in each warehouse (inventory quantity) 3. Information indicating the right holder having the right to sell for each inventory (right to sell) 4. Information indicating the right to sell for each base of distributors such as Distributor A Kanto and Distributor A Kansai

[0067] Thereby, based on the asset company, the inventory quantity, and the right to sell, each inventory can be clearly and simply classified and managed.

[0068] Also, on the distributor side, since it was difficult to share the inventory in real time, it was necessary to inquire with the manufacturer side about the inventory quantity with the right to sell by itself each time. For this reason, due to the complication and delay of the sales plan and shipping arrangements, there was a disadvantage of losing the sales opportunity of the product. Also, there was a problem that the products were not sold as planned at each distributor and defective inventory occurred.

[0069] However, the inventory inquiry device 1 of the embodiment manages each inventory based on the asset company, the inventory quantity, and the right to sell, enabling reference sharing. For this reason, unified management of the inventory can be performed on the manufacturer side and the distributor side. That is, the manufacturer side can refer to the inventory managed by the manufacturer side and the inventory of each distributor, and the distributor side can refer to the inventory managed by the manufacturer side with the right to sell to itself and its own inventory.

[0070] As a result, on the manufacturer side, it is possible to manage in real time which distributor has the right to sell with respect to the inventory of its own assets. For this reason, the burden of responding to inventory inquiries from distributors can be reduced, and business efficiency and inventory turnover can be improved by smoothly grasping the inventory.

[0071] On the other hand, on the distributor side, it is possible to easily and real-time confirm the inventory for which the distributor has the right to sell, which is managed by the manufacturer side. For this reason, the labor of inquiring about its own inventory to the manufacturer can be reduced. In addition, simplification and speed-up of the sales plan and shipping arrangements can be achieved, and the inconvenience of losing the sales opportunity of the product due to a response delay of the inventory from the manufacturer side can be prevented. In addition, smooth sales of products can be enabled at each distributor, and the inconvenience of generating defective inventory can also be prevented.

[0072] [Contribution to the Sustainable Development Goals (SDGs) led by the United Nations] According to the present embodiment, since it can contribute to promoting business efficiency and appropriate business judgment of the enterprise, it is possible to contribute to Goal 8 and Goal 9 of the SDGs.

[0073] In addition, according to the present embodiment, since it can contribute to reducing waste loss and promoting paperless and digitization, it is possible to contribute to Goal 12, Goal 13, and Goal 15 of the SDGs.

[0074] In addition, according to the present embodiment, since it can contribute to strengthening control and governance, it is possible to contribute to Goal 16 of the SDGs.

[0075] [Other Embodiments] The present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims, in addition to the above-described embodiments.

[0076] For example, among the various processes described in the embodiments, all or part of the processes described as being automatically performed can also be manually performed, or all or part of the processes described as being manually performed can be automatically performed by a known method.

[0077] In addition, regarding the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and the drawings, they can be arbitrarily changed unless otherwise specified.

[0078] Regarding the inventory inquiry device 1, each of the illustrated components is a functional concept and does not necessarily need to be physically configured as shown in the drawings.

[0079] For example, regarding the processing functions provided by the inventory inquiry device 1, particularly each processing function performed by the control unit 3 and the control unit 3, all or any part of them may be realized by a CPU (Central Processing Unit) and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. The program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing an information processing device to execute the processes described in this embodiment, and is mechanically read by the inventory inquiry device 1 as necessary. That is, in a storage unit such as a ROM or HDD, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM and constitutes the control unit 3 in cooperation with the CPU.

[0080] In addition, the inventory inquiry program of this inventory inquiry device 1 may be stored in another server device connected to the inventory inquiry device 1 via an arbitrary network, and all or part of it can be downloaded as necessary.

[0081] In addition, an inventory inquiry program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" includes any "portable physical medium" such as a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical Disk), a DVD (Digital Versatile Disk), and a Blu-ray (registered trademark) Disc.

[0082] Also, the "program" is a data processing method described in any language or description method, and is not limited to a specific form such as source code or binary code. Note that the "program" is not necessarily limited to a single configuration, and includes those that are distributed as a plurality of modules or libraries, or those that achieve their functions in cooperation with other separate programs represented by an OS. Regarding the specific configuration, reading procedure, and installation procedure after reading for reading the recording medium in the inventory inquiry device 1 shown in the embodiment, well-known configurations and procedures can be used.

[0083] The storage unit 2 is a storage means such as a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk, and stores various programs, tables, databases, and web page files used for various processes and website provision.

[0084] Further, the inventory inquiry device 1 may be configured by an information processing device such as a known personal computer device or workstation, or may be configured by an information processing device to which an arbitrary peripheral device is connected. Further, the information processing device may be realized by implementing software (including programs or data, etc.) that realizes the processing described in the present embodiment.

[0085] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in arbitrary units according to various additions or function additions. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Industrial Applicability

[0086] The present invention is applicable to any industry as long as it is an industry that conducts inventory inquiries of product inventories, such as the paper manufacturing industry.

Explanation of Signs

[0087] 1 Inventory inquiry device 2 Storage unit 3 Control unit 4 Communication interface unit 5 Input / output interface unit 6 Input device 7 Output device 8 Network 9 Server device 11 Login security master 12 Inventory display target master 13 Inventory data 21 Security display control unit 22 Acquisition unit 23 Display control unit 24 Data generation unit 25 Communication control unit 50 Manufacturer terminal device 60 Agency terminal device

Claims

1. A security display control unit that detects, from a storage unit in which inventory inquiry target users of inventory for which inventory inquiry is permitted are associated and stored for each user identification information of each user, an inventory inquiry target user associated with the input user identification information and displays it on a display unit; An acquisition unit that acquires inventory data of the detected inventory inquiry target user from an inventory database; A display control unit that displays the acquired inventory data on the display unit, and has, In the inventory database, at least the inventory quantity of the product for which inventory inquiry is made, the asset company that is the inventory inquiry target user, and the seller of the product are associated and stored, Among the inventories of products for which the sales agency is the sales manager, some inventories are managed by the manufacturer, and the remaining inventories are managed by the sales agency, When the detected inventory inquiry target user is the asset company that is the manufacturer of the product, the acquisition unit acquires the inventory data of all asset companies stored in the inventory database, and when the detected inventory inquiry target user is the asset company that is the sales agency of the product, as the inventory data for which the detected inventory inquiry target user is the seller, the inventory data of the inventory managed by the manufacturer and the inventory data of the inventory managed by the sales agency are acquired from the inventory database, An inventory inquiry device characterized by the above.

2. In the inventory database, the inventory quantity of the product is stored for each base of the sales agency, The inventory inquiry device according to claim 1, characterized by the above.

3. A security display control step in which a security display control unit detects, from a storage unit in which inventory inquiry target users of inventory for which inventory inquiry is permitted are associated and stored for each user identification information of each user, an inventory inquiry target user associated with the input user identification information and displays it on a display unit; An acquisition step in which an acquisition unit acquires inventory data of the detected inventory inquiry target user from an inventory database; A display control step in which a display control unit displays the acquired inventory data on the display unit, and has, In the inventory database, at least the inventory quantity of the product for which inventory inquiry is made, the asset company that is the inventory inquiry target user, and the seller of the product are associated and stored, Among the inventories of the products for which the sales agent is the sales manager, some inventories are managed by the manufacturer, and the remaining inventories are managed by the said sales agent. In the said acquisition step, when the detected inventory inquiry target user is the asset company that is the manufacturer of the said product, acquire the inventory data of all asset companies stored in the said inventory database; when the detected inventory inquiry target user is the asset company that is the sales agent of the said product, as the inventory data for which the detected inventory inquiry target user is the said sales rights holder, acquire from the said inventory database the inventory data of the inventories managed by the manufacturer and the inventory data of the inventories managed by the said sales agent. An inventory inquiry method characterized by the above.

4. A computer, For each user identification information of each user, a security display control unit that detects and displays on a display unit the inventory inquiry target user associated with the input user identification information from a storage unit in which the inventory inquiry target users of the inventories for which inventory inquiries are permitted are respectively associated and stored; An acquisition unit that acquires the inventory data of the detected inventory inquiry target user from an inventory database; Function as a display control unit that displays the acquired inventory data on the said display unit, In the said inventory database, at least the inventory quantity of the product for which an inventory inquiry is made, the asset company that is the inventory inquiry target user, and the sales rights holder of the said product are respectively associated and stored, Among the inventories of the products for which the sales agent is the sales manager, some inventories are managed by the manufacturer, and the remaining inventories are managed by the said sales agent. When the detected inventory inquiry target user is the asset company that is the manufacturer of the said product, the said acquisition unit acquires the inventory data of all asset companies stored in the said inventory database; when the detected inventory inquiry target user is the asset company that is the sales agent of the said product, as the inventory data for which the detected inventory inquiry target user is the said sales rights holder, acquire from the said inventory database the inventory data of the inventories managed by the manufacturer and the inventory data of the inventories managed by the said sales agent. An inventory inquiry program characterized by the above.

Citation Information

Patent Citations

  • Article total management system and method

    JP2001341813A

  • System for inquiring product stock

    JP2003150856A

  • Inventory management method of warehouse

    JP2004203498A

  • Sales support system, sales support method, sales support program and recording medium

    JP2004295369A