CN112381482A - Material management method and device, electronic equipment and storage medium - Google Patents

The application provides a material management method, a material management device, electronic equipment and a storage medium, wherein the method comprises the following steps: acquiring sales order amount data; acquiring current inventory available quantity data; the current inventory available data is obtained according to the current inventory data, the current inventory in-transit amount data and the current inventory occupancy data; acquiring order supply conditions according to sales order quantity data and current inventory available quantity data; and when the order supply condition is that the inventory available quantity cannot meet the material demand, generating a material demand plan list. The material management method provided by the application can obtain the current inventory available quantity data through multi-party data analysis, calculation and real-time refreshing; and the order supply condition is timely obtained according to the sales order quantity data and the current inventory available quantity data, so that the problem of fund occupation can be effectively solved, and the production and sales efficiency can be effectively improved.

Material management method and device, electronic equipment and storage medium

Technical Field

The present disclosure relates to the field of material management technologies, and in particular, to a material management method and apparatus, an electronic device, and a storage medium.

Background

The management of materials is always a difficult management block for manufacturing enterprises, if the stock materials are purchased or produced more frequently, a large amount of funds are occupied, if the stock materials are less frequently, the production progress of orders produced by the sales of customer orders is influenced, and the on-time delivery of the orders is influenced, so that the accurate management of the stock available quantity is a real problem which needs to be solved urgently for the production and the sales of each enterprise. The accurate management of the available quantity not only can solve a large amount of stagnant inventory of enterprises, but also can improve the production progress and the accuracy and timeliness of delivery of customers.

In the existing business management and supply chain system, the accurate available amount of the current materials is basically difficult to accurately calculate, and the processing mode of the existing system is basically a management mode of product stock, purchasing to-be-warehoused, producing to-be-warehoused and selling to-be-exported, wherein the mode is the condition that corresponding documents are already built in the purchasing warehousing, the producing warehousing and the selling export, and the mode of the single sheet is difficult to manage the existing real-time available amount of the inventory. Because when the material generates a demand, the purchase order and the sales order which are already placed are not put in storage, and in addition, in some cases, such as quality inspection and the like, the material available quantity generated by all the management modes is always inaccurate, and thus, decision support cannot be provided for the business management of enterprises.

Disclosure of Invention

The application is to solve the technical problem that the material available quantity is difficult to accurately manage and control in the prior art.

In order to solve the technical problem, the application discloses a material management method, which comprises the following steps:

acquiring sales order amount data;

acquiring current inventory available quantity data; the current inventory available quantity data is obtained according to the current inventory data, the current inventory in-transit quantity data and the current inventory occupancy data;

obtaining order supply conditions according to the sales order quantity data and the current inventory available quantity data;

and when the order supply condition is that the inventory available quantity cannot meet the material demand, generating a material demand plan list.

Further, the current inventory quantity-in-transit data is obtained according to the current procurement quantity-in-transit data, the current production quantity-in-transit data and the current outsourced quantity-in-transit data.

Further, the current purchasing quantity-in-transit data comprises purchasing temporary receiving quantity data and purchasing quality inspection quantity data;

the current production in-transit data comprises production incomplete quantity data and production quality inspection quantity data;

the current outsource in-transit data comprises outsource production unfinished quantity data and outsource production quality data.

Further, the current inventory occupancy data is obtained according to the current sales occupancy data, the current production occupancy data and the current outsource occupancy data.

Further, the method also comprises the following steps:

and acquiring a purchase order, a production order and an outsourcing order according to the material demand plan sheet.

Further, the method also comprises the following steps:

and when the order supply condition is that the inventory available quantity can meet the material demand, defining the current sales order quantity data as the sales occupancy quantity data.

A second aspect of the present application provides a material management apparatus, comprising:

the first acquisition module is used for acquiring data of the current sales order quantity;

the second acquisition module is used for acquiring the current inventory available quantity data; the current inventory available quantity data is obtained according to the current inventory data, the current inventory in-transit quantity data and the current inventory occupancy data;

the calculation module is used for acquiring order supply conditions according to the sales order quantity data and the current inventory available quantity data;

and the plan generating module is used for generating a material demand plan list when the inventory available quantity cannot meet the material demand.

Further, the second obtaining module is configured to obtain the current inventory in-transit amount data according to the current purchasing in-transit amount data, the current production in-transit amount data, and the current outsourced in-transit amount data.

A third aspect of the present application provides an electronic device comprising a processor and a memory, the memory having stored therein at least one instruction, at least one program, set of codes, or set of instructions, the at least one instruction, the at least one program, the set of codes, or the set of instructions being loaded and executed by the processor to implement the material management method.

A fourth aspect of the present application provides a computer storage medium, where at least one instruction or at least one program is stored, and the at least one instruction or the at least one program is loaded and executed by a processor to implement the material management method.

By adopting the technical scheme, the application has the following beneficial effects:

according to the material management method, the current inventory available data is obtained according to the current inventory data, the current warehouse in-transit amount data and the current warehouse occupation amount data, and the current inventory available data can be obtained through multi-party data analysis calculation and real-time refreshing; and the order supply condition is timely obtained according to the sales order quantity data and the current inventory available quantity data, so that the problem of fund occupation can be effectively solved, and the production and sales efficiency can be effectively improved.

Drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.

Fig. 1 is a schematic diagram of an implementation environment of a material management method according to an embodiment of the present application;

fig. 2 is a schematic flow chart of a material management method according to an embodiment of the present application;

fig. 3 is a schematic flowchart of a material management apparatus according to an embodiment of the present application;

fig. 4 is a schematic diagram of a server according to an embodiment of the present application.

Detailed Description

The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application. It is to be understood that the embodiments described are only a few embodiments of the present application 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 application.

Reference herein to "one embodiment" or "an embodiment" means that a particular feature, structure, or characteristic may be included in at least one implementation of the present application. In the description of the embodiments of the present application, it is to be understood that the terms "upper", "lower", "top", "bottom", and the like, indicate orientations or positional relationships based on the orientations or positional relationships shown in the drawings, are only for convenience in describing the present application and simplifying the description, and do not indicate or imply that the referred devices or elements must have a specific orientation, be constructed in a specific orientation, and be operated, and thus, should not be construed as limiting the present application. Furthermore, the terms "first", "second" and "first" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. Moreover, the terms "first," "second," and the like are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the application described herein are capable of operation in sequences other than those illustrated or described herein.

The embodiment of the application provides a material management method. First, the embodiment of the present invention discloses an implementation environment of the material management method in a possible embodiment.

Referring to fig. 2, fig. 2 is a schematic flow chart of a material management method according to an embodiment of the present application, including the following steps: the method comprises the following steps:

s201, acquiring sales order quantity data;

s202, acquiring the current inventory available quantity data; the current inventory available quantity data is obtained according to the current inventory data, the current inventory in-transit quantity data and the current inventory occupancy data; in the embodiment of the present application, the current inventory available amount data may be a difference value between a sum of the current inventory amount data and the current inventory quantity-in-transit data and the current inventory occupancy amount data.

In the embodiment of the application, the current inventory quantity-in-transit data is obtained according to the current purchasing quantity-in-transit data, the current production quantity-in-transit data and the current outsourced quantity-in-transit data. Wherein the current library-present quantity-of-routes data may be a sum of the current procurement quantity-of-routes data, the current production quantity-of-routes data, and the current outsourced quantity-of-routes data.

Wherein, the current purchasing quantity data comprises purchasing temporary receiving quantity data and purchasing quality inspection quantity data; the current production in-transit data comprises production incomplete quantity data and production quality inspection quantity data; the current outsource in-transit data comprises outsource production unfinished quantity data and outsource production quality data. In the embodiment of the application, the current purchasing in-transit volume data, the current production in-transit volume data and the current outsourced in-transit volume data all exclude internal order data;

in the embodiment of the application, the current inventory occupancy data is obtained according to the current sales occupancy data, the current production occupancy data and the current outsource occupancy data.

S203, obtaining order supply conditions according to the sales order quantity data and the current inventory available quantity data;

the order supply condition can be judged by the difference value between the current sale order quantity data and the current inventory available quantity data, and if the difference value is larger than 0, the inventory available quantity cannot meet the material requirement; if the difference is less than or equal to 0, the available quantity of the current material stock can meet the material requirement.

And S204, when the order supply condition is that the available inventory amount cannot meet the material demand, generating a material demand plan list. When the order supply condition is that the inventory available quantity can meet the material demand, defining the current sales order quantity data as sales occupancy quantity data; and carrying out sales occupation.

In the embodiment of the application, the method further comprises the following steps:

and acquiring a purchase order, a production order and an outsourcing order according to the material demand plan sheet.

In the embodiment of the application, the method further comprises the steps of obtaining the data of the sales to-be-delivered-warehouse quantity and the data of the internal order;

the data of the sales volume to be delivered is the delivery quality inspection volume which is not delivered; the internal order data includes an outstanding internal order quantity.

In the embodiment of the application, the method further comprises the steps of obtaining total demand data, demand unarranged displacement data and demand difference data;

and acquiring the total demand according to the unanchored quantity data of the checked sales orders and the quantity data of the production materials which are not received. Wherein the total demand data may be a sum of the approved sales order unannounced quantity data and the production material unexplored quantity data.

Acquiring the demand unaffiliated volume data as the quantity of the remaining unaffiliated production or purchase orders of the demand plan;

the demand difference is obtained according to the total demand data, the current inventory data, the current purchasing in-transit data, the current production in-transit data, the current outsourced in-transit data and the current demand non-arrangement quantity data;

the method further comprises the following steps: and judging the balance condition of the available inventory amount according to the demand difference condition.

In the embodiment of the application, the related data such as the current inventory data, the current inventory on-road quantity data, the current inventory occupied quantity data, the current purchasing on-road quantity data, the current production on-road quantity data, the current outsource on-road quantity data, the current inventory available quantity data, the sales order non-shipment quantity data, the production material non-yield quantity data, the current material demand quantity data and the like are all updated and calculated in real time.

According to the material management method, the current inventory available data can be obtained according to the current inventory data, the current warehouse in-transit amount data and the current warehouse occupation amount data, and the current inventory available data can be obtained through multi-party data analysis, calculation and real-time refreshing; and the order supply condition is timely obtained according to the sales order quantity data and the current inventory available quantity data, so that the problem of fund occupation can be effectively solved, and the production and sales efficiency can be effectively improved.

The method provided by the embodiment of the application can accurately calculate the inventory available quantity data, can realize data processing and closed-loop business processes of all related documents, triggers available quantity calculation during auditing of all documents, and warns and reminds in real time when the demand difference is unbalanced, so that the balance of the inventory available quantity is kept.

One embodiment of the method may be as follows;

the method comprises the steps that firstly, after the approved information of a sales order is obtained, sales order quantity data and inventory available quantity data are obtained from the beginning of the sales order; when the inventory available quantity can meet the requirement of a sales order, defining the sales order quantity data as sales occupation quantity data, and carrying out sales occupation;

when the available inventory amount cannot meet the demand of the sales order, generating a material demand plan list, and generating a purchase order, a production order and an outsource order according to the production attribute of the material; the total demand data and demand non-scheduled amount data and the demand difference data are updated at the same time.

After the purchase order is generated according to the material demand plan list, information such as purchase in-transit amount data and inventory available amount data of the added materials is automatically updated, and after production and outsource orders are generated according to the material demand plan list, the production in-transit amount data and outsource in-transit amount data are updated and increased at the same time.

When the arrival information of the purchase, production or outsource order is acquired, generating a temporary purchase storage list, and when the temporary storage quality inspection completion warehousing information is acquired, updating and increasing the current inventory data and reducing the corresponding purchase, production or outsource quantity data; if the purchase order arrival information is directed to direct purchase of the sales order, new sales occupancy data is obtained by updating stock occupancy of the sales order, and if the purchase order arrival information is production of production materials, stock occupancy of the production materials is updated to obtain new production material occupancy data.

According to the generated production order, BOM list data of the production materials and the required quantity data, MRP analysis is carried out, the inventory available quantity of the production materials is analyzed, if the inventory available quantity can meet the requirements of the production order, inventory occupation of the production materials is carried out, the production occupation quantity data is updated, if the inventory available quantity is insufficient, a demand plan is automatically generated, and the total demand quantity and demand difference data of the materials are updated. And when the information that the materials occupy enough materials is obtained, generating a material receiving and delivery list of the materials, and after the information that the materials are delivered out of the warehouse is obtained, reducing the production occupancy data and updating the inventory available data.

And according to the material occupation condition of the order, if the obtained stock occupation of the order is enough, the sales management sends information capable of delivering goods to the client, and if delivery quality inspection completion information fed back by the client is received, a sales delivery list is generated, and the data of the sales volume to be delivered and the sales occupation volume are updated.

And when the sales delivery bill auditing completion information is received, updating the data of the stock quantity, the total demand quantity, the sales occupancy quantity, the demand difference and the like.

According to the embodiment of the application, the strong association and the logic processing of all the associated documents are performed, and the inventory available quantity is refreshed and the inventory occupation is redistributed according to the big data analysis at regular time, so that the accurate tracking and control of the inventory available quantity of the materials are kept, and the inventory available quantity is managed efficiently and accurately. The management level and the working efficiency of the enterprise are improved.

In the embodiment of the application, the current inventory quantity-in-transit data is obtained according to the current purchasing quantity-in-transit data, the current production quantity-in-transit data and the current outsourced quantity-in-transit data. Wherein the current library-present quantity-of-routes data may be a sum of the current procurement quantity-of-routes data, the current production quantity-of-routes data, and the current outsourced quantity-of-routes data.

Wherein, the current purchasing quantity data comprises purchasing temporary receiving quantity data and purchasing quality inspection quantity data; the current production in-transit data comprises production incomplete quantity data and production quality inspection quantity data; the current outsource in-transit data comprises outsource production unfinished quantity data and outsource production quality data. In the embodiment of the application, the current purchasing in-transit volume data, the current production in-transit volume data and the current outsourced in-transit volume data all exclude internal order data;

in the embodiment of the application, the current inventory occupancy data is obtained according to the current sales occupancy data, the current production occupancy data and the current outsource occupancy data.

and acquiring a purchase order, a production order and an outsourcing order according to the material demand plan sheet.

In the embodiment of the application, the method further comprises the steps of obtaining the data of the sales to-be-delivered-warehouse quantity and the data of the internal order;

the data of the sales volume to be delivered is the delivery quality inspection volume which is not delivered; the internal order data includes an outstanding internal order quantity.

and acquiring the total demand according to the unanchored quantity data of the checked sales orders and the quantity data of the production materials which are not received. Wherein the total demand data may be a sum of the approved sales order unannounced quantity data and the production material unexplored quantity data.

Acquiring the demand unaffiliated volume data as the quantity of the remaining unaffiliated production or purchase orders of the demand plan;

the demand difference is obtained according to the total demand data, the current inventory data, the current purchasing in-transit data, the current production in-transit data, the current outsourced in-transit data and the current demand non-arrangement quantity data;

The embodiment of the invention also provides a storage medium, which can be arranged in the server to store at least one instruction and at least one program for implementing the computer information system production fault analysis method in the method embodiment, wherein the at least one instruction and the at least one program are loaded and executed by the processor to implement the material management method.

Alternatively, in this embodiment, the storage medium may be located in at least one network server of a plurality of network servers of a computer network. Optionally, in this embodiment, the storage medium may include, but is not limited to: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.

The embodiment of the invention also provides a storage medium, which has higher requirements on the specialty when test data are written. Alternatively, in this embodiment, the storage medium may be a program code for executing the material management method.

Optionally, in this embodiment, the storage medium may be located on at least one of a plurality of network devices in a network shown in the above embodiment.

Optionally, in this embodiment, the storage medium is arranged to store instructions for performing the method steps as shown in fig. 2 or the method steps as shown in fig. 2.

Optionally, the specific examples in this embodiment may refer to the examples described in the above embodiments, and this embodiment is not described herein again.

Optionally, in this embodiment, the storage medium may include, but is not limited to: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.

Embodiments of the present invention also provide a computer program product or computer program comprising computer instructions stored in a computer readable storage medium. The processor of the computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions to cause the computer device to perform the material management method provided in the above-mentioned various alternative implementations.

The embodiment of the invention provides electronic equipment, which comprises a processor and a memory, wherein at least one instruction and at least one program are stored in the memory, and the at least one instruction or the at least one program is loaded and executed by the processor to realize the material management method.

The memory may be used to store software programs and modules, and the processor may execute various functional applications and data processing by operating the software programs and modules stored in the memory. The memory can mainly comprise a program storage area and a data storage area, wherein the program storage area can store an operating system, application programs needed by functions and the like; the storage data area may store data created according to use of the device, and the like. Further, the memory may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other volatile solid state storage device. Accordingly, the memory may also include a memory controller to provide the processor access to the memory.

The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.

The integrated unit in the above embodiments, if implemented in the form of a software functional unit and sold or used as a separate product, may be stored in the above computer-readable storage medium. Based on such understanding, the technical solution of the present invention may be substantially or partially implemented in the prior art, or all or part of the technical solution may be embodied in the form of a software product stored in a storage medium, and including instructions for causing one or more computer devices (which may be personal computers, servers, or network devices) to execute all or part of the steps of the method according to the embodiments of the present invention.

In the above embodiments of the present invention, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.

The present invention is not intended to be limited to the particular embodiments shown and described, but is to be accorded the widest scope consistent with the principles and novel features herein disclosed.