Intelligent recording method and device for bills traveling along with goods

Abstract

The invention relates to an intelligent bill recording method for bills traveling along with goods. The method comprises the following steps that paper bills traveling along with goods are converted into electronic picture files through collection equipment; uploading the electronic picture file to a cloud server, automatically identifying text content in the picture by a server program, and intelligently converting the text content into electronic data in a unified JSON format; receiving and displaying the electronic data in the JSON format for a consignee to review, and supporting manual adjustment of the data; after the re-checking is completed, the purchase order in the warehouse management system is automatically matched; and after purchase order matching is completed, goods receiving and warehousing operation is executed in the warehouse management system. According to the technical scheme of the invention, a consignee can be helped to quickly complete document entry, purchase order matching and receiving and warehousing operations.

Description

Technical Field

[0001] The present invention relates to the field of logistics management technology, and in particular to an intelligent order recording method for shipping with goods, a system thereof, a readable storage medium, and a computer device. Background Art

[0002] In the pharmaceutical logistics sector, when suppliers deliver pharmaceuticals to logistics warehouses, they often include corresponding paper documents, known as accompanying documents, along with the cargo. Receiving personnel at the logistics warehouse use this accompanying document to complete document entry, match it with purchase orders, and receive the goods into the warehouse. Currently, receiving personnel at various companies' logistics warehouses generally enter document information manually. Because accompanying documents vary in format and print clarity across suppliers, this process is time-consuming and error-prone, and also presents significant challenges in matching them with purchase orders. Summary of the Invention

[0003] The present invention aims to solve at least one of the technical problems existing in the prior art or related art.

[0004] To this end, the purpose of the present invention is to provide an intelligent document recording method and equipment that accompanies the goods, which can help the receiving personnel quickly complete document entry, purchase order matching, and goods receipt and warehousing operations.

[0005] To achieve the above-mentioned purpose, the technical solution of the first aspect of the present invention provides an intelligent order recording method for shipping with goods, comprising the following steps:

[0006] Convert paper accompanying documents into electronic image files through acquisition equipment;

[0007] Upload the electronic image file to the cloud server, and the server program automatically recognizes the text content in the image and intelligently converts it into electronic data in a unified JSON format;

[0008] Receive and display the electronic data in JSON format for review by the receiving personnel, and support manual adjustment of the data;

[0009] After the review is completed, the purchase order in the warehouse management system is automatically matched;

[0010] After completing the purchase order matching, perform the goods receipt and warehousing operation in the warehouse management system.

[0011] In the above technical solution, preferably, it supports continuous collection of multiple pages of accompanying documents and merges multiple pages of data into the same electronic document.

[0012] In any of the above technical solutions, preferably, it further includes:

[0013] Establish and update field alias mapping rules in real time to convert different descriptions of the same field from different suppliers into standard field names.

[0014] In the above technical solution, preferably, the field name includes at least one of purchase order number, product code, product description, specification, origin, arrival quantity, unit, batch number, production date, validity period, approval number, manufacturer, and storage and transportation conditions.

[0015] In the above technical solution, preferably, the field alias mapping rule includes the following mapping relationship:

[0016] The fields corresponding to the purchase order number include the outbound order number, document number, sales order number, and order number;

[0017] The fields corresponding to the product code include product code, code, commodity code, commodity code, drug code, drug code, item number, item ID, inventory code, and material number;

[0018] The fields corresponding to the product description include product name, commodity name, product name, trade name, drug name, generic name, and commodity name;

[0019] The fields corresponding to specifications include specification model and packaging specifications;

[0020] The corresponding fields of Valid Until include Shelf Life Until, Expiration Date, Validity Date, and Validity Period.

[0021] In the above technical solution, preferably, the following steps are further included:

[0022] Automatically splitting the contents of composite fields joined by separators in a paper accompanying document includes the following steps:

[0023] Identify multiple fields connected by separators in the field name;

[0024] Split the corresponding field values into independent data according to the same delimiter;

[0025] Map the split data to standard field names in sequence;

[0026] The separator includes at least one of “ / ”, “,”, “;”, “,”, “;” and “space”.

[0027] In the above technical solution, preferably, the structure of the electronic data in JSON format includes:

[0028] Header information: including supplier name and purchase order number;

[0029] Detailed information: includes at least one field from the following: product code, product description, specifications, origin, arrival quantity, unit, batch number, production date, expiration date, approval number, manufacturer, and storage and transportation conditions.

[0030] The technical solution of the second aspect of the present invention provides an intelligent order recording system that records orders along with the goods, including:

[0031] An information collection module is configured to convert a paper accompanying document into an electronic image file through a collection device;

[0032] An information uploading module is configured to upload the electronic image file to a cloud server, where the server program automatically recognizes the text content in the image and intelligently converts it into electronic data in a unified JSON format;

[0033] An information display module is configured to receive and display the electronic data in JSON format for review by a receiving person, and supports manual adjustment of the data;

[0034] The order review module is set up to automatically match the purchase order in the warehouse management system after the review is completed;

[0035] The Goods Receiving and Warehousing module is configured to execute the Goods Receiving and Warehousing operations in the warehouse management system after completing the purchase order matching;

[0036] The field name mapping module is configured to establish and update field alias mapping rules in real time, converting different descriptions of the same field from different vendors into standard field names;

[0037] The composite field splitting module is configured to automatically split the composite field contents joined by separators in paper accompanying documents.

[0038] The technical solution of the third aspect of the present invention provides a readable storage medium on which a computer program is stored. When the program is executed by a processor, it implements the steps of the intelligent order recording method for the order accompanying the goods provided by the technical solution of the first aspect above.

[0039] The technical solution of the fourth aspect of the present invention provides a computer device, including a storage medium and a processor; the storage medium is used to store computer programs; the processor is used to execute the computer program to implement the steps of the intelligent order recording method for accompanying goods provided by the technical solution of the first aspect above.

[0040] Compared with the existing technology, the advantages of the intelligent recording method and equipment for accompanying documents provided by the present invention are: by taking a photo of the accompanying document, automatically identifying the content of the document, intelligently converting it into electronic data with complex requirements, and then automatically matching the purchase order data, it is ultimately achieved to help the receiving personnel quickly complete the operations of document entry, matching purchase orders, and receiving and warehousing, so as to improve the low operating efficiency and high error rate. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] The above and / or additional aspects and advantages of the present invention will become apparent and readily understood from the following description of the embodiments with reference to the accompanying drawings, in which:

[0042] Figure 1 A flowchart of an intelligent order recording method according to an embodiment of the present invention is shown;

[0043] Figure 2 A flowchart of an intelligent order recording method according to another embodiment of the present invention is shown;

[0044] Figure 3 A flowchart of the intelligent order recording method according to the third embodiment of the present invention is shown;

[0045] Figure 4 shows a flowchart of step S7 involved in an embodiment of the present invention;

[0046] Figure 5 The figure shows a structural block diagram of the intelligent order recording system involved in an embodiment of the present invention. DETAILED DESCRIPTION

[0047] In order to more clearly understand the above-mentioned objects, features and advantages of the present invention, the present invention is further described in detail below in conjunction with the accompanying drawings and specific embodiments. It should be noted that, in the absence of conflict, the embodiments of the present application and the features therein can be combined with each other.

[0048] In the following description, many specific details are set forth to facilitate a full understanding of the present invention. However, the present invention may also be implemented in other ways different from those described herein. Therefore, the scope of protection of the present invention is not limited to the specific embodiments disclosed below.

[0049] like Figure 1 As shown, according to an embodiment of the present invention, a smart order recording method for accompanying goods includes the following steps:

[0050] S1, converting the paper accompanying document into an electronic image file through the collection device;

[0051] S2, uploading the electronic image file to the cloud server, where the server program automatically recognizes the text content in the image and intelligently converts it into electronic data in a unified JSON format;

[0052] In this step, the present invention can process the contents of accompanying documents of different suppliers with different formats and paper sizes into unified JSON format data to facilitate subsequent use in other operation links;

[0053] This step uses optical character recognition (OCR) technology to extract the text content in the image, and combines it with the natural language processing (NLP) algorithm for semantic analysis and field matching. Optical character recognition (OCR) technology is an existing conventional text recognition technology, and the natural language processing (NLP) algorithm uses the existing conventional semantic analysis and field matching technology, which will not be repeated here.

[0054] S3, receives and displays the electronic data in JSON format for review by the receiving personnel, and supports manual adjustment of the data;

[0055] In this step, the present invention provides a visual interface to display JSON data in a table format and supports highlighting and editing of error fields.

[0056] S4, after the review is completed, automatically matches the purchase order in the warehouse management system that matches the electronic data in JSON format;

[0057] S5. After completing the purchase order matching, the goods receipt and warehousing operation corresponding to the purchase order is executed in the warehouse management system.

[0058] In the above embodiment, preferably, continuous collection of multiple pages of accompanying documents is supported, and multiple pages of data are merged into the same electronic document (i.e., electronic data in the same JSON format).

[0059] like Figure 2 As shown, in any of the above embodiments, preferably, it also includes:

[0060] S6, establish and update field alias mapping rules in real time, and convert different descriptions of the same field by different suppliers into standard field names.

[0061] In the above technical solution, preferably, the field name includes at least one of purchase order number, product code, product description, specification, origin, arrival quantity, unit, batch number, production date, validity period, approval number, manufacturer, and storage and transportation conditions.

[0062] In the above embodiment, preferably, the field alias mapping rule includes the following mapping relationship:

[0063] The fields corresponding to the purchase order number include the outbound order number, document number, sales order number, and order number;

[0064] The fields corresponding to the product code include product code, code, commodity code, commodity code, drug code, drug code, item number, item ID, inventory code, and material number;

[0065] The fields corresponding to the product description include product name, commodity name, product name, trade name, drug name, generic name, and commodity name;

[0066] The fields corresponding to specifications include specification model and packaging specifications;

[0067] The corresponding fields of Valid Until include Shelf Life Until, Expiration Date, Validity Date, and Validity Period.

[0068] In this embodiment, different suppliers' accompanying documents may have different names for the same field name. For example, some suppliers may call the field name "product code" "material code" and some may call it "drug code". The method provided by the present invention will intelligently convert the alias fields corresponding to the same field name of different suppliers into the same field name. Specifically, the present invention will maintain a set of alias correspondence rules, and maintain the common aliases in the industry in the rules. For example, in the industry, when people mention "product code, product code, code, commodity code, commodity code, drug code, drug code, item number, item ID, inventory code, material number", they actually all refer to "product code". Through the alias correspondence rules, the field values corresponding to these alias fields are converted into the same field value.

[0069] like Figure 3 and Figure 4 As shown, in the above embodiment, preferably, the following steps are further included:

[0070] S7, automatically splitting the composite field contents connected by separators in the paper accompanying document, including the following steps:

[0071] S71, identifying multiple fields connected by separators in a field name;

[0072] S72, splitting the corresponding field values into independent data according to the same delimiter;

[0073] S73, mapping the split data to standard field names in sequence;

[0074] The separator includes at least one of “ / ”, “,”, “;”, “,”, “:”, “.” and “space”.

[0075] In this embodiment, although some suppliers' accompanying documents may print multiple fields of information in the same cell using separators, the present invention accurately separates these multiple fields of information into independent fields. For example, some documents may print the three fields of information "Product Name / Specification / Origin" together. This method will automatically identify and separate them into the three fields of information "Product Name", "Specification", and "Origin". For example, if a list of field names is spliced together using the " / " character, this field name list will be split into multiple specific field names. When the corresponding field value is identified, the field value is also split according to the " / " and then matched to the specific field name in the splicing order.

[0076] In the above technical solution, preferably, the structure of the electronic data in JSON format includes:

[0077] Header information: including supplier name and purchase order number;

[0078] Detailed information: includes at least one field from the following: product code, product description, specifications, origin, arrival quantity, unit, batch number, production date, expiration date, approval number, manufacturer, and storage and transportation conditions.

[0079] like Figure 5 As shown, according to another embodiment of the present invention, an intelligent order recording system 1000 for accompanying goods includes:

[0080] The information collection module 10 is configured to convert the paper accompanying document into an electronic image file through a collection device;

[0081] The information uploading module 20 is configured to upload the electronic image file to the cloud server, where the server program automatically recognizes the text content in the image and intelligently converts it into electronic data in a unified JSON format;

[0082] The information display module 30 is configured to receive and display the electronic data in JSON format for review by the consignee, and supports manual adjustment of the data;

[0083] The order review module 40 is configured to automatically match the purchase order in the warehouse management system after the review is completed;

[0084] The goods receiving and warehousing module 50 is configured to perform goods receiving and warehousing operations in the warehouse management system after completing the purchase order matching;

[0085] The field name mapping module 60 is configured to establish and update field alias mapping rules in real time, converting different descriptions of the same field by different suppliers into a standard field name;

[0086] The composite field splitting module 70 is configured to automatically split the composite field contents joined by separators in the paper accompanying document.

[0087] Based on the above Figures 1 to 4 The method shown, accordingly, an embodiment of the present application also provides a computer-readable storage medium, on which a computer program is stored, and when the program is executed by a processor, the steps of the intelligent order recording method for the order accompanying the goods in any of the above embodiments are implemented.

[0088] Based on this understanding, the technical solution of the present application can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (which can be a CD-ROM, USB flash drive, mobile hard disk, etc.), and includes a number of instructions for enabling a computer device (which can be a personal computer, server, or network device, etc.) to execute the methods of various implementation scenarios of the present application.

[0089] Based on the above Figures 1 to 4 The method shown, and Figure 5 The virtual device embodiment shown, in order to achieve the above-mentioned purpose, the embodiment of the present application also provides a computer device, including a storage medium and a processor; the storage medium is used to store computer programs; the processor is used to execute the computer program to implement the steps of the intelligent order recording method for accompanying the goods in any of the above-mentioned embodiments.

[0090] Optionally, the computer device may further include a user interface, a network interface, a camera, a radio frequency (RF) circuit, a sensor, an audio circuit, a Wi-Fi module, etc. The user interface may include a display, an input unit such as a keyboard, etc., and the optional user interface may also include a USB interface, a card reader interface, etc. The network interface may optionally include a standard wired interface, a wireless interface (such as a Bluetooth interface, a Wi-Fi interface), etc.

[0091] Those skilled in the art will understand that the computer device structure provided in this embodiment does not constitute a limitation on the computer device, and may include more or fewer components, or a combination of certain components, or different component arrangements.

[0092] The storage medium may also include an operating system and a network communication module. An operating system is a program that manages and stores the hardware and software resources of a computer device, supporting the execution of information processing programs and other software and / or programs. The network communication module facilitates communication between components within the storage medium, as well as with other hardware and software within the physical device.

[0093] The foregoing description is merely a preferred embodiment of the present invention and is not intended to limit the present invention. Those skilled in the art will readily appreciate that various modifications and variations of the present invention are possible. Any modifications, equivalent substitutions, or improvements made within the spirit and principles of the present invention are intended to be within the scope of protection of the present invention.

Claims

1. An intelligent order recording method for accompanying goods, characterized in that: The following steps are involved: Convert paper accompanying documents into electronic image files through acquisition equipment; Upload the electronic image file to the cloud server, and the server program automatically recognizes the text content in the image and intelligently converts it into electronic data in a unified JSON format; Receive and display the electronic data in JSON format for review by the receiving personnel, and support manual adjustment of the data; After the review is completed, the purchase order in the warehouse management system is automatically matched; After completing the purchase order matching, perform the goods receipt and warehousing operation in the warehouse management system.

2. The intelligent recording method for accompanying goods according to claim 1 is characterized in that: Supports continuous collection of multiple pages of accompanying documents and merges multiple pages of data into the same electronic document.

3. The intelligent recording method for accompanying shipments according to claim 1 or 2, characterized in that: Also includes: Establish and update field alias mapping rules in real time to convert different descriptions of the same field from different suppliers into standard field names.

4. The intelligent recording method for accompanying shipments according to claim 3 is characterized in that: The field names include at least one of purchase order number, product code, product description, specification, place of origin, arrival quantity, unit, batch number, production date, validity period, approval number, manufacturer, and storage and transportation conditions.

5. The intelligent recording method for accompanying goods according to claim 4 is characterized in that: The field alias mapping rules include the following mapping relationships: The fields corresponding to the purchase order number include the outbound order number, document number, sales order number, and order number; The fields corresponding to the product code include product code, code, commodity code, commodity code, drug code, drug code, item number, item ID, inventory code, and material number; The fields corresponding to the product description include product name, commodity name, product name, trade name, drug name, generic name, and commodity name; The fields corresponding to specifications include specification model and packaging specifications; The corresponding fields of Valid Until include Shelf Life Until, Expiration Date, Validity Date, and Validity Period.

6. The intelligent recording method for accompanying shipments according to claim 4 is characterized in that: The following steps are also included: Automatically splitting the contents of composite fields joined by separators in a paper accompanying document includes the following steps: Identify multiple fields connected by separators in the field name; Split the corresponding field values into independent data according to the same delimiter; Map the split data to standard field names in sequence; Wherein, the separator includes at least one of " / ", "",", ";", "",", ";" and "space".

7. The intelligent recording method for accompanying shipments according to claim 6 is characterized in that: The structure of the electronic data in JSON format includes: Header information: including supplier name and purchase order number; Detailed information: includes at least one field from the following: product code, product description, specifications, origin, arrival quantity, unit, batch number, production date, expiration date, approval number, manufacturer, and storage and transportation conditions.

8. An intelligent order recording system that records orders along with goods, characterized in that: include: An information collection module is configured to convert a paper accompanying document into an electronic image file through a collection device; An information uploading module is configured to upload the electronic image file to a cloud server, where the server program automatically recognizes the text content in the image and intelligently converts it into electronic data in a unified JSON format; An information display module is configured to receive and display the electronic data in JSON format for review by a receiving person, and supports manual adjustment of the data; The order review module is set up to automatically match the purchase order in the warehouse management system after the review is completed; The Goods Receiving and Warehousing module is configured to execute the Goods Receiving and Warehousing operations in the warehouse management system after completing the purchase order matching; The field name mapping module is configured to establish and update field alias mapping rules in real time, converting different descriptions of the same field from different vendors into standard field names; The composite field splitting module is configured to automatically split the composite field contents joined by separators in paper accompanying documents.

9. A readable storage medium, characterized in that: A computer program is stored thereon, which, when executed by a processor, implements the steps of the intelligent order recording method for accompanying goods as described in any one of claims 1 to 7.

10. A computer device, characterized in that: It includes a storage medium and a processor; the storage medium is used to store a computer program; the processor is used to execute the computer program to implement the steps of the intelligent recording method for shipping orders as described in any one of claims 1 to 7.

Images