CN111275314A - Method, device and equipment for generating bill of material and storage medium - Google Patents
Method, device and equipment for generating bill of material and storage medium Download PDFInfo
- Publication number
- CN111275314A CN111275314A CN202010053500.7A CN202010053500A CN111275314A CN 111275314 A CN111275314 A CN 111275314A CN 202010053500 A CN202010053500 A CN 202010053500A CN 111275314 A CN111275314 A CN 111275314A
- Authority
- CN
- China
- Prior art keywords
- materials
- bill
- current product
- determining
- process flow
- 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
- 239000000463 material Substances 0.000 title claims abstract description 493
- 238000000034 method Methods 0.000 title claims abstract description 163
- 238000003860 storage Methods 0.000 title claims abstract description 26
- 238000004364 calculation method Methods 0.000 claims abstract description 72
- 238000012545 processing Methods 0.000 claims description 19
- 239000013077 target material Substances 0.000 claims description 17
- 238000007726 management method Methods 0.000 claims description 14
- 238000004590 computer program Methods 0.000 claims description 4
- RYGMFSIKBFXOCR-UHFFFAOYSA-N Copper Chemical compound [Cu] RYGMFSIKBFXOCR-UHFFFAOYSA-N 0.000 description 31
- 229910052802 copper Inorganic materials 0.000 description 24
- 239000010949 copper Substances 0.000 description 24
- 238000004519 manufacturing process Methods 0.000 description 20
- 239000002609 medium Substances 0.000 description 19
- 238000007747 plating Methods 0.000 description 8
- 239000011889 copper foil Substances 0.000 description 7
- 239000000654 additive Substances 0.000 description 6
- 230000000996 additive effect Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 5
- 230000006870 function Effects 0.000 description 5
- 238000005520 cutting process Methods 0.000 description 4
- 230000003287 optical effect Effects 0.000 description 3
- 238000009713 electroplating Methods 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 239000002994 raw material Substances 0.000 description 2
- 229910000679 solder Inorganic materials 0.000 description 2
- ATJFFYVFTNAWJD-UHFFFAOYSA-N Tin Chemical compound [Sn] ATJFFYVFTNAWJD-UHFFFAOYSA-N 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000002860 competitive effect Effects 0.000 description 1
- 230000008021 deposition Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005553 drilling Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000002655 kraft paper Substances 0.000 description 1
- 238000010030 laminating Methods 0.000 description 1
- 238000003475 lamination Methods 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 239000012120 mounting media Substances 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 230000008707 rearrangement Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000005507 spraying Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000009897 systematic effect Effects 0.000 description 1
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/0633—Workflow analysis
-
- 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
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- 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—Information and communication technology [ICT] specially adapted for implementation of business processes of 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
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Marketing (AREA)
- General Physics & Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Business, Economics & Management (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Manufacturing & Machinery (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Educational Administration (AREA)
- Game Theory and Decision Science (AREA)
- General Factory Administration (AREA)
Abstract
The embodiment of the invention discloses a method, a device, equipment and a storage medium for generating a bill of materials. The method comprises the following steps: determining a material set required by the current product according to the corresponding relation between the process flow and the materials; determining the material consumption required by the current product according to the material codes of the materials in the material set, the material calculation formula and the corresponding material calculation parameters; and generating a bill of materials according to the process flow, the material codes and the material consumption of the current product. The technical scheme provided by the embodiment of the invention realizes the automatic calculation of the material consumption and the automatic generation of the bill of materials, thereby saving the labor cost, improving the accuracy of the calculation of the material consumption and further improving the accuracy of the cost accounting, the order quotation and the material planning.
Description
Technical Field
The embodiment of the invention relates to the technical field of data processing, in particular to a bill of material generation method, a bill of material generation device, a bill of material generation equipment and a storage medium.
Background
With the development of electronic information, the Printed Circuit Board (PCB) industry is more competitive, and enterprises need to control costs and improve efficiency from multiple aspects. The bill of materials is a file for recording the serial number, name, specification and other related attribute information of electronic components, so that enterprises can know various information of materials conveniently. As a link for connecting and communicating various businesses of an enterprise, the generation of a bill of materials is an important component of computer-aided enterprise production management.
In the prior art, the material usage is usually calculated by only using some simple formulas to obtain rough material usage data for the whole product, a material list is made by using the data, and meanwhile, the calculation process is usually completed manually, so that the problems of low calculation result accuracy and low calculation efficiency are caused, and a large amount of labor cost is wasted.
Disclosure of Invention
The embodiment of the invention provides a method, a device, equipment and a storage medium for generating a bill of materials, which are used for quickly and accurately generating the bill of materials.
In a first aspect, an embodiment of the present invention provides a method for generating a bill of materials, where the method includes:
determining a material set required by the current product according to the corresponding relation between the process flow and the materials;
determining the material consumption required by the current product according to the material codes of the materials in the material set, the material calculation formula and the corresponding material calculation parameters;
and generating a bill of materials according to the process flow, the material codes and the material consumption of the current product.
In a second aspect, an embodiment of the present invention further provides a bill of material generating apparatus, where the apparatus includes:
the material set determining module is used for determining a material set required by the current product according to the corresponding relation between the process flow and the material;
the material usage determining module is used for determining the material usage required by the current product according to the material codes of the materials in the material set, the material calculation formulas and the corresponding material calculation parameters;
and the bill of material generation module is used for generating a bill of material according to the process flow, the material code and the material consumption of the current product.
In a third aspect, an embodiment of the present invention further provides a computer device, where the computer device includes:
one or more processors;
a memory for storing one or more programs;
when executed by the one or more processors, cause the one or more processors to implement a method for bill of materials generation as provided by any of the embodiments of the invention.
In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the bill of material generation method provided in any embodiment of the present invention.
The embodiment of the invention provides a method for generating a bill of materials, which comprises the steps of determining a material set required by a current product according to the corresponding relation between a process flow and materials, determining the material consumption required by the current product according to a material code, a material calculation formula and corresponding material calculation parameters of each material in the material set, and generating the bill of materials according to the process flow, the material code and the material consumption of the current product. The automatic calculation of the material consumption and the automatic generation of the bill of materials are realized, so that the labor cost is saved, the accuracy of the calculation of the material consumption is improved, and the accuracy of cost accounting, order quotation and material planning is improved.
Drawings
Fig. 1 is a flowchart of a bill of material generation method according to an embodiment of the present invention;
FIG. 2 is a flowchart of a bill of materials generation method according to a second embodiment of the present invention;
fig. 3 is a schematic structural diagram of a bill of material generation apparatus according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of a computer device according to a fourth embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Before discussing exemplary embodiments in more detail, it should be noted that some exemplary embodiments are described as processes or methods depicted as flowcharts. Although a flowchart may describe the steps as a sequential process, many of the steps can be performed in parallel, concurrently or simultaneously. In addition, the order of the steps may be rearranged. The process may be terminated when its operations are completed, but may have additional steps not included in the figure. The processes may correspond to methods, functions, procedures, subroutines, and the like.
Example one
Fig. 1 is a flowchart of a bill of material generation method according to an embodiment of the present invention. The present embodiment is applicable to a situation where a bill of materials is generated by performing statistics on material types, material usage amounts, and process flows in advance when a product is manufactured, and the method may be executed by the bill of materials generating apparatus provided in the embodiment of the present invention, and the apparatus may be implemented by hardware and/or software, and may be generally integrated in a computer device. As shown in fig. 1, the method specifically comprises the following steps:
and S11, determining a material set required by the current product according to the corresponding relation between the process flow and the materials.
When a certain product is planned to be produced, a process flow required for producing the product needs to be confirmed, wherein the process flow is also called a processing flow or a production flow and refers to the whole process of continuously processing from raw material input to finished product output in sequence through certain production equipment or pipelines. The process flow is determined by the production technical conditions of enterprises and the production technical characteristics of products, and a complete process flow generally comprises a plurality of working procedures. For example, the process flow of Printed Circuit Board (PCB) production may include cutting, negative plating, lamination, drilling, copper deposition, solder resist, and tin spraying, among others.
In each process included in the process flow, various materials can be used, and in the production process of relatively mature products, the process flow and the materials have relatively fixed and uniform corresponding relations. For example, in the PCB manufacturing process, the material for the cutting process may include a board material, the material for the negative plating process may include a copper anode and a copper plating additive, and the material for the laminating process may include a prepreg, a copper foil, and kraft paper.
Optionally, the corresponding relationship between the process flow and the material may be generated according to a single product, or may be generated together according to a plurality of similar products. After the process flow of the product to be produced is determined, the materials required by each corresponding process can be searched according to the corresponding relation between the process flow and the materials, and all the required materials form a material set. Wherein, the materials in the material set can be represented by material names. And the units of all materials can be remarked respectively.
And S12, determining the material consumption required by the current product according to the material codes of the materials in the material set, the material calculation formula and the corresponding material calculation parameters.
The material code is a code for uniquely identifying the material, usually represented by a character string or a number, and is also a unique identification code of the computer system for the material. The material codes can be roughly divided into storage bit codes, technical figure numbers, classified adding line numbers, material attribute numbers and national standard adding specification numbers. By using the material codes, the efficiency of each department can be improved, the data of various materials can be quickly transmitted, and the accuracy of material data can be improved, so that the problems of multiple names of one object, multiple names of one object and disorder of names of the objects can be avoided.
The material codes are generally independent in different production industries, and may be different between different enterprises in the same industry. The material coding is generally set before the production of products, for example, in the processing process of the PCB, the copper clad laminate is the most main material, and the coding rule can be copper plate type + property + presence or absence of watermark + copper plate thickness + size + plate color, then the copper plate S1141 double-sided watermark 1.50mm 2/20Z 41 ". multidot.49" yellow material can be coded as CB01DY15000011, wherein the meaning of the digits specified from left to right of the coding is CB (material type), 01 (copper plate type), D (copper plate property), Y (presence or absence of watermark), 150 (copper plate thickness), 2 (copper plate thickness), 001 (copper plate size) and 1 (plate color). If the encoding rule of the copper foil can be copper foil thickness + copper foil width + supplier number, the copper foil 1OZ 16 can be encoded as CF101600001, wherein the left-to-right designation of the digits means CF (material type), 10 (copper foil thickness), 1600 (copper foil width), and 001 (supplier number).
After the material set required by the current product is determined, the material codes of all materials in the material set are determined according to a material code table generated by the selected material coding rule. And then determining the material consumption of each material required by each procedure corresponding to the material code in the process flow of the current product according to the set material calculation formula and the corresponding material calculation parameters in each material calculation formula.
And S13, generating a bill of materials according to the process flow of the current product, the material codes and the material usage.
Wherein, Bill of Materials (BOM) is a technical document describing the composition of products of enterprises, and in the processing capital industry, BOM indicates the structural relationship among the assembly, subassembly, component, part, raw material and the required quantity of the products. Optionally, the BOM in this embodiment is composed of a material code, a material usage amount, and a process flow. After the process flow of the current product, the material codes of the materials in the material set corresponding to the current product, and the material usage amounts of the materials required by the processes in the process flow of the current product are determined, the BOM can be generated in a table form.
On the basis of the above technical solution, optionally, the material calculation parameters include: fixed parameters, process parameters and decision table parameters; correspondingly, before determining the material usage amount required by the current product according to the material codes, the material calculation formulas and the corresponding material calculation parameters of the materials in the material set, the method further comprises the following steps: determining technological parameters according to the technological process and the processing requirements of the current product; the decision table parameters are determined based on process parameters and/or product requirements.
The fixed parameter refers to a parameter with a fixed value in the calculation process of the material usage, and generally refers to a relatively universal parameter with a certain standard coefficient and the like. In the PCB processing process, for calculating the using amount of the copper plating additive used for negative film electroplating, the copper plating additive coefficient depended on belongs to a fixed parameter in material calculation parameters.
The process parameters generally need to be determined according to the process flow and the processing requirements of the produced product, and for example, in the cutting process of PCB processing, in order to calculate the size and the amount of the board, the length of the production dimension and the width of the production dimension of the product, which depend on the process parameters, belong to the process parameters in the material calculation parameters. In different steps of the process flow, the same material may be used, but the same material is generally different, and in the process of processing, different processing requirements may be provided according to the requirements of actual products, which may include requirements of aperture, pad and ring width, line width and safety space, solder mask, and character height, etc. Therefore, in the process of producing the product, the process parameters are determined according to the actual process procedures and the specific processing requirements.
The decision table parameters generally need to be judged according to the determined process parameters and/or product requirements, for example, in the processing process of the PCB, the minimum copper hole thickness may be determined according to the product requirement of the IPC standard of the PCB, and the minimum copper hole thickness belongs to the decision table parameters in the material calculation parameters, and when the IPC 2 standard is used, the minimum copper hole thickness is 18um, and when the IPC 3 standard is used, the minimum copper hole thickness is 20 um. On the other hand, the value of the decision table parameter can be determined according to the above process parameters, and for example, after the production dimension length and the production dimension width are determined, the thickness of the copper hole can be adaptively determined according to the two process parameters. And determining the value of the parameter of the decision table according to the process parameter and the product requirement. The decision table is a table formed by the decision table parameters and the corresponding possible values which need to be determined according to the method.
Correspondingly, before calculating the material consumption of each material required by each procedure corresponding to the material code in the process flow of the current product by using the material calculation formula and the corresponding material calculation parameters, the process parameters are determined according to the process flow and the processing requirements of the current product, the decision table parameters are determined according to the process parameters and/or the product requirements, then the process parameters, the decision table parameters and the fixed parameters corresponding to the material calculation formula are used as the material calculation parameters, and the material consumption is calculated by using the material calculation formula. Optionally, the configuration of the material calculation parameters by the user may be received to obtain each material calculation parameter.
On the basis of the above technical solution, optionally, before determining the material set required by the current product according to the corresponding relationship between the process flow and the material, the method further includes: and acquiring the corresponding relation between the process flow configured by the user and the materials and the material calculation formula of each material in the corresponding relation.
The correspondence between the process flows and the materials includes a correspondence between each process in the process flows required for producing the products and the materials required to be used, and optionally, the correspondence may be a correspondence between the process flows and the materials individually included in each product, or a correspondence between all the process flows and the materials included in the same product. The corresponding relationship can be obtained and stored in a table form, so that materials required by each process of the process flow can be inquired in the table in the following process. The material calculation formula is a calculation formula configured for each material according to actual conditions according to a corresponding relation between a process flow and the material, and illustratively, in a material cutting procedure of the PCB processing, the calculation formula of the plate may be (production size length x production size width)/(large material size length x large material size width), and in a negative electroplating procedure of the PCB processing, the calculation formula of the copper plating additive may be (production size length x production size width) residual copper rate 1 x residual copper rate 2/copper plating additive coefficient. The material calculation formula can be correspondingly stored in the table of the corresponding relation so as to be convenient for searching.
On the basis of the above technical solution, optionally, after generating the bill of materials according to the process flow, the material code, and the material usage amount of the current product, the method further includes: and sending the generated bill of materials to an enterprise resource planning system to obtain a material plan and a cost accounting result of the current product.
The Enterprise Resource Planning system (ERP) is a management platform which is established on the basis of information technology and provides decision operation means for Enterprise decision-making layer employees with a systematic management idea. ERP integrates the characteristics of discrete production and flow production, faces to global markets, covers all leading and supporting capacities on a supply chain, coordinates all management departments of an enterprise to guide around the markets, more flexibly develops business activities, and responds to market demands in real time. The generated material list is sent to the ERP, so that the ERP is combined with the material list, the material usage of the current order is determined, a material plan is made, the material is controlled to be received, and meanwhile, the method can be used for financial cost accounting to improve the accuracy of quotation.
On the basis of the above technical solution, optionally, after generating the bill of materials according to the process flow, the material code, and the material usage amount of the current product, the method further includes: and sending the generated bill of materials to an enterprise management information system to obtain the order price of the current product.
An enterprise management information system (OMS) is enterprise management software that covers links such as purchase management, sales management, inventory management, electronic commerce, financial management, customer management, and trading partners. And the OMS is combined with the determined bill of materials, product parameters obtained from an engineering design system, the counted unit price of the materials and the like to complete automatic calculation of the order price according to a set quotation rule, so that the accuracy and the efficiency of calculating the order price are improved.
According to the technical scheme provided by the embodiment of the invention, the material set required by the current product is determined according to the corresponding relation between the process flow and the materials, the material consumption required by the current product is determined according to the material codes, the material calculation formulas and the corresponding material calculation parameters of the materials in the material set, and then the material list is generated according to the process flow, the material codes and the material consumption of the current product. The automatic calculation of the material consumption and the automatic generation of the bill of materials are realized, so that the labor cost is saved, the accuracy of the calculation of the material consumption is improved, and the accuracy of cost accounting, order quotation and material planning is improved.
Example two
Fig. 2 is a flowchart of a bill of material generation method according to a second embodiment of the present invention. The technical scheme of the embodiment is further refined on the basis of the technical scheme, and specifically, in the embodiment, a material priority rule is adopted to determine the unique material code corresponding to each material required by the current product. Correspondingly, as shown in fig. 2, the method specifically includes the following steps:
and S21, determining a material set required by the current product according to the corresponding relation between the process flow and the materials.
S22, acquiring material codes corresponding to all materials in the material set from a material library, and if at least one target material in the material set corresponds to more than two material codes, determining the only material code corresponding to the target material according to a material priority rule; the material priority rule comprises the priority of each material code judgment condition.
The material library may be a table for storing the corresponding relationship between the material name and the material code, so as to search the corresponding material code according to the material name. After the material set required by the current product is determined, the material codes corresponding to the materials in the material set can be searched from the material library. As described in the above embodiments, the material coding rule may be different between different enterprises, and there may be multiple codes for the same material in an enterprise. Therefore, different kinds of material codes need to be analyzed to determine the segment selection strategy.
And if at least one target material corresponding to more than two material codes exists in the determined material set, determining the unique material code corresponding to the target material according to the material priority rule. The material priority rule comprises the priority of each material code judgment condition. Specifically, the material coding range can be determined according to the material specification, and then the material can be selected by combining the priority of the information such as the material state and the material inventory. Illustratively, the priority of the material state is higher than that of the material stock in the purchasable state, that is, the material state is preferentially judged, if the material state corresponding to the unique material code exists in the material code range is valid, the unique material code is selected, and if the unique material code does not exist, the material state is further judged to be the purchasable state of the valid material code; if the purchasable state corresponding to the unique material code is positive, the unique material code is selected, if the unique material code does not exist, the material inventory condition of the material code with the purchasable state being positive is further judged, and the material code with the higher material inventory can be selected.
Optionally, after acquiring the material codes corresponding to the materials in the material set from the material library, the method further includes: and if each material in the material set corresponds to the unique target material code, determining the target material code as the material code of each material in the material set corresponding to the target material code. Specifically, the specification of the material used in some steps in the process flow is fixed and unique, and the material code of the material searched from the material library can be directly used as the material code of the corresponding material for generating the current product bill of materials, such as a copper plating additive.
And S23, determining the material consumption required by the current product according to the material codes of the materials in the material set, the material calculation formula and the corresponding material calculation parameters.
And S24, generating a bill of materials according to the process flow of the current product, the material codes and the material usage.
According to the technical scheme provided by the embodiment of the invention, the unique material codes corresponding to all materials required by the current product are determined by adopting the material priority rule, so that the uniqueness of the material codes in the bill of materials is realized, and more appropriate material codes are determined according to actual conditions in various possible material codes, so that the contents of the bill of materials are clearer and more definite.
EXAMPLE III
Fig. 3 is a schematic structural diagram of a bill of material generating apparatus according to a third embodiment of the present invention, where the apparatus may be implemented by hardware and/or software, and may be generally integrated in a computer device, and is used to execute the bill of material generating method according to any embodiment of the present invention. As shown in fig. 3, the apparatus includes:
the material set determining module 31 is configured to determine a material set required by a current product according to a corresponding relationship between a process flow and a material;
the material usage determining module 32 is configured to determine material usage required by a current product according to a material code, a material calculation formula, and corresponding material calculation parameters of each material in the material set;
and the bill of material generation module 33 is used for generating a bill of material according to the process flow, the material code and the material consumption of the current product.
According to the technical scheme provided by the embodiment of the invention, the material set required by the current product is determined according to the corresponding relation between the process flow and the materials, the material consumption required by the current product is determined according to the material codes, the material calculation formulas and the corresponding material calculation parameters of the materials in the material set, and then the material list is generated according to the process flow, the material codes and the material consumption of the current product. The automatic calculation of the material consumption and the automatic generation of the bill of materials are realized, so that the labor cost is saved, the accuracy of the calculation of the material consumption is improved, and the accuracy of cost accounting, order quotation and material planning is improved.
On the basis of the above technical solution, optionally, the bill of material generating device further includes:
the first material code determining module is used for acquiring material codes corresponding to all materials in the material set from the material library before determining the material consumption required by the current product according to the material codes, the material calculation formulas and the corresponding material calculation parameters of all the materials in the material set, and if at least one target material in the material set corresponds to more than two material codes, determining the unique material code corresponding to the target material according to a material priority rule; the material priority rule comprises the priority of each material code judgment condition.
On the basis of the above technical solution, optionally, the bill of material generating device further includes:
and the second material code determining module is used for determining the target material code as the material code of each material corresponding to the target material code in the material set if each material in the material set corresponds to the unique target material code after the material code corresponding to each material in the material set is obtained from the material library.
On the basis of the above technical solution, optionally, the material calculation parameters include: fixed parameters, process parameters and decision table parameters;
correspondingly, the bill of material generating device further comprises:
the process parameter determining module is used for determining process parameters according to the process flow and the processing requirements of the current product before determining the material consumption required by the current product according to the material codes, the material calculation formulas and the corresponding material calculation parameters of the materials in the material set;
and the decision table parameter determining module is used for determining the decision table parameters according to the process parameters and/or the product requirements.
On the basis of the above technical solution, optionally, the bill of material generating device further includes:
and the corresponding relation acquisition module is used for acquiring the corresponding relation between the process flow and the materials configured by the user and the material calculation formula of each material in the corresponding relation before determining the material set required by the current product according to the corresponding relation between the process flow and the materials.
On the basis of the above technical solution, optionally, the bill of material generating device further includes:
and the material plan obtaining module is used for generating a material list according to the process flow, the material code and the material consumption of the current product, and then sending the generated material list to the enterprise resource planning system so as to obtain a material plan and a cost accounting result of the current product.
On the basis of the above technical solution, optionally, the bill of material generating device further includes:
and the order price acquisition module is used for generating a material list according to the process flow, the material code and the material consumption of the current product and then sending the generated material list to the enterprise management information system so as to obtain the order price of the current product.
The bill of material generation device provided by the embodiment of the invention can execute the bill of material generation method provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects of the execution method.
It should be noted that, in the embodiment of the bill of material generating apparatus, each included unit and module are only divided according to functional logic, but are not limited to the above division as long as the corresponding function can be realized; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present invention.
Example four
Fig. 4 is a schematic structural diagram of a computer device according to a fourth embodiment of the present invention, which shows a block diagram of an exemplary computer device suitable for implementing the embodiment of the present invention. The computer device shown in fig. 4 is only an example, and should not bring any limitation to the function and the scope of use of the embodiments of the present invention. As shown in fig. 4, the computer apparatus includes a processor 41, a memory 42, an input device 43, and an output device 44; the number of the processors 41 in the computer device may be one or more, one processor 41 is taken as an example in fig. 4, the processor 41, the memory 42, the input device 43 and the output device 44 in the computer device may be connected by a bus or in other ways, and the connection by the bus is taken as an example in fig. 4.
The memory 42 is used as a computer readable storage medium for storing software programs, computer executable programs, and modules, such as program instructions/modules corresponding to the bill of material generation method in the embodiment of the present invention (for example, the material set determination module 31, the material usage determination module 32, and the bill of material generation module 33 in the bill of material generation apparatus). The processor 41 executes various functional applications and data processing of the computer device by executing software programs, instructions and modules stored in the memory 42, that is, implements the bill of material generation method described above.
The memory 42 may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created according to use of the computer device, and the like. Further, the memory 42 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 non-volatile solid state storage device. In some examples, memory 42 may further include memory located remotely from processor 41, which may be connected to a computer device over a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device 43 can be used to obtain the corresponding relationship between the process flow configured by the user and the material, the material calculation formula, and the like, and generate key signal input related to the user setting and function control of the computer device. Output device 44 may be configured to send the bill of materials to the enterprise resource planning system and the enterprise management information system, and may include a display device such as a display screen.
EXAMPLE five
An embodiment of the present invention further provides a storage medium containing computer-executable instructions, which when executed by a computer processor, perform a method for bill of material generation, the method including:
determining a material set required by the current product according to the corresponding relation between the process flow and the materials;
determining the material consumption required by the current product according to the material codes of the materials in the material set, the material calculation formula and the corresponding material calculation parameters;
and generating a bill of materials according to the process flow, the material codes and the material consumption of the current product.
Storage medium-any of various types of memory devices or storage devices. The term "storage medium" is intended to include: mounting media such as CD-ROM, floppy disk, or tape devices; computer system memory or random access memory such as DRAM, DDR RAM, SRAM, EDO RAM, Lanbas (Rambus) RAM, etc.; non-volatile memory such as flash memory, magnetic media (e.g., hard disk or optical storage); registers or other similar types of memory elements, etc. The storage medium may also include other types of memory or combinations thereof. In addition, the storage medium may be located in the computer system in which the program is executed, or may be located in a different second computer system connected to the computer system through a network (such as the internet). The second computer system may provide the program instructions to the computer for execution. The term "storage medium" may include two or more storage media that may reside in different locations, such as in different computer systems that are connected by a network. The storage medium may store program instructions (e.g., embodied as a computer program) that are executable by one or more processors.
Of course, the storage medium provided by the embodiment of the present invention contains computer-executable instructions, and the computer-executable instructions are not limited to the method operations described above, and may also perform related operations in the bill of material generation method provided by any embodiment of the present invention.
A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
From the above description of the embodiments, it is obvious for those skilled in the art that the present invention can be implemented by software and necessary general hardware, and certainly, can also be implemented by hardware, but the former is a better embodiment in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which may be stored in a computer-readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, and includes several instructions for enabling a computer device (which may be a personal computer, a server, or a network device) to execute the methods according to the embodiments of the present invention.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (10)
1. A bill of material generation method, comprising:
determining a material set required by the current product according to the corresponding relation between the process flow and the materials;
determining the material consumption required by the current product according to the material codes of the materials in the material set, the material calculation formula and the corresponding material calculation parameters;
and generating a bill of materials according to the process flow of the current product, the material codes and the material consumption.
2. The method of claim 1, wherein before determining the material usage required by the current product according to the material codes, the material calculation formulas and the corresponding material calculation parameters of the materials in the material collection, the method further comprises:
acquiring material codes corresponding to all materials in the material set from a material library, and if at least one target material in the material set corresponds to more than two material codes, determining a unique material code corresponding to the target material according to a material priority rule; the material priority rule comprises the priority of each material code judgment condition.
3. The method according to claim 2, wherein after the obtaining material codes corresponding to the materials in the material collection from the material library, the method further comprises:
and if each material in the material set corresponds to a unique target material code, determining the target material code as the material code of each material in the material set corresponding to the target material code.
4. The bill of material generation method of claim 1, wherein the material calculation parameters comprise: fixed parameters, process parameters and decision table parameters;
correspondingly, before determining the material usage amount required by the current product according to the material codes, the material calculation formulas and the corresponding material calculation parameters of the materials in the material set, the method further includes:
determining the technological parameters according to the technological process and the processing requirements of the current product;
determining the decision table parameters according to the process parameters and/or product requirements.
5. The method of claim 1, wherein before determining the set of materials required for the current product according to the correspondence between the process flow and the materials, the method further comprises:
and acquiring the corresponding relation between the process flow configured by the user and the materials and the material calculation formula of each material in the corresponding relation.
6. The bill of material generation method of claim 1, further comprising, after generating the bill of materials from the process flow, the material code, and the material usage of the current product:
and sending the generated bill of materials to an enterprise resource planning system to obtain a material plan and a cost accounting result of the current product.
7. The bill of material generation method of claim 1, further comprising, after generating the bill of materials from the process flow, the material code, and the material usage of the current product:
and sending the generated bill of materials to an enterprise management information system to obtain the order price of the current product.
8. A bill of material generation apparatus, comprising:
the material set determining module is used for determining a material set required by the current product according to the corresponding relation between the process flow and the material;
the material usage determining module is used for determining the material usage required by the current product according to the material codes of the materials in the material set, the material calculation formulas and the corresponding material calculation parameters;
and the bill of material generation module is used for generating a bill of material according to the process flow of the current product, the material code and the material consumption.
9. A computer device, comprising:
one or more processors;
a memory for storing one or more programs;
when executed by the one or more processors, cause the one or more processors to implement the bill of materials generation method as recited in any one of claims 1-7.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out a method for bill of material generation according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010053500.7A CN111275314A (en) | 2020-01-17 | 2020-01-17 | Method, device and equipment for generating bill of material and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010053500.7A CN111275314A (en) | 2020-01-17 | 2020-01-17 | Method, device and equipment for generating bill of material and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111275314A true CN111275314A (en) | 2020-06-12 |
Family
ID=71003514
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010053500.7A Pending CN111275314A (en) | 2020-01-17 | 2020-01-17 | Method, device and equipment for generating bill of material and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111275314A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111967217A (en) * | 2020-08-14 | 2020-11-20 | 上海弘快科技有限公司 | Design system capable of realizing electrical interconnection of schematic diagrams |
| CN112116288A (en) * | 2020-08-21 | 2020-12-22 | 苏州浪潮智能科技有限公司 | Method, system, equipment and medium for ensuring consistency of key parts |
| CN112183956A (en) * | 2020-09-10 | 2021-01-05 | 胜宏科技（惠州）股份有限公司 | System and method for creating engineering Inplan material by PCB |
| CN112837171A (en) * | 2021-01-12 | 2021-05-25 | 柏丽德珠宝(广州)有限公司 | Material information calculation method and device for ornament process flow |
| CN113487266A (en) * | 2021-07-23 | 2021-10-08 | 济南信邦信息工程有限公司 | Method, system, equipment and storage medium for automatically generating material codes and bill of materials of dynamic parameters |
| CN113793124A (en) * | 2021-09-17 | 2021-12-14 | 广东溢达纺织有限公司 | Bill of material generation method and device, computer equipment and storage medium |
| CN113868752A (en) * | 2021-12-02 | 2021-12-31 | 深圳小库科技有限公司 | Automatic generation method and device of indoor design, computer equipment and storage medium |
| CN113965985A (en) * | 2021-10-19 | 2022-01-21 | 软控股份有限公司 | Method and device for determining signal transmission power and display system |
| CN115170039A (en) * | 2022-09-07 | 2022-10-11 | 塬数科技(无锡)有限公司 | Supplier physical management method and device, storage medium and electronic equipment |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103106563A (en) * | 2013-02-05 | 2013-05-15 | 深圳杰科电器制造有限公司 | Method and device for generating dedicated bill of material for producing printed circuit board |
| CN107862436A (en) * | 2017-10-12 | 2018-03-30 | 深圳云集智造***技术有限公司 | Generation method, device, terminal and the computer-readable recording medium of BOM |
| CN108121874A (en) * | 2017-12-22 | 2018-06-05 | 大全集团有限公司 | A kind of bus parameter bill of materials and process route automatic generation method |
-
2020
- 2020-01-17 CN CN202010053500.7A patent/CN111275314A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103106563A (en) * | 2013-02-05 | 2013-05-15 | 深圳杰科电器制造有限公司 | Method and device for generating dedicated bill of material for producing printed circuit board |
| CN107862436A (en) * | 2017-10-12 | 2018-03-30 | 深圳云集智造***技术有限公司 | Generation method, device, terminal and the computer-readable recording medium of BOM |
| CN108121874A (en) * | 2017-12-22 | 2018-06-05 | 大全集团有限公司 | A kind of bus parameter bill of materials and process route automatic generation method |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111967217A (en) * | 2020-08-14 | 2020-11-20 | 上海弘快科技有限公司 | Design system capable of realizing electrical interconnection of schematic diagrams |
| CN112116288A (en) * | 2020-08-21 | 2020-12-22 | 苏州浪潮智能科技有限公司 | Method, system, equipment and medium for ensuring consistency of key parts |
| CN112116288B (en) * | 2020-08-21 | 2022-06-03 | 苏州浪潮智能科技有限公司 | Method, system, equipment and medium for ensuring consistency of key parts |
| CN112183956A (en) * | 2020-09-10 | 2021-01-05 | 胜宏科技（惠州）股份有限公司 | System and method for creating engineering Inplan material by PCB |
| CN112837171A (en) * | 2021-01-12 | 2021-05-25 | 柏丽德珠宝(广州)有限公司 | Material information calculation method and device for ornament process flow |
| CN113487266A (en) * | 2021-07-23 | 2021-10-08 | 济南信邦信息工程有限公司 | Method, system, equipment and storage medium for automatically generating material codes and bill of materials of dynamic parameters |
| CN113793124A (en) * | 2021-09-17 | 2021-12-14 | 广东溢达纺织有限公司 | Bill of material generation method and device, computer equipment and storage medium |
| CN113965985A (en) * | 2021-10-19 | 2022-01-21 | 软控股份有限公司 | Method and device for determining signal transmission power and display system |
| CN113965985B (en) * | 2021-10-19 | 2024-02-09 | 软控股份有限公司 | Signal transmitting power determining method, device and display system |
| CN113868752A (en) * | 2021-12-02 | 2021-12-31 | 深圳小库科技有限公司 | Automatic generation method and device of indoor design, computer equipment and storage medium |
| CN115170039A (en) * | 2022-09-07 | 2022-10-11 | 塬数科技(无锡)有限公司 | Supplier physical management method and device, storage medium and electronic equipment |
| CN115170039B (en) * | 2022-09-07 | 2023-08-18 | 塬数科技(无锡)有限公司 | Vendor material management method and device, storage medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111275314A (en) | Method, device and equipment for generating bill of material and storage medium | |
| Ching et al. | Industry 4.0 applications for sustainable manufacturing: A systematic literature review and a roadmap to sustainable development | |
| Dev et al. | Diffusion of green products in industry 4.0: Reverse logistics issues during design of inventory and production planning system | |
| Hooper et al. | Costing customer value: an approach for the agile enterprise | |
| US10061464B2 (en) | Distributed order orchestration system with rollback checkpoints for adjusting long running order management fulfillment processes | |
| US9269075B2 (en) | Distributed order orchestration system for adjusting long running order management fulfillment processes with delta attributes | |
| US20090198534A1 (en) | Governing A Service Oriented Architecture | |
| US20110218921A1 (en) | Notify/inquire fulfillment systems before processing change requests for adjusting long running order management fulfillment processes in a distributed order orchestration system | |
| US10789562B2 (en) | Compensation patterns for adjusting long running order management fulfillment processes in an distributed order orchestration system | |
| US20110218813A1 (en) | Correlating and mapping original orders with new orders for adjusting long running order management fulfillment processes | |
| US20110218925A1 (en) | Change management framework in distributed order orchestration system | |
| US20100138252A1 (en) | Governing Realizing Services In A Service Oriented Architecture | |
| CN103886438A (en) | Food safety unified monitoring platform and method | |
| CN104881758A (en) | ERP system capable of realizing integrated supply chain cooperative production and operation method thereof | |
| CN112669110A (en) | Server label management method and related equipment | |
| US10395205B2 (en) | Cost of change for adjusting long running order management fulfillment processes for a distributed order orchestration system | |
| Ulewicz et al. | Economic aspects of robotization of production processes by example of a car semi-trailers manufacturer | |
| CN113065776A (en) | Raw material management method and system | |
| CN101510278A (en) | Drill automatic matching business system and ERP system for integrating the business system | |
| US20110218926A1 (en) | Saving order process state for adjusting long running order management fulfillment processes in a distributed order orchestration system | |
| CN106487799A (en) | Facility information storage system based on cloud platform | |
| US10176446B2 (en) | System and method for inventory management, cost savings delivery and decision making | |
| CN117196484A (en) | Slurry distributing method, system, electronic equipment and storage medium | |
| Tirpak | Design-to-manufacturing information management for electronics assembly | |
| CN111626474A (en) | Data processing method and equipment based on manufacturing MES system |
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 |