CN110264137A - A kind of cost BOM generation method, computer and storage medium - Google Patents

A kind of cost BOM generation method, computer and storage medium Download PDF

Info

Publication number
CN110264137A
CN110264137A CN201910535708.XA CN201910535708A CN110264137A CN 110264137 A CN110264137 A CN 110264137A CN 201910535708 A CN201910535708 A CN 201910535708A CN 110264137 A CN110264137 A CN 110264137A
Authority
CN
China
Prior art keywords
list
bom
generation method
cost
data library
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
Application number
CN201910535708.XA
Other languages
Chinese (zh)
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.)
Sichuan Kangjia Intelligent Terminal Technology Co Ltd
Original Assignee
Sichuan Kangjia Intelligent Terminal 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 Sichuan Kangjia Intelligent Terminal Technology Co Ltd filed Critical Sichuan Kangjia Intelligent Terminal Technology Co Ltd
Priority to CN201910535708.XA priority Critical patent/CN110264137A/en
Publication of CN110264137A publication Critical patent/CN110264137A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • G06Q10/0875Itemisation or classification of parts, supplies or services, e.g. bill of materials
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/10Office automation; Time management

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • Strategic Management (AREA)
  • Economics (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Tourism & Hospitality (AREA)
  • Quality & Reliability (AREA)
  • Operations Research (AREA)
  • General Business, Economics & Management (AREA)
  • Marketing (AREA)
  • Data Mining & Analysis (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Development Economics (AREA)
  • Software Systems (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The present invention relates to a kind of cost BOM generation method, computer and storage medium, method includes: to receive database creation instruction, pre-establishes one-to-one correspondence in the material data library of material type;Source list derived from eda software is received, and creates the first list, the material data in source list is imported into the first list;Macro creation instruction or macro-call instruction are received, creation or calling BOM generate macro;Generated using BOM it is macro from the material information for searching material in the first list in material data library, and according to material information calculate material price.The present invention can generate the material in macro Auto-matching source list using BOM, and material information is obtained from material data library, to calculate required material price manufacturing cost BOM according to material information, it need not manually calculate, avoid the problem for the calculating mistake being likely to occur in artificial calculating process, traditional cost BOM generation method is solved in the product more applied to device, it is artificial to calculate the problem of time-consuming, easy error.

Description

A kind of cost BOM generation method, computer and storage medium
Technical field
The present invention relates to technical field of data processing, more particularly to a kind of cost BOM generation method, computer and storage Medium.
Background technique
BOM(Bill of Material) i.e. bill of materials, that is, the file of product structure described in data format, It is the product structure data file and ERP(Enterprise Resource Planning that computer can identify, enterprise Resource planning) system master document.BOM makes system identification product structure, and the knob of connection and communication enterprise's items business Band.The type of BOM in ERP system mainly includes 5 classes: formula of indenting BOM, the BOM summarized, counter being looked into BOM, cost BOM and meter Draw BOM.
Traditional cost BOM generation method be after the completion of principle diagram design, it is clear first with eda software generating device It is single, the information such as name of material, parameter and producer of our company are then manually corresponded according to device parameters or model, are returned Class, statistical magnitude, finally calculate price;In the product more applied to device, time-consuming and is easy error for artificial calculating.
As it can be seen that the existing technology needs to be improved and developed.
Summary of the invention
Based on this, it is necessary in view of the above technical problems, provide a kind of cost BOM generation method, computer and storage and be situated between Matter, it is intended to solve traditional cost BOM generation method in the product more applied to device, time-consuming for artificial calculating, is easy The problem of error.
Technical scheme is as follows:
A kind of cost BOM generation method comprising step:
Database creation instruction is received, pre-establishes one-to-one correspondence in the material data library of material type;
Source list derived from eda software is received, and creates the first list, the material data in the source list is imported into institute State the first list;
Macro creation instruction or macro-call instruction are received, creation or calling BOM generate macro;
Generated using BOM it is macro from the material information for searching material in first list in material data library, and according to the object Expect that information calculates material price.
In further preferred embodiment, the material data library include: material model, parameter of materials, spare part number, Material description, unit price and remarks.
In further preferred embodiment, the source list includes: material model and/or parameter of materials.
In further preferred embodiment, the source list further include: packaging information and position number.
It is described to believe from the material for searching material in first list in material data library in further preferred embodiment Breath, and material price is calculated according to the material information and is specifically included:
From the material information for searching material in first list in material data library, the material information include: material model, Parameter of materials and unit price;
According to the quantity of material corresponding in the unit price and the first list in the material information, the price of the material is calculated.
It is described to believe from the material for searching material in first list in material data library in further preferred embodiment Before the step of breath further include: merge the identical material of model in first list.
It is described by the step of identical material of model merges in first list in further preferred embodiment Before further include: delete the garbage in the first list.
It is described to believe from the material for searching material in first list in material data library in further preferred embodiment After the step of breath, the quantity of corresponding material, calculates the object in the unit price and the first list according in the material information Before the step of price of material further include: the format of setup cost BOM inventory.
A kind of computer comprising: it memory, processor and is stored on the memory and can be on the processor The cost BOM of operation generates program, and the cost BOM is generated when program is executed by the processor and realized cost as described above The step of BOM generation method.
A kind of storage medium, is stored thereon with computer program, wherein real when the computer program is executed by processor Now the step of cost BOM generation method as described above.
Compared with prior art, cost BOM generation method provided by the invention refers to comprising steps of receiving database creation It enables, pre-establishes one-to-one correspondence in the material data library of material type;Source list derived from eda software is received, and creates the Material data in the source list is imported first list by one list;It receives macro creation instruction or macro-call refers to It enables, creation or calling BOM generation are macro;It is generated using BOM macro from the object for searching material in first list in material data library Expect information, and material price is calculated according to the material information.Based on this, cost BOM generation method provided by the present invention can The material in macro Auto-matching source list is generated using BOM, and obtains material information from material data library, thus according to material Material price manufacturing cost BOM needed for information calculates, it is not necessary to it is artificial to calculate, avoid the meter being likely to occur in artificial calculating process The problem of calculating mistake solves traditional cost BOM generation method in the product more applied to device, and artificial calculating is time-consuming The problem of long, easy error.
Detailed description of the invention
Fig. 1 is the flow chart of cost BOM generation method in one embodiment.
Specific embodiment
In order to make the objectives, technical solutions, and advantages of the present invention clearer, with reference to the accompanying drawings and embodiments, right The present invention is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the present invention, not For limiting the present invention.
Artificial calculate tends to the problem of omission, miscount occur, and needs take a substantial amount of time and energy;If energy Replace artificial calculating process using automatic calculate, then it at least can be to avoid being easy the problem of error in calculating process, and it can be with Save time and efforts.
Based on above-mentioned thinking, the present invention provides a kind of cost BOM generation methods, as shown in Figure 1, itself comprising steps of
S100, database creation instruction is received, pre-establishes one-to-one correspondence in the material data library of material type.
That is, each type of material corresponds to a material data library, it is stored with and can identifies in material data library The information of the type material, the information should be enough to be matched that (i.e. the information should be comprising extremely with the material in source list A few identification high material attribute, such as material model, such as parameter of materials etc.).Further, the material data Library includes: that material model, parameter of materials, spare part number, material description, unit price and remarks, i.e. material data library pass through attribute: Material model, parameter of materials, spare part number, material description, unit price and remarks are defined a kind of material, in order to subsequent Material matching.
As the improvement of above preferred embodiment, the material data library should can update, that is, be added, delete, The operation such as modification, to guarantee the accuracy of subsequent material matching and calculation of price.
S200, source list derived from eda software is received, and creates the first list, by the material in the source list Data import first list.
EDA was the abbreviation of electric design automation (Electronics Design Automation), 60 years 20th century For mid-term from CAD (CAD), computer-aided manufacturing (CAM), computer aided testing (CAT) and computer aided manufacturing The concept development of assistant engineer's journey (CAE) and come.EDA technology be exactly using computer as tool, designer on eda software platform, With hardware description language Verilog HDL complete design file, logic compiling is then automatically completed by computer, abbreviation, is divided It cuts, integrate, optimize, be laid out, be routed and emulate, until under the adaptation compiling of specific objective chip, logical mappings and programming The work such as load.Common eda software have multiSIM7, PSPICE, OrCAD, PCAD, Protel, Viewlogic, Mentor, Graphics, Synopsys, LSIIogic, Cadence and MicroSim etc..
The source list is including at least one in material model and parameter of materials, it is preferred that the source list It further include packaging information and position number.
As the improvement of above preferred embodiment, the creation of first list can be described original in reception by computer It is automatically performed, can also be generated after receiving the first list creation instruction that staff issues by computer after inventory, it can be with Understand, the first list can also directly modify source list and obtain (modification operation such as adjustment format), for the first list Generation the present invention and be not specifically limited.
First list can be generated directly in software in cost BOM and be created, and can also be utilized and be connect by cost BOM generation software Mouthful call other programs complete, such as call Excel carry out table creation and hereinafter BOM generate macro use etc. operation.
S300, macro creation instruction or macro-call instruction are received, creation or calling BOM generate macro.
BOM generate it is macro can be pre-created (calculated, be pre-created at least according to the cost BOM that more often carries out It is macro that one dedicated BOM generates macro or at least one general BOM generation);It is also possible to the operational order according to staff, Temporarily create.
Further, the second list of creation is further comprised the steps of: before the S300.The BOM generation is macro to be created in institute State the second list.
S400, macro from the material information for searching material in first list in material data library, and root is generated using BOM Material price is calculated according to the material information.
It is preferred that it is described from the material information for searching material in first list in material data library, and according to institute Material information calculating material price is stated to specifically include:
From the material information for searching material in first list in material data library, the material information include: material model, Parameter of materials and unit price;
According to the quantity of material corresponding in the unit price and the first list in the material information, the price of the material is calculated.
Learn that unit price and quantity can calculate a kind of price of material, calculating or calculate one by one simultaneously can be by cost BOM Inventory.
Further, described before the step of searching the material information of material in first list in material data library Further include: the identical material of model in first list is merged.It first merges, then carries out material matching and price It calculates, process is more simple and efficient, and the cost BOM of generation is also easier to analyze.
It is described to merge the identical material of model in first list as the improvement of above preferred embodiment It is described before the step of searching the material information of material in first list in material data library after step further include: File in material data library is locally downloading from server, and to prevent network problem from influencing, material is searched or material is searched Situations such as being limited by network speed generation.
It is described from the step of searching the material information of material in first list in material data library specifically: in local Material data library in search the material information of material in first list.
Further, described also to be wrapped before the step of identical material of model merges in first list It includes: deleting the garbage in the first list.It may include the information not influenced on calculating cost in source list, especially Wherein influence the cost BOM information checking and analyze, during BOM generation macro creation can according to led using eda software It is configured the case where source list out.
It is preferred that it is described after the step of searching the material information of material in first list in material data library, it is described According to the quantity of material corresponding in the unit price and the first list in the material information, before the step of calculating the price of the material Further include: the format of setup cost BOM inventory.
After described the step of searching the material information of material in first list in local material data library, institute Before the step of stating the format of setup cost BOM inventory further include: delete local material data library, prevent computer resource unrestrained Take.
A kind of computer comprising: it memory, processor and is stored on the memory and can be on the processor The cost BOM of operation generates program, and the cost BOM is generated when program is executed by the processor and realized cost as described above The step of BOM generation method.
The present invention also provides a kind of storage mediums, are stored thereon with computer program, wherein the computer program quilt The step of processor realizes cost BOM generation method as described above when executing.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with Relevant hardware is instructed to complete by computer program, the computer program can be stored in a non-volatile computer In read/write memory medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein, To any reference of memory, storage, database or other media used in each embodiment provided by the present invention, Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM (PROM), electrically programmable ROM(EPROM), electrically erasable ROM(EEPROM) or flash memory.Volatile memory may include Random-access memory (ram) or external cache.By way of illustration and not limitation, RAM is available in many forms, Such as static state RAM(SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing Type SDRAM(ESDRAM), synchronization link (SyNchliNk) DRAM(SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
Each technical characteristic of above embodiments can be combined arbitrarily, for simplicity of description, not to above-described embodiment In each technical characteristic it is all possible combination be all described, as long as however, the combination of these technical characteristics be not present lance Shield all should be considered as described in this specification.
The embodiments described above only express several embodiments of the present invention, and the description thereof is more specific and detailed, but simultaneously It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art It says, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to protection of the invention Range.Therefore, the scope of protection of the patent of the invention shall be subject to the appended claims.

Claims (10)

1. a kind of cost BOM generation method, which is characterized in that comprising steps of
Database creation instruction is received, pre-establishes one-to-one correspondence in the material data library of material type;
Source list derived from eda software is received, and creates the first list, the material data in the source list is imported into institute State the first list;
Macro creation instruction or macro-call instruction are received, creation or calling BOM generate macro;
Generated using BOM it is macro from the material information for searching material in first list in material data library, and according to the object Expect that information calculates material price.
2. cost BOM generation method according to claim 1, which is characterized in that the material data library includes: material type Number, parameter of materials, spare part number, material description, unit price and remarks.
3. cost BOM generation method according to claim 2, which is characterized in that the source list includes: material model And/or parameter of materials.
4. cost BOM generation method according to claim 3, which is characterized in that the source list further include: encapsulation letter Breath and position number.
5. cost BOM generation method according to claim 4, which is characterized in that described to search institute from material data library The material information of material in the first list is stated, and material price is calculated according to the material information and is specifically included:
From the material information for searching material in first list in material data library, the material information include: material model, Parameter of materials and unit price;
According to the quantity of material corresponding in the unit price and the first list in the material information, the price of the material is calculated.
6. cost BOM generation method according to claim 5, which is characterized in that described to search institute from material data library Before the step of stating the material information of material in the first list further include: carry out the identical material of model in first list Merge.
7. cost BOM generation method according to claim 6, which is characterized in that described by model in first list Before the step of identical material merges further include: delete the garbage in the first list.
8. cost BOM generation method according to claim 7, which is characterized in that described to search institute from material data library After the step of stating the material information of material in the first list, in the unit price and the first list according in the material information The quantity of corresponding material, before the step of calculating the price of the material further include: the format of setup cost BOM inventory.
9. a kind of computer, which is characterized in that the computer includes: memory, processor and is stored on the memory And the cost BOM that can be run on the processor generates program, when the cost BOM generation program is executed by the processor The step of realizing cost BOM generation methods as described in any item such as claim 1-8.
10. a kind of storage medium, is stored thereon with computer program, which is characterized in that the computer program is held by processor It realizes when row such as the step of cost BOM generation method described in any item of the claim 1 to 8.
CN201910535708.XA 2019-06-20 2019-06-20 A kind of cost BOM generation method, computer and storage medium Pending CN110264137A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910535708.XA CN110264137A (en) 2019-06-20 2019-06-20 A kind of cost BOM generation method, computer and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910535708.XA CN110264137A (en) 2019-06-20 2019-06-20 A kind of cost BOM generation method, computer and storage medium

Publications (1)

Publication Number Publication Date
CN110264137A true CN110264137A (en) 2019-09-20

Family

ID=67919732

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910535708.XA Pending CN110264137A (en) 2019-06-20 2019-06-20 A kind of cost BOM generation method, computer and storage medium

Country Status (1)

Country Link
CN (1) CN110264137A (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111061770A (en) * 2019-12-27 2020-04-24 云汉芯城(上海)互联网科技股份有限公司 BOM model matching device and method, electronic equipment and storage medium
CN112116288A (en) * 2020-08-21 2020-12-22 苏州浪潮智能科技有限公司 Method, system, equipment and medium for ensuring consistency of key parts
CN112884413A (en) * 2021-03-02 2021-06-01 科世达(上海)机电有限公司 Method, system, equipment and storage medium for generating bill of material
CN113065881A (en) * 2020-01-02 2021-07-02 珠海格力电器股份有限公司 Method and device for calculating price of material, computer equipment and storage medium
CN113590669A (en) * 2021-07-29 2021-11-02 奇瑞汽车股份有限公司 Cost report generation method and device and computer storage medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102096727A (en) * 2009-12-15 2011-06-15 鸿富锦精密工业(深圳)有限公司 System and method for generating bill of materials
CN108388743A (en) * 2018-03-06 2018-08-10 深圳市图敏智能视频股份有限公司 A kind of bill of materials method for sorting
CN109754200A (en) * 2017-11-07 2019-05-14 深圳前海硬之城信息技术有限公司 Bill of material management method, apparatus and computer readable storage medium

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102096727A (en) * 2009-12-15 2011-06-15 鸿富锦精密工业(深圳)有限公司 System and method for generating bill of materials
CN109754200A (en) * 2017-11-07 2019-05-14 深圳前海硬之城信息技术有限公司 Bill of material management method, apparatus and computer readable storage medium
CN108388743A (en) * 2018-03-06 2018-08-10 深圳市图敏智能视频股份有限公司 A kind of bill of materials method for sorting

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
吴彩萍等: "临床试验数据人工审核清单的SAS宏实现", 中国临床药理学与治疗学, pages 38 - 42 *

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111061770A (en) * 2019-12-27 2020-04-24 云汉芯城(上海)互联网科技股份有限公司 BOM model matching device and method, electronic equipment and storage medium
CN113065881A (en) * 2020-01-02 2021-07-02 珠海格力电器股份有限公司 Method and device for calculating price of material, computer equipment and storage medium
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
CN112884413A (en) * 2021-03-02 2021-06-01 科世达(上海)机电有限公司 Method, system, equipment and storage medium for generating bill of material
CN113590669A (en) * 2021-07-29 2021-11-02 奇瑞汽车股份有限公司 Cost report generation method and device and computer storage medium
CN113590669B (en) * 2021-07-29 2024-03-29 奇瑞汽车股份有限公司 Method and device for generating cost report forms and computer storage medium

Similar Documents

Publication Publication Date Title
CN110264137A (en) A kind of cost BOM generation method, computer and storage medium
US10748092B2 (en) Systems and methods for creating intuitive context for analysis data
CN104537069B (en) A kind of document configuration and application system and its method
EP3726442A1 (en) Semantic modeling and machine learning-based generation of conceptual plans for manufacturing assemblies
CN106886406A (en) The generation method and device of exploitation code or document
CN107797819A (en) Delta package generation method, computer-readable recording medium and server
CN108255702A (en) A kind of test case creation method, apparatus, equipment and storage medium
US9524366B1 (en) Annotations to identify objects in design generated by high level synthesis (HLS)
CN112433701A (en) Industrial software development project implementation flow, content and code generation method and device
CN107239923A (en) Generate the method and device of Application for Materials
Krenczyk et al. ERP, APS and simulation systems integration to support production planning and scheduling
CN116069726B (en) Management method, equipment and medium of integrated circuit design library
CN110377620A (en) A kind of material searching method, computer and storage medium based on BOM tool
CN112612693A (en) Method, device and storage medium for automatically checking application software version
CN107256167A (en) The upgrade control method and upgrading control device migrated applied to application system
Yoshino et al. Requirements traceability management support tool for UML models
Krogstie Evaluating data quality for integration of data sources
US20220180033A1 (en) Identifying potential improvement opportunities for simulation performance of an integrated circuit design
CN113254455B (en) Dynamic configuration method and device of database, computer equipment and storage medium
CN115964927A (en) Method and system for determining predicted operation time for manufacturing operation
CN117573121B (en) Graphical custom insurance document template generation method
US11934800B2 (en) Generating metadata to facilitate code generation
US20230342538A1 (en) Model-driven approach for failure mode, effects, and diagnostic analysis (fmeda) automation for hardware intellectual property of complex electronic systems
CN117234466B (en) Enterprise management software development method, system, equipment and storage medium
US8769460B1 (en) Device recognition engine

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