CN102096727A - System and method for generating bill of materials - Google Patents
System and method for generating bill of materials Download PDFInfo
- Publication number
- CN102096727A CN102096727A CN200910311454XA CN200910311454A CN102096727A CN 102096727 A CN102096727 A CN 102096727A CN 200910311454X A CN200910311454X A CN 200910311454XA CN 200910311454 A CN200910311454 A CN 200910311454A CN 102096727 A CN102096727 A CN 102096727A
- Authority
- CN
- China
- Prior art keywords
- bill
- spare part
- bom
- information
- wiring diagram
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method for generating a bill of materials, which comprises the following steps of: acquiring the component information of a wiring diagram to be designed; deriving a first bill of materials according to the component information; acquiring instant relevant information of each component in the wiring diagram to be designed; summarizing the acquired instant relevant information of components into the first bill of materials so as to generate a second bill of materials; rearranging the second bill of materials according to preset parameters; and converting the format of the second bill of materials so as to generate a plurality of standard bills of materials. The invention also provides a system for generating a bill of materials. By the method and the system, the throughput time of the bill of materials is shortened and the error rate of manual arrangement of the bill of materials is lowered.
Description
Technical field
The present invention relates to a kind of materials list generation system and method.
Background technology
For motherboard designers and production related personnel, (Bill of Materials, design has very important effect to Bill of Material (BOM) to auxiliary circuit for generation BOM) and classification.
Wiring diagram design tool OrCAD is the software that a cover is widely used in circuit design, and it can be carried out under Windows operating system, helps hardware designer to carry out circuit design, and generation BOM file carries out production management and warehousing management to transfer to make to hold.Particularly, hardware designer via information-based crossover tool, produces the BOM of a standard format or client's specified format by with OrCAD software and CIS database link.Wherein, the CIS database is failed the instant relevant information of spare part in the writing circuit design, cause up-to-date information that hardware designer can't obtain spare part immediately to choose suitably and spare part, make circuit design on time and price, lose ground with advantage.In addition, when different and needs of the client that may occur or to be designed wiring diagram corresponding product different by the supplier of part or assembly in the wiring diagram to be designed are replaced when expecting, needing the people is layout initial material inventory, or utilize OrCAD software to regenerate a or many parts of Bill of Material (BOM), take time and effort, and make mistakes easily.
Summary of the invention
In view of above content, be necessary to provide a kind of materials list generation system, can directly integrate and change the initial material inventory according to different suppliers' spare part, generate the many parts of standard Bill of Material (BOM) that meet procedure for producing, shortened the output time of Bill of Material (BOM) and reduced the error rate of people for the layout Bill of Material (BOM).
In view of above content, also be necessary to provide a kind of bill of material generating method, can directly integrate and change the initial material inventory according to different suppliers' spare part, generate the many parts of standard Bill of Material (BOM) that meet procedure for producing.
A kind of materials list generation system runs in the computing machine.This system comprises: initial material inventory generation module is used to obtain the spare part information of wiring diagram to be designed, and derives a first Bill of Material (BOM) according to described spare part information; Information remittance mould preparation piece is used for obtaining the instant relevant information of described each spare part of wiring diagram to be designed, and the instant relevant information of the spare part that obtained is converged whole to above-mentioned first Bill of Material (BOM), to upgrade the information of each spare part in this first Bill of Material (BOM), generate a second complete Bill of Material (BOM) with spare part up-to-date information; Parameter is provided with module and is used to receive the parameter that the deviser is provided with, and this parameter comprises the alternative material supplier corresponding with each spare part of spare part in the title, each wiring diagram corresponding client to be designed, each wiring diagram to be designed of wiring diagram to be designed; Reach the form modular converter and be used for rearranging described second Bill of Material (BOM), and this second Bill of Material (BOM) is carried out format conversion, generate the Bill of Material (BOM) of many parts of standards according to above-mentioned parameter.
A kind of bill of material generating method comprises the steps: to obtain the spare part information of wiring diagram to be designed; Derive a first Bill of Material (BOM) by the wiring diagram design software according to described spare part information; Obtain the instant relevant information of each spare part in the described wiring diagram to be designed; The instant relevant information of the spare part that obtained is converged whole to above-mentioned first Bill of Material (BOM), upgrading the information of each spare part in this first Bill of Material (BOM), and generate a second Bill of Material (BOM) thus; Rearrange this second Bill of Material (BOM) according to preset parameters, wherein, described parameter comprises the alternative material supplier corresponding with each spare part of spare part in the title, each wiring diagram corresponding client to be designed, each wiring diagram to be designed of wiring diagram to be designed; And this second Bill of Material (BOM) is carried out format conversion, to generate the Bill of Material (BOM) of many parts of standards.
Compared to prior art, described materials list generation system and method, can directly integrate the initial material inventory according to different suppliers' spare part, and the initial material inventory is edited and changed according to pre-set parameter, generate the many parts of standard Bill of Material (BOM) that meet procedure for producing, shortened Bill of Material (BOM) the output time, reduced the error rate of people for the layout Bill of Material (BOM).
Description of drawings
Fig. 1 is the running environment figure of materials list generation system preferred embodiment of the present invention.
Fig. 2 is the functional block diagram of Bill of Material (BOM) generation unit shown in Figure 1.
Fig. 3 is the process flow diagram of bill of material generating method preferred embodiment of the present invention.
The main element symbol description
| Computing machine | 1 |
| The part management server | 2 |
| Management of |
3 |
| OrCAD |
10 |
| The Bill of Material (BOM) |
12 |
| The CIS |
20 |
| The |
30 |
| Initial material |
120 |
| Information remittance |
122 |
| Parameter is provided with |
124 |
| |
126 |
| First Bill of Material (BOM) | 100 |
| Second Bill of Material (BOM) | 200 |
| The Bill of Material (BOM) of standard | 300 |
Embodiment
As shown in Figure 1, be Bill of Material (BOM) of the present invention (Bill of Materials, BOM) the running environment figure of generation system preferred embodiment.Part management server 2 and management of product server 3 that this running environment figure comprises computing machine 1, links to each other with this computing machine 1 by network.In the present embodiment, this network can be LAN (Local Area Network).
Wherein, the wiring diagram design software of a product is installed in the computing machine 1, as OrCAD software 10, and a Bill of Material (BOM) generation unit 12.A parts information management (Component Information System is arranged in the part management server 2, CIS) database 20, this CIS database 20 is used for storing the spare part information of symbol and each wiring diagram of each wiring diagram, this spare part information such as spare part attribute, the pairing supplier of spare part etc.Spare part in the present embodiment comprises part and assembly.
A product information management is arranged in the management of product server 3, and (Product Data Management, PDM) system 30.This PDM system 30 is used to store the instant relevant information of spare part, the instant relevant information of described spare part comprises spare part processing procedure Notification of Changes, price competitiveness and the suggestion of product trend etc., spare part and its information of being advised as the spare part information and the product trend of spare part information after changing, desirable price.This PDM system 30 also is used for the management of product development process with the technological document of product-related data, comprises special project file management, spare part attribute management, cad documents management, product structure management, authority setting management.
Described Bill of Material (BOM) generation unit 12 comprises that initial material inventory generation module 120, information remittance mould preparation piece 122, parameter are provided with module 124 and format converting module 126, as shown in Figure 2.The alleged module of the present invention is to finish the computer program code segments of a specific function, be more suitable in describing the implementation of software in computing machine than program, therefore below the present invention to all describing in the software description with module.
Described initial material inventory generation module 120 is used for obtaining from CIS database 20 the spare part information of wiring diagram to be designed, and utilizes OrCAD software 10 to derive a first Bill of Material (BOM) 100 according to described spare part information.
Described information remittance mould preparation piece 122 is used for obtaining from PDM system 30 the instant relevant information of each spare part the described wiring diagram, and the instant relevant information of the spare part that obtained is converged whole to above-mentioned first Bill of Material (BOM) 100, to upgrade the information of each spare part in this first Bill of Material (BOM) 100, generate a second Bill of Material (BOM) 200, have the up-to-date information of each spare part in this second Bill of Material (BOM) 200.In the present embodiment, the instant relevant information of described spare part comprises spare part processing procedure Notification of Changes, price competitiveness and the suggestion of product trend.Particularly, the instant relevant information of described spare part comprises the spare part information of spare part information after changing, desirable price and spare part that product trend is advised and its information etc.
Described parameter is provided with module 124 and is used to receive the parameter that the deviser is provided with, and this parameter comprises the alternative material supplier corresponding with each spare part of spare part in the title, each wiring diagram corresponding client to be designed, each wiring diagram to be designed of wiring diagram to be designed.Described format converting module 126 is used for rearranging described second Bill of Material (BOM) 200 according to above-mentioned parameter, and this second Bill of Material (BOM) 200 is carried out format conversion, generates the Bill of Material (BOM) 300 of many parts of standards.
Particularly, present embodiment is for the procedure for producing of the printed circuit board (PCB) that caters to different product such as different manufacturers, described format converting module 126 needs second Bill of Material (BOM) 200 is converted to the Bill of Material (BOM) 300 of many parts of standards of production unit approval, the Bill of Material (BOM) 300 of these many parts of standards has been put down in writing the spare part tabulation of a plurality of wiring diagram corresponding client to be designed, each wiring diagram to be designed, and the supplier of each spare part.
In addition, the Bill of Material (BOM) 300 of described many parts of standards can be a plurality of Bill of Material (BOM) files, or is stored in the same Bill of Material (BOM) file with the form of a plurality of Work Lists.
As shown in Figure 3, be the process flow diagram of bill of material generating method preferred embodiment of the present invention.
Step S1, initial material inventory generation module 120 obtains the spare part information of wiring diagram to be designed from CIS database 20.
Step S3, initial material inventory generation module 120 utilize OrCAD software 10 to derive a first Bill of Material (BOM) 100 according to described spare part information.
Step S5, information remittance mould preparation piece 122 obtains the instant relevant information of each spare part in the described wiring diagram to be designed from PDM system 30, for example, information is converged mould preparation piece 122 obtain the spare part information of spare part information after changing, desirable price and spare part that product trend is advised and its information etc. from PDM system 30.
Step S7, information is converged mould preparation piece 122 and is converged the instant relevant information of the spare part that obtained among the step S5 whole to above-mentioned first Bill of Material (BOM) 100, to upgrade the information of each spare part in this first Bill of Material (BOM) 100, generate a second Bill of Material (BOM) 200 with spare part up-to-date information.
Step S9, format converting module 126 is provided with in parameter according to the deviser that preset parameters rearranges this second Bill of Material (BOM) 200 in the module 124, wherein, described parameter comprises the alternative material supplier corresponding with each spare part of spare part in the title, each wiring diagram corresponding client to be designed, each wiring diagram to be designed of wiring diagram to be designed.
Step S11,126 pairs of these second Bill of Material (BOM) 200 of format converting module are carried out format conversion, with the Bill of Material (BOM) 300 that generates many parts of standards.Particularly, format converting module 126 is provided with the parameter that is provided with in the module 124 according to parameter, with spare part data input corresponding in second Bill of Material (BOM) 200 to worksheet, for example, the Bill of Material (BOM) that the wiring diagram of different product is corresponding different, this different Bill of Material (BOM) is the Bill of Material (BOM) 300 of above-mentioned many parts of standards, and it can be a plurality of worksheets in the same Bill of Material (BOM) file, or is respectively a Bill of Material (BOM) file.
It should be noted that at last, above embodiment is only unrestricted in order to technical scheme of the present invention to be described, although the present invention is had been described in detail with reference to preferred embodiment, those of ordinary skill in the art is to be understood that, can make amendment or be equal to replacement technical scheme of the present invention, and not break away from the spirit and scope of technical solution of the present invention.
Claims (10)
1. a bill of material generating method is characterized in that, this method comprises:
Obtain the spare part information of wiring diagram to be designed;
Derive a first Bill of Material (BOM) according to described spare part information;
Obtain the instant relevant information of each spare part in the described wiring diagram to be designed;
The instant relevant information of the spare part that obtained is converged whole to above-mentioned first Bill of Material (BOM), upgrading the information of each spare part in this first Bill of Material (BOM), and generate a second Bill of Material (BOM) thus;
Rearrange this second Bill of Material (BOM) according to preset parameters, wherein, described parameter comprises the alternative material supplier corresponding with each spare part of spare part in the title, each wiring diagram corresponding client to be designed, each wiring diagram to be designed of wiring diagram to be designed; And
This second Bill of Material (BOM) is carried out format conversion, to generate the Bill of Material (BOM) of many parts of standards.
2. bill of material generating method as claimed in claim 1 is characterized in that, described spare part information is stored in the parts information management database, and this spare part information comprises spare part attribute and the pairing supplier of spare part in each wiring diagram.
3. bill of material generating method as claimed in claim 1, it is characterized in that, the instant relevant information of described spare part is stored in the product information management system, and this product information management system also is used for the management of product development process with the technological document of product-related data.
4. bill of material generating method as claimed in claim 1 is characterized in that, the instant relevant information of described spare part comprises spare part processing procedure Notification of Changes, price competitiveness and the suggestion of product trend.
5. bill of material generating method as claimed in claim 1 is characterized in that, the Bill of Material (BOM) of described many parts of standards is a plurality of Bill of Material (BOM) files, or is stored in the same Bill of Material (BOM) file with the form of a plurality of worksheets.
6. a materials list generation system runs in the computing machine, it is characterized in that, this materials list generation system comprises:
Initial material inventory generation module is used to obtain the spare part information of wiring diagram to be designed, and utilizes the wiring diagram design software to derive a first Bill of Material (BOM) according to described spare part information;
Information remittance mould preparation piece, be used for obtaining the instant relevant information of described each spare part of wiring diagram to be designed, and the instant relevant information of the spare part that obtained is converged whole to above-mentioned first Bill of Material (BOM), to upgrade the information of each spare part in this first Bill of Material (BOM), generate a second complete Bill of Material (BOM) with spare part up-to-date information;
Parameter is provided with module, is used to receive the parameter that the deviser is provided with, and this parameter comprises the alternative material supplier corresponding with each spare part of spare part in the title, each wiring diagram corresponding client to be designed, each wiring diagram to be designed of wiring diagram to be designed; And
Format converting module is used for rearranging described second Bill of Material (BOM) according to above-mentioned parameter, and this second Bill of Material (BOM) is carried out format conversion, generates the Bill of Material (BOM) of many parts of standards.
7. materials list generation system as claimed in claim 6 is characterized in that, described spare part information is stored in the parts information management database, and this spare part information comprises spare part attribute and the pairing supplier of spare part in each wiring diagram.
8. materials list generation system as claimed in claim 6, it is characterized in that, the instant relevant information of described spare part is stored in the product information management system, and this product information management system also is used for the management of product development process with the technological document of product-related data.
9. materials list generation system as claimed in claim 6 is characterized in that, the instant relevant information of described spare part comprises spare part processing procedure Notification of Changes, price competitiveness and the suggestion of product trend.
10. materials list generation system as claimed in claim 6 is characterized in that, the Bill of Material (BOM) of described many parts of standards is a plurality of Bill of Material (BOM) files, or is stored in the same Bill of Material (BOM) file with the form of a plurality of worksheets.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910311454XA CN102096727A (en) | 2009-12-15 | 2009-12-15 | System and method for generating bill of materials |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910311454XA CN102096727A (en) | 2009-12-15 | 2009-12-15 | System and method for generating bill of materials |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102096727A true CN102096727A (en) | 2011-06-15 |
Family
ID=44129822
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200910311454XA Pending CN102096727A (en) | 2009-12-15 | 2009-12-15 | System and method for generating bill of materials |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102096727A (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103093038A (en) * | 2012-12-31 | 2013-05-08 | 深圳市九洲电器有限公司 | Updating method and updating device for bills of material (BOMs) |
| CN105205038A (en) * | 2015-09-18 | 2015-12-30 | 昆山龙腾光电有限公司 | Complete material list table generation method and device |
| CN106462749A (en) * | 2014-04-25 | 2017-02-22 | 西门子公司 | Method for automatically establishing a data record characterizing two technical drawings |
| CN106570668A (en) * | 2016-11-02 | 2017-04-19 | 深圳效率科技有限公司 | Bill-of-materials (BOM) information organizing method and BOM information organizing device |
| CN106779909A (en) * | 2016-11-21 | 2017-05-31 | 金蝶软件（中国）有限公司 | Material matching process and device |
| CN108121874A (en) * | 2017-12-22 | 2018-06-05 | 大全集团有限公司 | A kind of bus parameter bill of materials and process route automatic generation method |
| CN110059121A (en) * | 2019-03-12 | 2019-07-26 | 广州明珞汽车装备有限公司 | A kind of method, system, device and the storage medium of quick export bill of materials |
| CN110264137A (en) * | 2019-06-20 | 2019-09-20 | 四川康佳智能终端科技有限公司 | A kind of cost BOM generation method, computer and storage medium |
| CN112884413A (en) * | 2021-03-02 | 2021-06-01 | 科世达(上海)机电有限公司 | Method, system, equipment and storage medium for generating bill of material |
| CN114462363A (en) * | 2021-12-23 | 2022-05-10 | 北京方鸿智能科技有限公司 | Electronic component summary table generation method, tool and electronic equipment |
-
2009
- 2009-12-15 CN CN200910311454XA patent/CN102096727A/en active Pending
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103093038A (en) * | 2012-12-31 | 2013-05-08 | 深圳市九洲电器有限公司 | Updating method and updating device for bills of material (BOMs) |
| CN103093038B (en) * | 2012-12-31 | 2016-07-06 | 深圳市九洲电器有限公司 | The update method of a kind of BOM and device |
| CN106462749A (en) * | 2014-04-25 | 2017-02-22 | 西门子公司 | Method for automatically establishing a data record characterizing two technical drawings |
| CN105205038A (en) * | 2015-09-18 | 2015-12-30 | 昆山龙腾光电有限公司 | Complete material list table generation method and device |
| CN106570668A (en) * | 2016-11-02 | 2017-04-19 | 深圳效率科技有限公司 | Bill-of-materials (BOM) information organizing method and BOM information organizing device |
| CN106779909A (en) * | 2016-11-21 | 2017-05-31 | 金蝶软件（中国）有限公司 | Material matching process and device |
| CN108121874A (en) * | 2017-12-22 | 2018-06-05 | 大全集团有限公司 | A kind of bus parameter bill of materials and process route automatic generation method |
| CN110059121A (en) * | 2019-03-12 | 2019-07-26 | 广州明珞汽车装备有限公司 | A kind of method, system, device and the storage medium of quick export bill of materials |
| CN110059121B (en) * | 2019-03-12 | 2021-09-03 | 广州明珞汽车装备有限公司 | Method, system, device and storage medium for rapidly exporting bill of materials |
| CN110264137A (en) * | 2019-06-20 | 2019-09-20 | 四川康佳智能终端科技有限公司 | A kind of cost BOM generation method, computer and storage medium |
| CN112884413A (en) * | 2021-03-02 | 2021-06-01 | 科世达(上海)机电有限公司 | Method, system, equipment and storage medium for generating bill of material |
| CN114462363A (en) * | 2021-12-23 | 2022-05-10 | 北京方鸿智能科技有限公司 | Electronic component summary table generation method, tool and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102096727A (en) | System and method for generating bill of materials | |
| CN102087726A (en) | System for generating bill of materials and method thereof | |
| CN102298739A (en) | Method for changing bill of materials (BOM) and apparatus thereof | |
| CN108090073B (en) | Configurable bill of material conversion method and device | |
| CN110543303B (en) | Visual service platform | |
| CN103678648B (en) | A kind of BOM table sort aggregation system and method thereof | |
| CN103593456B (en) | Worksheet self-defining method for designing and device | |
| CN103926894A (en) | Furniture making method and system and control device | |
| US20180004881A1 (en) | Circuit design system and circuit design method | |
| CN113557517A (en) | Automatic generation device and method of electrical design drawing | |
| KR101886985B1 (en) | Information system construction support tool and information system construction support program | |
| CN105205038A (en) | Complete material list table generation method and device | |
| CN103164573A (en) | Product data management (PDM) design system | |
| CN103926895A (en) | Furniture making method and system and control device | |
| CN102004954A (en) | Product information system and information integration method of product design system | |
| CN102591808B (en) | System and method for DCS (distributed control system) hardware configuration based on Excel | |
| CN102023859B (en) | Digital development environment-oriented software integration method with reliability, maintainability and supportability | |
| CN102033512B (en) | Automatic cutting system and cutting method thereof | |
| CN105404613B (en) | XLS data export methods and system based on SAP platforms | |
| JP2008009590A (en) | Production management system, production management method, and storage medium for storing production management program for executing production management method | |
| US20040181506A1 (en) | System and method for sorting bills of material | |
| CN111338587A (en) | Custom printing WED system | |
| CN101500040A (en) | Configurable flow scheduling and section selection method based on arbitrarily spreading attribute specification | |
| CN110069516A (en) | A kind of service content intelligent management Implementation Technology based on normative document | |
| CN103699605A (en) | Automatic CKD (completely knock down)/SKD (semi knock down) inventory generation method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20110615 |