CN112990815A - Inventory management method and device based on ERP system - Google Patents
Inventory management method and device based on ERP system Download PDFInfo
- Publication number
- CN112990815A CN112990815A CN202110224417.6A CN202110224417A CN112990815A CN 112990815 A CN112990815 A CN 112990815A CN 202110224417 A CN202110224417 A CN 202110224417A CN 112990815 A CN112990815 A CN 112990815A
- Authority
- CN
- China
- Prior art keywords
- goods
- warehouse
- sales
- order
- depository
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- 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
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0633—Lists, e.g. purchase orders, compilation or processing
- G06Q30/0635—Processing of requisition or of purchase orders
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- Marketing (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Theoretical Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention discloses an inventory management method and device based on an ERP system, relates to the technical field of inventory management, and can improve the working efficiency of inventory management. The method comprises the following steps: matching the sales order with the inventory information of the main warehouse to determine whether the inventory of the sales goods in the main warehouse is sufficient; if the stock of the sales goods in the main warehouse is insufficient, determining whether the stock of the sales goods in the depository can complement the ordered quantity of the sales goods in the main warehouse or not according to the stock information of the depository; if the stock of the sales goods in the depository can complement the ordered quantity of the sales goods in a main warehouse, generating an output order of the depository according to the replenishment information of the sales goods; updating the inventory information of the depository according to the delivery list of the depository; generating a first purchasing warehousing entry of the main warehouse according to the delivery entry of the storage warehouse; and updating the inventory information of the main warehouse according to the first purchasing warehousing list of the main warehouse.
Description
Technical Field
The invention relates to the technical field of inventory management, in particular to an inventory management method and device based on an ERP system.
Background
Currently, for many trading enterprises, in order to speed up the delivery of orders, there are generally two modes for handling orders:
1. enterprises purchase and prepare stocks by themselves, but the mode has obvious defects:
for example: the enterprise is required to purchase from a supplier in advance, and a large amount of funds of the enterprise are occupied;
when the sale is not smooth, overstocked inventory, overdue inventory and the like are easily caused;
2. enabling the supplier to deposit the goods in the enterprise, and converting the goods into the stock assets of the enterprise and the settlement payment of the supplier when the enterprise has an order; the greatest advantages of this method are that:
for example: the stock level of enterprises can be reduced, and the occupation of stock capital is reduced;
the quick delivery of the order can be achieved, and the maximization of the benefit is realized.
For an Enterprise, when conditions are met, the above "scheme 2" is the best choice, but none of the ERP systems (Enterprise Resource Planning, integrated management information system) in the current market has a solution to complete inventory management of the "scheme 2", which is completed by manually processing the inventory management work of the "scheme 2" (see fig. 1) by a user outside the ERP system, at this time, because no connection is established between the storage warehouse management and the ERP systems in the whole inventory management operation process, mutual fusion and verification cannot be realized, the user needs to spend a large amount of manpower and time to perform matching, repeated entry and other operations, the maximum value of the ERP system is not fully exerted, the optimization of the internal flow of the Enterprise cannot be achieved, and the operation efficiency of the Enterprise can also be affected.
Disclosure of Invention
In view of this, embodiments of the present invention provide an inventory management method and apparatus based on an ERP system, which can reduce a large number of operations such as manual review, matching, entry, and judgment outside the EPR system in an enterprise inventory management process, optimize an inventory management process inside an enterprise, and improve the working efficiency of inventory management.
In a first aspect, an embodiment of the present invention provides an inventory management method based on an ERP system, where the method includes: obtaining a sales order, wherein the sales order comprises an identification of sales goods and an order quantity of each type of the sales goods; matching the sales order with inventory information of a main warehouse to determine whether the inventory of the sales goods in the main warehouse is sufficient, wherein the inventory information of the main warehouse comprises the identification and the quantity of the goods in the main warehouse; if the stock of the sales goods in the main warehouse is insufficient, determining whether the stock of the sales goods in the depository can complement the ordered quantity of the sales goods according to the stock information of the depository, wherein the stock information of the depository comprises the identification and the quantity of the goods in the depository; if the stock of the sales goods in the depository can complement the ordered quantity of the sales goods, generating a delivery order of the depository according to the replenishment information of the sales goods, wherein the replenishment information of the sales goods is determined according to the ordered quantity of the sales goods and the quantity of the sales goods in the main warehouse, and the delivery order comprises the identification and the quantity of the delivery goods; updating the inventory information of the depository according to the delivery list of the depository; generating a first purchasing warehousing entry of the main warehouse according to the delivery order of the storage warehouse, wherein the first purchasing warehousing entry comprises the identification and the quantity of purchased goods; and updating the inventory information of the main warehouse according to the first purchasing warehousing list of the main warehouse.
Optionally, after updating the inventory information of the primary warehouse according to the first purchase warehousing entry of the primary warehouse, the method further includes: and generating a sales delivery order of the main warehouse according to the sales order and the updated inventory information of the main warehouse, wherein the sales delivery order comprises the identification and the quantity of the delivered goods.
Optionally, after generating the sales slip of the main warehouse, the method further includes: and updating the inventory information of the main warehouse according to the sales delivery list according to the notification of the delivery completion of the sales goods.
Optionally, after the generating the delivery order of the depository according to the replenishment information of the sales goods, the method further includes: and generating a stocking warehouse purchase order according to the replenishment information of the sold goods so that a supplier can replenish the stocking warehouse according to the stocking warehouse purchase order, wherein the stocking warehouse purchase order comprises the identification and the quantity of the purchased goods.
Optionally, after generating a depository purchase order according to the replenishment information of the sales goods, the method further includes: after receiving goods sent by a supplier according to the deposit warehouse purchase order, generating a replenishment warehousing entry of the deposit warehouse according to the deposit warehouse purchase order, wherein the replenishment warehousing entry comprises the identification and the quantity of the replenishment goods; and updating the inventory information of the storage warehouse according to the replenishment warehousing entry.
Optionally, after determining that the inventory of the sales goods in the depository cannot complement the ordered quantity of the sales goods according to the inventory information of the depository, the method further comprises: and generating a main warehouse purchase order according to the replenishment information of the sold goods so that a supplier can send the goods according to the main warehouse purchase order, wherein the main warehouse purchase order comprises the identification and the quantity of the purchased goods.
Optionally, after receiving the goods sent by the supplier according to the primary warehouse purchase order, the method further includes: generating a second purchasing warehousing entry of the main warehouse according to the main warehouse purchasing order, wherein the second purchasing warehousing entry comprises the identification and the quantity of the purchased goods; and updating the inventory information of the main warehouse according to the second purchasing warehousing list.
Optionally, after matching the sales order with the inventory information of the primary warehouse and determining whether the inventory of the sales goods in the primary warehouse is sufficient, the method further includes: and if the stock of the sales goods in the main warehouse is determined to be sufficient, generating a sales delivery order of the main warehouse according to the sales order and the stock information of the main warehouse.
In a second aspect, an embodiment of the present invention provides an ERP-based inventory management apparatus, where the apparatus includes: the system comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring a sales order, and the sales order comprises an identification of sales goods and the order quantity of each type of the sales goods; a first determining unit, configured to match the sales order with inventory information of a primary warehouse, and determine whether inventory of the sales goods in the primary warehouse is sufficient, where the inventory information of the primary warehouse includes an identifier and a quantity of the goods in the primary warehouse; a second determining unit, configured to determine, if the stock of the sold goods in the main warehouse is insufficient, whether the stock of the sold goods in the depository can complement the ordered quantity of the sold goods according to stock information of the depository, where the stock information of the depository includes an identifier and a quantity of the goods in the depository; a first generating unit, configured to generate a delivery order of the depository according to replenishment information of the sold goods if the stock of the sold goods in the depository can replenish the ordered quantity of the sold goods, where the replenishment information of the sold goods is determined according to the ordered quantity of the sold goods and the quantity of the sold goods in the main warehouse, and the delivery order includes an identifier and a quantity of the delivered goods; the first updating unit is used for updating the inventory information of the depository according to the delivery list of the depository; the second generation unit is used for generating a first purchasing warehousing entry of the main warehouse according to the delivery entry of the storage warehouse, and the first purchasing warehousing entry comprises the identification and the quantity of the purchased goods; and the second updating unit is used for updating the inventory information of the main warehouse according to the first purchasing warehousing list of the main warehouse.
Optionally, the apparatus further comprises: a third generating unit, configured to generate a sales delivery order of the main warehouse according to the sales order and the updated inventory information of the main warehouse, where the sales delivery order includes identifiers and numbers of delivered goods; and the third updating unit is used for updating the stock information of the main warehouse according to the selling delivery list according to the notification of the completion of the delivery of the sold goods.
Optionally, the apparatus further comprises: and the fourth updating unit is used for updating the stock information of the main warehouse according to the selling delivery list according to the notification of the completion of the delivery of the sold goods.
Optionally, the apparatus further comprises: and the fourth generation unit is used for generating a stocking warehouse purchase order according to the replenishment information of the sold goods so that a supplier can replenish the stocking warehouse according to the stocking warehouse purchase order, wherein the stocking warehouse purchase order comprises the identification and the quantity of the purchased goods.
Optionally, the apparatus further comprises: a fifth generating unit, configured to generate a replenishment warehousing entry of the storage warehouse according to the storage warehouse purchase order after receiving the goods sent by the supplier according to the storage warehouse purchase order, where the replenishment warehousing entry includes the identification and the quantity of the replenishment goods; and the fifth updating unit is used for updating the inventory information of the storage warehouse according to the replenishment warehousing entry.
Optionally, the apparatus further comprises: and the sixth generating unit is used for generating a main warehouse purchase order according to the replenishment information of the sold goods so that a supplier can send the goods according to the main warehouse purchase order, wherein the main warehouse purchase order comprises the identification and the quantity of the purchased goods.
Optionally, the apparatus further comprises: a seventh generating unit, configured to generate a second purchasing warehousing entry of the main warehouse according to the main warehouse purchasing order, where the second purchasing warehousing entry includes an identifier and a quantity of purchased goods; and the sixth updating unit is used for updating the inventory information of the main warehouse according to the second purchasing warehousing entry.
Optionally, the apparatus further comprises: and the eighth generating unit is used for generating a sales delivery order of the main warehouse according to the sales order and the inventory information of the main warehouse if the sufficient inventory of the sales goods in the main warehouse is determined.
The inventory management method and device based on the ERP system provided by the embodiment of the invention have the following beneficial effects:
1. the ERP system can automatically acquire and analyze the inventory of the storage warehouse;
2. two types of purchase orders can be generated respectively aiming at the depository and the main warehouse, so that enterprises and suppliers can manage respective stocks conveniently;
3. the reduction and increase of the inventory of the deposit warehouse can be automatically completed;
4. the method can automatically complete the inventory operation of transferring the storage warehouse goods to the enterprise main warehouse goods, and realize the automatic operation of transferring the non-asset goods to the asset goods.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flow chart illustrating a method for enterprise inventory management according to the background of the invention;
fig. 2 is a schematic flowchart of an inventory management method based on an ERP system according to an embodiment of the present invention;
fig. 3 is a schematic flowchart of an embodiment of an inventory management method based on an ERP system according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of an inventory management device based on an ERP system according to a second embodiment of the present invention.
Detailed Description
Embodiments of the present invention will be described in detail below with reference to the accompanying drawings.
It should be understood that the described embodiments are only some embodiments of the invention, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Example one
As shown in fig. 2, an embodiment of the present invention provides an inventory management method based on an ERP system, where the method includes:
s101, obtaining a sales order, wherein the sales order comprises an identification of sales goods and the order quantity of each sales goods;
in this step, the sales order can be filled in by a salesman through the ERP system, and can be approved and approved by managers such as a supervisor, a manager and the like through the ERP system; after the sales order passes the examination and approval, the ERP system automatically acquires the sales order; the sales goods in the sales order refer to goods ordered by the customer through the salesman in the order, and the identification of the sales goods may be the name of the sales goods or the number (ID information) of the sales goods; the sales order may include one or more sales goods, and each of the sales goods corresponds to an order quantity.
S102, matching the sales order with inventory information of a main warehouse to determine whether the inventory of the sales goods in the main warehouse is sufficient, wherein the inventory information of the main warehouse comprises the identification and the quantity of the goods in the main warehouse;
in the step, the main warehouse is a saleable warehouse of an enterprise, the stock in the main warehouse belongs to the assets of the enterprise, and the sales orders are delivered from the warehouse; the deposit warehouse is a warehouse for placing deposits in an enterprise, the deposits are the goods of a supplier and are placed in the enterprise, the management right of the goods is responsible for the enterprise, the right of the goods belongs to the supplier and does not belong to the assets of the enterprise, when the enterprise sells, the deposits are converted into the assets of the enterprise, and the payment and settlement are formally carried out on the suppliers.
Specifically, the matching the sales order with the inventory information of the main warehouse to determine whether the inventory of the sales goods in the main warehouse is sufficient may include: matching the identification and the order quantity of the sold goods in the sales order with the identification and the quantity of the goods in the inventory information of the main warehouse respectively, and if the identification of all the sold goods exists in the inventory information of the main warehouse and the inventory quantity corresponding to each identification is larger than or equal to the order quantity of the sold goods corresponding to the identification, determining that the inventory of the sold goods in the main warehouse is sufficient; otherwise, it is determined that the inventory of the sold goods in the primary warehouse is insufficient.
S103, if the stock of the sales goods in the main warehouse is insufficient, determining whether the stock of the sales goods in the depository can complement the ordered quantity of the sales goods according to the stock information of the depository, wherein the stock information of the depository comprises the identification and the quantity of the goods in the depository;
in this step, when the stock of the sales goods in the main warehouse is insufficient, the sales goods can be searched in the depository warehouse to complement the number of the sales goods in the sales order, so as to deliver the sales goods to the customer in time.
Optionally, if the stock of the sold goods in the main warehouse is insufficient, determining whether the stock of the sold goods in the depository can complement the ordered quantity of the sold goods according to the stock information of the depository, which may specifically include: if the stock of the sold goods in the main warehouse is insufficient, determining whether the stocked goods in the main warehouse are out of stock or not according to the stock information of the depository; if the deposit warehouse has the sold goods lacking in the main warehouse, determining whether the quantity of the sold goods in the deposit warehouse is larger than or equal to the lacking quantity of the sold goods in the main warehouse; and if the quantity of the sales goods is larger than or equal to the shortage quantity of the sales goods in the main warehouse, determining that the stock of the sales goods in the storage warehouse can complement the ordered quantity of the sales goods. In this embodiment, the out-of-stock amount of the sales goods in the main warehouse is determined according to the ordered quantity of the sales goods and the quantity of the sales goods in the main warehouse.
S104, if the stock of the sales goods in the depository warehouse can complement the ordered quantity of the sales goods, generating an ex-warehouse order of the depository warehouse according to the replenishment information of the sales goods, wherein the replenishment information of the sales goods is determined according to the ordered quantity of the sales goods and the quantity of the sales goods in the main warehouse, and the ex-warehouse order comprises the identification and the quantity of the ex-warehouse goods;
the replenishment of the sold goods is specific to a main warehouse, and the replenishment information of the sold goods specifically comprises the identification of each sold goods and the replenishment amount corresponding to each sold goods; the inventory information of the depository may further include information such as a lot number and an expiration date of the goods in the depository, so that the generating of the delivery order of the depository according to the replenishment information of the sold goods may specifically include: and generating an output list of the depository according to the replenishment information of the sold goods and the inventory information of the depository, wherein the output list of the depository comprises the identification, the quantity, the batch number, the validity period and the like of the output goods.
In addition, when the inventory information of the depository includes information such as a lot number and a validity period of the goods in the depository, and when the delivery list of the depository is generated according to the replenishment information of the sold goods and the inventory information of the depository, a batch of the goods which are preferentially delivered can be set, and the priority of the goods which are delivered can be set according to the length of the validity period.
S105, updating the inventory information of the depository according to the delivery list of the depository;
in this step, the inventory of the goods recorded in the inventory information of the depository warehouse is automatically checked and deducted according to the delivery list of the depository warehouse.
S106, generating a first purchasing warehousing entry of the main warehouse according to the delivery order of the storage warehouse, wherein the first purchasing warehousing entry comprises the identification and the quantity of purchased goods;
in this step, since the information of the goods for replenishing the main warehouse is recorded in the delivery order of the deposit warehouse, the purchased goods in the first purchase warehousing entry are consistent with the delivery goods in the delivery order, and the number of the purchased goods is also consistent with the number of the delivery goods; when the delivery list of the storage warehouse comprises the batch number and the validity period of the delivered goods, the batch number and the validity period of the purchased goods can be recorded in the first purchasing storage list according to the batch number and the validity period of the delivered goods recorded in the delivery list.
And S107, updating the inventory information of the main warehouse according to the first purchasing warehousing entry of the main warehouse.
In this step, specifically, according to the first purchase warehousing entry, the inventory of the goods recorded in the inventory information of the main warehouse is automatically checked and added.
According to the inventory management method based on the ERP system, provided by the embodiment of the invention, the ERP system can automatically judge whether the inventory of the sales goods in the main warehouse is sufficient only by acquiring the sales order, and can further judge whether the inventory of the sales goods in the depository warehouse can complement the ordered quantity of the sales goods under the condition that the inventory of the sales goods in the main warehouse is insufficient, automatically generate the delivery order of the depository warehouse and update the inventory information of the depository warehouse under the condition that the inventory of the sales goods in the depository warehouse can complement the ordered quantity of the sales goods, and then generate the first purchase warehousing order of the main warehouse and update the inventory information of the main warehouse. The automatic management of the ERP system to the main warehouse and the inventory of the depositing warehouse is realized, the deposited goods of the depositing warehouse can be closely related to the inventory of the main warehouse, a large amount of manual rechecking, matching, judging and other operations outside the ERP system are reduced, the working efficiency of enterprise inventory management is improved, errors caused by manual management are reduced, and the delivery speed of enterprise orders is accelerated.
As shown in fig. 2, optionally, after updating the inventory information of the primary warehouse according to the first purchase warehousing entry of the primary warehouse, the method may further include:
and S108, generating a sales delivery order of the main warehouse according to the sales order and the updated inventory information of the main warehouse, wherein the sales delivery order comprises the identification and the quantity of the delivered goods.
In this embodiment, since the quantity of the sold goods in the updated inventory information of the main warehouse can already satisfy the ordered quantity of the sold goods, after the inventory information of the main warehouse is updated, the ERP system binds the inventory of the main warehouse according to the sales order and generates a sales delivery order, so that the staff can allocate and deliver the goods according to the sales delivery order.
As shown in fig. 2, optionally, in the above embodiment, after generating the sales slip of the main warehouse, the method may further include:
and S109, updating the stock information of the main warehouse according to the sales delivery list according to the notification of the delivery completion of the sales goods.
In this embodiment, after the sold goods are delivered according to the sales delivery order, the number of the goods in the main warehouse is actually reduced, so that after the ERP system obtains the notification that the sold goods are delivered, the number of the goods in the inventory information of the main warehouse is automatically reduced according to the sales delivery order.
Optionally, after the generating the delivery order of the depository according to the replenishment information of the sales goods, the method may further include: and generating a stocking warehouse purchase order according to the replenishment information of the sold goods so that a supplier can replenish the stocking warehouse according to the stocking warehouse purchase order, wherein the stocking warehouse purchase order comprises the identification and the quantity of the purchased goods.
In this embodiment, after the delivery order of the depository is generated, the goods in the depository are replenished to the main depository according to the delivery order of the depository, that is, the goods in the depository are reduced, at this time, the enterprise needs to re-purchase the goods according to the replenishment information to replenish the depository, so as to keep the number of the goods in the depository unchanged. Specifically, the purchased goods in the purchase order of the storage warehouse are consistent with the goods in the replenishment information, and the quantity of the purchased goods is consistent with the quantity of the goods in the replenishment information.
Optionally, in the above embodiment, after receiving the goods sent by the supplier according to the warehouse purchase order, the method may further include: generating a replenishment warehousing order of the storage warehouse according to the purchase order of the storage warehouse, wherein the replenishment warehousing order comprises the identification and the quantity of replenishment goods; and updating the inventory information of the storage warehouse according to the replenishment warehousing entry.
In the embodiment, after receiving the goods sent by the supplier according to the purchase order of the depository, the enterprise can replenish the goods into the depository, and at this time, the actual stock of the depository is increased, so that the stock information of the depository is updated in time according to the replenishment stock warehousing order, and the real-time performance and the authenticity of the stock information are ensured.
Optionally, after determining that the inventory of the sales goods in the depository cannot complement the ordered quantity of the sales goods according to the inventory information of the depository, the method further comprises: and generating a main warehouse purchase order according to the replenishment information of the sold goods so that a supplier can send the goods according to the main warehouse purchase order, wherein the main warehouse purchase order comprises the identification and the quantity of the purchased goods.
In this embodiment, when the stock in the depository warehouse cannot complement the ordered quantity of the sales goods, the ordered quantity in the sales order cannot be satisfied even if the goods are transferred from the depository warehouse to the main warehouse, so that the purchase order can be directly issued to the supplier according to the replenishment information of the sales goods without transferring the goods from the depository warehouse to the main warehouse.
Optionally, in the above embodiment, after generating the main warehouse purchase order according to the replenishment information of the sales goods, the method further includes: after receiving the goods sent by the supplier according to the main warehouse purchase order, generating a second purchase warehousing entry of the main warehouse according to the main warehouse purchase order, wherein the second purchase warehousing entry comprises the identification and the quantity of the purchased goods; and updating the inventory information of the main warehouse according to the second purchasing warehousing list.
In this embodiment, since the goods sent by the supplier are related to the purchase order of the main warehouse, the second purchase warehousing entry of the main warehouse can be generated according to the purchase order of the main warehouse, and specifically, the received goods can be checked according to the purchase order of the main warehouse to generate the second purchase warehousing entry of the main warehouse. The checking process may be completed through an ERP system, for example, the ERP system matches the uploaded information of the goods with the purchase order of the main warehouse, and generates a second purchase warehousing entry of the main warehouse.
Optionally, after matching the sales order with the inventory information of the primary warehouse and determining whether the inventory of the sales goods in the primary warehouse is sufficient, the method further includes: and if the stock of the sales goods in the main warehouse is determined to be sufficient, generating a sales delivery order of the main warehouse according to the sales order and the stock information of the main warehouse.
In this embodiment, when the stock of the sales goods in the main warehouse is sufficient, the sales delivery order of the main warehouse may be directly generated according to the sales order and the stock information of the main warehouse without borrowing the deposited goods in the deposited warehouse or ordering the goods from the supplier.
In order to better understand the present invention, a detailed description is given below of an inventory management method based on an ERP system according to an embodiment of the present invention.
As shown in fig. 3, an embodiment of the present invention provides an inventory management method based on an ERP system, where the method includes the following specific implementation processes:
1. the salesman fills in a sales order; the supervisor and the manager pass the approval;
2. the system can automatically judge whether the stock of the main warehouse is sufficient or not by processing the valid sales orders: if the stock is sufficient, directly generating a sales delivery order, distributing and delivering goods, and finishing the delivery of the sales order;
3. if the stock of the main warehouse is insufficient, the system automatically checks and matches the stock information of the storage warehouse to confirm whether the stock of the storage warehouse can complement the goods in shortage:
3.1, if the backyard can complement the goods in short of stock, the system automatically summarizes the matched goods numbers and quantities to generate a storage warehouse purchase order;
3.2, if the inventory of the storage warehouse is insufficient, automatically summarizing the goods numbers and the quantities which are not matched with each other by the system to generate a main warehouse purchase order;
4. the system can simultaneously establish association among 'warehouse deposit order', 'main warehouse purchase order' and 'sales order', and store the association in 'relation table H';
5. checking the 'deposited warehouse purchase order' and the 'main warehouse purchase order', printing or exporting a purchase file, and sending the purchase file to a supplier for purchase; the two purchase orders can be distinguished by using different marks, so that the enterprise can conveniently manage the inventory or the supplier can conveniently manage and deposit the goods;
6. because the 'deposit warehouse purchase order' is a purchase order for depositing goods and supplementing goods, which indicates that the deposit warehouse has deposited stock, the system can automatically generate a 'deposit warehouse delivery order', automatically check and automatically deduct the stock of the 'deposit warehouse', and the delivery of the deposit stock is finished;
7. the system can simultaneously establish association between the 'warehouse deposit order' and the 'warehouse delivery order' and store the association in a 'relation table E';
8. generating a main warehouse purchasing warehousing entry according to a deposited warehouse purchasing order;
9. according to the corresponding relation of the relation table E, the system can automatically output the warehouse-out information of the storage warehouse output list: the information such as quantity, batch number, validity period and the like is automatically filled in the 'main warehouse purchasing warehousing entry' by default, so that the manual repeated input of a user is reduced;
10. checking a purchase warehousing bill of a main warehouse, increasing the inventory of the main warehouse of the enterprise, and completing warehousing;
11. according to the corresponding relation of the relation table H, the system automatically binds the stock of the main warehouse with the sales order which requires purchasing;
12. generating a sales delivery order according to the bound inventory of the sales order, distributing, delivering and auditing, reducing the inventory and finishing the delivery;
13. when goods of a supplier's ' warehouse purchase order ' are received, checking according to the information of the ' warehouse purchase order ', and starting to handle warehousing of the warehouse after checking is correct;
14. directly clicking a 'replenishment' function on a 'stocking warehouse purchase order', automatically generating a 'replenishment warehousing order' of a stocking warehouse by a system according to corresponding information of a 'relation table E', filling the batch number and the validity period of the goods, storing and checking, and increasing the stock of the stocking warehouse;
15. the whole process is completed;
in this embodiment, in order to better show the flow of the inventory management method, each step in fig. 3 adopts an omission writing method, and the specific implementation process thereof is referred to above.
Second aspect of the invention
As shown in fig. 4, an embodiment of the present invention provides an ERP-based inventory management apparatus, where the apparatus includes: an obtaining unit 21, configured to obtain a sales order, where the sales order includes an identifier of a sales item and an order quantity of each of the sales items; a first determining unit 22, configured to match the sales order with inventory information of a primary warehouse, and determine whether the inventory of the sales goods in the primary warehouse is sufficient, where the inventory information of the primary warehouse includes an identifier and a quantity of the goods in the primary warehouse; a second determining unit 23, configured to determine, if the stock of the sales goods in the main warehouse is insufficient, whether the stock of the sales goods in the depository can complement the ordered number of the sales goods according to stock information of the depository, where the stock information of the depository includes an identifier and a number of the sales goods in the depository; a first generating unit 24, configured to generate a delivery order of the depository according to replenishment information of the sold goods if the stock of the sold goods in the depository can replenish the ordered quantity of the sold goods, where the replenishment information of the sold goods is determined according to the ordered quantity of the sold goods and the quantity of the sold goods in the main depository, and the delivery order includes an identifier and a quantity of the delivered goods; a first updating unit 25, configured to update the inventory information of the depository according to the delivery order of the depository; a second generating unit 26, configured to generate a first purchasing warehousing entry of the main warehouse according to the delivery order of the depository warehouse, where the first purchasing warehousing entry includes an identifier and a quantity of purchased goods; and a second updating unit 27, configured to update the inventory information of the main warehouse according to the first purchase warehousing entry of the main warehouse.
Optionally, the apparatus further comprises: a third generating unit, configured to generate a sales delivery order of the main warehouse according to the sales order and the updated inventory information of the main warehouse, where the sales delivery order includes identifiers and numbers of delivered goods; and the third updating unit is used for updating the stock information of the main warehouse according to the selling delivery list according to the notification of the completion of the delivery of the sold goods.
Optionally, the apparatus further comprises: and the fourth updating unit is used for updating the stock information of the main warehouse according to the selling delivery list according to the notification of the completion of the delivery of the sold goods.
Optionally, the apparatus further comprises: and the fourth generation unit is used for generating a stocking warehouse purchase order according to the replenishment information of the sold goods so that a supplier can replenish the stocking warehouse according to the stocking warehouse purchase order, wherein the stocking warehouse purchase order comprises the identification and the quantity of the purchased goods.
Optionally, the apparatus further comprises: a fifth generating unit, configured to generate a replenishment warehousing entry of the storage warehouse according to the storage warehouse purchase order after receiving the goods sent by the supplier according to the storage warehouse purchase order, where the replenishment warehousing entry includes the identification and the quantity of the replenishment goods; and the fifth updating unit is used for updating the inventory information of the storage warehouse according to the replenishment warehousing entry.
Optionally, the apparatus further comprises: and the sixth generating unit is used for generating a main warehouse purchase order according to the replenishment information of the sold goods so that a supplier can send the goods according to the main warehouse purchase order, wherein the main warehouse purchase order comprises the identification and the quantity of the purchased goods.
Optionally, the apparatus further comprises: a seventh generating unit, configured to generate a second purchasing warehousing entry of the main warehouse according to the main warehouse purchasing order, where the second purchasing warehousing entry includes an identifier and a quantity of purchased goods; and the sixth updating unit is used for updating the inventory information of the main warehouse according to the second purchasing warehousing entry.
Optionally, the apparatus further comprises: and the eighth generating unit is used for generating a sales delivery order of the main warehouse according to the sales order and the inventory information of the main warehouse if the sufficient inventory of the sales goods in the main warehouse is determined.
The apparatus of this embodiment may be used to implement the technical solutions of the method embodiments shown in fig. 2 to 3, and the implementation principles and technical effects are similar, which are not described herein again.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
All the embodiments in the present specification are described in a related manner, and the same and similar parts among the embodiments may be referred to each other, and each embodiment focuses on the differences from the other embodiments.
In particular, as for the apparatus embodiment, since it is substantially similar to the method embodiment, the description is relatively simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
The above description is only for the specific embodiment of the present invention, but the scope of the present invention is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present invention are included in the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (10)
1. An inventory management method based on an ERP system is characterized by comprising the following steps:
obtaining a sales order, wherein the sales order comprises an identification of sales goods and an order quantity of each type of the sales goods;
matching the sales order with inventory information of a main warehouse to determine whether the inventory of the sales goods in the main warehouse is sufficient, wherein the inventory information of the main warehouse comprises the identification and the quantity of the goods in the main warehouse;
if the stock of the sales goods in the main warehouse is insufficient, determining whether the stock of the sales goods in the depository can complement the ordered quantity of the sales goods according to the stock information of the depository, wherein the stock information of the depository comprises the identification and the quantity of the goods in the depository;
if the stock of the sales goods in the depository can complement the ordered quantity of the sales goods, generating a delivery order of the depository according to the replenishment information of the sales goods, wherein the replenishment information of the sales goods is determined according to the ordered quantity of the sales goods and the quantity of the sales goods in the main warehouse, and the delivery order comprises the identification and the quantity of the delivery goods;
updating the inventory information of the depository according to the delivery list of the depository;
generating a first purchasing warehousing entry of the main warehouse according to the delivery order of the storage warehouse, wherein the first purchasing warehousing entry comprises the identification and the quantity of purchased goods;
and updating the inventory information of the main warehouse according to the first purchasing warehousing list of the main warehouse.
2. The method of claim 1, wherein after updating the inventory information of the primary warehouse based on the first procurement manifest of the primary warehouse, the method further comprises:
and generating a sales delivery order of the main warehouse according to the sales order and the updated inventory information of the main warehouse, wherein the sales delivery order comprises the identification and the quantity of the delivered goods.
3. The method of claim 2, wherein after generating the sales slip for the master warehouse, the method further comprises:
and updating the inventory information of the main warehouse according to the sales delivery list according to the notification of the delivery completion of the sales goods.
4. The method of claim 1, wherein after generating the outbound order of the depository from the replenishment information of the sold good, the method further comprises:
and generating a stocking warehouse purchase order according to the replenishment information of the sold goods so that a supplier can replenish the stocking warehouse according to the stocking warehouse purchase order, wherein the stocking warehouse purchase order comprises the identification and the quantity of the purchased goods.
5. The method of claim 4, wherein after generating a depositor purchase order based on replenishment information for the sold good, the method further comprises:
after receiving goods sent by a supplier according to the deposit warehouse purchase order, generating a replenishment warehousing entry of the deposit warehouse according to the deposit warehouse purchase order, wherein the replenishment warehousing entry comprises the identification and the quantity of the replenishment goods;
and updating the inventory information of the storage warehouse according to the replenishment warehousing entry.
6. The method of claim 1, wherein after determining from inventory information of an escrow, that inventory of the sales item in an escrow is unable to replenish the ordered quantity of the sales item, the method further comprises:
and generating a main warehouse purchase order according to the replenishment information of the sold goods so that a supplier can send the goods according to the main warehouse purchase order, wherein the main warehouse purchase order comprises the identification and the quantity of the purchased goods.
7. The method of claim 6, wherein after receiving the goods placed by the supplier in accordance with the primary warehouse purchase order, the method further comprises:
generating a second purchasing warehousing entry of the main warehouse according to the main warehouse purchasing order, wherein the second purchasing warehousing entry comprises the identification and the quantity of the purchased goods;
and updating the inventory information of the main warehouse according to the second purchasing warehousing list.
8. The method of claim 1, wherein after matching the sales order with inventory information of a primary warehouse, determining whether the inventory of the sales items in the primary warehouse is sufficient, the method further comprises:
and if the stock of the sales goods in the main warehouse is determined to be sufficient, generating a sales delivery order of the main warehouse according to the sales order and the stock information of the main warehouse.
9. An ERP-based inventory management device, comprising:
the system comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring a sales order, and the sales order comprises an identification of sales goods and the order quantity of each type of the sales goods;
a first determining unit, configured to match the sales order with inventory information of a primary warehouse, and determine whether inventory of the sales goods in the primary warehouse is sufficient, where the inventory information of the primary warehouse includes an identifier and a quantity of the goods in the primary warehouse;
a second determining unit, configured to determine, if the stock of the sold goods in the main warehouse is insufficient, whether the stock of the sold goods in the depository can complement the ordered quantity of the sold goods according to stock information of the depository, where the stock information of the depository includes an identifier and a quantity of the goods in the depository;
a first generating unit, configured to generate a delivery order of the depository according to replenishment information of the sold goods if the stock of the sold goods in the depository can replenish the ordered quantity of the sold goods, where the replenishment information of the sold goods is determined according to the ordered quantity of the sold goods and the quantity of the sold goods in the main warehouse, and the delivery order includes an identifier and a quantity of the delivered goods;
the first updating unit is used for updating the inventory information of the depository according to the delivery list of the depository;
the second generation unit is used for generating a first purchasing warehousing entry of the main warehouse according to the delivery entry of the storage warehouse, and the first purchasing warehousing entry comprises the identification and the quantity of the purchased goods;
and the second updating unit is used for updating the inventory information of the main warehouse according to the first purchasing warehousing list of the main warehouse.
10. The apparatus of claim 9, further comprising:
a third generating unit, configured to generate a sales delivery order of the main warehouse according to the sales order and the updated inventory information of the main warehouse, where the sales delivery order includes identifiers and numbers of delivered goods;
and the third updating unit is used for updating the stock information of the main warehouse according to the selling delivery list according to the notification of the completion of the delivery of the sold goods.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110224417.6A CN112990815A (en) | 2021-03-01 | 2021-03-01 | Inventory management method and device based on ERP system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110224417.6A CN112990815A (en) | 2021-03-01 | 2021-03-01 | Inventory management method and device based on ERP system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112990815A true CN112990815A (en) | 2021-06-18 |
Family
ID=76351459
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110224417.6A Pending CN112990815A (en) | 2021-03-01 | 2021-03-01 | Inventory management method and device based on ERP system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112990815A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113657840A (en) * | 2021-09-01 | 2021-11-16 | 重药控股(湖南)有限公司 | Warehouse entry and exit management method and system and computer readable storage medium |
| CN113723895A (en) * | 2021-11-03 | 2021-11-30 | 南京云联数科科技有限公司 | Inventory data processing method, system, electronic device and storage medium |
| CN116882903A (en) * | 2023-09-07 | 2023-10-13 | 北京中亦信科技有限公司 | Method for managing order application and computer readable storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102486844A (en) * | 2010-12-01 | 2012-06-06 | 金蝶软件（中国）有限公司 | Method and device for processing concurrent data in enterprise resource planning (ERP) system |
| CN104240057A (en) * | 2014-09-03 | 2014-12-24 | 江苏众诚国际物流有限公司常熟分公司 | Warehousing management software |
| CN104867000A (en) * | 2015-06-18 | 2015-08-26 | 成都海三科技有限公司 | Method for managing stone stock with inventory management system |
| CN107679918A (en) * | 2017-10-17 | 2018-02-09 | 安徽机器猫电子商务股份有限公司 | The business method for promoting off-line transaction to be shifted to online trading is serviced based on SaaS |
| CN110490716A (en) * | 2019-08-29 | 2019-11-22 | 达疆网络科技(上海)有限公司 | A kind of method of the order adjustment of part Out of Stock under O2O scene |
-
2021
- 2021-03-01 CN CN202110224417.6A patent/CN112990815A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102486844A (en) * | 2010-12-01 | 2012-06-06 | 金蝶软件（中国）有限公司 | Method and device for processing concurrent data in enterprise resource planning (ERP) system |
| CN104240057A (en) * | 2014-09-03 | 2014-12-24 | 江苏众诚国际物流有限公司常熟分公司 | Warehousing management software |
| CN104867000A (en) * | 2015-06-18 | 2015-08-26 | 成都海三科技有限公司 | Method for managing stone stock with inventory management system |
| CN107679918A (en) * | 2017-10-17 | 2018-02-09 | 安徽机器猫电子商务股份有限公司 | The business method for promoting off-line transaction to be shifted to online trading is serviced based on SaaS |
| CN110490716A (en) * | 2019-08-29 | 2019-11-22 | 达疆网络科技(上海)有限公司 | A kind of method of the order adjustment of part Out of Stock under O2O scene |
Non-Patent Citations (2)
| Title |
|---|
| 刘星主编: "《物流信息系统综合实验教程》", 31 May 2007, 重庆大学出版社 * |
| 李雯等: "《ERP原理、实施与案例研究》", 28 February 2019, 江苏大学出版社 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113657840A (en) * | 2021-09-01 | 2021-11-16 | 重药控股(湖南)有限公司 | Warehouse entry and exit management method and system and computer readable storage medium |
| CN113723895A (en) * | 2021-11-03 | 2021-11-30 | 南京云联数科科技有限公司 | Inventory data processing method, system, electronic device and storage medium |
| CN116882903A (en) * | 2023-09-07 | 2023-10-13 | 北京中亦信科技有限公司 | Method for managing order application and computer readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107886391B (en) | Cross-border vertical e-commerce management method | |
| CN112990815A (en) | Inventory management method and device based on ERP system | |
| CN102292737B (en) | For the treatment of the method and system of request scheme and managed inventory | |
| CN108280630B (en) | Business processing system and method in traditional supply chain financial field | |
| US7813961B2 (en) | System and method for planning, allocation, and purchasing | |
| US7024382B2 (en) | System and method for managing retail and wholesale operations | |
| US7664684B2 (en) | Method and system for catch-weight management | |
| TW508516B (en) | Warehousing system with optimum process management | |
| EP1830316A1 (en) | Data processing system, RFID reader and data processing method | |
| CN107330755A (en) | Dealer management system | |
| KR101045587B1 (en) | Stock management system and stock managing method using the same | |
| US7805335B2 (en) | Purchase list having status indicators | |
| CN106022808A (en) | Internet shopping platform after-sale management method and system | |
| RU2642378C2 (en) | Automated system for making purchases and sales using interactive cloud system | |
| JP3978991B2 (en) | Ordering system and storage medium | |
| CN112530556A (en) | Medical consumable sales management method and device, computer equipment and storage medium | |
| WO2006104421A1 (en) | Commercial information and analytical system | |
| CN107451900A (en) | One kind is borrowed and sells system | |
| CN107491936A (en) | A kind of intelligent engineering project control platform and method | |
| US20100049634A1 (en) | Cost management system with flexible unit of measure | |
| CN112950070A (en) | Management method and system for joint purchase and centralized distribution and supply of oral consumables | |
| US20160092829A1 (en) | Consigned inventory management system | |
| US20040254854A1 (en) | Purchase management system and method | |
| CN113837680A (en) | Multi-stream coupled industrial product order execution linkage method and system | |
| Cote | The Power of Point of Sale Improving Growth, Profit, and Customer Service in a Retail Business |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210618 |
|
| RJ01 | Rejection of invention patent application after publication |