Processing method for warehouse-out abnormal data

Abstract

The invention discloses a processing method for warehouse-out abnormal data. The method comprises the following steps: detecting an inventory abnormal time point according to inventory flow data, and fragmenting the inventory flow data according to the inventory abnormal time point to obtain inventory flow fragments in different time periods; for each time period, determining the total warehouse-out times and the corrected warehouse-in times of the article receipts according to the inventory flow fragments in the time period; and according to the total warehouse-out frequency and the corrected warehouse-in frequency, determining the abnormal flow of the article receipts in the corresponding time period. Through the technical scheme of the embodiment of the invention, the determination of the abnormal flow in the inventory flow data in the historical process can be realized, the determination mode of the abnormal flow is optimized, and the determination efficiency of the abnormal flow is improved.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and particularly to a method for processing abnormal outbound data. Background Art

[0002] In the inventory management system of the fast-moving consumer goods industry, when a distributor checks the real-time inventory, the current stock quantity obtained always remains non-negative, which conforms to the daily operation perception. However, once the statistical dimension is switched to historical time, in records spanning several months or even years, the inventory quantity suddenly becomes negative in multiple discrete time periods. And for the historical time nodes marked with negative inventory, after cross-verification with the on-site inventory check records, outbound receipt documents, and financial reconciliation vouchers at that time, it is shown that the physical inventory is actually non-negative. The emergence of this phenomenon is due to the fact that the industry generally adopts the accounting treatment method of "one document, multiple postings", that is, it allows the same inbound and outbound document to be repeatedly out-of-stocked and in-stocked, and at the same time, the recording time of outbound and inbound can also be manually set. In a large amount of inventory transaction data, it is very difficult to accurately and quickly find the problem through the human eye or functions, and it cannot well solve the problem of the distributor's trust in historical data. Summary of the Invention

[0003] The present invention provides a method for processing abnormal outbound data to solve the problem of low efficiency in determining abnormal transactions in inventory transaction data.

[0004] According to one aspect of the present invention, there is provided a method for processing abnormal outbound data, including:

[0005] Detecting inventory abnormal time points according to inventory transaction data, and slicing the inventory transaction data according to the inventory abnormal time points to obtain inventory transaction slices in different time periods;

[0006] For each time period, determining the total number of outbound times and the corrected number of inbound times of item documents according to the inventory transaction slice in this time period;

[0007] Determining abnormal transactions of item documents in the corresponding time period according to the total number of outbound times and the corrected number of inbound times.

[0008] The technical solution provided by the present invention can achieve the technical effect of efficiently and accurately determining abnormal transactions by determining inventory abnormal time points, slicing the inventory transaction data to obtain inventory transaction slices in different time periods, and based on the statistics and comparison of the total number of outbound times and the corrected number of inbound times of item documents for each corresponding inventory transaction slice.

[0009] It should be understood that the content described in this section is not intended to identify the key or important features of the embodiments of the present invention, nor is it used to limit the scope of the present invention. Other features of the present invention will become readily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0010] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following will briefly introduce the accompanying drawings required for the description of the embodiments. Obviously, the accompanying drawings in the following description are only some embodiments of the present invention. For those of ordinary skill in the art, without creative efforts, other drawings can be obtained based on these drawings.

[0011] Figure 1 is the first flowchart of a method for processing abnormal outbound data provided by an embodiment of the present invention;

[0012] Figure 2 is the second flowchart of a method for processing abnormal outbound data provided by an embodiment of the present invention;

[0013] Figure 3 is a schematic structural diagram of a device for processing abnormal outbound data provided by an embodiment of the present invention;

[0014] Figure 4 is a schematic structural diagram of an electronic device for implementing the embodiments of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0015] In order to enable those skilled in the art to better understand the solutions of the present invention, the following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some embodiments of the present invention, rather than all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the scope of protection of the present invention.

[0016] It should be noted that the terms "first", "second", etc. in the description and claims of the present invention and the above accompanying drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged under appropriate circumstances so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "comprising" and "having" and any variations thereof are intended to cover non-exclusive inclusion. For example, a process, method, system, product, or device that includes a series of steps or units does not necessarily have to be limited to those steps or units clearly listed, but may include other steps or units not clearly listed or inherent to these processes, methods, products, or devices.

[0017] Figure 1 It is the first flowchart of a method for processing abnormal outbound data provided by an embodiment of the present invention. This embodiment is applicable to the situation where a user determines abnormal flows in inventory transaction data during a historical process. Since the timestamp of the corrected sales outbound of an item document in the inventory transaction data is set before the timestamp of the corrected sales inbound of the item document, it causes the item inventory of the document to be negative due to excessive outbound in a certain period. The scenario applicable to this embodiment is to find abnormal sales outbound flow data in historical inventory transaction data. This method can be executed by a processing device for abnormal outbound data, which can be implemented in the form of hardware and / or software and can be configured in an electronic device with corresponding data processing capabilities. As Figure 1 shown, the method includes:

[0018] S110. Detect an inventory abnormal time point according to the inventory transaction data, and slice the inventory transaction data according to the inventory abnormal time point to obtain inventory transaction slices in different time periods.

[0019] Specifically, before detecting the inventory abnormal time point according to the inventory transaction data, it may include: obtaining the inventory transaction data. There are various ways to obtain the inventory transaction data. For example, it can be by accessing the purchase-sale-inventory system to obtain the entire inventory transaction data; or by reading a pre-customized transaction table, which is used to record the inventory transaction data. The embodiment of the present invention provides various ways to obtain the inventory transaction data, enriching the ways to obtain the inventory transaction data. Users can select the specific way to obtain the inventory transaction data according to the actual situation, improving the user experience.

[0020] Among them, all inventory changes are recorded in the inventory transaction data, and its essence is to record the transfer trajectory of items in the space-time dimension. Each inventory change generates an inventory transaction data. An inventory transaction data includes the transaction information of one item of one document; one item of one document can correspond to multiple inventory transaction data. The inventory abnormal time point is the specific time point when the inventory does not meet the normal expectation. To improve the data processing efficiency, the entire inventory transaction data can be divided into multiple segments. The inventory transaction data can be arranged according to a certain rule. Exemplarily, it can be arranged in order from the front to the back according to the time point corresponding to each inventory transaction data. The inventory abnormal time point can be selected as the time segmentation point according to a certain rule, and the inventory transaction data is sliced according to the time segmentation point to obtain inventory transaction slices in different time periods.

[0021] In an alternative embodiment, an inventory anomaly time point is detected based on inventory transaction data, and the inventory transaction data is segmented according to the inventory anomaly time point to obtain inventory transaction segments for different time periods, including: determining a time point with a negative inventory quantity in the inventory transaction data as the inventory anomaly time point; when the previous time point of the inventory anomaly time point is a normal inventory time point, then determining the inventory anomaly time point as the time segmentation point; and segmenting the inventory transaction data according to the time segmentation point to obtain inventory transaction segments for different time periods.

[0022] Among them, the number of the inventory transaction segments is at least two. The inventory status is normal inventory or abnormal inventory. When the inventory quantity is positive or zero, the inventory status is normal inventory; when the inventory quantity is negative, the inventory status is abnormal inventory. When the inventory status is normal inventory, the corresponding time point is a normal inventory time point; when the inventory status is abnormal inventory, the corresponding time point is an abnormal inventory time point.

[0023] Specifically, all time points are arranged in the order from the front to the back. For each inventory anomaly time point, if the inventory anomaly time point is the i-th time point and the (i - 1)-th time point is a normal inventory time point, then determining the inventory anomaly time point as the time segmentation point; traversing all inventory anomaly time points based on the above method to obtain time segmentation points; and segmenting the inventory transaction data based on the time segmentation points to obtain inventory transaction segments for different time periods. There are two cases, which are respectively:

[0024] The first case is when the number of time segmentation points is at least two, then a time segmentation point set S = {S1,..., Sm} is obtained, and the inventory transaction data is segmented according to the following steps: Initial segmentation: From the first time point t0 to the first time segmentation point S1, a first inventory transaction segment P0 = [t0, S1] is formed; Intermediate segmentation: For any two adjacent segmentation points Sj and Sj+1, an intermediate segment Pj = (Sj, Sj+1] is generated; Termination segmentation: From the last segmentation point Sm to the last time point tn, a termination segment Pm = (Sm, tn] is formed.

[0025] The second case is when the number of time segmentation points is one, then a time segmentation point set S = {S1} is obtained, and the inventory transaction data is segmented according to the following steps: The first segment: From the first time point t0 to the time segmentation point S1, a first inventory transaction segment P0 = [t0, S1] is formed; The second segment: From the time segmentation point S1 to the last time point tn, a second inventory transaction segment P1 = (S1, tn] is formed.

[0026] By adopting the above technical solution, it is possible to optimize the processing operation of inventory transaction data using the time slicing technology, isolate the inventory transaction data before and after in the time dimension based on the inventory exception time point, make the data in different time periods relatively independent, effectively eliminate the mutual interference between data, and can more efficiently locate the abnormal transaction data, which is beneficial to improving the efficiency of data processing and analysis.

[0027] S120. For each time period, determine the total number of outbound times and the corrected inbound times of the item document according to the inventory transaction slices within this time period.

[0028] Among them, the item document is used to uniquely identify the item in the document. The item document has both the unique identifier of the item and the unique identifier of the document; exemplarily, a string obtained by concatenating the unique identifier of the item and the unique identifier of the document can be used as the unique identifier of the item in the document. The same item document can correspond to multiple inventory transaction data, and these multiple inventory transaction data have the same unique identifier of the document and the same unique identifier of the item. The inventory transaction data corresponding to different item documents have different unique identifiers of the document and the same unique identifier of the item, or have the same unique identifier of the document and different unique identifiers of the item, or while having different unique identifiers of the document, also have different unique identifiers of the item. The unique identifier of the document and the unique identifier of the item can be adaptively set according to the actual scenario, and no specific limitation is made here.

[0029] For any item, there may be at least one of a sales outbound document, a corrected sales outbound document, and a corrected sales inbound document. The total number of outbound times of the item document can be determined according to at least one of the sales outbound document flow data and the corrected sales outbound document flow data corresponding to the item, and the corrected inbound times of the item document can be determined according to the corrected sales inbound document flow data corresponding to the item. The corrected sales outbound document is generated when the item in a certain sales outbound document is re-outbound, and the corrected sales inbound document is generated when the item in a certain sales outbound document is inbound.

[0030] S130. Determine the abnormal transactions of the item document in the corresponding time period according to the total number of outbound times and the corrected inbound times.

[0031] Specifically, by determining the total number of outbound times and the corrected inbound times of the item document in the corresponding time period, it can be determined whether the inventory transaction data of the item document in the corresponding time period is abnormal transaction data. Abnormal transaction refers to the inventory transaction data that causes the abnormal inventory status. Abnormal transactions correspond to the documents generated in the corrected scenario, rather than the documents generated in the normal inbound and outbound scenarios.

[0032] The technical solution of the embodiment of the present invention detects the inventory anomaly time point according to the inventory flow data, and slices the inventory flow data according to the inventory anomaly time point to obtain inventory flow slices in different time periods; for each time period, determines the total number of outbound times and the corrected inbound times of the item documents according to the inventory flow slices in this time period; determines the abnormal flow of the item documents in the corresponding time period according to the total number of outbound times and the corrected inbound times, achieving the technical effect of efficiently processing the inventory flow data and accurately determining the abnormal flow.

[0033] In an alternative embodiment, the method further includes: in response to an abnormal flow determination operation, obtaining the historical operations of the user for this abnormal flow, and the content of the historical operations includes the editing records of the field information in the abnormal flow.

[0034] Among them, the editing records of the field information in the abnormal flow include the field information before correction, the field information after correction, the editor, the editing time, etc. Exemplarily, when the user enters the abnormal flow display page and selects the abnormal flow, the display page of the front-end device will call the back-end device to query the editing records of the field information of this abnormal flow, and the front-end device will display this record information, and the user can view this record information, so as to clarify the specific editing records of the abnormal flow, enabling the user to understand the specific content of the historical operations of this abnormal flow, thereby eliminating the user's distrust of historical data.

[0035] Figure 2 It is the second flowchart of a method for processing outbound abnormal data provided by the embodiment of the present invention, which is a concretization based on the above embodiment. As Figure 2 shown, the method includes:

[0036] S210, detecting the inventory anomaly time point according to the inventory flow data, and slicing the inventory flow data according to the inventory anomaly time point to obtain inventory flow slices in different time periods.

[0037] S220, for each time period, removing the purchase flow data corresponding to the purchase order of the item from the inventory flow slices in this time period to obtain the remaining flow data.

[0038] In the embodiment of the present invention, removing the purchase flow data corresponding to the purchase order of the item from the inventory flow slices in this time period achieves the technical effect of removing irrelevant flow data and reducing the data processing pressure.

[0039] S230, extracting the sales outbound order flow data and the corrected sales outbound order flow data corresponding to the item document from the remaining flow data, obtaining the sales outbound times and the corrected sales outbound times of the item document, and obtaining the total outbound times of the item document according to the sales outbound times and the corrected sales outbound times.

[0040] Specifically, for the remaining inventory transaction data, the inventory transaction data is divided from the item dimension to obtain the inventory transaction data corresponding to different items; the inventory transaction data is divided from the document dimension to obtain the inventory transaction data corresponding to different documents. After the above division of the inventory transaction data based on the item dimension and the document dimension, for each item-document, the inventory transaction data corresponding to the item-document is obtained, and the sales delivery note transaction data and the corrected sales delivery note transaction data corresponding to the item-document are extracted from the inventory transaction data corresponding to the item-document. Among them, the division of the inventory transaction data from the document dimension is implemented based on the unique identifier of the document; the division of the inventory transaction data from the item dimension is implemented based on the unique identifier of the item.

[0041] In the embodiment of the present invention, for the inventory transaction slices in different time periods, by grouping the inventory transaction data through the item dimension and the document dimension, the complexity of the many-to-many relationship can be effectively eliminated, which is beneficial to the refined analysis and traceability of the inventory transaction data.

[0042] Exemplarily, the inventory transaction data may include fields such as inventory change type, document type, document number, item name, item quantity, occurrence timestamp (accurate to seconds), and item inventory, recipient information, etc.; the inventory change type may include sales delivery, corrected sales delivery, corrected sales receipt, purchase receipt, etc.; the document type may include sales order and purchase order, etc. When the inventory change type of a piece of inventory transaction data is sales delivery or corrected sales delivery, this piece of inventory transaction data can be regarded as the transaction data for delivery. If the change type of a piece of inventory transaction data is sales delivery, it means that the sales delivery note is a normal sales delivery, then this piece of inventory transaction data is the sales delivery note transaction data; if the change type of a piece of inventory transaction data is corrected sales delivery, it means that after correcting the error information in the sales delivery note, a new delivery operation is performed, generating a corrected sales delivery note, then this piece of inventory transaction data is the corrected sales delivery note transaction data. The scenario where the sales delivery note has error information that needs to be corrected can be an incorrect recipient information (recipient name, recipient contact information, delivery address, etc.). When the inventory change type of a piece of inventory transaction data is corrected sales receipt, this piece of inventory transaction data can be regarded as the transaction data for re-inventory after delivery, indicating that there is error information in the original sales delivery note. Therefore, a red-ink sales delivery note equal to the original sales delivery note is generated for the red-ink write-off operation of the original sales delivery note to reverse the inventory quantity. The negative sales delivery note can be regarded as the corrected sales receipt, then this piece of inventory transaction data is the corrected sales receipt transaction data.

[0043] The document number is the unique identifier of the document. The document number is a unique code generated by the system and is used to independently identify each document during its life cycle. The coding rule of the document number supports user customization. For example, the coding rule of the document number can be "classification prefix + time + serial number". Different types of documents have different classification prefixes. S can be used to represent a sales order and C can be used to represent a purchase order. The format example can be "S250101001", which means that the document is a sales order, the occurrence time is January 1, 2025, and the serial number is 001.

[0044] Among them, the occurrence timestamp of the revised sales warehouse receipt is automatically generated by the system, and the user does not have the permission to set the occurrence timestamp. The user has the permission to set the occurrence timestamp of the revised sales warehouse delivery document. Optionally, the user can also have the permission to set the occurrence timestamp of the sales warehouse delivery document and the occurrence timestamp of the purchase warehouse receipt document.

[0045] In response to the correction operation (also called red-check operation) of the original sales outbound order, a revised sales inbound order is generated, and the current system time is used as the occurrence timestamp of the revised sales inbound order. In response to the re-outbound operation of the original sales outbound order, after confirming and modifying the information to be adjusted in the original sales outbound order, the sales outbound order is outbound again to generate a revised sales outbound order, and the user can set the occurrence timestamp of the revised sales outbound order. Optionally, in response to the sales outbound operation of the item, a sales outbound order corresponding to the item is generated, and the user can set the occurrence timestamp of the sales outbound order. In response to the purchase inbound operation of the item, a purchase inbound order corresponding to the item is generated, and the user can set the occurrence timestamp of the purchase inbound order.

[0046] For each item document, the sales outbound times of the item document are obtained according to the sales outbound order flow data corresponding to the item document, and the revised sales outbound times of the item document are obtained according to the revised sales outbound order flow data corresponding to the item document; wherein, the number of sales outbound order flow data corresponding to the item document is the sales outbound times of the item document; the number of revised sales outbound order flow data corresponding to the item document is the revised sales outbound times of the item document. The sales outbound times and the revised sales outbound times are added together, and the result of the addition is taken as the total outbound times of the item document.

[0047] S240, extracting the revised sales receipt flow data corresponding to the item document from the remaining flow data, and obtaining the revised receipt times corresponding to the item document.

[0048] Among them, the number of revised sales receipt flow data corresponding to the item document is the number of revised receipts of the item document; illustratively, if there are n revised sales receipt flow data corresponding to the item document in the remaining flow data, the number of revised receipts corresponding to the item document is n times.

[0049] S250, determine the abnormal transaction of the item document within the corresponding time period according to the total outbound times and the corrected inbound times.

[0050] In an alternative embodiment, determining the abnormal transaction of the item document within the corresponding time period according to the total outbound times and the corrected inbound times includes: determining the difference obtained by subtracting the corrected inbound times from the total outbound times of any item document within this time period; if the difference is greater than a preset threshold value, then use the corrected sales outbound document transaction data of this item document within this time period as the abnormal transaction. Wherein, the preset threshold value is 1.

[0051] Specifically, during normal outbound, the corrected sales outbound operation of the item document occurs after the corrected sales inbound operation of this item document. If the timestamp of the corrected sales outbound operation of an item document is set before the timestamp of the corrected sales inbound operation of this item document, it will result in more outbound of this item document within a certain time period, and the item document has an outbound anomaly, and the total outbound times of the abnormal outbound are greater than the total outbound times of the normal outbound.

[0052] In an alternative embodiment, after using the corrected sales outbound document transaction data of this item document within this time period as the abnormal transaction, it further includes: searching for the corrected sales inbound document transaction data of this item document from other time periods.

[0053] Specifically, if it is determined that this item document has more outbound within this time period, then relevant transaction data of more inbound of this item document can be searched for within other time periods.

[0054] In an alternative embodiment, searching for the corrected sales inbound document transaction data corresponding to the corrected sales outbound document transaction data of this item document from other time periods includes: determining the difference obtained by subtracting the corrected inbound times from the total outbound times of this item document within other time periods; if the difference is less than the preset threshold value, then determine the corrected sales inbound document transaction data of this item document within this time period.

[0055] After determining the corrected sales outbound document transaction data of this item document within this time period, continue to search for the corrected sales inbound document transaction data of this item document, so as to view the subsequently found corrected sales inbound document transaction data and the corrected sales outbound document transaction data of this item document together, and the user can better clarify that the abnormal transaction will not have an adverse impact on the actual inventory quantity, effectively ensuring the user's trust in historical data.

[0056] In an alternative embodiment, after determining the difference obtained by subtracting the corrected inbound quantity from the total outbound quantity of any item document within the time period, the method further includes: if the difference is equal to a preset threshold value, determining that there is no abnormal transaction for the item document within the time period.

[0057] Under normal circumstances, when an item is sold and shipped out, the outbound quantity of the item document is 1, there are no corrected inbound operations and corrected outbound operations, the corrected inbound quantity and the corrected outbound quantity are 0, and the difference obtained by subtracting the corrected inbound quantity from the total outbound quantity of the item document is 1, indicating that there is no abnormal transaction for the item document within the time period.

[0058] Exemplarily, if the specific content of some fields in the entire inventory transaction data is as follows:

[0059]

[0060] Then, within the time period [January 1, 2025, 13:00:00, January 4, 13:00:00] corresponding to inventory transaction slice 1, for sales order S250102001: the total outbound quantity is 2, the corrected inbound quantity is 0, and the difference between the two is 2. Since this difference is greater than the preset threshold value, determine the corrected sales outbound transaction data for the item document within the time period; for sales order S250103002: the total outbound quantity is 1, the corrected inbound quantity is 0, and the difference between the two is 1. Since this difference is equal to the preset threshold value, determine that there is no abnormal transaction for the item document within the time period; for sales order S250104003: the total outbound quantity is 1, the corrected inbound quantity is 0, and the difference between the two is 1. Since this difference is equal to the preset threshold value, determine that there is no abnormal transaction for the item document within the time period; within the time period (January 4, 2025, 13:00:00, January 6, 13:00:00] corresponding to inventory transaction slice 2, for sales order S250102001: the total outbound quantity is 0, the corrected inbound quantity is 1, and the difference between the two is -1. Since this difference is less than the preset threshold value, determine the corrected sales inbound transaction data for the item document within the time period; for sales order S250104004: the total outbound quantity is 1, the corrected inbound quantity is 0, and the difference between the two is 1. Since this difference is equal to the preset threshold value, determine that there is no abnormal transaction for the item document within the time period.

[0061] In the embodiment of the present invention, for the inventory flow water slicing in different time periods, the operations of grouping and aggregating data based on the item dimension and the document dimension can effectively eliminate the complexity of the many-to-many relationship, compare the total outbound times and the corrected inbound times of the item documents in the corresponding time period according to the set rules, locate the source of the abnormal inventory in the specific document within the specific time period, and find the root cause of the inventory abnormality more quickly and accurately, improving the processing efficiency of determining the abnormal water flow.

[0062] Figure 3 It is a schematic structural diagram of a processing device for outbound abnormal data provided by an embodiment of the present invention. As Figure 3 shown, the device includes:

[0063] An inventory flow water slicing determination module 310, configured to detect an inventory abnormal time point according to inventory flow water data, and slice the inventory flow water data according to the inventory abnormal time point to obtain inventory flow water slices in different time periods;

[0064] A times determination module 320, configured to, for each time period, determine the total outbound times and the corrected inbound times of item documents according to the inventory flow water slices in the time period;

[0065] An abnormality determination module 330, configured to determine the abnormal water flow of item documents in the corresponding time period according to the total outbound times and the corrected inbound times.

[0066] The processing device for outbound abnormal data provided by the embodiment of the present invention can execute the processing method for outbound abnormal data provided by any embodiment of the present invention, and has the corresponding functional modules and beneficial effects for executing the method.

[0067] Figure 4 It shows a schematic structural diagram of an electronic device 40 that can be used to implement the embodiments of the present invention. The electronic device is intended to represent various forms of digital computers, such as, a laptop computer, a desktop computer, a workbench, a personal digital assistant, a server, a blade server, a mainframe computer, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as, a personal digital processor, a cellular phone, a smart phone, a wearable device (such as a helmet, glasses, a watch, etc.) and other similar computing devices. The components shown herein, their connections and relationships, and their functions are only examples and are not intended to limit the implementation of the present invention described and / or claimed herein.

[0068] As Figure 4As shown, the electronic device 40 includes at least one processor 41 and a memory communicatively connected to the at least one processor 41, such as a read-only memory (ROM) 42, a random access memory (RAM) 43, etc. The memory stores a computer program executable by the at least one processor. The processor 41 can perform various appropriate actions and processes according to the computer program stored in the read-only memory (ROM) 42 or the computer program loaded from the storage unit 48 into the random access memory (RAM) 43. In the RAM 43, various programs and data required for the operation of the electronic device 40 can also be stored. The processor 41, the ROM 42, and the RAM 43 are connected to each other via a bus 44. An input / output (I / O) interface 45 is also connected to the bus 44.

[0069] Multiple components in the electronic device 40 are connected to the I / O interface 45, including: an input unit 46, such as a keyboard, a mouse, etc.; an output unit 47, such as various types of displays, speakers, etc.; a storage unit 48, such as a disk, an optical disc, etc.; and a communication unit 49, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 49 allows the electronic device 40 to exchange information / data with other devices via a computer network such as the Internet and / or various telecommunication networks.

[0070] The processor 41 can be various general-purpose and / or special-purpose processing components with processing and computing capabilities. Some examples of the processor 41 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various dedicated artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any suitable processor, controller, microcontroller, etc. The processor 41 executes the various methods and processes described above, such as the processing method for outbound exception data.

[0071] In some embodiments, the processing method for outbound exception data can be implemented as a computer program tangibly embodied in a computer-readable storage medium, such as the storage unit 48. In some embodiments, part or all of the computer program can be loaded and / or installed onto the electronic device 40 via the ROM 42 and / or the communication unit 49. When the computer program is loaded into the RAM 43 and executed by the processor 41, one or more steps of the processing method for outbound exception data described above can be executed. Alternatively, in other embodiments, the processor 41 can be configured to execute the processing method for outbound exception data in any other suitable manner (e.g., by means of firmware).

[0072] The various embodiments of the systems and techniques described above in this specification can be implemented in digital electronic circuitry, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems-on-chip (SOCs), complex programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various embodiments can include: being implemented in one or more computer programs that are executable and / or interpretable on a programmable system including at least one programmable processor, which may be a special-purpose or general-purpose programmable processor that receives data and instructions from, and transmits data and instructions to, a storage system, at least one input device, and at least one output device.

[0073] The computer programs for implementing the methods of the present invention can be written in any combination of one or more programming languages. These computer programs can be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions / operations specified in the flowchart and / or block diagram to be implemented. The computer programs can be executed entirely on the machine, partly on the machine, as a stand-alone software package partly on the machine and partly on a remote machine or entirely on the remote machine or server.

[0074] In the context of the present invention, a computer-readable storage medium can be a tangible medium that can contain or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. The computer-readable storage medium can include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination of the foregoing. Alternatively, the computer-readable storage medium can be a machine-readable signal medium. More specific examples of the machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or Flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0075] To provide interaction with users, the systems and techniques described herein can be implemented on an electronic device having: a display device for displaying information to the user (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor); and a keyboard and a pointing device (e.g., a mouse or a trackball) through which the user can provide input to the electronic device. Other types of devices can also be used to provide interaction with users; for example, the feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including acoustic input, voice input, or tactile input).

[0076] The systems and techniques described herein can be implemented in a computing system including backend components (e.g., as a data server), or a computing system including middleware components (e.g., an application server), or a computing system including frontend components (e.g., a user computer having a graphical user interface or a web browser through which the user can interact with an implementation of the systems and techniques described herein), or a computing system including any combination of such backend components, middleware components, or frontend components. The components of the system can be interconnected to each other by digital data communication in any form or medium (e.g., a communication network). Examples of communication networks include: local area network (LAN), wide area network (WAN), blockchain network, and the Internet.

[0077] The computing system can include a client and a server. The client and the server are generally far from each other and usually interact through a communication network. The client-server relationship is created by computer programs running on the respective computers and having a client-server relationship with each other. The server can be a cloud server, also known as a cloud computing server or a cloud host, which is a host product in the cloud computing service system and solves the defects of difficult management and weak business scalability existing in traditional physical hosts and VPS services.

[0078] It should be understood that various forms of the processes shown above can be used, with steps reordered, added, or deleted. For example, the steps recited in the present invention can be executed in parallel, sequentially, or in a different order, as long as the desired results of the technical solution of the present invention can be achieved, and this is not limited herein.

[0079] The above specific implementation manners do not constitute a limitation on the protection scope of the present invention. Those skilled in the art should understand that various modifications, combinations, sub-combinations, and substitutions can be made according to design requirements and other factors. Any modifications, equivalent substitutions, and improvements made within the spirit and principle of the present invention shall be included within the protection scope of the present invention.

Claims

1. A method for processing abnormal data of outbound, characterized in that, Including: Detecting an inventory anomaly time point based on inventory transaction data, and fragmenting the inventory transaction data according to the inventory anomaly time point to obtain inventory transaction fragments for different time periods; For each time period, determining the total number of outbound transactions and the corrected inbound quantity of item documents based on the inventory transaction fragments for that time period; Determining the abnormal transactions of item documents in the corresponding time period based on the total number of outbound transactions and the corrected inbound quantity; 2. The method according to claim 1, characterized in that, Determining the total number of outbound transactions and the corrected inbound quantity of item documents based on the inventory transaction fragments for that time period, including: Excluding the purchase transaction data corresponding to the purchase order of the item from the inventory transaction fragments for that time period to obtain the remaining transaction data; Extracting the sales outbound order transaction data and the corrected sales outbound order transaction data corresponding to the item document from the remaining transaction data, obtaining the number of sales outbound transactions and the corrected number of sales outbound transactions of the item document, and obtaining the total number of outbound transactions of the item document based on the number of sales outbound transactions and the corrected number of sales outbound transactions; Extracting the corrected sales inbound order transaction data corresponding to the item document from the remaining transaction data, and obtaining the corrected inbound quantity of the item document.

3. The method according to claim 1, wherein Determining the abnormal transactions of item documents in the corresponding time period based on the total number of outbound transactions and the corrected inbound quantity, including: Determining the difference obtained by subtracting the corrected inbound quantity from the total number of outbound transactions of any item document in that time period; If the difference is greater than a preset threshold value, regarding the corrected sales outbound order transaction data of the item document in that time period as abnormal transactions.

4. The method according to claim 3, wherein After regarding the corrected sales outbound order transaction data of the item document in that time period as abnormal transactions, further including: Searching for the corrected sales inbound order transaction data of the item document in other time periods.

5. The method according to claim 4, wherein Searching for the corrected sales inbound order transaction data of the item document in other time periods, including: Determining the difference obtained by subtracting the corrected inbound quantity from the total number of outbound transactions of the item document in other time periods; If the difference is less than the preset threshold value, determining the corrected sales inbound order transaction data of the item document in that time period.

6. The method according to claim 3, wherein If the difference is equal to the preset threshold value, determining that there are no abnormal transactions of the item document in that time period.

7. The method according to claim 3, characterized in that, The preset threshold value is 1.

8. The method according to claim 1, wherein Detecting an inventory anomaly time point based on inventory transaction data, and fragmenting the inventory transaction data according to the inventory anomaly time point to obtain inventory transaction fragments for different time periods, including: Determining the time points with negative inventory quantities in the inventory transaction data as inventory anomaly time points; When the previous time point of the inventory anomaly time point is a normal inventory time point, regarding the inventory anomaly time point as a time segmentation point; Fragmenting the inventory transaction data according to the time segmentation point to obtain inventory transaction fragments for different time periods.

9. The method according to claim 1, wherein Further including: In response to an abnormal transaction determination operation, obtaining the historical operations of the user for the abnormal transaction, the content of the historical operations including the editing records of the field information in the abnormal transaction.

10. The method according to claim 1, characterized in that, The inventory transaction data includes: inventory change type, document type, document number, item name, item quantity, occurrence timestamp, and item inventory quantity; the inventory change types include: sales out, corrected sales out, corrected sales in, and purchase in; the document types include: sales order and purchase order.

Images