A material distribution method, apparatus, equipment and storage medium

Abstract

This disclosure provides a material allocation method, apparatus, device, and storage medium, wherein the method includes: in response to a Bill of Materials (BOM) information update, obtaining first substitute material information from the BOM information and second substitute material information from a current substitute material information database; matching the first substitute material information with the second substitute material information to obtain a first matching result; and updating the substitute material information database based on the first matching result, the first substitute material information, and the second substitute material information to obtain a substitute material information database containing third substitute material information.

Description

Technical Field

[0001] This disclosure relates to the field of materials management, and more particularly to a material distribution method, apparatus, equipment, and storage medium. Background Technology

[0002] When a standard Bill of Materials (BOM) includes alternative materials, the usage ratio of these alternative materials needs to be updated promptly. Because BOM updates for alternative materials are not timely, backend personnel cannot promptly respond to and maintain the usage ratio, leading to errors in system calculations and consequently, anomalies in procurement execution, order commitments, and production execution.

[0003] To address the aforementioned technical issues, the existing general approach is as follows: When creating a Bill of Materials (BOM), the R&D department offline notifies the purchasing staff to maintain the substitution ratio for each individual BOM. After BOM creation, any adjustments to BOM substitution materials or changes in purchasing strategies such as quarterly price adjustments require the R&D department to offline notify the purchasing department to update the corresponding substitution ratio for each item. This method involves significant offline interaction between the relevant departments and the purchasing department, resulting in low efficiency. Purchasing staff need to update the substitution ratio for each individual BOM, which is time-consuming and labor-intensive, and it is impossible to pre-set the substitution ratio that will take effect in the future. Summary of the Invention

[0004] This disclosure provides a material distribution method, apparatus, equipment, and storage medium to at least solve the above-mentioned technical problems existing in the prior art.

[0005] According to a first aspect of this disclosure, a material dispensing method is provided, wherein the method includes:

[0006] In response to an update of the Bill of Materials (BOM) information, the system retrieves the first alternative material information from the BOM information and the second alternative material information from the current alternative material information database.

[0007] The first substitute material information is matched with the second substitute material information to obtain a first matching result;

[0008] Based on the first matching result, the first alternative material information, and the second alternative material information, the alternative material information database is updated to obtain an alternative material information database containing the third alternative material information.

[0009] In one possible implementation, the step of obtaining first substitute material information from the BOM information and second substitute material information from the current substitute material information database in response to a BOM information update includes:

[0010] In response to creating or modifying BOM information, the system obtains the first substitute material information from the newly created or modified BOM information and the second substitute material information from the current substitute material information database.

[0011] Based on the newly created BOM information or the related information in the modified BOM information, the data in the first alternative material information is grouped into related information groups, and duplicate items in the related information groups are removed according to the substitution relationship of the alternative materials and the factory information of the alternative materials to obtain the first alternative material information group.

[0012] Based on the associated information in the second alternative material information in the current alternative material information database, the data in the second alternative material information is grouped according to the associated information to obtain the second alternative material information group.

[0013] In one possible implementation, based on the second substitute material information, the first substitute material information is matched with the second substitute material information to obtain a first matching result, including:

[0014] Based on the second alternative material information group, the first alternative material information group is matched with the second alternative material information group to obtain a first matching result that includes at least a comparison of the usage ratios of all alternative materials in the first alternative material information and all alternative materials in the second alternative material information.

[0015] In one possible implementation, the alternative material information database is updated based on the first matching result, the first alternative material information, and the second alternative material information to obtain an alternative material information database containing third alternative material information, including:

[0016] Based on the first matching result and the first substitute material information, the substitute material information that did not match the first substitute material information is taken as the fourth substitute material information; and the usage ratio of the fourth substitute material information is filled into the usage ratio of the part of the first substitute material information corresponding to the fourth substitute material information.

[0017] Based on the first matching result and the second alternative material information, the alternative material information that successfully matches the second alternative material information with the first alternative material information is taken as the fifth alternative material information; and the usage ratio in the fifth alternative material information is filled with the usage ratio in the second alternative material information that corresponds to the fifth alternative material information.

[0018] The fourth and fifth alternative material information are combined to obtain the third alternative material information;

[0019] The third alternative material information replaces the second alternative material information and is stored in the alternative material information database.

[0020] In one possible implementation, the method further includes:

[0021] When the fourth alternative material information is not empty, an alternative material maintenance instruction is generated based on the usage ratio in the fourth alternative material information. The alternative material maintenance instruction includes at least the usage ratio information of all alternative materials in the fourth alternative material information.

[0022] Based on the usage ratio in the third alternative material information, calculate the correspondence between the usage ratio in the third alternative material information and the consumption time of each alternative material in the third alternative material information;

[0023] Based on the aforementioned time correspondence, a schedule for updating alternative material information is set.

[0024] According to a second aspect of this disclosure, a material dispensing apparatus is provided, wherein the apparatus includes:

[0025] The acquisition module is used to acquire the first alternative material information in the BOM information and the second alternative material information in the current alternative material information database in response to the BOM information update;

[0026] The acquisition module is further configured to, in response to new BOM information or modified BOM information, acquire the first substitute material information in the new BOM information or modified BOM information and the second substitute material information in the current substitute material information database;

[0027] The matching module is used to match the first substitute material information with the second substitute material information to obtain a first matching result;

[0028] The information update module is used to update the alternative material information database based on the first matching result, the first alternative material information, and the second alternative material information to obtain an alternative material information database containing the third alternative material information.

[0029] In one possible implementation, the information update module includes:

[0030] An information establishment module is used to, based on the first matching result and the first alternative material information, designate the alternative material information for which the second alternative material information and the first alternative material information did not match successfully as the fourth alternative material information; and to fill the usage ratio of the fourth alternative material information with the usage ratio of the portion of the first alternative material information corresponding to the fourth alternative material information.

[0031] The information replacement module is used to, based on the first matching result and the second alternative material information, take the alternative material information that is successfully matched with the first alternative material information as the fifth alternative material information; and fill the usage ratio in the fifth alternative material information with the usage ratio in the second alternative material information corresponding to the fifth alternative material information.

[0032] The information merging module is used to merge the fourth substitute material information and the fifth substitute material information to obtain the third substitute material information;

[0033] The information replacement module is further configured to replace the second substitute material information with the third substitute material information and store it in the substitute material information database.

[0034] In one possible embodiment, the device further includes:

[0035] The grouping module is used to group the data in the first alternative material information based on the associated information in the newly created BOM information or modified BOM information, and remove duplicate items in the associated information group according to the substitution relationship of the alternative materials and the factory information of the alternative materials to obtain the first alternative material information group.

[0036] The grouping module is further configured to, based on the associated information in the second alternative material information in the current alternative material information database, group the data in the second alternative material information according to the associated information to obtain the second alternative material information group;

[0037] The instruction generation module is used to generate a substitute material maintenance instruction based on the usage ratio in the fourth substitute material information when the fourth substitute material information is not empty. The substitute material maintenance instruction includes at least the usage ratio information of all substitute materials in the fourth substitute material information.

[0038] The schedule setting module is used to calculate the correspondence between the usage ratio in the third alternative material information and the time consumption of each alternative material in the third alternative material information, based on the usage ratio in the third alternative material information; and to set the alternative material information update schedule based on the time correspondence.

[0039] According to a third aspect of this disclosure, an electronic device is provided, comprising:

[0040] At least one processor; and

[0041] A memory communicatively connected to the at least one processor; wherein,

[0042] The memory stores instructions that can be executed by the at least one processor to enable the at least one processor to perform the material dispensing method described in this disclosure.

[0043] According to a fourth aspect of this disclosure, a non-transitory computer-readable storage medium is provided storing computer instructions for causing a computer to perform the material dispensing method described in this disclosure.

[0044] This disclosure discloses a material allocation method, apparatus, equipment, and storage medium. By matching the substitute material information obtained from the BOM update with the substitute material information in the warehouse's substitute material information database, and updating the substitute material information in the current database based on the matching results, it achieves automatic online updates. This eliminates the need for offline communication between the R&D and purchasing departments. The system automatically identifies substitute materials online, automating the update of the substitute material usage ratio. Newly added substitute material information notifies the purchasing department, enabling them to make bulk purchases based on the updated content in the substitute material information database, saving time and costs. By setting a substitute material information change schedule, the expected effective substitute material usage ratio can be set in advance, achieving the effect of automatically changing the usage ratio on the effective date.

[0045] It should be understood that the description in this section is not intended to identify key or essential features of the embodiments of this disclosure, nor is it intended to limit the scope of this disclosure. Other features of this disclosure will become readily apparent from the following description. Attached Figure Description

[0046] The above and other objects, features, and advantages of this disclosure will become readily apparent from the following detailed description of exemplary embodiments, taken in conjunction with the accompanying drawings. Several embodiments of this disclosure are illustrated in the drawings by way of example and not limitation, in which:

[0047] In the accompanying drawings, the same or corresponding reference numerals indicate the same or corresponding parts.

[0048] Figure 1 This illustration shows a schematic flow diagram of the implementation of a material distribution method according to an embodiment of the present disclosure. Figure 1 ;

[0049] Figure 2 This illustration shows a schematic flow diagram of the implementation of a material distribution method according to an embodiment of the present disclosure. Figure 2 ;

[0050] Figure 3 A schematic diagram of a material dispensing device according to an embodiment of the present disclosure is shown;

[0051] Figure 4A schematic diagram of the composition structure of an electronic device according to an embodiment of the present disclosure is shown. Detailed Implementation

[0052] To make the objectives, features, and advantages of this disclosure more apparent and understandable, the technical solutions in the embodiments of this disclosure will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only a part of the embodiments of this disclosure, and not all of them. All other embodiments obtained by those skilled in the art based on the embodiments of this disclosure without creative effort are within the scope of protection of this disclosure.

[0053] Figure 1 This illustration shows a schematic flow diagram of the implementation of a material distribution method according to an embodiment of the present disclosure. Figure 1 ,like Figure 1 The illustration shows the implementation flow of a material allocation method according to an embodiment of this disclosure. Figure 1 Includes the following steps:

[0054] Step 101: In response to the update of the Bill of Materials (BOM) information, obtain the first alternative material information in the BOM information and the second alternative material information in the current alternative material information database.

[0055] In this embodiment of the disclosure, in response to a Bill of Materials (BOM) information update, first alternative material information from the BOM information and second alternative material information from the current alternative material information database are obtained. The BOM information update includes creating a new BOM or updating the current BOM information after modification. The first alternative material information includes the factory information, material number, component material, alternative material group, line item number, and usage ratio corresponding to each alternative material in the BOM. The alternative material information database contains information on all alternative materials in the current material warehouse, as well as alternative material information for all current BOMs. The second alternative material information contains at least all information related to the first alternative material information stored in the alternative material information database.

[0056] Step 102: Match the first substitute material information with the second substitute material information to obtain a first matching result.

[0057] In this embodiment of the disclosure, the first alternative material information is matched with the second alternative material information to obtain a first matching result. Specifically, the first alternative material information is matched with the corresponding parts of the second alternative material information. The matching content includes: factory information, material number, component material, and alternative material group, to obtain the first matching result. The matching result includes: the alternative material information in the first alternative material information that successfully matches the second alternative material information and the part of the first alternative material information not included in the second alternative material information.

[0058] In this embodiment of the disclosure, before performing the above matching, the first substitute material information and the second substitute material information are grouped. Specifically, based on the associated information in the first substitute material information, namely factory information, material number, component material, substitute material group, and usage ratio, the data in the first substitute material information are grouped into associated information groups. Duplicate items in the associated information groups are removed according to the substitution relationship of the substitute materials and the factory information of the substitute materials to obtain the first substitute material information group. Similarly, based on the associated information in the second substitute material information, namely factory information, material number, component material, substitute material group, and usage ratio, the data in the second substitute material information are grouped into associated information groups. Duplicate items in the associated information groups are removed according to the substitution relationship of the substitute materials and the factory information of the substitute materials to obtain the second substitute material information group.

[0059] Step 103: Update the alternative material information database based on the first matching result, the first alternative material information, and the second alternative material information to obtain an alternative material information database containing the third alternative material information.

[0060] In this embodiment of the disclosure, the alternative material information database is updated based on the first matching result, the first alternative material information, and the second alternative material information to obtain an alternative material information database containing third alternative material information. Specifically, the alternative material information that successfully matches the second alternative material information in the first alternative material information is taken as the fifth alternative material information. The fifth alternative material information is the alternative material information that exists in the alternative material information database in the newly created or modified BOM. The usage ratio of each alternative material in the fifth alternative material information is filled with the usage ratio of the corresponding part of the second alternative material information. The first alternative material information that is not included in the second alternative material information, that is, the alternative material information that does not successfully match the first alternative material information in the second alternative material information, is taken as the fourth alternative material information. The fourth alternative material information is the alternative material information that does not exist in the alternative material information database in the newly created or modified BOM. The usage ratio of each alternative material in the fourth alternative material information is filled with the usage ratio of the corresponding part of the first alternative material information. The fourth and fifth alternative material information are merged to obtain the third alternative material information. The third alternative material information is then used to replace the second alternative material information and stored in the alternative material information database to complete the update of the alternative material information database.

[0061] Figure 2 This illustration shows a schematic flow diagram of the implementation of a material distribution method according to an embodiment of the present disclosure. Figure 2 ,like Figure 2 The illustration shows the implementation flow of a material allocation method according to an embodiment of this disclosure. Figure 2Includes the following steps:

[0062] Step 201: Establish a database to store BOM substitute material information.

[0063] In this embodiment of the disclosure, the alternative material relationships in all current BOM information are obtained, and a database storing BOM alternative material information is established as the second alternative material information. The obtained BOM alternative material information is subjected to weight reduction processing, specifically as shown in Table 1, all BOM materials, factory numbers, material numbers, component materials, alternative material relationships, priorities, and usage ratio data are captured.

[0064] factory Material Number Component materials Alternative materials Component line project Use ratio A001 A Z1 00 0001 70 A001 A Z2 00 0001 30 A002 B Z1 01 0001 70 A002 B Z2 01 0001 30 A001 C Z1 01 0001 90 A001 C Z2 01 0001 10 A001 C Z3 01 0001 0

[0065] Table 1

[0066] As shown in Table 2, the BOM substitute material data are grouped and duplicates are removed according to the substitute material relationship and factory number; the usage ratio of the component materials after grouping follows the usage ratio in the obtained BOM information;

[0067]

[0068]

[0069] Table 2

[0070] As shown in Table 3, the component materials in the substitution group are assigned priority according to the usage ratio, and the grouped database substitution material information is used as the second substitution material information group.

[0071] Alternate group number Material Number factory Component materials Use ratio Priority GRPNO1 A A001 Z1 70 1 GRPNO1 A A001 Z2 30 2 GRPNO2 B A002 Z1 70 1 GRPNO2 B A002 Z2 30 2 GRPNO3 C A001 Z1 90 1 GRPNO3 C A001 Z2 10 2 GRPNO3 C A001 Z3 0 3

[0072] Table 3

[0073] Step 202: Obtain information on the BOM substitute materials created or modified on the same day.

[0074] In this embodiment of the disclosure, the information on substitute materials in newly created or updated BOMs is automatically identified every day. Specifically, after the SAP (Systems Applications and Products in Data Processing) system, which is applied to the ERP (Enterprise Resource Planning) system, receives the information on the creation or modification of BOMs from the PLM (Product Life-cycle Management) system, the SAP system creates or modifies the BOM, generates BOM master data, and obtains the BOM master data that has been created or modified in the SAP system on the same day. The BOM master data includes information on BOM substitute materials, which is used as the first substitute material information, as shown in Table 4.

[0075] factory Material Number Component materials Alternative materials Component line project Use ratio A001 D Z1 00 0001 100 A001 D Z2 00 0001 0 A001 E Z1 01 0001 100 A001 E Z2 01 0001 0 A003 F Z1 02 0001 100 A003 F Z2 02 0001 0

[0076] Table 4

[0077] Step 203: Group the obtained BOM substitute material information according to the substitution relationship.

[0078] In this embodiment of the disclosure, based on the information of the BOM substitute materials created or modified on the same day, the data in the obtained BOM substitute material information is grouped according to the substitution relationship, and duplicate items in the grouped information are removed according to the substitution relationship of the substitute materials and the factory information of the substitute materials to obtain a group of substitute material data in the same format as the above database, which is used as the first group of substitute material information, as shown in Table 5. Table 6 is the group of substitute material data in the database corresponding to Table 5.

[0079] serial number Material Number factory Component materials Use ratio 1 D A001 Z1,Z2 100,0 2 E A001 Z1,Z2 100,0 3 F A003 Z1,Z2 100,0

[0080] Table 5

[0081] Alternate group number factory Component materials Use ratio GRPNO1 A001 Z1,Z2 70,30 GRPNO2 A002 Z1,Z2 70,30 GRPNO3 A003 Z1, Z2, Z3 90,10,0

[0082] Table 6

[0083] Step 204: Match the obtained BOM substitute material information with the substitute material information in the database to obtain the matching result.

[0084] In this embodiment of the disclosure, based on the alternative material information in the database, namely the second alternative material information group, the obtained BOM alternative material information, namely the first alternative material information group, is matched with the second alternative material information group to obtain a first matching result that includes at least a comparison of the usage ratios of all alternative materials in the first alternative material information and all alternative materials in the second alternative material information.

[0085] The first matching result also includes the tagging information of the alternative material information that was not successfully matched in the first alternative material information group.

[0086] Step 205: Update the database of BOM substitute material information based on the matching results.

[0087] In this embodiment of the disclosure, the database of the second substitute material information, i.e., the BOM substitute material information, is updated according to the first matching result. Specifically, as shown in Table 7, the substitute material information corresponding to the above-mentioned marking information is taken as the fourth substitute material information, and the usage ratio in the fourth substitute material information is filled with the usage ratio of the corresponding part of the first substitute material information. Users can adjust the substitute material usage ratio in the newly generated fourth substitute material information according to the actual inventory in the database and the current quarter's production capacity needs. The adjusted usage ratio of the substitute material in the fourth substitute material information is then synchronized to the newly created or updated BOM to achieve a reasonable allocation of the substitute material usage ratio.

[0088] serial number Material Number factory Component materials Use ratio Priority GRPNO4 F A003 Z1 100 1 GRPNO4 F A003 Z1 0 2

[0089] Table 7

[0090] As shown in Table 8, the substitute material information that is successfully matched in the first substitute material information group and the second substitute material information group in the first matching result is taken as the fifth substitute material information. The usage ratio of the fifth substitute material information is filled with the usage ratio of the part of the second substitute material information that corresponds to the fifth substitute material information.

[0091] serial number Material Number factory Component materials Use ratio Priority GRPNO1 D A001 Z1 70 1 GRPNO1 D A001 Z2 30 2 GRPNO2 E A002 Z1 70 1 GRPNO2 E A002 Z2 30 2

[0092] Table 8

[0093] The fourth substitute material information and the fifth substitute material information are merged to obtain the third substitute material information, and the third substitute material information is used as the updated substitute material information to replace the second substitute material information.

[0094] In this embodiment of the disclosure, when the generation of fourth alternative material information is detected, that is, when the fourth alternative material information is not empty, an alternative material maintenance instruction is generated based on the usage ratio in the fourth alternative material information. The alternative material maintenance instruction includes at least the usage ratio information of all alternative materials in the fourth alternative material information. The generated alternative material maintenance instruction is sent to the purchasing department, and the purchasing department maintains the alternative materials according to the alternative material usage ratio in the maintenance instruction.

[0095] In this embodiment of the disclosure, since the price of alternative materials may fluctuate, the usage ratio of alternative materials in the alternative material information database can also be updated according to the budget adjustment of the purchasing department. Specifically, as shown in Table 9, the alternative group number that needs to be adjusted in the usage ratio of the alternative material information database is obtained, and the corresponding alternative material information is queried according to the alternative group number.

[0096]

[0097]

[0098] Table 9

[0099] As shown in Table 10, based on the adjustment needs of the purchasing department, the usage ratio of each alternative material in the queried alternative material information is modified; the modified alternative material information is synchronized to the alternative material information database, and the priority of the modified alternative material information is re-determined according to the modified usage ratio.

[0100] Alternate group number Material Number factory Component materials Use ratio Priority GRPNO1 A A001 Z1 90 1 GRPNO1 A A001 Z2 10 2 GRPNO1 B A001 Z1 90 1 GRPNO1 B A001 Z2 10 2

[0101] Table 10

[0102] As shown in Table 11, based on the synchronized alternative material information database, the alternative material usage ratio in the BOM of the currently modified alternative material information is replaced with the alternative material usage ratio in the current alternative material information database.

[0103] factory Material Number Component materials Alternative materials Line Project Number Use ratio A001 A Z1 01 0001 90 A001 A Z2 01 0001 10 A001 B Z1 1 1 90 A001 B Z2 1 1 10

[0104] Table 11

[0105] Step 206: Set the alternative material information update schedule according to the updated BOM alternative material information database.

[0106] In this embodiment of the disclosure, the user can set an update schedule for the alternative material information of a BOM to be effective based on the currently updated BOM alternative material information database. Specifically, based on the usage ratio of each alternative material in the third alternative material information mentioned above, the system calculates the correspondence between the usage ratio of each alternative material in the current alternative material information and the consumption time of each alternative material. According to the time correspondence, a BOM to be effective is set. The usage ratio of the alternative materials in the BOM to be effective conforms to the correspondence between the current usage ratio of the alternative materials and the consumption time. When the BOM to be effective reaches its effective date, the system automatically generates BOM information and adjusts the usage ratio of the alternative materials in the generated BOM according to the usage ratio of the alternative materials in the alternative material information database at the effective date.

[0107] Figure 3 A schematic diagram of a material dispensing device according to an embodiment of the present disclosure is shown, such as... Figure 3As shown, an embodiment of this disclosure provides a material dispensing device comprising:

[0108] The acquisition module 301 is used to acquire the first alternative material information in the BOM information and the second alternative material information in the current alternative material information database in response to the BOM information update;

[0109] The acquisition module 301 is further configured to, in response to new BOM information or modified BOM information, acquire the first substitute material information in the new BOM information or modified BOM information and the second substitute material information in the current substitute material information database;

[0110] Matching module 302 is used to match the first substitute material information with the second substitute material information to obtain a first matching result;

[0111] Information update module 303 is used to update the alternative material information database based on the first matching result, the first alternative material information and the second alternative material information to obtain an alternative material information database containing the third alternative material information;

[0112] The information establishment module 304 is used to, based on the first matching result and the first alternative material information, take the alternative material information that did not match the first alternative material information as the fourth alternative material information; and fill the usage ratio of the fourth alternative material information with the usage ratio of the part of the first alternative material information corresponding to the fourth alternative material information.

[0113] The information replacement module 305 is used to, based on the first matching result and the second alternative material information, take the alternative material information that is successfully matched with the first alternative material information as the fifth alternative material information; and fill the usage ratio in the fifth alternative material information with the usage ratio in the second alternative material information corresponding to the fifth alternative material information.

[0114] The information replacement module 305 is further configured to replace the second substitute material information with the third substitute material information and store it in the substitute material information database;

[0115] The information merging module 306 is used to merge the fourth substitute material information and the fifth substitute material information to obtain the third substitute material information;

[0116] Grouping module 307 is used to group the data in the first alternative material information based on the associated information in the newly created BOM information or modified BOM information, and remove duplicate items in the associated information group according to the substitution relationship of the alternative materials and the factory information of the alternative materials to obtain the first alternative material information group.

[0117] The grouping module 307 is further configured to, based on the associated information in the second alternative material information in the current alternative material information database, group the data in the second alternative material information according to the associated information to obtain the second alternative material information group;

[0118] The instruction generation module 308 is used to generate a substitute material maintenance instruction based on the usage ratio in the fourth substitute material information when the fourth substitute material information is not empty. The substitute material maintenance instruction includes at least the usage ratio information of all substitute materials in the fourth substitute material information.

[0119] The schedule setting module 309 is used to calculate the correspondence between the usage ratio in the third alternative material information and the time consumption of each alternative material in the third alternative material information based on the usage ratio in the third alternative material information; and to set the alternative material information update schedule based on the time correspondence.

[0120] In an exemplary embodiment, the acquisition module 301, matching module 302, information update module 303, information creation module 304, information replacement module 305, information merging module 306, grouping module 307, instruction generation module 308, schedule setting module 309, etc., can be implemented by one or more central processing units (CPUs), graphics processing units (GPUs), application-specific integrated circuits (ASICs), DSPs, programmable logic devices (PLDs), complex programmable logic devices (CPLDs), field-programmable gate arrays (FPGAs), general-purpose processors, controllers, microcontrollers (MCUs), microprocessors, or other electronic components.

[0121] Regarding the apparatus in the above embodiments, the specific manner in which each module and unit performs its operations has been described in detail in the embodiments related to the method, and will not be elaborated upon here.

[0122] According to embodiments of this disclosure, this disclosure also provides an electronic device and a readable storage medium.

[0123] Figure 4A schematic block diagram of an example electronic device 800 that can be used to implement embodiments of the present disclosure is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device may also represent various forms of mobile devices, such as personal digital processors, cellular phones, smartphones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely illustrative and are not intended to limit the implementation of the present disclosure described and / or claimed herein.

[0124] like Figure 4 As shown, device 800 includes a computing unit 801, which can perform various appropriate actions and processes based on a computer program stored in read-only memory (ROM) 802 or a computer program loaded from storage unit 808 into random access memory (RAM) 803. RAM 803 may also store various programs and data required for the operation of device 800. The computing unit 801, ROM 802, and RAM 803 are interconnected via bus 804. Input / output (I / O) interface 805 is also connected to bus 804.

[0125] Multiple components in device 800 are connected to I / O interface 805, including: input unit 806, such as keyboard, mouse, etc.; output unit 807, such as various types of monitors, speakers, etc.; storage unit 808, such as disk, optical disk, etc.; and communication unit 809, such as network card, modem, wireless transceiver, etc. Communication unit 809 allows device 800 to exchange information / data with other devices through computer networks such as the Internet and / or various telecommunications networks.

[0126] The computing unit 801 can be a variety of general-purpose and / or special-purpose processing components with processing and computing capabilities. Some examples of the computing unit 801 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various special-purpose artificial intelligence (AI) computing chips, various computing units running machine learning model algorithms, a digital signal processor (DSP), and any suitable processor, controller, microcontroller, etc. The computing unit 801 performs the various methods and processes described above, such as a material dispensing method. For example, in some embodiments, a material dispensing method may be implemented as a computer software program tangibly contained in a machine-readable medium, such as storage unit 808. In some embodiments, part or all of the computer program may be loaded and / or installed on device 800 via ROM 802 and / or communication unit 809. When the computer program is loaded into RAM 803 and executed by the computing unit 801, one or more steps of a material dispensing method described above may be performed. Alternatively, in other embodiments, the computing unit 801 may be configured to perform a material dispensing method by any other suitable means (e.g., by means of firmware).

[0127] Various embodiments of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), systems-on-a-chip (SoCs), payload-programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various embodiments may include implementations in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which may be a dedicated or general-purpose programmable processor, capable of receiving data and instructions from a storage system, at least one input device, and at least one output device, and transmitting data and instructions to the storage system, the at least one input device, and the at least one output device.

[0128] The program code used to implement the methods of this disclosure may be written in any combination of one or more programming languages. This program code may be provided to a processor or controller of a general-purpose computer, special-purpose computer, or other programmable data processing apparatus, such that when executed by the processor or controller, the program code causes the functions / operations specified in the flowcharts and / or block diagrams to be implemented. The program code may be executed entirely on a machine, partially on a machine, as a standalone software package partially on a machine and partially on a remote machine, or entirely on a remote machine or server.

[0129] In the context of this disclosure, a machine-readable medium can be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, apparatus, or device. A machine-readable medium can be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium can be, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination of the foregoing. More specific examples of machine-readable storage media include electrical connections based on one or more wires, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.

[0130] To provide interaction with a user, the systems and techniques described herein can be implemented on a computer having: a display device for displaying information to the user (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor); and a keyboard and pointing device (e.g., a mouse or trackball) through which the user provides input to the computer. Other types of devices can also be used to provide interaction with the user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including sound input, voice input, or tactile input).

[0131] The systems and technologies described herein can be implemented in computing systems that include backend components (e.g., as a data server), or computing systems that include middleware components (e.g., an application server), or computing systems that include frontend components (e.g., a user computer with a graphical user interface or web browser through which a user can interact with embodiments of the systems and technologies described herein), or any combination of such backend, middleware, or frontend components. The components of the system can be interconnected via digital data communication of any form or medium (e.g., a communication network). Examples of communication networks include local area networks (LANs), wide area networks (WANs), and the Internet.

[0132] Computer systems can include clients and servers. Clients and servers are generally located far apart and typically interact via communication networks. Client-server relationships are created by computer programs running on the respective computers and having a client-server relationship with each other. Servers can be cloud servers, servers in distributed systems, or servers incorporating blockchain technology.

[0133] It should be understood that the various forms of processes shown above can be used to reorder, add, or delete steps. For example, the steps described in this disclosure can be executed in parallel, sequentially, or in different orders, as long as the desired result of the technical solution disclosed in this disclosure can be achieved, and this is not limited herein.

[0134] Furthermore, the terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one of that feature. In the description of this disclosure, "a plurality of" means two or more, unless otherwise explicitly specified.

[0135] The above description is merely a specific embodiment of this disclosure, but the scope of protection of this disclosure is not limited thereto. Any variations or substitutions that can be easily conceived by those skilled in the art within the scope of the technology disclosed in this disclosure should be included within the scope of protection of this disclosure. Therefore, the scope of protection of this disclosure should be determined by the scope of the claims.

Claims

1. A material distribution method, characterized in that, The method includes: In response to an update of the Bill of Materials (BOM) information, the system retrieves the first alternative material information from the BOM information and the second alternative material information from the current alternative material information database. The first substitute material information is matched with the corresponding part of the second substitute material information to obtain the first matching result; Based on the first matching result and the first substitute material information, the substitute material information that did not match the first substitute material information is taken as the fourth substitute material information; and the usage ratio of the fourth substitute material information is filled into the usage ratio of the part of the first substitute material information corresponding to the fourth substitute material information. Based on the first matching result and the second alternative material information, the alternative material information that successfully matches the second alternative material information with the first alternative material information is taken as the fifth alternative material information; and the usage ratio in the fifth alternative material information is filled with the usage ratio in the second alternative material information that corresponds to the fifth alternative material information. The fourth and fifth alternative material information are combined to obtain the third alternative material information; The third alternative material information replaces the second alternative material information and is stored in the alternative material information database.

2. The method according to claim 1, characterized in that, The step of responding to a Bill of Materials (BOM) information update by obtaining first substitute material information from the BOM information and second substitute material information from the current substitute material information database includes: In response to creating or modifying BOM information, the system obtains the first substitute material information from the newly created or modified BOM information and the second substitute material information from the current substitute material information database. Based on the newly created BOM information or the related information in the modified BOM information, the data in the first alternative material information is grouped into related information groups, and duplicate items in the related information groups are removed according to the substitution relationship of the alternative materials and the factory information of the alternative materials to obtain the first alternative material information group. Based on the associated information in the second alternative material information in the current alternative material information database, the data in the second alternative material information is grouped according to the associated information to obtain the second alternative material information group.

3. The method according to claim 2, characterized in that, The step of matching the first substitute material information with the corresponding portion of the second substitute material information based on the second substitute material information to obtain a first matching result includes: Based on the second alternative material information group, the first alternative material information group is matched with the second alternative material information group to obtain a first matching result that includes at least a comparison of the usage ratios of all alternative materials in the first alternative material information and all alternative materials in the second alternative material information.

4. The method according to claim 1, characterized in that, The method further includes: When the fourth alternative material information is not empty, an alternative material maintenance instruction is generated based on the usage ratio in the fourth alternative material information. The alternative material maintenance instruction includes at least the usage ratio information of all alternative materials in the fourth alternative material information. Based on the usage ratio in the third alternative material information, calculate the correspondence between the usage ratio in the third alternative material information and the consumption time of each alternative material in the third alternative material information; Based on the aforementioned time correspondence, a schedule for updating alternative material information is set.

5. A material dispensing device, characterized in that, The device includes: The acquisition module is used to acquire the first alternative material information in the BOM information and the second alternative material information in the current alternative material information database in response to the BOM information update; The acquisition module is further configured to, in response to new BOM information or modified BOM information, acquire the first substitute material information in the new BOM information or modified BOM information and the second substitute material information in the current substitute material information database; The matching module is used to match the first substitute material information with the corresponding part of the second substitute material information to obtain a first matching result; The information update module is used to update the alternative material information database based on the first matching result, the first alternative material information, and the second alternative material information to obtain an alternative material information database containing the third alternative material information. The information update module includes: An information establishment module is used to, based on the first matching result and the first alternative material information, designate the alternative material information for which the second alternative material information and the first alternative material information did not match successfully as the fourth alternative material information; and to fill the usage ratio of the fourth alternative material information with the usage ratio of the portion of the first alternative material information corresponding to the fourth alternative material information. The information replacement module is used to, based on the first matching result and the second alternative material information, take the alternative material information that is successfully matched with the first alternative material information as the fifth alternative material information; and fill the usage ratio in the fifth alternative material information with the usage ratio in the second alternative material information corresponding to the fifth alternative material information. The information merging module is used to merge the fourth substitute material information and the fifth substitute material information to obtain the third substitute material information; The information replacement module is further configured to replace the second substitute material information with the third substitute material information and store it in the substitute material information database.

6. The apparatus according to claim 5, characterized in that, The device further includes: The grouping module is used to group the data in the first alternative material information based on the associated information in the newly created BOM information or modified BOM information, and remove duplicate items in the associated information group according to the substitution relationship of the alternative materials and the factory information of the alternative materials to obtain the first alternative material information group. The grouping module is further configured to, based on the associated information in the second alternative material information in the current alternative material information database, group the data in the second alternative material information according to the associated information to obtain the second alternative material information group; The instruction generation module is used to generate a substitute material maintenance instruction based on the usage ratio in the fourth substitute material information when the fourth substitute material information is not empty. The substitute material maintenance instruction includes at least the usage ratio information of all substitute materials in the fourth substitute material information. The schedule setting module is used to calculate the correspondence between the usage ratio in the third alternative material information and the time consumption of each alternative material in the third alternative material information, based on the usage ratio in the third alternative material information; and to set the alternative material information update schedule based on the time correspondence.

7. An electronic device, characterized in that, include: At least one processor; as well as A memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor to enable the at least one processor to perform a material dispensing method according to any one of claims 1-4.

8. A non-transitory computer-readable storage medium storing computer instructions, characterized in that, The computer instructions are used to cause the computer to execute a material distribution method according to any one of claims 1-4.

Images