Material inventory analysis method and device, electronic equipment and storage medium

Abstract

The invention provides a material inventory analysis method and device, electronic equipment and a storage medium. The method comprises the following steps: acquiring a material inventory table from an inventory management system; the material inventory table is used for representing the inventory condition of each material; obtaining a material detection table from a laboratory management system; wherein the time periods corresponding to the material inventory table and the material detection table are the same; the material detection table is used for representing detection information corresponding to each to-be-detected material; extracting target information from a material arrangement table, a material inventory table and a material detection table based on the material information; the material arrangement table comprises the detection duration required by each detection item corresponding to the material and the material demand quantity; and determining the detection emergency degree of each to-be-detected material in the material detection table based on the target information. According to the method and the device, the materials needing emergency detection are automatically identified by combining the material arrangement table, the material inventory table and the material detection table, so that the emergency material identification efficiency is improved, and the risk that a production line stops production due to insufficient material inventory is reduced.

Description

Technical Field

[0001] The present application relates to the technical field of inventory management, and in particular to a material inventory analysis method, device, electronic device and storage medium. Background Art

[0002] At present, new energy vehicles are in a period of rapid development. Lithium batteries, as one of the important components, are in a stage of large demand. Upstream lithium battery raw materials are gradually in short supply, especially the supply of anode and cathode powders is relatively tight. At the same time, in order to reduce inventory and save costs, various lithium battery manufacturers reserve material inspection time in the factory, which generally depends on the bottleneck project's gram capacity detection cycle, which is usually about 3 days.

[0003] In the prior art, an inventory management system (ERP) is used to record the information of materials entering and leaving the warehouse, and a laboratory management system (LDMS) is used to effectively manage sample information, testing process, test data and test reports. Materials from warehousing, testing, posting and urgency determination are all operated by personnel in different offline modules. There is a gap between the testing link and inventory-related information. The principle of first-in-first-out testing cannot meet the actual material needs in the factory, and there is often a risk of insufficient material inventory, leading to production line shutdown. Summary of the invention

[0004] The purpose of the embodiments of the present application is to provide a material inventory analysis method, device, electronic device and storage medium to reduce the risk of production line shutdown due to insufficient material inventory.

[0005] In a first aspect, an embodiment of the present application provides a material inventory analysis method, comprising:

[0006] Obtain a material inventory table from the inventory management system; the material inventory table is used to represent the inventory status of each material;

[0007] Obtain a material inspection table from the laboratory management system; the material inventory table and the material inspection table correspond to the same time period; the material inspection table is used to represent the inspection information corresponding to each material to be inspected;

[0008] Extract target information from the material allocation table, material inventory table and material inspection table based on material information; the material allocation table contains the inspection time and material demand required for each inspection item corresponding to the material;

[0009] Determine the urgency of testing each material to be tested in the material testing table based on the target information.

[0010] The embodiment of the present application automatically identifies materials that require emergency inspection by combining a material allocation table, a material inventory table, and a material inspection table, thereby improving the efficiency of emergency material identification and reducing the risk of production line shutdown due to insufficient material inventory.

[0011] In any embodiment, the target information includes the inventory of the material and the material demand corresponding to the preset time; determining the urgency of testing each material to be tested in the material testing table based on the target information includes:

[0012] If the inventory is less than the material requirement, it is determined that the material needs to be urgently tested.

[0013] In an embodiment of the present application, when the inventory is less than the material demand, it is determined that the inventory of the material is less at the current time, and it is necessary to conduct emergency inspection of the material that is in storage but not inspected, so as to fill the inventory after the inspection passes, thereby reducing the risk of production suspension due to insufficient inventory of a certain material.

[0014] In any embodiment, the method further comprises:

[0015] If there are multiple materials that are determined to be materials that require urgent testing, the ratio of the corresponding inventory to the material demand of each material is obtained;

[0016] The inspection order of each material is determined according to the ratio.

[0017] In the embodiment of the present application, when there are multiple materials that require urgent testing, the urgency of each can be determined and the testing sequence can be further optimized.

[0018] In any embodiment, the target information includes the inventory of materials, the time for material inspection, the inspection duration, and the material demand corresponding to the preset duration; determining the urgency of the inspection of each material to be inspected in the material inspection table based on the target information includes:

[0019] Determine future inventory based on inventory, delivery time and inspection duration;

[0020] Based on the fact that the future inventory is less than the material demand, it is determined that the material needs to be urgently tested.

[0021] In the embodiment of the present application, some materials may be being inspected. Therefore, the future inventory can be determined in combination with the current inventory of the material and the time when the inspection of the material being inspected is completed, thereby improving the accuracy of identifying the urgency of the material.

[0022] In any embodiment, the target information includes the inventory of materials, the material demand, the detection time and the material consumption rate; determining the urgency of detecting each material to be detected in the material detection table based on the target information includes:

[0023] Obtain material consumption according to the detection time and material consumption rate;

[0024] If the inventory is less than the material demand, and the material consumption is greater than a preset multiple of the inventory, it is determined that the material needs to be urgently tested; wherein the preset multiple is a positive number less than 1.

[0025] In the embodiment of the present application, since the production line is in operation, the material will gradually decrease as the production line operates. Therefore, it is possible to determine whether the material needs to be urgently inspected based on the inventory and the material consumption during the inspection process, thereby improving the accuracy of determining the urgency of the material.

[0026] In any embodiment, obtaining a material inventory table from an inventory management system includes:

[0027] Run the inventory extraction program, which pre-defines the extraction time period and material inventory information;

[0028] Extract information from the inventory management system based on the extraction time period and material inventory information to generate a material inventory table.

[0029] The embodiment of the present application extracts information from the inventory management system through an inventory extraction program and generates a material inventory table, thereby providing data basis for whether subsequent materials require emergency inspection.

[0030] In any embodiment, obtaining a material test table from a laboratory management system includes:

[0031] Run the sampling and extraction program, in which the material testing information to be extracted is predefined;

[0032] The material inspection information to be extracted is extracted from the laboratory management system to generate a material inspection table.

[0033] The embodiment of the present application extracts information from the laboratory management system through a sampling and extraction program and generates a material inspection table, providing data basis for whether subsequent materials require emergency inspection.

[0034] In any embodiment, after extracting target information from the material allocation table, the material inventory table, and the material detection table based on the material information, the method further includes:

[0035] Generate an inventory analysis table based on the target information; the inventory analysis table also includes a warning field;

[0036] After determining whether the material needs to be inspected urgently based on the target information, the method further includes:

[0037] Update the warning field corresponding to the materials that need urgent inspection to the value representing the warning.

[0038] The embodiment of the present application can prompt the inspection personnel to inspect the materials in a timely manner by issuing an early warning for the materials that require urgent inspection.

[0039] In any embodiment, the method further comprises:

[0040] Scan the label on the material to be tested by a barcode scanning device to obtain the information of the material to be tested;

[0041] The information matching program is used to match the test material information with the sampling plan table to generate a test plan; the sampling plan table stores the test items and test frequencies of each material; the test plan is used to instruct material test personnel on the plan for testing the material.

[0042] The embodiment of the present application utilizes a barcode scanning device to scan the label on the material to be inspected, and automatically generates an inspection plan in combination with a sampling plan table, thereby improving the efficiency of generating the inspection plan.

[0043] In any embodiment, before extracting target information from the material allocation table, the material inventory table, and the material detection table based on the material information, the method further includes:

[0044] Hyperlink the material inventory table, material inspection table and material allocation table.

[0045] The embodiment of the present application performs hyperlink processing on the material inventory table, material inspection table and material allocation table, so that when the information in the material inventory table, material inspection table and material allocation table is updated, it can be synchronized with the target information, so that the urgency of the material to be inspected can be determined more accurately based on the target information.

[0046] In a second aspect, an embodiment of the present application provides a material inventory analysis device, comprising:

[0047] The first table acquisition module is used to obtain a material inventory table from the inventory management system; the material inventory table is used to represent the inventory status of each material;

[0048] The second table acquisition module is used to obtain a material inspection table from the laboratory management system; wherein the material inventory table and the material inspection table correspond to the same time period; the material inspection table is used to represent the inspection information corresponding to each material to be inspected;

[0049] An information extraction module is used to extract target information from a material allocation table, a material inventory table, and a material inspection table based on material information; the material allocation table includes the inspection time and material demand required for each inspection item corresponding to the material;

[0050] The detection module is used to determine the urgency of testing each material to be tested in the material detection table based on the target information.

[0051] In a third aspect, an embodiment of the present application provides an electronic device, including: a processor, a memory, and a bus, wherein:

[0052] The processor and the memory communicate with each other via the bus;

[0053] The memory stores program instructions that can be executed by the processor, and the processor can execute the method of the first aspect by calling the program instructions.

[0054] In a fourth aspect, an embodiment of the present application provides a non-transitory computer-readable storage medium, including:

[0055] The non-transitory computer-readable storage medium stores computer instructions that cause the computer to execute the method of the first aspect.

[0056] In a fifth aspect, an embodiment of the present application provides a computer program product, comprising computer program instructions, wherein when the computer program instructions are read and executed by a processor, the method of the first aspect is executed.

[0057] Other features and advantages of the present application will be described in the following description, and partly become apparent from the description, or be understood by practicing the embodiments of the present application. The purpose and other advantages of the present application can be realized and obtained by the structures specifically pointed out in the written description, claims, and drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0058] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the embodiments of the present application will be briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present application and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without paying creative work.

[0059] Figure 1 A schematic diagram of the process flow from material entry to production line provided by the traditional solution;

[0060] Figure 2 A schematic diagram of a material inventory analysis method provided in an embodiment of the present application;

[0061] Figure 3 A schematic diagram of material inventory analysis provided in an embodiment of the present application;

[0062] Figure 4 A schematic diagram of another material inventory analysis method provided in an embodiment of the present application;

[0063] Figure 5 A schematic diagram of the structure of a material inventory analysis device provided in an embodiment of the present application;

[0064] Figure 6 A schematic diagram of the physical structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0065] The following embodiments of the technical solution of the present application are described in detail in conjunction with the accompanying drawings. The following embodiments are only used to more clearly illustrate the technical solution of the present application, and are therefore only used as examples, and cannot be used to limit the scope of protection of the present application.

[0066] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by technicians in the technical field to which this application belongs; the terms used herein are only for the purpose of describing specific embodiments and are not intended to limit this application; the terms "including" and "having" in the specification and claims of this application and the above-mentioned figure descriptions and any variations thereof are intended to cover non-exclusive inclusions.

[0067] In the description of the embodiments of the present application, the technical terms "first", "second", etc. are only used to distinguish different objects, and cannot be understood as indicating or implying relative importance or implicitly indicating the number, specific order or primary and secondary relationship of the indicated technical features. In the description of the embodiments of the present application, the meaning of "multiple" is more than two, unless otherwise clearly and specifically defined.

[0068] Reference to "embodiments" herein means that a particular feature, structure, or characteristic described in conjunction with the embodiments may be included in at least one embodiment of the present application. The appearance of the phrase in various locations in the specification does not necessarily refer to the same embodiment, nor is it an independent or alternative embodiment that is mutually exclusive with other embodiments. It is explicitly and implicitly understood by those skilled in the art that the embodiments described herein may be combined with other embodiments.

[0069] In the description of the embodiments of the present application, the term "and / or" is only a description of the association relationship of the associated objects, indicating that there may be three relationships. For example, A and / or B can represent: A exists alone, A and B exist at the same time, and B exists alone. In addition, the character " / " in this article generally indicates that the associated objects before and after are in an "or" relationship.

[0070] In the description of the embodiments of the present application, the term "multiple" refers to more than two (including two). Similarly, "multiple groups" refers to more than two groups (including two groups), and "multiple pieces" refers to more than two pieces (including two pieces).

[0071] In the description of the embodiments of the present application, unless otherwise clearly specified and limited, technical terms such as "installed", "connected", "connected", "fixed" and the like should be understood in a broad sense. For example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection or an indirect connection through an intermediate medium, and it can be the internal connection of two elements or the interaction relationship between two elements. For those of ordinary skill in the art, the specific meanings of the above terms in the embodiments of the present application can be understood according to the specific circumstances.

[0072] Regarding the management of materials, after the materials enter the factory, the warehouse management personnel maintain the material information (name, batch number, quantity, supplier name) in the ERP system, and the quality inspection department personnel query the batch to be inspected in the ERP system, determine the inspection plan, and then apply for testing in the LDMS system, and then send the samples to the corresponding laboratories for each project. After the laboratory personnel complete the inspection, they will issue a report in the LDMS system, and the quality inspection department personnel will query the inspection results. If the inspection is qualified, the quality inspection department personnel will enter the data into the ERP system for posting operations. If the inspection is unqualified, the quality inspection department personnel will contact the warehouse management personnel for return and exchange processing, update the material inventory information, and the material control planner will determine the urgency of the material based on the inventory and demand in the ERP system.

[0073] Therefore, materials from entering the factory to going online involve the processing of warehouse management personnel, quality inspection personnel and laboratory personnel, such as Figure 1 The above process involves three modules (warehouse management, quality inspection, and laboratory). The process from the entry of materials into the factory to the completion of testing requires offline manual follow-up, which leads to information lag and increased labor costs. Data information is distributed in two systems (inventory management system and laboratory management system), and there is also a phenomenon of information connection fault. Material inventory is not updated in time, there are deviations in the determination of urgency, and the test is improperly scheduled, resulting in the risk of waiting for materials on the production line.

[0074] In order to solve the above technical problems, the embodiments of the present application provide a material inventory analysis method, device, electronic device and storage medium. The method can be applied to the analysis of various material inventories, for example, inventory analysis of lithium battery powder, etc.

[0075] It can be understood that the material inventory analysis method provided in the embodiment of the present application can be applied to electronic devices, which include terminals and servers; the terminals can specifically be smart phones, tablet computers, computers, personal digital assistants (PDA), etc.; the servers can specifically be application servers or Web servers.

[0076] Figure 2A schematic diagram of a material inventory analysis method provided in an embodiment of the present application is shown in FIG. Figure 2 As shown, the method includes:

[0077] Step 201: Obtain a material inventory table from the inventory management system; the material inventory table is used to represent the inventory status of each material;

[0078] Step 202: Obtain a material inspection table from the laboratory management system; wherein the material inventory table and the material inspection table correspond to the same time period; and the material inspection table is used to represent the inspection information corresponding to each material to be inspected;

[0079] Step 203: extracting target information from the material allocation table, the material inventory table, and the material inspection table based on the material information; the material allocation table includes the inspection time and material demand required for each inspection item corresponding to the material;

[0080] Step 204: Determine the urgency of testing each material to be tested in the material testing table based on the target information.

[0081] Among them, in step 201, the inventory management system, also known as the warehouse ERP system or ERP inventory system, is a system that comprehensively and systematically manages and controls the enterprise inventory by integrating multiple functional modules. It covers the entire process of inventory planning, procurement, warehousing, outbound, inventory, etc., and realizes real-time monitoring and dynamic adjustment of inventory through information technology.

[0082] The main functions of the ERP system include:

[0083] Inventory monitoring: Real-time tracking of inventory status, including inventory quantity, inventory age, slow-moving and expired items, etc., to help business managers better understand inventory conditions.

[0084] Warehouse management: Automatically record the warehouse information of materials, such as material name, specification, quantity, supplier, production date, expiration date, etc., for easy tracking and management.

[0085] Outbound management: Automatically record outbound material information, such as material name, specification, quantity, customer, outbound date, etc., to understand the flow of inventory and make arrangements and decisions on sales and production.

[0086] Inventory transfer: Help companies transfer and allocate inventory to meet the needs of different warehouses, production lines and customers.

[0087] Inventory management: Automatically record inventory information, including inventory time, inventory personnel, inventory results, etc., to help understand the actual inventory status and make corresponding adjustments and decisions.

[0088] The inventory management system stores a material inventory table, which stores the inventory status of each material. The material inventory table can include information such as material type, total unrestricted inventory, total inventory for the next three days, material code, material name, factory information, warehouse location, warehouse description, unrestricted inventory, quality inspection inventory, inventory unit, supplier batch, etc.

[0089] The electronic device obtains the material inventory list from the ERP system by accessing the ERP system.

[0090] In step 202, the Laboratory Data Management System (LDMS) is an integrated information management platform designed for the laboratory process in the battery production process. It is mainly used to manage various laboratory data, resources, processes, and quality control to ensure efficient, accurate, and reliable battery production.

[0091] The main functions of the LDMS system include but are not limited to:

[0092] Data management: The system can centrally store, process and analyze various data generated by the laboratory, such as battery performance data, raw material test data, production process data, etc. Through effective data management, a scientific basis can be provided for battery production decision-making.

[0093] Resource management: All types of laboratory resources, such as equipment, reagents, consumables, etc., can be centrally managed through LDMS. The system can track the use of resources to ensure effective use and timely replenishment of resources.

[0094] Process management: LDMS can standardize various laboratory operation processes, including sample reception, processing, testing, result analysis, etc. Through process management, the accuracy and consistency of experimental operations can be ensured, and the reliability of experimental results can be improved.

[0095] Quality control: The system can monitor the experimental process in real time and perform quality inspection and control on the experimental data to ensure the accuracy and effectiveness of the experimental results. In addition, LDMS can also help the laboratory establish a quality management system and improve the management level of the laboratory.

[0096] Reports and statistics: LDMS can automatically generate various experimental reports and statistical data to provide a basis for the improvement and optimization of battery production. At the same time, these reports and data can also be used for communication and exchanges with relevant departments or customers.

[0097] Therefore, the LDMS system includes a material testing table, which includes the material information submitted for the test application and relevant information for the material testing, including but not limited to the test item code, test item name, material code, sample quantity, priority, supplier batch, applicant, test time, tester, test results, etc.

[0098] The electronic device can obtain the material inspection list from the LDMS system by accessing the LDMS system.

[0099] It should be noted that the material inventory table and material inspection table obtained by the electronic device correspond to the same time period, that is, the material inventory table and material inspection table are within the same time period. In addition, in the subsequent analysis process, the material inventory table and material inspection table can update the data in real time.

[0100] In step 203, the material allocation table includes the required inspection time and material demand for each inspection item corresponding to the material. Each material can have at least one inspection item, and the inspection items for different materials can be the same, partially the same, or completely different. In addition, the inspection time required for different inspection items may also be different. Therefore, when judging the inspection time of a material, the longest inspection time among the inspection items can be used as the inspection time of the material. The material demand refers to the amount of each material required by the production line within the preset time.

[0101] The electronic device can extract target information from the material allocation table, material inventory table and material detection table. It is understandable that the target information can be the information of the pre-specified fields in the material allocation table, material inventory table and material detection table. It is understandable that the material allocation table, material inventory table and material detection table all contain fields that characterize the uniqueness of the material, such as: material code and supplier batch. The material can be uniquely identified by the material code and supplier batch, so that the acquired target information can be integrated according to the material code and supplier batch. Among them, in the integrated target information, the information corresponding to each material includes: material code, supplier batch, material demand, detection plan, detection time, detection duration, completion time, etc. It should be noted that in addition to the material code and supplier batch that can uniquely identify the material, it can also be uniquely determined by other parameters, such as: by material name and supplier batch, etc.

[0102] In step 204, the electronic device can perform an urgency analysis on each material based on the acquired target information. It is understandable that the urgency can be used to indicate whether the material needs to be urgently tested, and can also be used to indicate the urgency level of the material that needs to be urgently tested. For materials that need to be urgently tested, the test personnel can give priority to testing them.

[0103] The embodiment of the present application automatically identifies materials that require emergency inspection by combining a material allocation table, a material inventory table, and a material inspection table, thereby improving the efficiency of emergency material identification and reducing the risk of production line shutdown due to insufficient material inventory.

[0104] On the basis of the above embodiment, the target information includes the inventory of materials and the material demand corresponding to the preset time; determining the urgency of testing each material to be tested in the material testing table based on the target information includes:

[0105] If the inventory is less than the material requirement, it is determined that the material needs to be urgently tested.

[0106] In the specific implementation process, the inventory of materials refers to the inventory currently available for production. The preset duration can be pre-set, for example, it can be 3 days, 5 days, etc. The material demand refers to the amount of materials required for the production line to produce for three days.

[0107] When analyzing the urgency of each material, you can compare the material inventory and material demand. If the inventory is less than the material demand, it means that the material inventory is insufficient and the corresponding materials to be tested of this type of material need to be urgently tested. If the inventory is not less than the material demand, it means that the material inventory is sufficient and the corresponding materials to be tested of this type of material do not need to be urgently tested.

[0108] It should be noted that if there are no materials that require urgent testing, the materials can be tested in the order in which they are submitted.

[0109] In an embodiment of the present application, when the inventory is less than the material demand, it is determined that the inventory of the material is less at the current time, and it is necessary to conduct emergency inspection of the material that is in storage but not inspected, so as to fill the inventory after the inspection passes, thereby reducing the risk of production suspension due to insufficient inventory of a certain material.

[0110] Based on the above embodiment, the method further includes:

[0111] If there are multiple materials that are determined to be materials that require urgent testing, the ratio of the corresponding inventory to the material demand of each material is obtained;

[0112] The inspection order of each material is determined according to the ratio.

[0113] In the specific implementation process, when the electronic device determines that there are multiple materials that need to be urgently inspected based on the target information, if the number of inspection teams is the same as the number of materials that need to be urgently inspected, or the number of inspection teams is greater than the number of materials that need to be urgently inspected, then multiple materials can be inspected by one inspection team respectively. If the number of inspection teams is less than the number of materials that need to be urgently inspected, the urgency of multiple materials that need to be urgently inspected can be sorted to determine the inspection order. Among them, the inspection order can be calculated by calculating the ratio of the inventory corresponding to each material to the material demand. If the ratio is small, it means that the inventory accounts for a small proportion and the urgency is high, and priority inspection is required; on the contrary, it means that the inventory accounts for a relatively high proportion and the urgency is relatively low. Therefore, the inspection order of each material can be determined according to the ratio, that is, the materials with a small ratio are inspected first.

[0114] In the embodiment of the present application, when there are multiple materials that require urgent testing, the urgency of each can be determined and the testing sequence can be further optimized.

[0115] On the basis of the above embodiment, the target information includes the inventory of materials, the time of material inspection, the inspection duration, and the material demand corresponding to the preset duration; the urgency of the inspection of each material to be inspected in the material inspection table is determined based on the target information, including:

[0116] Determine future inventory based on inventory, delivery time and inspection duration;

[0117] Based on the fact that the future inventory is less than the material demand, it is determined that the material needs to be urgently tested.

[0118] In the specific implementation process, the explanation of the material inventory and the material demand corresponding to the preset time can be found in the above embodiment, which will not be repeated here. The material inspection time can be the time when the quality inspector submits the inspection application on the system, or it can be the time when the quality inspector delivers the material to be inspected to the laboratory and the laboratory staff records it on the system. The inspection time refers to the time to complete each inspection item of the material, that is, the maximum time among the inspection items can be used as the inspection time of the material.

[0119] Electronic devices can determine future inventory based on inventory, inspection time, and inspection duration, where future inventory refers to the maximum inventory of the material from the current time to the preset duration. The time it takes to complete the inspection of the material can be determined based on the inspection time and the inspection duration. If the time to complete the inspection is less than the time from the current time to the preset duration, it means that the inventory of the material may increase within the preset duration. It should be noted that the situation in which the inventory of the material increases within the preset duration is that the type of material being inspected passes the inspection, and then the batch of materials that pass the inspection can be put into storage. That is, if the inspection passes, the future inventory = inventory + inventory corresponding to the material that passed the inspection.

[0120] After determining the future inventory, the future inventory can be compared with the material demand. If the future inventory is greater than the material demand, it is determined that the material inventory is sufficient and no emergency inspection is required. On the contrary, if the future inventory is less than the material demand, it is determined that the material inventory is insufficient and emergency inspection is required.

[0121] In the embodiment of the present application, some materials may be being inspected. Therefore, the future inventory can be determined in combination with the current inventory of the material and the time when the inspection of the material being inspected is completed, thereby improving the accuracy of identifying the urgency of the material.

[0122] Based on the above embodiment, the target information includes the inventory of materials, the material demand, the inspection time, the inspection time and the material consumption rate; the urgency of the inspection of each material to be inspected in the material inspection table is determined based on the target information, including:

[0123] Obtain material consumption according to the detection time and material consumption rate;

[0124] If the inventory is less than the material demand, and the material consumption is greater than a preset multiple of the inventory, it is determined that the material needs to be urgently tested; wherein the preset multiple is a positive number less than 1.

[0125] In the specific implementation process, the explanations of material inventory, material demand, inspection time, and inspection time can be found in the above embodiments, which will not be repeated here. Material consumption rate refers to the amount of material used in a unit of time, for example: the amount of a certain material used in 1 hour.

[0126] The material consumption can be determined based on the detection time and the material consumption rate. It can be understood that the material consumption refers to the amount of the material used by the production line during the remaining detection time.

[0127] The production line generally reserves materials of a preset length of time. Since the materials being tested include this type of material, and during the testing process, the production line is in production and the materials will be consumed. Therefore, if the inventory is less than the material demand, and the material consumption is greater than the preset multiple of the inventory, it means that when the material test is completed, the inventory has been consumed more and urgent testing is required. It can be understood that the preset multiple is a positive number less than 1, such as 0.5, 0.3, etc.

[0128] In the embodiment of the present application, since the production line is in operation, the material will gradually decrease as the production line operates. Therefore, it is possible to determine whether the material needs to be urgently inspected based on the inventory and the material consumption during the inspection process, thereby improving the accuracy of determining the urgency of the material.

[0129] Based on the above embodiment, obtaining a material inventory table from the inventory management system includes:

[0130] Run the inventory extraction program, which pre-defines the extraction time period and material inventory information;

[0131] Extract information from the inventory management system based on the extraction time period and material inventory information to generate a material inventory table.

[0132] In a specific implementation process, the electronic device is loaded with an inventory extraction program, which is used to extract material inventory information from the ERP system. It is understandable that the extraction time period and the information of the extracted materials can be set in advance in the inventory extraction program, for example, the material inventory of the day of extraction can be set in advance, and the material information can include material code, supplier batch, unrestricted inventory sum, next three days inventory sum, material name, factory information, warehouse location, warehouse description, unrestricted inventory, quality inspection inventory, inventory unit, etc.

[0133] Therefore, by running the inventory extraction program, the required information can be extracted from the ERP system according to the extraction time period and material inventory information, and the extracted information can be used to generate a material inventory table. When generating a material inventory table, the material can be identified according to the material code and supplier batch, and the information belonging to the same material is regarded as one piece of material information, and multiple pieces of material information constitute a material inventory table. It can be understood that the material inventory table can be in the form of an EXCEL file. After obtaining the material inventory table, the material inventory table is stored in a specified path.

[0134] It should be noted that the inventory extraction program can be developed based on the RPA function of Uipath studio software.

[0135] The embodiment of the present application extracts information from the inventory management system through an inventory extraction program and generates a material inventory table, thereby providing data basis for whether subsequent materials require emergency inspection.

[0136] Based on the above embodiment, obtaining a material test table from a laboratory management system includes:

[0137] Run the sampling and extraction program, in which the material testing information to be extracted is predefined;

[0138] The material inspection information to be extracted is extracted from the laboratory management system to generate a material inspection table.

[0139] In the specific implementation process, the electronic device is loaded with a sampling and extraction program, which is used to extract material detection information from the LDMS system. It is understandable that the material detection information to be extracted can be set in advance in the material detection information, such as: test item code, test item name, material code, sample quantity, priority, supplier batch, applicant, detection time, tester, detection result, etc.

[0140] Therefore, by running the sampling and extraction program, it is possible to extract the pre-set material detection information from the LDMS system, and generate a material detection table with the extracted information. When generating a material detection table, the material can be identified according to the material code and supplier batch, and the information belonging to the same material is taken as one piece of material information, and multiple pieces of material information constitute a material detection table. It can be understood that the material detection table can be in the form of an EXCEL file. After obtaining the material detection table, the material detection table is stored in a specified path. In addition, the storage location of the material detection table can be the same as the storage location of the material inventory table.

[0141] It should be noted that the sample collection and extraction program can be developed based on the RPA function of the Uipath studio software.

[0142] The embodiment of the present application extracts information from the laboratory management system through a sampling and extraction program and generates a material inspection table, providing data basis for whether subsequent materials require emergency inspection.

[0143] On the basis of the above embodiment, after extracting target information from the material allocation table, the material inventory table and the material detection table based on the material information, the method further includes:

[0144] Generate an inventory analysis table based on the target information; the inventory analysis table also includes a warning field;

[0145] After determining whether the material needs to be inspected urgently based on the target information, the method further includes:

[0146] Update the warning field corresponding to the materials that need urgent inspection to the value representing the warning.

[0147] In a specific implementation process, after obtaining the target information, the electronic device can determine the uniqueness of the material based on the material code and supplier batch in the target information, and use the target information belonging to the same material as one piece of information in the inventory analysis table.

[0148] The warning field is used to indicate whether the material needs to be urgently tested. After obtaining the material that needs urgent testing, the electronic device sets the warning field corresponding to the material to a value that indicates the need for urgent testing. For example, it can be represented by "1" or "yes". It is understandable that other representation methods can also be used. In addition, when the warning field is yes, the field can also be marked with a pre-set color to achieve the purpose of reminding the tester.

[0149] The embodiment of the present application can prompt the inspection personnel to inspect the materials in a timely manner by issuing an early warning for the materials that require urgent inspection.

[0150] Based on the above embodiment, the method further includes:

[0151] Scan the label on the material to be tested by a barcode scanning device to obtain the information of the material to be tested;

[0152] The information matching program is used to match the test material information with the sampling plan table to generate a test plan; the sampling plan table stores the test items and test frequencies of each material; the test plan is used to instruct material test personnel on the plan for testing the material.

[0153] In the specific implementation process, a label describing the information of the material to be detected is affixed to the material to be detected, and the label can be a QR code, a barcode, etc. The code scanning device is connected to the electronic device for communication, and the code scanning device can obtain sample information of the material to be detected by scanning the label, and the sample information includes but is not limited to the material name, material code, supplier batch, material quantity, warehouse location, etc. The obtained sample information is transmitted to the designated location of the electronic device. After the electronic device obtains the sample information, it can determine the detection scheme from the sampling plan table based on the unique identifier used to characterize the material to be detected in the sample information (for example: material code and supplier batch). It should be noted that the sampling plan table stores detection schemes corresponding to a variety of materials, and these detection schemes are pre-established.

[0154] The embodiment of the present application utilizes a barcode scanning device to scan the label on the material to be inspected, and automatically generates an inspection plan in combination with a sampling plan table, thereby improving the efficiency of generating the inspection plan.

[0155] Based on the above embodiment, before extracting target information from the material allocation table, the material inventory table and the material detection table based on the material information, the method further includes:

[0156] Hyperlink the material inventory table, material inspection table and material allocation table.

[0157] In the specific implementation process, the electronic device can place the obtained material inventory table, material inspection table and material allocation table in the same path, and then perform hyperlink processing on them respectively, so that when the information in the material inventory table, material inspection table and material allocation table changes, the target information will be modified synchronously to achieve information synchronization. In addition, in addition to using hyperlink processing, the VLOOKUP function can also be used to achieve the association of the three tables and synchronization with the target information.

[0158] The embodiment of the present application performs hyperlink processing on the material inventory table, material inspection table and material allocation table, so that when the information in the material inventory table, material inspection table and material allocation table is updated, it can be synchronized with the target information, so that the urgency of the material to be inspected can be determined more accurately based on the target information.

[0159] Figure 3 A schematic diagram of material inventory analysis provided in an embodiment of the present application, such as Figure 3 As shown, taking electronic data as the starting point of the research, a scanner is used to replace manual identification of sample information (material name, supplier name, supplier batch, quantity), and the above information is automatically converted and transferred to the specified EXCEL file through the applet to replace manual filling. At the same time, the RPA program in the Uipath Studio software is introduced to write a program for automatic extraction of sample information to automatically obtain sample-related information in the inventory management system (ERP) and laboratory management system (LDMS) on a regular basis. Based on the above electronic information, a VBA matching program is written to associate and integrate the information of the three modules. At the same time, the material demand is automatically compared with the inventory setting to achieve the effect of automatically determining the urgency of the material and the purpose of online visualization of sample detection.

[0160] Figure 4 A schematic diagram of another material inventory analysis method provided in an embodiment of the present application is shown in FIG. Figure 4 As shown, the method includes:

[0161] Step 401: The scanner scans the material label to automatically obtain material information and inspection plan;

[0162] Step 402: The electronic device obtains the material inventory table from the ERP system and the material inspection table from the LDMS system on a regular basis every day.

[0163] Step 403: Obtain the testing time of each testing item of the material and the material demand within three days.

[0164] Step 404: The above information is associated and matched based on the material code and supplier batch to form a visual inventory analysis table.

[0165] Step 405: Compare the material demand and inventory to determine whether the material needs urgent testing, and issue an early warning notification for the material that needs urgent testing.

[0166] Step 406: The laboratory staff sorts based on the warnings to determine the order in which the materials should be tested. After the tests are completed, the inventory is updated, the urgency of the materials changes, and the process continues in a cycle.

[0167] It should be noted that the order of the above steps can be adjusted according to actual conditions, and there may be steps for parallel processing in the above steps.

[0168] Figure 5 This is a schematic diagram of a material inventory analysis device provided in an embodiment of the present application. The device may be a module, program segment or code on an electronic device. It should be understood that the device is similar to the above-mentioned Figure 2 The method embodiment corresponds to and can be executed Figure 2 The various steps involved in the method embodiment and the specific functions of the device can be found in the above description. To avoid repetition, detailed description is appropriately omitted here. The device includes: a first table acquisition module 501, a second table acquisition module 502, an information extraction module 503 and a detection module 504, wherein:

[0169] The first table acquisition module 501 is used to obtain a material inventory table from the inventory management system; the material inventory table is used to represent the inventory status of each material;

[0170] The second table acquisition module 502 is used to obtain a material inspection table from the laboratory management system; wherein the material inventory table and the material inspection table correspond to the same time period; the material inspection table is used to represent the inspection information corresponding to each material to be inspected;

[0171] The information extraction module 503 is used to extract target information from the material allocation table, the material inventory table and the material inspection table based on the material information; the material allocation table contains the required inspection time and material demand for each inspection item corresponding to the material;

[0172] The detection module 504 is used to determine the urgency of testing each material to be tested in the material testing table based on the target information.

[0173] Based on the above embodiment, the target information includes the inventory of the material and the material demand corresponding to the preset time; the detection module 504 is specifically used for:

[0174] If the inventory is less than the material demand, it is determined that the material needs to be urgently tested.

[0175] Based on the above embodiment, the device further includes a sorting module, which is used to:

[0176] If there are multiple materials that are determined to be materials that require urgent testing, the ratio of the corresponding inventory to the material demand of each material is obtained;

[0177] The detection order of each material is determined according to the ratio.

[0178] Based on the above embodiment, the target information includes the inventory of materials, the inspection time of materials, the inspection duration and the material demand corresponding to the preset duration; the inspection module 504 is specifically used for:

[0179] Determine the future inventory based on the inventory, the inspection time and the inspection duration;

[0180] According to the fact that the future inventory is less than the material demand, it is determined that an emergency inspection of the material is required.

[0181] Based on the above embodiment, the target information includes the inventory of the material, the material demand, the detection time and the material consumption rate; the detection module 504 is specifically used for:

[0182] Obtaining material consumption according to the detection duration and the material consumption rate;

[0183] If the inventory is less than the material demand, and the material consumption is greater than a preset multiple of the inventory, it is determined that an emergency inspection of the material is required; wherein the preset multiple is a positive number less than 1.

[0184] Based on the above embodiment, the first table acquisition module 501 is specifically used for:

[0185] Running an inventory extraction program, wherein the inventory extraction program predefines an extraction time period and material inventory information;

[0186] Information is extracted from the inventory management system based on the extraction time period and the material inventory information to generate the material inventory table.

[0187] Based on the above embodiment, the second table acquisition module 502 is specifically used for:

[0188] Running a sampling and extraction program, wherein the sampling and extraction program predefines the material detection information to be extracted;

[0189] The material detection information to be extracted is extracted from the laboratory management system to generate the material detection table.

[0190] Based on the above embodiment, the device further includes an early warning module, which is used to:

[0191] Generate an inventory analysis table based on the target information; the inventory analysis table also includes a warning field;

[0192] After determining the urgency of testing the material based on the target information, the warning field corresponding to the material that needs urgent testing is updated to a value representing a warning.

[0193] Based on the above embodiment, the device further includes a solution generating module, which is used to:

[0194] Scan the label on the material to be tested by a barcode scanning device to obtain the information of the material to be tested;

[0195] The test material information is matched with the sampling plan table by using an information matching program to generate a test plan; wherein the sampling plan table stores the test items and test frequencies of each material; the test plan is used to indicate the plan for material testing personnel to test the material.

[0196] Based on the above embodiment, the device further includes a hyperlink module, which is used to:

[0197] The material inventory table, the material inspection table and the material allocation table are hyperlinked.

[0198] Figure 6 A schematic diagram of the physical structure of an electronic device provided in an embodiment of the present application, such as Figure 6 As shown, the electronic device includes: a processor (processor) 601, a memory (memory) 602 and a bus 603; wherein,

[0199] The processor 601 and the memory 602 communicate with each other via the bus 603;

[0200] The processor 601 is used to call the program instructions in the memory 602 to execute the methods provided by the above-mentioned method embodiments, for example, including: obtaining a material inventory table from an inventory management system; the material inventory table is used to characterize the inventory status of each material; obtaining a material inspection table from a laboratory management system; wherein the time periods corresponding to the material inventory table and the material inspection table are the same; the material inspection table is used to characterize the inspection information corresponding to each material to be inspected; extracting target information from the material allocation table, the material inventory table and the material inspection table based on the material information; the material allocation table contains the inspection time and material demand required for each inspection item corresponding to the material; determining the urgency of inspecting each material to be inspected in the material inspection table based on the target information.

[0201] The processor 601 may be an integrated circuit chip with signal processing capabilities. The processor 601 may be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it may also be a digital signal processor (DSP), an application-specific integrated circuit (ASIC), a field programmable gate array (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components. It may implement or execute various methods, steps and logic block diagrams disclosed in the embodiments of the present application. A general-purpose processor may be a microprocessor or the processor may also be any conventional processor, etc.

[0202] The memory 602 may include but is not limited to random access memory (RAM), read only memory (ROM), programmable read-only memory (PROM), erasable programmable read-only memory (EPROM), electrically erasable read-only memory (EEPROM), etc.

[0203] The present embodiment discloses a computer program product, which includes a computer program stored on a non-transitory computer-readable storage medium, and the computer program includes program instructions. When the program instructions are executed by a computer, the computer can execute the methods provided by the above-mentioned method embodiments, for example, including: obtaining a material inventory table from an inventory management system; the material inventory table is used to characterize the inventory status of each material; obtaining a material inspection table from a laboratory management system; wherein the time periods corresponding to the material inventory table and the material inspection table are the same; the material inspection table is used to characterize the inspection information corresponding to each material to be inspected; based on the material information, target information is extracted from the material allocation table, the material inventory table and the material inspection table; the material allocation table contains the inspection time and material demand required for each inspection item corresponding to the material; based on the target information, the urgency of inspecting each material to be inspected in the material inspection table is determined.

[0204] The present embodiment provides a non-transitory computer-readable storage medium, which stores computer instructions, and the computer instructions enable the computer to execute the methods provided by the above-mentioned method embodiments, for example, including: obtaining a material inventory table from an inventory management system; the material inventory table is used to characterize the inventory status of each material; obtaining a material inspection table from a laboratory management system; wherein the time periods corresponding to the material inventory table and the material inspection table are the same; the material inspection table is used to characterize the inspection information corresponding to each material to be inspected; extracting target information from the material allocation table, the material inventory table and the material inspection table based on the material information; the material allocation table contains the inspection time and material demand required for each inspection item corresponding to the material; and determining the urgency of inspecting each material to be inspected in the material inspection table based on the target information.

[0205] In the embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. The device embodiments described above are merely schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some communication interfaces, and the indirect coupling or communication connection of the devices or units can be electrical, mechanical or other forms.

[0206] In addition, the units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0207] Furthermore, the functional modules in the various embodiments of the present application may be integrated together to form an independent part, or each module may exist independently, or two or more modules may be integrated to form an independent part.

[0208] In this document, relational terms such as first and second, etc. are used merely to distinguish one entity or operation from another entity or operation, but do not necessarily require or imply any such actual relationship or order between these entities or operations.

[0209] The above description is only an embodiment of the present application and is not intended to limit the protection scope of the present application. For those skilled in the art, the present application may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application shall be included in the protection scope of the present application.

Claims

1. A material inventory analysis method, characterized in that: include: Get the material inventory table from the inventory management system; The material inventory table is used to represent the inventory status of each material; Obtain a material inspection table from the laboratory management system; wherein the material inventory table and the material inspection table correspond to the same time period; and the material inspection table is used to characterize the inspection information corresponding to each material to be inspected; Extract target information from the material allocation table, the material inventory table and the material inspection table based on the material information; the material allocation table includes the inspection time and material demand required for each inspection item corresponding to the material; The urgency of testing each material to be tested in the material testing table is determined based on the target information.

2. The method according to claim 1, characterized in that The target information includes the inventory of materials and the material demand corresponding to the preset time; the step of determining the urgency of testing each material to be tested in the material testing table based on the target information includes: If the inventory is less than the material demand, it is determined that the material needs to be urgently tested.

3. The method according to claim 2, characterized in that The method further comprises: If there are multiple materials that are determined to be materials that require urgent testing, the ratio of the corresponding inventory to the material demand of each material is obtained; The detection order of each material is determined according to the ratio.

4. The method according to claim 1, characterized in that: The target information includes the inventory of materials, the time when materials are sent for inspection, the inspection duration, and the material demand corresponding to the preset duration; The determining, based on the target information, the urgency of testing each material to be tested in the material testing table includes: Determine the future inventory based on the inventory, the inspection time and the inspection duration; According to the fact that the future inventory is less than the material demand, it is determined that the material needs to be urgently tested.

5. The method according to claim 1, characterized in that: The target information includes the inventory, material demand, detection time and material consumption rate of the material; the urgency of detecting each material to be detected in the material detection table based on the target information includes: Obtaining material consumption according to the detection duration and the material consumption rate; If the inventory is less than the material demand, and the material consumption is greater than a preset multiple of the inventory, it is determined that an emergency inspection of the material is required; wherein the preset multiple is a positive number less than 1.

6. The method according to claim 1, characterized in that The obtaining of the material inventory table from the inventory management system includes: Running an inventory extraction program, wherein the inventory extraction program predefines an extraction time period and material inventory information; Information is extracted from the inventory management system based on the extraction time period and the material inventory information to generate the material inventory table.

7. The method according to claim 1, characterized in that The obtaining of the material test table from the laboratory management system includes: Running a sampling and extraction program, wherein the sampling and extraction program predefines the material detection information to be extracted; The material detection information to be extracted is extracted from the laboratory management system to generate the material detection table.

8. The method according to claim 1, characterized in that: After extracting target information from the material allocation table, the material inventory table and the material detection table based on the material information, the method further includes: Generate an inventory analysis table based on the target information; the inventory analysis table also includes a warning field; After determining the urgency of testing the material based on the target information, the method further includes: Update the warning field corresponding to the materials that need urgent inspection to the value representing the warning.

9. The method according to claim 1, characterized in that: The method further comprises: Scan the label on the material to be tested by a barcode scanning device to obtain the information of the material to be tested; The test material information is matched with the sampling plan table by using an information matching program to generate a test plan; wherein the sampling plan table stores the test items and test frequencies of each material; the test plan is used to indicate the plan for material testing personnel to test the material.

10. The method according to any one of claims 1 to 9, characterized in that: Before extracting target information from the material allocation table, the material inventory table and the material detection table based on the material information, the method further includes: The material inventory table, the material inspection table and the material allocation table are hyperlinked.

11. A material inventory analysis device, characterized in that: include: The first table acquisition module is used to obtain the material inventory table from the inventory management system; The material inventory table is used to represent the inventory status of each material; The second table acquisition module is used to obtain a material inspection table from the laboratory management system; wherein the material inventory table and the material inspection table correspond to the same time period; and the material inspection table is used to characterize the inspection information corresponding to each material to be inspected; An information extraction module is used to extract target information from a material allocation table, the material inventory table and the material inspection table based on material information; the material allocation table contains the required inspection time and material demand for each inspection item corresponding to the material; The detection module is used to determine the urgency of detecting each material to be detected in the material detection table based on the target information.

12. An electronic device, characterized in that: include: processor, memory and bus, wherein, The processor and the memory communicate with each other via the bus; The memory stores program instructions that can be executed by the processor, and the processor calls the program instructions to execute the method according to any one of claims 1 to 10.

13. A non-transitory computer-readable storage medium, characterized in that: The non-transitory computer-readable storage medium stores computer instructions, which, when executed by a computer, cause the computer to perform the method according to any one of claims 1 to 10.

14. A computer program product, characterized in that The method comprises computer program instructions, and when the computer program instructions are read and executed by a processor, the method according to any one of claims 1 to 10 is executed.

Images