CN112801621A - BOM bill of material sorting and approving method, system and computer readable storage medium - Google Patents
BOM bill of material sorting and approving method, system and computer readable storage medium Download PDFInfo
- Publication number
- CN112801621A CN112801621A CN202110131860.9A CN202110131860A CN112801621A CN 112801621 A CN112801621 A CN 112801621A CN 202110131860 A CN202110131860 A CN 202110131860A CN 112801621 A CN112801621 A CN 112801621A
- Authority
- CN
- China
- Prior art keywords
- materials
- abnormal
- information
- bom bill
- bill
- 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 312
- 238000000034 method Methods 0.000 title claims abstract description 44
- 230000002159 abnormal effect Effects 0.000 claims abstract description 86
- 230000005856 abnormality Effects 0.000 claims description 10
- 238000005538 encapsulation Methods 0.000 claims description 8
- 238000004806 packaging method and process Methods 0.000 claims description 7
- 239000000126 substance Substances 0.000 claims description 6
- 238000004590 computer program Methods 0.000 claims description 3
- 239000000203 mixture Substances 0.000 claims 1
- 239000002994 raw material Substances 0.000 claims 1
- 230000009286 beneficial effect Effects 0.000 abstract description 5
- 230000000694 effects Effects 0.000 abstract description 2
- 239000003990 capacitor Substances 0.000 description 4
- 238000010586 diagram Methods 0.000 description 2
- 238000000605 extraction Methods 0.000 description 2
- 238000013507 mapping Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 238000012937 correction Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012946 outsourcing Methods 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/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- 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
Abstract
The utility model relates to a BOM bill of material arrangement approval method, a system and a computer readable storage medium, wherein the arrangement approval method comprises the steps of obtaining information, and obtaining the bill information and the material information of the BOM bill of material; merging the same kind, merging the materials of the same kind with different numbers according to the material information; judging abnormal specifications, namely judging whether the BOM bill of materials has the abnormal specifications or not according to the model and filling specifications of the materials; a first warning is sent, if an abnormal specification exists, first warning information is sent, and the serial number of the material with the abnormal specification is output; a BOM bill of material arrangement approval system comprises an information acquisition module, a homogeneous merging module, an abnormal specification judgment module and a first warning module; and provides a computer-readable storage medium. Compared with the related art, the method and the device have the effect of being beneficial to improving the problem that errors easily occur in the material information of the BOM bill of material.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a method, a system, and a computer-readable storage medium for BOM bill of material sorting and approval.
Background
A BOM bill of materials, also known as a BOM table, is a file that describes the structure of a product in a data format. The BOM bill of materials can be identified by the computer and is a link for contacting and communicating various businesses of the enterprise. BOM bill of materials is the basic basis for computer to identify materials, the basis for planning, the basis for matching and receiving materials, the basis for tracking the processing process, the basis for purchasing and outsourcing, the basis for calculating the cost, the reference for quotation and the like.
In the production process of electronic products, the BOM bill of materials is also used to perform the work of purchasing, picking up and the like on the required electronic components. Generally, a plurality of types of electronic components with various specifications and models can be designed in one BOM bill of materials, so that when the BOM bill of materials is manufactured, filling errors or incomplete arrangement and the like are easily caused due to manual errors and the like, and the material information of the BOM bill of materials is easily wrong.
Disclosure of Invention
In order to help improve the problem that errors are prone to occur in bill of material (BOM) information, the application provides a BOM bill of material sorting and approving method, system and computer-readable storage medium.
In a first aspect, the present application provides a method for sorting and approving a bill of materials of a BOM, which adopts the following technical scheme:
a BOM bill of material arrangement approval method comprises,
acquiring information, namely acquiring list information and material information of a BOM bill of material, wherein the list information comprises a list number and the number of circuit boards, and the material information comprises a serial number, a model number, packaging, a filling specification, a position number, a material type, the using amount of a single board and the number;
merging the same kind, merging the materials of the same kind with different numbers according to the material information;
judging abnormal specifications, namely judging whether the BOM bill of materials has the abnormal specifications or not according to the model and filling specifications of the materials; and the number of the first and second groups,
and sending a first warning, if the abnormal specification exists, sending first warning information, and outputting the serial number of the material with the abnormal specification.
By adopting the technical scheme, after the bill information and the material information are obtained, the materials which belong to the same material but have different numbers are combined according to the material information, whether abnormal specifications exist is judged according to the model and filling specifications of the materials, if the abnormal specifications exist, the first warning information is sent to remind a user, and meanwhile, the numbers of the materials with the abnormal specifications are output, so that the user can find the corresponding materials according to the output numbers to correct, the BOM bill of materials is sorted, checked and calibrated, and the problem that errors easily occur in the material information of the BOM bill of materials is facilitated to be improved to a certain extent.
Optionally, the method further comprises the step of,
judging quantity abnormity, namely judging whether quantity abnormity exists in the BOM bill of material according to the quantity, the position number, the single board consumption and the quantity of the circuit boards;
and sending out a second warning, and if the quantity is abnormal, sending out second warning information.
By adopting the technical scheme, whether the quantity is abnormal or not is judged according to the quantity, the position number, the single board consumption and the quantity of the circuit boards, and if so, second warning information is sent out to remind a user that the quantity of the BOM bill of materials is abnormal, so that the user can correct the BOM bill of materials in time, and the problem that errors easily occur in the BOM bill of materials is further improved.
Optionally, the method for determining the quantity abnormality includes,
judging whether the number of the position of each material is matched with the using amount of the single board or not according to the number of the position and the using amount of the single board;
judging whether the quantity of each material is enough or not according to the quantity of the circuit boards, the using amount of the single boards and the quantity of the single boards; and the number of the first and second groups,
if there is no match and/or insufficient quantity, then there is a quantity exception.
By adopting the technical scheme, whether the number of the bits is matched with the using amount of the single boards is judged, and whether the number of the single boards is enough can be judged by combining the number of the circuit boards and the using amount of the single boards, so that whether the number of the single boards is abnormal or not can be judged conveniently.
Optionally, the method for issuing the second alarm further comprises,
and sending the material numbers and/or the material numbers with insufficient quantity which are not matched with the corresponding material numbers and the abnormal quantity types in a message mode, wherein the abnormal quantity types comprise mismatching and insufficient quantity.
By adopting the technical scheme, when the quantity is abnormal, the type with the abnormal quantity and the corresponding material number are sent out in the form of the message, so that a user can obtain the material number with the abnormal quantity and the corresponding type with the abnormal quantity according to the sent protection, and the correction can be pertinently carried out, thereby further being beneficial to improving the problem that the material information of the BOM bill of materials is easy to generate errors.
Optionally, the method of homogeneous merging includes,
obtaining materials of the same type with different numbers according to the position number;
the filling specification, the material type, the model and the encapsulation of materials with the same type and different numbers are compared in sequence, and if the materials are the same, the materials are the same; and the number of the first and second groups,
and combining the position numbers, the single plate usage amounts and the quantities of the materials of the same kind with different numbers, and numbering the materials of the BOM bill of materials again after the combination is finished.
By adopting the technical scheme, the similar materials are obtained according to the position numbers, the similar materials with different numbers are compared to obtain the same materials, the same materials are combined, and finally the combined BOM bill of materials is numbered again to realize the arrangement of the BOM bill of materials to a certain extent.
Optionally, the method for determining the abnormal specification includes,
acquiring actual specifications corresponding to the models according to the models of the materials, and judging whether the actual specifications of all the materials are consistent with the filling specifications; and the number of the first and second groups,
and if the actual specification of at least one part of material is not consistent with the filling specification, an abnormal specification exists in the BOM bill of materials.
By adopting the technical scheme, the actual specification is obtained according to the model, and whether the actual specification is consistent with the filling specification is judged, so that whether the abnormal specification exists is judged conveniently.
In a second aspect, the present application provides a BOM bill of material arrangement approval system, which adopts the following technical scheme:
a BOM bill of material arrangement approval system comprises an information acquisition module, a homogeneous merging module, an abnormal specification judgment module and a first warning module; wherein the content of the first and second substances,
the information acquisition module is used for acquiring the list information and the material information of a BOM bill of material, wherein the list information comprises a list number and the number of circuit boards, and the material information comprises a serial number, a model number, packaging, filling specifications, a position number, material types, single board usage and the number;
the same kind combining module is used for combining the same kind of materials with different numbers according to the material information;
the abnormal specification judging module is used for judging whether an abnormal specification exists in the BOM bill of materials according to the model and filling specification of the materials;
and the first warning module is used for sending first warning information if the abnormal specification exists and outputting the serial number of the material with the abnormal specification.
By adopting the technical scheme, after the information acquisition module obtains the list information and the material information, the same type merging module merges materials belonging to the same type and different numbers according to the material information, the abnormal specification judgment module judges whether the abnormal specification exists or not according to the model and the filling specification of the materials, the first warning module sends out the first warning information to remind a user when the abnormal specification exists, and simultaneously outputs the number of the materials with the abnormal specification, so that the user can find out the corresponding materials according to the output number to correct, so as to realize the sorting, checking and calibration of the BOM bill of materials, thereby being beneficial to improving the problem that the error easily occurs in the material information of the BOM bill of materials to a certain extent.
Optionally, the system further comprises a quantity abnormality judgment module and a second warning module; wherein the content of the first and second substances,
the quantity abnormity judging module is used for judging whether quantity abnormity exists in the BOM bill of materials according to the quantity, the position number, the single board consumption and the quantity of the circuit boards;
and the second warning module is used for sending out second warning information if the quantity is abnormal.
By adopting the technical scheme, the quantity abnormity judging module judges whether the quantity is abnormal according to the quantity, the bit number, the single board consumption and the quantity of the circuit boards, and the second warning module sends out second warning information when the quantity is abnormal so as to remind a user that the quantity of the BOM bill of materials is abnormal, so that the user can correct the BOM bill of materials in time, and the problem that errors easily occur in the material information of the BOM bill of materials is further facilitated to be improved.
Optionally, the homogeneous merging module includes a homogeneous material obtaining unit, a homogeneous material judging unit, and a merging unit; wherein the content of the first and second substances,
the similar material obtaining unit is used for obtaining materials with different numbers and the same type according to the position number;
the same material judging unit is used for sequentially comparing the filling specifications, the material types, the models and the encapsulation of the materials with the same type and different numbers, and if the filling specifications, the material types, the models and the encapsulation of the materials are the same, the materials are the same;
and the merging unit is used for merging the position numbers, the single plate use amounts and the quantity of the materials of the same kind with different numbers, and numbering the materials of the BOM bill of materials again after merging.
By adopting the technical scheme, the similar material obtaining unit obtains the similar materials according to the position numbers, the similar material judging unit compares the similar materials with different numbers to obtain the same materials, the combining unit combines the same materials, and finally the combined BOM bill of materials is numbered again to realize the arrangement of the BOM bill of materials to a certain extent.
In a third aspect, the present application provides a computer-readable storage medium, which adopts the following technical solutions:
a computer readable storage medium storing a computer program capable of being loaded by a processor and performing a method as in any one of the first aspects.
In summary, the present application includes at least one of the following beneficial technical effects:
1. according to the BOM bill of material arrangement approval method, materials with abnormal specifications in the BOM bill of material can be found out, meanwhile, uncombined same materials can be combined, arrangement, checking and calibration of the BOM bill of material are achieved, and therefore the method is beneficial to improving the problem that material information of the BOM bill of material is prone to errors to occur to a certain extent;
2. the utility model provides a BOM bill of material arrangement approval system, through the combined action of information acquisition module, the same kind merge module, unusual specification judge module and first warning module, realize arranging and check the calibration to BOM bill of material to help improving the problem that the material information of BOM bill of material appears the mistake easily to a certain extent.
Drawings
Fig. 1 is a first flowchart of a BOM bill of material sorting approval method according to an embodiment of the present application.
Fig. 2 is a second flowchart of a BOM bill of material sorting approval method according to an embodiment of the present application.
Fig. 3 is a third flowchart of a BOM bill of material sorting approval method according to an embodiment of the present application.
Fig. 4 is a fourth flowchart of a BOM bill of material sorting and approval method according to an embodiment of the present application.
Fig. 5 is a schematic structural diagram of a BOM bill of material arrangement approval according to an embodiment of the present application.
Fig. 6 is a schematic structural diagram of the same kind of merging module according to an embodiment of the present application.
Description of reference numerals: 201. an information acquisition module; 202. a homogeneous merging module; 2021. a homogeneous material obtaining unit; 2022. a homogeneous material judging unit; 2023. a merging unit; 203. an abnormal specification judging module; 204. a first warning module; 205. a quantity abnormality judgment module; 206. and the second warning module.
Detailed Description
The present application is described in further detail below with reference to figures 1-6.
The embodiment of the application discloses a BOM bill of material sorting and approval method. Referring to fig. 1, the BOM bill of material sorting approval method includes information acquisition 101, isomorphism merging 102, abnormal specification judgment 103, and first warning issue 104.
And acquiring information 101, and acquiring list information and material information of a BOM bill of material.
After the BOM bill of material is imported, the list information and the material information of the BOM bill of material can be identified and read through character extraction.
The BOM bill of materials is a bill of electronic components, and therefore the material information is the electronic component information. The list information comprises a list number and the number of circuit boards, and the material information comprises a number, a model, packaging, a filling specification, a position number, a material type, the using amount of the single board and the number.
Note that the bit numbers are the numbers of the electronic components, such as C1, C2, and C3, and refer to the first nonpolar capacitor C1, the second nonpolar capacitor C2, and the third nonpolar capacitor C3. Material classes, i.e. inline and patch elements. Generally, the amount of single board is less than or equal to the number of circuit boards.
And (4) merging the same materials with different numbers according to the material information 102.
The same material refers to a material with the same type, packaging, filling specification and material category.
And (5) judging whether an abnormal specification exists in the BOM bill of materials according to the model and the filling specification of the materials 103.
And filling the specification, namely, importing or manually filling the specification when the BOM bill of materials is manufactured. According to the model, the unique actual specification corresponding to the material (electronic component) can be obtained.
And a first warning is sent out 104, if the abnormal specification exists, first warning information is sent out, and the serial number of the material with the abnormal specification is output.
The first warning information includes but is not limited to any one or more of voice prompt, buzzing prompt or indicator light prompt. When the number of the material with the abnormal specification is output, the number may be output to a display interface for receiving the number of the material with the abnormal specification, along with a character of "abnormal specification" or a letter or a number representing "abnormal specification".
In the implementation mode of the sorting and approval method, the uncombined same-kind materials are combined, the serial numbers of the materials with abnormal specifications are output for being checked by a user (an auditor) to correct in time, and the sorting, checking and calibration of the BOM bill of materials are realized, so that the problem that errors are easy to occur in the material information of the BOM bill of materials is improved to a certain extent.
Referring to fig. 1, as a further embodiment of the collation approval method, a quantity abnormality judgment 105 and a second warning issuance 106 are further included.
And quantity abnormity judgment 105, which judges whether quantity abnormity exists in the BOM bill of material according to the quantity, the position number, the single board consumption and the quantity of the circuit boards.
And the second alarm is sent out 106, and if the quantity is abnormal, second alarm information is sent out.
Referring to fig. 2, an embodiment of the homology merge 102 includes step 1021, step 1022, and step 1023.
1021. And obtaining the materials with the same type and different numbers according to the position numbers.
The same type of material, i.e. the same type of electronic component, such as a resistor, a capacitor, an inductor, etc., is of one type. Therefore, the type of the material is easily obtained according to the position number, so that the same type of material can be further obtained.
1022. And comparing the filling specification, the material type, the model and the encapsulation of the materials with the same type and different numbers in sequence, wherein if the materials are the same, the materials are the same.
The comparison sequence of filling specification, material type, model and encapsulation can be changed at will.
1023. And combining the position numbers, the single plate usage amounts and the quantities of the materials of the same kind with different numbers, and numbering the materials of the BOM bill of materials again after the combination is finished.
It should be noted that the bit number and the bit number are combined, the board usage and the board usage are combined, the number and the number are combined, and the combination is performed in an addition manner.
The renumbered BOM bill of materials can be output or exported for subsequent work.
Referring to fig. 3, as one embodiment of the abnormal specification determination 103, steps 1031 and 1032 are included.
1031. And acquiring actual specifications corresponding to the models according to the models of the materials, and judging whether the actual specifications of all the materials are consistent with the filling specifications.
It should be noted that the actual specification may be pre-stored or may be obtained online according to the model. If the actual specification is pre-stored, the actual specification and the model are stored in a mapping relation, and therefore the corresponding actual specification can be called according to the model of the material.
1032. And if the actual specification of at least one part of material is not consistent with the filling specification, an abnormal specification exists in the BOM bill of materials.
The actual specification and the filled specification are not consistent, possibly due to model filling errors on the BOM bill of materials, and possibly filling specification errors.
Referring to fig. 4, as one embodiment of the quantity abnormality determination 105, step 1051, step 1052, and step 1053 are included.
1051. And judging whether the number of the bits of each material is matched with the using amount of the single board or not according to the number of the bits and the using amount of the single board.
And matching when the number of the digit is consistent with the using amount of the single board, otherwise, not matching. If the bit numbers are C1, C2 and C3, the number of the bit numbers is 3, the number of the single boards is 3, the single boards are matched, otherwise, the single boards are not matched.
1052. And judging whether the quantity of each material is enough or not according to the quantity of the circuit boards, the using amount of the single boards and the quantity of the single boards.
When the number is larger than or equal to the number of the circuit boards and the using amount of the single boards, the number of the materials is sufficient, otherwise, the number is not sufficient, and generally, when the number is larger than the number of the circuit boards and the using amount of the single boards, the number is sufficient. Therefore, when the number is less than or equal to the number of the circuit boards and the number of the single boards is used, the number of each material is insufficient.
The execution order of step 1051 and step 1052 may be changed or performed simultaneously.
1053. If there is no match and/or insufficient quantity, then there is a quantity exception.
The quantity is abnormal as long as there is unmatched material and/or material with insufficient quantity.
As an embodiment of the second alert issuance 106, the method of the second alert issuance 106 further comprises:
and sending out the material numbers and/or the material numbers with insufficient quantity and the abnormal quantity types which are not matched correspondingly in a message form.
The quantity exception type comprises mismatching and insufficient quantity, and when the quantity exception type is output in a message form, the quantity exception type corresponds to the material number one by one.
As an implementation manner of the second warning information, the second warning information includes any one or more of a voice prompt, a buzzing prompt and a light flashing prompt.
The BOM bill of material arrangement and approval method disclosed by the embodiment of the application is not only suitable for arrangement and approval of BOM bill of material related to electronic elements, but also suitable for arrangement and approval of other types of BOM bill of material after being properly adjusted.
The embodiment of the application also discloses a BOM bill of material arrangement approval system. Referring to fig. 5, the BOM bill of material sorting and approval system includes an information obtaining module 201, a same kind combining module 202, an abnormal specification determining module 203, and a first warning module 204.
The information obtaining module 201 is configured to obtain the list information and the material information of the BOM bill of materials.
The list information comprises a list number and the number of circuit boards, and the material information comprises a number, a model, packaging, a filling specification, a position number, a material type, the using amount of the single board and the number.
After the information obtaining module 201 obtains the BOM bill of materials by means of importing, faxing, scanning, etc., the list information and the material information of the BOM bill of materials can be read by means of character recognition and extraction.
And the same kind combining module 202 is used for combining the same kind of materials with different numbers according to the material information.
As an implementation of merging, the obtained BOM bill of materials is presented in the form of an EXCEL table, and the merging process is a process of merging cells 2023 after the sequence of rows or columns is changed.
And the abnormal specification judging module 203 is used for judging whether an abnormal specification exists in the BOM bill of materials according to the model and the filling specification of the materials.
The actual specifications corresponding to various types and models of various electronic components are stored in a local library or an online library in advance, and the types and the actual specifications are stored in a mapping relation. The abnormal specification judging module 203 can obtain the actual specification from the local library or the online library according to the model, and can skip to the webpage for searching to obtain the actual specification if the actual specification corresponding to the model does not exist in the local library or the online library. And judging whether the BOM bill of material has abnormal specification, namely judging whether the actual specification and the filling specification of the material are consistent.
The first warning module 204 is configured to send out first warning information if the abnormal specification exists, and output a serial number of the material with the abnormal specification.
It should be noted that when the serial numbers of the materials with abnormal specifications are output, the list numbers are output together, so that a user can conveniently find the corresponding BOM bill of materials according to the list numbers. In addition, when the number of the material with the abnormal specification is output, the number accompanied by the word of the "abnormal specification" or the letter or the number representing the "abnormal specification" may be output to a table for exclusively receiving the number of the material with the abnormal specification, and may be finally displayed on a display screen.
The first warning information includes, but is not limited to, any one of a voice prompt, a buzzer prompt or an indicator light prompt.
Referring to fig. 5, as a further embodiment of the finishing approval system, a quantity abnormality judgment module 205 and a second warning module 206 are further included. The quantity abnormality determining module 205 is configured to determine whether a quantity abnormality exists in the BOM bill of materials according to the number of the circuit boards, the bit number, the board usage amount, and the quantity. The second warning module 206 is configured to send out second warning information if the quantity is abnormal.
Referring to fig. 6, as an embodiment of the homogeneous merging module 202, the homogeneous merging module 202 includes a homogeneous material acquisition unit 2021, a homogeneous material judgment unit 2022, and a merging unit 2023.
The similar material obtaining unit 2021 is configured to obtain the same type of materials with different numbers according to the position number.
The homogeneous material determining unit 2022 is configured to compare filling specifications, material types, models, and packages of materials belonging to the same type and different numbers in sequence, and if the filling specifications, the material types, the models, and the packages are the same, the materials are the same.
The merging unit 2023 is configured to merge the position numbers, the board usage amounts, and the quantities of the materials of the same kind with different numbers, and after merging, re-number the materials in the BOM bill of materials.
The numbering can be carried out by using numbers, English letters, Greek letters and the like, and the BOM bill of materials after renumbering can be sent or exported.
One implementation mode of the BOM bill of material sorting and approving system comprises a single-board computer, a microcomputer, a programmable logic controller, a memory, a display screen, a loudspeaker and the like.
The BOM bill of material arrangement approval system disclosed in the embodiment of the application is not limited to arrangement and approval of BOM bill of material related to electronic components in application scenes, and is also suitable for arrangement and approval of other types of BOM bill of material through proper adjustment.
The embodiment of the application also discloses a computer readable storage medium, which stores a computer program capable of being loaded by a processor and executing any one method of BOM bill of material arrangement and approval methods.
The computer-readable storage medium includes, for example: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
The implementation principle of a BOM bill of material arrangement approval system in the embodiment of the application is as follows: after the information obtaining module 201 obtains the list information and the material information of the BOM bill of materials, the same-kind merging module 202 merges the obtained same-kind materials according to the material information. The abnormal specification judging module 203 judges whether the specification of each material is abnormal or not according to the model and the filling specification and by combining the actual specification, if so, the first warning module 204 sends out first warning information and outputs the serial number and the receipt number of the material with the abnormal specification. The quantity abnormality determining module 205 determines whether mismatch and/or insufficient quantity exists according to the material information such as the bit number, the model, the specification, the material category, and the like, and if so, sends out second warning information and outputs the number of the material with the abnormal quantity and the type of the abnormal quantity.
The above embodiments are preferred embodiments of the present application, and the protection scope of the present application is not limited by the above embodiments, so: all equivalent changes made according to the structure, shape and principle of the present application shall be covered by the protection scope of the present application.
Claims (10)
1. A BOM bill of material arrangement approval method is characterized in that: comprises the steps of (a) preparing a mixture of a plurality of raw materials,
the method comprises the steps that information acquisition (101) is carried out, and list information and material information of a BOM bill of material are acquired, wherein the list information comprises a list number and the number of circuit boards, and the material information comprises a serial number, a model number, packaging, filling specifications, a position number, material types, single board usage and the number;
the same kind is combined (102), and the materials of the same kind with different numbers are combined according to the material information;
judging whether an abnormal specification exists in the BOM bill of materials or not according to the model and filling specification of the materials (103); and the number of the first and second groups,
and a first warning is sent out (104), if the abnormal specification exists, first warning information is sent out, and the serial number of the material with the abnormal specification is output.
2. The BOM bill of material sorting and approval method of claim 1, wherein: also comprises the following steps of (1) preparing,
the quantity abnormity judgment (105) judges whether the quantity abnormity exists in the BOM bill of materials according to the quantity, the position number, the single board consumption and the quantity of the circuit boards;
and sending out a second warning (106), and if the quantity is abnormal, sending out second warning information.
3. The BOM bill of material sorting and approval method of claim 2, wherein: the method of the quantity abnormality judgment (105) includes,
judging whether the number of the position of each material is matched with the using amount of the single board or not according to the number of the position and the using amount of the single board;
judging whether the quantity of each material is enough or not according to the quantity of the circuit boards, the using amount of the single boards and the quantity of the single boards; and the number of the first and second groups,
if there is no match and/or insufficient quantity, then there is a quantity exception.
4. The BOM bill of material sorting and approval method of claim 3, wherein: the method of the second alert issuance (106) further comprises,
and sending the material numbers and/or the material numbers with insufficient quantity which are not matched with the corresponding material numbers and the abnormal quantity types in a message mode, wherein the abnormal quantity types comprise mismatching and insufficient quantity.
5. A BOM bill of material sorting approval method obtained according to claim 1, characterized in that: the method of homogeneous merging (102) includes,
obtaining materials of the same type with different numbers according to the position number;
the filling specification, the material type, the model and the encapsulation of materials with the same type and different numbers are compared in sequence, and if the materials are the same, the materials are the same; and the number of the first and second groups,
and combining the position numbers, the single plate usage amounts and the quantities of the materials of the same kind with different numbers, and numbering the materials of the BOM bill of materials again after the combination is finished.
6. The BOM bill of material sorting and approval method of claim 1, wherein: the method for determining the abnormal specification (103) comprises the following steps,
acquiring actual specifications corresponding to the models according to the models of the materials, and judging whether the actual specifications of all the materials are consistent with the filling specifications; and the number of the first and second groups,
and if the actual specification of at least one part of material is not consistent with the filling specification, an abnormal specification exists in the BOM bill of materials.
7. A BOM bill of material arrangement approval system which characterized in that: the system comprises an information acquisition module (201), a same kind combination module (202), an abnormal specification judgment module (203) and a first warning module (204); wherein the content of the first and second substances,
the information acquisition module (201) is used for acquiring the list information and the material information of a BOM bill of material, wherein the list information comprises a list number and the number of circuit boards, and the material information comprises a serial number, a model number, packaging, a filling specification, a position number, a material type, a single board using amount and the number;
the same kind combining module (202) is used for combining the same kind of materials with different numbers according to the material information;
the abnormal specification judging module (203) is used for judging whether an abnormal specification exists in the BOM bill of materials according to the model and filling specification of the materials;
and the first warning module (204) is used for sending out first warning information if the abnormal specification exists and outputting the serial number of the material with the abnormal specification.
8. The BOM bill of material finishing and approval system of claim 7, wherein: the system also comprises a quantity abnormity judgment module (205) and a second warning module (206); wherein the content of the first and second substances,
the quantity abnormity judging module (205) is used for judging whether quantity abnormity exists in the BOM bill of material according to the quantity, the position number, the single board consumption and the quantity of the circuit boards;
and the second warning module (206) is used for sending out second warning information if the quantity is abnormal.
9. The BOM bill of material finishing and approval system of claim 7, wherein: the homogeneous material combining module (202) comprises a homogeneous material acquiring unit (2021), a homogeneous material judging unit (2022) and a combining unit (2023); wherein the content of the first and second substances,
the homogeneous material obtaining unit (2021) is used for obtaining the same type of materials with different numbers according to the position number;
the homogeneous material judging unit (2022) is used for sequentially comparing filling specifications, material types, models and encapsulation of materials with the same type and different numbers, and if the filling specifications, the material types, the models and the encapsulation are the same, the materials are homogeneous;
and the merging unit (2023) is used for merging the position number, the single board usage amount and the number of the materials of the same type with different numbers, and numbering the materials of the BOM bill of materials again after merging.
10. A computer-readable storage medium characterized by: a computer program which can be loaded by a processor and which executes the method according to any of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110131860.9A CN112801621A (en) | 2021-01-30 | 2021-01-30 | BOM bill of material sorting and approving method, system and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110131860.9A CN112801621A (en) | 2021-01-30 | 2021-01-30 | BOM bill of material sorting and approving method, system and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112801621A true CN112801621A (en) | 2021-05-14 |
Family
ID=75813175
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110131860.9A Pending CN112801621A (en) | 2021-01-30 | 2021-01-30 | BOM bill of material sorting and approving method, system and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112801621A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113627168A (en) * | 2021-08-16 | 2021-11-09 | 深圳市云采网络科技有限公司 | Method, device, medium and equipment for checking component packaging conflict |
| CN113627851A (en) * | 2021-08-16 | 2021-11-09 | 深圳市云采网络科技有限公司 | Abnormal detection method and system for bill of material |
| CN113627136A (en) * | 2021-08-16 | 2021-11-09 | 深圳市云采网络科技有限公司 | Component recommendation method, device and system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104268699A (en) * | 2014-09-28 | 2015-01-07 | 浪潮(北京)电子信息产业有限公司 | Method for automatic inspection of bill of material (BOM) |
| CN109325730A (en) * | 2018-08-28 | 2019-02-12 | 四川九州电子科技股份有限公司 | A method of it supports that BOM is directly imported production system |
| KR20200097947A (en) * | 2019-02-11 | 2020-08-20 | 한국항공우주산업 주식회사 | Comparative analysis system and method of Bill Of Material |
-
2021
- 2021-01-30 CN CN202110131860.9A patent/CN112801621A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104268699A (en) * | 2014-09-28 | 2015-01-07 | 浪潮(北京)电子信息产业有限公司 | Method for automatic inspection of bill of material (BOM) |
| CN109325730A (en) * | 2018-08-28 | 2019-02-12 | 四川九州电子科技股份有限公司 | A method of it supports that BOM is directly imported production system |
| KR20200097947A (en) * | 2019-02-11 | 2020-08-20 | 한국항공우주산업 주식회사 | Comparative analysis system and method of Bill Of Material |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113627168A (en) * | 2021-08-16 | 2021-11-09 | 深圳市云采网络科技有限公司 | Method, device, medium and equipment for checking component packaging conflict |
| CN113627851A (en) * | 2021-08-16 | 2021-11-09 | 深圳市云采网络科技有限公司 | Abnormal detection method and system for bill of material |
| CN113627136A (en) * | 2021-08-16 | 2021-11-09 | 深圳市云采网络科技有限公司 | Component recommendation method, device and system |
| CN113627168B (en) * | 2021-08-16 | 2023-06-30 | 深圳市云采网络科技有限公司 | Method, device, medium and equipment for checking component packaging conflict |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112801621A (en) | BOM bill of material sorting and approving method, system and computer readable storage medium | |
| US10482541B2 (en) | VIN based insurance claim system | |
| CN107368765A (en) | A kind of packaging material batch can tracing management method and system | |
| CN106845930A (en) | One kind declaration data handling system | |
| CN109767242A (en) | Tracing Material method, system, computer equipment and storage medium based on two dimensional code | |
| CN106355375B (en) | A kind of automatic materiel affirmation method | |
| US20130197842A1 (en) | Streamlined parts approval process | |
| CN107730157A (en) | A kind of extraction of traditional Chinese medicine weighs allocator | |
| CN113722377A (en) | Method and system for building drug standard library | |
| CN111143278A (en) | Electronic assembly-based bill of material processing method, device, equipment and readable medium | |
| CN111522741A (en) | Interface test code generation method and device, electronic equipment and readable storage medium | |
| CN106897883A (en) | One kind automation commodity sampling observation method and system | |
| CN111813653A (en) | Data anomaly testing method and automatic testing tool related to field content | |
| CN115619091A (en) | Medicine industry material inspection release control method and device and storage medium | |
| CN111611465B (en) | Product detection system, method, device, computer equipment and storage medium | |
| CN106681850A (en) | Vehicle model calibration method and device | |
| CN111353284B (en) | Part diagram title bar filling method, system and storage medium | |
| US20210383039A1 (en) | Method and system for multilayer modeling | |
| CA3142579A1 (en) | Method and apparatus for validation of event tracking acquired data | |
| CN113469713A (en) | Block chain-based food data anti-counterfeiting tracing method and system | |
| CN106778394A (en) | Intelligent card data automatically writes method and system, intelligent card data automatic testing method and system | |
| CN111796907A (en) | Data checking method and device based on checking script, electronic equipment and medium | |
| CN108052405A (en) | Method and device for checking spatial data | |
| CN114528309A (en) | Data verification method and device based on database fine comparison | |
| CN107247646A (en) | The method and guiding flow of mainboard VR chip FW versions can be accurately positioned |
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 | ||
| CB02 | Change of applicant information |
Address after: 518000 401, building 33, Longwangmiao Industrial Zone, baishixia community, Fuyong street, Bao'an District, Shenzhen City, Guangdong Province Applicant after: SHENZHEN JIECHUANG ELECTRONIC TECHNOLOGY Co.,Ltd. Address before: 3 / F, building A1, A2, 15 Zhongxing Road, Kengzi street, Pingshan District, Shenzhen, Guangdong 518000 Applicant before: SHENZHEN JIECHUANG ELECTRONIC TECHNOLOGY Co.,Ltd. |
|
| CB02 | Change of applicant information |