CN116128439A - Method, device, equipment and medium for tracking quality information of veneer products - Google Patents
Method, device, equipment and medium for tracking quality information of veneer products Download PDFInfo
- Publication number
- CN116128439A CN116128439A CN202211683419.2A CN202211683419A CN116128439A CN 116128439 A CN116128439 A CN 116128439A CN 202211683419 A CN202211683419 A CN 202211683419A CN 116128439 A CN116128439 A CN 116128439A
- Authority
- CN
- China
- Prior art keywords
- product
- quality
- tracking
- production
- information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/20—Software design
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06395—Quality analysis or management
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Economics (AREA)
- General Engineering & Computer Science (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- Software Systems (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Game Theory and Decision Science (AREA)
- General Factory Administration (AREA)
Abstract
The invention provides a method, a device, equipment and a medium for tracking quality information of a veneer product, wherein the method comprises the following steps: establishing a central database, sequentially interfacing with a ERP, WMS, WCS, MES system through an application programming interface, and completing testing of interfaces, flows and data circulation; automatically acquiring a quality inspection record of the whole life cycle related process of the product through manual input and from a ERP, WMS, WCS, MES system, and storing the quality inspection record in a central database; and analyzing and tracking the reasons of the problems related to the product quality according to the quality inspection record, and optimizing and improving the problems based on the reasons of the problems. The method for tracking the quality information of the veneer products integrates the product quality inspection related information of a plurality of systems, so that the extraction and analysis of inspection data are quicker and more convenient, the use of paper inspection sheets is reduced, the problem of information storage is solved, and therefore, the cost and efficiency can be reduced, and the resources are saved.
Description
Technical Field
The invention relates to the technical field of product production quality tracking, in particular to a method, a device, equipment and a medium for tracking quality information of a veneer product.
Background
With the rapid development of industry, various veneer products are available to meet the high quality demands of people, and before a veneer is delivered to a customer, quality inspection and quality control are required to be performed on veneer raw materials, production processes, finished products and the like, and the quality of the veneer is accurately tracked in a whole process.
Because the veneer has multiple product patterns, multiple effects, multiple colors and multiple numbers, the quality detection items of the whole life cycle are multiple, and different product types need different detection methods. At present, paper documents or electronic documents are often used for veneer inspection, the problems of each product cannot be classified and analyzed, and as different inspection project data are not uniformly stored, the quality of the product is difficult to analyze and track effectively, the condition that the detection states of different products are mixed easily occurs, so that the workload of inspection staff is large, the efficiency is low, the inspection cost is increased, and feedback of customers on the quality problems and comments of the veneer products cannot be obtained timely.
Disclosure of Invention
In view of the above, the present invention provides a method, apparatus, device and medium for tracking quality information of a veneer product, which solves the problems of confusing product information status, large inspection workload, high cost, and incapability of tracking quality of the product.
In order to achieve the above purpose, the present invention provides the following technical solutions:
in a first aspect, an embodiment of the present invention provides a method for tracking quality information of a veneer product, including:
establishing a central database, sequentially interfacing with a ERP, WMS, WCS, MES system through an application programming interface, and completing testing of interfaces, flows and data circulation;
automatically acquiring a quality inspection record of the whole life cycle related process of the product through manual input and from a ERP, WMS, WCS, MES system, and storing the quality inspection record in a central database;
and analyzing and tracking the reasons of the problems related to the product quality according to the quality inspection record, and optimizing and improving the problems based on the reasons of the problems.
The method for tracking the quality information of the veneer product integrates the product quality inspection related information of a plurality of systems, so that the extraction and analysis of inspection data are quicker and more convenient, the use of paper inspection sheets is reduced, the problem of information storage is solved, the cost is reduced, the efficiency is improved, and the resources are saved.
Optionally, the product comprises throughout its life cycle: material supply, pre-production, production process, finished product, pre-sale and after-sale.
The embodiment of the invention tests and tracks the quality of the product from the supply of the product to the after-sale of the product, ensures the visualization and traceability of the production information of the product, and is beneficial to the data statistics and the data analysis according to the statistics.
Optionally, the process of obtaining data from the ERP system through the application programming interface includes:
basic data is acquired from the ERP system to perfect the purchasing process, the selling process and the financial management process.
According to the veneer product quality information tracking method provided by the embodiment of the invention, through communication with the ERP, basic data of a product is automatically acquired, the data acquisition efficiency is improved, the working flow is simplified based on the data perfecting flow, and the working efficiency of each department is improved.
Optionally, the process of interfacing with the WMS and WCS systems through the application programming interface includes:
and (3) performing program butt joint between the WMS and the WCS system through an application programming interface, and performing out-in-warehouse flow test and related report development.
Optionally, interfacing with the MES system through the application programming interface includes:
and testing and perfecting the processes of material calling, material feeding, material returning, inspection management, material transferring, bar code printing and finishing.
According to the veneer product quality information tracking method provided by the embodiment of the invention, the application programming interface is in butt joint with the individual systems, and the whole production flow is tested, so that the accuracy and stability of veneer product quality information tracking are ensured.
Optionally, the analyzing and tracking the reasons for the problems related to the product quality according to the quality test record includes:
analyzing the qualification rate of the materials of the suppliers according to the quality inspection records of the incoming materials, and managing the suppliers;
analyzing warehouse inventory conditions according to the prenatal quality inspection records, and managing warehouse inventory;
analyzing the reasons for generating defective products according to the production process and the quality inspection record of the finished product: artificial, equipment or raw materials, and carrying out production management;
analyzing warehouse inventory conditions according to the pre-sale quality inspection records, and managing warehouse inventory;
and according to the after-sale quality inspection records, combining the product basic data with the quality inspection records of incoming materials, pre-production, production process, finished products and pre-sale products, analyzing reasons and solving problems.
In practical application, data analysis is performed according to quality inspection records in the whole production process of the product, so that the problems are found out and solved, and the qualification rate and quality of the product are improved.
Optionally, the inspection and recording is performed by managing the material bar codes of the incoming materials and the finished products, wherein:
the information recorded by the material bar code of the incoming material comprises: material bar code, material name, material specification, batch number, production date, manufacturer, supplier, customer information, creation time, creator;
the information recorded by the bar code of the material of the finished product comprises: material bar code, material name, material specification, batch number, date of production, manufacturer, supplier, customer information, date of production, production shop, production machine, producer, production time, creation time, creator.
In practical application, the material bar codes of the incoming materials and the finished products are managed to be inspected and recorded, and inspection rules are formulated, so that the quality inspection and tracking of the products can be more comprehensively facilitated, the inspection effect is ensured, and the data tracking is facilitated.
In a second aspect, an embodiment of the present invention provides a veneer product quality information tracking apparatus, including:
the docking module is used for establishing a central database, sequentially docking with the ERP, WMS, WCS, MES system through an application programming interface and completing the testing of interfaces, flows and data circulation;
the acquisition recording module is used for automatically acquiring quality inspection records of the whole life cycle related process of the product through manual input and from a ERP, WMS, WCS, MES system and storing the quality inspection records in a central database;
and the tracking module is used for analyzing and tracking the reasons of the problems related to the product quality according to the quality inspection record and optimizing and improving the problems based on the reasons of the problems.
The veneer product quality information tracking device provided by the embodiment of the invention integrates product quality inspection related information of a plurality of systems, so that the extraction and analysis of inspection data are quicker and more convenient, the use of paper inspection sheets is reduced, the information storage problem is solved, the cost is reduced, the efficiency is improved, and the resources are saved.
In a third aspect, an embodiment of the present invention provides a computer apparatus, including: the system comprises a memory and a processor, wherein the memory and the processor are in communication connection, the memory stores computer instructions, and the processor executes the computer instructions, thereby executing the method in the first aspect or any optional implementation manner of the first aspect.
In a fourth aspect, embodiments of the present invention provide a computer-readable storage medium storing computer instructions for causing a computer to perform the method of the first aspect, or any one of the alternative embodiments of the first aspect.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are needed in the description of the embodiments or the prior art will be briefly described, and it is obvious that the drawings in the description below are some embodiments of the present invention, and other drawings can be obtained according to the drawings without inventive effort for a person skilled in the art.
Fig. 1 is a flowchart of a method for tracking quality information of a veneer product according to an embodiment of the present invention;
fig. 2 is an application flowchart of a method for tracking quality information of a veneer product according to an embodiment of the present invention in a specific embodiment;
fig. 3 is a schematic structural diagram of a quality information tracking device for a veneer product according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a computer device according to an embodiment of the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are some embodiments of the present invention, but not all embodiments of the present invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to fall within the scope of the invention.
In the description of the present invention, it should be noted that the directions or positional relationships indicated by the terms "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inner", "outer", etc. are based on the directions or positional relationships shown in the drawings, are merely for convenience of describing the present invention and simplifying the description, and do not indicate or imply that the devices or elements referred to must have a specific orientation, be configured and operated in a specific orientation, and thus should not be construed as limiting the present invention. Furthermore, the terms "first," "second," and "third" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance.
In the description of the present invention, it should be noted that, unless explicitly specified and limited otherwise, the terms "mounted," "connected," and "connected" are to be construed broadly, and may be either fixedly connected, detachably connected, or integrally connected, for example; can be mechanically or electrically connected; the two components can be directly connected or indirectly connected through an intermediate medium, or can be communicated inside the two components, or can be connected wirelessly or in a wired way. The specific meaning of the above terms in the present invention can be understood by those of ordinary skill in the art according to the specific circumstances.
The technical features of the different embodiments of the invention described below may be combined with one another as long as they do not conflict with one another.
Example 1
The embodiment of the invention provides a method for tracking quality information of a veneer product, which is shown in fig. 1, and specifically comprises the following steps:
step S1: a central database is established, which is in turn interfaced with enterprise resource planning (Enterprise Resource Planning, ERP), warehouse management system (Warehouse Manage System, WMS), warehouse control system (Warehouse Control System, WCS), manufacturing execution system (Manufacturing Execution System, MES) through application programming interfaces, and the testing of interfaces, flows and data flows is completed.
Illustratively, in a production management system for a veneer, basic data (e.g., material information, customer information, user information, etc.) for all products is built in an ERP system for other system calls. The ERP system has the main functions of: (1) The order planning part formulates a purchase request application form according to the sales condition of the sales order, the lead audit is followed by a purchase order, the purchase part carries out the audit of the purchase order form, the purchase order flow is completed, and the information is pushed to a provider module of the WMS system through an application programming interface (Application Programming Interface, API) standard; (2) The order manager establishes a sales order in ERP, if the sales order is not in stock, the production order is transferred, and the production order is pushed to an MES system through an API standard interface; (3) After the production order is finished and the finished product is put in storage, an order manager generates a sales delivery order, and the sales delivery order information is pushed to the WMS through an API standard interface; (4) The method comprises the steps that firstly, a commodity management personnel is required to conduct material inspection, inspection sheet information is manually input into an MES system, the commodity can be returned truly, an order management part pushes return information to a WMS system through an API standard interface after the process is completed according to the inspection sheet, if customers need to supplement commodity, the commodity management system pushes production orders to the MES system through the API standard interface after the ERP walks the commodity returning process.
Specifically, in one embodiment, a process for obtaining data from an ERP system through an application programming interface includes: basic data is acquired from the ERP system to perfect the purchasing process, the selling process and the financial management process. According to the veneer product quality information tracking method provided by the embodiment of the invention, through communication with the ERP system, basic data of a product is automatically acquired, the data acquisition efficiency is improved, the working flow is simplified based on the data perfecting flow, and the working efficiency of each department is improved.
Illustratively, WMS systems are used for warehouse management, with the main functions of: (1) After receiving purchase information pushed by the ERP system, a provider module of the WMS system sorts goods, prints corresponding raw material delivery bar codes according to the purchase orders, pastes the bar codes on the packaged raw materials, and transports the packaged raw materials to a production factory along with the raw materials; (2) After raw materials are transported to a factory, the warehouse department firstly needs to check related information, quality personnel carry out raw material spot check and input into an MES system, and after the quality is qualified, warehouse entry is carried out; (3) After the warehouse-in conveying track detects materials, warehouse-in conveying is carried out, after the fixed code scanning device of the track scans codes successfully, the WMS forms a warehouse-in job ticket, and warehouse-in job ticket information is pushed to the WCS system through an API standard interface, if the materials are returned to warehouse, finished products are warehouse-in, and after the materials are warehouse-in successfully, the WMS system returns warehouse-in information to the source bill system; (4) After sales and delivery, the finished products are delivered, inspection staff need to carry out quality spot check on the products, and inspection sheets are input into an MES system. The WCS system is used for equipment management, executing a warehouse-in and warehouse-out instruction, setting a warehouse three-dimensional warehouse rule, and has the main functions of: (1) Receiving the warehousing operation information of the WMS, executing a warehousing instruction, and pushing the warehousing information to the WMS by the WCS after the warehousing is successful, wherein the WMS increases the inventory data; (2) Receiving the ex-warehouse operation information of the WMS, positioning the position of the material according to the bar code information of the ex-warehouse material by the WCS, executing the ex-warehouse instruction, scanning the code from the material ex-warehouse to the ex-warehouse gallery, returning the ex-warehouse information to the WMS system through an API standard interface after the successful ex-warehouse is shown by the successful code scanning, and deducting the inventory data by the WMS system; (3) And in special cases such as no-bill warehouse-in and warehouse-out and emergency warehouse-in, manual bill making in an ERP system is needed, and equipment is manually operated to carry out warehouse-in and warehouse-out.
Specifically, in one embodiment, the process of interfacing with WMS, WCS systems through an application programming interface includes: and (3) performing program butt joint between the WMS and the WCS system through an application programming interface, and performing out-in-warehouse flow test and related report development.
Illustratively, the MES system is used to perform order production tasks with the main functions of: (1) Receiving ERP production order information, and performing production scheduling and production execution; (2) During production, the material is called according to the production order requirement, and the material calling list is pushed to the WMS; (3) Receiving the delivery confirmation information (containing delivery bar codes) pushed by the WMS, scanning and loading by using bar codes by a production workshop machine (due to the characteristics of veneer products, loading a bag of base material plates and a bag of base paper at a time during loading, and just consuming the base material after production, and reporting a bag of finished products at the moment, wherein the operation is mainly to track the material batch from raw materials to finished products), performing raw material quality sampling inspection by workshop quality management personnel before loading by the machine, and inputting inspection information into a system; (4) Quality sampling inspection is carried out by quality management personnel in the production process and after the production is finished, inspection sheet information is input into the MES, and when an unqualified product exists, the system deducts the corresponding raw material quantity, such as insufficient raw material, and the MES system needs to supplement materials; (5) After the production order is finished, printing bar codes and pasting the bar codes on finished products, forklift fork-loading and conveying the bar codes to a loading and conveying rail for loading, and pushing finishing information to an ERP system through an API standard interface when the whole order is finished.
Specifically, in one embodiment interfacing with the MES system through the application programming interface comprises: and testing and perfecting the processes of material calling, material feeding, material returning, inspection management, material transferring, bar code printing and finishing. According to the veneer product quality information tracking method provided by the embodiment of the invention, the application programming interface is in butt joint with the individual systems, and the whole production flow is tested, so that the accuracy and stability of veneer product quality information tracking are ensured.
Step S2: the quality inspection record of the whole life cycle related flow of the product is automatically acquired through manual input and from a ERP, WMS, WCS, MES system and is stored in a central database.
Specifically, in one embodiment, the entire life cycle of the product includes: material supply, pre-production, production process, finished product, pre-sale and after-sale. The embodiment of the invention tests and tracks the quality of the product from the supply of the product to the after-sale of the product, ensures the visualization and traceability of the production information of the product, and is beneficial to the data statistics and the data analysis according to the statistics.
Step S3: and analyzing and tracking the reasons of the problems related to the product quality according to the quality inspection record, and optimizing and improving the problems based on the reasons of the problems.
Specifically, in one embodiment, the analysis of tracking the causes of product quality related problems based on quality check records includes: analyzing the qualification rate of the materials of the suppliers according to the quality inspection records of the incoming materials, and managing the suppliers; analyzing warehouse inventory conditions according to the prenatal quality inspection records, and managing warehouse inventory; analyzing the reasons for generating defective products according to the production process and the quality inspection record of the finished product: artificial, equipment or raw materials, and carrying out production management; analyzing warehouse inventory conditions according to the pre-sale quality inspection records, and managing warehouse inventory; and according to the after-sale quality inspection records, combining the product basic data with the quality inspection records of incoming materials, pre-production, production process, finished products and pre-sale products, analyzing reasons and solving problems. In practical application, data analysis is performed according to quality inspection records in the whole production process of the product, so that the problems are found out and solved, and the qualification rate and quality of the product are improved.
Specifically, in one embodiment, the material bar codes of the incoming materials and the finished products are managed to be checked and recorded, wherein the information recorded by the material bar codes of the incoming materials comprises: material bar code, material name, material specification, batch number, production date, manufacturer, supplier, customer information, creation time, creator; the information recorded by the bar code of the material of the finished product comprises: material bar code, material name, material specification, batch number, date of production, manufacturer, supplier, customer information, date of production, production shop, production machine, producer, production time, creation time, creator. In practical application, the material bar codes of the incoming materials and the finished products are managed to be inspected and recorded, and inspection rules are formulated, so that the quality inspection and tracking of the products can be more comprehensively facilitated, the inspection effect is ensured, and the data tracking is facilitated.
Illustratively, product quality information verification and tracking is added to the ERP, WMS, WCS, MES system, the complete production flow is shown in FIG. 2, where the oval represents execution in the MES system, the hexagonal represents execution in the WMS system, the rectangular represents execution in the ERP system, and the double rectangular represents execution in the WCS system. The complete production process is as follows:
and (3) material charging: the sales personnel receives the order and inputs the ERP system, the order planning part makes a purchase plan according to the order, the purchasing department makes purchases, the suppliers sort goods and print bar codes in the WMS system, the vehicles are transported to the factory, and the quality inspection of the materials of the MES system is generated after the quality inspection of the materials is qualified;
before production: the warehouse manager scans and stores materials of the WMS system, the order planning part converts sales orders of the ERP system into production orders, the order planning part arranges production groups to produce and arrange production of the MES system, a workshop machine platform calls materials of the MES system according to the production orders, the warehouse manager generates a work order of the WMS system for delivery according to the call materials, the WCS system executes a delivery instruction, returns the instruction to the WMS system after the delivery is successful, the WMS system pushes a delivery confirmation order to the MES system, and workshop quality control personnel conduct spot check on raw materials to form a raw material inspection list of the MES system;
the production process comprises the following steps: the machine production personnel scan the two-dimensional code feeding on the material, the production process is executed, the production process quality personnel perform spot check at any time, and the AI camera performs real-time check to form a production inspection list;
and (3) producing a finished product: after the production is finished, the product management personnel carry out inspection to form a finished product inspection list, and the production personnel produce and report the completion and push the completion information to an ERP system, print and paste two-dimensional codes, and scan the codes by a code scanning device for storage;
before sale: the order planning part makes a sales delivery bill according to the finishing information and the finished product warehousing information, the ERP system sales delivery bill is converted into a WMS delivery job bill, the WCS system executes the delivery instruction, the delivery instruction is returned to the WMS system after successful delivery, and quality personnel performs sales inspection to form a sales inspection bill, and the vehicle is loaded and transported to a customer;
after sale: if a customer finds a quality problem to perform quality feedback, a checker performs after-sale quality check and judges to form an after-sale check list, an order planning part generates an after-sale check list according to the after-sale check list, the ERP system returns the after-sale check list to a WMS system to enter an order, the WCS system executes an entering order, the after-sale check list returns the order to the WMS system, an order planning part generates a production order according to the customer demand, and the ERP system production order changes to an MES system to carry out scheduling production.
The veneer product quality information tracking method provided by the embodiment of the invention integrates the product quality inspection related information of a plurality of systems, realizes data sharing, ensures that the extraction and analysis of inspection data are quicker and more convenient, and basically performs quality control from raw materials, material storage, production execution, process setting, finished product storage and after-sales tracking, reduces the use of paper inspection sheets, solves the problem of information storage, can reduce cost and efficiency, saves resources, reduces inspection time and analysis time of inspection personnel, and realizes the integration of quality management.
Example 2
The embodiment of the invention provides a veneer product quality information tracking device, as shown in fig. 3, which comprises:
the docking module 1 is used for establishing a central database, sequentially docking with the ERP, WMS, WCS, MES system through an application programming interface and completing testing of interfaces, processes and data circulation. Details refer to the related description of step S1 in the above method embodiment, and will not be described herein.
The acquisition record module 2 is used for automatically acquiring the quality inspection record of the whole life cycle related process of the product through manual entry and from the ERP, WMS, WCS, MES system, and storing the quality inspection record in a central database. For details, refer to the related description of step S2 in the above method embodiment, and no further description is given here.
And the tracking module 3 is used for analyzing and tracking the reasons of the problems related to the product quality according to the quality inspection records and optimizing and improving the problems based on the reasons of the problems. For details, refer to the related description of step S3 in the above method embodiment, and no further description is given here.
The veneer product quality information tracking device provided by the embodiment of the invention integrates product quality inspection related information of a plurality of systems, so that the extraction and analysis of inspection data are quicker and more convenient, the use of paper inspection sheets is reduced, the information storage problem is solved, the cost is reduced, the efficiency is improved, and the resources are saved.
Example 3
Fig. 4 shows a schematic structural diagram of a computer device according to an embodiment of the present invention, including: a processor 901 and a memory 902, wherein the processor 901 and the memory 902 may be connected by a bus or otherwise, for example in fig. 4.
The processor 901 may be a central processing unit (Central Processing Unit, CPU). The processor 901 may also be other general purpose processors, digital signal processors (Digital Signal Processor, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC), field programmable gate arrays (Field-Programmable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or a combination thereof.
The memory 902 is used as a non-transitory computer readable storage medium for storing non-transitory software programs, non-transitory computer executable programs, and modules, such as program instructions/modules corresponding to the methods in the method embodiments described above. The processor 901 executes various functional applications of the processor and data processing, i.e., implements the methods in the above-described method embodiments, by running non-transitory software programs, instructions, and modules stored in the memory 902.
The memory 902 may include a storage program area and a storage data area, wherein the storage program area may store an operating system, at least one application program required for a function; the storage data area may store data created by the processor 901, and the like. In addition, the memory 902 may include high-speed random access memory, and may also include non-transitory memory, such as at least one magnetic disk storage device, flash memory device, or other non-transitory solid state storage device. In some embodiments, memory 902 optionally includes memory remotely located relative to processor 901, which may be connected to processor 901 via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
One or more modules are stored in the memory 902 that, when executed by the processor 901, perform the methods of the method embodiments described above.
The specific details of the computer device may be correspondingly understood by referring to the corresponding related descriptions and effects in the above method embodiments, which are not repeated herein.
It will be appreciated by those skilled in the art that implementing all or part of the above-described methods in the embodiments may be implemented by a computer program for instructing relevant hardware, and the implemented program may be stored in a computer readable storage medium, and the program may include the steps of the embodiments of the above-described methods when executed. The storage medium may be a magnetic Disk, an optical Disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), a Flash Memory (Flash Memory), a Hard Disk (HDD), or a Solid State Drive (SSD); the storage medium may also comprise a combination of memories of the kind described above.
Although embodiments of the present invention have been described in connection with the accompanying drawings, various modifications and variations may be made by those skilled in the art without departing from the spirit and scope of the invention, and such modifications and variations are within the scope of the invention as defined by the appended claims.
Claims (10)
1. The method for tracking the quality information of the veneer product is characterized by comprising the following steps of:
establishing a central database, sequentially interfacing with a ERP, WMS, WCS, MES system through an application programming interface, and completing testing of interfaces, flows and data circulation;
automatically acquiring a quality inspection record of the whole life cycle related process of the product through manual input and from a ERP, WMS, WCS, MES system, and storing the quality inspection record in a central database;
and analyzing and tracking the reasons of the problems related to the product quality according to the quality inspection record, and optimizing and improving the problems based on the reasons of the problems.
2. A method of tracking quality information of a veneer product according to claim 1, wherein the entire life cycle of the product comprises: material supply, pre-production, production process, finished product, pre-sale and after-sale.
3. A method of tracking trim panel product quality information as defined in claim 2, wherein the process of obtaining data from the ERP system via the application programming interface comprises:
basic data is acquired from the ERP system to perfect the purchasing process, the selling process and the financial management process.
4. A method for tracking quality information of a veneer product according to claim 2, wherein the interfacing with WMS and WCS systems via an application programming interface comprises:
and (3) performing program butt joint between the WMS and the WCS system through an application programming interface, and performing out-in-warehouse flow test and related report development.
5. A method of tracking trim panel product quality information according to claim 3, wherein interfacing with the MES system via the application programming interface comprises:
and testing and perfecting the processes of material calling, material feeding, material returning, inspection management, material transferring, bar code printing and finishing.
6. A method of tracking quality information of a veneer product according to claim 5, wherein said analyzing and tracking causes of product quality related problems based on said quality check record comprises:
analyzing the qualification rate of the materials of the suppliers according to the quality inspection records of the incoming materials, and managing the suppliers;
analyzing warehouse inventory conditions according to the prenatal quality inspection records, and managing warehouse inventory;
analyzing the reasons for generating defective products according to the production process and the quality inspection record of the finished product: artificial, equipment or raw materials, and carrying out production management;
analyzing warehouse inventory conditions according to the pre-sale quality inspection records, and managing warehouse inventory;
and according to the after-sale quality inspection records, combining the product basic data with the quality inspection records of incoming materials, pre-production, production process, finished products and pre-sale products, analyzing reasons and solving problems.
7. A method of tracking trim panel product quality information according to claim 6, wherein the inspection and recording is performed by managing material bar codes of incoming material and finished products, wherein:
the information recorded by the material bar code of the incoming material comprises: material bar code, material name, material specification, batch number, production date, manufacturer, supplier, customer information, creation time, creator;
the information recorded by the bar code of the material of the finished product comprises: material bar code, material name, material specification, batch number, date of production, manufacturer, supplier, customer information, date of production, production shop, production machine, producer, production time, creation time, creator.
8. A veneer product quality information tracking device, the device comprising:
the docking module is used for establishing a central database, sequentially docking with the ERP, WMS, WCS, MES system through an application programming interface and completing the testing of interfaces, flows and data circulation;
the acquisition recording module is used for automatically acquiring quality inspection records of the whole life cycle related process of the product through manual input and from a ERP, WMS, WCS, MES system and storing the quality inspection records in a central database;
and the tracking module is used for analyzing and tracking the reasons of the problems related to the product quality according to the quality inspection record and optimizing and improving the problems based on the reasons of the problems.
9. A computer device, comprising: a memory and a processor in communication with each other, the memory having stored therein computer instructions, the processor executing the computer instructions to perform the method of any of claims 1-7.
10. A computer readable storage medium storing computer instructions for causing a computer to perform the method of any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211683419.2A CN116128439A (en) | 2022-12-27 | 2022-12-27 | Method, device, equipment and medium for tracking quality information of veneer products |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211683419.2A CN116128439A (en) | 2022-12-27 | 2022-12-27 | Method, device, equipment and medium for tracking quality information of veneer products |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116128439A true CN116128439A (en) | 2023-05-16 |
Family
ID=86307277
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211683419.2A Pending CN116128439A (en) | 2022-12-27 | 2022-12-27 | Method, device, equipment and medium for tracking quality information of veneer products |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116128439A (en) |
-
2022
- 2022-12-27 CN CN202211683419.2A patent/CN116128439A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107831750B (en) | IMES intelligent manufacturing execution system | |
| CN105404243B (en) | Flow control and manufacturing execution system in industrial production line | |
| CN110580572B (en) | Product life-span traceability system | |
| Hwang et al. | Operational performance metrics in manufacturing process: based on SCOR model and RFID technology | |
| CN112116364A (en) | Production and manufacturing tracing system and platform | |
| Ping Yi et al. | Reducing electronic component losses in lean electronics assembly with Six Sigma approach | |
| Mohsen | Developments of digital technologies related to supply chain management | |
| CN111191991A (en) | Intelligent management system for reagent consumables in clinical laboratory | |
| CN112348530A (en) | Automatic server production inspection and repair method | |
| CN112308241A (en) | Robot production management system, method, device and storage medium | |
| CN113807651A (en) | Big data based component whole process management system, terminal equipment and management method | |
| CN116128439A (en) | Method, device, equipment and medium for tracking quality information of veneer products | |
| CN110826926A (en) | Intelligent manufacturing execution system for surface assembly production line | |
| CN110223015A (en) | Logistics Process link processing method, management system, device and storage equipment | |
| CN109977007B (en) | PLM (product development management) mold test management method and system | |
| EP1193630A1 (en) | Agile information system and management method | |
| CN112184185A (en) | ERP system of commercial concrete mixing plant | |
| Giorgetti et al. | HNCR model following robust approach | |
| Rahoui et al. | TDABC Capabilities for performance measurement: A case study in a manufacturing context | |
| Divakaran et al. | Review of Kanban planning and execution in the context of Lean manufacturing | |
| Tsung et al. | Six Sigma | |
| KR102337271B1 (en) | Global manufacturing execution system based on business rule management system | |
| CN117495254B (en) | Material management platform | |
| CN117611188A (en) | Material management method and system in industrial chain | |
| CN117495260A (en) | Enterprise warehouse management method, enterprise warehouse management device, enterprise warehouse management equipment, enterprise warehouse management storage medium and enterprise warehouse management program product |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |