Inventory management device, inventory management method, and inventory management program
The inventory management system addresses inefficiencies by utilizing manufacturer-issued labels with encoded lot numbers for automatic inventory identification, reducing errors and improving accuracy and efficiency in inventory management.
Patent Information
- Application Number
- JP2023073593
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2023-04-27
- Publication Date
- 2025-07-15
- Estimated Expiration
- 2043-04-27
AI Technical Summary
Existing inventory management systems require manual printing and attachment of inventory labels, leading to increased workload and potential for attachment mistakes, and existing solutions fail to efficiently utilize manufacturer lot numbers for unique inventory identification.
An inventory management system that utilizes manufacturer-issued inventory labels by encoding manufacturer lot numbers, allowing automatic assignment of product inventory identification numbers and managing inventory data, including manufacturer lot numbers, through a control unit and storage system, enabling efficient and accurate inventory management processes.
Reduces human error and workload by using manufacturer labels directly, improves inventory accuracy, and maintains manufacturer lot number associations, enhancing quality control and management efficiency.
Smart Images

Figure 0007708809000001 
Figure 0007708809000002 
Figure 0007708809000003
Abstract
Description
Technical Field
[0001] The present invention relates to an inventory management device, an inventory management method, and an inventory management program.
Background Art
[0002] Patent Document 1 discloses a configuration in which an inventory label is issued at the end of the incoming goods operation by an operator, and when the inventory label is scanned by another operator, incoming goods registration and movement work instruction creation are performed.
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 above, when receiving a base material from a manufacturer, it is necessary to print and attach a label issued by the company to all inventories, and there is a problem that the work load due to attachment mistakes and the like is large.
[0005] The present invention has been made in view of the above problems, and an object thereof is to provide an inventory management device, an inventory management method, and an inventory management program capable of managing in parallel a number for uniquely identifying an inventory and a manufacturer lot number set in an inventory label issued by a manufacturer.
Means for Solving the Problems
[0006] In order to solve the above-described problems and achieve the object, an inventory management apparatus according to the present invention is an inventory management apparatus including a storage unit and a control unit, wherein the storage unit includes product management storage means for storing order data in which a manufacturer lot number of a product and an order quantity are associated and set, and the control unit assigns a product inventory identification number to the product based on read data in which the manufacturer lot number of the product read from an inventory label issued by the manufacturer and the order data, and inventory registration means for registering current inventory data in which the inventory quantity of the product, the product inventory identification number, and the manufacturer lot number are associated and set, and product management execution means for executing the product management process based on an execution instruction for the product management process, reread data read from the inventory label of the product that is the target of the product management process, and the current inventory data.
[0007] Further, in the inventory management apparatus according to the present invention, the product management execution means executes the physical inventory process by collating the manufacturer lot number set in the reread data read from the inventory label of the product that is the target of the product management process with the manufacturer lot number set in the current inventory data based on the execution instruction for the physical inventory process.
[0008] Further, in the inventory management apparatus according to the present invention, the inventory registration means further acquires purchase data in which the purchase quantity of the product, the product inventory identification number, the manufacturer lot number, and the product rank related to the ownership of the product are associated and set based on the read data and the order data.
[0009] Also, in the inventory management device according to the present invention, the merchandise management execution means, based on the execution instruction of the consignment sales process, the rereading data read from the inventory label of the merchandise to be subjected to the merchandise management process, and the current inventory data, acquires sales data in which the sales quantity of the merchandise, the merchandise inventory identification number, the manufacturer lot number, and the merchandise rank as a company product are associated and set, and executes the consignment sales process of deleting the current inventory data of the merchandise to be subjected to the merchandise management process.
[0010] Also, in the inventory management device according to the present invention, the merchandise management execution means, based on the execution instruction of the consignment goods receipt process, the rereading data read from the inventory label of the merchandise to be subjected to the merchandise management process, and the current inventory data, assigns a serial number to the receipt inventory identification number of the merchandise, acquires transfer data in which the transfer quantity of the merchandise, the receipt inventory identification number, the manufacturer lot number, and the merchandise rank as consignment goods are associated and set, deletes the current inventory data of the merchandise to be subjected to the merchandise management process, and executes the consignment goods receipt process of registering new current inventory data in which the transfer quantity of the merchandise, the receipt inventory identification number, and the manufacturer lot number are associated and set.
[0011] Also, in the inventory management device according to the present invention, the merchandise management execution means, based on the execution instruction of the consignment goods processing process, the rereading data read from the inventory label of the merchandise to be subjected to the merchandise management process, and the current inventory data, assigns a serial number to the delivery inventory identification number of the merchandise, acquires processing delivery detail data in which the processing delivery quantity of the merchandise, the delivery inventory identification number, and the manufacturer lot number are associated and set, assigns a serial number to the processing inventory identification number of the processed merchandise, acquires processing receipt detail data in which the processing receipt quantity of the processed merchandise, the processing inventory identification number, and the manufacturer lot number are associated and set, deletes the current inventory data of the merchandise to be subjected to the merchandise management process, and executes the consignment goods processing process of registering new current inventory data in which the processing receipt quantity of the processed merchandise, the processing inventory identification number, and the manufacturer lot number are associated and set.
[0012] Further, in the inventory management device according to the present invention, the merchandise management execution means further acquires pre-inventory check processing data in which the book inventory quantity, the merchandise inventory identification number, and the manufacturer lot number of the merchandise are associated and set based on the execution instruction of the physical inventory process and the current inventory data, and causes a physical inventory entry form to be printed and output based on the pre-inventory check processing data.
[0013] Further, in the inventory management device according to the present invention, the merchandise management storage means further stores order data in which the manufacturer lot number is not set and the order quantity of the merchandise is set, and when there is no inventory label issued by the manufacturer for the merchandise, the inventory registration means assigns a serial number to the merchandise inventory identification number of the merchandise based on the order data, adopts the merchandise inventory identification number as the manufacturer lot number, and registers the current inventory data in which the inventory quantity, the merchandise inventory identification number, and the manufacturer lot number of the merchandise are associated.
[0014] Further, in the inventory management device according to the present invention, the inventory registration means further causes an inventory label in which the manufacturer lot number, which is the merchandise inventory identification number, is set to be printable and output.
[0015] Further, in the inventory management device according to the present invention, the inventory label issued by the manufacturer is characterized in that an information code in which the manufacturer lot number of the merchandise is encoded is set.
[0016] Moreover, the inventory management method according to the present invention is an inventory management method for causing an inventory management device including a storage unit and a control unit to execute. The storage unit includes product management storage means for storing order data in which a manufacturer lot number of a product and an order quantity are associated and set. In the control unit, based on read data in which the manufacturer lot number of the product read from an inventory label issued by the manufacturer is set, and the order data, a product inventory identification number of the product is numbered, and inventory registration is performed to register current inventory data in which the inventory quantity of the product, the product inventory identification number, and the manufacturer lot number are associated and set. A step, and a product management execution step of executing the product management process based on an execution instruction of the product management process, reread data read from the inventory label of the product to be processed by the product management process, and the current inventory data. It is characterized by including.
[0017] Moreover, the inventory management program according to the present invention is an inventory management program for causing an inventory management device including a storage unit and a control unit to execute. The storage unit includes product management storage means for storing order data in which a manufacturer lot number of a product and an order quantity are associated and set. In the control unit, based on read data in which the manufacturer lot number of the product read from an inventory label issued by the manufacturer is set, and the order data, a product inventory identification number of the product is numbered, and inventory registration is performed to register current inventory data in which the inventory quantity of the product, the product inventory identification number, and the manufacturer lot number are associated and set. A step, and a product management execution step of executing the product management process based on an execution instruction of the product management process, reread data read from the inventory label of the product to be processed by the product management process, and the current inventory data. It is characterized by causing the steps to be executed.
Effects of the Invention
[0018] According to the present invention, in the inventory management of the base material, there is an effect that the inventory label issued by the manufacturer (for example, the inventory label attached at the time of shipment from the manufacturer, etc.) can be used as it is. Further, according to the present invention, there is an effect that the work efficiency can be improved by reducing the work of issuing the inventory label by the company itself and attaching it to the base material. Further, according to the present invention, there is an effect that the accuracy of inventory management can be improved because it is collated together with the incoming data (contract number, dimensions, weight, etc.) received from the manufacturer. Further, according to the present invention, by directly using the off-the-shelf label issued by the manufacturer, human errors such as mislabeling can be reduced, and the manufacturer lot number associated with the mill sheet can be inherited from the base material to the product, and the accuracy of quality control can be improved. Further, according to the present invention, there is an effect that the company can use the inventory label of the manufacturer.
Brief Description of Drawings
[0019]
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
Mode for Carrying Out the Invention
[0020] Embodiments of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited by these embodiments.
[0021] [1. Overview] First, with reference to FIG. 1, the overview of the present invention will be described. FIG. 1 is a diagram showing an example of the inventory management process flow in the present embodiment.
[0022] Conventionally, when receiving a base material from a steel material manufacturer or the like, it was necessary to print and attach a label issued by the company itself to the base material, but there was a possibility of misattachment and the work load was large. Also, conventionally, in order to use the inventory label issued by the manufacturer as it is, it was necessary to uniquely identify the inventory by the manufacturer lot number, but since the numbers looped and overlapped within several years, it could not be used.
[0023] Therefore, in this embodiment, by adopting the processing flow shown in FIG. 1, a number that uniquely identifies the inventory is set for the "inventory identification number", and the manufacturer lot number encoded in the barcode described on the inventory label is set for the "barcode number". When inventory is received, the barcode on the inventory label is read, and purchase data is automatically created (simplification of the receiving operation). When taking inventory, the barcode on the inventory label is read, and a mechanism is provided to identify the inventory based on the barcode number and enable inventory taking.
[0024] [2. Configuration] An example of the configuration of the inventory management device 100 according to this embodiment will be described with reference to FIG. 2. FIG. 2 is a block diagram showing an example of the configuration of the inventory management device 100 in this embodiment.
[0025] As shown in FIG. 2, the inventory management device 100 is a commercially available desktop personal computer. Note that the inventory management device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer.
[0026] The inventory management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the inventory management device 100 is communicably connected via an arbitrary communication path.
[0027] The communication interface unit 104 communicably connects the inventory management 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 a function of communicating data with other devices via a communication line. Here, the network 300 has a function of communicably connecting the inventory management device 100 and the server 200 to each other, and is, for example, the Internet or a LAN (Local Area Network).
[0028] An input / output interface unit 108 is connected to an input device 112 and an output device 114. As the output device 114, in addition to a monitor (including a touch panel), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be described as the monitor 114 or the printer 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.
[0029] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 records a computer program for giving instructions to the CPU (Central Processing Unit) in cooperation with the OS (Operating System) to perform various processes. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory)·ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used. The storage unit 106 includes a product management database 106a.
[0030] The product management database 106a stores product management data. Here, the product management database 106a may store order data in which the manufacturer lot number of the product and the order quantity are associated. Further, the product management database 106a may store order data in which the manufacturer lot number is not set and the order quantity of the product is set. Further, the product management data may be read data of the information code, reread data of the information code, inventory data, purchase data, sales data, movement data, processing payment detail data, processing receipt detail data, pre-inventory count processing data, or product data.
[0031] The control unit 102 is a CPU or the like that comprehensively controls the inventory management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, and required data, and executes various information processes based on these stored programs. Conceptually in terms of functions, the control unit 102 includes an inventory registration unit 102a and a product management execution unit 102b.
[0032] The inventory registration unit 102a registers various data (in the storage unit 106). Here, the inventory registration unit 102a may assign a product inventory identification number to a product based on the read data obtained by setting the manufacturer lot number of the product read from the inventory label issued by the manufacturer and the order data, and register the current inventory data in which the inventory quantity of the product, the product inventory identification number, and the manufacturer lot number are associated. Further, the inventory registration unit 102a may obtain the purchase data in which the purchase quantity of the product, the product inventory identification number, the manufacturer lot number, and the product rank related to the ownership of the product are associated based on the read data and the order data. Also, when there is no inventory label issued by the manufacturer for the product, the inventory registration unit 102a may assign a product inventory identification number to the product based on the order data, adopt the product inventory identification number as the manufacturer lot number, and register the current inventory data in which the inventory quantity of the product, the product inventory identification number, and the manufacturer lot number are associated. Additionally, the inventory registration unit 102a may print and output an inventory label in which the manufacturer lot number, which is the product inventory identification number, is set to be readable. Also, the inventory label issued by the manufacturer may have an information code (for example, a barcode or a two-dimensional code such as a QR code (registered trademark), etc.) in which the manufacturer lot number of the product is encoded. Moreover, the inventory registration unit 102a may register the order data based on the incoming shipment schedule data from the manufacturer.
[0033] The merchandise management execution unit 102b executes merchandise management processing. Here, the merchandise management execution unit 102b may execute the merchandise management processing based on an execution instruction for the merchandise management processing, rereading data read from the inventory label of the merchandise subject to the merchandise management processing, and current inventory data. Also, the merchandise management execution unit 102b may execute the physical inventory processing by matching the manufacturer lot number set in the rereading data read from the inventory label of the merchandise subject to the merchandise management processing with the manufacturer lot number set in the current inventory data based on an execution instruction for the physical inventory processing. Further, the merchandise management execution unit 102b may acquire sales data in which the quantity sold of the merchandise, the merchandise inventory identification number, the manufacturer lot number, and the merchandise rank of in-house products are associated and set based on an execution instruction for the consignment sales processing, rereading data read from the inventory label of the merchandise subject to the merchandise management processing, and current inventory data, and execute the consignment sales processing for deleting the current inventory data of the merchandise subject to the merchandise management processing. Also, the merchandise management execution unit 102b may number the incoming inventory identification number of the merchandise, acquire movement data in which the quantity of movement of the merchandise, the incoming inventory identification number, the manufacturer lot number, and the merchandise rank of the consignment goods are associated and set, delete the current inventory data of the merchandise subject to the merchandise management processing, and execute the consignment goods incoming processing for registering new current inventory data in which the quantity of movement of the merchandise, the incoming inventory identification number, and the manufacturer lot number are associated and set based on an execution instruction for the consignment goods incoming processing, rereading data read from the inventory label of the merchandise subject to the merchandise management processing, and current inventory data. Further, the merchandise management execution unit 102b may number the disbursement inventory identification number of the merchandise, acquire processing disbursement detail data in which the quantity of processed disbursement of the merchandise, the disbursement inventory identification number, and the manufacturer lot number are associated and set, number the processing inventory identification number of the processed merchandise, acquire processing receipt detail data in which the quantity of processed receipt of the processed merchandise, the processing inventory identification number, and the manufacturer lot number are associated and set, delete the current inventory data of the merchandise subject to the merchandise management processing, and execute the consignment goods processing for registering new current inventory data in which the quantity of processed receipt of the processed merchandise, the processing inventory identification number, and the manufacturer lot number are associated and set based on an execution instruction for the consignment goods processing, rereading data read from the inventory label of the merchandise subject to the merchandise management processing, and current inventory data.In addition, the merchandise management execution unit 102b may obtain pre-inventory check processing data in which the book inventory quantity, merchandise inventory identification number, and manufacturer lot number of the merchandise are associated and set based on an instruction to execute the physical inventory process and the current inventory data, and may print and output a physical inventory entry form based on the pre-inventory check processing data.
[0034] [3. Specific Example] A specific example of this embodiment will be described with reference to FIGS. 3 to 14.
[0035] [Inventory Management Process] Here, with reference to FIG. 3, an example of the inventory management process in this embodiment will be described. FIG. 3 is a flowchart showing an example of the processing of the inventory management apparatus 100 in this embodiment.
[0036] As shown in FIG. 3, the inventory registration unit 102a registers the order data in the merchandise management database 106a based on the incoming shipment schedule data from the manufacturer (step SA-1).
[0037] Then, the inventory registration unit 102a determines whether there is an inventory label issued by the manufacturer for the merchandise (step SA-2).
[0038] Then, when the inventory registration unit 102a determines that there is an inventory label issued by the manufacturer for the merchandise (step SA-2: Yes), the process proceeds to step SA-3.
[0039] Then, the inventory registration unit 102a assigns a merchandise inventory identification number to the merchandise based on the read data obtained by reading the manufacturer lot number of the merchandise from the inventory label issued by the manufacturer via the input device (handheld terminal) 112 by the user and the order data stored in the merchandise management database 106a, and obtains purchase data in which the purchase quantity of the merchandise, the merchandise inventory identification number, the manufacturer lot number, and the merchandise rank related to the ownership of the merchandise are associated and set (step SA-3).
[0040] Then, the inventory registration unit 102a registers current inventory data in which the inventory quantity, product inventory identification number, and manufacturer lot number of the product are associated and set in the product management database 106a based on the read data in which the manufacturer lot number of the product read from the manufacturer-issued inventory label by the user via the input device (handy terminal) 112 is set, and the order data stored in the product management database 106a (step SA-4), and transfers the process to step SA-8.
[0041] On the other hand, when the inventory registration unit 102a determines that there is no manufacturer-issued inventory label for the product (step SA-2: No), the process is transferred to step SA-5.
[0042] Then, the inventory registration unit 102a assigns a serial number to the product inventory identification number of the product based on the order data stored in the product management database 106a, adopts the product inventory identification number as the manufacturer lot number, and obtains purchase data in which the purchase quantity of the product, the product inventory identification number, the manufacturer lot number, and the product rank related to the ownership of the product are associated and set (step SA-5).
[0043] Then, the inventory registration unit 102a registers current inventory data in which the inventory quantity, product inventory identification number, and manufacturer lot number which is the product inventory identification number of the product are associated and set in the product management database 106a (step SA-6).
[0044] Then, the inventory registration unit 102a causes the output device 114 to print and output an inventory label in which a barcode capable of reading the manufacturer lot number which is the product inventory identification number is set (step SA-7), and transfers the process to step SA-8.
[0045] Then, the product management execution unit 102b executes product management processing (step SA-8) based on an execution instruction for product management processing set by the user via the input device 112, reread data read from the inventory label of the product to be subject to product management processing by the user via the input device (handy terminal) 112, and current inventory data stored in the product management database 106a, and ends the processing.
[0046] Here, with reference to FIGS. 4 to 14, an example of the inventory management processing in the present embodiment will be described. FIGS. 4 to 14 are diagrams showing an example of the inventory management processing in the present embodiment.
[0047] As shown in FIG. 4, in the present embodiment, order data is registered based on incoming shipment scheduled data from the manufacturer.
[0048] Then, as shown in FIG. 5, in the present embodiment, the base material is received from the manufacturer. Here, on the inventory label issued by the manufacturer attached to the actual base material in the present embodiment, a product code, a manufacturer lot number, the number of employees, the weight, and a barcode in which the manufacturer lot number is encoded are described.
[0049] Then, as shown in FIG. 6, in the present embodiment, the barcodes of the inventory labels (A, B) are read via a handy terminal connected to the in-house PC via a wireless LAN or the like, the order data is referred to based on the barcode number, and the associated purchase data is created.
[0050] Then, as shown in FIG. 7, in the present embodiment, for the product S002 without an inventory label issued by the manufacturer, registration is performed from the purchase input screen, the inventory identification number is automatically assigned a serial number at the time of registration, and since there is no barcode number, the same value as the automatically assigned inventory identification number is set as the barcode number.
[0051] Then, as shown in FIG. 8, in this embodiment, only the products of S002 that could not be processed by the handheld terminal have their labels issued and replaced. Here, in the label issuance processing screen of this embodiment, when the label is issued with the "including handheld processing" check OFF, only the inventory data with the inventory identification number = barcode number can be extracted.
[0052] Then, as shown in FIG. 9, in this embodiment, an inventory count of barcode number: B is performed with the current inventory, and the inventory data at the time of the inventory count is updated to the pre-inventory count processing data. After the pre-inventory count processing is performed, an inventory count entry form is printed.
[0053] Then, as shown in FIG. 10, in this embodiment, while the user confirms the target described in the inventory count entry form, the barcode of the inventory label is read by the handheld terminal and the inventory count is performed, that is, it is matched with the barcode number of the current inventory data, and the inventory is uniquely identified. Here, in this embodiment, when there are multiple pieces of current inventory data with the same barcode number, the inventory data on the first line arranged in descending order of the current inventory quantity is acquired. For example, as shown in FIG. 10, in this embodiment, the barcode of B is read, and the inventory data on the first line (inventory identification number: L003) arranged in descending order of the current inventory is displayed, and the inventory count update process is executed to complete the inventory count operation.
[0054] Also, as shown in FIGS. 11 to 14, in this embodiment, after purchasing the base material purchased by the company, barcode transfer is executed when taking consignment sales, receiving consignment goods, and processing consignment goods. That is, in this embodiment, after taking consignment sales (FIG. 12) or when receiving consignment goods (FIG. 13), the barcode of the base material is registered in the barcode number to enable inventory accounting of consignment goods. Here, the consignment sales in this embodiment is a process of selling the base material purchased as the company's own product to the customer (however, since the processing itself is not performed immediately, the goods are left in the company for a while). Also, the consignment goods receipt in this embodiment is a process of accounting for inventory at 0 yen as consignment goods, and the manufacturer lot number held by the base material can be transferred. Therefore, at the time of consignment goods receipt, although the goods themselves are the same, as assets, they transfer from the company to another company, so originally the data of the product key should also change (that is, label replacement is required), but since the barcode number is transferred, label replacement is not required. Also, as shown in FIG. 14, in this embodiment, the same barcode number as the base material is transferred to the product made by processing the consignment goods, so it is possible to transfer the association of the mill sheet. Here, the mill sheet is an inspection certificate issued by the manufacturer to prove the material and quality of the steel material, and is associated with the manufacturer lot number.
[0055] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] According to this embodiment, it is possible to contribute to promoting business efficiency and appropriate business judgment of the company, so it is possible to contribute to Goals 8 and 9 of the SDGs.
[0056] Also, according to this embodiment, it is possible to contribute to reducing waste loss and promoting paperless and digitalization, so it is possible to contribute to Goals 12, 13, and 15 of the SDGs.
[0057] Also, according to this embodiment, it is possible to contribute to strengthening control and governance, so it is possible to contribute to Goal 16 of the SDGs.
[0058] [5. Other Embodiments] In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.
[0059] For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be manually performed, or all or part of the processes described as being manually performed can be automatically performed by a known method.
[0060] Also, 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.
[0061] Regarding the inventory management device 100, each illustrated component is a functional concept, and it is not necessarily physically configured as shown in the figure.
[0062] For example, regarding the processing functions provided by the inventory management device 100, particularly each processing function performed by the control unit 102, all or any part of them may be realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. Note that 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 management device 100 as necessary. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), 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 in cooperation with the CPU.
[0063] Also, this computer program may be stored in an application program server connected to the inventory management device 100 via an arbitrary network, and it is also possible to download all or part of it as necessary.
[0064] Also, a program for executing the processing 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.
[0065] Also, a "program" is a data processing method described in any language or description method, and is not limited to a form such as source code or binary code. Note that the "program" is not necessarily limited to being configured singly, and includes those that are distributed as a plurality of modules or libraries, or those that cooperate with another program represented by an OS to achieve its function. Note that for the specific configuration, reading procedure, and installation procedure after reading for reading the recording medium in each device shown in this embodiment, well-known configurations and procedures can be used.
[0066] The various databases and the like stored in the storage unit 106 are storage means such as memory devices like RAM and ROM, fixed disk devices like hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and files for web pages used for various processes and website provision.
[0067] Further, the inventory management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the inventory management device 100 may be realized by installing software (including programs or data, etc.) that realizes the processes described in this embodiment in the device.
[0068] Furthermore, the specific form of the distribution and integration of the devices is not limited to that 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 according to the functional load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.
Industrial Applicability
[0069] The present invention is useful in industries such as the steel industry or the chemical industry that manage base materials.
Explanation of Signs
[0070] 100 Inventory management device 102 Control unit 102a Inventory registration unit 102b Commodity management execution unit 104 Communication interface unit 106 Storage unit 106a Commodity management database 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network
Claims
1. An inventory management device comprising a memory unit and a control unit, wherein the memory unit comprises product management storage means for storing order data in which a manufacturer lot number of a product and an order quantity are associated and set; and the control unit inventory registration means for numbering a product inventory identification number of the product based on read data in which the manufacturer lot number of the product read from an inventory label issued by the manufacturer and the order data, and registering current inventory data in which the inventory quantity of the product, the product inventory identification number, and the manufacturer lot number are associated and set; product management execution means for executing the product management process based on an execution instruction for the product management process, reread data read from the inventory label of the product targeted for the product management process, and the current inventory data; An inventory management device, characterized by comprising the above.
2. The product management execution means executes the physical inventory process by collating the manufacturer lot number set in the reread data read from the inventory label of the product targeted for the product management process with the manufacturer lot number set in the current inventory data based on the execution instruction for the physical inventory process. The inventory management device according to claim 1, characterized by this.
3. The inventory registration means further obtains purchase data in which the purchase quantity of the product, the product inventory identification number, the manufacturer lot number, and the product rank related to the ownership of the product are associated and set based on the read data and the order data. The inventory management device according to claim 1, characterized by this.
4. The product management execution means obtains sales data in which the sales quantity of the product, the product inventory identification number, the manufacturer lot number, and the product rank as an in-house product are associated and set based on the execution instruction for the consignment sales process, the reread data read from the inventory label of the product targeted for the product management process, and the current inventory data, and executes the consignment sales process for deleting the current inventory data of the product targeted for the product management process. The inventory management device according to claim 3, characterized by this.
5. The product management execution means Based on the execution instruction for consignment goods receipt processing, the reread data read from the inventory label of the goods subject to the goods management processing, and the current inventory data, assign a serial number to the receipt inventory identification number of the goods, obtain movement data in which the movement quantity of the goods, the receipt inventory identification number, the manufacturer lot number, and the goods rank as consignment goods are associated and set, delete the current inventory data of the goods subject to the goods management processing, and execute the consignment goods receipt processing for registering new current inventory data in which the movement quantity of the goods, the receipt inventory identification number, and the manufacturer lot number are associated and set. The inventory management device according to claim 3, characterized in that.
6. The goods management execution means Based on the execution instruction for consignment goods processing, the reread data read from the inventory label of the goods subject to the goods management processing, and the current inventory data, assign a serial number to the delivery inventory identification number of the goods, obtain processing delivery detail data in which the processing delivery quantity of the goods, the delivery inventory identification number, and the manufacturer lot number are associated and set, assign a serial number to the processing inventory identification number of the processed goods, obtain processing receipt detail data in which the processing receipt quantity of the processed goods, the processing inventory identification number, and the manufacturer lot number are associated and set, delete the current inventory data of the goods subject to the goods management processing, and execute the consignment goods processing for registering new current inventory data in which the processing receipt quantity of the processed goods, the processing inventory identification number, and the manufacturer lot number are associated and set. The inventory management device according to claim 3, characterized in that.
7. The goods management execution means Furthermore, based on the execution instruction for the physical inventory process and the current inventory data, obtain physical inventory pre-processing data in which the book inventory quantity of the goods, the goods inventory identification number, and the manufacturer lot number are associated and set, and based on the physical inventory pre-processing data, print and output a physical inventory entry form. The inventory management device according to claim 2, characterized in that.
8. The goods management storage means Furthermore, store the order data in which the manufacturer lot number is not set and the order quantity of the goods is set. The inventory registration means When the inventory label issued by the manufacturer is not attached to the product, based on the order data, number the product inventory identification number of the product, adopt the product inventory identification number as the manufacturer lot number, and register the current inventory data in which the inventory quantity of the product, the product inventory identification number, and the manufacturer lot number are associated. The inventory management device according to any one of claims 1 to 7, characterized in that.
9. The inventory registration means Furthermore, the inventory management device according to claim 8, characterized in that it prints and outputs an inventory label in which the manufacturer lot number, which is the product inventory identification number, is set to be readable.
10. The inventory label issued by the manufacturer The inventory management device according to any one of claims 1 to 7, characterized in that an information code encoding the manufacturer lot number of the product is set.
11. An inventory management method for causing an inventory management device including a storage unit and a control unit to execute, The storage unit Product management storage means for storing order data in which the manufacturer lot number of the product and the order quantity are associated, Comprising Executed in the control unit, An inventory registration step of setting read data in which the manufacturer lot number of the product read from the inventory label issued by the manufacturer is set, and numbering the product inventory identification number of the product based on the order data, and registering the current inventory data in which the inventory quantity of the product, the product inventory identification number, and the manufacturer lot number are associated; A product management execution step of executing the product management process based on an execution instruction of the product management process, reread data read from the inventory label of the product that is the target of the product management process, and the current inventory data; An inventory management method characterized by including.
12. An inventory management program for causing an inventory management device including a storage unit and a control unit to execute, The storage unit Product management storage means for storing order data in which the manufacturer lot number of the product and the order quantity are associated, Comprising In the control unit, Based on the read data obtained by setting the manufacturer lot number of the product read from the inventory label issued by the manufacturer and the order data, generate a serial number for the product inventory identification number of the product, and register current inventory data in which the inventory quantity of the product, the product inventory identification number, and the manufacturer lot number are associated and set. An inventory registration step; A product management execution step of executing the product management process based on an execution instruction for the product management process, reread data read from the inventory label of the product subject to the product management process, and the current inventory data; An inventory management program for causing the above to be executed.
Citation Information
Patent Citations
Required amount calculation device, required amount calculation method, and required amount calculation program
JP2017182797A
Inventory management device, inventory management method, and inventory management program
JP2021140719A
Construction method of physical distribution operation system and physical distribution operation system
JP2022182446A
Operation support device, operation support method, and operation support program
JP2023034524A
JPP7082359B