Method, system, medium and equipment for quickly detecting abnormity of inventory goods allocation account

Abstract

The invention provides a method, a system, a medium and equipment for quickly detecting abnormity of an inventory goods allocation account, and relates to the technical field of inventory management. The method comprises the steps that inspection task rules are configured and used for configuring an inspection data range, an inspection period and an inspection process, and the inspection process comprises intelligent inspection including inspection data calculation and automatic repair early warning; and quickly repairing and recalculating inventory goods location accounts in a specified range for responding to emergency situations. And regularly triggering the inspection task for analyzing the inspection task rule and carrying out intelligent inspection or rapid repair. Calculating inspection data, performing incremental query on data with inventory goods allocation accounting changes, comparing the data with inventory goods allocation general ledger information in a database, and if abnormal data is found, triggering automatic repair early warning. And automatically repairing and early warning, namely searching abnormal data, backing up the abnormal data and repairing the abnormal data. According to the invention, the accuracy and efficiency of inventory management can be improved, and abnormal conditions in inventory records can be found and solved in time.

Description

Technical Field

[0001] The present invention belongs to the technical field of warehouse inventory management systems, and in particular, relates to a method, system, medium and equipment for quickly detecting abnormalities in inventory location accounts. Background Art

[0002] In the process of refined warehouse inventory management, inventory location accounting becomes particularly complicated due to the diversity of business documents and the complexity of processes. Although the existing inventory management system can cover a wide range of business scenarios, it still has shortcomings in handling marginal atypical situations, which affects the robustness of the system and user satisfaction. The existing inventory management system cannot quickly and accurately identify abnormal inventory location account data, nor can it automatically repair abnormal data without the customer's perception. Summary of the invention

[0003] To this end, the technical problem to be solved by the present invention is to provide a method, system, medium and equipment for quickly detecting anomalies in inventory location accounts, aiming to improve the accuracy and efficiency of inventory management and promptly discover and resolve anomalies in inventory records.

[0004] In a first aspect, the present invention discloses a method for quickly detecting anomalies in an inventory location account, the method comprising: ‌Configure inspection task rules to specify the inspection data range and inspection cycle, and configure corresponding inspection processes according to different needs; the inspection process includes intelligent inspection and rapid repair; ‌Timed triggering of inspection tasks, used to parse the inspection task rules and perform the intelligent inspection or the quick repair; The intelligent inspection includes inspection data calculation and automatic repair warning; The inspection data calculation incrementally queries the data with inventory location account changes, compares the data with the inventory location general ledger information in the database, and if abnormal data is found, triggers the automatic repair warning; if no abnormality is found, the inspection ends; The automatic repair warning includes collecting abnormal data, backing up abnormal data, and repairing abnormal data after the backup is successful; The quick fix recalculates the inventory location accounts in a specified range to respond to emergency situations.

[0005] Furthermore, in the smart inspection, after the quick repair, an inventory health indicator analysis is also performed. The inventory health indicator analysis evaluates the inventory health status by collecting key indicators and calculating comprehensive weight values.

[0006] Furthermore, in the inventory health indicator analysis, the key indicators include the total number of customers, total inspection data, the number of abnormal customers and the total abnormal data; the total number of customers is the number of active customers in the system, the total inspection data is the total amount of data inspected within a specified period, the number of abnormal customers is the number of customers detected with problems, and the total abnormal data is the total amount of all abnormal data.

[0007] Furthermore, in the inspection data calculation, the queried data is processed in pieces, a message is sent to trigger the parallel calculation of the inventory location account, and then the data after the parallel calculation is compared with the inventory location general ledger information in the database.

[0008] Furthermore, in the inspection data calculation, the incremental query of data on inventory location account changes is to query only the data of the day before the current date.

[0009] In a second aspect, the present invention further provides a system for quickly detecting abnormalities in inventory location accounts, comprising: Inspection task rule configuration module, used to specify the inspection data range and inspection cycle, and configure the corresponding inspection process according to different needs; the inspection process includes intelligent inspection module and quick repair module; ‌A timed inspection task triggering module is used to analyze the inspection task rules and perform the intelligent inspection or the quick repair; The intelligent inspection module includes inspection data calculation and automatic repair warning; The inspection data calculation incrementally queries the data with inventory location account changes, compares the data with the inventory location general ledger information in the database, and if abnormal data is found, triggers the automatic repair warning; if no abnormality is found, the inspection ends; The automatic repair warning includes collecting abnormal data, backing up abnormal data, and repairing abnormal data after the backup is successful; The quick repair module recalculates the inventory location accounts in a specified range to respond to emergency situations.

[0010] Furthermore, it also includes an inventory health indicator analysis module, which evaluates the inventory health status by collecting key indicators and calculating comprehensive weight values.

[0011] Furthermore, in the inspection data calculation, the queried data is processed in pieces, a message is sent to trigger the parallel calculation of the inventory location account, and then the data after the parallel calculation is compared with the inventory location general ledger information in the database.

[0012] In a third aspect, the present invention further discloses a computer-readable storage medium storing a computer program, which, when executed by a processor, implements the aforementioned method for quickly detecting anomalies in an inventory location account.

[0013] In a fourth aspect, the present invention further discloses an electronic device, comprising a memory, a processor and a computer program, wherein the computer program is stored in the memory and can be run on the processor, and when the processor executes the computer program, the method for quickly detecting anomalies in the inventory location account is implemented.

[0014] Beneficial effects: The present invention discloses a method, system, medium and device for quickly detecting abnormalities in an inventory location account, which performs intelligent inspection or rapid repair by regularly triggering inspection tasks, thereby achieving the following technical effects: Significantly improve the accuracy and efficiency of inventory location management; Timely discover and resolve anomalies in inventory records to improve system robustness and user satisfaction; Reduce manual intervention and operating costs through automated processes; The inspection effect is good and can discover and solve cargo location accounting problems in advance, such as data anomalies caused by lack of scene coverage and concurrency problems. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] Figure 1 This is a flow chart of a method for quickly detecting abnormalities in an inventory location account of the present invention; Figure 2 This is a flow chart of the inspection task configuration of Example 1 of the present invention; Figure 3 This is a schematic diagram of system hierarchy of Example 2 of the present invention. DETAILED DESCRIPTION

[0016] The present invention will be described in detail below with reference to the accompanying drawings and in combination with embodiments. The principles and features of the present invention are described below in combination with the accompanying drawings. It should be noted that the embodiments in this application and the features in the embodiments can be combined with each other without conflict. The embodiments are only used to explain the present invention and are not used to limit the scope of the present invention.

[0017] In the process of finely managing inventory locations, the existing technology makes inventory location accounting particularly complicated due to the involvement of multiple business documents and their complex process differences. On the technical level, people are committed to optimizing the inventory location management system through innovative technical design to meet diverse business needs. Although the existing technology can already cover a wide range of business scenarios, technical experts know that the key to technical optimization lies in digging deep and solving those remaining edge cases. Although these cases are not common, they have a decisive impact on the robustness of the system and user satisfaction.

[0018] In order to improve user experience, the present invention optimizes the existing technology as follows from a technical perspective: 1. Enhanced anomaly detection module: By introducing intelligent algorithms, key fields of the cargo account data are extracted to more accurately predict and identify marginal atypical situations, so that timely warnings and repairs can be made when problems occur.

[0019] 2. Real-time monitoring and feedback: Establish a real-time monitoring system to continuously track changes in inventory locations and immediately notify the technical support team when potential problems are detected.

[0020] The present invention aims to improve the accuracy and efficiency of inventory management and promptly detect and resolve abnormal situations in inventory records.

[0021] Example 1 like Figure 1 As shown, the present invention discloses a method for quickly detecting anomalies in an inventory location account, including configuring inspection task rules, timing triggering inspection tasks, intelligent inspection, and rapid repair.

[0022] Configure inspection task rules, such as Figure 2 As shown in the figure, the inspection task rules can be configured to specify the inspection data range, inspection cycle and inspection process. After the scheduled task is triggered, two different processes are executed according to the inspection rules: intelligent inspection and fast repair.

[0023] ‌The inspection task is triggered regularly to analyze the inspection task rules and perform intelligent inspection or the above-mentioned quick repair.

[0024] ‌Intelligent inspection‌, including inspection data calculation and automatic repair warning.

[0025] Inspection data calculation, incremental query of inventory location account change data, to ensure that the amount of calculated data is not too large, improve query efficiency. Compare the data with the inventory location general ledger information in the database. If abnormal data is found, the system will automatically collect the data and trigger the automatic repair warning. At the same time, it will automatically back up the abnormal data for subsequent investigation and analysis. After the backup is successful, the system will automatically repair the abnormal data; if no abnormality is found, the inspection ends.

[0026] Automatic repair warning, including collecting abnormal data, backing up abnormal data, and repairing abnormal data after successful backup; ‌Quick Repair, suitable for emergency situations, can quickly and comprehensively repair the customer's inventory location accounts. When encountering urgent problems, this process can respond quickly to ensure the accuracy of inventory data. ‌Quick Repair is achieved by recalculating the inventory location accounts of a specified range.

[0027] As a preferred implementation, in the smart inspection, after the quick repair, an inventory health indicator analysis is also performed. The inventory health indicator analysis evaluates the inventory health status by collecting key indicators and calculating comprehensive weight values.

[0028] Key indicators can be: total number of customers, total inspection data, number of abnormal customers, and total abnormal data. The total number of customers is the number of active customers in the system, the total inspection data is the total amount of data inspected within a specified period, the number of abnormal customers is the number of customers with problems detected, and the total abnormal data is the total amount of all abnormal data.

[0029] As another preferred implementation, the queried data may be processed in pieces, and messages may be sent to trigger the inventory location account to perform parallel calculations, thereby improving the overall efficiency of the inspection.

[0030] In addition, in the intelligent inspection process, only the data from the day before the current date can be queried to ensure that the amount of calculated data is moderate, thereby improving query efficiency.

[0031] The method for warehouse cargo location account detection provided by the present invention greatly improves the accuracy and efficiency of inventory cargo location management. The following efficiency improvement is achieved by using the inspection method of this embodiment in specific products: the inspection efficiency for processing 100 users is 15 minutes. And the following inspection effect is obtained: 4 cargo location account problems are found in daily inspections, such as: lack of scene coverage, data anomalies caused by concurrency problems, etc., all of which are discovered and solved earlier than users. With inspections, if problems are encountered in each shuttle iteration, they can also be quickly discovered and solved during the grayscale period.

[0032] Example 2 The present invention also provides a system for quickly detecting abnormalities in inventory location accounts, comprising: Inspection task rule configuration module, used to specify the inspection data range and inspection cycle, and configure the corresponding inspection process according to different needs; the inspection process includes intelligent inspection module and quick repair module; ‌Timed-trigger inspection task module, used to analyze inspection task rules and perform intelligent inspection or quick repair; ‌Intelligent inspection module‌, including inspection data calculation and automatic repair warning; Inspection data calculation, incremental query of data with inventory location account changes, compare the data with the inventory location general ledger information in the database, if abnormal data is found, trigger automatic repair warning; if no abnormality is found, the inspection ends; Automatic repair warning, including collecting abnormal data, backing up abnormal data, and repairing abnormal data after successful backup; ‌Quick repair module, recalculates the inventory location accounts in a specified range to respond to emergency situations.

[0033] In this embodiment, an inventory health index analysis module may also be included. The inventory health index analysis module evaluates the inventory health status by collecting key indicators and calculating comprehensive weight values.

[0034] Preferably, in the inspection data calculation, the queried data can be processed in pieces, a message can be sent to trigger the parallel calculation of the inventory location account, and then the data after the parallel calculation can be compared with the inventory location general ledger information in the database.

[0035] like Figure 3 As shown, the inventory location account rapid detection abnormality system provided in this embodiment can perform the following functional hierarchical analysis: 1. Cargo location data collection layer: This layer is responsible for collecting data from various documents and building a data source containing all necessary fields to ensure data consistency and facilitate subsequent data analysis and processing. Through the processing of this layer, reliable basic data support can be provided for subsequent data analysis.

[0036] Among them, the cargo location data collection layer includes the following key fields: tenant, warehouse, cargo location, commodity, specification, batch, quantity, unit.

[0037] 2. Cargo location scheduled inspection trigger layer: Set the time point or frequency for starting the inspection task. Tenant: Specify the customer for the inspection task. Warehouse: Select the specific warehouse that needs to be inspected. Cargo location: Refine to the specific cargo location dimension so as to perform the inspection task in a targeted manner. Process: Configure the corresponding inspection process according to different needs, such as intelligent inspection or quick repair. Through these configurations, the system can start the inspection task on demand to ensure the accuracy and reliability of inventory data.

[0038] The cargo space scheduled inspection trigger layer includes: Scenario: Inspection of cargo location accounts and recalculation of cargo location accounts; Inspection dimensions: warehouse, cargo location, commodity, specification, batch; Inspection switch: whether to simulate repair; The parameters related to the trigger layer of the scheduled inspection of cargo locations include: warehouse, cargo location, specification, batch, inspection scenario or recalculation scenario, and whether to simulate repair.

[0039] 3. Cargo inspection data calculation layer: Incremental query data range, only query the data of the day before the current date to ensure that the amount of data calculated is moderate, thereby improving query efficiency. Data sharding and parallel computing, sharding the queried data, and triggering parallel computing through the message sending mechanism to improve the overall efficiency of the inspection. Abnormal data collection, during the calculation process, if abnormal data is found, it will be collected and processed. In this way, the inspection data calculation layer can effectively improve the processing speed while ensuring data accuracy.

[0040] The calculation variables, rules and formulas of the cargo inspection calculation layer are as follows: The current quantity of the cargo location: indicates the actual quantity of physical objects stored in the warehouse, the visible inventory; Available quantity of cargo space: indicates the actual quantity that can be used; Accounting rules: If the document is not effective, the available quantity is recorded; if it is effective, the current quantity is recorded; Accounting formula: Available quantity = current quantity + quantity to be received - quantity to be delivered; The key fields of the cargo location calculation result include: available quantity type, warehouse, cargo location, specification, batch, abnormal quantity, and quantity to be repaired.

[0041] 4. Automatic repair warning layer: if there is abnormal data, it will trigger the early warning system and data backup system, and then trigger automatic repair.

[0042] 5. Intelligent analysis layer of cargo location monitoring indicators: This layer collects key indicators through the monitoring system and calculates a comprehensive weight value to represent the monitoring status.

[0043] The cargo location monitoring indicator analysis layer includes analysis of the following data: Total customers: the number of active customers in the system; Total inspection data: the total amount of data inspected within a specified period; Number of abnormal customers: the number of customers with problems detected; Total abnormal data: The total amount of all abnormal data. These indicators are used to calculate a comprehensive weight value to assess the overall inventory health. This weight value reflects the overall operation status of the inventory location account.

[0044] Example 3 According to a third aspect of the present invention, a computer-readable storage medium is provided, which stores a computer program, and when the computer program is executed by a processor, the method for quickly detecting anomalies in the inventory location account is implemented.

[0045] Example 4 According to a fourth aspect of the present invention, there is also provided an electronic device, including a memory, a processor and a computer program. The computer program is stored in the memory and can be run on the processor. When the processor executes the computer program, the above-mentioned method for quickly detecting anomalies in the inventory location account is implemented.

[0046] Obviously, the above embodiments are merely examples for the purpose of clear explanation, and are not intended to limit the implementation methods. For those skilled in the art, other different forms of changes or modifications can be made based on the above description. It is not necessary and impossible to list all the implementation methods here. The obvious changes or modifications derived therefrom are still within the scope of protection of the invention.

Claims

1. A method for quickly detecting abnormalities in inventory location accounts, characterized in that: include: ‌Configure inspection task rules to specify the inspection data range and inspection cycle, and configure the corresponding inspection process according to different needs; The inspection process includes intelligent inspection and rapid repair; ‌Timed inspection task triggering is used to analyze the inspection task rules and perform intelligent inspection or quick repair; The intelligent inspection includes inspection data calculation and automatic repair warning; The inspection data calculation, incremental query of data with inventory location account changes, and comparison of the data with the inventory location general ledger information in the database. If abnormal data is found, the automatic repair warning is triggered; If no abnormality is found, the inspection ends; The automatic repair warning includes collecting abnormal data, backing up abnormal data, and repairing abnormal data after the backup is successful; The quick fix recalculates the inventory location accounts in a specified range to respond to emergency situations.

2. The method according to claim 1, characterized in that In the smart inspection, after the quick repair, an inventory health indicator analysis is also performed, and the inventory health indicator analysis evaluates the inventory health status by collecting key indicators and calculating comprehensive weight values.

3. The method according to claim 2, characterized in that In the inventory health indicator analysis, the key indicators include the total number of customers, total inspection data, the number of abnormal customers and the total abnormal data; the total number of customers is the number of active customers in the system, the total inspection data is the total amount of data inspected within a specified period, the number of abnormal customers is the number of customers with problems detected, and the total abnormal data is the total amount of all abnormal data.

4. The method according to claim 2, characterized in that: In the inspection data calculation, the queried data is processed in pieces, and a message is sent to trigger the parallel calculation of the inventory location account, and then the data after the parallel calculation is compared with the inventory location general ledger information in the database.

5. The method according to claim 2, characterized in that: In the inspection data calculation, the incremental query of data on inventory location account changes is to query only the data of the day before the current date.

6. A system for quickly detecting abnormalities in inventory location accounts, characterized in that: include: Inspection task rule configuration module, used to specify the inspection data range and inspection cycle, and configure the corresponding inspection process according to different needs; The inspection process includes an intelligent inspection module and a quick repair module; ‌A timed inspection task triggering module is used to analyze the inspection task rules and perform intelligent inspection or quick repair; The intelligent inspection module includes inspection data calculation and automatic repair warning; The inspection data calculation, incremental query of data with inventory location account changes, and comparison of the data with the inventory location general ledger information in the database. If abnormal data is found, the automatic repair warning is triggered; If no abnormality is found, the inspection ends; The automatic repair warning includes collecting abnormal data, backing up abnormal data, and repairing abnormal data after the backup is successful; The quick repair module recalculates the inventory location accounts in a specified range to respond to emergency situations.

7. The system according to claim 6, characterized in that It also includes an inventory health indicator analysis module, which evaluates inventory health status by collecting key indicators and calculating comprehensive weight values.

8. The system according to claim 7, characterized in that In the inspection data calculation, the queried data is processed in pieces, and a message is sent to trigger the parallel calculation of the inventory location account, and then the data after the parallel calculation is compared with the inventory location general ledger information in the database.

9. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the method for quickly detecting anomalies in an inventory location account as described in any one of claims 1 to 5 is implemented.

10. An electronic device comprising a memory, a processor and a computer program, wherein the computer program is stored in the memory and can be run on the processor, wherein: When the processor executes the computer program, the method for quickly detecting anomalies in an inventory location account as described in any one of claims 1 to 5 is implemented.

Images