CN113516425A - Inventory tracking method and device - Google Patents
Inventory tracking method and device Download PDFInfo
- Publication number
- CN113516425A CN113516425A CN202010279655.2A CN202010279655A CN113516425A CN 113516425 A CN113516425 A CN 113516425A CN 202010279655 A CN202010279655 A CN 202010279655A CN 113516425 A CN113516425 A CN 113516425A
- Authority
- CN
- China
- Prior art keywords
- warehouse system
- target
- warehouse
- inventory
- service
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
Abstract
The invention discloses a method and a device for tracking inventory, and relates to the technical field of computers. One embodiment of the method comprises: collecting service data of each warehouse system; acquiring node data of at least two target warehouse systems from the business data, and determining a current business node corresponding to a target single number in each target warehouse system; and when the current service nodes of the target warehouse systems are not consistent, performing inventory leveling operation on the target single number. This embodiment can resources of saving system, improves the execution efficiency, in time discovers the uneven reason in stock, alleviates personnel's contrast work load, avoids artifical contrast data, and is lower to technical staff's professional requirement.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a method and a device for tracking inventory.
Background
In the field of warehousing, synchronous inventory of upstream and downstream systems needs to be realized through intermediate nodes, if more intermediate systems or middleware exist, problems such as network or system abnormity occur in any system or middleware, the inventory is uneven, over-selling is easy to occur, operations such as inventory checking, troubleshooting, inventory leveling and the like need to be performed in time by the upstream and downstream systems, and the inventory checking is very huge, tedious, time-consuming and labor-consuming.
At present, the large data technology is mainly adopted for checking inventory, the inventory data of upstream and downstream systems are extracted, the inventory data of the two systems are regularly compared according to the dimension of a Stock Keeping Unit (SKU), and after the uneven inventory is found, technicians are timely informed to check the inventory so as to investigate the reason that the inventory is uneven.
In the process of implementing the invention, the inventor finds that at least the following problems exist in the prior art:
1. each comparison is to compare the stock of all SKUs of the upstream and downstream systems in a full quantity, which wastes system resources and affects the execution efficiency of the system;
2. the method is transitionally dependent on the historical flow data of the inventory and has no universality;
3. the timeliness is poor;
4. the technical requirements on the technical personnel are high.
Disclosure of Invention
In view of this, embodiments of the present invention provide a method and an apparatus for tracking inventory, which discover difference data through the life cycles of individual single numbers, and directly filter out normal data, so as to save system resources, improve execution efficiency, discover the reason for uneven inventory in time, reduce personnel comparison workload, avoid manual data comparison, and have low professional requirements on technicians.
To achieve the above object, according to an aspect of an embodiment of the present invention, there is provided a method of tracking inventory.
The inventory tracking method in the embodiment of the invention comprises the following steps:
collecting service data of each warehouse system;
acquiring node data of at least two target warehouse systems from the service data, and determining a current service node corresponding to a target single number in each target warehouse system;
and when the current service nodes of the target warehouse systems are not consistent, performing inventory leveling operation on the target single number.
Optionally, the collecting the business data of each warehouse system comprises:
inputting a warehouse system number, associated warehouse information, a warehouse state and early warning information of each warehouse system;
determining service completion time and life cycle of each service type; wherein the lifecycle includes service nodes executed in a service order.
Optionally, the collecting the service data of each warehouse system includes:
and collecting node data generated when each warehouse system executes the service node by using a log extraction or data point burying mode.
Optionally, the node data includes the warehouse system number, a business order number, a life cycle number, a product stock, a node state, creation time, and last update time; and
acquiring node data of at least two target warehouse systems from the service data, and determining a current service node corresponding to a target list number in each target warehouse system, wherein the method comprises the following steps:
analyzing the node data of each target warehouse system;
acquiring service finishing time of a service type corresponding to the service order number, and calculating service execution time based on the creation time and the last update time;
selecting the service order number with the service execution time larger than the service completion time to obtain a target order number;
determining the corresponding current service node of the target single number in each target warehouse system according to the warehouse system number and the node state;
and graphically displaying the life cycle of the target single number in each target warehouse system according to the life cycle number and the current service node of each target warehouse system.
Optionally, performing inventory leveling operation on the target single number, including:
dividing any two associated target warehouse systems into an upstream warehouse system and a downstream warehouse system based on the associated warehouse information;
comparing the product stock amounts of the target product corresponding to the target single number in the upstream warehouse system and the downstream warehouse system;
if the product inventory of the upstream warehouse system is larger than that of the downstream warehouse system, locking the target product in the upstream warehouse system according to a product inventory difference value, carrying out early warning based on the early warning information, and carrying out inventory leveling operation on the target product in the upstream warehouse system or the downstream warehouse system based on the warehouse system number, the warehouse state, the business order number, the product number and the product inventory;
and if the product inventory of the upstream warehouse system is smaller than that of the downstream warehouse system, performing early warning based on the early warning information, and performing inventory leveling operation on the target product in the upstream warehouse system or the downstream warehouse system based on the warehouse system number, the warehouse state, the business order number, the product number and the product inventory.
To achieve the above object, according to still another aspect of an embodiment of the present invention, there is provided an apparatus for tracking inventory.
The inventory tracking device of the embodiment of the invention comprises:
the acquisition module is used for acquiring the service data of each warehouse system;
the determining module is used for acquiring node data of at least two target warehouse systems from the service data and determining a current service node corresponding to a target single number in each target warehouse system;
and the inventory balancing module is used for performing inventory balancing operation on the target single number when the current service nodes of the target warehouse systems are inconsistent.
Optionally, the system further comprises an information module, configured to:
inputting a warehouse system number, associated warehouse information, a warehouse state and early warning information of each warehouse system;
determining service completion time and life cycle of each service type; wherein the lifecycle includes service nodes executed in a service order.
Optionally, the acquisition module is further configured to:
and collecting node data generated when each warehouse system executes the service node by using a log extraction or data point burying mode.
Optionally, the node data includes the warehouse system number, a business order number, a life cycle number, a product stock, a node state, creation time, and last update time; and
the determination module is further to:
analyzing the node data of each target warehouse system;
acquiring service finishing time of a service type corresponding to the service order number, and calculating service execution time based on the creation time and the last update time;
selecting the service order number with the service execution time larger than the service completion time to obtain a target order number;
determining the corresponding current service node of the target single number in each target warehouse system according to the warehouse system number and the node state;
and graphically displaying the life cycle of the target single number in each target warehouse system according to the life cycle number and the current service node of each target warehouse system.
Optionally, the inventory leveling module is further configured to:
dividing any two associated target warehouse systems into an upstream warehouse system and a downstream warehouse system based on the associated warehouse information;
comparing the product stock amounts of the target product corresponding to the target single number in the upstream warehouse system and the downstream warehouse system;
if the product inventory of the upstream warehouse system is larger than that of the downstream warehouse system, locking the target product in the upstream warehouse system according to a product inventory difference value, carrying out early warning based on the early warning information, and carrying out inventory leveling operation on the target product in the upstream warehouse system or the downstream warehouse system based on the warehouse system number, the warehouse state, the business order number, the product number and the product inventory;
and if the product inventory of the upstream warehouse system is smaller than that of the downstream warehouse system, performing early warning based on the early warning information, and performing inventory leveling operation on the target product in the upstream warehouse system or the downstream warehouse system based on the warehouse system number, the warehouse state, the business order number, the product number and the product inventory.
To achieve the above object, according to still another aspect of the embodiments of the present invention, there is provided an electronic device for tracking inventory.
An electronic device for tracking inventory according to an embodiment of the present invention includes: one or more processors; a storage device for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to implement a method of tracking inventory of an embodiment of the invention.
To achieve the above object, according to still another aspect of embodiments of the present invention, there is provided a computer-readable storage medium.
A computer-readable storage medium of an embodiment of the invention has stored thereon a computer program that, when executed by a processor, implements a method of tracking inventory of an embodiment of the invention.
One embodiment of the above invention has the following advantages or benefits: the method adopts the collection of the business data of each warehouse system; acquiring node data of at least two target warehouse systems from the business data, and determining a current business node corresponding to a target single number in each target warehouse system; wherein the service data comprises at least one node data; when the current service nodes of all target warehouse systems are inconsistent, the technical means of inventory balancing operation on the target single numbers discovers differential data through the life cycles of the single numbers (the same single number is at the service nodes of different warehouse systems), and directly filters normal data, so that the technical problems that system resources are wasted, historical inventory data are excessively depended on, the universality is not possessed, the timeliness is poor, and the requirement on the professional performance of technical personnel is high are overcome, further, the system resources are saved, the execution efficiency is improved, the reason that the inventory is uneven is timely discovered, the comparison workload of personnel is reduced, the manual data comparison is avoided, and the technical effect that the requirement on the professional performance of the technical personnel is low.
Further effects of the above-mentioned non-conventional alternatives will be described below in connection with the embodiments.
Drawings
The drawings are included to provide a better understanding of the invention and are not to be construed as unduly limiting the invention. Wherein:
FIG. 1 is a schematic diagram of the main steps of a method of tracking inventory according to an embodiment of the invention;
FIG. 2 is a schematic view of a main flow of a method of tracking inventory according to one referential embodiment of the present invention;
FIG. 3 is a schematic illustration of an order number at the life cycle of various warehouse systems in accordance with a referenced embodiment of the present invention;
FIG. 4 is a schematic diagram graphically illustrating a life cycle, in accordance with one referenced embodiment of the present invention;
FIG. 5 is a schematic diagram of the main modules of an apparatus for tracking inventory according to an embodiment of the present invention;
FIG. 6 is an exemplary system architecture diagram in which embodiments of the present invention may be employed;
fig. 7 is a schematic block diagram of a computer system suitable for use in implementing a terminal device or server of an embodiment of the invention.
Detailed Description
Exemplary embodiments of the present invention are described below with reference to the accompanying drawings, in which various details of embodiments of the invention are included to assist understanding, and which are to be considered as merely exemplary. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.
It should be noted that the embodiments of the present invention and the technical features of the embodiments may be combined with each other without conflict.
Currently, aiming at an upstream system and a downstream system with a comparison relation of inventory historical streamline data, a big data technology is used for comparing inventory historical streamline data of the two systems, inconsistent streamline is screened out, and technicians check specific documents according to the streamline and find out whether the documents are abnormal or not, so that specific problems are solved; the process of checking the inventory needs manual checking for an upstream system and a downstream system which are difficult to compare historical flow data of the inventory, the process needs all historical flow data of SKUs in the two systems to compare all the historical flow data including normal documents one by one, once differences occur again after the same SKU, the process needs to be repeated again, a large amount of manpower and time are consumed, omission and errors are prone to occur, and the historical flow data with high orders of magnitude can hardly be checked manually.
In the prior art, the upstream and downstream stocks are extracted by a big data technology, and the stock data of the upstream and downstream systems are compared with the dimension of the SKU periodically, and the stock is compared with the stock historical flow data of the upstream and downstream systems. Although a great deal of manpower and time can be saved, the method has the following defects:
1. comparing the historical running water data of upstream and downstream systems regularly, and having poor timeliness;
2. in each comparison, whether the stock of the SKUs is uneven or not, the stock of all the SKUs of the upstream and downstream systems is compared in a full quantity mode, so that the waste of system resources is caused, and the execution efficiency of the system is influenced;
3. the inventory is checked by comparing the historical running water data of upstream and downstream systems, the method has no universality, and the upstream and downstream systems which are difficult to compare the historical running water data cannot be used;
4. the problem of positioning is troublesome, and the problem can be solved by a professional through the flowing back check of the document.
Therefore, the embodiment of the invention finds the difference data through the life cycle of the single number (the same single number is at the service nodes of different warehouse systems), and directly filters the normal data, thereby troubleshooting the problem. Considering that the stock difference of a common SKU is accompanied by a single number, such as a purchase single number, an order number, a guest returning single number, a supply returning single number, an internal distribution single number, an inventory single number and the like, the single number is necessarily appeared in upstream and downstream systems, the flow of the single number in each warehouse system is regarded as a life cycle, and as long as the life cycle of the single number in the two warehouse systems is completely finished, the single number is not a source of the stock difference of the SKU. In addition, the life cycle of the single number can be displayed graphically, and the difference data can be displayed visually.
FIG. 1 is a schematic diagram of the main steps of a method of tracking inventory according to an embodiment of the invention.
As shown in fig. 1, the method for tracking inventory of the embodiment of the present invention mainly includes the following steps:
step S101: and collecting the service data of each warehouse system.
Due to supply relation or management relation and the like, operation in one warehouse system can affect another warehouse system, for example, inventory changes, and by collecting operation data (namely business data) affecting the inventory changes in the warehouse system, inventory tracking can be achieved, and the reason that the inventory is uneven can be found in time.
In order to effectively collect service data from the warehouse system, basic information of the warehouse system, such as a warehouse system number, a warehouse system name, an english abbreviation, a related personnel contact way, a related system (for monitoring inventory difference between two warehouse systems), a state, whether to lock differential inventory, and the like, can be recorded in advance, and service completion time and a life cycle corresponding to each service type can be preset, wherein the life cycle comprises service nodes executed according to a service sequence, taking an order as an example, the life cycle comprises positioning inventory-picking off shelf-rechecking, and the positioning inventory, the picking off shelf, and the rechecking are all one service warehouse node, and each service node is executed in one service warehouse system.
In the embodiment of the present invention, before executing step S101, the following steps may also be implemented: inputting the serial number of the warehouse system, the associated warehouse information, the warehouse state and the early warning information of each warehouse system; and determining the service completion time and the life cycle of each service type.
The status of the warehouse status warehouse system, whether differential inventory is locked, etc. are used to indicate the operation status of the warehouse system, and may also indicate that it is correcting inventory during subsequent flat inventory operations.
In the embodiment of the present invention, step S101 may be implemented in the following manner: and collecting node data generated when each warehouse system executes the service node by extracting logs or data embedding points.
Extracting the log refers to extracting specified contents in the log file. Data burial is the implantation of preset codes at specific locations as needed to obtain critical behavior or data. The specific implementation of extracting the log or the data embedding point can utilize the existing technology or tools, and the embodiment of the invention is not repeated. In addition, the collection of the node data can also be realized by other modes, such as actively sending out a message by a warehouse system.
Step S102: and acquiring node data of at least two target warehouse systems from the business data, and determining the corresponding current business node of the target list number in each target warehouse system.
Typically, a business order may exist in multiple warehouse systems with a corresponding and fixed period in each system, which is part of the lifecycle, and the inventory is normally deducted after the end of the cycle. Therefore, it can be determined which node (i.e. the current service node) the target order number arrives at in each target warehouse system through the node data of the target warehouse systems, so as to determine whether the target order number is a source generating the inventory difference.
The node data is data generated when a service node is executed in the warehouse system, and may include a warehouse system number, a service order number, a life cycle number, a product stock, a node state, creation time, and last update time.
In the embodiment of the present invention, step S102 may be implemented in the following manner: analyzing the node data of each target warehouse system; acquiring service finishing time of a service type corresponding to the service order number, and calculating service execution time based on the creation time and the last update time; selecting a service order number with service execution time larger than service completion time to obtain a target order number; determining a current service node corresponding to the target single number in each target warehouse system according to the warehouse system number and the node state; and graphically displaying the life cycle of the target single number in each target warehouse system according to the life cycle number and the current service node of each target warehouse system.
The target warehouse system represents an associated warehouse system that has inventory differences, and the target order number is the number of a task order that may result in inventory differences between the various target warehouse systems. When the inventory difference exists between the associated warehouse systems, the node data of the target warehouse systems are analyzed, and finally the progress of the task list corresponding to the target list number in the target warehouse system, namely which service node (namely the current service node) is executed to is determined.
In addition, the progress of the task list in the target warehouse system can also adopt a graphical display mode, so that technicians can check the inventory more intuitively. The implementation of the graphical display may utilize the existing technologies or tools, and the embodiments of the present invention are not described in detail.
Step S103: and when the current service nodes of the target warehouse systems are not consistent, performing inventory leveling operation on the target single number.
If the current service nodes of the target warehouse systems are not consistent, the progress of the task list in the target warehouse systems is different, namely, the target warehouse systems have inventory difference, and then the inventory leveling operation is needed.
When a certain service node is absent in the life cycle of a certain task list, inventory difference can occur, and the inventory balancing operation is to call a corresponding inventory balancing interface to trigger re-execution and completion of the operation according to the absent service node. The flat stock interface is an interface which is provided by the warehouse system and is executed again by the operation nodes influencing the stock change, each operation node influencing the stock change in each service type in each warehouse system corresponds to one flat stock interface, and different flat stock interfaces can be distinguished and called through the service system number, the service type or the service node.
In the embodiment of the present invention, the step of performing inventory leveling operation on the target single number may be implemented in the following manner: dividing any two associated target warehouse systems into an upstream warehouse system and a downstream warehouse system based on the associated warehouse information; comparing the product inventory in the upstream warehouse system and the downstream warehouse system of the target product corresponding to the target single number; if the product inventory of the upstream warehouse system is larger than that of the downstream warehouse system, locking a target product in the upstream warehouse system according to a product inventory difference value, carrying out early warning based on early warning information, and carrying out inventory leveling operation on the target product in the upstream warehouse system or the downstream warehouse system based on the warehouse system number, the warehouse state, the business order number, the product number and the product inventory; and if the product inventory of the upstream warehouse system is smaller than that of the downstream warehouse system, performing early warning based on the early warning information, and performing inventory leveling operation on the target product in the upstream warehouse system or the downstream warehouse system based on the warehouse system number, the warehouse state, the business order number, the product number and the product inventory.
The upstream warehouse system and the downstream warehouse system are divided according to the related warehouse information, and when the same warehouse system is compared with different warehouse systems, the upstream warehouse system and the downstream warehouse system are possible.
If the inventory of the upstream warehouse system is more than that of the downstream warehouse system, the inventory shortage list may be represented, physical loss, inventory shortage of the downstream warehouse system, inventory deduction, failure in the process of returning to the upstream warehouse system, unreceived by the upstream warehouse system, unredeemed inventory of the upstream warehouse system, and the like may occur, the inventory needs to be locked in time, early warning is performed, for example, related personnel are notified in a mail or short message manner according to early warning information, and then inventory leveling operation is triggered for processing.
If the inventory of the downstream warehouse system is more than that of the upstream warehouse system, the purchase order may be represented, and the early warning is performed and the inventory leveling operation is triggered to process the purchase order if the inventory of the downstream warehouse system is increased, the upstream warehouse system fails to return or the upstream warehouse system does not increase.
According to the inventory tracking method, the business data of each warehouse system are collected; acquiring node data of at least two target warehouse systems from the business data, and determining a current business node corresponding to a target single number in each target warehouse system; wherein the service data comprises at least one node data; when the current service nodes of all target warehouse systems are inconsistent, the technical means of inventory balancing operation on the target single numbers discovers differential data through the life cycles of the single numbers (the same single number is at the service nodes of different warehouse systems), and directly filters normal data, so that the technical problems that system resources are wasted, historical inventory data are excessively depended on, the universality is not possessed, the timeliness is poor, and the requirement on the professional performance of technical personnel is high are overcome, further, the system resources are saved, the execution efficiency is improved, the reason that the inventory is uneven is timely discovered, the comparison workload of personnel is reduced, the manual data comparison is avoided, and the technical effect that the requirement on the professional performance of the technical personnel is low.
In order to further illustrate the technical idea of the present invention, the technical solution of the present invention will now be described with reference to specific application scenarios.
As shown in fig. 2, when the method for tracking inventory according to the embodiment of the present invention is applied, the following process can be referred to:
first, initialize document type
Presetting document types such as orders, purchase orders, customer return orders, withdrawal orders, internal distribution orders, inventory orders and the like and early warning days (namely service finishing time);
secondly, inputting basic information of the access system
Basic information input into an access system (namely a warehouse system) comprises a warehouse system number, a warehouse system name, an English short name, a system related personnel contact mode (mobile phone number + mailbox), an association system (used for automatically monitoring inventory difference between two warehouse systems), a state, whether to lock differential inventory and the like;
thirdly, entering document template information
Template (i.e., life cycle) information may be entered by warehouse system or document type (i.e., business type) dimension, including template number (i.e., life cycle number), warehouse system number, document type, template name, template (e.g., { "status": 10"," desc ": initialize" }, { "status": 20"," desc ": locating inventory" }, { "status": 30"," desc ": shelf for picking up, {" status ": 40", "desc": recheck "}), status, etc.;
fourth, data acquisition
Collecting node data of each access system influencing inventory change by adopting a log extraction or data point burying mode;
fifthly, stock comparison
Comparing the stock according to the dimension of the life cycle, if the life cycle of a single number is completely finished, the single number is not a source of stock difference of the SKU, when the stock difference is compared, the stock difference can be quickly compared according to the SKU, the type of the bill and the time dimension, the stock difference can also be automatically monitored, over-sale can be prevented, historical data are transferred, the relevant personnel of the system are timely notified to process the bill of which the life cycle is not completely finished within the specified early warning days, and the relevant personnel of the system can quickly position the problem according to the single number, process the problem and level the stock.
The inventory tracking method provided by the embodiment of the invention has universality, and as long as the single numbers are consistent, the inventory can be compared between an upstream system and a downstream system even if an intermediate system is arranged between the upstream system and the downstream system, so that the workload of technicians for comparing the inventory, processing problems and leveling the inventory is greatly reduced, the working efficiency is improved, and the error rate is reduced.
One business order corresponds to a fixed business period, and after the business period is finished, the related warehouse systems normally reduce the product inventory of the products related to the business order. Taking an order as an example, the life cycle of an order number in each warehouse system is shown in fig. 3, inventory can be compared according to SKU, document type and time dimension, differential data can be displayed only, normal data are filtered out, and a comparison result is displayed in a page graphical manner, as shown in fig. 4.
According to the correlation system, monitoring abnormal documents of which the recent life cycle is not completely finished within the early warning days according to the dimension of the documents or SKUs, registering abnormal document data, and continuing to explain by using an example in FIG. 4, wherein two orders of ESL110606530004 and ESL110606530005 are only completely finished in the life cycle of one warehouse system, and can be judged as abnormal documents, and if the corresponding SKU inventory is not flat, comparing the inventories of a plurality of warehouse systems related to the orders, wherein the inventory system is upstream of a warehouse sea system, and the warehouse sea system is downstream of the inventory system; simultaneously, the warehouse sea system is the upper reaches of warehouse system, and the warehouse system is the low reaches of warehouse sea system, at specific comparison in-process:
if the stock of the upstream (namely the upstream warehouse system) is more, triggering the access system to lock the stock interface, locking the upstream differential stock, preventing over-selling, and notifying related personnel of the system in a mail or short message mode, wherein the related personnel can troubleshoot problems according to abnormal document data and call the stock balancing interface provided by the access system to balance the stock by triggering an abnormal processing button corresponding to the abnormal document data;
if the downstream (namely the downstream warehouse system) has more stock, informing relevant personnel of the system in a mail or short message mode, and the relevant personnel can check the problems according to the abnormal data of the document and call an inventory leveling interface provided by the access system to level the stock by triggering an abnormal processing button corresponding to the abnormal data of the document;
it should be noted that, in the application, each warehouse system provides an interface for the flat stock of the document for each operation node of each document type that affects the stock change, but only one exception handling button is provided, and different flat stock interfaces can be distinguished and called through the service system number, the service type, or the service node.
The balance can be carried out on the history data with flat stock, the history data of which the life cycle of the single number is completely finished in each system is balanced according to the time point and the dimensionality of the receipt, the stock does not need to be compared by full data, and the comparison or monitoring efficiency is improved.
Fig. 5 is a schematic diagram of the main modules of an apparatus for tracking inventory according to an embodiment of the present invention.
As shown in fig. 5, the apparatus 500 for tracking inventory according to the embodiment of the present invention includes: an acquisition module 501, a determination module 502 and a flat stock module 503.
Wherein the content of the first and second substances,
the acquisition module 501 is used for acquiring the service data of each warehouse system;
a determining module 502, configured to obtain node data of at least two target warehouse systems from the service data, and determine a current service node corresponding to a target order number in each target warehouse system;
and a stock leveling module 503, configured to perform stock leveling operation on the target list number when the current service nodes of the target warehouse systems are inconsistent.
In an embodiment of the present invention, the inventory tracking device 500 may further include an information module (not shown) for:
inputting a warehouse system number, associated warehouse information, a warehouse state and early warning information of each warehouse system;
determining service completion time and life cycle of each service type; wherein the lifecycle includes service nodes executed in a service order.
In this embodiment of the present invention, the acquisition module 501 may further be configured to:
and collecting node data generated when each warehouse system executes the service node by using a log extraction or data point burying mode.
Further, the node data may include the warehouse system number, business form number, life cycle number, product inventory, node status, creation time, last update time.
In this embodiment of the present invention, the determining module 502 may further be configured to:
analyzing the node data of each target warehouse system;
acquiring service finishing time of a service type corresponding to the service order number, and calculating service execution time based on the creation time and the last update time;
selecting the service order number with the service execution time larger than the service completion time to obtain a target order number;
determining the corresponding current service node of the target single number in each target warehouse system according to the warehouse system number and the node state;
and graphically displaying the life cycle of the target single number in each target warehouse system according to the life cycle number and the current service node of each target warehouse system.
In this embodiment of the present invention, the inventory leveling module 503 may further be configured to:
dividing any two associated target warehouse systems into an upstream warehouse system and a downstream warehouse system based on the associated warehouse information;
comparing the product stock amounts of the target product corresponding to the target single number in the upstream warehouse system and the downstream warehouse system;
if the product inventory of the upstream warehouse system is larger than that of the downstream warehouse system, locking the target product in the upstream warehouse system according to a product inventory difference value, carrying out early warning based on the early warning information, and carrying out inventory leveling operation on the target product in the upstream warehouse system or the downstream warehouse system based on the warehouse system number, the warehouse state, the business order number, the product number and the product inventory;
and if the product inventory of the upstream warehouse system is smaller than that of the downstream warehouse system, performing early warning based on the early warning information, and performing inventory leveling operation on the target product in the upstream warehouse system or the downstream warehouse system based on the warehouse system number, the warehouse state, the business order number, the product number and the product inventory.
According to the device for tracking the inventory, the business data of each warehouse system are collected; acquiring node data of at least two target warehouse systems from the business data, and determining a current business node corresponding to a target single number in each target warehouse system; wherein the service data comprises at least one node data; when the current service nodes of all target warehouse systems are inconsistent, the technical means of inventory balancing operation on the target single numbers discovers differential data through the life cycles of the single numbers (the same single number is at the service nodes of different warehouse systems), and directly filters normal data, so that the technical problems that system resources are wasted, historical inventory data are excessively depended on, the universality is not possessed, the timeliness is poor, and the requirement on the professional performance of technical personnel is high are overcome, further, the system resources are saved, the execution efficiency is improved, the reason that the inventory is uneven is timely discovered, the comparison workload of personnel is reduced, the manual data comparison is avoided, and the technical effect that the requirement on the professional performance of the technical personnel is low.
Fig. 6 illustrates an exemplary system architecture 600 of a method or apparatus for tracking inventory to which embodiments of the present invention may be applied.
As shown in fig. 6, the system architecture 600 may include terminal devices 601, 602, 603, a network 604, and a server 605. The network 604 serves to provide a medium for communication links between the terminal devices 601, 602, 603 and the server 605. Network 604 may include various types of connections, such as wire, wireless communication links, or fiber optic cables, to name a few.
A user may use the terminal devices 601, 602, 603 to interact with the server 605 via the network 604 to receive or send messages or the like. Various communication client applications, such as shopping applications, web browser applications, search applications, instant messaging tools, mailbox clients, social platform software, and the like, may be installed on the terminal devices 601, 602, and 603.
The terminal devices 601, 602, 603 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, and the like.
The server 605 may be a server that provides various services, such as a background management server that supports shopping websites browsed by users using the terminal devices 601, 602, and 603. The background management server may analyze and perform other processing on the received data such as the product information query request, and feed back a processing result (e.g., target push information and product information) to the terminal device.
It should be noted that the method for tracking inventory provided by the embodiment of the present invention is generally executed by the server 605, and accordingly, the apparatus for tracking inventory is generally disposed in the server 605.
It should be understood that the number of terminal devices, networks, and servers in fig. 6 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
Referring now to FIG. 7, shown is a block diagram of a computer system 700 suitable for use with a terminal device implementing an embodiment of the present invention. The terminal device shown in fig. 7 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present invention.
As shown in fig. 7, the computer system 700 includes a Central Processing Unit (CPU)701, which can perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)702 or a program loaded from a storage section 708 into a Random Access Memory (RAM) 703. In the RAM 703, various programs and data necessary for the operation of the system 700 are also stored. The CPU 701, the ROM 702, and the RAM 703 are connected to each other via a bus 704. An input/output (I/O) interface 705 is also connected to bus 704.
The following components are connected to the I/O interface 705: an input portion 706 including a keyboard, a mouse, and the like; an output section 707 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage section 708 including a hard disk and the like; and a communication section 709 including a network interface card such as a LAN card, a modem, or the like. The communication section 709 performs communication processing via a network such as the internet. A drive 710 is also connected to the I/O interface 705 as needed. A removable medium 711 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 710 as necessary, so that a computer program read out therefrom is mounted into the storage section 708 as necessary.
In particular, according to the embodiments of the present disclosure, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such an embodiment, the computer program can be downloaded and installed from a network through the communication section 709, and/or installed from the removable medium 711. The computer program performs the above-described functions defined in the system of the present invention when executed by the Central Processing Unit (CPU) 701.
It should be noted that the computer readable medium shown in the present invention can be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having 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. In the present invention, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present invention, however, a computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The modules described in the embodiments of the present invention may be implemented by software or hardware. The described modules may also be provided in a processor, which may be described as: a processor includes an acquisition module, a determination module, and a flat inventory module. The names of the modules do not limit the modules themselves in some cases, and for example, the collection module may be further described as a "module that collects business data of each warehouse system".
As another aspect, the present invention also provides a computer-readable medium that may be contained in the apparatus described in the above embodiments; or may be separate and not incorporated into the device. The computer readable medium carries one or more programs which, when executed by a device, cause the device to comprise: step S101: collecting service data of each warehouse system; step S102: acquiring node data of at least two target warehouse systems from the business data, and determining a current business node corresponding to a target single number in each target warehouse system; step S103: and when the current service nodes of the target warehouse systems are not consistent, performing inventory leveling operation on the target single number.
According to the technical scheme of the embodiment of the invention, the business data of each warehouse system is collected; acquiring node data of at least two target warehouse systems from the business data, and determining a current business node corresponding to a target single number in each target warehouse system; wherein the service data comprises at least one node data; when the current service nodes of all target warehouse systems are inconsistent, the technical means of inventory balancing operation on the target single numbers discovers differential data through the life cycles of the single numbers (the same single number is at the service nodes of different warehouse systems), and directly filters normal data, so that the technical problems that system resources are wasted, historical inventory data are excessively depended on, the universality is not possessed, the timeliness is poor, and the requirement on the professional performance of technical personnel is high are overcome, further, the system resources are saved, the execution efficiency is improved, the reason that the inventory is uneven is timely discovered, the comparison workload of personnel is reduced, the manual data comparison is avoided, and the technical effect that the requirement on the professional performance of the technical personnel is low.
The above-described embodiments should not be construed as limiting the scope of the invention. Those skilled in the art will appreciate that various modifications, combinations, sub-combinations, and substitutions can occur, depending on design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (12)
1. A method of tracking inventory, comprising:
collecting service data of each warehouse system;
acquiring node data of at least two target warehouse systems from the service data, and determining a current service node corresponding to a target single number in each target warehouse system;
and when the current service nodes of the target warehouse systems are not consistent, performing inventory leveling operation on the target single number.
2. The method of claim 1, wherein collecting business data for each warehouse system previously comprises:
inputting a warehouse system number, associated warehouse information, a warehouse state and early warning information of each warehouse system;
determining service completion time and life cycle of each service type; wherein the lifecycle includes service nodes executed in a service order.
3. The method of claim 2, wherein collecting business data for each warehouse system comprises:
and collecting node data generated when each warehouse system executes the service node by using a log extraction or data point burying mode.
4. The method of claim 2, wherein the node data includes the warehouse system number, business form number, lifecycle number, product inventory, node status, creation time, last update time; and
acquiring node data of at least two target warehouse systems from the service data, and determining a current service node corresponding to a target list number in each target warehouse system, wherein the method comprises the following steps:
analyzing the node data of each target warehouse system;
acquiring service finishing time of a service type corresponding to the service order number, and calculating service execution time based on the creation time and the last update time;
selecting the service order number with the service execution time larger than the service completion time to obtain a target order number;
determining the corresponding current service node of the target single number in each target warehouse system according to the warehouse system number and the node state;
and graphically displaying the life cycle of the target single number in each target warehouse system according to the life cycle number and the current service node of each target warehouse system.
5. The method of claim 4, wherein performing a flat inventory operation on the target sheet number comprises:
dividing any two associated target warehouse systems into an upstream warehouse system and a downstream warehouse system based on the associated warehouse information;
comparing the product stock amounts of the target product corresponding to the target single number in the upstream warehouse system and the downstream warehouse system;
if the product inventory of the upstream warehouse system is larger than that of the downstream warehouse system, locking the target product in the upstream warehouse system according to a product inventory difference value, carrying out early warning based on the early warning information, and carrying out inventory leveling operation on the target product in the upstream warehouse system or the downstream warehouse system based on the warehouse system number, the warehouse state, the business order number, the product number and the product inventory;
and if the product inventory of the upstream warehouse system is smaller than that of the downstream warehouse system, performing early warning based on the early warning information, and performing inventory leveling operation on the target product in the upstream warehouse system or the downstream warehouse system based on the warehouse system number, the warehouse state, the business order number, the product number and the product inventory.
6. An apparatus for tracking inventory, comprising:
the acquisition module is used for acquiring the service data of each warehouse system;
the determining module is used for acquiring node data of at least two target warehouse systems from the service data and determining a current service node corresponding to a target single number in each target warehouse system;
and the inventory balancing module is used for performing inventory balancing operation on the target single number when the current service nodes of the target warehouse systems are inconsistent.
7. The apparatus of claim 6, further comprising an information module to:
inputting a warehouse system number, associated warehouse information, a warehouse state and early warning information of each warehouse system;
determining service completion time and life cycle of each service type; wherein the lifecycle includes service nodes executed in a service order.
8. The apparatus of claim 7, wherein the acquisition module is further configured to:
and collecting node data generated when each warehouse system executes the service node by using a log extraction or data point burying mode.
9. The apparatus of claim 7, wherein the node data comprises the warehouse system number, business form number, lifecycle number, product inventory, node status, creation time, last update time; and
the determination module is further to:
analyzing the node data of each target warehouse system;
acquiring service finishing time of a service type corresponding to the service order number, and calculating service execution time based on the creation time and the last update time;
selecting the service order number with the service execution time larger than the service completion time to obtain a target order number;
determining the corresponding current service node of the target single number in each target warehouse system according to the warehouse system number and the node state;
and graphically displaying the life cycle of the target single number in each target warehouse system according to the life cycle number and the current service node of each target warehouse system.
10. The apparatus of claim 9, wherein the inventory leveling module is further configured to:
dividing any two associated target warehouse systems into an upstream warehouse system and a downstream warehouse system based on the associated warehouse information;
comparing the product stock amounts of the target product corresponding to the target single number in the upstream warehouse system and the downstream warehouse system;
if the product inventory of the upstream warehouse system is larger than that of the downstream warehouse system, locking the target product in the upstream warehouse system according to a product inventory difference value, carrying out early warning based on the early warning information, and carrying out inventory leveling operation on the target product in the upstream warehouse system or the downstream warehouse system based on the warehouse system number, the warehouse state, the business order number, the product number and the product inventory;
and if the product inventory of the upstream warehouse system is smaller than that of the downstream warehouse system, performing early warning based on the early warning information, and performing inventory leveling operation on the target product in the upstream warehouse system or the downstream warehouse system based on the warehouse system number, the warehouse state, the business order number, the product number and the product inventory.
11. An electronic device for tracking inventory, comprising:
one or more processors;
a storage device for storing one or more programs,
when executed by the one or more processors, cause the one or more processors to implement the method of any one of claims 1-5.
12. A computer-readable medium, on which a computer program is stored, which, when being executed by a processor, carries out the method according to any one of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010279655.2A CN113516425A (en) | 2020-04-10 | 2020-04-10 | Inventory tracking method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010279655.2A CN113516425A (en) | 2020-04-10 | 2020-04-10 | Inventory tracking method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113516425A true CN113516425A (en) | 2021-10-19 |
Family
ID=78061103
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010279655.2A Pending CN113516425A (en) | 2020-04-10 | 2020-04-10 | Inventory tracking method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113516425A (en) |
Citations (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140006223A1 (en) * | 2012-06-28 | 2014-01-02 | Christopher Thiele | Consistent Interface for Goods and Activity Confirmation |
| US20160342938A1 (en) * | 2014-12-16 | 2016-11-24 | Boe Technology Group Co., Ltd. | Warehouse data processing system and method |
| WO2017020740A1 (en) * | 2015-08-06 | 2017-02-09 | 阿里巴巴集团控股有限公司 | Inventory data reconciliation method and device |
| US9629928B1 (en) * | 2008-03-31 | 2017-04-25 | Symantec Corporation | Hash-based inventory identification |
| CN107292549A (en) * | 2016-03-31 | 2017-10-24 | 阿里巴巴集团控股有限公司 | A kind of inventory monitoring methods and device |
| WO2018036307A1 (en) * | 2016-08-23 | 2018-03-01 | 腾讯科技（深圳）有限公司 | Information processing method utilized in pushing information order, allocation method, device, and data storage medium |
| WO2018210062A1 (en) * | 2017-05-18 | 2018-11-22 | 北京京东尚科信息技术有限公司 | Method and device for determining inventory of items by server system |
| CN108876245A (en) * | 2018-06-25 | 2018-11-23 | 杭州骑轻尘信息技术有限公司 | Automobile storage monitoring and managing method, apparatus and system |
| US20190080398A1 (en) * | 2017-09-12 | 2019-03-14 | Pramod Jain | Automated collateral risk and business performance assessment system |
| CN109544278A (en) * | 2018-11-05 | 2019-03-29 | 广州大学 | A kind of commodity supply and marketing operation system and method based on Internet of Things search |
| CN109544060A (en) * | 2018-10-18 | 2019-03-29 | 金蝶软件（中国）有限公司 | Delivery amount control method, device, computer equipment and storage medium based on ERP |
| CN110222042A (en) * | 2019-05-30 | 2019-09-10 | 口碑(上海)信息技术有限公司 | For determining the method, apparatus, equipment and system architecture of having checked business datum |
| CN110321336A (en) * | 2019-06-21 | 2019-10-11 | 迅鳐成都科技有限公司 | It is a kind of based on block chain in depositary management platform |
| CN110414878A (en) * | 2018-04-28 | 2019-11-05 | 北京京东尚科信息技术有限公司 | Inventory's bearing calibration and device and computer readable storage medium |
| CN110580572A (en) * | 2019-08-22 | 2019-12-17 | 科大智能电气技术有限公司 | Product life-cycle tracing system |
| CN110889656A (en) * | 2018-09-11 | 2020-03-17 | 北京京东振世信息技术有限公司 | Warehouse rule configuration method and device |
-
2020
- 2020-04-10 CN CN202010279655.2A patent/CN113516425A/en active Pending
Patent Citations (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9629928B1 (en) * | 2008-03-31 | 2017-04-25 | Symantec Corporation | Hash-based inventory identification |
| US20140006223A1 (en) * | 2012-06-28 | 2014-01-02 | Christopher Thiele | Consistent Interface for Goods and Activity Confirmation |
| US20160342938A1 (en) * | 2014-12-16 | 2016-11-24 | Boe Technology Group Co., Ltd. | Warehouse data processing system and method |
| WO2017020740A1 (en) * | 2015-08-06 | 2017-02-09 | 阿里巴巴集团控股有限公司 | Inventory data reconciliation method and device |
| CN107292549A (en) * | 2016-03-31 | 2017-10-24 | 阿里巴巴集团控股有限公司 | A kind of inventory monitoring methods and device |
| WO2018036307A1 (en) * | 2016-08-23 | 2018-03-01 | 腾讯科技（深圳）有限公司 | Information processing method utilized in pushing information order, allocation method, device, and data storage medium |
| WO2018210062A1 (en) * | 2017-05-18 | 2018-11-22 | 北京京东尚科信息技术有限公司 | Method and device for determining inventory of items by server system |
| US20190080398A1 (en) * | 2017-09-12 | 2019-03-14 | Pramod Jain | Automated collateral risk and business performance assessment system |
| CN110414878A (en) * | 2018-04-28 | 2019-11-05 | 北京京东尚科信息技术有限公司 | Inventory's bearing calibration and device and computer readable storage medium |
| CN108876245A (en) * | 2018-06-25 | 2018-11-23 | 杭州骑轻尘信息技术有限公司 | Automobile storage monitoring and managing method, apparatus and system |
| CN110889656A (en) * | 2018-09-11 | 2020-03-17 | 北京京东振世信息技术有限公司 | Warehouse rule configuration method and device |
| CN109544060A (en) * | 2018-10-18 | 2019-03-29 | 金蝶软件（中国）有限公司 | Delivery amount control method, device, computer equipment and storage medium based on ERP |
| CN109544278A (en) * | 2018-11-05 | 2019-03-29 | 广州大学 | A kind of commodity supply and marketing operation system and method based on Internet of Things search |
| CN110222042A (en) * | 2019-05-30 | 2019-09-10 | 口碑(上海)信息技术有限公司 | For determining the method, apparatus, equipment and system architecture of having checked business datum |
| CN110321336A (en) * | 2019-06-21 | 2019-10-11 | 迅鳐成都科技有限公司 | It is a kind of based on block chain in depositary management platform |
| CN110580572A (en) * | 2019-08-22 | 2019-12-17 | 科大智能电气技术有限公司 | Product life-cycle tracing system |
Non-Patent Citations (2)
| Title |
|---|
| 孟战平;: "炼化企业基于供应链管理的智能仓库建设", 今日财富, no. 03 * |
| 张永强;周歆瞳;吕宝;: "基于信息系统的仓储管理流程分析", 电子商务, no. 05 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11163731B1 (en) | Autobuild log anomaly detection methods and systems | |
| CN111190888A (en) | Method and device for managing graph database cluster | |
| CN112766907A (en) | Service data processing method and device and server | |
| CN111881221A (en) | Method, device and equipment for customer portrait in logistics service | |
| CN114461644A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| CN106815223B (en) | Mass picture management method and device | |
| CN112433757A (en) | Method and device for determining interface calling relationship | |
| CN113114776A (en) | Data pushing method and device | |
| CN111212112B (en) | Information processing method and device | |
| CN113762910B (en) | Document monitoring method and device | |
| CN114841678B (en) | Post data exchange method, data exchange system, server and storage medium | |
| CN113516425A (en) | Inventory tracking method and device | |
| US11416801B2 (en) | Analyzing value-related data to identify an error in the value-related data and/or a source of the error | |
| CN110866001A (en) | Method and device for determining order to be processed | |
| CN112441364B (en) | Container warehouse-in or warehouse-back method and device for automatic warehouse | |
| CN114491253A (en) | Observation information processing method, device, electronic device and storage medium | |
| US10296967B1 (en) | System, method, and computer program for aggregating fallouts in an ordering system | |
| CN112131077A (en) | Fault node positioning method and device and database cluster system | |
| CN110956430A (en) | Department door recommendation method and device | |
| CN116450622B (en) | Method, apparatus, device and computer readable medium for data warehouse entry | |
| CN112181701A (en) | Method and device for positioning abnormal service request | |
| CN116109112B (en) | Service data processing method, device, medium and equipment based on aggregation interface | |
| CN111813765B (en) | Method, device, electronic equipment and computer readable medium for processing abnormal data | |
| CN113778657B (en) | Data processing method and device | |
| CN112215531B (en) | Method and device for solving logistics distribution problem |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |