Inventory search device, inventory search method, and inventory search program
Patent Information
- Application Number
- JP2025023601
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2025-02-17
- Publication Date
- 2026-08-27
AI Technical Summary
【0016】 本発明によれば、自社管理のサイズ単位と異なる取引先管理単位に合わせた許容範囲在庫検索をすることができるという効果を奏する。また、本発明によれば、取引先管理のサイズ管理をマスタ登録していないケースにおいても、取引先のサイズ単位を自社のサイズ単位に換算して在庫検索する際に、単位換算時の端数を加味した、許容範囲内の検索ヒットをすることができるという効果を奏する。また、本発明によれば、許容範囲が不要な商品群もあるため、分類となる品種毎に許容範囲を設定可能とすることができるという効果を奏する。また、本発明によれば、品種毎に許容範囲を設定することで、担当者が効率よく、単位換算時の端数を意識せずに在庫検索することができるという効果を奏する。また、本発明によれば、一部の品種が製造の難しさより公差が認められており、得意先(販売先)の発注サイズと多少異なっても販売可能な取引がされている業界(例えば、ホーロー製品業界等)において、品種毎の在庫検索許容範囲に公差の範囲を設定することにより、在庫検索の煩雑さによる機会損失を減らすことができるという効果を奏する。また、本発明によれば、建材業界のように同一商品で規格の誤差が生じる製品を在庫に持つ企業を中心に、在庫検索の効率を改善することができるという効果を奏する。また、本発明によれば、在庫検索の煩雑な業務を効率化することで販売機会損失の防止をすることができるという効果を奏する。また、本発明によれば、在庫検索の効率を改善するであるという効果を奏する。
Smart Images

Figure 2026137471000001_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to an inventory search device, an inventory search method, and an inventory search program.
Background Art
[0002] Patent Document 1 discloses a configuration for performing inventory management of in-stock products by pre-registering unit conversion factors and performing unit conversion from the company's own unit of use to the customer-specified unit or from the customer-specified unit to the company's own unit of use.
Prior Art Documents
Patent Documents
[0003]
Patent Document 1
Summary of the Invention
Problems to be Solved by the Invention
[0004] However, in the invention described in Patent Document 1, there is a problem that it is impossible to search for inventory managed in the company's own unit of use by specifying the size of the customer-specified unit.
[0005] The present invention has been made in view of the above problems, and an object thereof is to provide an inventory search device, an inventory search method, and an inventory search program that can register a trading partner management unit in a master and perform a search in the size unit of trading partner management at the time of inventory search.
Means for Solving the Problems
[0006] To solve the above-mentioned problems and achieve the objective, the inventory search device according to the present invention is an inventory search device comprising a storage unit and a control unit, wherein the storage unit comprises inventory management storage means that stores current inventory data set by linking products, inventory size and inventory quantity according to the company's management unit, a customer master setting a customer management unit for each customer, a unit conversion master setting a conversion value according to the company's management unit for each customer management unit, and a tolerance range master setting a tolerance value that defines the size tolerance range of the product, and the control unit comprises order acquisition means that acquires order data set by linking the order size and order quantity of the product from the customer, and inventory search means that displays inventory search results set by linking the inventory size and inventory quantity of the inventory product based on the order data, the current inventory data, the customer master, the unit conversion master, and the tolerance range master.
[0007] Furthermore, in the inventory search device according to the present invention, the order acquisition means acquires order data set by linking the order size and order quantity of the customer management unit of the product from the customer, the inventory search means converts the order size of the customer management unit set in the order data to the converted size of the company's management unit using the conversion value set in the unit conversion master for the customer management unit set in the customer master, and displays the inventory search results set by linking the inventory size and inventory quantity of the inventory product based on the converted size, the current inventory data, and the tolerance range master.
[0008] Furthermore, in the inventory search device according to the present invention, the inventory search means converts the order size of the customer management unit set in the order data to the converted size of the company's management unit using the conversion value set in the unit conversion master for the customer management unit set in the customer master, identifies the current inventory data in which the inventory size is set within the size tolerance range from the lower limit obtained by subtracting the tolerance value set in the tolerance range master from the converted size to the upper limit obtained by adding the tolerance value to the converted size, identifies the inventory search result set by linking the inventory size and inventory quantity of the inventory product from the current inventory data, and displays the inventory search result.
[0009] Furthermore, in the inventory search device according to the present invention, the inventory search means is further characterized in that, when an input size for the product according to the company's internal management unit is set, it displays the inventory search results set by linking the inventory size and inventory quantity of the inventory product based on the input size, the current inventory data, and the tolerance range master.
[0010] Furthermore, in the inventory search device according to the present invention, the inventory search means is further characterized in that, when the order data from a customer in which the company's management unit is set as the customer management unit in the customer master is acquired by the order acquisition means, the inventory data in which the inventory size is set within the size tolerance range from a lower limit obtained by subtracting the tolerance value set in the tolerance range master from the order size set in the order data to an upper limit obtained by adding the tolerance value to the order size, and displays the inventory search results which are set by linking the inventory size and inventory quantity of the inventory product based on the current inventory data.
[0011] Furthermore, in the inventory search device according to the present invention, the storage unit further comprises a product master set by linking the product and the product type, the tolerance range master is set by linking the product type and the tolerance value, the inventory search means converts the order size of the customer management unit of the product set in the order data to the converted size of the company management unit using the conversion value set in the unit conversion master for the customer management unit set in the customer master, identifies the product type set by linking the product in the product master, identifies the tolerance value set by linking the product type in the tolerance range master, identifies the current inventory data in which the inventory size is set within the size tolerance range from the lower limit obtained by subtracting the tolerance value from the converted size to the upper limit obtained by adding the tolerance value to the converted size, identifies the inventory search result set by linking the inventory size and inventory quantity of the inventory product from the current inventory data, and displays the inventory search result.
[0012] Furthermore, in the inventory search device according to the present invention, the in-house management unit is characterized by being millimeters, centimeters, meters, inches, hands, feet, yards, chains, rin, bu, sun, shaku, ken, jo, or cho, and the customer management unit is characterized by being millimeters, centimeters, meters, inches, hands, feet, yards, chains, rin, bu, sun, shaku, ken, jo, or cho.
[0013] Furthermore, in the inventory search device according to the present invention, the product is characterized in that it is a building material or an enamel product.
[0014] Furthermore, the inventory search method according to the present invention is an inventory search method to be executed by an inventory search device comprising a storage unit and a control unit, wherein the storage unit comprises inventory management storage means that stores current inventory data set by linking products, inventory size and inventory quantity according to the company's management unit, a customer master setting a customer management unit for each customer, a unit conversion master setting a conversion value according to the company's management unit for each customer management unit, and an tolerance range master setting a tolerance value that defines the size tolerance range of the product, and is characterized by including an order acquisition step executed by the control unit to acquire order data set by linking the order size and order quantity of the product from the customer, and an inventory search step that displays inventory search results set by linking the inventory size and inventory quantity of the inventory product based on the order data, the current inventory data, the customer master, the unit conversion master, and the tolerance range master.
[0015] Furthermore, the inventory search program according to the present invention is an inventory search program to be executed by an inventory search device comprising a storage unit and a control unit, wherein the storage unit comprises inventory management storage means that stores current inventory data set by linking products, inventory size and inventory quantity according to the company's management unit, a customer master setting a customer management unit for each customer, a unit conversion master setting a conversion value according to the company's management unit for each customer management unit, and a tolerance range master setting a tolerance value that defines the size tolerance range of the products, and the control unit is characterized by causing the control unit to execute an order acquisition step of acquiring order data set by linking the order size and order quantity of the products from the customer, and an inventory search step of displaying inventory search results set by linking the inventory size and inventory quantity of the inventory products based on the order data, the current inventory data, the customer master, the unit conversion master, and the tolerance range master. [Effects of the Invention]
[0016] The present invention provides the effect of enabling inventory searches within an acceptable range that matches the size units managed by the customer, which may differ from the size units managed by the company. Furthermore, even in cases where the size management of customer management is not registered in the master data, the present invention provides the effect of enabling search hits within an acceptable range, taking into account fractions during unit conversion, when converting the customer's size units to the company's size units and searching for inventory. Furthermore, since there are product groups for which an acceptable range is not necessary, the present invention provides the effect of being able to set an acceptable range for each product category. Furthermore, by setting an acceptable range for each product category, the present invention provides the effect of enabling personnel to efficiently search for inventory without having to be aware of fractions during unit conversion. Furthermore, in industries where tolerances are permitted for some product categories due to the difficulty of manufacturing, and where transactions are conducted even if the size differs slightly from the customer's (sales destination's) order size (for example, the enamelware industry), the present invention provides the effect of reducing opportunity losses due to the complexity of inventory searches by setting a tolerance range in the inventory search acceptable range for each product category. Furthermore, the present invention has the effect of improving the efficiency of inventory searches, particularly for companies in the building materials industry that stock products with variations in specifications for the same product. Additionally, the present invention has the effect of preventing lost sales opportunities by streamlining the cumbersome inventory search process. Furthermore, the present invention has the effect of improving the efficiency of inventory searches. [Brief explanation of the drawing]
[0017] [Figure 1] Figure 1 is a block diagram showing an example of the configuration of an inventory search device in an embodiment. [Figure 2] Figure 2 shows an example of a data structure in an embodiment. [Figure 3] Figure 3 shows an example of a data structure in an embodiment. [Figure 4] Figure 4 shows an example of a data structure in an embodiment. [Figure 5] Figure 5 shows an example of a data structure in an embodiment. [Figure 6] FIG. 6 is a diagram showing an example of a data structure in an embodiment. [Figure 7] FIG. 7 is a flowchart showing an example of the processing of an inventory search device in an embodiment. [Figure 8] FIG. 8 is a diagram showing an example of inventory management processing in an embodiment. [Figure 9] FIG. 9 is a diagram showing an example of inventory management processing in an embodiment. MODE FOR CARRYING OUT THE INVENTION
[0018] Embodiments of the present invention will be described in detail based on the drawings. Note that the present invention is not limited to these embodiments.
[0019] [1. Overview] First, an overview of the present invention will be described.
[0020] Conventionally, in the building materials industry, inventory management by size such as width, length, and thickness for the same product is an essential requirement. Since the unit of size is unified within the company, there are cases where it is different from the unit of transactions with customers. Specifically, in the construction field, there are cases where "shaku" is used. Although the size management within the company is carried out in "cm", when conducting transactions with customers in shaku, since 3 shaku is converted to 90.909 cm, when searching for inventory, it is not known whether the inventory is registered in 90 cm or 91 cm, so it is necessary to search both sizes, making the operation inefficient and complicated. Also, conventionally, in order to perform a search considering the decimal places during unit conversion, a From~To search could be considered, but a From~To search was required even for product types where no unit conversion occurred.
[0021] Therefore, in this embodiment, even in cases where the customer management unit is not registered in the customer master (sales destination master), the inventory search will be performed using the company's own management unit, but a mechanism is provided that will still find a hit in the search as long as the size error of the search value is within the acceptable range set in the master. For example, in this embodiment, when converting from shaku to centimeters, the product will be found whether you search using 90 cm or 91 cm, so you can search efficiently without worrying about rounding up, rounding down, or rounding to the nearest whole number during unit conversion.
[0022] Furthermore, in this embodiment, (1) the size units managed by the trading partner can be registered on the trading partner master screen. Also, in this embodiment, (2) a unit conversion master and a tolerance range master are provided and parameters can be set for unit conversion or tolerance range search after unit conversion. In this embodiment, in order to allow for batch adjustment in cases where tolerance range is unnecessary, the tolerance range is too wide, or the tolerance range is too narrow for products other than those related to construction, the tolerance range can be set on a per-product basis. Also, in this embodiment, (3) when searching by sales destination and size as extraction conditions on the inventory search screen, the search is performed using the size units managed by the trading partner, converted to the company's size units, and inventory within the tolerance range can be displayed as a search result. In this embodiment, if a sales destination is not specified in the extraction conditions, the search will be performed using the company's size units instead of the trading partner's size units, but even in this case, inventory within the tolerance range can be displayed as a search result.
[0023] [2. Structure] An example of the configuration of the inventory search device 100 according to this embodiment will be described with reference to Figures 1 to 6. Figure 1 is a block diagram showing an example of the configuration of the inventory search device 100 in this embodiment.
[0024] As shown in Figure 1, the inventory search device 100 is a commercially available desktop personal computer. However, the inventory search device 100 is not limited to stationary information processing devices such as desktop personal computers, but may also be portable information processing devices such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smartphones, or tablet personal computers.
[0025] The inventory search device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each component of the inventory search device 100 is connected to communicate via any communication path.
[0026] The communication interface unit 104 connects the inventory search device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has the function of communicating data with other devices via a communication line. Here, the network 300 has the function of connecting the inventory search device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).
[0027] The input / output interface unit 108 is connected to an input device 112 and an output device 114. The output device 114 can be a monitor (including a touch panel), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that works in conjunction with a mouse to provide pointing device functionality. In the following, the output device 114 may be referred to as the monitor 114 or printer 114, and the input device 112 may be referred to as the keyboard 112 or mouse 112.
[0028] The storage unit 106 stores various databases, tables, and files. The storage unit 106 also stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 includes an inventory management database 106a.
[0029] The inventory management database 106a stores inventory management data. Here, the inventory management database 106a may store current inventory data linked to products, inventory size and inventory quantity according to the company's management units, a customer master with customer management units set for each customer, a unit conversion master with conversion values according to the company's management units for each customer management unit, and / or a tolerance range master with tolerance values that define the size tolerance range of products. The inventory management database 106a may also store a product master linked to products and product types. The tolerance range master may also be set linked to product types and tolerance values. The company's management units may be millimeters, centimeters, meters, inches, hands, feet, yards, chains, rin, bu, sun, shaku, ken, jo, or cho. The customer management units may also be millimeters, centimeters, meters, inches, hands, feet, yards, chains, rin, bu, sun, shaku, ken, jo, or cho. Furthermore, the goods may be building materials or enamel products. In addition, the inventory management database 106a may store order data, sales data, purchase data, incoming goods data, and / or outgoing goods data.
[0030] Here, an example of the data structure in this embodiment will be described with reference to Figures 2 to 6. Figures 2 to 6 are diagrams showing an example of the data structure in the embodiment.
[0031] As shown in Figure 2, this embodiment includes a customer master (sales customer master) that links customer codes (sales customer codes), customer names (sales customer names), and customer management units (customer units). As shown in Figure 2, Company I uses the same CM management as the company itself, so the customer unit is not registered (NULL).
[0032] As shown in Figure 3, this embodiment includes a unit conversion master in which the source unit and the converted value are linked and set.
[0033] As shown in Figure 4, this embodiment includes a product master in which product codes, product names, and variety codes are linked and configured.
[0034] As shown in Figure 5, this embodiment includes a tolerance range master in which a variety code and an tolerance value are linked and set.
[0035] As shown in Figure 6, the inventory management database 106a of this embodiment stores current inventory data linked to the storage location (warehouse), product code, product name, lot number, width, length, and inventory quantity.
[0036] Returning to Figure 1, the control unit 102 is a CPU or similar component that comprehensively controls the inventory search device 100. The control unit 102 has internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs. Functionally, the control unit 102 comprises an order acquisition unit 102a and an inventory search unit 102b.
[0037] The order acquisition unit 102a acquires order data. Here, the order acquisition unit 102a may acquire order data that is set by linking the order size and order quantity of goods from the trading partner. Alternatively, the order acquisition unit 102a may acquire order data that is set by linking the order size and order quantity of goods for each trading partner management unit from the trading partner.
[0038] The inventory search unit 102b performs an inventory search. The inventory search unit 102b may output (display or print) the inventory search results. The inventory search unit 102b may also display inventory search results that are set by linking the inventory size and inventory quantity of inventory items based on order data, current inventory data, customer master, unit conversion master, and tolerance range master. Alternatively, the inventory search unit 102b may convert the order size of the customer management unit set in the order data to the converted size of the company's management unit using the conversion value set in the unit conversion master for the customer management unit set in the customer master, and then display inventory search results that are set by linking the inventory size and inventory quantity of inventory items based on the converted size, current inventory data, and tolerance range master. Furthermore, the inventory search unit 102b may convert the order size of the customer management unit set in the order data to the converted size of the company's own management unit using the conversion value set in the unit conversion master for the customer management unit set in the customer master, identify current inventory data for which the inventory size is set within the size tolerance range from the lower limit obtained by subtracting the tolerance value set in the tolerance range master from the converted size to the upper limit obtained by adding the tolerance value to the converted size, identify inventory search results set by linking the inventory size and inventory quantity of the inventory product from the current inventory data, and display the inventory search results. In addition, if the input size of the product is set in the company's own management unit, the inventory search unit 102b may display inventory search results set by linking the inventory size and inventory quantity of the inventory product based on the input size, current inventory data, and tolerance range master. Furthermore, when the inventory search unit 102b obtains order data from a customer whose company management unit is set as the customer management unit in the customer master by the order acquisition unit 102a, it may identify current inventory data in which the inventory size is set within a size tolerance range from the lower limit obtained by subtracting the tolerance value set in the tolerance range master from the order size set in the order data to the upper limit obtained by adding the tolerance value to the order size, and then display the inventory search results that associate the inventory size and inventory quantity of the inventory items based on the current inventory data.Furthermore, the inventory search unit 102b may convert the order size of the customer management unit for the product set in the order data to the converted size of the company's management unit using the conversion value set in the unit conversion master for the customer management unit set in the customer master, identify the product variety set in association with the product in the product master, identify the tolerance value set in association with the product variety in the tolerance range master, identify the current inventory data in which the inventory size is set within the size tolerance range from the lower limit obtained by subtracting the tolerance value from the converted size to the upper limit obtained by adding the tolerance value to the converted size, identify the inventory search result set in association with the inventory size and inventory quantity of the inventory product from the current inventory data, and display the inventory search result.
[0039] [3. Specific Examples] A specific example of this embodiment will be described with reference to Figures 7 to 9.
[0040] [Inventory management processing] Now, with reference to Figure 7, an example of inventory management processing in this embodiment will be described. Figure 7 is a flowchart showing an example of processing by the inventory search device 100 in this embodiment.
[0041] As shown in Figure 7, the order acquisition unit 102a acquires order data from a trading partner, linking the order size and order quantity of the trading partner management unit for the goods (Step SA-1).
[0042] Then, the inventory search unit 102b converts the order size of the customer management unit for the product set in the order data to the converted size of the company's management unit using the conversion value set in the unit conversion master for the customer management unit set in the customer master, identifies the product type set in association with the product in the product master, identifies the tolerance value set in association with the product type in the tolerance range master, identifies the current inventory data in which the inventory size is set within the size tolerance range from the lower limit obtained by subtracting the tolerance value from the converted size to the upper limit obtained by adding the tolerance value to the converted size, identifies the inventory search result set in association with the inventory size and inventory quantity of the inventory product from the current inventory data, displays the inventory search result on the output device 114 (step SA-2), and ends the process.
[0043] Here, an example of inventory management processing in this embodiment will be described with reference to Figures 8 and 9. Figures 8 and 9 are diagrams showing an example of inventory management processing in this embodiment.
[0044] As shown in Figure 8, in this embodiment, when an order data for 100 sheets of "1x3" size MDF is obtained from Company H, (1) Company H's customer code is set as the planned customer on the inventory inquiry screen to identify the customer unit registered in the customer master, (2) the size of the customer unit is set on the inventory inquiry screen, and (3) the unit is converted from shaku to cm using the conversion value from the unit conversion master, the product type is referenced from the product code in the product master, and a from~to inventory search is performed using the tolerance value + / - from the tolerance range master.
[0045] Furthermore, as shown in Figure 9, in this embodiment, when an order data for 100 sheets of "1x3" size MDF is obtained from Company H, and the user has converted the input size (cm) from "1 (shaku) x 3 (shaku)" and set it on the inventory inquiry screen, (1) the product code is used to refer to the product type in the product master, and a from~to inventory search is performed using the tolerance value of the tolerance range master by adding / subtracting.
[0046] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving operational efficiency and promoting appropriate management decisions within companies, thereby enabling contributions to SDGs Goals 8 and 9.
[0047] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.
[0048] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.
[0049] [5. Other Embodiments] In addition to the embodiments described above, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.
[0050] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically by known methods.
[0051] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.
[0052] Furthermore, with respect to the inventory search device 100, each component shown in the illustration is a functional concept and does not necessarily need to be physically configured as shown.
[0053] For example, the processing functions of the inventory search device 100, particularly those performed by the control unit 102, may be implemented entirely or partially by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for the information processing device to execute the processing described in this embodiment, and is mechanically read by the inventory search device 100 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) contains a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing tasks. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.
[0054] Furthermore, this computer program may be stored on an application program server connected to the inventory search device 100 via any network, and it is possible to download all or part of it as needed.
[0055] Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.
[0056] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in this embodiment, as well as the installation procedures after reading, well-known configurations and procedures can be used.
[0057] The various databases stored in the memory unit 106 include memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.
[0058] Furthermore, the inventory search device 100 may be configured as an information processing device such as a known personal computer or workstation, or as an information processing device to which any peripheral devices are connected. Alternatively, the inventory search device 100 may be implemented by installing software (including programs or data, etc.) on the device that enables the processing described in this embodiment.
[0059] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Industrial applicability]
[0060] This invention is useful in industries such as the building materials industry and the enamel industry, where tolerances are permitted due to the difficulty of manufacturing, and where goods can be sold even if they differ slightly from the customer's ordered size. [Explanation of symbols]
[0061] 100 Inventory Search Device 102 Control Unit 102a Order Acquisition Department 102b Inventory Search Department 104 Communication Interface Section 106 Storage section 106a Inventory Management Database 108 Input / Output Interface Section 112 Input device 114 Output device 200 servers 300 Networks
Claims
1. An inventory retrieval device comprising a storage unit and a control unit, The aforementioned storage unit is Inventory management storage means that stores current inventory data linked to products, inventory size and quantity according to the company's internal management units, a customer master with customer management units set for each customer, a unit conversion master with conversion values according to the company's internal management units set for each customer management unit, and a tolerance range master with tolerance values that define the size tolerance range of the products. Equipped with, The control unit, An order acquisition means for acquiring order data set by linking the order size and order quantity of the aforementioned products from the aforementioned trading partner, An inventory search means that displays inventory search results set by linking the inventory size and inventory quantity of inventory items based on the order data, the current inventory data, the customer master, the unit conversion master, and the tolerance range master, An inventory search device characterized by being equipped with the following features.
2. The aforementioned order acquisition means is, The order data is obtained by linking the order size and order quantity of the customer management unit for the said product from the said customer, The aforementioned inventory search means is The inventory search device according to claim 1, characterized in that it converts the order size of the customer management unit set in the order data to the converted size of the company's own management unit using the conversion value set in the unit conversion master for the customer management unit set in the customer master, and displays the inventory search results set by linking the inventory size and inventory quantity of the inventory product based on the converted size, the current inventory data, and the tolerance range master.
3. The aforementioned inventory search means is The inventory search device according to claim 2, characterized in that it converts the order size of the customer management unit set in the order data to the converted size of the company's management unit using the conversion value set in the unit conversion master for the customer management unit set in the customer master, identifies the current inventory data in which the inventory size is set within the size tolerance range from the lower limit obtained by subtracting the tolerance value set in the tolerance range master from the converted size to the upper limit obtained by adding the tolerance value to the converted size, identifies the inventory search result set by linking the inventory size and inventory quantity of the inventory product from the current inventory data, and displays the inventory search result.
4. The aforementioned inventory search means is Furthermore, the inventory search device according to any one of claims 1 to 3 is characterized in that, when an input size is set according to the company's internal management unit for the said product, the inventory search results are displayed, which are set by linking the inventory size and inventory quantity of the said inventory product based on the input size, the current inventory data, and the tolerance range master.
5. The aforementioned inventory search means is Furthermore, the inventory search device according to claim 1 or 2, characterized in that when the order data from a customer whose company management unit is set as the customer management unit in the customer master is acquired by the order acquisition means, the current inventory data is identified in which the inventory size is set within the size tolerance range from the lower limit obtained by subtracting the tolerance value set in the tolerance range master from the order size set in the order data to the upper limit obtained by adding the tolerance value to the order size, and the inventory search results are displayed based on the current inventory data, linking the inventory size and inventory quantity of the inventory product.
6. The aforementioned storage unit is The aforementioned products, and the product master set up by linking the product and variety, Furthermore, The aforementioned tolerance master is The aforementioned varieties and the aforementioned tolerance values are set in association with each other. The aforementioned inventory search means is The inventory search device according to claim 3, characterized in that it converts the order size of the customer management unit for the product set in the order data to the converted size of the company's management unit using the conversion value set in the unit conversion master for the customer management unit set in the customer master, identifies the product type set in association with the product in the product master, identifies the tolerance value set in association with the product type in the tolerance range master, identifies the current inventory data in which the inventory size is set within the size tolerance range from the lower limit obtained by subtracting the tolerance value from the converted size to the upper limit obtained by adding the tolerance value to the converted size, identifies the inventory search result set in association with the inventory size and inventory quantity of the inventory product from the current inventory data, and displays the inventory search result.
7. The aforementioned internal management unit is, Millimeters, centimeters, meters, inches, hands, feet, yards, chains, rin, fen, sun, shaku, ken, jo, or cho. The aforementioned customer management unit is: An inventory search device according to any one of 1 to 3, characterized in that the unit is millimeters, centimeters, meters, inches, hands, feet, yards, chains, rin, bu, sun, shaku, ken, jo, or cho.
8. The aforementioned product is An inventory search device according to any one of claims 1 to 3, characterized in that it is a building material or an enamel product.
9. An inventory search method to be executed by an inventory search device comprising a memory unit and a control unit, The aforementioned storage unit is Inventory management storage means that stores current inventory data linked to products, inventory size and quantity according to the company's internal management units, a customer master with customer management units set for each customer, a unit conversion master with conversion values according to the company's internal management units set for each customer management unit, and a tolerance range master with tolerance values that define the size tolerance range of the products. Equipped with, The control unit is executed as follows: An order acquisition step to acquire order data set by linking the order size and order quantity of the aforementioned product from the aforementioned business partner, An inventory search step that displays inventory search results set by linking the inventory size and inventory quantity of inventory items based on the order data, current inventory data, customer master, unit conversion master, and tolerance range master, A method for searching inventory, characterized by including the following:
10. An inventory search program to be executed by an inventory search device comprising a memory unit and a control unit, The aforementioned storage unit is Inventory management storage means that stores current inventory data linked to products, inventory size and quantity according to the company's internal management units, a customer master with customer management units set for each customer, a unit conversion master with conversion values according to the company's internal management units set for each customer management unit, and a tolerance range master with tolerance values that define the size tolerance range of the products. Equipped with, In the control unit, An order acquisition step to acquire order data set by linking the order size and order quantity of the aforementioned product from the aforementioned business partner, An inventory search step that displays inventory search results set by linking the inventory size and inventory quantity of inventory items based on the order data, current inventory data, customer master, unit conversion master, and tolerance range master, An inventory search program to execute the command.
Citation Information
Patent Citations
Quantity changer and quantity corrector
JP2000211711A