CN109522334B - Lack material inquiring party, lack material inquiring system and electronic equipment - Google Patents

Lack material inquiring party, lack material inquiring system and electronic equipment Download PDF

Info

Publication number
CN109522334B
CN109522334B CN201811424688.0A CN201811424688A CN109522334B CN 109522334 B CN109522334 B CN 109522334B CN 201811424688 A CN201811424688 A CN 201811424688A CN 109522334 B CN109522334 B CN 109522334B
Authority
CN
China
Prior art keywords
materials
inquired
work order
query
determining
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201811424688.0A
Other languages
Chinese (zh)
Other versions
CN109522334A (en
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.)
Oppo Chongqing Intelligent Technology Co Ltd
Original Assignee
Oppo Chongqing Intelligent 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 Oppo Chongqing Intelligent Technology Co Ltd filed Critical Oppo Chongqing Intelligent Technology Co Ltd
Priority to CN201811424688.0A priority Critical patent/CN109522334B/en
Publication of CN109522334A publication Critical patent/CN109522334A/en
Application granted granted Critical
Publication of CN109522334B publication Critical patent/CN109522334B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

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/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063—Operations research, analysis or management
    • G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
    • 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
    • G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
    • G06Q50/04—Manufacturing
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30—Computing systems specially adapted for manufacturing

Abstract

The application discloses a material shortage query method, a material shortage query system, electronic equipment and a computer readable storage medium, wherein the material shortage query method comprises the following steps: acquiring a work order number to be inquired; determining each material to be inquired according to the work order number to be inquired; inquiring each material to be inquired based on data of inventory materials and data of production line materials, wherein the production line materials are materials received by a production line; and outputting a material shortage result of the material based on the query result. According to the scheme, the redundant and complicated of the lack material query result can be reduced to a certain extent, and meanwhile, the accuracy of the lack material query result is improved.

Description

Lack material inquiring party, lack material inquiring system and electronic equipment
Technical Field
The application belongs to the technical field of material management, and particularly relates to a material shortage query method, a material shortage query system, electronic equipment and a computer readable storage medium.
Background
In the manufacturing industry, the components used by manufacturers to assemble products are often supplied by specialized material suppliers. In order to avoid the situation of unbalanced supply and demand, manufacturers often need to inquire about the shortage of the material in time. The query result of the existing material shortage query system is often redundant and has a certain improvement space for the accuracy of the query result.
Disclosure of Invention
In view of this, the present application provides a material shortage query method and a material shortage query system, which can reduce the redundancy of material shortage query results and improve the accuracy of the material shortage query results.
A first aspect of the present application provides a material shortage query method, including:
acquiring a work order number to be inquired;
determining each material to be inquired according to the work order number to be inquired;
inquiring each material to be inquired based on data of inventory materials and data of production line materials, wherein the production line materials are materials received by a production line;
and outputting a material shortage result of the material based on the query result.
A second aspect of the present application provides a starved material query system, comprising:
the order number acquisition module is used for acquiring the number of the work order to be inquired;
the material determining module is used for determining each material to be inquired according to the work order number to be inquired;
the material query module is used for querying each material to be queried based on data of inventory materials and data of production line materials, wherein the production line materials are materials received by a production line;
and the result output module is used for outputting the material shortage result of the material based on the query result.
A third aspect of the present application provides an electronic device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, the processor implementing the steps of the method according to the first aspect when executing the computer program.
A fourth aspect of the present application provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of the method of the first aspect as described above.
A fifth aspect of the application provides a computer program product comprising a computer program which, when executed by one or more processors, performs the steps of the method as described in the first aspect above.
Therefore, according to the scheme, the work order number to be inquired is firstly acquired, then each material to be inquired is determined according to the work order number to be inquired, each material to be inquired is inquired based on the data of the stock materials and the data of the production line materials, wherein the production line materials are materials received by a production line, and finally the material shortage result of the materials is output based on the inquiry result. In the scheme of the application, the work order number is used for inquiring, so that the redundancy of the lack inquiry result can be reduced to a certain extent; meanwhile, production line materials are considered during query, and accuracy of a lack material query result can be improved to a certain extent.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings needed to be used in the embodiments or the prior art descriptions will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without inventive exercise.
Fig. 1 is a schematic flow chart illustrating an implementation of a material shortage query method provided in an embodiment of the present application;
fig. 2 is a schematic flowchart of a detailed step 101 of a material shortage query method provided in an embodiment of the present application;
fig. 3 is a schematic flowchart of a specific step 102 of a material shortage query method according to an embodiment of the present application;
fig. 4 is a schematic flowchart of a detailed step 104 of the material shortage query method provided in the embodiment of the present application;
fig. 5 is a schematic structural diagram of a material shortage query system provided in an embodiment of the present application;
fig. 6 is a schematic structural diagram of an electronic device provided in an embodiment of the present application.
Detailed Description
In the following description, for purposes of explanation and not limitation, specific details are set forth, such as particular system structures, techniques, etc. in order to provide a thorough understanding of the embodiments of the present application. It will be apparent, however, to one skilled in the art that the present application may be practiced in other embodiments that depart from these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the present application with unnecessary detail.
In order to explain the technical solution of the present application, the following description will be given by way of specific examples.
Example one
Referring to fig. 1, a method for querying a material shortage according to an embodiment of the present application is described below, where the method for querying a material shortage according to the embodiment of the present application includes:
in step 101, acquiring a work order number to be inquired;
in the embodiment of the present application, the order number of the work order to be queried, that is, the work order number to be queried, may be obtained first, where the work order may also be referred to as an order or a plan order. In a work order, the material requirements, i.e. the material, to complete an operation will be involved. In the embodiment of the present application, the work order to be queried may include not only the work order already issued by the buyer, but also the work order planned to be issued by the buyer, that is, the work order to be issued. Specifically, the work order number to be queried may be obtained by accepting an input from a user, or may be obtained by automatically deriving from a material shortage query system, which is not limited herein. Optionally, after the work order number to be queried is obtained, the work order number to be queried may be analyzed, and the number of work orders of the work order corresponding to the work order number to be queried may be obtained and displayed.
In step 102, determining each material to be queried according to the work order number to be queried;
in the embodiment of the application, each work order relates to the material requirement for completing the operation, so that the work order related to the work order number to be inquired can be found according to the work order number to be inquired, and each material to be inquired is determined.
In step 103, inquiring each material to be inquired based on the data of the stock materials and the data of the production line materials;
in the embodiment of the present application, the production line material is a material that is received by a production line. In the conventional material shortage query system, only stock materials are considered, and the production line materials are ignored, so that errors are easily caused in the final query result. Therefore, in the embodiment of the application, the query can be performed on each material to be queried based on the data of the stock material and the data of the production line material.
In step 104, based on the result of the query, a material shortage result of the material is output.
In the embodiment of the application, based on the query result, the number of each material to be queried in the stock materials and the production line materials can be known, based on the comparison between the number and the required number in the work order to be queried, whether the material is in short supply or not can be known, and based on the comparison, the material shortage result of the material is output.
Optionally, fig. 2 shows a specific implementation flow of the step 101, and referring to fig. 2, the step 101 includes:
in step 201, receiving an input buyer code;
in the embodiment of the application, in addition to directly receiving the work order number to be inquired input by the user, the buyer code input by the user can also be received. Generally, each buyer of a manufacturer has a corresponding buyer code within the manufacturer, and the buyer code is unique. Thus, the buyer corresponding to the buyer code can be determined by the buyer code. Optionally, organization information input by a user may also be received to learn by which organization the current starved inquiry operation is performed.
In step 202, determining a buyer to be queried based on the buyer code;
in the embodiment of the application, the buyer corresponding to the buyer code is used as the buyer to be inquired.
In step 203, displaying all the list numbers of the opened work related to the buyer to be inquired;
in the embodiment of the present application, all the list numbers of the work orders related to the buyer to be queried, that is, the list numbers of the work orders issued by the buyer, may be displayed through the material shortage querying system. Optionally, in order to make the result of the material shortage query have a certain prospect, the work order to be issued by the buyer and the corresponding work order number may also be displayed. Optionally, when the work order number is displayed, the work order corresponding to the work order number can be displayed for the user to check, so that the user can better select the work order number to be inquired.
In step 204, an input selection instruction is received, and the number of the work order to be queried is determined among all the opened work order numbers based on the selection instruction.
In the embodiment of the application, the material shortage inquiry system can continuously receive a selection instruction input by a user, and one or more work order numbers are selected from the displayed work order numbers as the work order numbers to be inquired based on the instruction of the selection instruction.
Optionally, fig. 3 shows a specific implementation flow of the step 102, please refer to fig. 3, where the step 102 includes:
in step 301, a bill of materials related to the work order number to be queried is obtained according to the work order number to be queried;
in the embodiment of the present application, the Bill of Material (BOM) is a file describing a product structure in a data format, and is a product structure data file that can be identified by a computer. Through the bill of materials, the product composition manufactured by the manufacturer and all materials to be involved can be quickly known.
In step 302, the materials to be queried are determined from the bill of materials.
In the embodiment of the present application, each material listed in the bill of materials is used as each material to be queried, or a user may further screen materials in the bill of materials to determine each material to be queried. Specifically, a bill of materials includes more than one parent item, and each parent item may further include more than one child item, that is, a component may be split according to the descriptions of the parent item and the child items. For example, a mobile phone as a parent may be further split into children such as a screen, a battery, and a motherboard, and the motherboard may also be further split into more detailed children. In the embodiment of the application, after the bill of materials is expanded, the query of the materials can be performed according to the minimum sub-item of the expanded materials, for example, for a mobile phone, a user only cares about the shortage of the main board, and the user does not care about the more detailed sub-items of the virtual components, the sub-items of the upper cover component, the sub-items of the power cover component, and the like (collectively referred to as the redundant component sub-items), and according to the scheme of the application, as long as the expanded bill of materials only reaches the sub-item of the main board, the rest redundant component sub-items are not queried in the shortage query system, so that the redundancy of the query result of the shortage query system can be greatly reduced.
Optionally, fig. 4 shows a specific implementation flow of the step 104, please refer to fig. 4, where the step 104 includes:
in step 401, based on the result of the query, determining the material that has been short of material;
in step 402, outputting the relevant information of the material which has been short through the EXCEL table, wherein the relevant information includes a material code, a material description, a short place, a demand quantity and/or an inventory quantity of the material which has been short.
In the embodiment of the present application, through the result of the query, the material that is currently short in the manufacturer can be obtained, and in order to enable the user to further know the specific situation of the short, the related information of the short material may be output in the form of an EXCEL table, including but not limited to the material code of the short material, the material description, the location of the short material (i.e., the plant category or the organization, etc.), the required quantity, the existing quantity of the production line, the inventory quantity, the corresponding planner, the corresponding merchandiser, the corresponding buyer, the material classification, and/or the applicable product of the material. Specifically, since the same material may be used on a plurality of different products, that is, there may be more than one organization that needs the material, the quantity of the material needed by the organizations in the manufacturer may be listed in the EXCEL table in order, which helps the user to better plan the material as a whole.
Optionally, after the step 104, the method for inquiring the material shortage further includes:
acquiring a user set associated with the work order number to be inquired;
and pushing the material shortage result to each user in the user set.
In this embodiment of the application, the material shortage result may be pushed to each user related to the work order to be queried, for example, sent to a mailbox of each user in the user set, where the pushing method is not limited here.
As can be seen from the above, according to the embodiment of the present application, firstly, the work order number to be queried is obtained, then, each material to be queried is determined according to the work order number to be queried, and query is performed on each material to be queried based on data of inventory materials and data of production line materials, where the production line materials are materials received by a production line, and finally, a material shortage result of the material is output based on a query result. In the scheme of the application, the work order number is used for inquiring, so that the redundancy of the lack inquiry result can be reduced to a certain extent; meanwhile, production line materials are considered during query, and accuracy of a lack material query result can be improved to a certain extent.
It should be understood that, the sequence numbers of the steps in the foregoing embodiments do not imply an execution sequence, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation to the implementation process of the embodiments of the present application.
Example two
An embodiment of the present application provides a material shortage query system, as shown in fig. 5, a material shortage query system 500 in the embodiment of the present application includes:
a form number obtaining module 501, configured to obtain a work form number to be queried;
a material determining module 502, configured to determine each material to be queried according to the work order number to be queried;
a material query module 503, configured to query each material to be queried based on data of inventory materials and data of production line materials, where the production line materials are materials already received by a production line;
and a result output module 504, configured to output a material shortage result of the material based on the query result.
Optionally, the single number obtaining module 501 includes:
a code receiving unit for receiving an input purchaser code;
the buyer determining unit is used for determining a buyer to be inquired based on the buyer code;
the order number display unit is used for displaying all the operating order numbers related to the buyer to be inquired;
and the sheet number selection unit is used for receiving an input selection instruction and determining the number of the work sheet to be inquired in all the opened work sheet numbers based on the selection instruction.
Optionally, the material determination module 502 includes:
the bill of material obtaining unit is used for obtaining a bill of material related to the work order number to be inquired according to the work order number to be inquired;
and the material to be inquired determining unit is used for determining each material to be inquired through the bill of materials.
Optionally, the to-be-queried material determining unit is specifically configured to obtain each minimum sub-item of the material included in the bill of materials, and determine each to-be-queried material based on each minimum sub-item.
Optionally, the result output module 504 includes:
the material shortage determination unit is used for determining the material shortage based on the query result;
the EXCEL table output unit is used for outputting the related information of the materials which are short of materials through an EXCEL table, and the related information comprises
Optionally, the material shortage query system 500 further includes:
the user set acquisition unit is used for acquiring a user set associated with the work order number to be inquired;
and the material shortage result pushing unit is used for pushing the material shortage result to each user in the user set.
As can be seen from the above, according to the embodiment of the present application, the material shortage query system first obtains the work order number to be queried, then determines each material to be queried according to the work order number to be queried, and queries each material to be queried based on the data of the stock material and the data of the production line material, where the production line material is a material received by the production line, and finally outputs the material shortage result of the material based on the query result. In the scheme of the application, the work order number is used for inquiring, so that the redundancy of the lack inquiry result can be reduced to a certain extent; meanwhile, production line materials are considered during query, and accuracy of a lack material query result can be improved to a certain extent.
EXAMPLE III
Referring to fig. 6, an electronic device according to a third embodiment of the present application includes: a memory 601, one or more processors 602 (only one shown in fig. 6), and computer programs stored on the memory 601 and executable on the processors. Wherein: the memory 601 is used for storing software programs and modules, and the processor 602 executes various functional applications and data processing by running the software programs and units stored in the memory 601, so as to acquire resources corresponding to the preset events. Specifically, the processor 602 implements the following steps by running the above-mentioned computer program stored in the memory 601:
acquiring a work order number to be inquired;
determining each material to be inquired according to the work order number to be inquired;
inquiring each material to be inquired based on data of inventory materials and data of production line materials, wherein the production line materials are materials received by a production line;
and outputting a material shortage result of the material based on the query result.
Assuming that the foregoing is the first possible implementation manner, in a second possible implementation manner provided on the basis of the first possible implementation manner, the acquiring the work order number to be queried includes:
receiving an input purchaser code;
determining a buyer to be inquired based on the buyer code;
displaying all the operating order numbers related to the buyer to be inquired;
and receiving an input selection instruction, and determining the number of the work order to be inquired in all the opened work order numbers based on the selection instruction.
In a third possible implementation manner provided on the basis of the first possible implementation manner, the determining, according to the work order number to be queried, each material to be queried includes:
acquiring a bill of materials related to the work order number to be inquired according to the work order number to be inquired;
and determining each material to be inquired according to the bill of materials.
In a fourth possible implementation manner provided on the basis of the third possible implementation manner, the determining, by the bill of materials, each material to be queried includes:
obtaining each minimum sub item of the materials contained in the bill of materials;
and determining each material to be inquired based on each minimum sub-item.
In a fifth possible implementation manner provided on the basis of the first possible implementation manner, the outputting a material shortage result of the material based on the result of the query includes;
determining the materials which are short of the materials based on the query result;
and outputting the related information of the materials which are short through an EXCEL table, wherein the related information comprises material codes, material descriptions, short places, required quantity and/or inventory quantity of the materials which are short.
In a sixth possible implementation manner provided on the basis of the first possible implementation manner, the second possible implementation manner, the third possible implementation manner, the fourth possible implementation manner, or the fifth possible implementation manner, after the query-based result is output and the result of the shortage of the material is output, the processor 602 further implements the following steps when executing the computer program stored in the memory 601:
acquiring a user set associated with the work order number to be inquired;
and pushing the material shortage result to each user in the user set.
It should be noted that the electronic device may be a server or the like. Further, as shown in fig. 6, the electronic device may further include: one or more input devices 603 (only one shown in fig. 6) and one or more output devices 604 (only one shown in fig. 6). The memory 601, processor 602, input device 603, and output device 604 are connected by a bus 605.
It should be understood that in the embodiments of the present Application, the Processor 602 may be a Central Processing Unit (CPU), and the Processor may be other general-purpose processors, Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field-Programmable Gate arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components, or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The input device 603 may include a keyboard, a touch pad, a fingerprint sensor (for collecting fingerprint information of a user and direction information of the fingerprint), a microphone, etc., and the output device 604 may include a display, a speaker, etc.
Memory 601 may include both read-only memory and random-access memory, and provides instructions and data to processor 602. Some or all of memory 601 may also include non-volatile random access memory. For example, the memory 601 may also store device type information.
As can be seen from the above, according to the embodiment of the present application, the electronic device first obtains the work order number to be queried, then determines each material to be queried according to the work order number to be queried, and queries each material to be queried based on data of inventory materials and data of production line materials, where the production line materials are materials received by a production line, and finally outputs a material shortage result of the material based on a query result. In the scheme of the application, the work order number is used for inquiring, so that the redundancy of the lack inquiry result can be reduced to a certain extent; meanwhile, production line materials are considered during query, and accuracy of a lack material query result can be improved to a certain extent.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-mentioned division of the functional units and modules is illustrated, and in practical applications, the above-mentioned functions may be distributed as different functional units and modules according to needs, that is, the internal structure of the system may be divided into different functional units or modules to implement all or part of the above-mentioned functions. Each functional unit and module in the embodiments may be integrated in one processing unit, or each unit may exist alone physically, or two or more units are integrated in one unit, and the integrated unit may be implemented in a form of hardware, or in a form of software functional unit. In addition, specific names of the functional units and modules are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present application. The specific working processes of the units and modules in the system may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the above embodiments, the descriptions of the respective embodiments have respective emphasis, and reference may be made to the related descriptions of other embodiments for parts that are not described or illustrated in a certain embodiment.
Those of ordinary skill in the art would appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware or combinations of external device software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
In the embodiments provided in the present application, it should be understood that the disclosed system and method may be implemented in other ways. For example, the above-described system embodiments are merely illustrative, and for example, the division of the above-described modules or units is only one logical functional division, and in actual implementation, there may be another division, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, systems or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
The integrated unit may be stored in a computer-readable storage medium if it is implemented in the form of a software functional unit and sold or used as a separate product. Based on such understanding, all or part of the flow in the method of the embodiments described above may be implemented by a computer program, which may be stored in a computer readable storage medium and used by a processor to implement the steps of the embodiments of the methods described above. The computer program includes computer program code, and the computer program code may be in a source code form, an object code form, an executable file or some intermediate form. The computer-readable storage medium may include: any entity or device capable of carrying the above-described computer program code, recording medium, usb disk, removable hard disk, magnetic disk, optical disk, computer readable Memory, Read-Only Memory (ROM), Random Access Memory (RAM), electrical carrier wave signal, telecommunication signal, software distribution medium, etc. It should be noted that the computer readable storage medium may contain other contents which can be appropriately increased or decreased according to the requirements of the legislation and the patent practice in the jurisdiction, for example, in some jurisdictions, the computer readable storage medium does not include an electrical carrier signal and a telecommunication signal according to the legislation and the patent practice.
The above embodiments are only used for illustrating the technical solutions of the present application, and not for limiting the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; such modifications and substitutions do not substantially depart from the spirit and scope of the embodiments of the present application and are intended to be included within the scope of the present application.

Claims (6)

1. A material shortage query method is characterized by comprising the following steps:
acquiring a work order number to be inquired;
determining each material to be inquired according to the work order number to be inquired;
inquiring each material to be inquired based on data of inventory materials and data of production line materials, wherein the production line materials are materials received by a production line;
outputting a material shortage result of the material based on the query result;
the determining each material to be inquired according to the work order number to be inquired comprises the following steps:
acquiring a bill of materials related to the work order number to be inquired according to the work order number to be inquired;
determining each material to be queried according to the bill of materials, specifically: the bill of materials contains more than one father item, each father item further contains more than one son item, after the bill of materials is expanded, the inquiry of the materials is carried out according to the minimum son item of the expanded materials, so that the user can screen the materials in the bill of materials to determine each material to be inquired;
the acquiring of the work order number to be inquired comprises the following steps:
receiving an input purchaser code;
determining a buyer to be queried based on the buyer code;
displaying all the started work order numbers and corresponding work orders related to the buyer to be inquired, the work orders to be started and the corresponding work order numbers;
and receiving an input selection instruction, and determining the number of the work order to be inquired in all the opened work order numbers based on the selection instruction.
2. The starved material query method of claim 1, wherein outputting starved material results for the material based on the results of the query comprises;
determining the material which is short of the material based on the query result;
and outputting relevant information of the material which is short through an EXCEL table, wherein the relevant information comprises a material code, a material description, a material short place, a demand quantity and/or an inventory quantity of the material which is short.
3. The starved query method according to claim 1 or 2, further comprising, after outputting a starved result of the material based on the result of the query:
acquiring a user set associated with the work order number to be inquired;
and pushing the material shortage result to each user in the user set.
4. A starved material polling system, comprising:
the order number acquisition module is used for acquiring the number of the work order to be inquired;
the material determining module is used for determining each material to be inquired according to the work order number to be inquired;
the material query module is used for querying each material to be queried based on data of inventory materials and data of production line materials, wherein the production line materials are materials received by a production line;
the result output module is used for outputting the material shortage result of the material based on the query result;
the material determination module comprises:
the bill of material obtaining unit is used for obtaining a bill of material related to the work order number to be inquired according to the work order number to be inquired;
the to-be-queried material determining unit is used for determining each to-be-queried material according to the bill of materials, and specifically comprises the following steps: the bill of materials contains more than one father item, each father item further contains more than one son item, after the bill of materials is expanded, the inquiry of the materials is carried out according to the minimum son item of the expanded materials, so that the user can screen the materials in the bill of materials to determine each material to be inquired;
the single number acquisition module comprises:
a code receiving unit for receiving an input purchaser code;
the buyer determining unit is used for determining a buyer to be inquired based on the buyer code;
the order number display unit is used for displaying all the opened order numbers and corresponding work orders related to the buyer to be inquired, the work orders to be opened and the corresponding work order numbers;
and the sheet number selection unit is used for receiving an input selection instruction and determining the number of the work sheet to be inquired in all the opened work sheet numbers based on the selection instruction.
5. An electronic device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the steps of the method according to any of claims 1 to 3 are implemented when the computer program is executed by the processor.
6. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 3.
CN201811424688.0A 2018-11-27 2018-11-27 Lack material inquiring party, lack material inquiring system and electronic equipment Active CN109522334B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201811424688.0A CN109522334B (en) 2018-11-27 2018-11-27 Lack material inquiring party, lack material inquiring system and electronic equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201811424688.0A CN109522334B (en) 2018-11-27 2018-11-27 Lack material inquiring party, lack material inquiring system and electronic equipment

Publications (2)

Publication Number Publication Date
CN109522334A CN109522334A (en) 2019-03-26
CN109522334B true CN109522334B (en) 2021-07-27

Family

ID=65794424

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201811424688.0A Active CN109522334B (en) 2018-11-27 2018-11-27 Lack material inquiring party, lack material inquiring system and electronic equipment

Country Status (1)

Country Link
CN (1) CN109522334B (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110704471B (en) * 2019-10-21 2023-01-06 深圳市展祥通信科技有限公司 Material management method, material management system and electronic equipment
CN111858698B (en) * 2020-06-02 2024-03-08 深圳市鼎盛光电有限公司 Data checking method, data checking device and terminal equipment

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20020034267A (en) * 2000-10-31 2002-05-09 구자홍 Method for managing a material manufacturing number in internet server
CN1684077A (en) * 2004-04-17 2005-10-19 鸿富锦精密工业（深圳）有限公司 Material shortage inquiry system and method
CN101702209A (en) * 2009-10-30 2010-05-05 金蝶软件（中国）有限公司 Method for receiving material and device thereof
CN107368868A (en) * 2017-07-26 2017-11-21 山东鲁信天印务有限公司 A kind of product back-tracing method and system based on RFID
CN107766900A (en) * 2017-09-11 2018-03-06 深圳市共进电子股份有限公司 A kind of method, system and automation tools for printing bar code

Family Cites Families (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2002279244A (en) * 2001-03-19 2002-09-27 Juken Sangyo Co Ltd Simplified order receiving/placing method and system therefor
CN1459749A (en) * 2002-05-20 2003-12-03 英业达股份有限公司 Network type storage information inquiry system and method
US20030220853A1 (en) * 2002-05-22 2003-11-27 Andrew Back User interface for bill of materials
CN1996357A (en) * 2006-12-21 2007-07-11 上海交通大学 Dynamic production line modeling system integrated with information system based on real-time data acquisition
CN101706912A (en) * 2009-11-23 2010-05-12 浪潮集团山东通用软件有限公司 Sales order BOM-based method for tracking material and calculating material requirements
CN101706820A (en) * 2009-12-10 2010-05-12 金蝶软件（中国）有限公司 Storing method and device and query method and device of bill of materials
CN102567818A (en) * 2010-12-08 2012-07-11 金蝶软件（中国）有限公司 Method for generating order bill of material and system thereof
CN105069054A (en) * 2015-07-23 2015-11-18 孔凡勇 Material information query method and apparatus
CN106572186B (en) * 2016-11-10 2021-05-25 上海庆科信息技术有限公司 Production supervision method and system
CN107491916A (en) * 2017-08-08 2017-12-19 广州高专资讯科技有限公司 A kind of material distribution method and system for producing order
CN108364155A (en) * 2018-02-09 2018-08-03 东莞嘉泰钟表有限公司 The method for managing storage material using O/No. and name of material
CN108876244A (en) * 2018-06-22 2018-11-23 珠海格力电器股份有限公司 A kind of the storage inquiry system and method for bill of materials BOM

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20020034267A (en) * 2000-10-31 2002-05-09 구자홍 Method for managing a material manufacturing number in internet server
CN1684077A (en) * 2004-04-17 2005-10-19 鸿富锦精密工业（深圳）有限公司 Material shortage inquiry system and method
CN101702209A (en) * 2009-10-30 2010-05-05 金蝶软件（中国）有限公司 Method for receiving material and device thereof
CN107368868A (en) * 2017-07-26 2017-11-21 山东鲁信天印务有限公司 A kind of product back-tracing method and system based on RFID
CN107766900A (en) * 2017-09-11 2018-03-06 深圳市共进电子股份有限公司 A kind of method, system and automation tools for printing bar code

Also Published As

Publication number Publication date
CN109522334A (en) 2019-03-26

Similar Documents

Publication Publication Date Title
CN109978565B (en) Product packaging data management method and device, terminal equipment and readable storage medium
CN108846599A (en) A kind of method and device of logistics order management
CN109522334B (en) Lack material inquiring party, lack material inquiring system and electronic equipment
CN102314654A (en) Information push method and information push server
CN106326243A (en) Data processing method and apparatus
US11892817B2 (en) Methods and systems for ordering expedited production or supply of designed products
CN112348420A (en) Storage position information acquisition method and system, storage medium and electronic equipment
CN108959229A (en) Planning report generation method, terminal and storage medium based on customer information
CN110704486B (en) Data processing method, device, system, storage medium and server
CN115456739B (en) Data management method and related device
CN107679222A (en) Image processing method, mobile terminal and computer-readable recording medium
CN110874365A (en) Information query method and related equipment thereof
CN112258104A (en) Transfer information generation method, article transfer method, apparatus, device and medium
CN111553749A (en) Activity push strategy configuration method and device
CN111126923A (en) Material stagnation statistical method and device, storage medium and terminal equipment
CN111061733A (en) Data processing method and device, electronic equipment and computer readable storage medium
CN105677776A (en) Data processing method and device
CN114996369A (en) Method and device for constructing data warehouse index library
CN109739876B (en) Data query method and device for database based on Sqltoy-orm framework
CN113918728A (en) Industrial Internet post-service knowledge map analysis platform
CN109146421B (en) Cost analysis data page display method and device
CN112541645A (en) Data processing method and system along with vehicle product project development and related device
CN108121815B (en) Automobile part query method, device and system, electronic equipment and medium
CN110717807A (en) Commodity price determining method, device and equipment for purchase order
KR102432067B1 (en) Method and Server for Providing Web Service with Customer Compatibility using Matching Table related to Standardized Bill of Material

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant