A data processing method for electronicization of paper inventory of warehousing logistics

Abstract

The invention discloses a data processing method for electronicization of paper lists of warehousing logistics, and relates to the field of supply chain data processing. The invention comprises the steps of collecting and image-recognizing paper lists; generating and entering name tags, and associating warehousing data of paper lists corresponding to the name tags; entering transaction records for paper lists associated with user names, including entering goods, transaction time, transaction discounts, and balances, generating transaction formulas associated with the users based on transaction record analysis, and using the transaction formulas to verify the data relationship of balances, goods, and transaction discounts in time sequence; analyzing and processing warehousing data, outputting electronic lists, and prompting error content and error types; the invention realizes intelligent and efficient paper-to-electronic data conversion, improves the accuracy and efficiency of conversion, reduces labor costs, and avoids manual errors.

Description

Technical Field

[0001] The present invention relates to the field of supply chain data processing, and in particular to a data processing method for electronicizing a paper inventory of warehousing logistics. Background Art

[0002] In the current scenario, small storage institutions still use paper-based office work, which is inefficient and prone to confusion, loss, and erroneous records.

[0003] For various user groups, the manual entry system generates a lot of workload, and the calculation and summary of list data is prone to proofreading failures. Manual marking makes subsequent verification difficult and the workload is large. The balances, transaction records, transaction discounts, and goods of different users all need to be manually identified, recorded, and calculated. The transaction discounts of users of different levels are different, which require manual accounting and analysis one by one.

[0004] In the process of systematic and electronic office work, since entering historical paper data is conducive to analyzing the transaction habits of different users and storing historical transaction records, existing merchants have not sorted out past paper data in the process of using system office work, resulting in unclear consumption habits of different users and inconvenience in making corresponding adjustments to the inventory of commodity types. For example, some users can see the periodic entry and exit of a certain type of commodity based on paper lists, but merchants have not conducted research on previous data, resulting in insufficient balances and affecting transaction progress;

[0005] In view of the shortcomings of the prior art, the present invention considers an intelligent paper list electronic process processing method that combines high precision and strong verification mode with image recognition to solve the defects of the prior art. Summary of the invention

[0006] In a first aspect, the present invention provides a data processing method for electronicizing a paper inventory of warehousing logistics, which solves the problems of the prior art, including:

[0007] Capture and image recognition of paper lists;

[0008] Among them, image acquisition and text crawling are performed on multiple paper lists entered in sequence, and the corresponding different user names are analyzed based on the crawled text, and the paper lists associated with the user names are integrated;

[0009] Generate and enter name tags, and associate the name tags with the storage data of the paper list;

[0010] Among them, the transaction records are entered into the paper list associated with the user name, including the entry of goods, transaction time, transaction discount, and balance. Based on the transaction record analysis, a transaction formula associated with the user is generated, and the transaction formula is used to verify the data relationship of the balance, goods, and transaction discount in time sequence;

[0011] Analyze and process warehouse data, output electronic lists and indicate error content and error type;

[0012] For user warehouse data that fails the transaction formula verification, the error type and error content are determined, including missing data, calculation errors and the corresponding error content location, and a warning message is output to prompt manual correction.

[0013] Furthermore, in the process of image recognition of paper lists, the paper lists captured by the image are marked with first-category page numbers in sequence. At the same time, a blank template with corresponding page numbers is generated in the electronic system, the text content at the user name position in the corresponding paper list is identified, and the corresponding paper list with the user name having the same text content is output and entered into the electronic system. The electronic system organizes the first-category page number marks captured by the image, and adds second-category page number marks to the paper list with the same user name in the electronic system.

[0014] Furthermore, the time record of the goods part in the paper inventory data of the image acquisition of the same user name is obtained, and the second-category page number marks are sorted according to the transaction time sequence based on the time sequence of the goods part, and compared with the first-category page number marks of the associated image acquisition for manual correction in the subsequent error prompts.

[0015] Furthermore, the product text is captured from the collected data associated with different user names to generate transaction formulas for balance changes and product comparisons in chronological order, and multiple adjacent pieces of the same product data are selected for calculation and analysis to generate transaction formulas for the user of the corresponding product type.

[0016] Furthermore, adjacent data of different goods are used for verification to analyze whether the balance satisfies the data calculated by the transaction formula corresponding to the goods. If so, the transaction formula corresponding to the adjacent data of different goods is correct. If not, an error is reported for the transaction data.

[0017] Furthermore, the transaction records generated for the same product are sorted, and a transaction formula is generated between every two adjacent transaction records in time sequence;

[0018] The frequencies of occurrence of the corresponding coefficients of the transaction formula are sorted, and the corresponding coefficient with the highest sorting is selected to form the transaction formula as the transaction formula for the product.

[0019] Furthermore, the transaction formula composed of the highest-ranked corresponding coefficients is used to verify all transaction records of the goods, filter out the transaction data of a single item that does not meet the requirements, and report an error.

[0020] Furthermore, it also includes re-verifying multiple adjacent commodity transaction data among the single commodity transaction data that are screened out as non-compliant, selecting the earliest and latest transaction data among the multiple commodity transaction data, and verifying the earliest transaction data with the correct transaction data adjacent to the previous time sequence according to the transaction formula. If the verification is successful, the earliest transaction data is marked as the compliant single commodity transaction data, and the latest transaction data is verified with the correct transaction data adjacent to the next time sequence according to the transaction formula. If the verification is successful, the latest transaction data is marked as the compliant single commodity transaction data.

[0021] Furthermore, after sorting the frequencies of occurrence of the corresponding coefficients of the transaction formula and selecting the corresponding coefficients with the highest ranking to form the transaction formula as the transaction formula for the product, it also includes: marking the product transaction records corresponding to the coefficients calculated except for the highest ranking coefficient as non-compliant single product transaction data and reporting an error.

[0022] Furthermore, the step of marking the commodity transaction records corresponding to the calculated coefficients except the highest sorting coefficient as non-compliant transaction data of a single commodity and reporting an error also includes: sorting every two adjacent erroneous commodity transaction records in chronological order, repeatedly marking overlapping commodity transaction records as erroneous transaction records, and removing the error information of the two adjacent transaction records above and below the erroneous transaction record, and re-marking the two adjacent transaction records above and below the erroneous transaction record as transaction data of a single commodity that complies with the transaction formula.

[0023] The present invention provides a data processing method for electronicization of paper lists of warehousing logistics, which uses image recognition and corresponding data calculation to verify errors in paper lists, and screens out and marks erroneous data, thereby realizing intelligent and efficient paper-to-electronic data conversion, improving the accuracy and efficiency of conversion, reducing labor costs, and avoiding human errors. BRIEF DESCRIPTION OF THE DRAWINGS

[0024] The drawings described herein are used to provide a further understanding of the embodiments of the present invention, constitute a part of the present invention, and do not constitute a limitation of the embodiments of the present invention. In the drawings:

[0025] Figure 1 A flow chart of a data processing method for electronicizing paper inventories of warehouse logistics provided by an exemplary embodiment of the present invention. DETAILED DESCRIPTION

[0026] Exemplary embodiments will be described in detail herein, examples of which are shown in the accompanying drawings. When the following description refers to the drawings, the same numbers in different drawings represent the same or similar elements unless otherwise indicated. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present invention. Instead, they are merely examples of devices and methods consistent with some aspects of the present invention as detailed in the appended claims.

[0027] In the existing technology, manual meter reading is often used to solve the data record of the past paper list, or the historical data content is directly discarded, which is not conducive to the verification of past storage transaction records, and the verification is difficult. At the same time, it is not conducive to the generation of user consumption images. Without data reference and data support, it is not conducive to the targeted adjustment of the storage volume of different goods;

[0028] In the prior art, when dealing with simple paper lists including user name, user transaction time, user transaction product type, user balance and user discount, copying historical data is complicated and prone to secondary errors, making verification difficult. The present invention considers using image recognition to solve the problem of difficult copying, directly generating the corresponding electronic list with one click, and marking and reminding the erroneous parts at the same time. After using the electronic system, merchants can simply check the reminded erroneous parts directly, and can directly verify all paper lists converted into electronic ones.

[0029] The specific application scenario of the present invention is the electronic data conversion of paper lists.

[0030] The present invention provides a data processing method for electronicizing paper lists of warehousing logistics, aiming to solve the above technical problems in the prior art.

[0031] The technical solution of the present invention and how the technical solution of the present invention solves the above-mentioned technical problems are described in detail below with specific embodiments. The following specific embodiments can be combined with each other, and the same or similar concepts or processes may not be repeated in some embodiments. The embodiments of the present invention will be described below in conjunction with the accompanying drawings.

[0032] Embodiment 1: This embodiment provides a data processing method for electronicizing a paper inventory of warehousing logistics, such as Figure 1 As shown, the following steps are included:

[0033] S1. Collection and image recognition of paper lists:

[0034] Perform image acquisition and text crawling on multiple paper lists entered in sequence, identify different user names based on crawled text analysis, and integrate paper lists associated with the user names; in the process of image recognition of paper lists, perform first-category page number marking on the paper lists captured by the images in sequence, and at the same time, generate a blank template with the corresponding page number in the electronic system, identify the text content at the user name position in the corresponding paper list, output the corresponding paper list of the user name with the same text content and enter it into the electronic system, the electronic system organizes the first-category page number markings captured by the images, and adds second-category page number markings to the paper lists with the same user name in the electronic system. In the case where there is an inconsistent order in entering paper lists, or multiple overlapping paper lists are entered, the text data entered into the electronic system needs to be replaced, and all list data corresponding to the same user name need to be recorded and classified. The present invention solves this problem in the following way: the time record in the goods part of the paper list data captured by the image of the same user name is obtained, and the second type of page number marks are sorted according to the transaction time sequence based on the time sequence of the goods part, and the first type of page number marks captured by the associated image are compared for manual correction in the event of subsequent error prompts.

[0035] S2. Generate and enter name tags, and associate the name tags with the storage data of the paper list:

[0036] Transaction records are entered into the paper list of associated user names, including goods, transaction time, transaction discount, and balance. Based on the transaction record analysis, transaction formulas for associated users are generated, and the transaction formulas are used to verify the data relationship between balance, goods, and transaction discounts in chronological order. For the collected data associated with different user names, product texts are captured to generate transaction formulas for balance changes and product comparisons in chronological order, and multiple adjacent pieces of data on the same product are selected for calculation and analysis to generate transaction formulas for users of corresponding product types.

[0037] Among them, the calculation process of the transaction formula is:

[0038] The transaction records generated by the same product are sorted, and a transaction formula is generated between every two transaction records in adjacent time sequence; the corresponding coefficients of the transaction formula are sorted by frequency of occurrence, and the corresponding coefficient with the highest ranking is selected to form the transaction formula as the transaction formula for the product.

[0039] S3. Analyze and process storage data, output electronic list and indicate error content and error type:

[0040] Determine the error type and error content of user warehouse data that fails the transaction formula verification, including missing data, calculation errors and the corresponding error content location, and output warning information to prompt manual correction;

[0041] The analysis process is:

[0042] Adjacent data of different goods are used for verification to analyze whether the balance satisfies the data calculated by the transaction formula corresponding to the goods. If so, the transaction formula corresponding to the adjacent different goods is correct. If not, an error is reported for the transaction data.

[0043] For the transaction formula calculated in S2, there are two technical solutions for verifying the correctness of other data according to the calculated transaction formula:

[0044] The first technical solution for verifying the correctness of other data is as follows: use the highest-ranked corresponding coefficient to form a transaction formula to verify all transaction records of the goods, filter out the transaction data of a single item that does not meet the requirements, and report an error.

[0045] There are correct data among multiple error data. In order to save the workload of manual verification, the following method is used to screen out false data:

[0046] For the single item transaction data that does not meet the requirements, the adjacent multiple items transaction data are verified again to select the earliest and latest transaction data of the multiple items transaction data. The earliest transaction data is verified with the correct transaction data adjacent to the previous time sequence according to the transaction formula. If the verification is successful, the earliest transaction data is marked as the transaction data of the single item that meets the requirements. The latest transaction data is verified with the correct transaction data adjacent to the next time sequence according to the transaction formula. If the verification is successful, the latest transaction data is marked as the transaction data of the single item that meets the requirements.

[0047] The second technical solution for verifying the correctness of other data is as follows: after sorting the frequency of occurrence of the corresponding coefficients of the transaction formula, selecting the corresponding coefficient with the highest ranking to form the transaction formula as the transaction formula for the goods, it also includes: marking the transaction records of goods corresponding to the coefficients other than the highest ranking coefficient calculated as non-compliant single item transaction data, and reporting an error. In the second technical solution for verifying the correctness of other data, in order to save the workload of manual verification, the following method is adopted to screen out false data: marking the transaction records of goods corresponding to the coefficients other than the highest ranking coefficient calculated as non-compliant single item transaction data, and reporting an error, and also includes: sorting each two adjacent error-reported goods transaction records in chronological order, repeatedly marking the overlapping goods transaction records as error transaction records, and eliminating the error information of the two upper and lower adjacent transaction records of the error transaction record, and re-marking the two upper and lower adjacent transaction records of the error transaction record as single item transaction data that conform to the transaction formula.

[0048] In the several embodiments provided by the present invention, it should be understood that the disclosed systems and methods can be implemented in other ways. For example, the system embodiments described above are only schematic, for example, the division of modules is only a logical function division, and there may be other division methods in actual implementation, such as multiple modules or components can be combined or integrated into another system, or some features can be ignored or not executed.

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

[0050] In addition, each functional module in each embodiment of the present invention may be integrated into one processing module, or each module may exist physically separately, or two or more modules may be integrated into one module. The above-mentioned integrated module may be implemented in the form of hardware or in the form of hardware plus software functional modules.

[0051] Those skilled in the art will appreciate that the embodiments of the present invention may be provided as methods or systems. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware aspects.

[0052] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.

[0053] The above are only embodiments of the present invention and are not intended to limit the present invention. For those skilled in the art, the present invention may have various modifications and variations. Any modification, equivalent substitution, improvement, etc. made within the spirit and principle of the present invention should be included in the scope of the claims of the present invention.

[0054] Those skilled in the art will readily appreciate other embodiments of the present invention after considering the specification and practicing the invention disclosed herein. The present invention is intended to cover any variations, uses or adaptations of the present invention that follow the general principles of the present invention and include common knowledge or customary techniques in the art that are not disclosed by the present invention. The description and examples are to be considered exemplary only, and the true scope and spirit of the present invention is indicated by the claims above.

[0055] It should be understood that the present invention is not limited to the exact construction that has been described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the present invention is limited only by the appended claims.

Claims

1. A data processing method for electronicizing paper lists of warehousing logistics, characterized in that: The steps include: Collecting and image-recognizing paper lists: In the process of image-recognizing paper lists, the first-class page number marking is performed sequentially on the paper lists collected by the images. At the same time, a blank template of the corresponding page number is generated in the electronic system, and the text content at the user name position in the corresponding paper list is identified. The corresponding paper list of the user name with the same text content is output and entered into the electronic system. The electronic system sorts the first-class page number markings collected by the images, and adds the second-class page number markings to the paper lists with the same user name in the electronic system; obtain the time record of the goods part in the paper list data collected by the images with the same user name, sort the second-class page number markings according to the transaction time sequence according to the time sequence of the goods part, and compare them with the first-class page number markings collected by the associated images for manual correction in the event of subsequent error prompts; Among them, image acquisition and text crawling are performed on multiple paper lists entered in sequence, and the corresponding different user names are analyzed based on the crawled text, and the paper lists associated with the user names are integrated; Generate and enter name tags, and associate the name tags with the storage data of the paper list; Among them, the transaction records are entered into the paper list associated with the user name, including the entry of goods, transaction time, transaction discount, and balance. Based on the transaction record analysis, a transaction formula associated with the user is generated, and the transaction formula is used to verify the data relationship of the balance, goods, and transaction discount in time sequence; Analyze and process warehouse data, output electronic lists and indicate error content and error type; For user warehouse data that fails the transaction formula verification, the error type and error content are determined, including missing data, calculation errors and the corresponding error content location, and a warning message is output to prompt manual correction.

2. The data processing method for electronicizing paper inventory of warehousing logistics according to claim 1 is characterized in that: The product text is captured from the collected data associated with different user names to generate transaction formulas for balance changes and product comparisons in chronological order. Multiple adjacent pieces of the same product data are selected for calculation and analysis to generate transaction formulas for the user of the corresponding product type.

3. The data processing method for electronicizing paper inventory of warehousing logistics according to claim 1 is characterized in that: Adjacent data of different goods are used for verification to analyze whether the balance satisfies the data calculated by the transaction formula corresponding to the goods. If so, the transaction formula corresponding to the adjacent different goods is correct. If not, an error is reported for the transaction data.

4. The data processing method for electronicizing paper inventory of warehousing logistics according to claim 2 is characterized in that: The transaction records generated by the same product are sorted out, and a transaction formula is generated between every two adjacent transaction records in time sequence; The frequencies of occurrence of the corresponding coefficients of the transaction formula are sorted, and the corresponding coefficient with the highest ranking is selected to form the transaction formula as the transaction formula for the product.

5. The data processing method for electronicizing paper inventory of warehousing logistics according to claim 4 is characterized in that: The transaction formula composed of the highest-ranked corresponding coefficients is used to verify all transaction records of the goods, filter out the transaction data of a single item that does not meet the requirements, and report an error.

6. A data processing method for electronicizing paper inventory of warehousing logistics according to claim 5, characterized in that: It also includes re-verifying multiple adjacent commodity transaction data among the single commodity transaction data that are screened out as non-compliant, selecting the earliest and latest transaction data among the multiple commodity transaction data, and verifying the earliest transaction data with the correct transaction data adjacent to the previous time sequence according to the transaction formula. If the verification is successful, marking the earliest transaction data as the compliant single commodity transaction data, and verifying the latest transaction data with the correct transaction data adjacent to the next time sequence according to the transaction formula. If the verification is successful, marking the latest transaction data as the compliant single commodity transaction data.

7. A data processing method for electronicizing paper inventory of warehousing logistics according to claim 4, characterized in that: After sorting the frequencies of occurrence of the corresponding coefficients of the transaction formula and selecting the corresponding coefficient with the highest ranking to form the transaction formula as the transaction formula for the product, the method further includes: marking the product transaction records corresponding to the coefficients calculated except for the highest ranking coefficient as non-compliant transaction data of a single product and reporting an error.

8. A data processing method for electronicizing paper inventory of warehousing logistics according to claim 7, characterized in that: The step of marking the commodity transaction records corresponding to the calculated coefficients except the highest sorting coefficient as non-compliant single commodity transaction data and reporting an error also includes: sorting each two adjacent erroneous commodity transaction records in chronological order, repeatedly marking overlapping commodity transaction records as erroneous transaction records, removing the error information of the two upper and lower adjacent transaction records of the erroneous transaction record, and re-marking the two upper and lower adjacent transaction records of the erroneous transaction record as single commodity transaction data that comply with the transaction formula.

Images