TW201939377A - Order generation system for BOM table management quickly generating customized orders through adding by batch - Google Patents

Abstract

An order generation system for BOM table management comprises a BOM table order generation software built in a computer, the BOM table order generation software comprising a BOM adding/deducting option input unit and a BOM table order material part comparing unit. The BOM table adding/deducting option input unit has a built-in parent BOM table A0001, and a plurality of adding/deducting option material parts associated with the parent BOM table A0001, and an optional module. The parent BOM table A0001 is preset with a plurality of basic material parts having an additive connection relationship and a deductive connection relationship with each of the adding/deducting option material parts. The connection relationship between the adding/deducting material parts and the basic material parts includes that the optional module includes a plurality of sub-BOM tables, and the sub-BOM tables respectively include the added material parts, the deducted material parts, and a combination of the added/deducted material parts. Customized orders can be quickly generated through adding by batch.

Description

Order generation system managed by BOM

The present invention relates to the technical field of BOM (Bill of Material) table management, and in particular to an order generation system for BOM table management.

The machine tool manufacturing industry requires many and complex parts, and the production of BOM orders is relatively high. Therefore, the rapid production of the correct BOM and whether all parts can be purchased smoothly will affect whether the order can be delivered on time. key.

The current software on the market, in order to meet the customization requirements and can be quickly generated, will find a high similarity order to copy and then make customized modifications to meet the customized requirements of the product BOM. As shown in the first, second, and third situations in the tenth figure from top to bottom, situation one: A order of 100 parts selected by the parent table can meet the requirements, and the parent BOM table can be copied to become the BOM table one in operation To complete order A. Condition 2: The B order must meet the requirements with 100 parts selected by the parent table and some parts of the BOM table a. In operation, the parent BOM table can be copied and added (by manual check) to the BOM table a. BOM form 2 to complete the B order. Situation three: The order C can only meet the requirements with the 100 parts selected by the mother table, some parts of the BOM table a, and the BOM table b. In operation, you can copy the parent BOM table and then add it (by manually checking the operation). Parts of a and BOM table b become BOM table 3, and the C order can be completed.

By analogy, the D order must be manually checked to make the BOM table 4, and the E order must be manually checked to make the BOM table 5. ． ． BOM One zero one.

The operations described above can be summarized as the process shown in Figure 11. Each order is an independent BOM with independent specifications. When a product has more than one hundred material parts, it is manually adjusted according to demand. If you select the item of each item, the custom new BOM completed by the material parts must reselect each item in the parent BOM. Not only is it very time-consuming in operation, but it is also easy to cause human error, which is one of the shortcomings of the existing BOM management and order output operation.

In addition, as described above, when the parent BOM table is changed, a new parent BOM table needs to be reconstructed as the basic table. This causes a problem. In order to meet the needs of each customization, the basic The parent BOM table needs to be renamed to another parent BOM table, which will form a multiple growth of each parent BOM table for a long time, which makes it difficult to analyze and manage. This is the second disadvantage of the existing BOM table management and order output operation.

Moreover, once human error is caused, the lack of materials will delay the shipment date, and many losses will be incurred. This is the third shortcoming of the existing BOM management and order output operation.

Therefore, how to deal with the above-mentioned existing BOM management and order output operations are prone to human error, and the dilemma of the management of the multiple growth of each parent BOM, which is difficult to analyze and manage, and because of lack of materials and delays in shipment caused by losses The inventors have made improvements to solve the difficulties that the present invention intends to solve.

The main purpose of the present invention is to be able to select materials of different sub-BOMs according to different needs of customers to form a modular management operation, which can be immediately selected according to different needs of customers, and can quickly generate various customized orders, which is effective Avoid human error caused by lack of materials and delays in shipping.

A secondary objective of the present invention is to effectively pass on historical experience and avoid the dilemma of difficult analysis and management caused by the multiple growth of the parent BOM table. At the same time, it is compatible with the comparison of the BOM table order material parts comparison unit, which can facilitate cost estimation and further provide production management. and analyse.

In order to achieve the above-mentioned object and effect, the order generation system managed by the BOM table of the present invention includes a computer, a display unit with electrical connection, a recording unit, and a BOM order generation software.

The BOM order generation software includes a BOM table addition / deduction option input unit and a BOM table order material parts comparison unit, wherein the BOM table addition / deduction option input unit has a mother BOM table A0001 built in, and a BOM table with the parent BOM Table A0001 has a plurality of added / decreased option material parts and an optional module. The parent BOM table A0001 presets a plurality of basic material parts that have a connection relationship with each of the increased / decreased option material parts, each of which has an increase / decrease option. The connection relationship between the material part and the basic material part includes the addition item connection and the deduction item connection. The BOM table addition / deduction option input unit calls a plurality of basic material parts of the parent BOM table A0001 and displays them on the display unit. Any one of the basic materials Click on the part to pop up the plural increase / decrease options related to the material part and its plus and minus links. Click on the plus and minus links of each of the plural plus / minus option parts to add and subtract. The item is selected, and at least one order is generated and stored in the recording unit.

The optional module includes a plurality of sub-BOMs. The sub-BOMs respectively include added material parts, deducted material parts, and added / deducted material parts combinations to provide a whole set of selections for easy selection.配 操作。 With operation.

A further technical feature of the present invention is that the recording unit further records The price of each basic material part and each increase / decrease option material part.

A further technical feature of the present invention is that the BOM table order generation software further includes a BOM table order material parts comparison unit and is connected to the BOM table addition / deduction option input unit, and the BOM table order material parts comparison unit calls each order With all the increase / decrease option materials and parts, and the BOM order materials and parts comparison unit displays the basic material parts and the increase / decrease options materials and parts corresponding to each order on the display unit to compare the increase of each order / Minus the difference of the number of option material parts and cost estimation.

(10) ‧‧‧Computer

(11) ‧‧‧Display unit

(12) ‧‧‧Recording unit

(20) ‧‧‧BOM order generation software

(21) ‧‧‧BOM table addition / deduction option input unit

(22) ‧‧‧BOM table order material parts comparison unit

(211) ‧‧‧Female BOM A0001

(2111) ‧‧‧Basic Material Parts

(212) ‧‧‧Material parts

(213) ‧‧‧Additional link

(214) ‧‧‧Subtraction link

(215) ‧‧‧Optional Module

(2151) ‧‧‧ Sub BOM

(30) ‧‧‧Order

The first figure is a block diagram of the equipment system of the present invention.

The second figure is a schematic diagram of the pull operation of the input / output option input unit of the BOM table of the present invention.

The third figure is a schematic view of the parts of the mother BOM table A0001 of the present invention.

The fourth figure is a schematic diagram of an optional module of the present invention.

The fifth diagram is a schematic diagram of the order B produced by the present invention.

The sixth diagram is a schematic diagram of the order C produced by the present invention.

The seventh diagram is a schematic diagram of the order D produced by the present invention.

The eighth figure is a schematic diagram of different conditions of the output order of the present invention.

The ninth figure is a schematic diagram of the difference in the quantity of material parts in different orders compared with the material parts comparison unit in the BOM table of the present invention.

The tenth figure is a schematic diagram of different situations of the existing BOM management and order output operation.

The eleventh figure is a flow chart of the existing BOM management and order output operation.

In order to achieve the above-mentioned objects and effects, as well as the technical means and structure adopted by the present invention, the features and effects of the embodiments of the present invention will be described in detail with reference to the drawings.

Please refer to the first to fourth figures shown in the BOM table management order generation system of the present invention, which includes a computer (10), a display unit (11), a recording unit (12) and a BOM order with electrical connection. Generate software (20).

The BOM order generation software (20) includes a BOM form addition / deduction option input unit (21) and a BOM order order material parts comparison unit (22), wherein the BOM form addition / deduction option input unit (21) A mother BOM table A0001 (reference number 211 in the figure) with a plurality of basic material parts (2111, such as A1 ~ A10 ... J1 ~ J10 in the third figure, a total of 100), and a parent BOM table A0001 ( 211) There are a plurality of linked increase / decrease options (212, such as K1 ~ K10, L1 ~ L10, M1 ~ M10, N1 ~ N110 ...) in the third figure, and an optional module (215) , The parent BOM table A0001 (211) presets a plurality of basic material parts (2111) that are connected to each increase / decrease option material part (212), each increase / decrease option material part (212) and basic material part ( The link relationship of 2111) includes a plus item link (213) and a minus item link (214). The BOM table addition / deduction option input unit (21) calls the plural basic material parts (2111) of the parent BOM table A0001 (211). And displayed on the display unit (11), click on any of the basic material parts (2111) to pop up the plural increase / decrease options of the connection relationship. The material part (212) and its addition link (213) and decrease Item link (214), click on the plus item link (213) and the minus item link (214) of each of the plural increase / decrease option material parts (212) to select the plus item and the minus item, and generate at least one order ( 30, as shown by A, B, C ... in the first figure) and stored in the recording unit (12).

The optional module (215, as shown in the fourth figure) includes a plurality of sub-BOMs (2151), and the plurality of sub-BOMs (2151) respectively include added material parts, deducted material parts, and addition / deduction The combination of materials and parts is used to provide a whole set of selections, which is convenient for matching operations.

The foregoing is the main technical features of the main embodiment of the present invention, which corresponds to the content of the first item of the scope of the patent application for this case, and the purpose and implementation mode of the present invention can be known in detail. Detailed description or additional technical features of the first content of the scope of patent application, rather than limiting the scope of the first scope of patent application, it should be known that the first scope of the patent scope of this application does not necessarily include the scope of the rest of the patent application for subsidiary applications Technical characteristics.

The features of the components of the present invention are described in further detail below. In the first to third drawings, the recording unit further records the prices of each basic material part (2111) and each increase / decrease option material part (212). In addition, the BOM order generation software (20) further includes a BOM order material parts comparison unit (22) and is connected to the BOM list addition / deduction option input unit (21), the BOM order material parts comparison unit ( 22) Call each order (30) and all the increase / decrease option material parts (212), and the BOM order material parts comparison unit (22) displays the corresponding order (30) on the display unit (11) The number of basic material parts (2111) and increase / decrease option material parts (212) are used to compare the difference in the number of increase / decrease option material parts (212) for each order (30), and perform cost estimation.

As shown in the first to third figures, since the parent BOM table A0001 (211) of the present invention presets a plurality of basic material parts (2111) that have a connection relationship with each increase / decrease option material part (212), each increase / decrease Package of optional material parts (212) and basic material parts (2111) Containing plus item link (213) and minus item link (214), the BOM table addition / deduction option input unit (21) calls the plural basic material parts (2111) of the parent BOM table A0001 (211) and displays them on the display unit ( 11), click on any of the basic material parts (2111) to pop up the plural increase / decrease options that have a connection relationship. The material part (212) and its plus link (213) and subtract link (214) are added to each complex number. / Minus option material part (212) plus item link (213) and minus item link (214) Click to select plus and minus items, and generate at least one order (30) and store in the record unit (12 ).

As shown in the second to seventh figures, the optional module (215) of the present invention includes a plurality of sub-BOM tables (2151), and the plurality of sub-BOM tables (2151) respectively include added material parts and deducted material parts, And the combination of material parts added / deducted; by this way, the commonly used material parts combination is built into a structured relationship table, and the child BOM table (2151) that can be easily selected is composed, as shown in B0001 ~ B0007 in the fourth, The light bottom of the figure indicates the parts to be added, and the deep bottom indicates the parts to be reduced. The sub BOM table (2151) containing the combination of the part to be added and the part to be reduced is used to facilitate the use of the combined sub BOM (2151) ) Carry out the whole group selection, which is convenient for matching operation.

In accordance with the orders A, B, C, and D shown in the eighth figure, when order A requires only 100 basic material parts (2111, A1 ~ A10 ... J1 ~ J10, a total of 100) selected by the parent table ) Can meet the requirements; then the operation can be called as long as the mother BOM table A0001 (211) plural basic material parts (2111, A1 ~ A10 ... J1 ~ J10, a total of 100) apply, you can complete the order A . When the order B must be selected from the 100 basic material parts (2111, A1 ~ A10 ... J1 ~ J10) selected by the parent table, and L1, M1, N1 including B0004 in the child BOM table (2151) in the fourth figure Only the material parts (212) can be added and subtracted to meet the requirements; then the operation can be completed after the order A process is completed, and then through the addition link (213) to select the sub BOM (2151) of the increase / Adding the option material part (212), the order B can be completed (as shown in the fifth figure). When order C must be selected by the parent table, the 100 basic material parts (2111, A1 ~ A10 ... J1 ~ J10), and L1, M1, N1, etc. of B0004 in the child BOM table (2151) are added / removed. The optional material parts (212) and L3, L4 and other optional material parts (212) including B0005 in the sub-BOM (2151) can meet the requirements; as long as the operation is completed, the order B Add item link (213) and select the sub-BOM table (2151) to add the increase / decrease option material parts (212) such as L3, L4 of B0005 to complete order C (as shown in the sixth figure). When order D needs to add a child BOM table B0007 (2151, the parent BOM table A0001 must be subtracted from C2, D2, E2, and then L2) to the content of the original order C; then the operation can only meet the order After the C program, you can add the B0007 in the child BOM table (2151) through the addition link (213) to complete the order D (as shown in the seventh figure. According to this operation, through the mother BOM table A0001 and different combinations Combination of sub-BOMs (2151, B0001 ~ B0007 ...) can produce orders with various needs. Because the optional module (215) contains sub-components to be added and sub-components to be reduced. BOM table (2151), by which the commonly used materials and parts are combined into a structured relationship table, and a sub-BOM table (2151) can be conveniently selected to facilitate the integration of the sub-BOM table (2151) Plus selection for easy matching operation.

As described above, the operation of the BOM table increase / deduction option input unit (21) is like the concept of building block combination, and B0001 ~ B0007 increase / decrease option material parts (212) in different sub-BOM tables (2151) are selected according to different needs of customers. In order to form a modular management operation, it effectively simplifies the process and accelerates the output of customized orders.

As shown in the ninth figure, since the recording unit of the present invention further records the prices of each basic material part (2111) and each increase / decrease option material part (212), the BOM order The material parts comparison unit (22) further calls each order (30) through the electrically connected recording unit (12), and all the increase / decrease option material parts (212), and the BOM order material parts comparison unit ( 22) The display unit (11) displays the number of basic material parts (2111) and increase / decrease option material parts (212) corresponding to each order (30) (compared to order E, order F as shown in the figure) ) To immediately compare the difference in the number of material parts (212) for the increase / decrease options of each order (30), and immediately perform cost estimation.

As described above, the operation of the BOM table increase / deduction option input unit (21) of the present invention is similar to the concept of building block combination. According to different needs of customers, different (B0001 ~ B0007) increase / decrease option material parts in different sub BOM tables (2151) are selected. (212) Joined to form a modular management operation, which can definitely break through the current difficulties and shortcomings in BOM management and order output technology development, and achieve the following advantages:

1. Can be selected immediately according to the different needs of customers, and can quickly generate a variety of customized orders, effectively avoiding human-induced errors caused by lack of materials and delays incurred by the shipping date.

2. The module management operation is used to simplify the process and avoid the dilemma of difficult analysis and management caused by the multiple growth of the parent BOM table. At the same time, it inherits historical experience and cooperates with the comparison of the BOM table material parts comparison unit (22). Cost estimation and further provide production management and analysis.

Claims (3)

An order generation system managed by a BOM, including: a computer, a display unit with electrical connection, a recording unit, and a BOM order generation software; the BOM order generation software includes a BOM addition / deduction option input unit And a BOM order material parts comparison unit, in which the BOM table addition / deduction option input unit has a female BOM table A0001 and a plurality of increase / decrease option material parts linked to the parent BOM table A0001, and a selection Equipped with a module, the parent BOM table A0001 presets a plurality of basic material parts that have a connection relationship with each of the increase / decrease option material parts, and the connection relationship between each increase / decrease option material part and the basic material part includes an addition link and a decrease Item link, the BOM add / subtract option input unit calls out the plural basic material parts of the parent BOM table A0001 and displays them on the display unit. Click on any of the basic material parts to pop up the linked increase / decrease option material parts And its plus and minus links, click on the plus and minus links of each of the multiple increase / decrease options for material parts to select the plus and minus items, and Generate at least one order and store it in the record unit; the optional module includes a plurality of sub-BOMs, which respectively include added material parts, deducted material parts, and combinations of added / deducted material parts , Used to provide the entire group of selection, convenient selection operation. The order generation system managed by the BOM according to claim 1, wherein the recording unit further records the prices of each basic material part and each increase / decrease option material part. The BOM management order generation system as described in claim 2, wherein the BOM order generation software further includes a BOM order material parts comparison order Yuan and link the BOM increase / deduction option input unit, the BOM order material parts comparison unit calls each order and all the increase / decrease option material parts, and the BOM order material parts comparison unit is displayed on the display unit The number of basic material parts and increase / decrease option material parts corresponding to each order is used to compare the difference in the number of increase / decrease option material parts of each order, and to estimate the cost.