CN113762816B - Method, device, equipment and storage medium for generating internal distribution list - Google Patents
Method, device, equipment and storage medium for generating internal distribution list Download PDFInfo
- Publication number
- CN113762816B CN113762816B CN202010523495.1A CN202010523495A CN113762816B CN 113762816 B CN113762816 B CN 113762816B CN 202010523495 A CN202010523495 A CN 202010523495A CN 113762816 B CN113762816 B CN 113762816B
- Authority
- CN
- China
- Prior art keywords
- data
- field
- batch data
- batch
- distribution
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 51
- 238000012216 screening Methods 0.000 claims abstract description 19
- 238000007726 management method Methods 0.000 claims description 30
- 238000004590 computer program Methods 0.000 claims description 10
- 238000004891 communication Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 6
- 230000008569 process Effects 0.000 description 5
- 238000009825 accumulation Methods 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 4
- 230000003287 optical effect Effects 0.000 description 3
- 230000000644 propagated effect Effects 0.000 description 2
- 125000004122 cyclic group Chemical group 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000008707 rearrangement Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Physics & Mathematics (AREA)
- Finance (AREA)
- Entrepreneurship & Innovation (AREA)
- Databases & Information Systems (AREA)
- Accounting & Taxation (AREA)
- Data Mining & Analysis (AREA)
- Development Economics (AREA)
- Computational Linguistics (AREA)
- General Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention discloses a method, a device, equipment and a storage medium for generating an internal distribution list, wherein the method comprises the following steps: receiving a query instruction, wherein the query instruction comprises a query field and field data of the query field; inquiring batch data corresponding to field data of the inquiry field from the batch management system by taking the inquiry field as an inquiry dimension; screening batch data to be distributed from the batch data based on the data of the stock place field in the batch data, and creating an internal distribution list according to the batch data to be distributed. The batch data of certain types of commodities can be inquired from the batch management system through the inquiry command; furthermore, batch data of the commodity can be subjected to unified automatic internal order generation processing, so that the problem that in the prior art, a sales person cannot uniformly create an internal order for the commodity is solved. The method can automatically generate the internal distribution list aiming at certain commodities, improves the generation efficiency and accuracy of the internal distribution list, and reduces the manpower and time cost consumption.
Description
Technical Field
The embodiment of the invention relates to the technical field of computers, in particular to a method, a device, equipment and a storage medium for generating an internal distribution list.
Background
Currently, retail companies typically have their own warehouse distribution networks, i.e., utilizing specific warehouses (e.g., a central warehouse that is convenient for transportation and/or rich in commodity sources) to perform commodity purchase or return, and distributing commodities from the specific warehouse to each pre-warehouse for commodity sales.
In the prior art, an internal distribution system of a retail company creates an internal distribution list for immediate creation, and because the internal distribution business generally has distribution cost requirements, sales collectors can manually use the internal distribution system to create the internal distribution list of the commodities between the warehouses when the transaction amount and the transportation cost of the commodities to be distributed between the warehouses meet a certain proportion.
In the process of implementing the present invention, the inventor finds that at least the following technical problems exist in the prior art: when the demand of delivering certain types of commodities of different storehouses to a certain storeroom exists, sales staff cannot uniformly create an internal distribution list for the types of commodities, can only respectively create the internal distribution list for the storerooms meeting the requirement of delivery cost, and manually add the types of commodities to the internal distribution list, so that a great deal of manpower and time cost are consumed, and mistakes are easy to occur.
Disclosure of Invention
The embodiment of the invention provides a method, a device, equipment and a storage medium for generating an internal distribution list, which can automatically generate the internal distribution list aiming at certain commodities, improve the generation efficiency and the accuracy of the internal distribution list and reduce the consumption of manpower and time cost.
In a first aspect, an embodiment of the present invention provides a method for generating an internal configuration order, including:
Receiving a query instruction, wherein the query instruction comprises a query field and field data of the query field;
inquiring batch data corresponding to field data of the inquiry field from a batch management system by taking the inquiry field as an inquiry dimension;
Screening batch data to be distributed from the batch data based on the data of the stock place field in the batch data, and creating an internal distribution list according to the batch data to be distributed.
In a second aspect, an embodiment of the present invention provides an apparatus for generating an internal policy, including:
the instruction receiving module is used for receiving a query instruction, wherein the query instruction comprises a query field and field data of the query field;
the data query module is used for querying batch data corresponding to field data of the query field from the batch management system by taking the query field as a query dimension;
The form creation module is used for screening batch data to be distributed from the batch data based on the data of the stock place field in the batch data, and creating an internal distribution form according to the batch data to be distributed.
In a third aspect, an embodiment of the present invention provides a terminal device, including:
One or more processors;
a memory for storing one or more programs;
The one or more programs, when executed by the one or more processors, cause the one or more processors to implement a method of generating an internal order according to any embodiment of the present invention.
In a fourth aspect, an embodiment of the present invention provides a computer readable storage medium having stored thereon a computer program, which when executed by a processor, implements a method for generating an internal order according to any embodiment of the present invention.
The embodiment of the invention provides a method, a device, equipment and a storage medium for generating an internal distribution list, wherein the device for generating the internal distribution list receives a query instruction, and the query instruction comprises a query field and field data of the query field; inquiring batch data corresponding to field data of the inquiry field from the batch management system by taking the inquiry field as an inquiry dimension; screening batch data to be distributed from the batch data based on the data of the stock place field in the batch data, and creating an internal distribution list according to the batch data to be distributed. The batch data of certain types of commodities can be inquired from the batch management system through the inquiry command; furthermore, batch data of the commodity can be subjected to unified automatic internal order generation processing, so that the problem that in the prior art, a sales person cannot uniformly create an internal order for the commodity is solved. The method can automatically generate the internal distribution list aiming at certain commodities, improves the generation efficiency and accuracy of the internal distribution list, and reduces the manpower and time cost consumption.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, a brief description will be given below of the drawings required for the embodiments or the prior art descriptions, and it is obvious that the drawings in the following description are some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 shows a flowchart of a method for generating an internal order according to an embodiment of the present invention;
FIG. 2 is a flowchart of a method for generating an internal order according to a second embodiment of the present invention;
Fig. 3 is a schematic structural diagram of an internal distribution list generating device according to a third embodiment of the present invention;
fig. 4 shows a schematic hardware structure of a terminal device according to a fourth embodiment of the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the present invention more apparent, the technical solutions of the present invention will be clearly and completely described by means of implementation examples with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention. In the following embodiments, optional features and examples are provided in each embodiment at the same time, and the features described in the embodiments may be combined to form multiple alternatives, and each numbered embodiment should not be considered as only one technical solution.
Example 1
Fig. 1 shows a flowchart of a method for generating an internal order according to an embodiment of the present invention, where the method for generating an internal order according to the embodiment of the present invention may be applicable to a case of generating an internal order in the field of logistics, for example, a case of generating an internal order distributed between internal stores by a retail company. The method may be performed by an in-order generation device implemented in software and/or hardware, preferably in an electronic device, such as a computer or a server.
As shown in fig. 1, the method for generating an internal allocation list provided in the embodiment of the invention includes the following steps:
s110, receiving a query instruction, wherein the query instruction comprises a query field and field data of the query field.
In the traditional method, the internal distribution system creates an internal distribution list in real time, the internal distribution system can be considered to generate the internal distribution list immediately according to the received data, and the generated internal distribution list is the final internal distribution list. In order to meet the distribution cost requirement, sales personnel of retail companies often perform internal distribution at intervals or after accumulating certain commodity quantities. However, during the time interval or the period of accumulating the commodities, the sales staff cannot perform the operation of creating the in-house order according to the requirement of distributing the commodities of the certain type from the different stores to the certain store. The method for generating the internal order disclosed by the embodiment can overcome the defects, and can receive the query instruction at any time to prepare data for creating the internal order.
In embodiments of the present invention, a batch management system (System Applications and Products, SAP) may be used to perform commodity warehousing, in-warehouse and out-of-warehouse management. The SAP may be added with batch data corresponding to the movement of the commodity every time the commodity is moved out of the warehouse or put into the warehouse, and the batch data may include, but is not limited to, data of fields such as commodity inventory location, movement time, shelf life, batch number, supplier, commodity number, commodity attribute, etc. In addition, the data of different fields of the SAP record may be data representing different information and conforming to a preset rule, and may be composed of at least one element such as a number, a letter, a special symbol, and the like. For example, the data for the inventory location fields may be 001, 002, and 003, respectively, which may represent the center bin, the pre-bin 1, and the pre-bin 2, respectively.
In this embodiment, the SAP system may expose the interface of the query data to the generating device of the internal order (may simply be called as generating device), so that the generating device may receive the query instruction input by the user, and query the batch data from the SAP system through the interface of the query data. The query instruction includes a query field and field data corresponding to the query field, where the query field may be any field in batch data recorded by the SAP system, and the field data corresponding to the query field also needs to conform to a preset rule of a corresponding field in the SAP system.
Optionally, the query field includes at least one of: a library age field, a lot number field, and a vendor field.
In this embodiment, the age of the warehouse may be considered as the difference between the current time and the time when the commodity is first recorded into the SAP system, and may be used to represent the time for the commodity to be stored in the warehouse of the retail company, and in general, the larger the age of the commodity, the higher the cost of the warehouse. And inquiring the batch data according to the library age field to obtain a commodity with the library age greater than or equal to the field data of the library age field in the inquiring instruction. Furthermore, the internal distribution is performed based on a batch of commodities with huge warehouse age, so that the commodities with huge warehouse age can be conveniently returned and returned uniformly, and the warehouse cost is reduced.
The retail company can also present business demands of distributing commodities with the same batch number in different warehouses to a front warehouse for sale, or distributing commodities with the same batch number in different warehouses back to a central warehouse for return. By setting the query field as the batch number field, the type of commodities corresponding to the same batch number can be queried and obtained, and unified distribution operation of distributing the commodities with the same batch number back to the central bin or internally to the front bin is facilitated.
In addition, retail establishments may also experience business demands that cease to cooperate with a provider to return all of the provider's goods. By setting the query field as the provider field, the type of commodities corresponding to the same provider can be queried and obtained, and unified distribution operation of distributing the commodities of the same provider back to the central warehouse is facilitated.
It is considered that the query instruction may include at least one query field and field data of the query field, and at least one field may be other fields for querying to meet the service requirement besides the fields disclosed above, which is not exhaustive herein.
S120, inquiring batch data corresponding to field data of the inquiry field from the batch management system by taking the inquiry field as an inquiry dimension.
In the embodiment of the invention, the generating device can call the interface of the query data, and at least one query field and the field data of the query field are sent to the SAP system, so that the SAP system takes the at least one query field as a query dimension, queries batch data corresponding to the field data of the query field from the recorded batch data, and feeds back the query result of the generating device. The generating device can receive the query result fed back by the SAP system so as to realize the query of the batch data corresponding to the query instruction from the batch management system according to the query instruction.
The query instruction may further include query logic, for example, equal to, unequal to, greater than or equal to, less than, etc. Accordingly, the generating device may further send the query logic to the SAP system, so that the SAP system queries the batch data corresponding to the field data of the query field from the recorded batch data according to the query logic. For example, assuming that the query field in the query instruction is a library age field, the field data corresponding to the query field is 25 days, and the query logic is greater than or equal to that of the query field, then the batch data corresponding to the field data of the query field is queried from the batch management system, specifically, the generating device may send the library age field, 25 days and greater than or equal to that of the batch data to the SAP system through the interface of the query data, so that the SAP system queries the batch data with the library age field greater than or equal to 25 days from the batch data, and feeds the queried data back to the generating device.
In addition, when the query logic is not included in the query instruction, the batch data may be queried according to the default logic, and the data of different fields may correspond to different query logic, for example, the query logic corresponding to the inventory location field may be equal.
The batch data of the corresponding type of commodities can be queried from the batch management system by querying the fields and the field data corresponding to the query fields, so that a foundation is laid for uniformly generating the internal allocation list of the certain type of commodities.
S130, screening batch data to be distributed from the batch data based on the data of the stock place field in the batch data, and creating an internal order according to the batch data to be distributed.
In the embodiment of the invention, since the internal distribution list is a bill for recording the batch data of the commodities from one warehouse to another warehouse, the generating device can receive the target inventory location data corresponding to each batch data obtained by inquiry, and can determine the warehouse where the commodity corresponding to each batch data is currently located based on the inventory location field in the batch data. For each batch of data, the generating device can judge whether the data of the stock location field in the batch of data is the same as the target stock location corresponding to the batch of data, if not, the batch of data is used as the batch of data to be distributed, and if so, the commodity corresponding to the batch of data is not required to be distributed.
The generation device may generate the internal order according to batch data in which the data of the stock location field and the target stock location data are identical. Since the data of the stock location fields in the different batch data may be the same or different, and the target stock location data may be the same or different, the number of the internal orders may be one or more.
Optionally, screening the lot data to be delivered from the lot data based on the data of the stock location field in the lot data includes: judging whether the data of the stock location field in the batch data is equal to the target stock location data; if not, the batch data is used as batch data to be distributed.
In this embodiment, when the target inventory location data corresponding to the batch data obtained by the query are the same, the generating device may only receive one target inventory location data, and sequentially determine whether the data of the inventory location field in each batch data is equal to the target inventory location data; if not, taking the batch data as batch data to be distributed; if yes, the batch data is taken as the batch data which does not need to be distributed.
Optionally, creating the internal order according to the batch data to be distributed includes: adding the batch data to be distributed into corresponding distribution records, wherein the distribution start point of the corresponding distribution records is the data of the stock location field in the batch data to be distributed, and the distribution end point of the corresponding distribution records is the target stock location data; and when the triggering condition is met, creating an internal distribution list according to each distribution record.
In this embodiment, for each batch data to be distributed, the data whose distribution start point is the stock location field is the target stock location, and the distribution route from the warehouse at the distribution start point to the warehouse at the distribution terminal is the distribution route of each batch data to be distributed. The generating device can store a plurality of distribution records, each distribution record only records batch data to be distributed of the same distribution route, and different distribution records can correspond to distribution routes from different distribution starting points to distribution ending points.
Illustratively, only batch data to be distributed from bin a to bin B are recorded in the distribution record 1; only the lot data to be dispensed from bin B to bin a is recorded in the dispensing record 2. If the distribution path of the batch data to be distributed obtained by inquiring and screening at the time is from the bin A to the bin B, adding the batch data to be distributed at the time into a distribution record 1; if the distribution path of the batch data to be distributed obtained by next inquiry and screening is from the bin B to the bin A, adding the batch data to be distributed next into the distribution record 2.
When the trigger condition is met, the distribution record can be considered to meet the distribution cost requirement of the internal distribution service, at the moment, the generating device can call an interface for creating the internal distribution list exposed by the internal distribution system, and the to-be-distributed batch data in the same distribution record is created as an internal distribution list through the interface for creating the internal distribution list.
During the period of time accumulation or accumulation of the quantity of goods and the like for meeting the distribution cost requirement of the interior distribution business, the batch data to be distributed is added into different distribution records according to different distribution paths, so that the preparation work of interior distribution of the batch data can be executed at any time, the automatic generation of the interior distribution list for certain types of goods is realized, the generation efficiency and accuracy of the interior distribution list are improved, and the manpower and time cost consumption is reduced.
Further, the triggering condition includes at least one of: every preset time interval, and the quantity of batch data to be distributed in the distribution record reaches a preset quantity.
The preset time interval may be, for example, 2 days or 3 days, and specifically may be preset according to the accumulation speed of the commodities in the actual internal configuration scene, where the faster the accumulation speed, the smaller the time interval may be set. The number of the batch data to be distributed in the distribution record reaches a preset number, and the commodities to be distributed in the warehouse at the distribution start point in the distribution record path can be considered to be accumulated to the preset number. In addition, the triggering condition may be other conditions that can indicate that the transaction amount and the transportation cost of the commodity to be distributed meet a certain proportion, for example, the sum of the selling price amounts of the batch data to be distributed in the distribution record reaches a preset value, which is not exhaustive.
When the triggering condition is that the internal configuration order is created at intervals of a preset time interval, the generating device can set a timer task, for example, a timer task is set by using a spring's quatertz timing task framework, and the timer task can be a cyclic timer task, so that an interface for creating the internal configuration order of the internal configuration system is called at intervals of the preset time interval, and the internal configuration order is created.
Further, creating an internal order from each delivery record includes: inquiring current batch data corresponding to the distribution starting point of each distribution record from a batch management system by taking the inventory location field as an inquiry dimension; and updating the batch data to be distributed of each distribution record according to each current batch data, and creating an internal distribution list according to each updated distribution record.
In this embodiment, since there is a certain time difference between the generation of the delivery record and the creation of the delivery list, in order to ensure that the batch data to be delivered in the delivery list is accurate, the generating device may query the current batch data corresponding to the delivery start point of each delivery record, i.e. the current batch data of the delivery start point warehouse of each batch data to be delivered, from the batch management system by using the inventory location field as the query dimension when creating.
In addition, the generating device can update the batch data to be distributed according to the current batch data. For example, if a commodity corresponding to a certain batch data to be distributed in the current batch data is sold, the batch data to be distributed may be deleted to update the batch data to be distributed; or when inventory occurs after inventory is taken at the delivery starting point, a batch of data is newly recorded, and the newly recorded batch of data also belongs to the batch of data to be delivered, the newly recorded batch of data to be delivered can be added into the corresponding delivery record so as to update the batch of data to be delivered.
By re-inquiring the current batch data corresponding to the delivery starting points of the delivery records before the internal distribution list is created, the batch data to be delivered in the delivery records can be checked and updated, the internal distribution list can be created by using the delivery records as accurate as possible, and the accuracy of the internal distribution list creation is improved.
Optionally, after querying the lot data corresponding to the field data of the query field from the lot management system, the method further includes: locking the batch data, wherein the batch data obtained by inquiry does not comprise the locked batch data; accordingly, when the batch data to be distributed is added to the corresponding distribution record, the method further comprises: unlocking the batch data added to the distribution record.
In this embodiment, the generating device may put the lot data to be distributed obtained by screening into the data pool, and may remove the lot data to be distributed from the data pool and record the lot data to be distributed in the corresponding distribution record. In addition, when the current batch data corresponding to the delivery start point of each delivery record is queried again, the re-determined batch data to be delivered can be put into the data pool, so that updating operations such as adding or deleting the batch data to be delivered in the delivery record can be realized.
The generating device can lock the batch data to be distributed in the process of putting the batch data into the data pool until the batch data is moved out of the data pool, and the problem of operation conflict caused by operation of other personnel on the batch data to be matched can be avoided by locking the data.
According to the method for generating the internal configuration list, provided by the embodiment of the invention, a query instruction is received by a generating device of the internal configuration list, and the query instruction comprises a query field and field data of the query field; inquiring batch data corresponding to field data of the inquiry field from the batch management system by taking the inquiry field as an inquiry dimension; screening batch data to be distributed from the batch data based on the data of the stock place field in the batch data, and creating an internal distribution list according to the batch data to be distributed. The batch data of certain types of commodities can be inquired from the batch management system through the inquiry command; furthermore, batch data of the commodity can be subjected to unified automatic internal order generation processing, so that the problem that in the prior art, a sales person cannot uniformly create an internal order for the commodity is solved. The method can automatically generate the internal distribution list aiming at certain commodities, improves the generation efficiency and accuracy of the internal distribution list, and reduces the manpower and time cost consumption.
Example two
Based on the embodiment, the method optimizes the form generation under the goods return scene, can realize the generation of the waiting goods return form and the goods return form, is beneficial to integrating goods return after uniformly distributing the same batch of goods to the target inventory location, and can meet the business requirement of suppliers for one-time goods return. The present embodiment and the method for generating an internal policy provided in the foregoing embodiment belong to the same inventive concept, and technical details that are not described in detail in the present embodiment may be referred to the foregoing embodiment.
Fig. 2 shows a flowchart of a method for generating an internal order according to a second embodiment of the present invention. Referring to fig. 2, the method for generating an internal configuration order provided in the embodiment of the present invention includes:
S210, receiving a query instruction, wherein the query instruction comprises a query field and field data of the query field.
S220, inquiring batch data corresponding to field data of the inquiry field from the batch management system by taking the inquiry field as an inquiry dimension.
S230, screening batch data to be distributed from the batch data based on the data of the stock place field in the batch data, and creating an internal order according to the batch data to be distributed.
S240, removing the residual batch data of the batch data to be distributed from the batch data, generating a waiting order, and establishing a corresponding relation between the waiting order and the batch data to be distributed.
In this embodiment, the generating device may further generate the waiting order by removing the remaining lot data of the lot data to be distributed from the lot data. It can be considered that when the data of the stock location field in the batch data is equal to the target stock location data, the commodity corresponding to the batch data is in the return warehouse, the commodity corresponding to the batch data is not required to be distributed, and the return bill can be created only after the commodity corresponding to the batch data to be distributed is distributed, so that the return operation is performed. After the generating device generates the waiting and returning bill according to the residual data, the generating device can also establish a corresponding relation between the waiting and returning bill and the batch data to be distributed, so as to lay a foundation for creating the waiting and returning bill for the residual batch data in the waiting and returning bill and the batch data to be distributed of the same type of commodity.
The generating device can also put the residual batch data into another data pool, remove the residual batch data from the other data pool, record the residual batch data into a waiting dispatch list, and establish a corresponding relation between the waiting dispatch list and the batch data to be distributed.
In addition, when the generating device creates the return bill, the generating device can also query the current batch data with the stock location field as the target stock location data from the batch management system; and updating the residual batch data of the waiting bill according to the current batch data, and putting the updated residual batch data into another data pool to realize updating operations such as adding or deleting the waiting bill and improve the accuracy of the batch data in the waiting bill.
In the process that the batch data is put into another data pool until the batch data is moved out of the data pool, the generating device can lock the residual batch data, and by locking the data, the problem of operation conflict caused by operation of other personnel on the data to be matched can be avoided.
S250, inquiring newly added batch data with the inventory location field as target inventory location data from the batch management system by taking the inventory location field as an inquiry dimension.
The generating device can send the delivery list to the logistics delivery system so that the logistics side delivers the commodities corresponding to the batch data to be delivered. The generating device may further monitor whether the lot data to be distributed is distributed back to the warehouse corresponding to the target inventory location data, specifically, may query the lot management system for new lot data with the inventory location field as the target inventory location data at every second preset time interval. The second preset time interval may be 12 hours, may be 24 hours, and is not particularly limited herein. The newly added batch data can comprise batch data corresponding to purchased goods, batch data matched back by each warehouse and batch data newly input when inventory is in inventory filling condition.
S260, judging whether the newly added batch data is matched with the batch data to be distributed.
The determining whether the newly added batch data matches with the batch data to be distributed may specifically be determining whether the newly added batch data includes all the batch data to be distributed.
And S270, if so, creating the delivery order according to the delivery order and the batch data to be delivered corresponding to the delivery order.
In the embodiment of the invention, if the newly added batch data includes all the batch data to be distributed, the batch data to be distributed is considered to be distributed back to the warehouse corresponding to the target inventory location data, and the generating device can also call the interface for creating the return bill provided by the return system, and create the return bill by using the residual batch data in the return bill and the batch data to be distributed corresponding to the return bill.
If the newly added batch data does not include all the batch data to be distributed, the batch data to be distributed is considered to be not completely distributed back to the warehouse corresponding to the target inventory location data, and the generating device can jump to step S250 at this time, and continue to judge whether the newly added batch data and the batch data to be distributed are matched or not until a delivery order is created when the newly added batch data and the batch data to be distributed are matched.
Based on the embodiment, the form generation under the goods return scene is optimized, specifically, the queried batch data of certain types of goods are divided into batch data to be distributed for generating an internal distribution form and residual batch data for generating a waiting goods return form; when the batch data to be distributed is completely distributed to the target inventory location, the batch data in the return bill of the target inventory location and the distributed batch data can be integrated, and then the integrated data is utilized to generate the return bill, so that the generation of the waiting return bill and the return bill is realized, the integrated return of the same batch of commodities after being uniformly distributed to the target inventory location is facilitated, and the business requirement of a supplier for one-time return can be met. In addition, the embodiment of the present invention and the method for generating the internal order proposed by the above embodiment belong to the same inventive concept, and technical details not described in detail in the present embodiment can be seen in the above embodiment, and the present embodiment has the same beneficial effects as the above embodiment.
Example III
Fig. 3 is a schematic structural diagram of an internal order generation device according to a third embodiment of the present invention, where the embodiment of the present invention is applicable to a case of generating an internal order in the field of logistics, for example, a case of generating an internal order distributed between internal stores by a retail company. The generation device of the internal distribution list provided by the invention can realize the generation method of the internal distribution list provided by the embodiment.
As shown in fig. 3, the device for generating an internal order in the embodiment of the present invention includes:
an instruction receiving module 310, configured to receive a query instruction, where the query instruction includes a query field and field data of the query field;
The data query module 320 is configured to query batch data corresponding to field data of the query field from the batch management system by using the query field as a query dimension;
The form creation module 330 is configured to screen lot data to be distributed from the lot data based on the data of the inventory location field in the lot data, and create an internal order according to the lot data to be distributed.
Optionally, the form creation module includes:
the data screening sub-module is used for judging whether the data of the stock location field in the batch data is equal to the target stock location data; if not, the batch data is used as batch data to be distributed.
Optionally, the form creation module includes:
the internal distribution list creation sub-module is used for adding the batch data to be distributed into corresponding distribution records, wherein the distribution start point of the corresponding distribution records is the data of the stock location field in the batch data to be distributed, and the distribution end point of the corresponding distribution records is the target stock location data; and when the triggering condition is met, creating an internal distribution list according to each distribution record.
Further, the triggering condition includes at least one of: every preset time interval, and the quantity of batch data to be distributed in the distribution record reaches a preset quantity.
Optionally, the internal order creation sub-module is specifically configured to: inquiring current batch data corresponding to the distribution starting point of each distribution record from a batch management system by taking the inventory location field as an inquiry dimension; and updating the batch data to be distributed of each distribution record according to each current batch data, and creating an internal distribution list according to each updated distribution record.
Optionally, the generating device of the internal order further includes:
the data locking module is used for locking the batch data after the batch data corresponding to the field data of the query field is queried from the batch management system, wherein the batch data obtained by query does not comprise the locked batch data;
And the data unlocking module is used for unlocking the batch data added to the distribution records when the batch data to be distributed is added to the corresponding distribution records.
Optionally, the form creation module further includes:
The waiting return bill generation sub-module is used for removing the residual batch data of the batch data to be distributed from the batch data after screening the batch data to be distributed from the batch data, generating a waiting return bill and establishing a corresponding relation between the waiting return bill and the batch data to be distributed;
The return bill creation sub-module is used for inquiring newly added batch data with the inventory location field as target inventory location data from the batch management system by taking the inventory location field as an inquiry dimension; judging whether the newly added batch data is matched with the batch data to be distributed or not; if yes, creating a delivery bill according to the delivery waiting bill and the batch data to be delivered corresponding to the delivery waiting bill.
Optionally, the query field includes at least one of: a library age field, a lot number field, and a vendor field.
The generation device of the internal order provided by the embodiment of the present invention belongs to the same inventive concept as the generation method of the internal order provided by the above embodiment, technical details which are not described in detail in the embodiment of the present invention can be seen in the above embodiment, and the embodiment of the present invention has the same beneficial effects as the above embodiment.
Example IV
Fig. 4 shows a schematic hardware structure of a terminal device according to a fourth embodiment of the present invention. The terminal device in the embodiment of the present invention may include, but is not limited to, mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), car terminals (e.g., car navigation terminals), and the like, and stationary terminals such as digital TVs, desktop computers, and the like. The terminal device shown in fig. 4 is only an example, and should not impose any limitation on the functions and the scope of use of the embodiment of the present invention.
As shown in fig. 4, the terminal apparatus 400 may include a processing device (e.g., a central processor, a graphics processor, etc.) 401 that may perform various appropriate actions and processes according to a program stored in a Read-Only Memory (ROM) 402 or a program loaded from a storage device 408 into a random access Memory (Random Access Memory, RAM) 403. In the RAM403, various programs and data necessary for the operation of the terminal apparatus 400 are also stored. The processing device 401, the ROM 402, and the RAM403 are connected to each other by a bus 404. An input/output (I/O) interface 405 is also connected to bus 404.
In general, the following devices may be connected to the I/O interface 405: input devices 406 including, for example, a touch screen, touchpad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; an output device 407 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; storage 408 including, for example, magnetic tape, hard disk, etc.; and a communication device 409. The communication means 409 may allow the terminal device 400 to communicate with other devices wirelessly or by wire to exchange data. While fig. 4 shows a terminal device 400 having various means, it is to be understood that not all of the illustrated means are required to be implemented or provided. More or fewer devices may be implemented or provided instead.
In particular, according to embodiments of the present invention, the processes described above with reference to flowcharts may be implemented as computer software programs. For example, embodiments of the present invention 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 shown in the flowcharts. In such an embodiment, the computer program may be downloaded and installed from a network via communications device 409, or from storage 408, or from ROM 402. The above-described functions defined in the method of the embodiment of the present invention are performed when the computer program is executed by the processing means 401.
The terminal provided by the embodiment of the present invention and the method for generating the internal distribution list provided by the above embodiment belong to the same inventive concept, technical details which are not described in detail in the embodiment of the present invention can be referred to the above embodiment, and the embodiment of the present invention has the same beneficial effects as the above embodiment.
Example five
An embodiment of the present invention provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, implements the method for generating an internal order provided in the above embodiment.
It should be noted that, the computer readable storage medium according to the embodiment of the present invention may be a computer readable signal medium or a computer readable storage medium, or any combination of the two. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any 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 (Random Access Memory, RAM), a Read-only memory (ROM), an erasable programmable Read-only memory (Erasable Programmable Read-OnlyMemory, EPROM) or FLASH memory (FLASH), 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 embodiments of 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 contrast, in embodiments of the present invention, the computer-readable signal medium may comprise a data signal propagated in baseband or as part of a carrier wave, with the computer-readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. 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: electrical wires, fiber optic cables, RF (radio frequency), and the like, or any suitable combination of the foregoing.
In some embodiments, the clients, servers may communicate using any currently known or future developed network protocol, such as HTTP (HyperText TransferProtocol ), and may be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), the internet (e.g., the internet), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future developed networks.
The computer-readable storage medium may be included in the terminal device or may exist alone without being incorporated in the terminal device.
The terminal device stores one or more programs that, when executed by the terminal device, cause the terminal device to:
Receiving a query instruction, wherein the query instruction comprises a query field and field data of the query field; inquiring batch data corresponding to field data of the inquiry field from the batch management system by taking the inquiry field as an inquiry dimension; screening batch data to be distributed from the batch data based on the data of the stock place field in the batch data, and creating an internal distribution list according to the batch data to be distributed.
Or the above computer-readable medium carries one or more programs which, when executed by the terminal device, cause the terminal device to:
Receiving a query instruction, wherein the query instruction comprises a query field and field data of the query field; inquiring batch data corresponding to field data of the inquiry field from the batch management system by taking the inquiry field as an inquiry dimension; screening batch data to be distributed from the batch data based on the data of the stock place field in the batch data, and creating an internal distribution list according to the batch data to be distributed.
Computer program code for carrying out operations of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).
The flowcharts 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 and/or flowchart illustration, and combinations of blocks in the block diagrams and/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 units involved in the embodiments of the present invention may be implemented in software or in hardware. Wherein the names of the units do not constitute a limitation of the units themselves in some cases.
The functions described above herein may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary versions of hardware logic that may be used include: a Field Programmable Gate Array (FPGA), an Application Specific Integrated Circuit (ASIC), an Application Specific Standard Product (ASSP), a system on a chip (SOC), a Complex Programmable Logic Device (CPLD), and the like.
Note that the above is only a preferred embodiment of the present invention and the technical principle applied. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, while the invention has been described in connection with the above embodiments, the invention is not limited to the embodiments, but may be embodied in many other equivalent forms without departing from the spirit or scope of the invention, which is set forth in the following claims.
Claims (10)
1. The method for generating the internal distribution list is characterized by comprising the following steps of:
Receiving a query instruction, wherein the query instruction comprises a query field and field data of the query field;
inquiring batch data corresponding to field data of the inquiry field from a batch management system by taking the inquiry field as an inquiry dimension;
screening batch data to be distributed from the batch data based on the data of the stock place field in the batch data, and creating an internal distribution list according to the batch data to be distributed;
The creating an internal order according to the batch data to be distributed comprises the following steps:
Adding the batch data to be distributed into corresponding distribution records, wherein the distribution start point of the corresponding distribution records is the data of the stock location field in the batch data to be distributed, and the distribution end point of the corresponding distribution records is the target stock location data;
when the trigger condition is met, creating an internal distribution list according to each distribution record; and each distribution record only records the batch data to be distributed of the same distribution route, and different distribution records correspond to distribution routes from different distribution starting points to distribution ending points.
2. The method of claim 1, wherein the screening the lot data for distribution from the lot data based on the data in the inventory location field of the lot data comprises:
judging whether the data of the stock location field in the batch data is equal to the target stock location data;
If not, the batch data is used as batch data to be distributed.
3. The method of claim 1, wherein the trigger condition comprises at least one of: every preset time interval, and the quantity of batch data to be distributed in the distribution record reaches a preset quantity.
4. The method of claim 1, wherein said creating an internal order from each of said delivery records comprises:
inquiring current batch data corresponding to the distribution starting point of each distribution record from the batch management system by taking the inventory location field as an inquiry dimension;
and updating the batch data to be distributed of each distribution record according to each current batch data, and creating an internal distribution list according to each updated distribution record.
5. The method of claim 1, further comprising, after the querying the lot management system for the lot data corresponding to the field data of the query field:
locking the batch data, wherein the batch data obtained by inquiry does not comprise the locked batch data;
Correspondingly, when the batch data to be distributed is added to the corresponding distribution record, the method further comprises the following steps:
Unlocking the batch data added to the distribution record.
6. The method of claim 1, further comprising, after said screening out lot data to be dispensed from said lot data:
Removing the residual batch data of the batch data to be distributed from the batch data, generating a waiting order, and establishing a corresponding relation between the waiting order and the batch data to be distributed;
Inquiring newly added batch data with the inventory location field as target inventory location data from the batch management system by taking the inventory location field as an inquiry dimension;
Judging whether the newly added batch data is matched with the batch data to be distributed or not;
if yes, creating a delivery order according to the delivery order and the batch data to be delivered corresponding to the delivery order.
7. The method of any of claims 1-6, wherein the query field comprises at least one of: a library age field, a lot number field, and a vendor field.
8. An internal order generation device, comprising:
the instruction receiving module is used for receiving a query instruction, wherein the query instruction comprises a query field and field data of the query field;
the data query module is used for querying batch data corresponding to field data of the query field from the batch management system by taking the query field as a query dimension;
The form creation module is used for screening batch data to be distributed from the batch data based on the data of the stock place field in the batch data, and creating an internal distribution form according to the batch data to be distributed;
The form creation module includes: an internal distribution list creation sub-module, configured to add the batch data to be distributed to a corresponding distribution record, where a distribution start point of the corresponding distribution record is data of an inventory location field in the batch data to be distributed, and a distribution end point of the corresponding distribution record is target inventory location data; when the trigger condition is met, creating an internal distribution list according to each distribution record; and each distribution record only records the batch data to be distributed of the same distribution route, and different distribution records correspond to distribution routes from different distribution starting points to distribution ending points.
9. A terminal device, characterized in that the terminal comprises:
One or more processors;
a memory for storing one or more programs;
When executed by the one or more processors, causes the one or more processors to implement the method of generating an internal order as recited in any one of claims 1-7.
10. A computer-readable storage medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, implements a method of generating an internal order according to any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010523495.1A CN113762816B (en) | 2020-06-10 | 2020-06-10 | Method, device, equipment and storage medium for generating internal distribution list |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010523495.1A CN113762816B (en) | 2020-06-10 | 2020-06-10 | Method, device, equipment and storage medium for generating internal distribution list |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113762816A CN113762816A (en) | 2021-12-07 |
| CN113762816B true CN113762816B (en) | 2024-06-18 |
Family
ID=78785349
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010523495.1A Active CN113762816B (en) | 2020-06-10 | 2020-06-10 | Method, device, equipment and storage medium for generating internal distribution list |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113762816B (en) |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109447549A (en) * | 2018-10-17 | 2019-03-08 | 金蝶软件（中国）有限公司 | A kind of method and relevant apparatus that material position is determining |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2009282912A (en) * | 2008-05-26 | 2009-12-03 | Terumo Corp | Commodity distribution management system, commodity distribution management server and commodity distribution management device |
| CN107977815A (en) * | 2017-12-01 | 2018-05-01 | 广东安捷供应链管理股份有限公司 | Warehouse management system and method |
| CN108960718B (en) * | 2018-06-28 | 2021-06-01 | 深圳春沐源控股有限公司 | Warehouse management method and system |
| CN109508885A (en) * | 2018-11-15 | 2019-03-22 | 北京华能新锐控制技术有限公司 | Concocting method and device, storage medium, the processor of spare part |
| CN109858849A (en) * | 2018-12-20 | 2019-06-07 | Oppo（重庆）智能科技有限公司 | Warehouse management system warehouse-out method, device and storage medium |
-
2020
- 2020-06-10 CN CN202010523495.1A patent/CN113762816B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109447549A (en) * | 2018-10-17 | 2019-03-08 | 金蝶软件（中国）有限公司 | A kind of method and relevant apparatus that material position is determining |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113762816A (en) | 2021-12-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11282026B2 (en) | Method and apparatus for planning route | |
| CN113762858B (en) | Inventory management method and device | |
| CN110516984B (en) | Method and apparatus for generating delivery path information | |
| WO2022063300A1 (en) | Allocation information generation method, item allocation method and apparatus, device and medium | |
| CN110633928A (en) | Commodity inverse matching decision method and device | |
| CN112884405A (en) | Inquiry system and scheduling method thereof | |
| CN109902847B (en) | Method and device for predicting amount of orders in branch warehouse | |
| CN113762863A (en) | Inventory management method and device | |
| CN113780914A (en) | Inventory allocation method and device | |
| CN113762816B (en) | Method, device, equipment and storage medium for generating internal distribution list | |
| CN116957268A (en) | Logistics order automatic distribution method and device, electronic equipment and readable storage medium | |
| CN114418482A (en) | Order information processing method and device, electronic equipment and computer readable medium | |
| CN115983762A (en) | Power equipment material getting method and device, electronic equipment and computer medium | |
| CN107085754B (en) | Information output method and device | |
| CN113780650B (en) | Capacity locking method, apparatus, device and storage medium | |
| CN113537680B (en) | Method and device for determining completion time of transportation task | |
| CN113159659A (en) | Method, device, equipment and computer readable medium for updating manifest aging | |
| CN113496386A (en) | Method and device for combined charging | |
| CN113723892A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN112085441A (en) | Information generation method and device, electronic equipment and computer readable medium | |
| CN113822516A (en) | Matching method and device for distribution and transportation side | |
| CN112308478A (en) | Resource allocation data generation method and device | |
| CN113537676A (en) | Method and device for determining completion time of transportation task | |
| CN112053106A (en) | Method and device for managing delivery of articles | |
| CN111695749A (en) | Method and device for generating grouping tasks |
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 |