JP2006155174A - Inspection management device, inspection management system, inspection management method and inspection management program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To realize an inspection management linked with an ERP (enterprise resource planning) package. <P>SOLUTION: An inspection reference master 31 associates an inspection type and inspection items of the inspection management device 2 with an inspection object product and a schedule type of an ERP management device 4. According to this, inspection schedule data to the inspection management device 2 can be generated from schedule data of the ERP package. An after-processing means 24 performs correspondence of a stock state of the ERP package based on a propriety determination result of the inspection management device 2 by use of a stock state correspondence table 34, and determines the place of a moving destination based on the stock state and place of lot stock by use of a moving destination determination table 35. According to this, stock transaction data of ERP can be generated based on the propriety result of the inspection management device 2. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to an inspection management apparatus and the like that can be linked to an ERP (Enterprise Resource Planning) package.

  The inspection management system manages inspection result data and pass / fail results for inspection items. In recent years, with the improvement of consumer quality awareness, quality management requirements to be dealt with by companies have expanded, and the amount of data to be handled by inspection management systems has also increased. FIG. 9 is a block diagram showing a conventional inspection management system. Hereinafter, description will be given based on this drawing.

  A conventional inspection management system 100 includes an activation unit 101 that activates an inspection management apparatus 102, an inspection management apparatus 102 that manages inspection data, an inspection storage apparatus 103 that stores data, and the like. The inspection management apparatus 102 includes an instruction input unit 121, a result input unit 122, a pass / fail determination unit 123, and the like. The inspection storage device 103 includes an inspection reference master 131, inspection instruction data 132, inspection result data 133, and the like.

  First, user information and connection information with a storage device are received from the activation unit 101, and the inspection management apparatus 102 is activated. The instruction input unit 121 receives information such as an inspection item and a scheduled inspection date from the user, and creates inspection instruction data 132 based on the inspection standard master 131. The result input unit 122 receives an inspection result value for each inspection item from the user, and creates inspection result data 133 for the inspection instruction data 132. The pass / fail determination means 123 matches the inspection result data 133 and the inspection reference master 131, and determines whether the inspection result data is acceptable, rejected, or other state.

  On the other hand, the use of an ERP package that centrally manages operations such as inventory, production, purchase, sales, and accounting in a company's core business is rapidly progressing (for example, Patent Document 1).

JP 2002-32436 A

  In view of the above background, there is a demand for an inspection management system that can be automatically linked with the ERP package. However, when trying to link a conventional inspection management system with an ERP package, there are the following two problems.

  The first problem is that it is necessary to generate appropriate inspection instruction information in the inspection management system in accordance with various schedule information in the ERP package. First, in the ERP package, there are various schedule information such as raw material acceptance schedule, intermediate product production schedule, product receipt schedule, and product production receipt. On the other hand, in the inspection management system, there are inspection types such as all lot inspection of raw materials, in-process inspection of intermediate products, inspection of all lots of products, monthly management inspection of products, etc. Need to manage.

  The second problem is that, although it is necessary to generate ERP package receipt / payment information based on the pass / fail determination result of the inspection management system, the inspection management system and the ERP package have different units of management. For example, even if it is rejected on inspection management, it may be treated as acceptable because it is shipped to a specific customer on the ERP package. For this reason, it has been difficult to automatically generate payment information on systems with different management levels.

  Therefore, an object of the present invention is to provide an inspection management apparatus and the like that can be linked to an ERP package.

  The inspection management apparatus according to the present invention includes an inspection reference master, an inventory status correspondence table, and a movement destination determination table. The inspection standard master indicates a correspondence relationship between the scheduled data regarding the inspection target item and the inspection instruction data including the inspection item and its pass / fail criterion. The inventory status correspondence table indicates a correspondence relationship between the pass / fail determination result of the inspection target item and the inventory status in the ERP package. The movement destination determination table shows a correspondence relationship between the stock status in the ERP package of the item to be inspected and the location of the movement destination. The inspection management apparatus according to the present invention inputs schedule data from the ERP management apparatus and inputs inspection result values from outside the inspection management apparatus, and these schedule data and inspection result values, as well as an inspection standard master, inventory status correspondence Based on the table and the movement destination determination table, there is provided means for creating inventory receipt / payment data and outputting it to the ERP management device.

  The operation of this inspection management apparatus will be described. First, when the scheduled data is input from the ERP management apparatus, the inspection instruction data can be created based on the inspection standard master that already exists. On the other hand, when an inspection result value is input from outside the inspection management apparatus, inspection result data including the input inspection result value can be created for each inspection item included in the created inspection instruction data. Then, the pass / fail of the inspection result data can be determined based on the prepared inspection result data and the pass / fail criteria included in the already-existing inspection reference master. Then, based on the pass / fail judgment result and the inventory status correspondence table that already exists, the inventory status in the ERP package can be obtained. Then, based on the inventory status and the destination determination table that already exists, the destination location can be obtained. In other words, the schedule data is input from the ERP management apparatus, the inventory receipt / payment data is created from the schedule data, and the inventory receipt / payment data is output to the ERP management apparatus, thereby enabling linkage with the ERP package.

  The inspection management apparatus according to the present invention includes an inspection reference master, an inventory status correspondence table, a movement destination determination table, a preprocessing unit, a result input unit, a pass / fail determination unit, a post-processing unit, and the like. The inspection standard master indicates a correspondence relationship between the scheduled data regarding the inspection target item and the inspection instruction data including the inspection item and its pass / fail criterion. The inventory status correspondence table indicates a correspondence relationship between the pass / fail determination result of the inspection target item and the inventory status in the ERP package. The movement destination determination table shows a correspondence relationship between the stock status in the ERP package of the item to be inspected and the location of the movement destination. The preprocessing means inputs schedule data from the ERP management apparatus and creates inspection instruction data based on the schedule data and the inspection reference master. The result input means inputs the inspection result value from outside the inspection management apparatus, and creates inspection result data composed of the inspection result value for each inspection item included in the inspection instruction data created by the preprocessing means. The pass / fail determination means determines pass / fail of the inspection result data based on the inspection result data created by the result input means and the pass / fail criteria included in the inspection reference master. The post-processing means creates inventory receipt / payment data based on the acceptance / rejection judgment result by the acceptance / rejection judgment means, the inventory status correspondence table and the movement destination determination table, and outputs the inventory receipt / payment data to the ERP management device.

  The inspection management apparatus according to the present invention may further include a difference management unit. The difference management means manages difference data to be added, updated, or deleted to the scheduled data already input from the ERP management apparatus. At this time, the preprocessing means inputs the difference data from the difference management means, and creates the minimum necessary inspection instruction data based on the difference data and the inspection reference master.

  An inspection management system according to the present invention includes an inspection management device according to the present invention, an ERP management device that outputs schedule data to the inspection management device and inputs inventory receipt / payment data from the inspection management device, an inspection standard master, and an inventory status correspondence table. And a test storage device for storing a destination determination table.

  The inspection management method according to the present invention expresses each means of the inspection management apparatus according to the present invention as a procedure. The inspection management program according to the present invention is for causing a computer to realize each means of the inspection management apparatus according to the present invention.

  Next, the present invention will be described once again in other words.

  There has been no “inspection management apparatus that can be linked to an ERP package” that solves the above-mentioned problems for general ERP packages. In the present invention, the following means are used to solve the problem. This is a feature of the present invention.

  First, by using an inspection standard master for associating the inspection target item and schedule information type of the ERP management apparatus with the inspection type and inspection item group of the inspection management apparatus, the ERP package can be associated with various schedule data. Inspection inspection data can be automatically selected and inspection schedule data to the inspection management device can be generated.

  Second, an inventory status correspondence table that associates the inspection management device with the inventory status of the ERP, pass / fail information of the inspection management device, and a destination determination table that associates the pass / fail judgment result of the inspection management device with the stock status of the ERP package. By using it, the destination location is determined from the inventory status and location of the inventory lot in the ERP package, thereby generating ERP inventory delivery data from the pass / fail result of the inspection management device.

  By this mechanism, it is possible to generate appropriate inspection schedule data in the inspection management apparatus from various schedule data of the ERP package, and to generate ERP inventory receipt / payment data from the pass / fail result of the inspection management apparatus. It becomes possible to realize inspection management linked to the.

  That is, the present invention generates inspection schedule data of the inspection management device from the ERP package schedule data, and generates ERP inventory receipt / payment data from the pass / fail result of the inspection management device, thereby enabling inspection that can be linked to the ERP package. A management device or the like is provided.

  According to the present invention, the inspection standard master indicating the correspondence relationship between the schedule data relating to the inspection target item and the inspection instruction data including the inspection item and the acceptance criterion thereof, the pass / fail judgment result of the inspection target item, and the stock status in the ERP package Prepared in advance, and a destination determination table indicating the correspondence between the inventory status of the item to be inspected in the ERP package and the location of the destination, and input planned data from the ERP management device At the same time, the actual inspection value is input from outside the inspection management device, and the inventory receipt / payment data is created based on the inspection standard master, the inventory status correspondence table, and the movement destination determination table, and output to the ERP management device. Such as a simple inspection management device. That is, by inputting schedule data from the ERP management apparatus, creating inventory receipt / payment data from the schedule data, and outputting the inventory receipt / payment data to the ERP management apparatus, the ERP package can be linked.

  FIG. 1 is a block diagram showing a first embodiment of an inspection management system according to the present invention. Hereinafter, description will be given based on this drawing.

  The inspection management system 10 according to the present embodiment includes an activation unit 1 that activates the inspection management device 2, an inspection management device 2 that manages inspection data, an inspection storage device 3 that stores data, an ERP management device 4, and the like. The inspection management apparatus 2 includes a preprocessing unit 21, a result input unit 22, a pass / fail determination unit 23, a post-processing unit 24, and the like. The inspection storage device 3 includes an inspection reference master 31, inspection instruction data 32, inspection result data 33, an inventory status correspondence table 34, a movement destination determination table 35, and the like. The ERP management device 4 includes schedule data 41, inventory receipt / payment data 42, and the like. The inspection management device 2 is composed of, for example, a computer, and each means is realized by a computer program.

  First, an outline of the configuration will be described. The inspection standard master 31 shows a correspondence relationship between the schedule data 41 related to the inspection target item and the inspection instruction data 32 including the inspection items and the acceptance criteria. The inventory status correspondence table 34 shows a correspondence relationship between the pass / fail determination result of the inspection target item and the inventory status in the ERP package. The movement destination determination table 35 shows the correspondence between the stock status in the ERP package of the item to be inspected and the location of the movement destination. The preprocessing means 21 receives the schedule data 41 from the ERP management device 4 and creates inspection instruction data 32 based on the schedule data 41 and the inspection reference master 31. The result input means 22 inputs an inspection result value from outside the inspection management device 2 and creates inspection result data 33 composed of the inspection result value for each inspection item included in the inspection instruction data 32 created by the preprocessing means 21. To do. The pass / fail determination means 23 determines pass / fail of the inspection result data 33 based on the inspection result data 33 created by the result input means 22 and the pass / fail criteria included in the inspection reference master 31. The post-processing means 24 creates inventory receipt / payment data 42 based on the acceptance / rejection determination result in the acceptance / rejection determination means 23, the inventory status correspondence table 34 and the movement destination determination table 35, and outputs the inventory receipt / payment data 42 to the ERP management device 4.

  Subsequently, an outline of the operation will be described. When the preprocessing means 21 inputs the schedule data 41 from the ERP management device 4, it can create the inspection instruction data 32 based on the inspection standard master 31 that already exists. On the other hand, when the actual result input means 22 inputs the actual inspection value from outside the inspection management device 2, the actual inspection result is composed of the input actual inspection value for each inspection item included in the inspection instruction data 32 created by the preprocessing means 21. Data 33 can be created. Then, the pass / fail determination means 23 can determine the pass / fail of the inspection result data 33 based on the inspection result data 33 created by the result input means 22 and the pass / fail criteria included in the inspection reference master 31 already possessed. Then, the post-processing means 24 obtains the stock status in the ERP package based on the pass / fail judgment result by the pass / fail judgment means 23 and the stock status correspondence table 34 that already has, and the stock status and the destination determination table that already has the stock status. 35, the destination location can be obtained. That is, the schedule data 41 is input from the ERP management device 4, the inventory receipt / payment data 42 is created from the schedule data 41, and the inventory receipt / payment data 42 is output to the ERP management device 4, thereby enabling linkage with the ERP package. Become.

  This will be described in more detail below. User information and storage device connection information are received from the activation means 1 and the inspection management apparatus 2 is activated. The preprocessing means 21 extracts the inspection schedule information from the schedule data 41 and generates inspection instruction data 32 based on the inspection schedule information and the inspection reference master 31. The result input means 22 receives the inspection result value for each inspection item from the user, and creates inspection result data 33 for the inspection instruction data 32. The pass / fail determination means 23 combines the inspection result data 33 and the inspection reference master 31, and determines whether the inspection result data is acceptable, rejected, or otherwise. The post-processing means 24 generates receipt / payment information of the ERP management device 4 based on the pass / fail determination information of the inspection management device 2 using the inventory status correspondence table 34 and the movement destination determination table 35.

  The inspection standard master 31 has the structure illustrated in FIG. The inspection standard A1 associates the inspection type A5 and the inspection item A2 of the inspection management apparatus 2 with the inspection target item A3 and the scheduled type A4 of the ERP management apparatus 4. Thereby, it is possible to generate inspection schedule data from the ERP package schedule data to the inspection management apparatus 2.

  The post-processing means 24 performs the process illustrated in FIG. 6 uses the inventory status correspondence table 34 to correlate the inventory status of the ERP package based on the pass / fail judgment result of the inspection management apparatus 2, and uses the movement destination determination table 35 to inventory status of the inventory lot in the ERP package. And the destination location is determined based on the location. This makes it possible to generate ERP inventory receipt / payment data 42 based on the pass / fail result of the inspection management apparatus 2.

  The inspection standard master 31 and the post-processing means 24 are features that are characteristic of this embodiment. As described above, the inspection schedule data of the inspection management apparatus 2 can be generated from the ERP package schedule data, and the ERP inventory receipt / payment data 42 can be generated from the pass / fail result of the inspection management apparatus 2, and the inspection linked to the ERP package. Management can be realized.

  Next, the operation of the inspection management system 10 of this embodiment will be described in detail with reference to FIGS.

  The inspection standard master 31 has the structure illustrated in FIG. The inspection standard A1 holds a plurality of inspection items A2, and the inspection item A2 defines a lower limit value and an upper limit value as a range in which the inspection passes. An inspection target item A3, a scheduled type A4, and an inspection type A5 are associated with the inspection standard A1. The inspection target item A3 is a master that defines an item to be inspected, and it is assumed that the ERP management device 4 and the inspection management device 2 share the master.

  The schedule type A4 represents the type of schedule information in the ERP management device 4, and includes, for example, a raw material acceptance schedule, an intermediate product production schedule, a product receipt schedule, and a product production receipt. The inspection type A5 represents the type of inspection in the inspection management device 2, and includes, for example, all lot inspection of raw materials, in-process inspection of intermediate products, all lot inspection of products, monthly management inspection of products, etc. It is done.

  Using the structure described above, the inspection type and inspection item group of the inspection management device 2 can be associated with the inspection target item of the ERP management device 4 and the type of schedule information.

  FIG. 2 [2] illustrates specific contents of the inspection standard master 31. In the ERP management device 4, when the inspection target item is A and the transaction type is scheduled to be produced, the inspection management device 2 has the inspection type of all lot inspection, and the inspection items include average molecular weight, density, and bending strength. Indicates that it is necessary. A lower limit and an upper limit are defined for each inspection item. In addition, the expiration date of this inspection standard is shown to be effective from January 1, 2004 to December 31, 2004.

  FIG. 3 [1] illustrates the structure of the inspection result data 33. The inspection result B1 has one or more inspection result details B2. The inspection result details B2 need to be created by the number of inspection items defined in the inspection standard master 31. The inspection result specification B2 holds one or more inspection samples B3. The value input by the result input means 22 is stored in the sample measurement value of the inspection sample B3. By adopting such a structure, even if there are a plurality of inspection samples for the inspection lot, the pass / fail judgment can be integrated into the inspection result B1. Therefore, the stock processing data 42 can be generated when the post-processing unit 24 is linked to the ERP management device 4.

  FIG. 3 [2] illustrates specific contents of the inspection result data 33. This is an example of inspection result data 33 for the inspection reference master 31 illustrated in FIG. 2 [2]. For one inspection result B1, data of three inspection result details B2 and eight inspection samples B3 are held. The first inspection item value is the molecular weight, and three sample measurement values are stored in the inspection sample B3. In the inspection result specification B2, the average value of these three sample measurement values is stored. The second density is the same as the first density. The third bending strength contains two samples. Thus, the number of inspection samples may differ for each inspection result specification.

  A specific example of the pass / fail determination means 23 will be described with reference to FIG. Here, based on the inspection reference value master of FIG. 2 [2], an example of creating the pass / fail judgment result of FIG. 5 from the inspection record data 33 of FIG. 3 [2] is used.

  First, inspection result data 33 is read (step C1). Second, a pass / fail judgment process is executed on the read data (steps C2, C3, C4, C5). The conversion process is executed by sequentially processing the inspection result details (step C2).

  In the first round of the loop, the first inspection result detail is targeted. First, it is determined whether all the samples are acceptable (step C3). The sample measurement values are 60.0, 59.0, and 61.0, all of which are within the range of the lower limit value 55.0 and 65.0 or less of the inspection standard master 31, and thus are determined to be acceptable. For this reason, it is determined that the first inspection result detail is acceptable (step C4).

  In the second round of the loop, the second inspection result specification is targeted. First, it is determined whether or not all the samples pass (Step C3). The sample measurement values are 31.0, 29.0, and 33.0. Since the second sample does not fall within the range of the lower limit value 30.0 and 40.0 of the inspection reference master 31, it is determined as rejected. For this reason, since all the samples do not pass, the second inspection result specification is determined to be unacceptable (step C5). The third time of the loop is determined to be passed as in the first time.

  Subsequently, it is determined whether or not all inspection items are acceptable (step C6). In this example, since the second inspection item is rejected, the inspection result of the entire inspection result data 33 is determined to be unacceptable (step C8).

  FIG. 6 illustrates the operation of the post-processing means 24. Here, with respect to the inspection result data 33 in FIG. 3 [2] and the pass / fail judgment result in FIG. 5, the inventory status correspondence table 34 in FIG. 7 [1] and the movement destination determination table 35 in FIG. 7 [2] are used. An example of generating inventory receipt / payment data 42 will be shown.

  First, inspection result data 33 is read (step D1). Second, the inventory status of the movement source and the location of the movement source are determined (step D2). Here, it is assumed that the inventory status of the movement source is QC and the location of the movement source is the production line A. Third, the destination stock status is determined using the stock status correspondence table 34 (step D3). Since the pass / fail judgment result in FIG. 5 is rejected, it is determined from FIG. 7 [1] that the ERP inventory status is REJECT.

  Fourth, the destination is determined from the destination determination table 35 (step D4). Using FIG. 7 [2], when the source inventory status is QC, the source location is the production line A, and the destination inventory status is REJECT, the destination location is the discard location A in the third row. It turns out. Here, if the destination location does not exist in the destination determination table 35, the destination location is manually designated (step D5).

  As described above, in the ERP management apparatus 4, the inventory receipt / payment data 42 in which the inventory status of the movement source is QC, the lot of the production line A is REJECT as the movement destination, and the place is moved to the disposal location A is generated (step D6). .

  According to the present embodiment, the inspection schedule data of the inspection management apparatus 2 can be generated from the ERP package schedule data 41, and the ERP inventory receipt / payment data 42 can be generated from the pass / fail result of the inspection management apparatus 2. Inspection management linked to the ERP package can be realized.

  FIG. 8 is a block diagram showing a second embodiment of the inspection management system according to the present invention. Hereinafter, description will be given based on this drawing. However, the description of the same part as the first embodiment is omitted.

  The inspection management system 11 according to the present embodiment further includes difference management means 25 in the configuration of the first embodiment. The difference management means 25 manages the difference data 36 to be added, updated, or deleted from the scheduled data 41 already input from the ERP management device 4. At this time, the preprocessing means 41 receives the difference data 36 from the difference management means 25 and creates the minimum necessary inspection instruction data 32 based on the difference data 36 and the inspection reference master 31.

  In other words, in the present embodiment, the difference management means 25 is added to the inspection management device 2 and the difference data 36 is added to the inspection storage device 3 with respect to the configuration of the first embodiment. The difference data 36 stores the ERP schedule data 41 added, updated, or deleted after the previous operation of the preprocessing means 21 is executed. The difference management means 25 manages the schedule data 41 fetched last time and the schedule data 41 fetched this time based on the difference data 36 described above. Since the preprocessing means 21 uses the difference management means 25 to read only the difference data 36, only the data that needs to be converted can be processed.

  According to the present embodiment, it is possible to mechanically execute only the ERP scheduled data that is the difference from the previous time without explicitly specifying the activation condition.

1 is a block diagram showing a first embodiment of an inspection management system according to the present invention. FIG. 2 [1] is a block diagram showing the structure of the inspection standard master, and FIG. 2 [2] is a chart showing specific contents of the inspection standard master. FIG. 3 [1] is a block diagram showing the structure of inspection result data, and FIG. 3 [2] is a chart showing specific contents of inspection result data. It is a flowchart which shows operation | movement of a pass / fail determination means. It is a chart which shows a pass / fail judgment result. It is a flowchart which shows operation | movement of a post-processing means. FIG. 7 [1] is a chart showing an inventory status correspondence table, and FIG. 7 [2] is a chart showing a destination determination table. It is a block diagram which shows 2nd embodiment of the test | inspection management system which concerns on this invention. It is a block diagram which shows the conventional test | inspection management system.

Explanation of symbols

DESCRIPTION OF SYMBOLS 10,11 Inspection management system 1 Starting means 2 Inspection management apparatus 21 Pre-processing means 22 Result input means 23 Pass / fail judgment means 24 Post-processing means 25 Difference management means 3 Inspection storage device 31 Inspection reference master 32 Inspection instruction data 33 Inspection result data 34 Inventory status correspondence table 35 Destination determination table 36 Difference data 4 ERP management device 41 Scheduled data 42 Inventory receipt / payment data

Claims (10)

An inspection standard master indicating a correspondence relationship between the scheduled data regarding the inspection target item and the inspection instruction data including the inspection item and the acceptance criteria;
An inventory status correspondence table showing a correspondence relationship between the pass / fail judgment result of the inspection target item and the inventory status in the ERP package;
A destination determination table showing the correspondence between the inventory status in the ERP package of the item to be inspected and the destination location;
The scheduled data is input from the ERP management apparatus and the inspection result value is input from outside the inspection management apparatus, and the schedule data and the inspection result value, the inspection standard master, the inventory status correspondence table, and the destination determination table A means for generating inventory receipt / payment data and outputting it to the ERP management device;
Inspection management device with An inspection standard master indicating a correspondence relationship between the scheduled data regarding the inspection target item and the inspection instruction data including the inspection item and the acceptance criteria;
An inventory status correspondence table showing a correspondence relationship between the pass / fail judgment result of the inspection target item and the inventory status in the ERP package;
A destination determination table showing the correspondence between the inventory status in the ERP package of the item to be inspected and the destination location;
Pre-processing means for inputting the schedule data from an ERP management apparatus and creating the inspection instruction data based on the schedule data and the inspection standard master;
Results input means for inputting inspection results values from outside the inspection management device, and creating inspection results data consisting of the inspection results values for each of the inspection items included in the inspection instruction data created by the preprocessing means;
Pass / fail judgment means for judging pass / fail of the inspection result data based on the inspection result data created by the result input means and the pass / fail criteria included in the inspection standard master;
A post-processing unit that creates pass / fail data on the basis of the pass / fail determination result in the pass / fail determination unit, the inventory status correspondence table and the destination determination table, and outputs the stock transfer / payment data to the ERP management device;
Inspection management device with A difference management means for managing difference data to be added, updated or deleted to the scheduled data already input from the ERP management device;
The preprocessing means inputs the difference data from the difference management means, and creates the minimum necessary inspection instruction data based on the difference data and the inspection reference master.
The inspection management apparatus according to claim 2.
The inspection management device according to any one of claims 1 to 3,
An ERP management device that outputs the scheduled data to the inspection management device and inputs the inventory receipt / payment data from the inspection management device;
An inspection storage device for storing the inspection reference master, the inventory status correspondence table and the destination determination table;
Inspection management system with
An inspection standard master indicating the correspondence between the scheduled data related to the inspection target item and the inspection instruction data including the inspection item and its pass / fail criteria, and an inventory indicating the correspondence between the pass / fail judgment result of the inspection target item and the stock status in the ERP package A state correspondence table and a destination determination table indicating a correspondence relationship between an inventory state of the ERP package of the item to be inspected and a destination location;
The planned data is input from the ERP management apparatus and the inspection actual value is input from the outside. Based on the planned data and the actual inspection value, the inspection standard master, the inventory status correspondence table, and the destination determination table, Create receipt data and output to the ERP management device,
Inspection management method. An inspection standard master indicating the correspondence between the scheduled data related to the inspection target item and the inspection instruction data including the inspection item and its pass / fail criteria, and an inventory indicating the correspondence between the pass / fail judgment result of the inspection target item and the stock status in the ERP package A state correspondence table and a destination determination table indicating a correspondence relationship between an inventory state of the ERP package of the item to be inspected and a destination location;
The schedule data is input from the ERP management device, and the inspection instruction data is created based on the schedule data and the inspection standard master,
Enter inspection result values from outside, create inspection result data consisting of the inspection result values for each inspection item included in the created inspection instruction data,
Determining pass / fail of the inspection result data based on the created inspection result data and the pass / fail criteria included in the inspection standard master;
Based on this pass / fail determination result, inventory receipt / payment data is created based on the inventory status correspondence table and the destination determination table, and this inventory receipt / payment data is output to the ERP management device,
Inspection management method. Managing difference data to be added, updated or deleted to the scheduled data already input from the ERP management device;
The difference data is input, and the minimum necessary inspection instruction data is created based on the difference data and the inspection reference master.
The inspection management method according to claim 6.
An inspection standard master indicating the correspondence between the scheduled data related to the inspection target item and the inspection instruction data including the inspection item and its pass / fail criteria, and an inventory indicating the correspondence between the pass / fail judgment result of the inspection target item and the stock status in the ERP package To a computer prepared in advance in a storage device, a state correspondence table and a movement destination determination table showing a correspondence relationship between an inventory state in an ERP package of an item to be inspected and a movement destination location,
The scheduled data is input from the ERP management apparatus and the actual inspection value is input from outside the computer. Based on the planned data and the actual inspection value, the inspection standard master, the inventory status correspondence table, and the destination determination table. , Means for generating inventory receipt / payment data and outputting it to the ERP management device;
Inspection management program to realize. An inspection standard master indicating the correspondence between the scheduled data related to the inspection target item and the inspection instruction data including the inspection item and its pass / fail criteria, and an inventory indicating the correspondence between the pass / fail judgment result of the inspection target item and the stock status in the ERP package To a computer prepared in advance in a storage device, a state correspondence table and a movement destination determination table showing a correspondence relationship between an inventory state in an ERP package of an item to be inspected and a movement destination location,
Pre-processing means for inputting the schedule data from an ERP management apparatus and creating the inspection instruction data based on the schedule data and the inspection standard master;
Results input means for inputting inspection results values from outside the computer, and creating inspection results data consisting of the inspection results values for each of the inspection items included in the inspection instruction data created by the preprocessing means;
Pass / fail judgment means for judging pass / fail of the inspection result data based on the inspection result data created by the result input means and the pass / fail criteria included in the inspection standard master;
A post-processing unit that creates pass / fail data on the basis of the pass / fail determination result in the pass / fail determination unit, the inventory status correspondence table and the destination determination table, and outputs the stock transfer / payment data to the ERP management device;
Inspection management program to realize. The computer further realizes a difference management means for managing difference data to be added, updated or deleted to the scheduled data already input from the ERP management device,
The preprocessing means inputs the difference data from the difference management means, and creates the minimum necessary inspection instruction data based on the difference data and the inspection reference master.
The inspection management program according to claim 9.

Images