JP2022102910A - Inspection management device, inspection management method, and inspection management program - Google Patents

Abstract

To improve work efficiency in allocating the most suitable lot(s) of stock to each destination which is a combination of a client and a delivery destination when using different inspection standards for different destinations.SOLUTION: An inspection management device according to an embodiment includes: first master data which consists of inspection patterns each of which has been registered for a destination which is a combination of a client and a delivery destination and a product; second master data which consists of inspection standard values for multiple inspection items which have been registered for the respective inspection patterns; received-order input means with which received-order information including a destination, a product, and a scheduled shipping quantity is inputted; and stock allocation means which, when allocating stock for the received order, obtains an inspection pattern from the first master data using the destination and the product in the received-order information as keys, obtains inspection standard values for multiple inspection items from the second master data using the obtained inspection pattern as a key, and allocates a lot(s) whose inspection result(s) meets/meet the inspection standard values of the inspection items which have been obtained, out of candidate products in stock/inspection information.SELECTED DRAWING: Figure 1

Description

The present invention relates to an inspection control device, an inspection management method, and an inspection management program.

For example, a chemical manufacturer may use a different inspection standard for each destination, which is a combination of a customer and a delivery destination, in addition to the inspection standard determined in-house. Inspection standards for each destination are set when concluding a transaction contract, and products that do not meet the conditions cannot be shipped. As a system related to product inspection, for example, there is Patent Document 1.

Japanese Unexamined Patent Publication No. 2013-134560

However, in the above-mentioned Patent Document 1, when different inspection standards are used for each destination, which is a combination of a customer and a delivery destination, there is nothing about improving the work efficiency when allocating the optimum lot inventory for each destination. Not listed.

The present invention has been made in view of the above, and is a work in which the optimum lot inventory is allocated to each destination when different inspection standards are used for each destination, which is a combination of the customer and the delivery destination. It is an object of the present invention to provide an inspection control device, an inspection management method, and an inspection management program capable of improving efficiency.

In order to solve the above-mentioned problems and achieve the object, the present invention is an inspection management device including a control unit and a storage unit, and the storage unit is a destination that is a combination of a customer and a delivery destination. A first master in which inspection patterns are registered for each product and each product, a second master in which inspection standard values of a plurality of inspection items are registered for each inspection pattern, and a plurality of stocks for each product lot. Inventory / inspection information including the inspection result of the inspection item of the above is stored, and the control unit is an order input means for inputting order information including a destination, a product, and a planned number of shipments, and inventory allocation of an order. The inspection standard of a plurality of inspection items is acquired from the first master using the destination of the order information and the product as a key, and the acquired inspection pattern is used as a key. It is characterized by having an inventory allocation means for acquiring a value and allocating a lot whose inspection result meets the inspection standard value of the acquired inspection item for the product subject to inventory / inspection information.

Further, according to one aspect of the present invention, the first master includes important inspection items that define priorities among inspection items for each destination and each product, which is a combination of a customer and a delivery destination. When the information is registered and the inventory allocation means has a plurality of lots satisfying the inspection standard value, the lot may be allocated according to the priority among the inspection items of the important inspection item information.

Further, according to one aspect of the present invention, the important inspection item information further defines the priority within the inspection item, and the inventory allocation means has a plurality of lots satisfying the inspection standard value. In this case, lots may be assigned according to the priority among the inspection items of the important inspection item information and the priority within the inspection item.

Further, according to one aspect of the present invention, the priority may be set depending on whether the numerical value is large, the numerical value is small, the numerical value is close to the standard value, or the numerical value is far from the standard value.

Further, according to one aspect of the present invention, the inspection item may include a component of a substance.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is an inspection management method executed by an information processing apparatus including a control unit and a storage unit, and the storage unit includes a customer. A first master that registers inspection patterns for each destination and product, which is a combination of delivery destinations, a second master that registers inspection standard values for multiple inspection items for each inspection pattern, and products. For each lot, inventory / inspection information including the number of stocks and inspection results of a plurality of inspection items is stored, and order information including destinations, products, and planned shipment numbers executed by the control unit. When the order input process for inputting the order and the inventory allocation of the order are performed, the inspection pattern is acquired from the first master using the destination of the order information and the product as the key, and the acquired inspection pattern is used as the key. An inventory allocation process in which inspection standard values for multiple inspection items are acquired from the second master, and lots whose inspection results meet the inspection standard values for the acquired inspection items are assigned to the products subject to inventory / inspection information. , May be included.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is an inspection management program for causing an information processing apparatus provided with a control unit and a storage unit to execute, and the storage unit is good at it. A first master that registers inspection patterns for each destination and product that is a combination of destinations and delivery destinations, a second master that registers inspection standard values for multiple inspection items for each inspection pattern, and products. For each lot, inventory / inspection information including the number of stocks and inspection results of a plurality of inspection items is stored, and in the control unit, order information including destinations, products, and planned shipment numbers is input. When the order input process and the inventory allocation of the order are performed, the inspection pattern is acquired from the first master by using the destination and the product of the order information as the key, and the acquired inspection pattern is used as the key to the second. An inventory allocation process that acquires inspection standard values for multiple inspection items from the master and allocates lots whose inspection results meet the inspection standard values for the acquired inspection items for the products subject to inventory / inspection information. It is characterized by being an inspection management program for execution.

According to the present invention, when different inspection standards are used for each destination, which is a combination of a customer and a delivery destination, it is possible to improve the work efficiency when allocating the optimum lot inventory for each destination. It plays the effect.

FIG. 1 is a block diagram showing an example of the configuration of the inspection management device according to the present embodiment. FIG. 2 is a diagram showing a flow for explaining an example of the entire processing procedure of the control unit of the inspection management device according to the present embodiment. FIG. 3 is a diagram for explaining a specific example of processing of the control unit of the inspection management device according to the present embodiment. FIG. 4 is a diagram for explaining a specific example of processing of the control unit of the inspection management device according to the present embodiment. FIG. 5 is a diagram for explaining a specific example of processing of the control unit of the inspection management device according to the present embodiment. FIG. 6 is a diagram for explaining a specific example of processing of the control unit of the inspection management device according to the present embodiment.

Hereinafter, embodiments of an inspection management device, an inspection management method, and an inspection management program according to the present invention will be described in detail with reference to the drawings. The present invention is not limited to this embodiment.

[1. Overview]
For example, a chemical manufacturer may use a different inspection standard for each destination, which is a combination of a customer and a delivery destination, in addition to the inspection standard determined in-house. Inspection standards for each destination are set when concluding a transaction contract, and products that do not meet the conditions cannot be shipped. In addition, some of the inspection items should be emphasized, and they are treated as points to be noted at the time of allocation.

Specifically, for example, with regard to destinations, even if the customer with whom the transaction is made is the same, the place (delivery destination) where the product is delivered may be different, and different inspection standards may be used for each destination. .. For example, if the customer is "○○ Shoji" and the delivery destination is "△△ sales office", "□□ branch office", "XX warehouse", etc., and different inspection standards are used by each delivery destination. There is.

However, in the past, there was a lot of information to be judged and managed for inventory allocation processing, and it took time to select the optimum product lot for each destination. In addition, since it was done manually, there was a concern that work mistakes would occur.

Therefore, in the present embodiment, in the case of using different inspection standards for each destination, which is a combination of the customer and the delivery destination, in order to improve the work efficiency when allocating the optimum lot inventory for each destination. It determines whether it is the optimum product lot based on the inspection information, and automatically allocates inventory. Specifically, in this embodiment, (1) inventory that meets the inspection standards set for each destination is automatically allocated, and (2) the most important inspection items are listed. Automatically allocates inventory whose inspection values meet the requirements.

According to the present embodiment, it is possible to shorten the work time of the inventory allocation process when allocating the inventory of the optimum lot for each destination, and it is possible to improve the work efficiency. In addition, by reducing manual work, it is possible to reduce the possibility of mistakes and prevent erroneous shipment. As a result, it becomes possible to improve customer satisfaction.

This embodiment is widely applicable to the field of inspecting produced products, and is applicable to various industries such as chemical products (including intermediate products and finished products), food products, cosmetics, and pharmaceutical products.

Hereinafter, a specific configuration and operation will be described.

[2. Constitution]
The configuration of the inspection management device 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the inspection management device 100.

The inspection management device 100 is a commercially available desktop personal computer. The inspection management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable type such as a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, or a tablet personal computer. It may be an information processing device.

As shown in FIG. 1, the inspection 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 inspection management device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the inspection management device 100 to the network 300 so as to be communicable 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 another device via a communication line. Here, the network 300 has a function of connecting the inspection management device 100 and the server 200 so as to be communicable with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like. The data stored in the storage unit 106, which will be described later, may be stored in the server 200.

An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). As the input device 112, a keyboard, a mouse, and a microphone, as well as 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 referred to as a monitor 114, and the input device 112 may be described as a keyboard 112 or a mouse 112. Further, the “output” includes displaying on the monitor of the output device 114 and printing on the printer of the output device 114. Further, the user operating the information displayed on the monitor 114 with the input device 112 or the like may be described as "user operation via UI".

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. 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, an optical disk, or the like can be used.

The storage unit 106 includes a delivery condition master 106a, an inspection pattern master 106b, and a data file 106c.

The delivery condition master (first master) 106a is a master for registering inspection patterns and important inspection item information for each destination and each product, which is a combination of a customer and a delivery destination. The delivery condition master 106a is a destination (customer, delivery destination), product, inspection pattern, important inspection item information (important inspection item 1, priority 1, standard value 1, important inspection item 2, priority 2, standard value). 2. It can be composed of a table or the like registered in association with data such as important inspection item 3, priority 3, standard value 3, ...) (See FIG. 4). Important inspection item information defines the priority between inspection items and the priority within the inspection item. The order of priority is higher in the order of important inspection item 1> important inspection item 2> important inspection item 3> .... The priority can be set to "0: large numerical value", "1: small numerical value", "2: close to the standard value", "3: far from the standard value", and the like.

The inspection pattern master (second master) 106b is a master for registering a plurality of inspection items constituting the inspection pattern and inspection standard values of each inspection item for each inspection pattern. The inspection pattern master (second master) 106b can be composed of a table or the like in which data such as serial numbers, inspection items, and inspection standard values are registered in association with each inspection pattern (see FIG. 4).

The data file 106c is a file for storing various data such as order information and inventory / inspection information.

The inspection information may include data such as a product, a lot number, an inventory quantity (Kg), a manufacturing date, and an inspection result of each inspection item (see FIG. 5).

The order information may include data such as an order number, a customer, a delivery destination, a shipping date, a product, and a planned shipping quantity (see FIG. 5).

The control unit 102 is a CPU or the like that comprehensively controls the inspection management device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run. The control unit 102 functionally includes an inspection result input unit 102a, an inventory management unit 102b, an order input unit 102c, an inventory allocation unit 102d, a master maintenance unit 102e, and a screen display control unit 102f.

The inspection result input unit 102a is an inspection result data which is an inspection result of a plurality of inspection items for each lot of the planned and produced products in response to an operator's operation on the input screen displayed on the monitor 114, for example. Enter.

The inventory management unit 102b, for example, responds to an operator's operation on an input screen (not shown) displayed on the monitor 114, and adds inspection record data corresponding to the inventory information to the data table 105c for inventory / inspection. Register and update information.

The order input unit 102c inputs order information and registers it in the data file 106c, for example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114.

The inventory allocation unit 102d acquires inspection patterns and important inspection item information from the master of the delivery condition master 106a using the destination of the order information and the product as the key when allocating the inventory of the order, and uses the acquired inspection pattern as the key. As a result, inspection standard values of a plurality of inspection items are acquired from the inspection pattern master 106b, and lots whose inspection results satisfy the inspection standard values of the acquired inspection items are assigned to the products subject to inventory / inspection information.

Further, when there are a plurality of lots satisfying the inspection standard value, the inventory allocation unit 102d may allocate lots according to the priority among the inspection items of the acquired important inspection item information.

Further, when there are a plurality of lots satisfying the inspection standard value, the inventory allocation unit 102d may allocate lots according to the priority among the inspection items of the important inspection item information and the priority within the inspection items. ..

The master maintenance unit 102e edits data input / addition / change to the delivery condition master 106a and the inspection pattern master 106b in response to an operator operation on a master maintenance screen (not shown) displayed on the monitor 112, for example. Is for doing.

The screen display control unit 102f controls, for example, the display of various screens (for example, an input screen, a master maintenance screen, etc.) displayed on the monitor 112 and the reception of the input thereof.

[3. Concrete example]
A specific example of the processing of the inspection management device 100 according to the present embodiment will be described with reference to FIGS. 1 to 6. FIG. 2 is a diagram showing a flow for explaining the overall processing flow of the control unit 102 of the inspection management device 100 according to the present embodiment. 3 to 6 are diagrams for explaining a specific example of processing of the control unit of the inspection management device 100 according to the present embodiment.

(Overall processing)
With reference to FIG. 2, the overall processing flow of the control unit 102 of the inspection management device 100 according to the present embodiment will be described. In FIG. 2, the master maintenance unit 102e executes the master maintenance process (step S1). Specifically, in the master maintenance process, the master maintenance unit 102e sets the delivery condition master 106a and the inspection pattern master 106b, for example, in response to an operator operation on a master maintenance screen (not shown) displayed on the monitor 112. Set the data for it.

The inspection result input unit 102a executes the inspection result input process (step S2). Specifically, in the inspection information input process, the inspection result input unit 102a is in-house for each lot of planned and produced products in response to an operator's operation on the input screen displayed on the monitor 114, for example. Enter the inspection record data that is the inspection result of multiple inspection items determined in. The input inspection record data is added to the inventory information by the inventory management unit 102b and registered in the data file 106c as inventory / inspection information.

The order input unit 102c executes an order input process (step S3). Specifically, in the order input process, the order input unit 102c inputs order information in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and inputs the order information to the data file 106c. sign up.

The inventory allocation unit 102d executes the inventory allocation process (step S4). Specifically, in the inventory allocation process, when inventory allocation of an order is made, the inventory allocation unit 102d uses the destination of the order information and the product as a key, and the inspection pattern and important inspection item information from the master of the delivery condition master 106a. , And using the acquired inspection pattern as a key, the inspection standard values of multiple inspection items are acquired from the inspection pattern master 106b, and the inspection results of the products subject to inventory / inspection information are the inspection standards of the acquired inspection items. Allocate lots that meet the value. Further, when there are a plurality of lots satisfying the inspection standard value, the inventory allocation unit 102d may allocate lots according to the priority among the inspection items of the important inspection item information and the priority within the inspection items. ..

Next, a specific example of the processing of the control unit 102 of the inspection management device 100 according to the present embodiment will be described with reference to FIGS. 3 to 6.

(Master maintenance processing)
The master maintenance unit 102e sets data for the delivery condition master 106a and the inspection pattern master 106b according to the operation of the operator on the master maintenance screen (not shown) displayed on the monitor 112, for example. FIG. 3 is a diagram for explaining the delivery condition master 106a and the inspection pattern master 106b. FIG. 4 is a diagram showing an example of data setting of the delivery condition master 106a and the inspection pattern master 106b.

In FIGS. 3 and 4, in the delivery condition master 106a, "target inspection patterns" are registered for each destination (customer, delivery destination) and each product. In addition, important inspection item information that is important at the time of inventory allocation is registered in the delivery condition master 106a. The delivery condition master 106a and the inspection pattern master 106b are associated with each other by an inspection pattern. In the example shown in FIG. 4, the delivery condition master 106a and the inspection pattern master 106b are associated with each other by the inspection pattern “APX001”. By setting the inspection pattern for each destination (customer, delivery destination) / product, it is possible to set the inspection standard value of the inspection item for each destination (customer, delivery destination) / product.

The delivery condition master 106a is a destination (customer, delivery destination), product, inspection pattern, important inspection item information (important inspection item 1, priority 1, standard value 1, important inspection item 2, priority 2, standard value). 2. Data such as important inspection item 3, priority 3, standard value 3, ...) Are set. Important inspection item information defines the priority between inspection items and the priority within the inspection item. The order of priority is higher in the order of important inspection item 1> important inspection item 2> important inspection item 3> .... Here, up to three priorities are specified, but four or more may be specified. The priority can be set to "0: large numerical value", "1: small numerical value", "2: close to the standard value", "3: far from the standard value", and the like.

In the example of the delivery condition master 106a shown in FIG. 4A, the customer “A Shoji”, the delivery destination “P warehouse”, the product “X product”, the inspection pattern “APX001”, and the important inspection item information ( Important inspection item 1 "copper", priority 1 "large numerical value", important inspection item 2 "calcium", priority 2 "large numerical value", important inspection item 3 "chlorine", priority 3 "close to standard value" , The standard value is 3 "5.5"). In this example, the order of priority of the inspection items is copper> calcium> chlorine. The priority of "copper" is high for "large numerical value", the priority of "calcium" is high for "large numerical value", and the priority of "chlorine" is from "standard value" 5.5 ". Those that are "close" are getting higher.

In the inspection pattern master (second master) 106b, data such as serial numbers, inspection items, and inspection standard values are set for each inspection pattern. In the example of the inspection pattern master 106b shown in FIG. 4B, for the inspection pattern “APX001”, the first line is the serial number “1”, the inspection item “copper”, and the inspection standard value “62.3”. % Or more ", the second line is the serial number" 2 ", the inspection item" calcium ", the inspection standard value" 10.24% or more ", the third line is the serial number" 3 ", the inspection item" chlorine ", the inspection Standard value "4.5% or more and 7.3% or less", 4th line is serial number "4", inspection item "arsenic", inspection standard value "0.30% or less", 5th line is serial number "5", inspection item "lead", inspection standard value "2.0% or more and 2.3% or less", 6th line is serial number "6", inspection item "sodium", inspection standard value "0.05" % Or more. " Here, the inspection item is a component of the substance, but other inspection items may be used.

(Inventory allocation processing)
The inventory allocation unit 102d acquires inspection patterns and important inspection item information from the delivery condition master 106a using the destination of order information and products as keys when allocating inventory for orders, and uses the acquired inspection patterns as keys. The inspection standard values of multiple inspection items are acquired from the inspection pattern master 106b, and for the products subject to inventory / inspection information, lots whose inspection results satisfy the inspection standard values of the acquired inspection items are assigned and the inspection standard values are assigned. If there are multiple lots that satisfy the above conditions, lots are assigned according to the priority among the inspection items of the important inspection item information and the priority within the inspection items. If the inventory allocation is not determined even with the important inspection item information, it may be determined by the manufacturing date (for example, it may be allocated by first-in first-out).

FIG. 5A shows an example of order information. In the example of the order information shown in FIG. 5 (A), the order number "JUCHUU000001", the customer "A Shoji", the delivery destination "P warehouse", the shipping date "2020/10/30", the product "Product X", and the shipping. The planned quantity is "200.000".

FIG. 5B shows an example of the delivery condition master 106a, which is the same data as in FIG. 4A.

FIG. 5C shows an example of the inspection pattern master 106b, which is the same data as in FIG. 4B.

FIG. 6D shows an example of inventory / inspection information. In the example of inventory / inspection information shown in FIG. 6D, the first column shows the lot number “202008151-1”, the number of stocks (Kg) “150”, the manufacturing date “2020/8/15”, and the inspection result ( Copper "62.0", calcium "12.33", chlorine "4.2", arsenic "0.2", lead "1.95", sodium "0.07"), the second row is the lot number "20200815-2", quantity in stock (Kg) "200", date of manufacture "2020/8/15", inspection results (copper "64.2", calcium "11.34", chlorine "4.7", lead "0.24", lead "12.04", sodium "0.08").

The third column shows the lot number "20200925-1", the number of stocks (Kg) "75", the date of manufacture "2020/9/25", the inspection results (copper "65.4", calcium "12.51", chlorine. "5.0", arsenic "0.25", lead "2.02", sodium "0.09"), the fourth row is the lot number "202009288-1", the number of stocks (Kg) "150", Date of manufacture "2020/9/28", test results (copper "66.1", calcium "12.78", chlorine "5.3", arsenic "0.18", lead "2.1", sodium " 0.06 ").

The fifth column shows the lot number "202009228-2", the number of stocks (Kg) "80", the date of manufacture "2020/9/28", the inspection results (copper "65.8", calcium "11.90", chlorine). "6.5", arsenic "0.31", lead "2.2", sodium "0.07"), the sixth column is the lot number "202001001-1", the number of stocks (Kg) "110", Date of manufacture "2020/10/1", test results (copper "66.1", calcium "12.1", chlorine "5.4", arsenic "0.28", lead "2.1", sodium " 0.07 ").

In the 7th column, lot number "202001001-2", number of stocks (Kg) "300", date of manufacture "2020/10/1", inspection results (copper "66.1", calcium "12.78", chlorine "6.1", arsenic "0.15", lead "2.1", sodium "0.08"), lot number "202001001-3" in the 8th column, stock quantity (Kg) "280", Date of manufacture "2020/10/1", test results (copper "62.9", calcium "11.90", chlorine "4.8", arsenic "0.14", lead "2.1", sodium " 0.09 ").

The inventory allocation unit 102d inspects from the delivery condition master 106a using the destination of the order information (customer "A trading", delivery destination "P warehouse") and the product "product X" as keys when allocating the order. The pattern "AP-X001" and important inspection item information are acquired, and the inspection standard value of the inspection item is acquired from the inspection pattern master 106b using the acquired inspection pattern as a key. For the products subject to inventory / inspection information, the lots that meet the inspection standard values of the acquired inspection items are lot numbers "20200815-2", "20200925-1", "202009218-1", and "2020001-1". , "20201001-2", "20201001-3". Since multiple lots meet the inspection standard values of inspection items, the inventory to be allocated is determined according to the priority of important inspection item information.

The order of priority of inspection item information is important inspection item 1 "copper", priority 1 "large numerical value"> important inspection item 2 "calcium", priority 2 "large numerical value"> important inspection item 3 "chlorine", Priority 3 is "close to the standard value" and standard value 3 is "5.5". Regarding the important inspection item 1 "copper" and priority 1 "large numerical value", the three lots of lot numbers "20200928-1", "20200011-1", and "20201001-2" are copper "66.1". And the number is getting bigger.

Next, regarding the important inspection item 2 "calcium" and the priority 2 "large numerical value", the two lots of lot numbers "202009288-1" and "20201001-2" have calcium "12.78". The numbers are getting bigger. Furthermore, for the important inspection item 3 "chlorine", priority 3 "close to the standard value", and standard value 3 "5.5", the lot number "202009218-1" is chlorine from the lot number "2020001-2". At "5.3", the value is close to the standard value of 3 "5.5". Therefore, the priority of inventory allocation is lot number "20200928-1"> "20201001-2"> "2020001-1".

Since the planned shipment quantity of the inventory allocation unit 102d is "200", the quantity "150" of the lot number "202009288-1" and the quantity "50" of the lot number "20201001-2" are taken into consideration in consideration of the inventory quantity. To allocate.

As described above, according to the present embodiment, the delivery condition master (first master) 106a in which the inspection pattern is registered and the inspection pattern for each destination and each product, which is a combination of the customer and the delivery destination, and the inspection pattern. An inspection pattern master (second master) 106b that registers inspection standard values for multiple inspection items, an order input unit 102c that inputs order information including destinations, products, and planned shipments, and inventory of orders. When making an allocation, the inspection pattern is acquired from the delivery condition master 106a using the destination of the order information and the product as the key, and the inspection standard values of multiple inspection items are obtained from the inspection pattern master 106b using the acquired inspection pattern as the key. For the products to be acquired and subject to inventory / inspection information, the inventory allocation unit 102d, which allocates lots whose inspection results meet the inspection standard values of the acquired inspection items, is provided. When different inspection standards are used for each destination, which is a combination, it is possible to improve the work efficiency when allocating the optimum lot inventory for each destination.

[4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)]
Since this embodiment can contribute to improving business efficiency and promoting appropriate management decisions of companies, it is possible to contribute to the goals 8 and 9 of the SDGs.

In addition, the present embodiment can contribute to the reduction of waste loss and the promotion of paperless and digitization, and thus can contribute to the goals 12, 13 and 15 of the SDGs.

In addition, since this embodiment can contribute to the strengthening of control and governance, it is possible to contribute to the goal 16 of the SDGs.

[5. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the standards of the technical idea described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed may be performed manually, or all the processes described as being performed manually may be performed. Alternatively, a part can be automatically performed by a known method.

In addition, processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in this specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the inspection management device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the inspection management device 100, particularly each processing function performed by the control unit 102, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and the inspection management apparatus is required. Read mechanically to 100. 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 an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form a control unit.

Further, this computer program may be stored in an application program server connected to the inspection management device 100 via an arbitrary network, and all or a part thereof can be downloaded as needed. be.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes 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), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disc), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium and the installation procedure after reading in each device shown in the embodiment.

Various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the inspection 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 inspection management device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

Furthermore, the specific form of distribution / integration of the device is not limited to that shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

100 Inspection management device 102 Control unit 102a Inspection result input unit 102b Inventory management unit 102c Order input unit 102d Stock allocation unit 102e Master maintenance unit 102f Screen display control unit 104 Communication interface unit 106 Storage unit 106a Delivery condition master 106b Inspection pattern master 106c Data File 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (7)

An inspection management device equipped with a control unit and a storage unit.
In the storage unit
The first master that registered the inspection pattern for each destination and product that is a combination of customer and delivery destination,
A second master that registers inspection standard values for multiple inspection items for each inspection pattern,
Inventory / inspection information including the number of stocks and inspection results of multiple inspection items for each lot of products,
Is stored,
The control unit
An order input method for inputting order information including destination, product, and planned number of shipments,
When allocating inventory for orders, an inspection pattern is acquired from the first master using the destination and product of the order information as a key, and a plurality of inspections are performed from the second master using the acquired inspection pattern as a key. Inventory allocation means for acquiring the inspection standard value of the item and allocating the lot whose inspection result meets the inspection standard value of the acquired inspection item for the product subject to inventory / inspection information.
An inspection management device characterized by being equipped with. In the first master, important inspection item information that defines priorities among inspection items is registered for each destination and product that is a combination of a customer and a delivery destination.
The inspection management according to claim 1, wherein the inventory allocation means allocates lots according to the priority among inspection items of important inspection item information when there are a plurality of lots satisfying the inspection standard value. Device. The important inspection item information further defines the priority within the inspection item.
When there are a plurality of lots satisfying the inspection standard value, the inventory allocation means allocates lots according to the priority among inspection items of important inspection item information and the priority within the inspection item. Item 2. The inspection management device according to item 2. The inspection management device according to claim 3, wherein the priority is set by a large numerical value, a small numerical value, a value close to a standard value, or a value far from the standard value. The inspection management device according to any one of claims 1 to 4, wherein the inspection item contains a component of a substance. It is an inspection management method executed by an information processing device equipped with a control unit and a storage unit.
In the storage unit
The first master that registered the inspection pattern for each destination and product that is a combination of customer and delivery destination,
A second master that registers inspection standard values for multiple inspection items for each inspection pattern,
Inventory / inspection information including the number of stocks and inspection results of multiple inspection items for each lot of products,
Is stored,
Executed in the control unit,
An order entry process for entering order information including destinations, products, and planned number of shipments,
When allocating inventory for orders, an inspection pattern is acquired from the first master using the destination and product of the order information as a key, and a plurality of inspections are performed from the second master using the acquired inspection pattern as a key. An inventory allocation process that acquires inspection standard values for items and allocates lots whose inspection results meet the inspection standard values for the acquired inspection items for the products subject to inventory / inspection information.
An inspection management method characterized by including. It is an inspection management program to be executed by an information processing device equipped with a control unit and a storage unit.
In the storage unit
The first master that registered the inspection pattern for each destination and product that is a combination of customer and delivery destination,
A second master that registers inspection standard values for multiple inspection items for each inspection pattern,
Inventory / inspection information including the number of stocks and inspection results of multiple inspection items for each lot of products,
Is stored,
In the control unit
An order entry process for entering order information including destinations, products, and planned number of shipments,
When allocating inventory for orders, an inspection pattern is acquired from the first master using the destination and product of the order information as a key, and a plurality of inspections are performed from the second master using the acquired inspection pattern as a key. An inventory allocation process that acquires inspection standard values for items and allocates lots whose inspection results meet the inspection standard values for the acquired inspection items for the products subject to inventory / inspection information.
Inspection management program to execute.

Images