Multi-system material mixing operation method and device

Abstract

The present invention discloses a multi-system material mixed operation method and device, including: obtaining at least first supply and demand data, the first supply and demand data including material demand information and material supply information representing the first system; converting the material supply information in the first supply and demand data according to a preset multi-system material ID mapping relationship to obtain the material supply information of the material demand information in different systems; constructing the supply and demand relationship of each material corresponding to each system and setting priorities based on different supply and demand relationships. The present invention can obtain the material supply information in different systems by converting the first supply and demand data in the first system through the mapping relationship, thereby obtaining the supply and demand relationship of the relevant materials in each system, which is convenient for unified operation, solves the information isolation problem of multiple systems running independently in the prior art, and solves the problem of easy errors in the operation results due to the linkage of upstream and downstream system data by setting priorities.

Description

Technical Field

[0001] The present invention relates to the technical field of multi-system material mixing operation, and in particular to a multi-system material mixing operation method and device. Background Art

[0002] With the continuous expansion of corporate business and the widening of geographical distribution, material management and demand planning between different regions have become increasingly complex. Traditionally, each region tends to use independent ERP (Enterprise Resource Planning) systems to manage local material demand planning. These ERP systems operate independently based on the specific conditions of each region and effectively handle material management tasks in their respective regions.

[0003] However, when enterprises need to allocate and purchase materials between different regions, due to the independence of the ERP system, each region has to go to different regions to collect materials, which not only increases the cost and time of material collection, but also increases the complexity of management. More importantly, when it comes to cross-regional material allocation, it is difficult for an independently operated ERP system to comprehensively consider the material supply and demand conditions in different regions, so as to provide a reasonable supply and demand plan.

[0004] Therefore, due to the information isolation between systems, local production plans may be affected. Errors in one party may easily affect the calculation results of the other party. In addition, since it is difficult for independent ERP systems to share and update information in real time, it is difficult for enterprises to adjust material supply and demand strategies in time when facing market changes, resulting in poor supply and demand effectiveness. This chain reaction not only increases management risks, but may also lead to an imbalance in supply and demand, which in turn affects the operational efficiency and economic benefits of the entire enterprise. Summary of the invention

[0005] The purpose of the present invention is to provide a multi-system material mixing operation method and device to solve the technical problems in the prior art of information isolation between multiple material operation systems, difficulty in real-time sharing and updating of information, which leads to errors in the operation of one of the intermediate systems, easily affecting the final result and poor supply and demand effectiveness.

[0006] To achieve one of the above-mentioned objects of the invention, an embodiment of the present invention provides a multi-system material mixing operation method, the method comprising: obtaining at least first supply and demand data, the first supply and demand data comprising material demand information and material supply information representing the first system;

[0007] Convert the material supply information in the first supply and demand data according to the preset multi-system material ID mapping relationship to obtain the material supply information of the material demand information in different systems;

[0008] Build the supply and demand relationship of each material corresponding to each system and set priorities based on different supply and demand relationships.

[0009] As a further improvement of the present invention, the method further comprises: the step of setting the multi-system material ID mapping relationship is:

[0010] At least obtaining a first bill of materials and a second bill of materials, wherein the first bill of materials includes material information stored in the first system, and the second bill of materials includes material information stored in the second system;

[0011] Based on the first bill of materials, determining whether the code of each material in the second bill of materials is the same as the code of the material in the first bill of materials, wherein each material code corresponds to a material ID;

[0012] If they are the same, a mapping relationship is established based on the first material ID in the first material list and the second material ID in the second material list.

[0013] As a further improvement of the present invention, the method also includes: if the coding of the material in the second bill of materials is different from the coding of the material in the first bill of materials, a new first material ID is generated, and a mapping relationship is established between the new first material ID and the corresponding second material ID in the second bill of materials.

[0014] As a further improvement of the present invention, the method further includes: after obtaining at least the first bill of materials and the second bill of materials, the method further includes: extracting the material code in the first bill of materials and setting it as an identifier, and constructing a hash index record according to the identifier and the first material ID corresponding to the identifier;

[0015] The method of judging whether the code of each material in the second material list is the same as the code of the material in the first material list based on the first material list is as follows:

[0016] Extracting the code of each material in the second bill of materials one by one, and determining whether the hash index record includes an identifier representing the code;

[0017] The specific steps to establish the mapping relationship are:

[0018] If the hash index record includes an identifier representing the code, a mapping relationship is established in the hash index record according to the first material ID and the second material ID corresponding to the identifier;

[0019] If the hash index record does not include an identifier representing the code, a first material ID corresponding to the first system is added to the hash index record, and a mapping relationship is established between the first material ID and the second material ID in the second system.

[0020] As a further improvement of the present invention, the method further includes: converting the material supply information in the first supply and demand data, and obtaining the material supply information of the material demand information in different systems specifically includes:

[0021] Obtaining a first material ID defined by a first system in the material supply information;

[0022] At least obtaining a second material ID corresponding to the second material defined in the second system according to the multi-system material ID mapping relationship;

[0023] The first material ID and the second material ID are summarized.

[0024] As a further improvement of the present invention, the method further includes: the construction of the supply and demand relationship of each material corresponding to each system specifically includes: forming a first supply and demand relationship with the corresponding material demand information in the first supply and demand data according to the first material ID defined in the first system;

[0025] A second supply and demand relationship is formed according to the second material ID of the material defined in the second system and the corresponding material demand information in the first supply and demand data.

[0026] As a further improvement of the present invention, the method further includes: after constructing the supply and demand relationship of each material corresponding to each system and setting the priority based on different supply and demand relationships, the method further includes:

[0027] Acquire material supply information at least in the first system and the second system, wherein the material supply information includes main material supply information and substitute material supply information;

[0028] Based on the material demand information, the supply relationship between the main material supply information and the substitute material supply information in the first system and the second system is balanced through the MRP algorithm.

[0029] As a further improvement of the present invention, the method further includes: balancing the supply relationship between the main material supply information and the substitute material supply information in the first system and the second system by using the MRP algorithm specifically includes:

[0030] Obtaining material demand information, and determining whether corresponding material supply information in the first system and the second system includes alternative material supply information;

[0031] If so, the MRP algorithm is used to balance the priority of primary material supply information and alternative material supply information.

[0032] To achieve one of the above-mentioned objects, the present invention further provides a multi-system material mixing operation device, the device comprising: an information acquisition module, used to acquire at least first supply and demand data, the first supply and demand data comprising material demand information and material supply information representing the first system;

[0033] The calculation module is used to convert the material supply information in the first supply and demand data according to the preset multi-system material ID mapping relationship, obtain the material supply information of the material demand information in different systems, and also to construct the supply and demand relationship of each material corresponding to each system and set priorities based on different supply and demand relationships.

[0034] As a further improvement of the present invention, the device also includes: the calculation module is also used to balance the supply relationship between the main material supply information and the alternative material supply information in the first system and the second system through the MRP algorithm based on the material demand information.

[0035] Compared with the prior art, the present invention has the following beneficial effects: the present invention can obtain the material supply information in different systems by converting the first supply and demand data in the first system through the multi-system material ID mapping relationship, thereby obtaining the supply and demand relationship of the relevant materials in each system, which is convenient for unified calculation and solves the information isolation problem of multiple systems running independently in the prior art. Moreover, by setting priorities for the supply and demand relationships of multiple systems and performing unified calculations, it can also avoid the scenario of inconsistent supply and demand due to time factors and solve the problem of easy errors in calculation results due to the linkage of upstream and downstream system data. BRIEF DESCRIPTION OF THE DRAWINGS

[0036] Figure 1 It is a flow chart of a multi-system material mixing operation method in one embodiment of the present invention.

[0037] Figure 2 It is a preset flow chart of the multi-system material ID mapping relationship in one embodiment of the present invention.

[0038] Figure 3 It is a flowchart of converting the material supply information in the first supply and demand data in one embodiment of the present invention.

[0039] Figure 4 It is a flow chart of balancing main material supply information and substitute material supply information in one embodiment of the present invention. DETAILED DESCRIPTION

[0040] The present invention will be described in detail below in conjunction with the specific embodiments shown in the accompanying drawings. However, these embodiments do not limit the present invention, and any structural, methodological, or functional changes made by a person skilled in the art based on these embodiments are all within the scope of protection of the present invention.

[0041] In one embodiment of the present invention, a multi-system material mixed operation method is provided. The mixed operation method can integrate the material supply information in multiple systems, thereby establishing the supply of multiple systems based on the material demand of one system, forming a solution of one demand corresponding to multiple supplies.

[0042] One of the systems represents the management of material information in a region. For example, a system can represent the material management of an enterprise in a region.

[0043] In one embodiment, the hybrid computing method is used to process at least the first system and the second system, wherein the first system is used by the enterprise to manage material information in the first area, and the second system is used by the enterprise to manage material information in the second area. In addition, in other embodiments, the hybrid computing method can also process the third system, the fourth system, etc., which will not be described in detail here.

[0044] The hybrid operation method can obtain the supply-demand relationship between the material demand information in the first system and the material supply information in the first system, and obtain the supply-demand relationship between the material demand information in the first system and the material supply information in the second system by calculation.

[0045] Similarly, the hybrid operation method can also obtain the supply and demand relationship between the material demand information in the second system and the material supply information in the first system and obtain the supply and demand relationship between the material demand information in the second system and the material supply information in the second system by calculation.

[0046] like Figure 1 As shown, taking the first system as a reference as an example, in one embodiment of the present invention, the multi-system material mixing operation method includes:

[0047] Step S1: at least obtain first supply and demand data, wherein the first supply and demand data includes material demand information and material supply information representing a first system.

[0048] The material demand information indicates the demand for materials in the first area represented by the first system. Taking a mobile phone as an example, the mobile phone screen and the mobile phone back panel used to manufacture the mobile phone are the material demand information.

[0049] The material supply information indicates the supply of materials in the first area represented by the first system, and can also be understood as the materials available in the first area. Taking a mobile phone as an example, the mobile phone screen, the mobile phone back panel, etc. are material supply information.

[0050] The first supply and demand data refers to the materials required to manufacture a certain item in the first region and the supply of the materials in the first region.

[0051] Both the material demand information and the material supply information include information such as the material name, material number, and material ID.

[0052] It should be noted that, similarly, the second supply and demand data in the second system is also understood as above and will not be elaborated here.

[0053] Step S2: converting the material supply information in the first supply and demand data according to a preset multi-system material ID mapping relationship to obtain the material supply information of the material demand information in different systems.

[0054] The preset multi-system material ID mapping relationship is the corresponding relationship between material IDs in multiple systems. By obtaining the first material ID in the material supply information in the first supply and demand data, the corresponding material ID in other systems is obtained. For example, the second material ID in the second system has been obtained.

[0055] The second material ID, the third material ID, etc. corresponding to the first material ID in multiple systems can be obtained as needed, which will not be repeated here.

[0056] Step S3: Construct the supply and demand relationship of each material corresponding to each system and set priorities based on different supply and demand relationships.

[0057] The above supply-demand relationship is a corresponding relationship established based on the material demand information in the first system and the material supply information of the same material in other systems.

[0058] Similarly, a correspondence between the material demand information in other systems and the material supply information in each system can also be established.

[0059] In one embodiment, the priority level can be understood as: the materials required in the first system are first supplied by the corresponding materials in the first system; secondly, they are supplied by the corresponding materials in the second system; and most preferably, they are supplied by the corresponding materials in the third system.

[0060] In this way, the calculation method adopted in the above implementation mode can obtain the material supply information in different systems by converting the first supply and demand data in the first system through the multi-system material ID mapping relationship, thereby obtaining the supply and demand relationship of the relevant materials in each system; it is convenient to use the data in all systems for unified calculation to obtain the final supply and demand relationship, which solves the information isolation problem of multiple systems running independently in the prior art, and after setting the priority of the supply and demand relationship of multiple systems and performing unified calculations, it can also avoid the scenario of inconsistent supply and demand due to time factors, and solves the problem of easy errors in calculation results due to the linkage of upstream and downstream system data.

[0061] In one embodiment of the present invention, Figure 2 As shown, the steps for setting the multi-system material ID mapping relationship are:

[0062] Step K1: obtaining at least a first bill of materials and a second bill of materials, wherein the first bill of materials includes material information stored in a first system, and the second bill of materials includes material information stored in a second system.

[0063] The bill of materials (BOM) describes the materials that a product consists of, including the dependencies and quantity relationships of these materials.

[0064] The first bill of materials describes the material composition relationship and quantity relationship of the product in the first system and also includes information such as material code and ID.

[0065] The second bill of materials describes the material composition relationship and quantity relationship of the product in the second system and also includes information such as material code and ID.

[0066] Step K2: Based on the first bill of materials, determine whether the code of each material in the second bill of materials is the same as the code of the material in the first bill of materials, wherein the code of each material corresponds to a material ID.

[0067] The material ID indicates the information of the material being defined in the system; the material code indicates the information of the material being manually defined. The material ID of the same material has different definitions in different systems; the material code of the same material has the same definition in different systems.

[0068] If they are the same, jump to step K3: establish a mapping relationship according to the first material ID in the first material list and the second material ID in the second material list.

[0069] The same code means that the materials in the first bill of materials are the same as the materials in the second bill of materials, which can be further understood as the materials in the first bill of materials and the materials in the second bill of materials can be supplied as the same materials.

[0070] If the material code in the second bill of materials is different from the material code in the first bill of materials, jump to step K4: generate a new first material ID, and establish a mapping relationship between the new first material ID and the corresponding second material ID in the second bill of materials.

[0071] Different codes indicate that there is no corresponding identical material in the first bill of materials and the second bill of materials, so a new first material ID is generated in the first system to match the second material ID in the second bill of materials, so that the first system can match the first material ID with the second material ID after purchasing it.

[0072] In this way, a mapping relationship is generated by matching the material IDs in the above-mentioned multiple systems, thereby establishing a connection between the multiple systems, making it easy to simultaneously obtain the supply information of corresponding materials in multiple systems when calculating the supply and demand relationship, and further assisting in the production of multiple supply plans when one party has production material needs.

[0073] In one embodiment of the present invention, after obtaining at least the first bill of materials and the second bill of materials, it also includes: extracting the material code in the first bill of materials and setting it as an identifier, and constructing a hash index record according to the identifier and the first material ID corresponding to the identifier.

[0074] A hash index is a form of database index that uses a hash function to calculate the hash value of the data and uses the hash value as the index key.

[0075] When a query is executed, the database system in the hash index record applies the same hash function to the query condition to obtain a hash value. Then it looks up the entry with that hash value in the hash table and quickly locates the data.

[0076] The method of judging whether the code of each material in the second material list is the same as the code of the material in the first material list based on the first material list is as follows:

[0077] The code of each material in the second material list is extracted one by one, and it is determined whether the hash index record includes an identifier representing the code.

[0078] In this implementation, the first system is used as the reference data, so the code of each material in the second bill of materials is extracted one by one to determine whether the hash index record includes an identifier representing the code.

[0079] In other embodiments, if the second system is used as the reference data, the material code in the second bill of materials is extracted and set as an identifier, and the code of each material in the first bill of materials is extracted one by one to determine whether the hash index record includes an identifier representing the code.

[0080] The specific steps to establish the mapping relationship are:

[0081] If the hash index record includes an identifier representing the code, a mapping relationship is established in the hash index record based on the first material ID and the second material ID corresponding to the identifier; if the hash index record does not include an identifier representing the code, a first material ID corresponding to the first system is added to the hash index record, and a mapping relationship is established between the first material ID and the second material ID in the second system.

[0082] In this way, by using hash index records, the first material ID can be quickly located according to the identifier, and the query speed is fast.

[0083] In one embodiment of the present invention, Figure 3 As shown, converting the material supply information in the first supply and demand data to obtain the material supply information of the material demand information in different systems specifically includes:

[0084] Step S2.1: Obtain a first material ID defined by a first system in the material supply information.

[0085] Step S2.2: According to the multi-system material ID mapping relationship, at least the second material ID defined in the second system is obtained.

[0086] Step S2.3: Summarize the first material ID and the second material ID.

[0087] The first material ID and the second material ID represent definitions of the same material in different systems.

[0088] In one embodiment of the present invention, the construction of the supply and demand relationship of each material corresponding to each system specifically includes:

[0089] A first supply-demand relationship is formed according to a first material ID of the material defined in the first system and corresponding material demand information in the first supply-demand data.

[0090] A second supply and demand relationship is formed according to the second material ID of the material defined in the second system and the corresponding material demand information in the first supply and demand data.

[0091] The material demand information includes information such as the name and quantity of the required materials. Specifically, the material demand information in the first supply and demand data represents information on the materials required in the area represented by the first system, including the name and quantity of the required materials.

[0092] The first material ID is a definition of the first material in the first system. In this implementation, it forms a first supply-demand relationship with the material demand information; it indicates that the first material in the first system can be supplied to the area represented by the first system.

[0093] The second material ID is a definition of the second material in the second system. In this embodiment, it forms a second supply-demand relationship with the material demand information; it indicates that the second material in the second system can be supplied to the area represented by the first system.

[0094] In this way, the same material demand can form multiple supply and demand relationships for different systems, thereby having multiple supply channels to obtain it, with more selectivity, and the importance of materials in multiple systems can be comprehensively considered to selectively supply designated needs; thus, the stable supply and demand of the enterprise can be guaranteed to a greater extent.

[0095] In one embodiment of the present invention, Figure 4 As shown, after building the supply and demand relationship of each material corresponding to each system and setting priorities based on different supply and demand relationships, it also includes:

[0096] Step S4: Acquire material supply information in at least the first system and the second system, wherein the material supply information includes main material supply information and substitute material supply information;

[0097] Step S5: Based on the material demand information, the supply relationship between the main material supply information and the substitute material supply information in the first system and the second system is balanced by the MRP algorithm.

[0098] The main material refers to the material used to produce a product, and the substitute material refers to the material that can replace the main material. The "main" and "substitute" in the main material supply information and substitute material supply information are relative definitions. The main material does not mean the main material used to produce a product; the main material and substitute material are mutually substitutable.

[0099] It should be noted that the substitute material supply information may include multiple substitute materials, all of which can be used to replace the materials in the main material supply information.

[0100] MRP algorithm, namely Material Requirement Planning algorithm.

[0101] Through the MRP algorithm, the material demand allocation quantity and material demand allocation sequence of each main material supply information and each alternative material supply information in the material supply information can be obtained.

[0102] The MRP algorithm is used to set the priorities of multiple substitute materials in the substitute material supply information, so that when the main material reserves are insufficient, the substitute materials can be accessed in sequence according to the priority order and the reserve quantity of the substitute materials can be calculated to see whether it meets the requirements.

[0103] Based on the principle of supply and demand balance, the MRP algorithm will replace the main materials in the existing production orders and the planned production orders generated by MRP with substitute materials. At the same time, the system will cancel the purchase orders related to the main materials or the equivalent quantity in the planned purchase orders accordingly.

[0104] In this way, the MRP algorithm can balance the main materials and alternative materials, so that when the main materials are insufficient in storage, alternative materials can be used first; this helps ensure the continuity and efficiency of production while reducing inventory costs and avoiding the risk of production interruptions.

[0105] Balancing the supply relationship between the main material supply information and the substitute material supply information in the first system and the second system by using the MRP algorithm specifically includes:

[0106] Obtaining material demand information, and determining whether corresponding material supply information in the first system and the second system includes alternative material supply information;

[0107] If so, the MRP algorithm is used to balance the priority of primary material supply information and alternative material supply information.

[0108] If not, only the supply and demand relationship between the main material supply information and the required material demand information is generated.

[0109] In one embodiment of the present invention, a multi-system material mixing operation device is also provided. The device is configured to use the multi-system material mixing operation method in the above embodiment to perform mixed operation on material data in multiple systems, thereby calculating a multi-system supply plan corresponding to the demand in one system.

[0110] The multi-system material mixing operation device comprises an information acquisition module and a calculation module. The calculation module is connected to the information acquisition module and is used to process the information acquired by the information acquisition module.

[0111] The information acquisition module is used to acquire at least first supply and demand data, wherein the first supply and demand data includes material demand information and material supply information representing the first system.

[0112] The calculation module is used to convert the material supply information in the first supply and demand data according to the preset multi-system material ID mapping relationship, obtain the material supply information of the material demand information in different systems, and also to construct the supply and demand relationship of each material corresponding to each system and set priorities based on different supply and demand relationships.

[0113] In one embodiment of the present invention, the calculation module is also used to balance the supply relationship between the main material supply information and the alternative material supply information in the first system and the second system through the MRP algorithm based on the material demand information.

[0114] Balancing the supply relationship between the main material supply information and the substitute material supply information in the first system and the second system by using the MRP algorithm specifically includes:

[0115] Obtaining material demand information, and determining whether corresponding material supply information in the first system and the second system includes alternative material supply information;

[0116] If so, the MRP algorithm is used to balance the priority of primary material supply information and alternative material supply information.

[0117] In summary, the present invention provides a multi-system material mixing operation device, which adopts a multi-system material mixing operation method to solve the technical problems in the prior art of information isolation between multiple material operation systems, difficulty in real-time sharing and updating of information, which leads to errors in the operation of one of the intermediate systems, easily affecting the final result and poor supply and demand effectiveness.

[0118] Specifically, the method first obtains at least a first bill of materials in a first system and a second bill of materials in a second system, and establishes a multi-system material ID mapping relationship based on the material coding.

[0119] In addition, the third material list of the third system can also be obtained, which will not be described here.

[0120] During the operation, the first supply and demand data in the first system is obtained; the material supply information of the material demand information in different systems is obtained through the multi-system material ID mapping relationship, that is, the corresponding material ID in the material supply information in different systems. The supply and demand relationship of each material corresponding to each system is constructed and the priority is set based on different supply and demand relationships.

[0121] Finally, you can select single or multiple supply sources (areas represented by the system) based on supply and demand.

[0122] It should be understood that although this specification is described according to implementation modes, not every implementation mode contains only one independent technical solution. This description of the specification is only for the sake of clarity. Those skilled in the art should regard the specification as a whole. The technical solutions in each implementation mode may also be appropriately combined to form other implementation modes that can be understood by those skilled in the art.

[0123] The series of detailed descriptions listed above are only specific descriptions of feasible implementation methods of the present invention. They are not intended to limit the scope of protection of the present invention. Any equivalent implementation methods or changes that do not deviate from the technical spirit of the present invention should be included in the scope of protection of the present invention.

Claims

1. A multi-system material mixing operation method, characterized in that: include: At least first supply and demand data is obtained, wherein the first supply and demand data includes material demand information and material supply information representing the first system; Convert the material supply information in the first supply and demand data according to the preset multi-system material ID mapping relationship to obtain the material supply information of the material demand information in different systems; Build the supply and demand relationship of each material corresponding to each system and set priorities based on different supply and demand relationships; The steps for setting the multi-system material ID mapping relationship are: At least obtaining a first bill of materials and a second bill of materials, wherein the first bill of materials includes material information stored in the first system, and the second bill of materials includes material information stored in the second system; Based on the first bill of materials, determining whether the code of each material in the second bill of materials is the same as the code of the material in the first bill of materials, wherein each material code corresponds to a material ID; If they are the same, a mapping relationship is established based on the first material ID in the first bill of materials and the second material ID in the second bill of materials; Otherwise, a new first material ID is generated, and a mapping relationship is established between the new first material ID and the corresponding second material ID in the second material list.

2. The multi-system material mixing operation method according to claim 1, characterized in that: After obtaining at least the first bill of materials and the second bill of materials, the method further includes: extracting the material code in the first bill of materials and setting it as an identifier, and constructing a hash index record according to the identifier and the first material ID corresponding to the identifier; The method of judging whether the code of each material in the second material list is the same as the code of the material in the first material list based on the first material list is as follows: Extracting the code of each material in the second bill of materials one by one, and determining whether the hash index record includes an identifier representing the code; The specific steps to establish the mapping relationship are: If the hash index record includes an identifier representing the code, a mapping relationship is established in the hash index record according to the first material ID and the second material ID corresponding to the identifier; If the hash index record does not include an identifier representing the code, a first material ID corresponding to the first system is added to the hash index record, and a mapping relationship is established between the first material ID and the second material ID in the second system.

3. The multi-system material mixing operation method according to claim 1, characterized in that: Converting the material supply information in the first supply and demand data to obtain the material supply information of the material demand information in different systems specifically includes: Obtaining a first material ID defined by a first system in the material supply information; At least obtaining a second material ID corresponding to the second material defined in the second system according to the multi-system material ID mapping relationship; The first material ID and the second material ID are summarized.

4. The multi-system material mixing operation method according to claim 3, characterized in that: The constructing of the supply and demand relationship of each material corresponding to each system specifically includes: forming a first supply and demand relationship with the corresponding material demand information in the first supply and demand data according to the first material ID defined in the first system; A second supply and demand relationship is formed according to the second material ID of the material defined in the second system and the corresponding material demand information in the first supply and demand data.

5. The multi-system material mixing operation method according to claim 1, characterized in that: After building the supply and demand relationship of each material corresponding to each system and setting priorities based on different supply and demand relationships, it also includes: Acquire material supply information at least in the first system and the second system, wherein the material supply information includes main material supply information and substitute material supply information; Based on the material demand information, the supply relationship between the main material supply information and the substitute material supply information in the first system and the second system is balanced through the MRP algorithm.

6. The multi-system material mixing operation method according to claim 5, characterized in that: Balancing the supply relationship between the main material supply information and the substitute material supply information in the first system and the second system by using the MRP algorithm specifically includes: Obtaining material demand information, and determining whether corresponding material supply information in the first system and the second system includes alternative material supply information; If so, the MRP algorithm is used to balance the priority of primary material supply information and alternative material supply information.

7. A multi-system material mixing operation device, characterized in that: include: An information acquisition module, configured to acquire at least first supply and demand data, wherein the first supply and demand data includes material demand information and material supply information representing the first system; a calculation module, used to convert the material supply information in the first supply and demand data according to a preset multi-system material ID mapping relationship, obtain the material supply information of the material demand information in different systems, and also used to construct a supply and demand relationship for each material corresponding to each system and set priorities based on different supply and demand relationships; The steps for setting the multi-system material ID mapping relationship are: At least obtaining a first bill of materials and a second bill of materials, wherein the first bill of materials includes material information stored in the first system, and the second bill of materials includes material information stored in the second system; Based on the first bill of materials, determining whether the code of each material in the second bill of materials is the same as the code of the material in the first bill of materials, wherein each material code corresponds to a material ID; If they are the same, a mapping relationship is established based on the first material ID in the first material list and the second material ID in the second material list; otherwise, a new first material ID is generated, and a mapping relationship is established based on the new first material ID and the corresponding second material ID in the second material list.

8. The multi-system material mixing operation device according to claim 7, characterized in that: The calculation module is also used to balance the supply relationship between the main material supply information and the substitute material supply information in the first system and the second system through the MRP algorithm based on the material demand information.

Images