CN113762827A - Inventory difference hedging processing method and device - Google Patents
Inventory difference hedging processing method and deviceDownload PDFInfo
- Publication number
- CN113762827A CN113762827ACN202010753995.4ACN202010753995ACN113762827ACN 113762827 ACN113762827 ACN 113762827ACN 202010753995 ACN202010753995 ACN 202010753995ACN 113762827 ACN113762827 ACN 113762827A
- Authority
- CN
- China
- Prior art keywords
- inventory
- difference data
- difference
- data
- stock
- 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.)
- Granted
Links
Images
Classifications
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Business, Economics & Management (AREA)
- Economics (AREA)
- Engineering & Computer Science (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Finance (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Accounting & Taxation (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- General Factory Administration (AREA)
Abstract
Description
Technical Field
The invention relates to the technical field of warehousing, in particular to a warehousing difference hedging processing method and device.
Background
The inventory difference refers to the difference between the actual inventory of the warehouse and the inventory stored by the warehouse management system. The difference may be caused by a variety of reasons, such as the good product being changed into a defective product, or the damaged or lost product, or the actual stock may not be damaged, but the storage location is different from the stock stored in the system. Most of the existing warehouse management systems have different acquisition, management and processing flows. For example, after the inventory is taken, the data of the difference is recorded, the difference is generated, and then the difference is processed manually. Such as verifying and canceling the difference stock, transferring the residue, or complementing and leveling the difference stock.
In the process of implementing the invention, the inventor finds that at least the following problems exist in the prior art:
although the existing warehouse management systems are managed differently, the processing of the difference is dependent on manual work and needs manual processing. In addition, under the existing warehouse management system, an operator needs to process the difference of the articles on one storage position and then processes the difference of the articles on the other storage position, so that the working efficiency is low, and no practical significance is realized.
Disclosure of Invention
In view of this, embodiments of the present invention provide an inventory difference hedge processing method and apparatus, so as to solve the technical problem of low inventory difference processing efficiency.
To achieve the above object, according to an aspect of an embodiment of the present invention, there is provided an inventory difference hedge processing method, including:
acquiring a plurality of inventory difference data from a difference table, and screening out first inventory difference data and second inventory difference data from the plurality of inventory difference data; wherein the first inventory difference data and the second inventory difference data have opposite difference types, and the item dimension information of the first inventory difference data and the second inventory difference data is the same;
carrying out hedging processing on the first inventory difference data and the second inventory difference data;
and updating the stock record table according to the hedging processing result, and writing the hedging record into the stock flow water meter.
Optionally, the step of screening out the first inventory difference data and the second inventory difference data from the plurality of inventory difference data includes:
arranging the plurality of inventory difference data in an ascending order according to the sequence of the difference values from small to large, and taking the first inventory difference data in the queue as the first inventory difference data;
screening out inventory difference data which is opposite to the difference type of the first inventory difference data and has the same item dimension information from the rest inventory difference data;
and according to the sequence of the difference values from small to large, arranging the inventory difference data which are opposite to the first inventory difference data in difference type and have the same article dimension information in an ascending manner, and taking the first inventory difference data in the queue as second inventory difference data.
Optionally, performing hedging processing on the first inventory difference data and the second inventory difference data, including:
if the difference value of the first stock difference data is larger than that of the second stock difference data, setting the difference value of the second stock difference data to be zero, setting the difference state to be hedge completion, and setting the to-be-processed difference value of the first stock difference data to be the difference value of the first stock difference data minus the difference value of the second stock difference data;
if the difference value of the first stock difference data is smaller than the difference value of the second stock difference data, setting the difference value of the first stock difference data to be zero, setting the difference state to be hedge completion, and setting the difference value to be processed of the second stock difference data to be the difference value of the second stock difference data minus the difference value of the first stock difference data;
if the difference value of the first inventory difference data is equal to the difference value of the second inventory difference data, setting the difference values of the first inventory difference data and the second inventory difference data to be zero, and setting the difference states to be in a hedging completion state.
Optionally, updating the inventory record table according to the hedge processing result includes:
and according to the hedge processing result, deducting or increasing the hedge value of the hedge processing for the inventory corresponding to the storage position information of the first inventory difference data and the inventory corresponding to the storage position information of the second inventory difference data in the inventory record table.
Optionally, the hedge record comprises: moving the article from the storage position corresponding to the first inventory difference data to the storage position corresponding to the second inventory difference data, or moving the article from the storage position corresponding to the second inventory difference data to the storage position corresponding to the first inventory difference data; wherein the number of articles moved is the hedge value of the hedge processing.
Optionally, the fields in the difference table include difference type, difference value, difference status, bin information, and item dimension information.
Optionally, the article dimension information includes at least one of an article code, good and defective articles, a serial number, a batch, and a warehousing date.
In addition, according to another aspect of the embodiments of the present invention, there is provided an inventory difference hedge processing apparatus, including:
the screening module is used for acquiring a plurality of inventory difference data from the difference table and screening out first inventory difference data and second inventory difference data from the inventory difference data; wherein the first inventory difference data and the second inventory difference data have opposite difference types, and the item dimension information of the first inventory difference data and the second inventory difference data is the same;
the hedge module is used for carrying out hedge processing on the first inventory difference data and the second inventory difference data;
and the updating module is used for updating the stock record table according to the hedging processing result and writing the hedging record into the stock flow water meter.
Optionally, the screening module is further configured to:
arranging the plurality of inventory difference data in an ascending order according to the sequence of the difference values from small to large, and taking the first inventory difference data in the queue as the first inventory difference data;
screening out inventory difference data which is opposite to the difference type of the first inventory difference data and has the same item dimension information from the rest inventory difference data;
and according to the sequence of the difference values from small to large, arranging the inventory difference data which are opposite to the first inventory difference data in difference type and have the same article dimension information in an ascending manner, and taking the first inventory difference data in the queue as second inventory difference data.
Optionally, the hedging module is further configured to:
if the difference value of the first stock difference data is larger than that of the second stock difference data, setting the difference value of the second stock difference data to be zero, setting the difference state to be hedge completion, and setting the to-be-processed difference value of the first stock difference data to be the difference value of the first stock difference data minus the difference value of the second stock difference data;
if the difference value of the first stock difference data is smaller than the difference value of the second stock difference data, setting the difference value of the first stock difference data to be zero, setting the difference state to be hedge completion, and setting the difference value to be processed of the second stock difference data to be the difference value of the second stock difference data minus the difference value of the first stock difference data;
if the difference value of the first inventory difference data is equal to the difference value of the second inventory difference data, setting the difference values of the first inventory difference data and the second inventory difference data to be zero, and setting the difference states to be in a hedging completion state.
Optionally, the update module is further configured to:
and according to the hedge processing result, deducting or increasing the hedge value of the hedge processing for the inventory corresponding to the storage position information of the first inventory difference data and the inventory corresponding to the storage position information of the second inventory difference data in the inventory record table.
Optionally, the hedge record comprises: moving the article from the storage position corresponding to the first inventory difference data to the storage position corresponding to the second inventory difference data, or moving the article from the storage position corresponding to the second inventory difference data to the storage position corresponding to the first inventory difference data; wherein the number of articles moved is the hedge value of the hedge processing.
Optionally, the fields in the difference table include difference type, difference value, difference status, bin information, and item dimension information.
Optionally, the article dimension information includes at least one of an article code, good and defective articles, a serial number, a batch, and a warehousing date.
According to another aspect of the embodiments of the present invention, there is also provided an electronic device, including:
one or more processors;
a storage device for storing one or more programs,
when the one or more programs are executed by the one or more processors, the one or more processors implement the method of any of the embodiments described above.
According to another aspect of the embodiments of the present invention, there is also provided a computer readable medium, on which a computer program is stored, which when executed by a processor implements the method of any of the above embodiments.
One embodiment of the above invention has the following advantages or benefits: because the technical means of screening out the first inventory difference data and the second inventory difference data with opposite difference types and same item dimension information and then carrying out hedge processing on the first inventory difference data and the second inventory difference data is adopted, the technical problem of low inventory difference processing efficiency in the prior art is solved. According to the embodiment of the invention, the inventory difference data are compared, the difference data which are in accordance with the hedging are matched, and then the hedging processing is carried out, so that the operation of a warehouse manager is reduced, and the inventory difference processing efficiency is improved. The embodiment of the invention also carries out corresponding deduction and addition processing on the inventory stored in the warehouse management system so as to ensure that the actual articles are consistent with the stored data in the system; and the strategy of minimum number of difference data after hedging is adopted, so that a large amount of meaningless operations in the process of processing the difference by the personnel in the warehouse are reduced, the workload of the personnel is further reduced, and the working efficiency of difference processing is improved.
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 view of a main flow of an inventory difference hedge processing method according to an embodiment of the present invention;
fig. 2 is a schematic view of a main flow of an inventory difference hedge processing method according to a referential embodiment of the present invention;
FIG. 3 is a schematic diagram of the main modules of an inventory difference hedge processing arrangement according to an embodiment of the present invention;
FIG. 4 is an exemplary system architecture diagram in which embodiments of the present invention may be employed;
fig. 5 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.
The difference in inventory is not, in most cases, a real loss of goods. Most often due to manual operator error such as loading the article from the a bin to the B bin during racking, or the articles from adjacent A, B bins becoming mixed together at hand. For example, the operator places item S1 from the A bin in the B bin, which also has item S1. When checking, the storage space A can be used for storing 1 article in the storage space S1, and the storage space B can be used for storing one article in the storage space S1.
This results in differences in the repository, but only in the stored details, but for the overall repository. There was no difference in the total amount of the article. Which need not be processed. The library is also not of great concern. In practice, it is more sufficient to correspond the accounting data to the actual data. However, in the current warehouse management system, the operator needs to deal with the difference of the article in the storage position A and then the difference of the article in the storage position B, so that the working efficiency is low, and the system has no practical significance.
Fig. 1 is a schematic diagram of a main flow of an inventory difference hedge processing method according to an embodiment of the present invention. As an embodiment of the present invention, as shown in fig. 1, the inventory difference hedge processing method may include:
step 101, obtaining a plurality of inventory difference data from a difference table, and screening out first inventory difference data and second inventory difference data from the plurality of inventory difference data.
The source of the difference in the library is many, and actions such as inventory, picking, shelving and the like are all entries generated by the difference. The difference type is divided into a plurality of goods and a plurality of goods, and the storage area where the difference is located is divided into a storage area and a goods picking area. Meanwhile, in order to record a difference, information which can uniquely determine the inventory dimension in the system needs to be recorded. The business system collects the information and records the information in the difference table. Optionally, the fields in the difference table include difference type, difference value (absolute value), difference state, bin information (such as bin code, tote code, etc.), and item dimension information. Optionally, the article dimension information includes at least one of an article code, good and defective articles, a serial number, a batch, and a warehousing date. It should be noted that, in the embodiment of the present invention, the difference values are absolute values.
Due to the fact that the sources of the differences are many, not all business data can be hedged, and partial differences such as composition and order picking are closely related to businesses and cannot be automatically processed. Not all stock areas can be differentially hedged, for example, the actual stock in the temporary storage area and the picking area is closely related to the documents, and the hedge cannot be automatically processed. Therefore, the conflict data source in the embodiment of the invention is the difference between the checking and the manual generation, and the stock difference data which is stored in the storage area and has the difference value to be processed not equal to zero is stored.
Screening out first inventory difference data and second inventory difference data from the plurality of inventory difference data, wherein the first inventory difference data and the second inventory difference data need to meet the requirements: the first inventory difference data and the second inventory difference data are opposite in difference type, and the item dimension information of the first inventory difference data and the second inventory difference data is the same.
Optionally, the step of screening out the first inventory difference data and the second inventory difference data from the plurality of inventory difference data includes: arranging the plurality of inventory difference data in an ascending order according to the sequence of the difference values from small to large, and taking the first inventory difference data in the queue as the first inventory difference data; screening out inventory difference data which is opposite to the difference type of the first inventory difference data and has the same item dimension information from the rest inventory difference data; and according to the sequence of the difference values from small to large, arranging the inventory difference data which are opposite to the first inventory difference data in difference type and have the same article dimension information in an ascending manner, and taking the first inventory difference data in the queue as second inventory difference data. The specific screening process is as follows:
1) the inventory difference data is sorted from small to large according to the difference value, which is to ensure that the number of the remaining inventory difference data after processing is minimum.
2) And after sorting, taking out a piece of stock difference data A to be processed with the minimum difference value (absolute value), and if the stock difference data A to be processed does not exist, ending the hedging. If there are a plurality of pieces of stock difference data to be processed having the smallest difference value (absolute value), one piece is randomly taken out as the stock difference data a.
3) Screening inventory difference data satisfying the following conditions:
the difference value to be processed is not zero; the difference type is opposite to the inventory difference data A (namely, if A is more goods, less goods are inquired); the dimension information of the objects is consistent (such as object codes, good and defective objects, serial numbers, batches, warehousing dates and the like. the dimensions are only taken as examples, and actually, the dimensions can be more than the dimensions
4) Sorting the inventory difference data screened in the step 3) from small to large according to the difference value, which is also to ensure that the number of the processed remaining inventory difference data is minimum).
5) And after sorting, taking out a piece of stock difference data B to be processed with the minimum difference value (absolute value). If there are a plurality of pieces of stock difference data to be processed having the smallest difference value (absolute value), one piece is randomly taken out as the stock difference data B.
And 102, carrying out hedging processing on the first inventory difference data and the second inventory difference data.
After the first inventory difference data and the second inventory difference data which can be subjected to hedge processing are screened out, the first inventory difference data and the second inventory difference data are subjected to hedge processing, the number of the difference data subjected to hedge processing is minimum, and therefore operation of a warehouse administrator is reduced.
Optionally, step 102 may comprise: if the difference value of the first stock difference data is larger than that of the second stock difference data, setting the difference value of the second stock difference data to be zero, setting the difference state to be hedge completion, and setting the to-be-processed difference value of the first stock difference data to be the difference value of the first stock difference data minus the difference value of the second stock difference data; if the difference value of the first stock difference data is smaller than the difference value of the second stock difference data, setting the difference value of the first stock difference data to be zero, setting the difference state to be hedge completion, and setting the difference value to be processed of the second stock difference data to be the difference value of the second stock difference data minus the difference value of the first stock difference data; if the difference value of the first inventory difference data is equal to the difference value of the second inventory difference data, setting the difference values of the first inventory difference data and the second inventory difference data to be zero, and setting the difference states to be in a hedging completion state. Specifically, the method comprises the following steps:
if the difference value of the inventory difference data A is greater than that of the inventory difference data B, the to-be-processed difference value of the inventory difference data B is set to be 0, the difference state is set to be the hedging completion, the hedging value of the current hedging processing of A, B is the difference value of the inventory difference data B, and the to-be-processed difference value of the inventory difference data A is A-B.
If the difference value of the inventory difference data A is smaller than that of the inventory difference data B, the to-be-processed difference value of the inventory difference data A is set to be 0, the difference state is set to be the hedging completion, the hedging value of the current hedging processing of A, B is the difference value of the inventory difference data A, and the to-be-processed difference value of the inventory difference data B is B-A.
If the difference value of the inventory difference data A is equal to that of the inventory difference data B, the difference values to be processed of A, B are all set to be 0, the difference state is set to be the hedging completion, and the hedging value of the current hedging processing of A, B is the difference value of the inventory difference data A.
And storing the stock difference data A and B after hedge processing.
And 103, updating the stock record table according to the hedging processing result, and writing the hedging record into the stock flow water meter.
Optionally, updating the inventory record table according to the hedge processing result includes: and according to the hedge processing result, deducting or increasing the hedge value of the hedge processing for the inventory corresponding to the storage position information of the first inventory difference data and the inventory corresponding to the storage position information of the second inventory difference data in the inventory record table. For example, if the difference type is a large quantity, the stock of the corresponding storage position is increased by the hedge value of the hedge processing, and if the difference type is a small quantity, the stock of the corresponding storage position is deducted by the hedge value of the hedge processing. And deducting or increasing the hedge value of the hedge processing at this time corresponding to the inventory records in the system, so that the inventory records are correspondingly consistent with the actual inventory.
Optionally, the hedge record comprises: moving the article from the storage position corresponding to the first inventory difference data to the storage position corresponding to the second inventory difference data, or moving the article from the storage position corresponding to the second inventory difference data to the storage position corresponding to the first inventory difference data; wherein the number of articles moved is the hedge value of the hedge processing. And recording a record of the hedging value of the current processing between A, B in the inventory flow water meter for recording the inventory change.
Examples are as follows:
if the data of inventory difference data A is that item S1 has more items than 1 item at bay C1, and the data of inventory difference data B is that item S1 has less items than 1 item at bay C2. The stock currently records that the stock quantity of the articles at the storage position C1 is 10, and the stock quantity at the storage position C2 is 11.
After the automatic hedging, the to-be-processed difference value recorded by the inventory difference data A is 0, the hedging is in a state of being completed, the to-be-processed difference recorded by the inventory difference data B is 0, and the hedging is in a state of being completed. The stock quantity of the articles at the stock location C1 is 10+1 to 11, and the stock quantity of the articles at the stock location C2 is 11-1 to 10.
A record of the number of 1 discrepancies is also generated for an item moving from bin C2 to bin C1.
And (4) the steps of step 101 and step 103 are repeated until all the inventory difference data are processed, and the inventory difference data remaining in the system are real and need to be processed manually, the items in the warehouse are different, and the number of the difference data is the least.
According to the various embodiments described above, it can be seen that the technical means of screening out the first inventory difference data and the second inventory difference data with opposite difference types and the same item dimension information and then performing the hedge processing on the first inventory difference data and the second inventory difference data solves the technical problem of low inventory difference processing efficiency in the prior art. According to the embodiment of the invention, the inventory difference data are compared, the difference data which are in accordance with the hedging are matched, and then the hedging processing is carried out, so that the operation of a warehouse manager is reduced, and the inventory difference processing efficiency is improved. The embodiment of the invention also carries out corresponding deduction and addition processing on the inventory stored in the warehouse management system so as to ensure that the actual articles are consistent with the stored data in the system; and the strategy of minimum number of difference data after hedging is adopted, so that a large amount of meaningless operations in the process of processing the difference by the personnel in the warehouse are reduced, the workload of the personnel is further reduced, and the working efficiency of difference processing is improved.
Fig. 2 is a schematic view of a main flow of an inventory difference hedge processing method according to a referential embodiment of the present invention. As another embodiment of the present invention, as shown in fig. 2, the inventory difference hedge processing method may include:
step 201, obtaining a plurality of inventory difference data from the difference table.
Step 203, judging whether inventory difference data to be processed exist; if yes, go to step 204; if not, the process is ended.
Step 205, screening out inventory difference data which is opposite to the difference type of the first inventory difference data A and has the same item dimension information from the remaining inventory difference data.
And step 206, arranging the inventory difference data screened in the step 205 in an ascending order according to the sequence of the difference values from small to large.
Step 207, judging whether inventory difference data to be processed exist; if yes, go to step 208; if not; step 203 is performed.
In step 208, a piece of inventory difference data B with the minimum difference value is taken out.
And step 211, updating the inventory record table according to the hedge processing result.
And step 212, writing the hedging record in the inventory flow water meter.
Step 213, judging whether the to-be-processed difference value of the inventory difference data A is zero or not; if yes, go to step 203; if not, go to step 214.
In addition, in one embodiment of the present invention, the detailed implementation of the stock difference hedge processing method is described in detail above, so that the repeated description is omitted here.
Fig. 3 is a schematic diagram of main modules of an inventory difference hedge processing device according to an embodiment of the present invention, and as shown in fig. 3, the inventory differencehedge processing device 300 includes ascreening module 301, ahedge module 302, and anupdate module 303; thescreening module 301 is configured to obtain a plurality of inventory difference data from the difference table, and screen out first inventory difference data and second inventory difference data from the plurality of inventory difference data; wherein the first inventory difference data and the second inventory difference data have opposite difference types, and the item dimension information of the first inventory difference data and the second inventory difference data is the same; thehedge module 302 is configured to hedge the first inventory difference data and the second inventory difference data; the updatingmodule 303 is configured to update the inventory record table according to the hedging processing result, and write the hedging record into the inventory flow water meter.
Optionally, thescreening module 301 is further configured to:
arranging the plurality of inventory difference data in an ascending order according to the sequence of the difference values from small to large, and taking the first inventory difference data in the queue as the first inventory difference data;
screening out inventory difference data which is opposite to the difference type of the first inventory difference data and has the same item dimension information from the rest inventory difference data;
and according to the sequence of the difference values from small to large, arranging the inventory difference data which are opposite to the first inventory difference data in difference type and have the same article dimension information in an ascending manner, and taking the first inventory difference data in the queue as second inventory difference data.
Optionally, thehedging module 302 is further configured to:
if the difference value of the first stock difference data is larger than that of the second stock difference data, setting the difference value of the second stock difference data to be zero, setting the difference state to be hedge completion, and setting the to-be-processed difference value of the first stock difference data to be the difference value of the first stock difference data minus the difference value of the second stock difference data;
if the difference value of the first stock difference data is smaller than the difference value of the second stock difference data, setting the difference value of the first stock difference data to be zero, setting the difference state to be hedge completion, and setting the difference value to be processed of the second stock difference data to be the difference value of the second stock difference data minus the difference value of the first stock difference data;
if the difference value of the first inventory difference data is equal to the difference value of the second inventory difference data, setting the difference values of the first inventory difference data and the second inventory difference data to be zero, and setting the difference states to be in a hedging completion state.
Optionally, the updatingmodule 303 is further configured to:
and according to the hedge processing result, deducting or increasing the hedge value of the hedge processing for the inventory corresponding to the storage position information of the first inventory difference data and the inventory corresponding to the storage position information of the second inventory difference data in the inventory record table.
Optionally, the hedge record comprises: moving the article from the storage position corresponding to the first inventory difference data to the storage position corresponding to the second inventory difference data, or moving the article from the storage position corresponding to the second inventory difference data to the storage position corresponding to the first inventory difference data; wherein the number of articles moved is the hedge value of the hedge processing.
Optionally, the fields in the difference table include difference type, difference value, difference status, bin information, and item dimension information.
Optionally, the article dimension information includes at least one of an article code, good and defective articles, a serial number, a batch, and a warehousing date.
According to the various embodiments described above, it can be seen that the technical means of screening out the first inventory difference data and the second inventory difference data with opposite difference types and the same item dimension information and then performing the hedge processing on the first inventory difference data and the second inventory difference data solves the technical problem of low inventory difference processing efficiency in the prior art. According to the embodiment of the invention, the inventory difference data are compared, the difference data which are in accordance with the hedging are matched, and then the hedging processing is carried out, so that the operation of a warehouse manager is reduced, and the inventory difference processing efficiency is improved. The embodiment of the invention also carries out corresponding deduction and addition processing on the inventory stored in the warehouse management system so as to ensure that the actual articles are consistent with the stored data in the system; and the strategy of minimum number of difference data after hedging is adopted, so that a large amount of meaningless operations in the process of processing the difference by the personnel in the warehouse are reduced, the workload of the personnel is further reduced, and the working efficiency of difference processing is improved.
It should be noted that, in the embodiment of the inventory difference hedge processing device according to the present invention, the above inventory difference hedge processing method has been described in detail, and therefore, the repeated content is not described herein.
Fig. 4 shows anexemplary system architecture 400 of an inventory difference hedge processing method or an inventory difference hedge processing apparatus to which an embodiment of the present invention may be applied.
As shown in fig. 4, thesystem architecture 400 may includeterminal devices network 404, and aserver 405. Thenetwork 404 serves as a medium for providing communication links between theterminal devices server 405.Network 404 may include various types of connections, such as wire, wireless communication links, or fiber optic cables, to name a few.
A user may useterminal devices server 405 over anetwork 404 to receive or send messages or the like. Theterminal devices
Theterminal devices
Theserver 405 may be a server providing various services, such as a background management server (for example only) providing support for shopping websites browsed by users using theterminal devices
It should be noted that the inventory difference hedge processing method provided by the embodiment of the present invention is generally executed by theserver 405, and accordingly, the inventory difference hedge processing device is generally disposed in theserver 405. The inventory difference hedge processing method provided by the embodiment of the present invention may also be executed by theterminal devices terminal devices
It should be understood that the number of terminal devices, networks, and servers in fig. 4 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
Referring now to FIG. 5, shown is a block diagram of acomputer system 500 suitable for use with a terminal device implementing an embodiment of the present invention. The terminal device shown in fig. 5 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. 5, thecomputer system 500 includes a Central Processing Unit (CPU)501 that can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM)502 or a program loaded from astorage section 508 into a Random Access Memory (RAM) 503. In the RAM503, various programs and data necessary for the operation of thesystem 500 are also stored. TheCPU 501,ROM 502, and RAM503 are connected to each other via abus 504. An input/output (I/O)interface 505 is also connected tobus 504.
The following components are connected to the I/O interface 505: aninput portion 506 including a keyboard, a mouse, and the like; anoutput portion 507 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; astorage portion 508 including a hard disk and the like; and acommunication section 509 including a network interface card such as a LAN card, a modem, or the like. Thecommunication section 509 performs communication processing via a network such as the internet. Thedriver 510 is also connected to the I/O interface 505 as necessary. Aremovable medium 511 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on thedrive 510 as necessary, so that a computer program read out therefrom is mounted into thestorage section 508 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 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 may be downloaded and installed from a network through thecommunication section 509, and/or installed from theremovable medium 511. The computer program performs the above-described functions defined in the system of the present invention when executed by the Central Processing Unit (CPU) 501.
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 programs 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 a filtering module, a hedging module, and an updating module, where the names of the modules do not in some cases constitute a limitation on the modules themselves.
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, implement the method of: acquiring a plurality of inventory difference data from a difference table, and screening out first inventory difference data and second inventory difference data from the plurality of inventory difference data; wherein the first inventory difference data and the second inventory difference data have opposite difference types, and the item dimension information of the first inventory difference data and the second inventory difference data is the same; carrying out hedging processing on the first inventory difference data and the second inventory difference data; and updating the stock record table according to the hedging processing result, and writing the hedging record into the stock flow water meter.
According to the technical scheme of the embodiment of the invention, the technical means of screening the first inventory difference data and the second inventory difference data which have opposite difference types and same item dimension information and then carrying out hedging processing on the first inventory difference data and the second inventory difference data is adopted, so that the technical problem of low inventory difference processing efficiency in the prior art is solved. According to the embodiment of the invention, the inventory difference data are compared, the difference data which are in accordance with the hedging are matched, and then the hedging processing is carried out, so that the operation of a warehouse manager is reduced, and the inventory difference processing efficiency is improved. The embodiment of the invention also carries out corresponding deduction and addition processing on the inventory stored in the warehouse management system so as to ensure that the actual articles are consistent with the stored data in the system; and the strategy of minimum number of difference data after hedging is adopted, so that a large amount of meaningless operations in the process of processing the difference by the personnel in the warehouse are reduced, the workload of the personnel is further reduced, and the working efficiency of difference processing is improved.
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 (10)
1. An inventory difference hedge processing method is characterized by comprising the following steps:
acquiring a plurality of inventory difference data from a difference table, and screening out first inventory difference data and second inventory difference data from the plurality of inventory difference data; wherein the first inventory difference data and the second inventory difference data have opposite difference types, and the item dimension information of the first inventory difference data and the second inventory difference data is the same;
carrying out hedging processing on the first inventory difference data and the second inventory difference data;
and updating the stock record table according to the hedging processing result, and writing the hedging record into the stock flow water meter.
2. The method of claim 1, wherein screening the plurality of inventory difference data for a first inventory difference data and a second inventory difference data comprises:
arranging the plurality of inventory difference data in an ascending order according to the sequence of the difference values from small to large, and taking the first inventory difference data in the queue as the first inventory difference data;
screening out inventory difference data which is opposite to the difference type of the first inventory difference data and has the same item dimension information from the rest inventory difference data;
and according to the sequence of the difference values from small to large, arranging the inventory difference data which are opposite to the first inventory difference data in difference type and have the same article dimension information in an ascending manner, and taking the first inventory difference data in the queue as second inventory difference data.
3. The method of claim 1, wherein reconciling the first inventory difference data with the second inventory difference data comprises:
if the difference value of the first stock difference data is larger than that of the second stock difference data, setting the difference value of the second stock difference data to be zero, setting the difference state to be hedge completion, and setting the to-be-processed difference value of the first stock difference data to be the difference value of the first stock difference data minus the difference value of the second stock difference data;
if the difference value of the first stock difference data is smaller than the difference value of the second stock difference data, setting the difference value of the first stock difference data to be zero, setting the difference state to be hedge completion, and setting the difference value to be processed of the second stock difference data to be the difference value of the second stock difference data minus the difference value of the first stock difference data;
if the difference value of the first inventory difference data is equal to the difference value of the second inventory difference data, setting the difference values of the first inventory difference data and the second inventory difference data to be zero, and setting the difference states to be in a hedging completion state.
4. The method of claim 1, wherein updating the inventory records table based on hedge processing results comprises:
and according to the hedge processing result, deducting or increasing the hedge value of the hedge processing for the inventory corresponding to the storage position information of the first inventory difference data and the inventory corresponding to the storage position information of the second inventory difference data in the inventory record table.
5. The method of claim 1, wherein the hedge record comprises: moving the article from the storage position corresponding to the first inventory difference data to the storage position corresponding to the second inventory difference data, or moving the article from the storage position corresponding to the second inventory difference data to the storage position corresponding to the first inventory difference data; wherein the number of articles moved is the hedge value of the hedge processing.
6. The method of claim 1, wherein the fields in the difference table comprise a difference type, a difference value, a difference status, bin information, and item dimension information.
7. The method of claim 6, wherein the item dimension information comprises at least one of an item code, good and defective, serial number, lot, warehousing date.
8. An inventory difference hedge processing device, comprising:
the screening module is used for acquiring a plurality of inventory difference data from the difference table and screening out first inventory difference data and second inventory difference data from the inventory difference data; wherein the first inventory difference data and the second inventory difference data have opposite difference types, and the item dimension information of the first inventory difference data and the second inventory difference data is the same;
the hedge module is used for carrying out hedge processing on the first inventory difference data and the second inventory difference data;
and the updating module is used for updating the stock record table according to the hedging processing result and writing the hedging record into the stock flow water meter.
9. An electronic device, comprising:
one or more processors;
a storage device for storing one or more programs,
the one or more programs, when executed by the one or more processors, implement the method of any of claims 1-7.
10. 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-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010753995.4ACN113762827B (en) | 2020-07-30 | 2020-07-30 | Inventory difference hedging processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010753995.4ACN113762827B (en) | 2020-07-30 | 2020-07-30 | Inventory difference hedging processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113762827Atrue CN113762827A (en) | 2021-12-07 |
| CN113762827B CN113762827B (en) | 2023-11-07 |
Family
ID=78785549
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010753995.4AActiveCN113762827B (en) | 2020-07-30 | 2020-07-30 | Inventory difference hedging processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113762827B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114331722A (en)* | 2021-12-27 | 2022-04-12 | 建信金融科技有限责任公司 | Transaction data processing method and device, electronic equipment and storage medium |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104463545A (en)* | 2014-12-16 | 2015-03-25 | 合肥鑫晟光电科技有限公司 | Warehouse data processing system |
| CN106156987A (en)* | 2016-08-31 | 2016-11-23 | 成都聚美优品科技有限公司 | The equalization methods of inventory variance and device |
| WO2017020740A1 (en)* | 2015-08-06 | 2017-02-09 | 阿里巴巴集团控股有限公司 | Inventory data reconciliation method and device |
| CN106557482A (en)* | 2015-09-25 | 2017-04-05 | 阿里巴巴集团控股有限公司 | A kind of inventory system data-updating method and device |
| US20180114184A1 (en)* | 2016-10-24 | 2018-04-26 | Wal-Mart Stores, Inc. | Systems and methods for monitoring and reconciling inventory |
| CN108133352A (en)* | 2018-02-09 | 2018-06-08 | 东莞嘉泰钟表有限公司 | Method for rapidly processing difference between actual inventory and account inventory of warehouse |
| CN110322186A (en)* | 2018-03-30 | 2019-10-11 | 阿里巴巴集团控股有限公司 | Data object inventory information processing method, apparatus and system |
| CN110414878A (en)* | 2018-04-28 | 2019-11-05 | 北京京东尚科信息技术有限公司 | Inventory's bearing calibration and device and computer readable storage medium |
| CN111126902A (en)* | 2019-12-12 | 2020-05-08 | 江苏苏宁物流有限公司 | Warehouse inventory method and device |
- 2020
- 2020-07-30CNCN202010753995.4Apatent/CN113762827B/enactiveActive
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104463545A (en)* | 2014-12-16 | 2015-03-25 | 合肥鑫晟光电科技有限公司 | Warehouse data processing system |
| WO2017020740A1 (en)* | 2015-08-06 | 2017-02-09 | 阿里巴巴集团控股有限公司 | Inventory data reconciliation method and device |
| CN106557482A (en)* | 2015-09-25 | 2017-04-05 | 阿里巴巴集团控股有限公司 | A kind of inventory system data-updating method and device |
| CN106156987A (en)* | 2016-08-31 | 2016-11-23 | 成都聚美优品科技有限公司 | The equalization methods of inventory variance and device |
| US20180114184A1 (en)* | 2016-10-24 | 2018-04-26 | Wal-Mart Stores, Inc. | Systems and methods for monitoring and reconciling inventory |
| CN108133352A (en)* | 2018-02-09 | 2018-06-08 | 东莞嘉泰钟表有限公司 | Method for rapidly processing difference between actual inventory and account inventory of warehouse |
| CN110322186A (en)* | 2018-03-30 | 2019-10-11 | 阿里巴巴集团控股有限公司 | Data object inventory information processing method, apparatus and system |
| CN110414878A (en)* | 2018-04-28 | 2019-11-05 | 北京京东尚科信息技术有限公司 | Inventory's bearing calibration and device and computer readable storage medium |
| CN111126902A (en)* | 2019-12-12 | 2020-05-08 | 江苏苏宁物流有限公司 | Warehouse inventory method and device |
Non-Patent Citations (2)
| Title |
|---|
| SONG HONGFANG ET AL: "Multi-period optimization with loss-averse customer behavior: Joint pricing and inventory decisions with stochastic demand", 《EXPERT SYSTEMS WITH APPLICATIONS》* |
| 李梦丽: "大型电商仓配中心盘点管理优化研究——以Q公司为例", 《中国优秀硕士学位论文全文数据库电子期刊 经济与管理科学辑》, vol. 2020, no. 2* |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114331722A (en)* | 2021-12-27 | 2022-04-12 | 建信金融科技有限责任公司 | Transaction data processing method and device, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113762827B (en) | 2023-11-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109684369B (en) | Information updating method and device | |
| CN110348771B (en) | Method and device for order grouping of orders | |
| CN111753019B (en) | Data partitioning method and device applied to data warehouse | |
| CN110717697A (en) | Warehouse-out positioning method and device | |
| CN110443531A (en) | The method and apparatus for determining the bit information of article in order | |
| CN111932163B (en) | A method and device for locating outbound goods in a multi-depth warehouse | |
| CN113065106A (en) | Account management method and device | |
| CN110766349A (en) | Tallying method and device | |
| CN111858621A (en) | Method, device, equipment and computer readable medium for monitoring business process | |
| CN113114776A (en) | Data pushing method and device | |
| WO2021008147A1 (en) | Method and device for determining warehouse inventory | |
| CN113379476A (en) | Order processing method and device | |
| CN113742321A (en) | Data updating method and device | |
| CN110826960A (en) | Order picking method, device, equipment and computer readable medium | |
| CN113706064A (en) | Order processing method and device | |
| CN113762827A (en) | Inventory difference hedging processing method and device | |
| CN113128821A (en) | Method and device for determining task | |
| CN111401684A (en) | Task processing method and device | |
| CN109902847B (en) | Method and device for predicting amount of orders in branch warehouse | |
| CN113762863A (en) | Inventory management method and device | |
| CN113704242A (en) | Data processing method and device | |
| CN117893287A (en) | Order information processing method, device, equipment and storage medium | |
| CN112053106A (en) | A method and device for managing items out of warehouse | |
| CN112256566B (en) | Fresh-keeping method and device for test cases | |
| CN111260271A (en) | Method and device for shortening order picking time of store |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |