Product management device, product management method, and product management program

Abstract

To provide a product management device, a product management method, and a product management program capable of managing repair history or the like for every product by adding serial numbers for identification to a plurality of products having an identical production number.SOLUTION: A product management device according to an embodiment includes a control part, and is accessible to order acceptance data and a product number master. The control part is provided with: a serial data creation part which adds a serial number identifying a plurality of products and creates serial data associated with an accepted order number and a manufacturing number in order acceptance in which one manufacturing number is added to the plurality of products; a repair arrangement data creation part which creates repair arrangement data associated with a repair production number, a manufacturing number, a serial number, a repair component name, a product number code, and a repair content; and a repair history extraction part which extracts and outputs a repair history per serial number by designation via a repair history inquiry screen.SELECTED DRAWING: Figure 1

Description

[Technical field]

[0001] The present invention relates to a product management device, a product management method, and a product management program. [Background technology]

[0002] In manufacturing industries that accept individual orders, products are managed by serial number (hereinafter sometimes referred to as "serial number"), so when multiple products with the same serial number are ordered, the same serial number is assigned to those multiple products. When the products are repaired or modified, there is a problem in that it is not possible to manage which products have been repaired, because they are managed by serial number.

[0003] Patent Document 1 describes a product guarantee and user registration management device that includes a web server, a product information database, and a registered user information database that stores information about users, and includes a process of registering a product password, which is different from the serial number that is the product's manufacturing number and is used to distinguish between products of the same type, in the product information database; a process in which a user who has purchased the product for which the product password is registered connects to the web server via the Internet from a client terminal and transmits product information including the serial number and product password attached to the product and personal information to the web server to apply for user registration; and a process of determining whether the product password in the product information database matches the transmitted product password, and determining whether the product password matches both product passwords. The method for product warranty and user registration includes the steps of: when the passwords match, the web server authenticates the user as the purchaser of the product to which the product password is attached; registering the transmitted personal information in the registrant information database as registrant information and creating a warranty that guarantees a contract to replace or repair the product or to take equivalent measures in the event that the product is defective, etc.; and storing the warranty on the web server or another server, thereby enabling the user to access the warranty via the Internet, so that the user can receive a service of replacing or repairing the product by presenting the warranty downloaded from the server. [Prior art documents] [Patent documents]

[0004] [Patent Document 1] JP 2003-242275 A Summary of the Invention [Problem to be solved by the invention]

[0005] The product warranty and user registration method of Patent Document 1 does not allow for the understanding of the repair status of each product when multiple products with the same serial number are ordered and repaired.

[0006] The present invention has been made in consideration of the above problems, and aims to provide a product management device, a product management method, and a product management program that enable management of the repair history, etc., of each product by assigning an identifying serial number to multiple products having the same serial number. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the object, the product management device of the present invention is a product management device equipped with a control unit that can access order data storing order information including order number, customer, order category, quantity, serial number, and shipping date, and a product number master storing product number codes and product number names and the expiration date of the product numbers, and the control unit is characterized in that it is equipped with: a serial data creation unit that, in an order in which one serial number is assigned to multiple products, assigns a serial number that identifies the multiple products and creates serial data linked to the order number and the serial number; a repair order data creation unit that, when a repair order is placed for at least some of the multiple products to which serial numbers are assigned, creates repair order data linking the repair serial number, serial number, serial number, repair part name, product number code, and repair content; and a repair history extraction unit that extracts and outputs repair history on a serial number basis from the repair order data based on a specification made via a repair history inquiry screen.

[0008] In addition, in the product management device of the present invention, in the above invention, the repair history extraction unit refers to the order data, the serial data, and the repair arrangement data, extracts post-repair product information for products with a specified manufacturing number on a serial number basis, and outputs it together with the repair history.

[0009] In the product management device according to the present invention, in the above invention, the repair history extraction section also extracts unrepaired products having the same serial numbers as the repaired products in units of serial numbers.

[0010] In addition, in the product management device of the present invention, in the above invention, the repair history extraction unit refers to the order data, the serial data, and the repair arrangement data, extracts post-repair product information having specified parts on a serial number basis, and outputs it together with the repair history.

[0011] In addition, in the product management device of the present invention, in the above invention, the repair history extraction unit obtains the shipping date of a specified serial number from the order data, determines for each part whether the number of days elapsed since the shipping date is within the expiration date in the part number master, and outputs products whose expiration date has passed, by serial number.

[0012] Furthermore, the product management method of the present invention is a product management method executed by a product management device equipped with a control unit, the product management device being capable of accessing order data storing order information including order number, customer, order category, quantity, serial number, and shipping date, and a product number master storing product number codes and product number names, and the expiration date of the product numbers, and is characterized in that the product management method includes the following steps: a serial data creation step, executed by the control unit, for receiving an order in which one serial number is assigned to multiple products, assigning a serial number that identifies the multiple products and creating serial data linked to the order number and the serial number; a repair order data creation step, when a repair order is placed for at least some of the multiple products to which serial numbers are assigned, creating repair order data linking the repair serial number with the serial number, serial number, repair part name, product number code, and repair content; and a repair history extraction step, for extracting and outputting repair history on a serial number basis from the repair order data based on a specification made via a repair history inquiry screen.

[0013] In addition, the product management program of the present invention is a product management program executed by a product management device equipped with a control unit, which is capable of accessing order data storing order information including order number, customer, order category, quantity, serial number, and shipping date, and a product number master storing product number codes and product number names and the expiration date of the product numbers, and causes the control unit to execute a serial data creation step of assigning serial numbers that identify multiple products and creating serial data linked to the order number and serial number when an order is placed in which one serial number is assigned to multiple products, a repair order data creation step of creating repair order data linking the repair serial number with the serial number, serial number, repair part name, product number code, and repair content when a repair order is placed for at least some of the multiple products to which serial numbers are assigned, and a repair history extraction step of extracting and outputting repair history on a serial number basis from the repair order data based on specification via a repair history inquiry screen. Effect of the Invention

[0014] According to the present invention, by assigning an identifying serial number to a plurality of products having the same production number, it is possible to effectively manage repair history and the like. [Brief description of the drawings]

[0015] [Figure 1] FIG. 1 is a diagram showing an example of a configuration of a product management device according to the present embodiment. [Diagram 2] FIG. 2 is a diagram showing an example of an order input screen. [Diagram 3] FIG. 3 is a diagram showing the relationship between the manufacturing number and the serial number. [Figure 4] FIG. 4 is a diagram illustrating an example of the order data. [Diagram 5] FIG. 5 is a diagram illustrating an example of serial data. [Figure 6] FIG. 6 is a diagram showing an example of the order input screen. [Figure 7] FIG. 7 is a diagram illustrating an example of the order data. [Figure 8] FIG. 8 is a diagram illustrating an example of serial data. [Figure 9] FIG. 9 is a diagram showing an example of the repair arrangement input screen. [Figure 10] FIG. 10 is a diagram showing an example of the repair arrangement data. [Figure 11] FIG. 11 is a diagram illustrating an example of the product number master. [Figure 12] FIG. 12 is a diagram showing an example of the repair history inquiry screen. [Figure 13] FIG. 13 is a diagram for explaining extraction of a repair history by the repair history extracting unit. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0016] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, preferred embodiments of a product management device, a product management method, and a product management program according to the present invention will be described in detail with reference to the accompanying drawings. Note that the present invention is not limited to the preferred embodiments.

[0017] [1. Configuration] An example of the configuration of a product management device according to this embodiment will be described with reference to Fig. 1 etc. Fig. 1 is a diagram showing an example of the configuration of a product management device 100 according to this embodiment.

[0018] The product management device 100 is constructed based on a commercially available desktop personal computer. Note that the product management device 100 is not limited to being constructed based on a stationary information processing device such as a desktop personal computer, but may be constructed based on a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0019] The product management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the product management device 100 are communicatively connected via any communication path.

[0020] The communication interface unit 104 communicatively connects the product 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 the communication line. Here, the network 300 has a function of connecting the product management device 100 and the server device 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The data stored in the memory unit 106 may be stored in the server device 200, for example.

[0021] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0022] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106.

[0023] The storage unit 106 stores, for example, order data 106a, serial data 106b, repair arrangement data 106c, and part number master 106d.

[0024] The order data 106a is data related to order information from customers. As shown in Fig. 4, the order data 106a stores the order number, customer code, order category, product code, quantity, serial number, order date, expected sales date, shipping date, sales amount, etc. The order data 106a stores data related to orders for repairs, etc., in addition to new sales such as new construction work. New sales and repairs / modifications are categorized by order category.

[0025] The serial data 106b is data related to serial numbers that are assigned to identify products when receiving an order in which one manufacturing number is assigned to multiple products. The serial data 106b stores information such as order number, manufacturing number, serial number, and repair parts, as shown in an example in Fig. 5. The serial data 106b stores serial numbers that are assigned when selling new products, as well as data related to the serial numbers of products for which orders for repairs, etc. have been received.

[0026] The repair arrangement data 106c is data related to arrangements for repair and modification of a product. The repair arrangement data 106c stores information such as a repair model number, a manufacturing number, a serial number, a product number code, a product number name, and a repair reason, as shown in an example in FIG.

[0027] The part number master 106d stores part number names and part number codes of parts constituting a product, and the expiration dates of the part numbers in association with each other.

[0028] The control unit 102 is a CPU or the like that performs overall control of the product 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, required data, and the like, and executes various types of information processing based on these stored programs.

[0029] The control unit 102 conceptually includes, functionally, a serial data creation unit 102a, a repair order data creation unit 102b, a repair history extraction unit 102c, and the like.

[0030] In an order in which one serial number is assigned to multiple products, the serial data creation unit 102a assigns a serial number that identifies the multiple products, and creates serial data 106b that is linked to the order number and the serial number.

[0031] When a repair order is placed for at least some of a plurality of products to which serial numbers have been assigned, the repair order data creation unit 102b creates repair order data 106c that links the repair serial number, manufacturing number, repair part name, product number code, and repair content to the serial number.

[0032] The repair history extraction unit 102c extracts and outputs repair histories on a serial number basis from the repair order data in response to a specification made via a repair history inquiry screen, which will be described later.

[0033] [2. Processing] Here, a specific example of the process executed by the product management device 100 will be described with reference to FIGS.

[0034] When a transaction is concluded with a customer, order information is entered into order input screen MA-1, an example of which is shown in Fig. 2, and order data 106a, an example of which is shown in Fig. 4, is created. Orders for new construction work may include multiple identical products, in which case one order is assigned one serial number, and multiple products included in one order are given the same serial number. The quantity in order data 106a indicates the number of products included in one order number (one serial number).

[0035] When the order information is entered on the order input screen MA-1 and the serial button on the screen is pressed, the serial data creation unit 102a assigns a serial number to each product to identify the product, as shown on the order input screen MA-2. When the serial number assignment is confirmed and the order data is registered, the serial data creation unit 102a creates serial data 106b that links the order number, manufacturing number, and serial number. FIG. 3 is a diagram showing the relationship between the manufacturing number and the serial number, and FIG. 5 is an example of the serial data 106b. As shown in FIGS. 3 and 5, "FQ0001" is assigned as the manufacturing number of a new construction to the order number "JUC00001", and the manufacturing number "FQ0001" is assigned to the five products included in the order number "JUC00001", and the serial numbers "001", "002", "003", "004", and "005" are assigned individually. The serial numbers are not only written on the data, but are also stamped on each product.

[0036] Thereafter, when an order is placed for repair or modification of a sold product, order data 106a', an example of which is shown in FIG. 7, is created by inputting order information for the repair or modification into order input screen MA-1', an example of which is shown in FIG. 6. The serial number is also assigned as the repair serial number, "FA0001." Furthermore, in the case of orders for modification, the order category is "2." When order category "2" is selected, pressing the serial button transitions to order input screen MA-2', but the serial number is not automatically assigned by serial data creation unit 102a, and the operator enters the serial number included in the order information.

[0037] When the serial number of the product to be repaired or modified is entered and confirmed on the order input screen MA-2', the serial data creation unit 102a creates serial data 106b' that links the order number and reference number to the serial number. Figure 8 is an example of the serial data 106b'. In the serial data 106b', the order number "JUC00002" is linked to the original production number "FQ0001", and an order has been placed for repairs of serial numbers "003" and "004".

[0038] After receiving an order for repair or modification, the person in charge of the repair department inputs the details of the repair or modification into the repair arrangement input screen, an example of which is shown in Figure 9, either at the preliminary estimate stage or at the post-repair stage, and then finalizes and registers the details of the repair or modification. On the repair arrangement screen MB, inputting the repair model number outputs information such as the model number and serial number entered on the order input screen MA-2 (serial data 106b'), but when repairing multiple parts for one product, the details of the repair arrangement are entered for each part.

[0039] When the repair arrangement is confirmed, the part number code of the part to be repaired is obtained from the part number master 106d, an example of which is shown in Fig. 11, and repair arrangement data 106c is created that links the repair model number, manufacturing number, serial number, repair part name, part number code, and repair content. Fig. 10 is an example of repair arrangement data 106c.

[0040] When the repair history of a product created and stored as described above is to be checked, it is done via a repair history inquiry screen, an example of which is shown in FIG. 12. In the repair history inquiry screen MC-1, a serial number is input and the column of unrepaired serial numbers is selected. The repair history extraction unit 102c extracts information on the product having the input serial number from, for example, the order data 106a'', serial data 106b'', and repair arrangement data 106c'' shown in FIG. 13, and outputs the information for each target part at the bottom of the repair history inquiry screen MC-1. FIG. 12 shows an example of the order data 106a'', serial data 106b'', and repair arrangement data 106c'' created based on multiple orders and stored in the storage unit 106.

[0041] When the operator selects and clicks a part for which he / she wishes to check the repair history on the repair history inquiry screen MC-1, the repair history extraction unit 102c outputs the repair history of the selected part, as shown in an example in the repair history inquiry screen MC-2. The repair history inquiry screen MC-2 shows the repair history of part A selected on the repair history inquiry screen MC-1. Since the unrepaired serial number is also selected on the repair history inquiry screen MC-1, information such as the serial number, shipping date, number of repairs, repair contents, and repair date is output for unrepaired products with the same manufacturing number as well as for repaired products. If the unrepaired serial number is not selected on the repair history inquiry screen MC-1, information such as the serial number, shipping date, number of repairs, repair contents, and repair date is output only for repaired products, without output for unrepaired products with the same manufacturing number.

[0042] In addition, in the above, the repair history extraction unit 102c extracts the repair history based on the manufacturing number, but this is not limited to this. It is also possible to specify the repair part on the repair history inquiry screen MC-1, extract and output the repaired product that has that part by serial number.

[0043] Furthermore, by selecting the "Expiration Date Exceeded" field on the repair history inquiry screen MC-1, products whose parts stored in the product number master 106d have expired can be output by serial number. When the "Expiration Date Exceeded" field is selected on the repair history inquiry screen MC-1, the repair history extraction unit 102c obtains the shipping date of each product from the order data 106a, determines for each part whether the number of days since the shipping date is within the expiration date in the product number master 106d, and outputs products whose parts have expired by their serial numbers.

[0044] The product management device 100 according to the present embodiment can easily check the repair history of each product by assigning an identifying serial number to multiple products having the same manufacturing number. The product management device 100 according to the present embodiment can also predict the repair of products that have not been repaired, and can easily make routine proposals for repairs.

[0045] [3. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.

[0046] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0047] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

[0048] [4. Other embodiments] The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0049] 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 using known methods.

[0050] In addition, 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 drawings may be changed as desired unless otherwise specified.

[0051] Furthermore, with regard to the product management device 100, each of the components shown in the figures is merely a functional concept, and does not necessarily have to be physically configured as shown in the figures.

[0052] For example, the processing functions of the product management device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the product management device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.

[0053] In addition, this computer program may be stored in an application program server connected to the product management device 100 via any network, and it is also possible to download all or part of it as necessary.

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

[0055] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.

[0056] The various databases etc. stored in the memory unit are storage means such as 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 etc. used for various processes and providing websites.

[0057] The product management device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The product management device 100 may be realized by installing software (including programs, data, etc.) that causes the device to realize the processes described in this embodiment.

[0058] Furthermore, the specific form of 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 any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]

[0059] The present invention is useful for companies that manufacture and sell products based on individual orders. [Explanation of symbols]

[0060] 100 Product management equipment 102 Control section 102a Serial data creation section 102b Repair Arrangement Data Creation Department 102c Repair history extraction section 104 Communication interface section 106 Storage section 106a Order Data 106b Serial Data 106c Repair order data 106d Part Number Master 106e Scheduled recovery data 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. A product management device including a control unit, Order data that stores order information including order number, customer, order type, quantity, serial number, and shipping date; A part number master that stores part number codes, part number names, and expiration dates of the part numbers; is accessible to The control unit is a serial data creation unit that, in an order in which one manufacturing number is assigned to a plurality of products, assigns serial numbers that identify the plurality of products and creates serial data linked to the order number and the manufacturing number; a repair arrangement data creation unit that creates repair arrangement data that links the repair product number with a manufacturing number, a serial number, a repair part name, a part number code, and a repair content when a repair order is placed for at least some of a plurality of products to which serial numbers are assigned; a repair history extraction unit that extracts and outputs repair histories on a serial number basis in response to a request via a repair history inquiry screen; A product management device comprising:

2. 2. The product management device according to claim 1, wherein the repair history extraction unit refers to the order data, the serial data, and the repair arrangement data, extracts post-repair product information for products with a specified manufacturing number on a serial number basis, and outputs the product information together with the repair history.

3. 3. The product management device according to claim 2, wherein the repair history extraction unit also extracts unrepaired products having the same serial number as the repaired product, on a serial number basis.

4. 2. The product management device according to claim 1, wherein the repair history extraction unit refers to the order data, the serial data, and the repair arrangement data to extract, on a serial number basis, post-repair product information having specified parts, and outputs the product information together with the repair history.

5. 2. The product management device according to claim 1, wherein the repair history extraction unit obtains a shipping date for a specified serial number from the order data, determines for each part whether the number of days elapsed since the shipping date is within the expiration date in the part number master, and outputs products that have exceeded their expiration date by serial number.

6. A product management method executed by a product management device having a control unit, The product management device includes: Order data that stores order information including order number, customer, order type, quantity, serial number, and shipping date; A part number master that stores part number codes, part number names, and expiration dates of the part numbers; is accessible to Executed by the control unit, a serial data creation step of creating serial data linked to the order number and the serial number by assigning serial numbers that identify the multiple products in an order in which one serial number is assigned to multiple products; a repair arrangement data creation step of creating repair arrangement data that links the repair product number with the manufacturing number, the serial number, the name of the repair part, the part number code, and the repair content when a repair order is placed for at least some of the products to which serial numbers are assigned; a repair history extraction step of extracting and outputting a repair history on a serial number basis from the repair arrangement data in response to a designation made via a repair history inquiry screen; A product management method comprising:

7. A product management program executed by a product management device having a control unit, The product management device includes: Order data that stores order information including order number, customer, order type, quantity, serial number, and shipping date; A part number master that stores part number codes, part number names, and expiration dates of the part numbers; is accessible to The control unit, a serial data creation step of creating serial data linked to the order number and the serial number by assigning serial numbers that identify the multiple products in an order in which one serial number is assigned to multiple products; a repair arrangement data creation step of creating repair arrangement data that links the repair product number with the manufacturing number, the serial number, the name of the repair part, the part number code, and the repair content when a repair order is placed for at least some of the products to which serial numbers are assigned; a repair history extraction step of extracting and outputting a repair history on a serial number basis from the repair arrangement data in response to a designation made via a repair history inquiry screen; Product management program to implement.

Images