CN113313438A - Method and device for generating ex-warehouse form - Google Patents

Method and device for generating ex-warehouse form Download PDF

Info

Publication number
CN113313438A
CN113313438A CN202010120381.2A CN202010120381A CN113313438A CN 113313438 A CN113313438 A CN 113313438A CN 202010120381 A CN202010120381 A CN 202010120381A CN 113313438 A CN113313438 A CN 113313438A
Authority
CN
China
Prior art keywords
warehouse
actual
inventory
amount
detail
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202010120381.2A
Other languages
Chinese (zh)
Inventor
张跃雷
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Jingdong Zhenshi Information Technology Co Ltd
Original Assignee
Beijing Jingdong Zhenshi Information Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Jingdong Zhenshi Information Technology Co Ltd filed Critical Beijing Jingdong Zhenshi Information Technology Co Ltd
Priority to CN202010120381.2A priority Critical patent/CN113313438A/en
Publication of CN113313438A publication Critical patent/CN113313438A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders

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)

Abstract

The invention discloses a method and a device for generating an outbound form, and relates to the technical field of computers. One embodiment of the method comprises: receiving an article ex-warehouse request, wherein the article ex-warehouse request comprises at least two ex-warehouse lists, and the ex-warehouse lists at least comprise article names and request ex-warehouse quantity; the names of the articles contained in the at least two ex-warehouse particulars are the same, and the attributes of the articles are different; respectively calculating the inventory and the actual delivery amount corresponding to each delivery detail based on the acquired total inventory amount, the available quantity and the requested delivery amount of each delivery detail; and collecting each ex-warehouse list, the inventory and the actual ex-warehouse quantity corresponding to the ex-warehouse list, and generating an ex-warehouse form. The method and the device can solve the problem that in the prior art, the requested shipment volume, the actual shipment volume and the available quantity in each row of the shipment object data in the shipment form are inconsistent because no connection is established.

Description

Method and device for generating ex-warehouse form
Technical Field
The invention relates to the technical field of computers, in particular to a method and a device for generating a outbound form.
Background
The method comprises the steps that the e-commerce business relates to goods picking or goods returning business, a supplier submits a request form for picking a certain number of goods to a warehouse according to specific requirements of the business, and a warehouse information system collects the distributable number of the goods in the warehouse and returns the number of the goods to the supplier according to a goods delivery request provided by the supplier so as to carry out next actual goods picking operation.
In the process of implementing the invention, the inventor finds that at least the following problems exist in the prior art:
when the form of the warehouse-out request of goods contains a plurality of rows of data of the goods, the existing technical means adopts simple line-by-line distribution of the stock quantity of the goods in the warehouse from top to bottom, and the warehouse-out form with inconsistent data is formed without establishing a relation with the shipment quantity in each line of data and the actual shipment quantity.
Disclosure of Invention
In view of this, embodiments of the present invention provide a method and an apparatus for generating an ex-warehouse form, which can receive an article ex-warehouse request, where the article ex-warehouse request includes at least two ex-warehouse details, and the ex-warehouse details at least include an article name and a requested ex-warehouse quantity; the article names contained in the at least two ex-warehouse particulars are the same, and the attributes of the articles in the ex-warehouse particulars are different; acquiring the total inventory amount and the available quantity of the articles according to the article names; respectively calculating the inventory and the actual delivery amount corresponding to each delivery detail based on the total inventory, the available quantity and the requested delivery amount of each delivery detail; and collecting each ex-warehouse list, the inventory and the actual ex-warehouse quantity corresponding to the ex-warehouse list, and generating an ex-warehouse form. The problem that in the prior art, the data are in contradiction due to the fact that the requested shipment volume, the actual shipment volume and the available quantity in each row of the shipment object data in the shipment form are not connected is solved.
To achieve the above object, according to an aspect of an embodiment of the present invention, there is provided a method for generating a outbound form, including: receiving an article ex-warehouse request, wherein the article ex-warehouse request comprises at least two ex-warehouse lists, and the ex-warehouse lists at least comprise article names and request ex-warehouse quantity; the article names contained in the at least two ex-warehouse particulars are the same, and the attributes of the articles in the ex-warehouse particulars are different; acquiring the total inventory amount and the available quantity of the articles according to the article names; respectively calculating the inventory and the actual delivery amount corresponding to each delivery detail based on the total inventory, the available quantity and the requested delivery amount of each delivery detail; and collecting each ex-warehouse list, the inventory and the actual ex-warehouse quantity corresponding to the ex-warehouse list, and generating an ex-warehouse form.
Optionally, the method of generating a outbound form is characterized in that,
when the available quantity of the item is less than the inventory quantity, the available quantity is indicated as a difference between the inventory quantity and a quantity of an unavailable item.
Optionally, the method of generating a outbound form is characterized in that,
respectively calculating the inventory and the actual delivery amount corresponding to each delivery statement based on the total inventory, the available quantity and the requested delivery amount of each delivery statement, including:
setting the same initial value for the inventory corresponding to each ex-warehouse detail; calculating the difference between the total inventory of the articles and the sum of the initial inventory values in all the ex-warehouse particulars to obtain the total intermediate inventory;
setting the same initial value for the actual ex-warehouse quantity corresponding to each ex-warehouse detail; calculating the difference between the available quantity of the articles and the sum of the initial values of the actual ex-warehouse quantity in all the ex-warehouse particulars to obtain the intermediate actual ex-warehouse quantity;
the initial value of the actual warehouse-out quantity is not more than the initial value of the stock quantity.
Optionally, the method of generating a outbound form is characterized in that,
respectively calculating the inventory and the actual delivery amount corresponding to each delivery statement based on the total inventory, the available quantity and the requested delivery amount of each delivery statement, including:
based on the intermediate actual ex-warehouse quantity of the article, sequentially aiming at the request ex-warehouse quantity and the actual ex-warehouse quantity initial value of each ex-warehouse detail, calculating the actual ex-warehouse quantity corresponding to each ex-warehouse detail;
and calculating the inventory amount corresponding to each warehouse-out detail sequentially according to the requested warehouse-out amount and the initial inventory amount value of each warehouse-out detail based on the intermediate inventory amount of the articles.
Optionally, the method of generating a outbound form is characterized in that,
calculating the actual ex-warehouse quantity corresponding to each ex-warehouse detail sequentially aiming at the request ex-warehouse quantity and the actual ex-warehouse quantity initial value of each ex-warehouse detail based on the intermediate actual ex-warehouse quantity of the article, and the method comprises the following steps:
calculating the difference value between the requested ex-warehouse quantity and the corresponding actual ex-warehouse quantity initial value aiming at each ex-warehouse detail in sequence;
when the difference is smaller than or equal to the intermediate actual ex-warehouse quantity, taking the requested ex-warehouse quantity as the actual ex-warehouse quantity, and correspondingly reducing the intermediate actual ex-warehouse quantity by the difference;
when the difference is larger than the intermediate actual ex-warehouse quantity, calculating the sum of the initial value of the actual ex-warehouse quantity and the intermediate actual ex-warehouse quantity as the actual ex-warehouse quantity;
and when the intermediate actual ex-warehouse quantity is zero, taking the initial value of the actual ex-warehouse quantity as the actual ex-warehouse quantity.
Optionally, the method of generating a outbound form is characterized in that,
calculating the inventory amount corresponding to each warehouse-out detail sequentially for the requested warehouse-out amount and the initial inventory amount value of each warehouse-out detail based on the intermediate inventory amount of the article, including:
calculating the difference value between the requested warehouse-out quantity and the initial value of the stock quantity in sequence aiming at each warehouse-out detail;
when the difference is smaller than or equal to the intermediate inventory amount, taking the requested inventory amount as the inventory amount, and correspondingly reducing the intermediate inventory amount by the difference;
when the difference is larger than the intermediate inventory amount, calculating the sum of the initial inventory amount and the intermediate inventory amount as the inventory amount;
and when the intermediate inventory amount is zero, taking the initial inventory value as the inventory.
To achieve the above object, according to a second aspect of the embodiments of the present invention, there is provided an apparatus for generating a outbound form, including: the system comprises an inventory information acquisition module, a warehouse-out information calculation module and a warehouse-out form generation module; the inventory information acquiring module is used for receiving an article ex-warehouse request, wherein the article ex-warehouse request comprises at least two ex-warehouse particulars, and the ex-warehouse particulars at least comprise an article name and a request ex-warehouse quantity; the article names contained in the at least two ex-warehouse particulars are the same, and the attributes of the articles in the ex-warehouse particulars are different; the warehouse-out calculation information module is used for acquiring the total inventory amount and the available quantity of the articles according to the article names; respectively calculating the inventory and the actual delivery amount corresponding to each delivery detail based on the total inventory, the available quantity and the requested delivery amount of each delivery detail; and the outbound form generation module is used for collecting each outbound detail, the stock amount and the actual outbound amount corresponding to the outbound detail and generating an outbound form.
Optionally, the apparatus for generating a outbound form is characterized in that,
when the available quantity of the item is less than the inventory quantity, the available quantity is indicated as a difference between the inventory quantity and a quantity of an unavailable item.
Optionally, the apparatus for generating a outbound form is characterized in that,
respectively calculating the inventory and the actual delivery amount corresponding to each delivery statement based on the total inventory, the available quantity and the requested delivery amount of each delivery statement, including:
setting the same initial value for the inventory corresponding to each ex-warehouse detail; calculating the difference between the total inventory of the articles and the sum of the initial inventory values in all the ex-warehouse particulars to obtain the total intermediate inventory;
setting the same initial value for the actual ex-warehouse quantity corresponding to each ex-warehouse detail; calculating the difference between the available quantity of the articles and the sum of the initial values of the actual ex-warehouse quantity in all the ex-warehouse particulars to obtain the intermediate actual ex-warehouse quantity;
the initial value of the actual warehouse-out quantity is not more than the initial value of the stock quantity.
Optionally, the apparatus for generating a outbound form is characterized in that,
respectively calculating the inventory and the actual delivery amount corresponding to each delivery statement based on the total inventory, the available quantity and the requested delivery amount of each delivery statement, including:
based on the intermediate actual ex-warehouse quantity of the article, sequentially aiming at the request ex-warehouse quantity and the actual ex-warehouse quantity initial value of each ex-warehouse detail, calculating the actual ex-warehouse quantity corresponding to each ex-warehouse detail;
and calculating the inventory amount corresponding to each warehouse-out detail sequentially according to the requested warehouse-out amount and the initial inventory amount value of each warehouse-out detail based on the intermediate inventory amount of the articles.
Optionally, the apparatus for generating a outbound form is characterized in that,
calculating the actual ex-warehouse quantity corresponding to each ex-warehouse detail sequentially aiming at the request ex-warehouse quantity and the actual ex-warehouse quantity initial value of each ex-warehouse detail based on the intermediate actual ex-warehouse quantity of the article, and the method comprises the following steps:
calculating the difference value between the requested ex-warehouse quantity and the corresponding actual ex-warehouse quantity initial value aiming at each ex-warehouse detail in sequence;
when the difference is smaller than or equal to the intermediate actual ex-warehouse quantity, taking the requested ex-warehouse quantity as the actual ex-warehouse quantity, and correspondingly reducing the intermediate actual ex-warehouse quantity by the difference;
when the difference is larger than the intermediate actual ex-warehouse quantity, calculating the sum of the initial value of the actual ex-warehouse quantity and the intermediate actual ex-warehouse quantity as the actual ex-warehouse quantity;
and when the intermediate actual ex-warehouse quantity is zero, taking the initial value of the actual ex-warehouse quantity as the actual ex-warehouse quantity.
Optionally, the apparatus for generating a outbound form is characterized in that,
calculating the inventory amount corresponding to each warehouse-out detail sequentially for the requested warehouse-out amount and the initial inventory amount value of each warehouse-out detail based on the intermediate inventory amount of the article, including:
calculating the difference value between the requested warehouse-out quantity and the initial value of the stock quantity in sequence aiming at each warehouse-out detail;
when the difference is smaller than or equal to the intermediate inventory amount, taking the requested inventory amount as the inventory amount, and correspondingly reducing the intermediate inventory amount by the difference;
when the difference is larger than the intermediate inventory amount, calculating the sum of the initial inventory amount and the intermediate inventory amount as the inventory amount;
and when the intermediate inventory amount is zero, taking the initial inventory value as the inventory.
To achieve the above object, according to a third aspect of the embodiments of the present invention, there is provided an electronic device for generating a outbound form, including: one or more processors; a storage device for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to implement a method as in any one of the methods of generating a outbound form described above.
To achieve the above object, according to a fourth aspect of the embodiments of the present invention, there is provided a computer-readable medium having a computer program stored thereon, wherein the program, when executed by a processor, implements any of the methods of generating a outbound form as described above.
One embodiment of the above invention has the following advantages or benefits: receiving an article ex-warehouse request, wherein the article ex-warehouse request comprises at least two ex-warehouse lists, and the ex-warehouse lists at least comprise article names and request ex-warehouse quantity; the article names contained in the at least two ex-warehouse particulars are the same, and the attributes of the articles in the ex-warehouse particulars are different; acquiring the total inventory amount and the available quantity of the articles according to the article names; respectively calculating the inventory and the actual delivery amount corresponding to each delivery detail based on the total inventory, the available quantity and the requested delivery amount of each delivery detail; and collecting each ex-warehouse list, the inventory and the actual ex-warehouse quantity corresponding to the ex-warehouse list, and generating an ex-warehouse form. Therefore, the embodiment of the invention overcomes the problem that the data are inconsistent because the contact is not established in the requested shipment quantity, the actual shipment quantity and the available shipment quantity in each row of the shipment object data in the shipment form in the prior art.
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 flow chart illustrating a method for generating outbound forms according to an embodiment of the present invention;
FIG. 2 is a flow chart illustrating a process of calculating an actual ex-warehouse quantity in a form according to an embodiment of the present invention;
FIG. 3 is a flow chart illustrating a calculation of the inventory in the form according to an embodiment of the present invention;
FIG. 4 is a block diagram of a system for generating outbound forms according to an embodiment of the present invention;
FIG. 5 is an exemplary system architecture diagram in which embodiments of the present invention may be employed;
fig. 6 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.
In the prior art, when a warehouse-out request of goods forms multi-line data about one goods in a form due to different attributes of the goods, the distributable amount in a warehouse is simply distributed line by line from top to bottom by the prior art means, and the stock quantity distributed for each line of data and the actual warehouse-out quantity are not linked, so that a warehouse-out form with front and back data contradictions is formed, taking table 1 as an example, the calculation method has the situation that the actual warehouse-out quantity of the first line of data is larger than the data contradiction of the requested warehouse-out quantity; in another case, taking table 2 as an example, the data contradiction that the inventory amount is smaller than the actual ex-warehouse amount is caused by performing the line-by-line average distribution on the inventory amount.
Name of commodity Commodity attributes Request for delivery volume Actual delivery volume Stock quantity
Commodity ABC 2019 run 1 10 30 36
Commodity ABC 2019 run 2 15
Commodity ABC 2020 batch 1 20
Commodity ABC 2020 batch 2 10
TABLE 1
Name of commodity Commodity attributes Request for delivery volume Actual delivery volume Stock quantity
Commodity ABC 2019 run 1 10 30 9
Commodity ABC 2019 run 2 15 9
Commodity ABC 2020 batch 1 20 9
Commodity ABC 2020 batch 2 10 9
TABLE 2
In order to overcome the defects in the prior art, an embodiment of the present invention provides a method for generating a outbound form, which may include the following steps, as shown in fig. 1:
step S101: receiving an article ex-warehouse request, wherein the article ex-warehouse request comprises at least two ex-warehouse lists, and the ex-warehouse lists at least comprise article names and request ex-warehouse quantity; the article names contained in the at least two ex-warehouse particulars are the same, and the attributes of the articles in the respective ex-warehouse particulars are different.
Specifically, the above steps are explained by taking the following table 3 as an example, as shown in table 3, where "commodity ABC" is an example of the name of the article, and "2019 batch 1" is an example of the attribute of the article. It will be appreciated that, for a product, due to different packages, different batches due to production time, or different attributes due to other reasons, the same product name in the form of the outbound request will be presented in the form of multiple rows of data due to the different attributes. That is, the item names of the rows are the same, but the attributes are different, and the requested delivery amounts of the items in the rows based on the different attributes may be different, as shown in table 3, where each row of data is one delivery list, and table 3 includes 4 delivery lists. Receiving an article ex-warehouse request, wherein the article ex-warehouse request comprises at least two ex-warehouse lists, and the ex-warehouse lists at least comprise article names and request ex-warehouse quantity; the article names contained in the at least two ex-warehouse particulars are the same, and the attributes of the articles in the ex-warehouse particulars are different;
Figure BDA0002392780880000081
Figure BDA0002392780880000091
TABLE 3
Further, according to the item name, acquiring the inventory amount and the available quantity of the item.
Specifically, the total inventory amount and the available quantity of the item in the warehouse are obtained according to the item name in the warehouse-out request, and the step can be completed through an information system of the warehouse; it will be appreciated that the attributes of the goods are ignored in obtaining the inventory amount and the available quantity of the items based on the item names.
Further, the total inventory amount of the item is less than or equal to the sum of the requested ex-warehouse amounts in the ex-warehouse details, for example, taking the data in table 3 as an example, the sum of the requested ex-warehouse amounts of the ex-warehouse details is 55; the available quantity of the item is the total inventory in the warehouse minus the quantity of the unavailable item, which is the condition of damage, incompleteness, etc. caused by transportation, warehousing or other reasons, in which case the item is considered to be unavailable.
That is, when the available quantity of the item is less than the inventory quantity, the available quantity is indicated as a difference between the inventory quantity and a quantity of an unavailable item.
Step S102: and respectively calculating the inventory amount and the actual delivery amount corresponding to each delivery detail based on the total inventory amount, the available amount and the requested delivery amount of each delivery detail.
Specifically, as in the example shown in table 3, it is necessary to calculate the stock quantity and the actual shipment quantity for each row of data, i.e., each of the shipment details, i.e., the stock quantity and the actual shipment quantity corresponding to each of the shipment details are calculated based on the total stock quantity, the available quantity, and the requested shipment quantity of each of the shipment details, respectively. The calculation mode is that the requested ex-warehouse quantity is sequentially met from top to bottom, and it can be understood that the total inventory quantity of the articles is less than or equal to the sum of the requested ex-warehouse quantities in each ex-warehouse detail, and the available quantity of the articles is less than the total inventory quantity; therefore, corresponding to each row, namely each warehouse-out detail, the numerical value of the stock quantity is measured based on the total stock quantity, and the actual warehouse-out quantity is calculated based on the available quantity;
further, a schematic flow of calculating the actual ex-warehouse quantity based on each ex-warehouse detail is shown in fig. 2;
further, a schematic flow of calculating the inventory amount based on each warehouse-out specification is shown in fig. 3;
step S103: and collecting each ex-warehouse list, the inventory and the actual ex-warehouse quantity corresponding to the ex-warehouse list, and generating an ex-warehouse form.
Specifically, based on the actual ex-warehouse quantity and inventory quantity of each ex-warehouse detail calculated in step S102, that is, the data of the actual ex-warehouse quantity and inventory quantity of each row, assuming that the total inventory quantity is 40 and the number of damaged articles is 4, the available quantity is 36, the calculation step of step S102 yields the example shown in table 4, from the example of table 4, one example method of calculation is to first set an initial value for each ex-warehouse detail, in this example, the initial value is set to 1, further, the actual ex-warehouse quantity and inventory quantity are calculated from the first ex-warehouse detail, and through calculation in sequence, it can be seen that the sum of the actual ex-warehouse quantities of all the ex-warehouse details is the available quantity; the sum of the inventory amounts of all the ex-warehouse particulars is the total inventory amount;
as can be seen from the examples shown in table 4, with the method of the present embodiment, the problem of data contradiction among the requested warehouse-out amount, the actual warehouse-out amount, and the inventory amount is overcome, and the rationality that the requested warehouse-out amount is greater than or equal to the inventory amount and the inventory amount is greater than or equal to the actual warehouse-out amount in each warehouse-out detail is achieved.
Name of article Property of an article Request for delivery volume Actual delivery volume Stock quantity
Commodity ABC 2019 run 1 10 10 10
Commodity ABC 2019 run 2 15 15 15
Commodity ABC 2020 batch 1 20 10 14
Commodity ABC 2020 batch 2 10 1 1
TABLE 4
Furthermore, each ex-warehouse statement, the inventory amount corresponding to the ex-warehouse statement and the actual ex-warehouse quantity are collected, and an ex-warehouse form is generated.
Specifically, the example of the ex-warehouse form is shown in table 4, and it can be understood that the content and form of table 4 are examples, an actual scene contains more information and content related to an item, and the present invention does not limit the specific information and content of each set except for an item name and a requested ex-warehouse quantity; the embodiment form of the outbound form is not limited.
As shown in fig. 2, an embodiment of the present invention provides a method for calculating an actual ex-warehouse quantity in a form, where the method may include the following steps:
step S201: and assigning the same initial value to the actual warehouse-out amount in each warehouse-out specification.
Specifically, calculating the inventory amount and the actual ex-warehouse amount corresponding to each ex-warehouse detail respectively based on the total inventory amount, the available amount and the requested ex-warehouse amount of each ex-warehouse detail includes: setting the same initial value for the actual ex-warehouse quantity corresponding to each ex-warehouse detail;
further, the initial value of the actual warehouse-out quantity is smaller than or equal to the initial value of the stock quantity. It is understood that the actual shipment amount is equal to or less than the stock amount, and therefore the initial value of the actual shipment amount may be set equal to or less than the initial value of the stock amount;
specifically, taking table 5 as an example, a description will be given of a flow in which the same initial value is set for the actual ex-warehouse quantity corresponding to each ex-warehouse detail, and as shown in table 5, the initial value set for the actual ex-warehouse quantity corresponding to each ex-warehouse detail is 1, and preferably, the initial value is set to the minimum value of 1, so that the actual ex-warehouse quantity corresponding to each ex-warehouse detail may be a number other than 0.
Name of article Property of an article Request for delivery volume Actual delivery volume Stock quantity
Commodity ABC 2019 run 1 10 1
Commodity ABC 2019 run 2 15 1
Commodity ABC 2020 batch 1 20 1
Commodity ABC 2020 batch 2 10 1
TABLE 5
Step S202: and calculating the sum of the initial values of the actual ex-warehouse quantities of all the ex-warehouse particulars.
Step S203: and acquiring the available quantity of the articles in the warehouse.
Step S204: and obtaining the intermediate value of the actual ex-warehouse quantity.
Step S202-step S204 describe the step of calculating the intermediate value of the actual delivery quantity by using the sum of the available quantity of the items in the warehouse and the initial value of the actual delivery quantity of all the delivery details.
That is, the same initial value is set for the actual delivery amount corresponding to each delivery detail; calculating the difference between the available quantity of the articles and the sum of the initial values of the actual ex-warehouse quantity in all the ex-warehouse particulars to obtain the intermediate actual ex-warehouse quantity;
specifically, still taking the data in table 5 as an example, the sum of the initial values of the actual warehouse-out amounts of all the warehouse-out details is calculated to be 4, assuming that the available amount of the items in the warehouse is obtained to be 36, the sum of the initial values of the actual warehouse-out amounts subtracted from the available amount of the items is obtained to obtain a value 32, and 32 is an intermediate value for obtaining the actual warehouse-out amounts, that is, an intermediate actual warehouse-out amount. It will be appreciated that the actual shipment value in each shipment detail is calculated using this intermediate actual shipment.
That is, the method of calculating the inventory amount and the actual ex-warehouse amount corresponding to each ex-warehouse schedule based on the total inventory amount, the available amount, and the requested ex-warehouse amount for each ex-warehouse schedule, further comprises: and calculating the actual delivery amount corresponding to each delivery detail sequentially according to the request delivery amount and the actual delivery amount initial value of each delivery detail based on the intermediate actual delivery amount of the article.
Step S205: calculating a difference value between the requested warehouse-out quantity of a warehouse-out detail and an initial value, and comparing the size of the difference value with the intermediate value of the actual warehouse-out quantity.
Calculating the difference value between the requested ex-warehouse quantity and the corresponding actual ex-warehouse quantity initial value aiming at each ex-warehouse detail in sequence;
specifically, still taking the first ex-warehouse statement in table 5 as an example, the difference between the requested ex-warehouse quantity of the first ex-warehouse statement and the corresponding actual ex-warehouse quantity initial value is 9; further, comparing the difference value with the intermediate value of the actual ex-warehouse quantity, and performing the following operations according to the comparison result:
when the actual ex-warehouse quantity intermediate value is large, executing step S206 and step S209;
when the actual warehouse-out quantity intermediate value is small, executing step S207;
when the actual warehouse-out quantity intermediate value is 0, executing step S208;
step S206: the actual ex-warehouse quantity is the requested ex-warehouse quantity.
Step S207: the actual ex-warehouse quantity is the added initial value of the requested ex-warehouse quantity.
Step S208: the actual ex-warehouse quantity is an initial value.
Step S209: and subtracting the request warehouse-out quantity and the initial value from the actual warehouse-out quantity to obtain a value.
The flow from step S205 to step S209 is described below by taking table 6 as an example,
1) the difference value between the requested warehouse-out quantity of the first warehouse-out detail and the corresponding actual warehouse-out quantity initial value is 9;
2) assuming that the available quantity of the articles in the warehouse is 36, the sum of the available quantity of the articles and the initial value of the actual delivery quantity is 32, 32 is the intermediate value of the obtained actual delivery quantity, namely the intermediate actual delivery quantity, and the difference value is compared with the intermediate value of the actual delivery quantity, namely the comparison between 9 and 32 is carried out;
3) when the difference is smaller than or equal to the intermediate actual ex-warehouse quantity, taking the requested ex-warehouse quantity as the actual ex-warehouse quantity, and correspondingly reducing the intermediate actual ex-warehouse quantity by the difference; that is, the requested ex-warehouse amount of the first ex-warehouse entry may be satisfied, so the actual ex-warehouse amount of the first ex-warehouse entry is 10, which is equal to the requested ex-warehouse amount, and further, the intermediate actual ex-warehouse amount is reduced by the number of the difference, and the value of the intermediate actual ex-warehouse amount is 32-9-23;
4) the actual ex-warehouse quantity corresponding to the second ex-warehouse detail is the same as the steps 1) -3), and is not described again; the value of the intermediate actual warehouse-out quantity is 23-14-9;
5) comparing the difference value with the middle actual warehouse-out quantity by the third warehouse-out detail, wherein 19 is greater than 9, 19 is the difference value, and 9 is the middle actual warehouse-out quantity; that is, when the difference is larger than the intermediate actual ex-warehouse quantity, calculating the sum of the initial value of the actual ex-warehouse quantity and the intermediate actual ex-warehouse quantity as the actual ex-warehouse quantity; obtaining the actual warehouse-out quantity of 10; meanwhile, the intermediate actual ex-warehouse quantity becomes 0;
it is to be understood that, starting from the first ex-warehouse statement, calculation is performed line by line based on the condition that the request ex-warehouse quantity is satisfied, until the intermediate actual ex-warehouse quantity becomes 0;
6) and regarding the fourth ex-warehouse detail, when the intermediate actual ex-warehouse quantity is zero, taking the initial value of the actual ex-warehouse quantity as the actual ex-warehouse quantity.
Using steps 1) -6), the results of calculating the actual shipment volume for each shipment detail in table 6 are shown in table 6.
Name of article Property of an article Request for delivery volume Actual delivery volume Stock quantity
Commodity ABC 2019 run 1 10 10(1+9)
Commodity ABC 2019 run 2 15 15(1+14)
Commodity ABC 2020 batch 1 20 10(1+9)
Commodity ABC 2020 batch 2 10 1
TABLE 6
Calculating the difference value between the requested ex-warehouse quantity and the corresponding actual ex-warehouse quantity initial value for each ex-warehouse detail in sequence;
when the difference is smaller than or equal to the intermediate actual ex-warehouse quantity, taking the requested ex-warehouse quantity as the actual ex-warehouse quantity, and correspondingly reducing the intermediate actual ex-warehouse quantity by the difference;
when the difference is larger than the intermediate actual ex-warehouse quantity, calculating the sum of the initial value of the actual ex-warehouse quantity and the intermediate actual ex-warehouse quantity as the actual ex-warehouse quantity;
and when the intermediate actual ex-warehouse quantity is zero, taking the initial value of the actual ex-warehouse quantity as the actual ex-warehouse quantity.
As shown in FIG. 3, an embodiment of the present invention provides a method for calculating the inventory amount in a form, which may include the following steps:
step S301: the same initial value is assigned to the stock in each shipment detail.
Specifically, calculating the inventory amount and the actual ex-warehouse amount corresponding to each ex-warehouse detail respectively based on the total inventory amount, the available amount and the requested ex-warehouse amount of each ex-warehouse detail includes: setting the same initial value for the inventory corresponding to each ex-warehouse detail;
further, the initial value of the actual warehouse-out quantity is smaller than the initial value of the stock quantity.
Specifically, taking table 7 as an example, a description will be given of a flow in which the same initial value is set for the stock quantity corresponding to each shipment detail, and as shown in table 7, the initial value set for the stock quantity corresponding to each shipment detail is 1, and preferably, the initial value is set to the minimum value of 1 so that the stock quantity corresponding to each shipment detail may be a number other than 0. The initial value of the stock quantity can also be set to other values which are larger than the initial value of the actual stock quantity, for example, the initial value of the actual stock quantity is set to be 2.
Assuming that the available ex-warehouse quantity in the warehouse is 36, the total inventory quantity is 40; and the actual ex-warehouse volume of each ex-warehouse statement has been calculated, as shown in table 7.
Name of article Property of an article Request for delivery volume Actual delivery volume Stock quantity
Commodity ABC 2019 run 1 10 10 1
Commodity ABC 2019 run 2 15 15 1
Commodity ABC 2020 batch 1 20 10 1
Commodity ABC 2020 batch 2 10 1 1
TABLE 7
Step S302: and calculating the sum of the initial values of all the ex-warehouse detail inventory quantities.
Step S303: the total inventory of the items in the warehouse is obtained.
Step S304: an intermediate value of the inventory amount is obtained.
Step S302-step S304 describe the step of calculating the intermediate value of the obtained stock quantity using the sum of the total stock quantity of the items in the warehouse and the initial value of the stock quantity of all the out-stock details.
Calculating the difference between the total inventory of the articles and the sum of the initial inventory values in all the ex-warehouse particulars to obtain the intermediate total inventory;
specifically, still taking the data in table 7 as an example, the sum of the initial values of all the inventory details is calculated to be 4, and it is known that the total inventory amount of the items in the warehouse is obtained to be 40, the sum of the total inventory amount of the items minus the initial values of the inventory amounts is 36, and 36 is an intermediate value of the obtained inventory amount, i.e., an intermediate inventory amount. It will be appreciated that this intermediate inventory amount is used to further calculate the amount of inventory in each of the outbound inventory items.
That is, the method of calculating the inventory amount and the actual ex-warehouse amount corresponding to each ex-warehouse schedule based on the total inventory amount, the available amount, and the requested ex-warehouse amount for each ex-warehouse schedule, further comprises: on the basis of the total inventory amount of the articles, sequentially aiming at the requested inventory amount and the initial inventory amount value of each inventory item, calculating the inventory amount corresponding to each inventory item;
step S305: calculating a difference value between the requested warehouse-out quantity of a warehouse-out detail and an initial value of the stock quantity, and comparing the difference value with the intermediate value of the stock quantity.
Calculating the difference value between the requested warehouse-out quantity and the corresponding initial value of the stock quantity in sequence aiming at each warehouse-out detail;
specifically, still taking the first ex-warehouse statement in table 7 as an example, the difference between the requested ex-warehouse quantity of the first ex-warehouse statement and the corresponding initial inventory quantity value is 9; further, comparing the difference value with the intermediate value of the stock quantity, and performing the following operations according to the comparison result:
when the stock quantity intermediate value is large, step S306 and step S309 are executed;
when the stock quantity intermediate value is small, step S307 is executed;
when the intermediate inventory value is 0, executing step S308;
step S306: the inventory is the quantity of the requested warehouse-out.
Step S307: the inventory is the added initial value of the quantity of the requested stock.
Step S308: the stock is the initial value.
Step S309: the inventory amount is subtracted by the difference obtained after the request inventory amount and the initial value are obtained.
The flow from step S305 to step S309 will be described below by taking table 8 as an example,
1) the difference value between the requested warehouse-out amount of the first warehouse-out detail and the corresponding initial value of the stock quantity is 9;
2) assuming that the available quantity of the items in the warehouse is obtained to be 40, the sum of the total stock quantity of the items and the initial value of the stock quantity is 36, 36 is the intermediate stock quantity of the obtained stock quantity, and the difference value is compared with the intermediate stock quantity of the stock quantity, namely the comparison between 9 and 36 is carried out;
3) when the difference is smaller than or equal to the intermediate inventory amount, taking the requested inventory amount as the inventory amount, and correspondingly reducing the intermediate inventory amount by the difference; that is, the requested ex-warehouse quantity of the first ex-warehouse list can be satisfied, so that the stock quantity of the first ex-warehouse list is 10, which is equal to the requested ex-warehouse quantity, and further, the intermediate stock quantity is reduced by the difference, and the value of the intermediate stock quantity is 36-9 to 27;
4) the inventory corresponding to the second warehouse-out specification is the same as the steps 1) -3), and is not described again; the total intermediate inventory value is 27-14-13;
5) for the third inventory detail, comparing the difference with the size of the intermediate inventory quantity of the inventory quantity, wherein 19>13, namely, when the difference is larger than the intermediate inventory quantity, calculating the sum of the initial value of the inventory quantity and the intermediate inventory quantity as the inventory quantity; the obtained stock is 14; while the stock amount becomes 0;
it is to be understood that, starting from the first ex-warehouse statement, calculation is performed line by line based on the satisfaction of the request ex-warehouse quantity until the intermediate inventory total quantity becomes 0;
6) and regarding the fourth inventory details, when the total intermediate inventory amount is zero, taking the initial value of the inventory as the inventory amount.
Using the steps 1) -6), the results of calculating the stock amount of each of the shipment details in table 8 are shown in table 8.
Name of article Property of an article Request for delivery volume Actual delivery volume Stock quantity
Commodity ABC 2019 run 1 10 10 10(1+9)
Commodity ABC 2019 run 2 15 15 15(1+14)
Commodity ABC 2020 batch 1 20 10 14(1+13)
Commodity ABC 2020 batch 2 10 1 1
TABLE 8
Calculating the difference value between the requested warehouse-out amount and the corresponding initial inventory value for each warehouse-out detail in sequence;
when the difference is smaller than or equal to the intermediate inventory amount, taking the requested inventory amount as the inventory amount, and correspondingly reducing the intermediate inventory amount by the difference;
when the difference is larger than the intermediate inventory amount, calculating the sum of the initial value of the inventory amount and the intermediate inventory amount as the inventory amount;
and when the intermediate inventory amount is zero, taking the initial inventory value as the inventory.
As shown in fig. 4, an apparatus 400 for generating a outbound form according to an embodiment of the present invention includes: the system comprises an inventory information acquisition module 401, a warehouse-out information calculation module 402 and a warehouse-out form generation module 403; wherein,
the stock information obtaining module 401 is configured to receive an article ex-warehouse request, where the article ex-warehouse request includes at least two ex-warehouse details, and the ex-warehouse details at least include an article name and a requested ex-warehouse quantity; the article names contained in the at least two ex-warehouse particulars are the same, and the attributes of the articles in the ex-warehouse particulars are different;
the out-of-stock information calculating module 402 is configured to obtain the total inventory amount and the available quantity of the item according to the item name; respectively calculating the inventory and the actual delivery amount corresponding to each delivery detail based on the total inventory, the available quantity and the requested delivery amount of each delivery detail;
the out-of-stock form generating module 403 is configured to collect each out-of-stock detail, and the inventory amount and the actual out-of-stock amount corresponding to the out-of-stock detail, and generate an out-of-stock form.
Optionally, the module 401 for obtaining inventory information includes when the available quantity of the item is smaller than the total inventory quantity, the available quantity is indicated as a difference between the total inventory quantity and a quantity of an unavailable item.
Optionally, the step 402 of calculating the warehouse-out information is configured to calculate an inventory amount and an actual warehouse-out amount corresponding to each warehouse-out detail based on the total inventory amount, the available amount, and the requested warehouse-out amount of each warehouse-out detail, respectively, and includes:
setting the same initial value for the inventory corresponding to each ex-warehouse detail; calculating the difference between the total inventory of the articles and the sum of the initial inventory values in all the ex-warehouse particulars to obtain the total intermediate inventory;
setting the same initial value for the actual ex-warehouse quantity corresponding to each ex-warehouse detail; calculating the difference between the available quantity of the articles and the sum of the initial values of the actual ex-warehouse quantity in all the ex-warehouse particulars to obtain the intermediate actual ex-warehouse quantity;
the initial value of the actual warehouse-out quantity is not more than the initial value of the stock quantity.
Optionally, the step 402 of calculating the warehouse-out information is configured to calculate an inventory amount and an actual warehouse-out amount corresponding to each warehouse-out detail based on the total inventory amount, the available amount, and the requested warehouse-out amount of each warehouse-out detail, respectively, and includes:
based on the intermediate actual ex-warehouse quantity of the article, sequentially aiming at the request ex-warehouse quantity and the actual ex-warehouse quantity initial value of each ex-warehouse detail, calculating the actual ex-warehouse quantity corresponding to each ex-warehouse detail;
and calculating the inventory amount corresponding to each warehouse-out detail sequentially according to the requested warehouse-out amount and the initial inventory amount value of each warehouse-out detail based on the intermediate inventory amount of the articles.
Optionally, the step of calculating the ex-warehouse information 402 is configured to calculate, based on the intermediate actual ex-warehouse quantity of the article, the actual ex-warehouse quantity corresponding to each ex-warehouse detail with respect to the requested ex-warehouse quantity and the actual ex-warehouse quantity initial value of each ex-warehouse detail in sequence, and includes:
calculating the difference value between the requested ex-warehouse quantity and the corresponding actual ex-warehouse quantity initial value aiming at each ex-warehouse detail in sequence;
when the difference is smaller than or equal to the intermediate actual ex-warehouse quantity, taking the requested ex-warehouse quantity as the actual ex-warehouse quantity, and correspondingly reducing the intermediate actual ex-warehouse quantity by the difference;
when the difference is larger than the intermediate actual ex-warehouse quantity, calculating the sum of the initial value of the actual ex-warehouse quantity and the intermediate actual ex-warehouse quantity as the actual ex-warehouse quantity;
and when the intermediate actual ex-warehouse quantity is zero, taking the initial value of the actual ex-warehouse quantity as the actual ex-warehouse quantity.
Optionally, the step 402 of calculating the inventory information based on the intermediate inventory amount of the item, which is configured to calculate the inventory amount corresponding to each inventory item in turn for the requested inventory amount and the initial value of the inventory amount of each inventory item, includes:
calculating the difference value between the requested warehouse-out quantity and the initial value of the stock quantity in sequence aiming at each warehouse-out detail;
when the difference is smaller than or equal to the intermediate inventory amount, taking the requested inventory amount as the inventory amount, and correspondingly reducing the intermediate inventory amount by the difference;
when the difference is larger than the intermediate inventory amount, calculating the sum of the initial inventory amount and the intermediate inventory amount as the inventory amount;
and when the intermediate inventory amount is zero, taking the initial inventory value as the inventory.
An embodiment of the present invention further provides an electronic device for generating a outbound form, including: one or more processors; the storage device is used for storing one or more programs, and when the one or more programs are executed by the one or more processors, the one or more processors are enabled to realize the method provided by any one of the above embodiments.
Embodiments of the present invention further provide a computer-readable medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the method provided in any of the above embodiments.
Fig. 5 illustrates an exemplary system architecture 500 of a method of generating a outbound form or an apparatus for generating an outbound form to which embodiments of the present invention may be applied.
As shown in fig. 5, the system architecture 500 may include terminal devices 501, 502, 503, a network 504, and a server 505. The network 504 serves to provide a medium for communication links between the terminal devices 501, 502, 503 and the server 505. Network 504 may include various connection types, such as wired, wireless communication links, or fiber optic cables, to name a few.
The user may use the terminal devices 501, 502, 503 to interact with a server 505 over a network 504 to receive or send messages or the like. The terminal devices 501, 502, 503 may have various client applications installed thereon, such as a web browser application, a search-class application, an instant messaging tool, a client of an enterprise management system, a mailbox client, and the like.
The terminal devices 501, 502, 503 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, and the like.
The server 505 may be a server that provides various services, such as a background management server that supports an item ex-warehouse request made by a user using the terminal devices 501, 502, 503. The background management server can perform data calculation and processing on the received ex-warehouse request and feed back the processed form data to the terminal equipment.
It should be noted that the method for generating the outbound form provided by the embodiment of the present invention is generally executed by the server 505, and accordingly, the apparatus for generating the outbound form is generally disposed in the server 505.
It should be understood that the number of terminal devices, networks, and servers in fig. 5 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
Referring now to FIG. 6, a block diagram of a computer system 600 suitable for use with a terminal device implementing an embodiment of the invention is shown. The terminal device shown in fig. 6 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. 6, the computer system 600 includes a Central Processing Unit (CPU)601 that can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM)602 or a program loaded from a storage section 608 into a Random Access Memory (RAM) 603. In the RAM 603, various programs and data necessary for the operation of the system 600 are also stored. The CPU 601, ROM 602, and RAM 603 are connected to each other via a bus 604. An input/output (I/O) interface 605 is also connected to bus 604.
The following components are connected to the I/O interface 605: an input portion 606 including a keyboard, a mouse, and the like; an output portion 607 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage section 608 including a hard disk and the like; and a communication section 609 including a network interface card such as a LAN card, a modem, or the like. The communication section 609 performs communication processing via a network such as the internet. The driver 610 is also connected to the I/O interface 605 as needed. A removable medium 611 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 610 as necessary, so that a computer program read out therefrom is mounted in the storage section 608 as necessary.
In particular, according to the embodiments of the present disclosure, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network through the communication section 609, and/or installed from the removable medium 611. The computer program performs the above-described functions defined in the system of the present invention when executed by the Central Processing Unit (CPU) 601.
It should be noted that the computer readable medium shown in the present invention can be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present invention, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present invention, however, a computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The modules and/or units described in the embodiments of the present invention may be implemented by software, and may also be implemented by hardware. The described modules and/or units may also be provided in a processor, and may be described as: a processor comprises an inventory information acquisition module, a warehouse-out information calculation module and a warehouse-out form generation module. The names of these modules do not limit the module itself in some cases, and for example, the module for calculating the warehouse-out information may be further described as a "module for calculating the inventory amount and the actual warehouse-out amount of each warehouse-out specification according to the warehouse-out request".
As another aspect, the present invention also provides a computer-readable medium that may be contained in the apparatus described in the above embodiments; or may be separate and not incorporated into the device. The computer readable medium carries one or more programs which, when executed by a device, cause the device to comprise: receiving an article ex-warehouse request, wherein the article ex-warehouse request comprises at least two ex-warehouse lists, and the ex-warehouse lists at least comprise article names and request ex-warehouse quantity; the article names contained in the at least two ex-warehouse particulars are the same, and the attributes of the articles in the ex-warehouse particulars are different; acquiring the total inventory amount and the available quantity of the articles according to the article names; respectively calculating the inventory and the actual delivery amount corresponding to each delivery detail based on the total inventory, the available quantity and the requested delivery amount of each delivery detail; and collecting each ex-warehouse list, the inventory and the actual ex-warehouse quantity corresponding to the ex-warehouse list, and generating an ex-warehouse form.
According to the technical scheme of the embodiment of the invention, the embodiment can solve the problem of contradiction between data caused by the fact that the requested shipment volume, the actual shipment volume and the available quantity in each shipment object data in the shipment form are not linked in the prior art.
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 (14)

1. A method of generating a outbound form, comprising:
receiving an article ex-warehouse request, wherein the article ex-warehouse request comprises at least two ex-warehouse lists, and the ex-warehouse lists at least comprise article names and request ex-warehouse quantity; the article names contained in the at least two ex-warehouse particulars are the same, and the attributes of the articles in the ex-warehouse particulars are different;
acquiring the total inventory amount and the available quantity of the articles according to the article names;
respectively calculating the inventory and the actual delivery amount corresponding to each delivery detail based on the total inventory, the available quantity and the requested delivery amount of each delivery detail;
and collecting each ex-warehouse list, the inventory and the actual ex-warehouse quantity corresponding to the ex-warehouse list, and generating an ex-warehouse form.
2. The method of claim 1,
when the available quantity of the item is less than the inventory quantity, the available quantity is indicated as a difference between the inventory quantity and a quantity of an unavailable item.
3. The method of claim 1,
respectively calculating the inventory and the actual delivery amount corresponding to each delivery statement based on the total inventory, the available quantity and the requested delivery amount of each delivery statement, including:
setting the same initial value for the inventory corresponding to each ex-warehouse detail; calculating the difference between the total inventory of the articles and the sum of the initial inventory values in all the ex-warehouse particulars to obtain the total intermediate inventory;
setting the same initial value for the actual ex-warehouse quantity corresponding to each ex-warehouse detail; calculating the difference between the available quantity of the articles and the sum of the initial values of the actual ex-warehouse quantity in all the ex-warehouse particulars to obtain the intermediate actual ex-warehouse quantity;
the initial value of the actual warehouse-out quantity is not more than the initial value of the stock quantity.
4. The method of claim 3,
respectively calculating the inventory and the actual delivery amount corresponding to each delivery statement based on the total inventory, the available quantity and the requested delivery amount of each delivery statement, including:
based on the intermediate actual ex-warehouse quantity of the article, sequentially aiming at the request ex-warehouse quantity and the actual ex-warehouse quantity initial value of each ex-warehouse detail, calculating the actual ex-warehouse quantity corresponding to each ex-warehouse detail;
and calculating the inventory amount corresponding to each warehouse-out detail sequentially according to the requested warehouse-out amount and the initial inventory amount value of each warehouse-out detail based on the intermediate inventory amount of the articles.
5. The method of claim 4,
calculating the actual ex-warehouse quantity corresponding to each ex-warehouse detail sequentially aiming at the request ex-warehouse quantity and the actual ex-warehouse quantity initial value of each ex-warehouse detail based on the intermediate actual ex-warehouse quantity of the article, and the method comprises the following steps:
calculating the difference value between the requested ex-warehouse quantity and the corresponding actual ex-warehouse quantity initial value aiming at each ex-warehouse detail in sequence;
when the difference is smaller than or equal to the intermediate actual ex-warehouse quantity, taking the requested ex-warehouse quantity as the actual ex-warehouse quantity, and correspondingly reducing the intermediate actual ex-warehouse quantity by the difference;
when the difference is larger than the intermediate actual ex-warehouse quantity, calculating the sum of the initial value of the actual ex-warehouse quantity and the intermediate actual ex-warehouse quantity as the actual ex-warehouse quantity;
and when the intermediate actual ex-warehouse quantity is zero, taking the initial value of the actual ex-warehouse quantity as the actual ex-warehouse quantity.
6. The method of claim 4,
calculating the inventory amount corresponding to each warehouse-out detail sequentially for the requested warehouse-out amount and the initial inventory amount value of each warehouse-out detail based on the intermediate inventory amount of the article, including:
calculating the difference value between the requested warehouse-out quantity and the initial value of the stock quantity in sequence aiming at each warehouse-out detail;
when the difference is smaller than or equal to the intermediate inventory amount, taking the requested inventory amount as the inventory amount, and correspondingly reducing the intermediate inventory amount by the difference;
when the difference is larger than the intermediate inventory amount, calculating the sum of the initial inventory amount and the intermediate inventory amount as the inventory amount;
and when the intermediate inventory amount is zero, taking the initial inventory value as the inventory.
7. An apparatus for generating outbound forms, comprising: the system comprises an inventory information acquisition module, a warehouse-out information calculation module and a warehouse-out form generation module; wherein,
the inventory information acquiring module is used for receiving an article ex-warehouse request, wherein the article ex-warehouse request comprises at least two ex-warehouse particulars, and the ex-warehouse particulars at least comprise an article name and a request ex-warehouse quantity; the article names contained in the at least two ex-warehouse particulars are the same, and the attributes of the articles in the ex-warehouse particulars are different;
the warehouse-out calculation information module is used for acquiring the total inventory amount and the available quantity of the articles according to the article names; respectively calculating the inventory and the actual delivery amount corresponding to each delivery detail based on the total inventory, the available quantity and the requested delivery amount of each delivery detail;
and the outbound form generation module is used for collecting each outbound detail, the stock amount and the actual outbound amount corresponding to the outbound detail and generating an outbound form.
8. The apparatus of claim 7,
when the available quantity of the item is less than the inventory quantity, the available quantity is indicated as a difference between the inventory quantity and a quantity of an unavailable item.
9. The apparatus of claim 7,
respectively calculating the inventory and the actual delivery amount corresponding to each delivery statement based on the total inventory, the available quantity and the requested delivery amount of each delivery statement, including:
setting the same initial value for the inventory corresponding to each ex-warehouse detail; calculating the difference between the total inventory of the articles and the sum of the initial inventory values in all the ex-warehouse particulars to obtain the total intermediate inventory;
setting the same initial value for the actual ex-warehouse quantity corresponding to each ex-warehouse detail; calculating the difference between the available quantity of the articles and the sum of the initial values of the actual ex-warehouse quantity in all the ex-warehouse particulars to obtain the intermediate actual ex-warehouse quantity;
the initial value of the actual warehouse-out quantity is not more than the initial value of the stock quantity.
10. The apparatus of claim 9,
respectively calculating the inventory and the actual delivery amount corresponding to each delivery statement based on the total inventory, the available quantity and the requested delivery amount of each delivery statement, including:
based on the intermediate actual ex-warehouse quantity of the article, sequentially aiming at the request ex-warehouse quantity and the actual ex-warehouse quantity initial value of each ex-warehouse detail, calculating the actual ex-warehouse quantity corresponding to each ex-warehouse detail;
and calculating the inventory amount corresponding to each warehouse-out detail sequentially according to the requested warehouse-out amount and the initial inventory amount value of each warehouse-out detail based on the intermediate inventory amount of the articles.
11. The apparatus of claim 10,
calculating the actual ex-warehouse quantity corresponding to each ex-warehouse detail sequentially aiming at the request ex-warehouse quantity and the actual ex-warehouse quantity initial value of each ex-warehouse detail based on the intermediate actual ex-warehouse quantity of the article, and the method comprises the following steps:
calculating the difference value between the requested ex-warehouse quantity and the corresponding actual ex-warehouse quantity initial value aiming at each ex-warehouse detail in sequence;
when the difference is smaller than or equal to the intermediate actual ex-warehouse quantity, taking the requested ex-warehouse quantity as the actual ex-warehouse quantity, and correspondingly reducing the intermediate actual ex-warehouse quantity by the difference;
when the difference is larger than the intermediate actual ex-warehouse quantity, calculating the sum of the initial value of the actual ex-warehouse quantity and the intermediate actual ex-warehouse quantity as the actual ex-warehouse quantity;
and when the intermediate actual ex-warehouse quantity is zero, taking the initial value of the actual ex-warehouse quantity as the actual ex-warehouse quantity.
12. The apparatus of claim 10,
calculating the inventory amount corresponding to each warehouse-out detail sequentially for the requested warehouse-out amount and the initial inventory amount value of each warehouse-out detail based on the intermediate inventory amount of the article, including:
calculating the difference value between the requested warehouse-out quantity and the initial value of the stock quantity in sequence aiming at each warehouse-out detail;
when the difference is smaller than or equal to the intermediate inventory amount, taking the requested inventory amount as the inventory amount, and correspondingly reducing the intermediate inventory amount by the difference;
when the difference is larger than the intermediate inventory amount, calculating the sum of the initial inventory amount and the intermediate inventory amount as the inventory amount;
and when the intermediate inventory amount is zero, taking the initial inventory value as the inventory.
13. An electronic device, comprising:
one or more processors;
a storage device for storing one or more programs,
when executed by the one or more processors, cause the one or more processors to implement the method of any one of claims 1-6.
14. 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-6.
CN202010120381.2A 2020-02-26 2020-02-26 Method and device for generating ex-warehouse form Pending CN113313438A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010120381.2A CN113313438A (en) 2020-02-26 2020-02-26 Method and device for generating ex-warehouse form

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010120381.2A CN113313438A (en) 2020-02-26 2020-02-26 Method and device for generating ex-warehouse form

Publications (1)

Publication Number Publication Date
CN113313438A true CN113313438A (en) 2021-08-27

Family

ID=77370022

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010120381.2A Pending CN113313438A (en) 2020-02-26 2020-02-26 Method and device for generating ex-warehouse form

Country Status (1)

Country Link
CN (1) CN113313438A (en)

Citations (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH08241353A (en) * 1995-03-07 1996-09-17 Kobe Steel Ltd Stocking plan support device
JP2014052892A (en) * 2012-09-07 2014-03-20 Fujitsu Ltd Program, method, apparatus and system for generating inventory information, and inventory information display device
CN105574690A (en) * 2014-10-17 2016-05-11 航天信息软件技术有限公司 Method for obtaining available quantity data
CN108171451A (en) * 2017-12-06 2018-06-15 中国铁道科学研究院电子计算技术研究所 railway maintenance material storage management system and method
CN108694535A (en) * 2017-04-07 2018-10-23 北京京东尚科信息技术有限公司 information generating method and device
WO2018210062A1 (en) * 2017-05-18 2018-11-22 北京京东尚科信息技术有限公司 Method and device for determining inventory of items by server system
CN109767151A (en) * 2017-11-09 2019-05-17 北京京东尚科信息技术有限公司 Storage management method, device, medium and electronic equipment
CN110135770A (en) * 2018-02-02 2019-08-16 北京京东尚科信息技术有限公司 The generation method and device of outbound scheme
JP6562429B1 (en) * 2018-04-19 2019-08-21 三菱ロジスネクスト株式会社 Inventory management system
CN110472899A (en) * 2018-05-09 2019-11-19 北京京东尚科信息技术有限公司 A kind of the outbound distribution method and device of article
CN110689290A (en) * 2018-07-06 2020-01-14 北京京东尚科信息技术有限公司 Commodity selling method and device
CN110807596A (en) * 2019-11-06 2020-02-18 广东卓志供应链科技有限公司 Cross-border e-commerce consignment warehouse storage management system and method

Patent Citations (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH08241353A (en) * 1995-03-07 1996-09-17 Kobe Steel Ltd Stocking plan support device
JP2014052892A (en) * 2012-09-07 2014-03-20 Fujitsu Ltd Program, method, apparatus and system for generating inventory information, and inventory information display device
CN105574690A (en) * 2014-10-17 2016-05-11 航天信息软件技术有限公司 Method for obtaining available quantity data
CN108694535A (en) * 2017-04-07 2018-10-23 北京京东尚科信息技术有限公司 information generating method and device
WO2018210062A1 (en) * 2017-05-18 2018-11-22 北京京东尚科信息技术有限公司 Method and device for determining inventory of items by server system
CN109767151A (en) * 2017-11-09 2019-05-17 北京京东尚科信息技术有限公司 Storage management method, device, medium and electronic equipment
CN108171451A (en) * 2017-12-06 2018-06-15 中国铁道科学研究院电子计算技术研究所 railway maintenance material storage management system and method
CN110135770A (en) * 2018-02-02 2019-08-16 北京京东尚科信息技术有限公司 The generation method and device of outbound scheme
JP6562429B1 (en) * 2018-04-19 2019-08-21 三菱ロジスネクスト株式会社 Inventory management system
CN110472899A (en) * 2018-05-09 2019-11-19 北京京东尚科信息技术有限公司 A kind of the outbound distribution method and device of article
CN110689290A (en) * 2018-07-06 2020-01-14 北京京东尚科信息技术有限公司 Commodity selling method and device
CN110807596A (en) * 2019-11-06 2020-02-18 广东卓志供应链科技有限公司 Cross-border e-commerce consignment warehouse storage management system and method

Non-Patent Citations (4)

* Cited by examiner, † Cited by third party
Title
DIOVANINA DIMAS 等: "Multiproduct pipeline scheduling integrating for inbound and outbound inventory management", 《COMPUTERS & CHEMICAL ENGINEERING》, vol. 115, pages 377 - 396, XP085406061, DOI: 10.1016/j.compchemeng.2018.04.025 *
李明 等: "基于HIS系统门诊药房药品实库存建立与实践", 《海峡药学》, vol. 28, no. 9, pages 286 - 288 *
李琳: "医院药品批次管理的实践与探讨", 《中国药房》, vol. 20, no. 19, pages 5 *
顾嘉钦 等: "基于HIS系统的贵重药品优化管理软件设计与实现", 《中国药师》, vol. 12, no. 9, pages 1217 - 1219 *

Similar Documents

Publication Publication Date Title
CN110751497A (en) Commodity replenishment method and device
CN110826831A (en) Method and device for restocking a picking zone of a warehouse
CN113762858B (en) Inventory management method and device
JP2022547230A (en) Method, device, electronic device and storage medium for determining storage location
CN110738436B (en) Method and device for determining available inventory
CN110648089A (en) Method and device for determining delivery timeliness of articles
CN114118888A (en) Order ex-warehouse method and device
CN113095893A (en) Method and device for determining sales of articles
CN112884405A (en) Inquiry system and scheduling method thereof
CN111798167B (en) Warehouse replenishment method and device
JP2023525366A (en) Warehouse storage data processing method, device, electronic device, program, and recording medium
CN113706064A (en) Order processing method and device
CN113128821A (en) Method and device for determining task
CN109255563B (en) Method and device for determining storage area of article
CN110555641B (en) Warehouse allocation method and device
CN109902847B (en) Method and device for predicting amount of orders in branch warehouse
CN110827102A (en) Method and device for adjusting goods price ratio
CN110826948B (en) Warehouse selecting method and device
CN110956478A (en) Method and device for determining goods input quantity
CN115525665A (en) Information processing method and device, electronic equipment and computer readable medium
CN113313438A (en) Method and device for generating ex-warehouse form
CN112926907B (en) Warehouse inventory layout method and device
CN115115313A (en) Order aging management method and device
CN115390958A (en) Task processing method and device
CN113822516A (en) Matching method and device for distribution and transportation side

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