CN110991571A - Material code scanning and warehousing information processing system and method based on ERP system - Google Patents

Material code scanning and warehousing information processing system and method based on ERP system Download PDF

Info

Publication number
CN110991571A
CN110991571A CN201911041711.2A CN201911041711A CN110991571A CN 110991571 A CN110991571 A CN 110991571A CN 201911041711 A CN201911041711 A CN 201911041711A CN 110991571 A CN110991571 A CN 110991571A
Authority
CN
China
Prior art keywords
module
product
information
warehousing
erp
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
Application number
CN201911041711.2A
Other languages
Chinese (zh)
Inventor
吴雷江
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ningbo Lingling Iron And Steel Industry Co ltd
Original Assignee
Ningbo Lingling Iron And Steel Industry Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Ningbo Lingling Iron And Steel Industry Co ltd filed Critical Ningbo Lingling Iron And Steel Industry Co ltd
Priority to CN201911041711.2A priority Critical patent/CN110991571A/en
Publication of CN110991571A publication Critical patent/CN110991571A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06KGRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
    • G06K17/00Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations
    • G06K17/0022Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisious for transferring data to distant stations, e.g. from a sensing device
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • G06Q10/0875Itemisation or classification of parts, supplies or services, e.g. bill of materials
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/103Workflow collaboration or project management
    • GPHYSICS
    • G08SIGNALLING
    • G08BSIGNALLING OR CALLING SYSTEMS; ORDER TELEGRAPHS; ALARM SYSTEMS
    • G08B5/00Visible signalling systems, e.g. personal calling systems, remote indication of seats occupied
    • G08B5/22Visible signalling systems, e.g. personal calling systems, remote indication of seats occupied using electric transmission; using electromagnetic transmission
    • G08B5/36Visible signalling systems, e.g. personal calling systems, remote indication of seats occupied using electric transmission; using electromagnetic transmission using visible light sources
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04WWIRELESS COMMUNICATION NETWORKS
    • H04W4/00Services specially adapted for wireless communication networks; Facilities therefor
    • H04W4/30Services specially adapted for particular environments, situations or purposes
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04WWIRELESS COMMUNICATION NETWORKS
    • H04W84/00Network topologies
    • H04W84/02Hierarchically pre-organised networks, e.g. paging networks, cellular networks, WLAN [Wireless Local Area Network] or WLL [Wireless Local Loop]
    • H04W84/10Small scale networks; Flat hierarchical networks
    • H04W84/12WLAN [Wireless Local Area Networks]

Abstract

The invention belongs to the technical field of information processing, and discloses a material code scanning warehousing information processing system and method based on an ERP system, wherein when an ERP software compiles a production processing list according to product information, a two-dimensional code containing information of each finished product is attached to the back of each finished product, and the production processing list is sent to a team; an operator forks the packaged product onto a platform scale, scans a two-dimensional code of the product by using a code scanning gun, transmits information of the weighing weight of the product to an ERP main system, judges the weighing weight of the product by the main system, and can be seen at an ERP using end if no logic problem exists; after the operator finishes the online warehousing, printing product information labels, and sticking the labels on the products; and warehousing personnel can audit the code scanning warehousing information at the use end of the ERP, check the code scanning warehousing information to be correct and finish a warehousing link. The invention simplifies the warehousing process and reduces the workload of warehousing staff; and the products can be delivered out of the warehouse after being produced in time, so that the warehousing and delivery efficiency of enterprises is improved.

Description

Material code scanning and warehousing information processing system and method based on ERP system
Technical Field
The invention belongs to the technical field of information processing, and particularly relates to a material code scanning and warehousing information processing system and method based on an ERP system.
Background
Currently, the closest prior art: at present, the warehousing process of small and medium-sized steel shearing and processing enterprises is as follows: material packaging → packager weighing → warehousing personnel collecting the weight list → warehousing personnel transacting ERP system warehousing; there are the following problems: 1. the time spent by warehouse entry personnel for collecting the pound order is long; 2. batch numbers can be written on the pound sheets for distinguishing, and if the pound sheets are wrongly written or the pound sheets are abnormal, the verification time is long; 3. the sheet is easy to lose when stuck or clamped on a task sheet; 4. the information of specification, quantity, customers and the like of finished products needs to be recorded on the pound sheet, and if the pound sheet is finished by a packer, errors are easy to occur due to the cultural degree and responsibility of the packer); 5. the delay of warehousing time is high, the packaged products need 0.5-12H (12H is overnight, and part of warehousing staff mends night shifts when the white shifts are in warehousing) when the packaged products are handled and warehoused due to pound receiving orders, and particularly, the warehousing delay time is long and the warehousing efficiency is low when the products needing to be immediately delivered are made.
In summary, the problems of the prior art are as follows:
(1) the existing steel shearing processing warehousing method has the problem that warehousing personnel collect the pound order and take longer time.
(2) At present, the steel shearing processing warehousing method has wrong writing or abnormal weighing when batch numbers are written on a weighing sheet, and the checking time is long.
(3) The existing steel shearing processing warehousing method is easy to lose due to the fact that the steel is stuck or clamped on a task list.
(4) The existing steel shearing processing warehousing method has the defect that finished product information is very easy to make mistakes when the balance sheet is required to be recorded.
(5) The existing steel shearing processing warehousing method has the hysteresis of warehousing time, more warehousing delay time and low warehousing efficiency.
The difficulty of solving the technical problems is as follows: 1. if a plurality of workers collect the pound order, the cost of the workers is high, and the labor division of the post is difficult; 2. if the packer directly writes, the workload of the packer is increased, writing data errors are easy to occur, and rework checking time is long; 3. the special person collects the pound bill, and the special person enters the pound bill, so that the labor cost is high, and when the workload is small, the pound bill collecting single person needs to rearrange the work; 4. if an MES workshop management system (including code scanning and warehousing) is introduced, the investment cost is at least more than 30 ten thousand, and the financial cost is high for part of enterprises.
The significance of solving the technical problems is as follows: 1. the warehousing process is simplified, and the workload of warehousing workers is reduced; 2. and warehousing is timely, the products can be delivered after being produced, and the warehousing and delivery efficiency of enterprises is improved.
Disclosure of Invention
Aiming at the problems in the prior art, the invention provides a material code scanning and warehousing information processing system and method based on an ERP system.
The invention is realized in such a way that a material code-scanning warehousing information processing method based on an ERP system comprises the following steps:
step one, according to product information, when ERP software compiles a production processing list, attaching a two-dimensional code containing information of each finished product to the rear of each finished product, and sending the production processing list to a team;
secondly, forking the packaged product onto a platform scale by an operator, scanning the two-dimensional code of the product by using a code scanning gun, and feeding back the weighing weight of the product after weighing onto site operation computer code scanning and warehousing software by a data acquisition line; after confirming that the product information is consistent with the software display information, the operator transmits the information of the weighing weight of the product to the ERP main system, and the information is judged by the main system without logic problem, so that the information can be seen at the ERP using end;
thirdly, printing product information labels after the operator finishes on-line warehousing, and sticking the labels on the products;
and fourthly, the warehousing personnel can check the code scanning warehousing information at the use end of the ERP, check the code scanning warehousing information to be correct and finish the warehousing link.
Further, the first two-dimensional code bearing information is batch number, specification, customer and product name.
Further, the method for processing the material code scanning and warehousing information based on the ERP system further comprises the following steps:
(1) generating a two-dimensional code of a printed product according to the EPR information; feeding back data after weighing the product in a weighing scale to a field ERP system through a data acquisition line; storing the product information through a cloud database server; comparing whether the product information is consistent with the software display information through an operator;
(2) correcting the wrong software display information through a data correction program; transmitting the product information to an ERP main system through a wireless signal; providing illumination to the system by an illumination source;
(3) comparing and checking the corrected product information with the product information stored in the database again through an information checking program; monitoring the height of a product to be transported through a photoelectric sensor; conveying the products into a warehouse through a conveying device; alarming for abnormal conditions through an alarming device;
(4) calling a corresponding exception handling method in the database based on the exception, carrying out exception handling, and if the exception handling cannot be recovered, carrying out alarm prompting again; acquiring the whole process of product warehousing through a plurality of camera devices; and displaying the product information, the weight information and the alarm information obtained by scanning the codes through a liquid crystal display.
Another object of the present invention is to provide a material code-scanning warehousing information processing system based on an ERP system for implementing the material code-scanning warehousing information processing method based on the ERP system, the material code-scanning warehousing information processing system based on the ERP system including: the system comprises a product, a platform scale printing display, a platform scale display and computer end data line, a field operation computer, a label printer, a code scanning gun, a production processing list, a two-dimensional code, an ERP main system and an ERP using end;
the product is placed on the platform scale, the platform scale is connected with the platform scale printing display, the platform scale printing display is connected with the field operation computer through the platform scale display and a computer end data line, the field operation computer is connected with the label printer, the code scanning gun and the ERP main system, the ERP main system is connected with the ERP using end, and the two-dimensional code is pasted on the production processing list.
Further, the functional modules of the information processing system include:
the system comprises a two-dimensional code generation module, a code scanning module, a weight data acquisition module, a data storage module, a data verification module, a data correction module, a main control module, a data transmission module, an illumination module, a label printing module, an information auditing module, a height monitoring module, a product conveying module, an alarm module, an exception processing module, a camera module and a display module;
the two-dimensional code generation module is connected with the main control module and used for generating a two-dimensional code of a printed product according to the EPR information;
the code scanning module is connected with the main control module and used for scanning the two-dimensional code of the product through the code scanning gun;
the weight data acquisition module is connected with the main control module and used for feeding back data after weighing the product by weighing to the on-site ERP system through a data acquisition line;
the data storage module is connected with the main control module and used for storing the product information through the cloud database server;
the data checking module is connected with the main control module and used for comparing whether the product information is consistent with the software display information through an operator;
the data correction module is connected with the main control module and used for correcting the wrong software display information through a data correction program;
the main control module is connected with the two-dimensional code generation module, the code scanning module, the weight data acquisition module, the data storage module, the data verification module, the data correction module, the data transmission module, the illumination module, the label printing module, the information auditing module, the height monitoring module, the product conveying module, the alarm module, the exception processing module, the camera module and the display module and is used for controlling the normal operation of each module through a central controller at a computer end;
the data transmission module is connected with the main control module and used for transmitting the product information to the ERP main system through the wireless transmission device;
the lighting module is connected with the main control module and used for providing lighting for the system through a lighting source;
the label printing module is connected with the main control module and is used for printing product labels through a label printer;
the information auditing module is connected with the main control module and is used for comparing and auditing the corrected product information and the product information stored in the database again through an information auditing program;
the height monitoring module is connected with the main control module and used for monitoring the height of the product to be transported through the photoelectric sensor;
the product conveying module is connected with the main control module and is used for conveying the products into a warehouse through the conveying device;
the alarm module is connected with the main control module and used for alarming the abnormal condition through the alarm device;
the exception handling module is connected with the main control module and used for calling a corresponding exception handling method in the database based on the exception, carrying out exception handling, and if the exception handling cannot be recovered, carrying out alarm prompting again;
the camera module is connected with the main control module and is used for acquiring the whole process of product warehousing through a plurality of camera devices;
and the display module is connected with the main control module and used for displaying the product information, the weight information and the alarm information obtained by scanning the code through the liquid crystal display.
Further, in the data correction module, the data correction method includes:
(1) collecting current signals generated by a capacitive screen of a central controller;
(2) performing analog-to-digital conversion on the current signals to obtain a first matrix with M rows and N columns, wherein M and N are both natural numbers; the elements of the first matrix and the capacitance sensing points of the capacitive screen have a one-to-one correspondence relationship;
(3) judging whether a channel abnormal condition and an area abnormal condition exist according to the numerical values of the elements in the first matrix; if the channel is abnormal, correcting data corresponding to the abnormal channel; if the area is abnormal, correcting the data corresponding to the abnormal area;
the method for judging the channel abnormal condition comprises the following steps: determining the ratio of the number of elements with values larger than or equal to a first preset value in the r-th column in the first matrix to M to obtain a first ratio, wherein r is a natural number, and r is more than or equal to 1 and less than or equal to N; comparing the magnitude relation between the first ratio and a first preset ratio; if the first ratio is smaller than the first preset ratio, determining that a channel corresponding to the r-th column of the first matrix is normal, and/or determining the ratio of the number of elements with values larger than or equal to the first preset value in the t-th row of the first matrix to N to obtain a second ratio, wherein t is a natural number, and t is more than or equal to 1 and less than or equal to M; comparing the magnitude relation between the second ratio and a second preset ratio; and if the second ratio is smaller than the second preset ratio, determining that the channel corresponding to the t-th row of the first matrix is normal.
Further, in the data transmission module, the wireless transmission apparatus includes: the mobile communication antenna, the CPU and the display module which is externally connected with the CPU are arranged, the clock frequency of the communication between the CPU and the display module is set to be 108MHz, and the frequency values of n-th harmonic and n + 1-th harmonic of the clock frequency are enabled to avoid the receiving frequency band of the wireless communication system; n is a positive integer;
the wireless communication device also comprises a wireless local area network unit connected with the CPU, the wireless local area network unit is connected with the Wlan antenna, and the distance between the Wlan antenna and the mobile communication antenna is set, so that the isolation between the two antennas is less than-20 dB; the CPU is connected with the wireless local area network unit through a first set of SDIO interfaces, the driving capability of a clock signal interface in the first set of SDIO interfaces is reduced, and an impedance matching resistor is connected in series on a clock signal line connected with the clock signal interface.
Furthermore, the information processing system also comprises a bearing platform, an L-shaped limiting baffle arranged on the upper end surface of the bearing platform, and a horizontal chute arranged on the L-shaped limiting baffle; the bearing platform is provided with a lower controller with a wireless transmission module, the L-shaped limiting baffle is provided with a photoelectric sensor connected with the lower controller, and the height of the photoelectric sensor is consistent with that of the conveying line;
in the alarm module, the abnormal conditions include but are not limited to inconsistency between product information and software display information in the data verification process, inconsistency between product information corrected in the information auditing process and product information stored in a database, abnormal reading of two-dimensional code data, abnormal data transmission, abnormal product transmission, data error and abnormal label printing; alarm device is including fixed setting up on L shape limit baffle up end and being located the alarm lamp mounting bracket and the three-colour alarm lamp of fixed connection on alarm lamp mounting bracket top of horizontal spout side.
Further, in the product conveying module, the product conveying device comprises a rack, a conveyor belt, a driving mechanism, a detector and a guiding device, one end of the rack is a product inlet end, the other end of the rack is a product outlet end, a transmission drum is arranged at the top of the product outlet end of the rack, a direction-changing drum is arranged at the top of the product inlet end of the rack, the transmission drum is in transmission connection with the direction-changing drum through the conveyor belt, a bearing carrier roller for supporting the conveyor belt is further arranged between the transmission drum and the direction-changing drum, the driving mechanism is arranged on the rack, the driving mechanism is connected with the transmission drum and is used for driving the transmission drum to rotate, and the guiding device is arranged at the top of the rack and is close to the product inlet end of the rack; the detector is arranged at the top of the rack;
the driving mechanism comprises a motor and a speed reducer, an output shaft of the motor is connected with an input shaft of the speed reducer, and an output shaft of the speed reducer is connected with one end of the transmission roller; the detector is an ultrasonic detector or an infrared detector.
The invention also aims to provide an information data processing terminal applying the material code scanning and warehousing information processing method based on the ERP system.
In summary, the advantages and positive effects of the invention are: the invention simplifies the warehousing process and reduces the workload of warehousing staff; and the products can be delivered out of the warehouse after being produced in time, so that the warehousing and delivery efficiency of enterprises is improved. Meanwhile, the invention also has an automatic abnormal alarm function, can detect abnormal automatic alarm, and records the video in the whole process, thereby avoiding other situations.
The L-shaped limiting baffle is arranged, two adjacent sides of the product can be respectively aligned to two sides of the L-shaped limiting baffle, and the L-shaped limiting baffle is arranged at a certain height, so that a stack of products can be accurately aligned, repeated placement and scanning are not needed, and the working efficiency of scanning is improved; be provided with alarm device, when sweeping the sign indicating number and appearing the mistake, the controller can control alarm device and realize quick warning and remind. In addition, the light source is used for providing brightness required by code scanning for the system, and the clear code scanning picture is ensured; the photoelectric sensor is used for sensing products on the conveying line, and when sensing signals are collected, the lower controller drives the product conveying device to move rapidly, so that automatic control starting is achieved.
TABLE 1 comparison of conventional methods with the present invention
Figure BDA0002253022330000071
Figure BDA0002253022330000081
Drawings
Fig. 1 is a flowchart of a method for processing material code scanning warehousing information based on an ERP system according to an embodiment of the present invention.
Fig. 2 is a flowchart of an implementation of a method for processing material code scanning and warehousing information based on an ERP system according to an embodiment of the present invention.
Fig. 3 is a structural diagram of a material code scanning and warehousing information processing device based on an ERP system according to an embodiment of the present invention;
in the figure: 1. producing a product; 2. a platform scale; 3. a scale printing display; 4. the platform scale display and the computer end data line; 5. operating the computer on site; 6. a label printer; 7. a code scanning gun; 8. producing a processing sheet; 9. two-dimensional codes; 10. ERP main system; 11. ERP using end.
Fig. 4 is a structural diagram of a material code scanning and warehousing information processing system based on an ERP system according to an embodiment of the present invention;
in the figure: 1. a two-dimensional code generation module; 2. a code scanning module; 3. a weight data acquisition module; 4. a data storage module; 5. a data verification module; 6. a data correction module; 7. a main control module; 8. a data transmission module; 9. a lighting module; 10. a label printing module; 11. an information auditing module; 12. a height monitoring module; 13. a product delivery module; 14. an alarm module; 15. an exception handling module; 16. a camera module; 17. and a display module.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is further described in detail with reference to the following embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
Aiming at the problems in the prior art, the invention provides a system and a method for processing material code scanning and warehousing information based on an ERP system, and the invention is described in detail below with reference to the accompanying drawings.
The technical solution of the present invention is described in detail below with reference to the accompanying drawings.
As shown in fig. 1-2, a method for processing material code scanning warehousing information based on an ERP system according to an embodiment of the present invention includes the following steps:
s101: according to the product information, when the ERP software compiles a production processing list, a two-dimensional code (batch number, specification, customer, product name and the like) containing the information of each finished product is attached to the back of each finished product, and the production processing list is sent to a team.
S102: an operator forks the packaged product onto a platform scale, a code scanning gun is used for scanning the two-dimension code of the product, and the weighing weight of the product when weighing the product is fed back to the code scanning and warehousing software of the field operation computer through a data acquisition line; and after confirming that the product information is consistent with the software display information, an operator clicks a warehousing button, the information that the product contains the weighing weight is transmitted to the ERP main system, and the information is judged by the main system, so that the information can be seen at an ERP using end without logic problems.
S103: after the operator finishes the on-line warehousing, the label printing can be carried out on the software, the product information label printing is carried out, and the label is pasted on the product.
S104: and the warehousing personnel can audit the code scanning warehousing information at the use end of the ERP, check the code scanning warehousing information to be correct, and finally click to audit and warehouse in to finish the warehousing link.
The method for processing the material code scanning warehousing information based on the ERP system further comprises the following steps:
(1) generating a two-dimensional code of a printed product according to the EPR information; feeding back data after weighing the product in a weighing scale to a field ERP system through a data acquisition line; storing the product information through a cloud database server; comparing whether the product information is consistent with the software display information through an operator;
(2) correcting the wrong software display information through a data correction program; transmitting the product information to an ERP main system through a wireless signal; providing illumination to the system by an illumination source;
(3) comparing and checking the corrected product information with the product information stored in the database again through an information checking program; monitoring the height of a product to be transported through a photoelectric sensor; conveying the products into a warehouse through a conveying device; alarming for abnormal conditions through an alarming device;
(4) calling a corresponding exception handling method in the database based on the exception, carrying out exception handling, and if the exception handling cannot be recovered, carrying out alarm prompting again; acquiring the whole process of product warehousing through a plurality of camera devices; and displaying the product information, the weight information and the alarm information obtained by scanning the codes through a liquid crystal display.
As shown in fig. 3, a system device for processing material code scanning and warehousing information based on an ERP system according to an embodiment of the present invention includes: the system comprises a product 1, a platform scale 2, a platform scale printing display 3, a platform scale display and computer data line 4, a field operation computer 5, a label printer 6, a code scanning gun 7, a production processing sheet 8, a two-dimensional code 9, an ERP main system 10 and an ERP using end 11.
The product 1 is placed on the platform scale 2, the platform scale 2 is connected with the platform scale printing display 3, the platform scale printing display 3 is connected with the field operation computer 5 through the platform scale display and the computer end data line 4, the field operation computer 5 is connected with the label printer 6, the code scanning gun 7 and the ERP main system 10, the ERP main system 10 is connected with the ERP using end 11, and the two-dimensional code 9 is attached to the production processing sheet 8.
The functional modules of the material code scanning and warehousing information processing system based on the ERP system provided by the embodiment of the invention comprise:
the system comprises a two-dimensional code generation module 1, a code scanning module 2, a weight data acquisition module 3, a data storage module 4, a data verification module 5, a data correction module 6, a main control module 7, a data transmission module 8, an illumination module 9, a label printing module 10, an information auditing module 11, a height monitoring module 12, a product conveying module 13, an alarm module 14, an exception handling module 15, a camera module 16 and a display module 17;
the two-dimensional code generation module 1 is connected with the main control module 7 and used for generating a two-dimensional code of a printed product according to EPR information;
the code scanning module 2 is connected with the main control module 7 and used for scanning the two-dimensional code of the product through a code scanning gun;
the weight data acquisition module 3 is connected with the main control module 7 and used for feeding back data after weighing the product by weighing to the on-site ERP system through a data acquisition line;
the data storage module 4 is connected with the main control module 7 and used for storing the product information through a cloud database server;
the data checking module 5 is connected with the main control module 7 and used for comparing whether the product information is consistent with the software display information through an operator;
the data correction module 6 is connected with the main control module 7 and is used for correcting the wrong software display information through a data correction program;
the main control module 7 is connected with the two-dimensional code generation module 1, the code scanning module 2, the weight data acquisition module 3, the data storage module 4, the data verification module 5, the data correction module 6, the data transmission module 8, the illumination module 9, the label printing module 10, the information auditing module 11, the height monitoring module 12, the product conveying module 13, the alarm module 14, the exception handling module 15, the camera module 16 and the display module 17, and is used for controlling the normal operation of each module through a central controller at a computer end;
the data transmission module 8 is connected with the main control module 7 and is used for transmitting the product information to an ERP main system through a wireless transmission device;
the lighting module 9 is connected with the main control module 7 and used for providing lighting for the system through a lighting source;
the label printing module 10 is connected with the main control module 7 and is used for printing product labels through a label printer;
the information auditing module 11 is connected with the main control module 7 and is used for comparing and auditing the corrected product information and the product information stored in the database again through an information auditing program;
the height monitoring module 12 is connected with the main control module 7 and used for monitoring the height of the product to be transported through a photoelectric sensor;
the product conveying module 13 is connected with the main control module 7 and is used for conveying products into a warehouse through a conveying device;
the alarm module 14 is connected with the main control module 7 and used for alarming abnormal conditions through an alarm device;
the exception handling module 15 is connected with the main control module 7 and used for calling a corresponding exception handling method in the database based on the exception, carrying out exception handling, and if the exception handling cannot be recovered, carrying out alarm prompting again;
the camera module 16 is connected with the main control module 7 and is used for acquiring the whole process of product warehousing through a plurality of camera devices;
and the display module 17 is connected with the main control module 7 and used for displaying the product information, the weight information and the alarm information obtained by scanning the codes through the liquid crystal display.
In the data correction module 6 provided in the embodiment of the present invention, the data correction method includes:
(1) collecting current signals generated by a capacitive screen of a central controller;
(2) performing analog-to-digital conversion on the current signals to obtain a first matrix with M rows and N columns, wherein M and N are both natural numbers; the elements of the first matrix and the capacitance sensing points of the capacitive screen have a one-to-one correspondence relationship;
(3) judging whether a channel abnormal condition and an area abnormal condition exist according to the numerical values of the elements in the first matrix; if the channel is abnormal, correcting data corresponding to the abnormal channel; if the area is abnormal, correcting the data corresponding to the abnormal area;
the method for judging the channel abnormal condition comprises the following steps: determining the ratio of the number of elements with values larger than or equal to a first preset value in the r-th column in the first matrix to M to obtain a first ratio, wherein r is a natural number, and r is more than or equal to 1 and less than or equal to N; comparing the magnitude relation between the first ratio and a first preset ratio; if the first ratio is smaller than the first preset ratio, determining that a channel corresponding to the r-th column of the first matrix is normal, and/or determining the ratio of the number of elements with values larger than or equal to the first preset value in the t-th row of the first matrix to N to obtain a second ratio, wherein t is a natural number, and t is more than or equal to 1 and less than or equal to M; comparing the magnitude relation between the second ratio and a second preset ratio; and if the second ratio is smaller than the second preset ratio, determining that the channel corresponding to the t-th row of the first matrix is normal.
In the data transmission module 8 provided in the embodiment of the present invention, the wireless transmission device includes: the mobile communication antenna, the CPU and the display module which is externally connected with the CPU are arranged, the clock frequency of the communication between the CPU and the display module is set to be 108MHz, and the frequency values of n-th harmonic and n + 1-th harmonic of the clock frequency are enabled to avoid the receiving frequency band of the wireless communication system; n is a positive integer;
the wireless communication device also comprises a wireless local area network unit connected with the CPU, the wireless local area network unit is connected with the Wlan antenna, and the distance between the Wlan antenna and the mobile communication antenna is set, so that the isolation between the two antennas is less than-20 dB; the CPU is connected with the wireless local area network unit through a first set of SDIO interfaces, the driving capability of a clock signal interface in the first set of SDIO interfaces is reduced, and an impedance matching resistor is connected in series on a clock signal line connected with the clock signal interface.
The information processing system provided by the embodiment of the invention also comprises a bearing platform, an L-shaped limiting baffle arranged on the upper end surface of the bearing platform, and a horizontal sliding chute arranged on the L-shaped limiting baffle; the bearing platform is provided with a lower controller with a wireless transmission module, the L-shaped limiting baffle is provided with a photoelectric sensor connected with the lower controller, and the height of the photoelectric sensor is consistent with that of the conveying line;
in the alarm module 14, the abnormal conditions include, but are not limited to, inconsistency between product information and software display information in a data verification process, inconsistency between product information corrected in an information auditing process and product information stored in a database, abnormal reading of two-dimensional code data, abnormal data transmission, abnormal product transmission, data error and abnormal label printing; alarm device is including fixed setting up on L shape limit baffle up end and being located the alarm lamp mounting bracket and the three-colour alarm lamp of fixed connection on alarm lamp mounting bracket top of horizontal spout side.
In the product conveying module 13 provided by the embodiment of the present invention, the product conveying device includes a rack, a conveyor belt, a driving mechanism, a detector, and a guiding device, one end of the rack is a product inlet end, the other end of the rack is a product outlet end, a driving drum is disposed on the top of the product outlet end of the rack, a direction-changing drum is disposed on the top of the product inlet end of the rack, the driving drum is in transmission connection with the direction-changing drum through the conveyor belt, a carrying idler roller for supporting the conveyor belt is further disposed between the driving drum and the direction-changing drum, the driving mechanism is disposed on the rack, the driving mechanism is connected with the driving drum and is used for driving the driving drum to rotate, and the guiding device is disposed on the top of the rack and is close to the product inlet; the detector is arranged at the top of the rack;
the driving mechanism comprises a motor and a speed reducer, an output shaft of the motor is connected with an input shaft of the speed reducer, and an output shaft of the speed reducer is connected with one end of the transmission roller; the detector is an ultrasonic detector or an infrared detector.
Proof part (concrete examples/experiments/simulation/positive experimental data, evidence material, appraisal report, business data, research and development evidence, business cooperation evidence, etc. capable of proving the creativity of the invention)
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents and improvements made within the spirit and principle of the present invention are intended to be included within the scope of the present invention.

Claims (10)

1. A material code-scanning warehousing information processing method based on an ERP system is characterized by comprising the following steps:
step one, according to product information, when ERP software compiles a production processing list, attaching a two-dimensional code containing information of each finished product to the rear of each finished product, and sending the production processing list to a team;
secondly, forking the packaged product onto a platform scale by an operator, scanning the two-dimensional code of the product by using a code scanning gun, and feeding back the weighing weight of the product after weighing onto site operation computer code scanning and warehousing software by a data acquisition line; after confirming that the product information is consistent with the software display information, the operator transmits the information of the weighing weight of the product to the ERP main system, and the information is judged by the main system without logic problem, so that the information can be seen at the ERP using end;
thirdly, printing product information labels after the operator finishes on-line warehousing, and sticking the labels on the products;
and fourthly, the warehousing personnel can check the code scanning warehousing information at the use end of the ERP, check the code scanning warehousing information to be correct and finish the warehousing link.
2. The ERP system-based material code-scanning warehousing information processing method of claim 1, wherein the first-step two-dimensional code bearing information is a batch number, specification, customer, product name.
3. The ERP system-based material code-scanning warehousing information processing method of claim 1, wherein the ERP system-based material code-scanning warehousing information processing method further comprises:
(1) generating a two-dimensional code of a printed product according to the EPR information; feeding back data after weighing the product in a weighing scale to a field ERP system through a data acquisition line; storing the product information through a cloud database server; comparing whether the product information is consistent with the software display information through an operator;
(2) correcting the wrong software display information through a data correction program; transmitting the product information to an ERP main system through a wireless signal; providing illumination to the system by an illumination source;
(3) comparing and checking the corrected product information with the product information stored in the database again through an information checking program; monitoring the height of a product to be transported through a photoelectric sensor; conveying the products into a warehouse through a conveying device; alarming for abnormal conditions through an alarming device;
(4) calling a corresponding exception handling method in the database based on the exception, carrying out exception handling, and if the exception handling cannot be recovered, carrying out alarm prompting again; acquiring the whole process of product warehousing through a plurality of camera devices; and displaying the product information, the weight information and the alarm information obtained by scanning the codes through a liquid crystal display.
4. A material code-scanning warehousing information processing system based on an ERP system for implementing the material code-scanning warehousing information processing method based on the ERP system as claimed in claim 1, wherein the material code-scanning warehousing information processing system based on the ERP system comprises: the system comprises a product, a platform scale printing display, a platform scale display and computer end data line, a field operation computer, a label printer, a code scanning gun, a production processing list, a two-dimensional code, an ERP main system and an ERP using end;
the product is placed on the platform scale, the platform scale is connected with the platform scale printing display, the platform scale printing display is connected with the field operation computer through the platform scale display and a computer end data line, the field operation computer is connected with the label printer, the code scanning gun and the ERP main system, the ERP main system is connected with the ERP using end, and the two-dimensional code is pasted on the production processing list.
5. The ERP system-based material code-scanning warehousing information processing system of claim 4, wherein the functional modules of the information processing system comprise:
the system comprises a two-dimensional code generation module, a code scanning module, a weight data acquisition module, a data storage module, a data verification module, a data correction module, a main control module, a data transmission module, an illumination module, a label printing module, an information auditing module, a height monitoring module, a product conveying module, an alarm module, an exception processing module, a camera module and a display module;
the two-dimensional code generation module is connected with the main control module and used for generating a two-dimensional code of a printed product according to the EPR information;
the code scanning module is connected with the main control module and used for scanning the two-dimensional code of the product through the code scanning gun;
the weight data acquisition module is connected with the main control module and used for feeding back data after weighing the product by weighing to the on-site ERP system through a data acquisition line;
the data storage module is connected with the main control module and used for storing the product information through the cloud database server;
the data checking module is connected with the main control module and used for comparing whether the product information is consistent with the software display information through an operator;
the data correction module is connected with the main control module and used for correcting the wrong software display information through a data correction program;
the main control module is connected with the two-dimensional code generation module, the code scanning module, the weight data acquisition module, the data storage module, the data verification module, the data correction module, the data transmission module, the illumination module, the label printing module, the information auditing module, the height monitoring module, the product conveying module, the alarm module, the exception processing module, the camera module and the display module and is used for controlling the normal operation of each module through a central controller at a computer end;
the data transmission module is connected with the main control module and used for transmitting the product information to the ERP main system through the wireless transmission device;
the lighting module is connected with the main control module and used for providing lighting for the system through a lighting source;
the label printing module is connected with the main control module and is used for printing product labels through a label printer;
the information auditing module is connected with the main control module and is used for comparing and auditing the corrected product information and the product information stored in the database again through an information auditing program;
the height monitoring module is connected with the main control module and used for monitoring the height of the product to be transported through the photoelectric sensor;
the product conveying module is connected with the main control module and is used for conveying the products into a warehouse through the conveying device;
the alarm module is connected with the main control module and used for alarming the abnormal condition through the alarm device;
the exception handling module is connected with the main control module and used for calling a corresponding exception handling method in the database based on the exception, carrying out exception handling, and if the exception handling cannot be recovered, carrying out alarm prompting again;
the camera module is connected with the main control module and is used for acquiring the whole process of product warehousing through a plurality of camera devices;
and the display module is connected with the main control module and used for displaying the product information, the weight information and the alarm information obtained by scanning the code through the liquid crystal display.
6. The ERP system-based material code-scanning warehousing information processing system of claim 4, wherein in the data correction module, the data correction method comprises:
(1) collecting current signals generated by a capacitive screen of a central controller;
(2) performing analog-to-digital conversion on the current signals to obtain a first matrix with M rows and N columns, wherein M and N are both natural numbers; the elements of the first matrix and the capacitance sensing points of the capacitive screen have a one-to-one correspondence relationship;
(3) judging whether a channel abnormal condition and an area abnormal condition exist according to the numerical values of the elements in the first matrix; if the channel is abnormal, correcting data corresponding to the abnormal channel; if the area is abnormal, correcting the data corresponding to the abnormal area;
the method for judging the channel abnormal condition comprises the following steps: determining the ratio of the number of elements with values larger than or equal to a first preset value in the r-th column in the first matrix to M to obtain a first ratio, wherein r is a natural number, and r is more than or equal to 1 and less than or equal to N; comparing the magnitude relation between the first ratio and a first preset ratio; if the first ratio is smaller than the first preset ratio, determining that a channel corresponding to the r-th column of the first matrix is normal, and/or determining the ratio of the number of elements with values larger than or equal to the first preset value in the t-th row of the first matrix to N to obtain a second ratio, wherein t is a natural number, and t is more than or equal to 1 and less than or equal to M; comparing the magnitude relation between the second ratio and a second preset ratio; and if the second ratio is smaller than the second preset ratio, determining that the channel corresponding to the t-th row of the first matrix is normal.
7. The ERP system-based material code-scanning warehousing information processing system of claim 4, wherein in the data transmission module, the wireless transmission device comprises: the mobile communication antenna, the CPU and the display module which is externally connected with the CPU are arranged, the clock frequency of the communication between the CPU and the display module is set to be 108MHz, and the frequency values of n-th harmonic and n + 1-th harmonic of the clock frequency are enabled to avoid the receiving frequency band of the wireless communication system; n is a positive integer;
the wireless communication device also comprises a wireless local area network unit connected with the CPU, the wireless local area network unit is connected with the Wlan antenna, and the distance between the Wlan antenna and the mobile communication antenna is set, so that the isolation between the two antennas is less than-20 dB; the CPU is connected with the wireless local area network unit through a first set of SDIO interfaces, the driving capability of a clock signal interface in the first set of SDIO interfaces is reduced, and an impedance matching resistor is connected in series on a clock signal line connected with the clock signal interface.
8. The ERP system-based material code-scanning warehousing information processing system of claim 4, wherein the information processing system further comprises a bearing platform, an L-shaped limiting baffle arranged on the upper end surface of the bearing platform, and a horizontal chute arranged on the L-shaped limiting baffle; the bearing platform is provided with a lower controller with a wireless transmission module, the L-shaped limiting baffle is provided with a photoelectric sensor connected with the lower controller, and the height of the photoelectric sensor is consistent with that of the conveying line;
in the alarm module, the abnormal conditions include but are not limited to inconsistency between product information and software display information in the data verification process, inconsistency between product information corrected in the information auditing process and product information stored in a database, abnormal reading of two-dimensional code data, abnormal data transmission, abnormal product transmission, data error and abnormal label printing; alarm device is including fixed setting up on L shape limit baffle up end and being located the alarm lamp mounting bracket and the three-colour alarm lamp of fixed connection on alarm lamp mounting bracket top of horizontal spout side.
9. The ERP-system-based material code-scanning warehousing information processing system of claim 4, it is characterized in that in the product conveying module, the product conveying device comprises a frame, a conveying belt, a driving mechanism, a detector and a guiding device, one end of the frame is a product inlet end, the other end is a product outlet end, the top of the product outlet end of the frame is provided with a transmission roller, the top of the product inlet end of the rack is provided with a turnabout drum, the transmission drum is in transmission connection with the turnabout drum through the conveyor belt, a bearing carrier roller for supporting the conveyor belt is arranged between the transmission roller and the direction-changing roller, the driving mechanism is arranged on the frame, is connected with the transmission roller and is used for driving the transmission roller to rotate, the guide device is arranged at the top of the rack and is close to the product inlet end of the rack; the detector is arranged at the top of the rack;
the driving mechanism comprises a motor and a speed reducer, an output shaft of the motor is connected with an input shaft of the speed reducer, and an output shaft of the speed reducer is connected with one end of the transmission roller; the detector is an ultrasonic detector or an infrared detector.
10. An information data processing terminal applying the material code scanning and warehousing information processing method based on the ERP system as claimed in any one of claims 1-3.
CN201911041711.2A 2019-10-30 2019-10-30 Material code scanning and warehousing information processing system and method based on ERP system Pending CN110991571A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911041711.2A CN110991571A (en) 2019-10-30 2019-10-30 Material code scanning and warehousing information processing system and method based on ERP system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911041711.2A CN110991571A (en) 2019-10-30 2019-10-30 Material code scanning and warehousing information processing system and method based on ERP system

Publications (1)

Publication Number Publication Date
CN110991571A true CN110991571A (en) 2020-04-10

Family

ID=70082654

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911041711.2A Pending CN110991571A (en) 2019-10-30 2019-10-30 Material code scanning and warehousing information processing system and method based on ERP system

Country Status (1)

Country Link
CN (1) CN110991571A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112200521A (en) * 2020-10-30 2021-01-08 珠海格力电工有限公司 Intelligent prevention and control system and method for cable abnormal products
CN112407498A (en) * 2020-11-18 2021-02-26 山东厚德测控技术股份有限公司 Automatic water meter packaging production line and method
CN113052524A (en) * 2021-03-05 2021-06-29 蒙娜丽莎集团股份有限公司 Unmanned intelligent warehouse entry system for checking box support codes

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20020032582A1 (en) * 2000-09-14 2002-03-14 Feeney Robert J. System for medication dispensing and integrated data management
CN102386937A (en) * 2011-10-25 2012-03-21 青岛海信移动通信技术股份有限公司 Wireless communication system and method for improving sensitivity of wireless communication system
CN105719106A (en) * 2014-12-03 2016-06-29 金蝶软件(中国)有限公司 Product management method and terminal based on two-dimensional code
CN107330350A (en) * 2017-07-05 2017-11-07 中科院合肥技术创新工程院 A kind of fertilizer packaging bag barcode scanning in-stockroom operation platform
CN208321370U (en) * 2018-04-28 2019-01-04 广州市至信防伪科技有限公司 A kind of barcode scanning storage sorting equipment
CN109264280A (en) * 2018-10-19 2019-01-25 重庆驰骋轻型汽车部件股份有限公司 A kind of automation Input System
CN109976588A (en) * 2019-04-04 2019-07-05 广州视源电子科技股份有限公司 A kind of data correction method and apparatus applied to intelligent interaction plate

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20020032582A1 (en) * 2000-09-14 2002-03-14 Feeney Robert J. System for medication dispensing and integrated data management
CN102386937A (en) * 2011-10-25 2012-03-21 青岛海信移动通信技术股份有限公司 Wireless communication system and method for improving sensitivity of wireless communication system
CN105719106A (en) * 2014-12-03 2016-06-29 金蝶软件(中国)有限公司 Product management method and terminal based on two-dimensional code
CN107330350A (en) * 2017-07-05 2017-11-07 中科院合肥技术创新工程院 A kind of fertilizer packaging bag barcode scanning in-stockroom operation platform
CN208321370U (en) * 2018-04-28 2019-01-04 广州市至信防伪科技有限公司 A kind of barcode scanning storage sorting equipment
CN109264280A (en) * 2018-10-19 2019-01-25 重庆驰骋轻型汽车部件股份有限公司 A kind of automation Input System
CN109976588A (en) * 2019-04-04 2019-07-05 广州视源电子科技股份有限公司 A kind of data correction method and apparatus applied to intelligent interaction plate

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
魏庆丰;: "条形码在钢铁企业物流管理中的应用" *

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112200521A (en) * 2020-10-30 2021-01-08 珠海格力电工有限公司 Intelligent prevention and control system and method for cable abnormal products
CN112407498A (en) * 2020-11-18 2021-02-26 山东厚德测控技术股份有限公司 Automatic water meter packaging production line and method
CN113052524A (en) * 2021-03-05 2021-06-29 蒙娜丽莎集团股份有限公司 Unmanned intelligent warehouse entry system for checking box support codes

Similar Documents

Publication Publication Date Title
CN110991571A (en) Material code scanning and warehousing information processing system and method based on ERP system
US10360770B2 (en) Order re-check system
CN105005289B (en) A kind of industrial platform of internet of things
CN202558171U (en) Storage picking system
CN110503171B (en) Double-verification type batching and feeding production method
CN102262757A (en) Advanced planning system (APS)/manufacturing execution system (MES) lean manufacturing management system
CN109332206A (en) High speed multi-panel barcode scanning, weighing detection system and detection method
CN104689996A (en) Method and system for sorting parcels by using sorting machine
CN107730157A (en) A kind of extraction of traditional Chinese medicine weighs allocator
CN110467009B (en) Batching feeding and weighing system
US20160224023A1 (en) Automated production system for mobile phone
CN207763656U (en) Wrap up volume weight measuring equipment
CN109141596A (en) A kind of remote data wireless transmission weighbridge system based on LoRa technology
CN106454733A (en) Online monitoring system based on wireless sensor network
CN206270744U (en) A kind of plastic film industry control system
CN113077266A (en) Traceable information boxing method and system
CN112053175A (en) Operating system for intelligent digital traceability of cosmetics
CN207164813U (en) Aluminium section bar finished product order identifies and pound weight data acquisition management system
CN213855791U (en) Express delivery conveyer belt weighing device
CN213932790U (en) Intelligent weighing system for transport vehicle
CN213413284U (en) Printing production line data acquisition system based on ERP
CN114861846A (en) Code scanning acquisition method and device, storage medium and electronic device
CN112710372A (en) Intelligent weighing system for transport vehicle
CN111871829A (en) Reciprocating type parcel sorting device
CN107694733B (en) Modularized crushing equipment and building aggregate crushing system

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
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20200410

WD01 Invention patent application deemed withdrawn after publication