A processing method, device, equipment and medium for responding to data changes
By developing independent demand based on the associated BOM in the MRP system, analyzing business data demand step by step and allocating supply volume, the problem of low computing efficiency in traditional MRP algorithms when demand or BOM changes is solved, and the supply and demand balance of fast response and efficient calculation is achieved.
Patent Information
- Application Number
- CN202510067900.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2025-01-16
- Publication Date
- 2025-05-06
- Estimated Expiration
- 2045-01-16
AI Technical Summary
When demand or BOM changes, traditional MRP algorithms cannot quickly and efficiently calculate the supply and demand situation before and after the change, resulting in the system occupying a large amount of resources when data is updated, affecting the process of other operations.
When unfolding independent demands based on the associated BOM, the business data requirements are analyzed step by step, and the demand information within the independent demand range is screened based on the identification of the business data, the demand quantity of each material is calculated, the supply quantity is generated, the supply quantity is matched, the demand material SKU and demand time are allocated.
By controlling the effective demand range, the overall computing range is reduced. When responding to changes in demand, there is no need to continuously record every change in demand and supply, which improves computing efficiency and reduces system load.
Smart Images

Figure CN119476900B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of data processing technology, and in particular to a processing method, device, equipment and medium for responding to data changes. Background Art
[0002] In the manufacturing industry, especially in equipment manufacturing enterprises that design and produce at the same time, since their product BOM (Bill of Materials) is usually gradually improved, and production is also completed step by step based on components, it is necessary to be able to analyze the actual supply gap based on the changes in BOM based on sales orders, and continuously perform supply and demand balance analysis based on the sales orders during the production process to make up for the supply shortage.
[0003] Material Requirement Planning (MRP) refers to a demand plan that takes materials as the planning object and uses the demand time of finished products as the time basis. It is carried out step by step according to the independent demand of finished products and the BOM of finished products to form the related demand of multi-level semi-finished products and materials. It combines the inventory status and in-transit execution of each material to conduct supply and demand balance analysis, calculate the shortage of materials, replenish material supply, and arrange a reasonable production schedule.
[0004] The planning operation demand structure is complex, and the supply volume covers all in-transit business documents in the system. Therefore, as demand and supply continue to change, data update operations are essential during the planning operation process. However, when the data volume is large, update operations often take up a lot of resources, take a lot of time, and affect the progress of other operations.
[0005] The traditional MRP algorithm is based on global net demand and net change calculations, and cannot be performed within the specified demand range. Especially when demand or BOM changes, the system cannot quickly and efficiently calculate the difference in supply and demand before and after the change, adjust the plan in time, and make a reasonable material replenishment plan.
[0006] There are currently two relatively mature algorithms for material requirements planning based on supply and demand changes:
[0007] 1) Full rescheduling: The master production plan is completely re-formulated, the bill of materials is re-expanded, and the priority of material requirements is re-arranged. The original plan will be deleted and re-arranged. When it is frequently calculated, the impact on the system is large, the performance overhead is also large, and it has certain limitations.
[0008] 2) Net change: During the first calculation, material requirements planning is performed for materials in demand. During the second calculation, the material data that has changed is first found to reduce the calculation scope, but the difference before and after the demand change still needs to be recorded, and the difference within the corresponding time period needs to be extracted. Since there is quantity transfer and quantity change between in-transit documents, a large amount of redundant data needs to be recorded for the business documents before and after the change. When the difference demand is analyzed based on the BOM, the calculation complexity of supply and demand difference offset is still high, and the calculation performance is limited. Summary of the invention
[0009] The present application shows a processing method, device, equipment and medium for responding to data changes.
[0010] In a first aspect, the present application provides a method for processing a response to a data change, the method comprising:
[0011] When independent requirements are developed based on the associated BOM, the business data requirements are analyzed level by level, and the demand information within the scope of the independent requirements is screened according to the identifier of the business data, wherein the demand information within the scope of the independent requirements at least includes the production plan generated by historical calculations and the production processing orders generated by its circulation, and the final demand scope is confirmed;
[0012] Perform material requirement planning calculation on the demand information within the independent demand range to calculate the demand quantity of each material;
[0013] Filter all related supply quantities according to the identifier of the business data, and generate a temporary supply quantity data table based on the material SKU and time dimensions;
[0014] According to the temporary supply data table and low-order code, the demand material SKU and demand time are matched to allocate the supply.
[0015] Optionally, performing material requirement planning operation on the demand information within the independent demand range to calculate the demand quantity of each material includes:
[0016] According to the bill of materials, obtain the low-order code of each material;
[0017] Sort the materials by the size of the low-order code and calculate the demand for each material.
[0018] Optionally, the method further comprises:
[0019] Determine independent demands within a preset range according to demand documents (including sales orders and forecasts, etc.), wherein the demand documents at least include sales orders and forecasts, and generate an identification scheme corresponding to the demand documents;
[0020] Based on the identification information of the independent demand range, the matching situation between the demand range and the identification scheme corresponding to the demand document is determined, and it is judged whether this change generates a new unique identification.
[0021] Optionally, the method further comprises:
[0022] Under the premise of maintaining the same unique identifier, the scope of independent requirements corresponding to the unique identifier is expanded.
[0023] Optionally, the method further comprises:
[0024] When the supply is insufficient, a net demand is generated, new supply is supplemented, and related material plans are generated.
[0025] In a second aspect, the present application provides a processing device for responding to data changes, the device comprising:
[0026] An analysis module is used to analyze business data requirements level by level when developing independent requirements based on the associated BOM, and filter demand information within the scope of independent requirements according to the identifier of the business data, wherein the demand information within the scope of independent requirements at least includes the production plan generated by historical calculations and the production processing order generated by its circulation, and confirm the final demand scope;
[0027] A calculation module, used to perform material requirement planning operations on the demand information within the independent demand range to calculate the demand quantity of each material;
[0028] A generation module, used for filtering all related supply quantities according to the identification of the business data, and generating a temporary supply quantity data table based on the material SKU and time dimensions;
[0029] The matching module is used to match the demand material SKU and demand time according to the temporary supply data table and the low-order code, and allocate the supply quantity.
[0030] Optionally, the computing module is used to:
[0031] According to the bill of materials, obtain the low-order code of each material;
[0032] Sort the materials by the size of the low-order code and calculate the demand for each material.
[0033] Optionally, the matching module is used to:
[0034] Determine independent demands within a preset range according to demand documents, wherein the demand documents at least include sales orders and forecast orders, and generate an identification scheme corresponding to the demand documents;
[0035] Based on the identification information of the independent demand range, the matching situation between the demand range and the identification scheme corresponding to the demand document is determined, and it is judged whether this change generates a new unique identification.
[0036] Optionally, the matching module is used to:
[0037] Under the premise of maintaining the same unique identifier, the scope of independent requirements corresponding to the unique identifier is expanded.
[0038] Optionally, the matching module is used to:
[0039] When the supply is insufficient, a net demand is generated, new supply is supplemented, and related material plans are generated.
[0040] In a third aspect, the present application shows an electronic device, which includes: a processor; a memory for storing processor-executable instructions; wherein the processor is configured to execute the method described in any of the above aspects.
[0041] In a fourth aspect, the present application illustrates a non-temporary computer-readable storage medium, which, when instructions in the storage medium are executed by a processor of an electronic device, enables the electronic device to execute a method as described in any of the above aspects.
[0042] In a fifth aspect, the present application illustrates a computer program product. When instructions in the computer program product are executed by a processor of an electronic device, the electronic device is enabled to execute the method described in any of the above aspects.
[0043] The technical solution provided by the present application may include the following beneficial effects: The embodiment of the present application provides a processing method and device for responding to data changes, including analyzing business data requirements step by step when expanding independent requirements based on associated BOMs, and filtering demand information within the scope of independent requirements according to the identifier of the business data, wherein the demand information within the scope of the independent requirements at least includes a production plan generated by historical calculations and a production processing order generated by its circulation, and confirming the final demand range; performing material requirement planning calculations on the demand information within the scope of the independent requirements to calculate the demand quantity of each material; filtering all associated supply quantities according to the identifier of the business data, and generating a temporary supply quantity data table based on the material SKU and time dimensions; matching the demand material SKU and demand time according to the temporary supply quantity data table and the low-order code, and allocating the supply quantity, reducing the overall calculation scope by controlling the effective demand range, and in response to changes in demand, there is no need to continuously record each change in demand and supply, and by generating a unique identifier during the first calculation, marking the generated supply quantity, extracting the latest supply quantity within the effective demand range through the original unique identifier during the second calculation to perform a supply and demand balance calculation, and generating a differential supply quantity within the effective demand range. BRIEF DESCRIPTION OF THE DRAWINGS
[0044] Figure 1 It is a flowchart of the steps of a processing method for responding to data changes in the present application.
[0045] Figure 2 This is a flowchart of the steps of another processing method for responding to data changes in the present application.
[0046] Figure 3 This is a flowchart of the steps of another processing method for responding to data changes in the present application.
[0047] Figure 4 This is a flowchart of the steps of another processing method for responding to data changes in the present application.
[0048] Figure 5 This is a flowchart of the steps of another processing method for responding to data changes in the present application.
[0049] Figure 6 It is a structural block diagram of a processing device for responding to data changes in the present application.
[0050] Figure 7 It is a block diagram of an electronic device of the present application.
[0051] Figure 8 It is a block diagram of a computer-readable storage medium of the present application. DETAILED DESCRIPTION
[0052] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.
[0053] Reference Figure 1 , shows a flowchart of a method for processing a response data change of the present application, which can be applied to an electronic device, wherein the method may specifically include the following steps:
[0054] S101, when independent demand is expanded based on the associated BOM, the business data demand is analyzed level by level, and the demand information within the scope of the independent demand is screened according to the identification of the business data, wherein the demand information within the scope of the independent demand at least includes the production plan generated by the historical calculation and the production processing order generated by its circulation, and the final demand scope is confirmed;
[0055] S102, performing material requirement planning calculation on the demand information within the independent demand range to calculate the demand quantity of each material;
[0056] S103, filter all related supply quantities according to the identifier of the business data, and generate a temporary supply quantity data table based on the material SKU and time dimension;
[0057] S104. According to the temporary supply data table and the low-order code, the required material SKU and the required time are matched and the supply quantity is allocated.
[0058] The embodiment of the present application provides a processing method and device for responding to data changes, including: when expanding independent demands based on associated BOMs, analyzing business data demands step by step, and filtering demand information within the scope of independent demands according to the identifier of business data, wherein the demand information within the scope of independent demands at least includes a production plan generated by historical calculations and a production processing order generated by its circulation, and confirming the final demand range; performing material requirement planning calculations on the demand information within the scope of independent demands to calculate the demand quantity of each material; filtering all associated supply quantities according to the identifier of business data, and generating a temporary supply quantity data table based on material SKU and time dimensions; matching the demand material SKU and demand time according to the temporary supply quantity data table and low-order codes, and allocating supply quantities, and reducing the overall calculation scope by controlling the effective demand range. When responding to changes in demand, there is no need to continuously record each change in demand and supply. By generating a unique identifier during the first calculation, the generated supply quantity is marked, and the latest supply quantity within the effective demand range is extracted through the original unique identifier during the second calculation to perform a supply and demand balance calculation, thereby generating a differential supply quantity within the effective demand range.
[0059] Another embodiment of the present application further supplements the processing method for responding to data changes provided in the above embodiment.
[0060] Optionally, perform material requirement planning operations on the demand information within the independent demand range to calculate the demand quantity of each material, including:
[0061] According to the bill of materials, obtain the low-order code of each material;
[0062] Sort the materials by the size of the low-order code and calculate the demand for each material.
[0063] Optionally, the method further comprises:
[0064] Determine the independent demand within the preset range according to the demand documents (including sales orders and forecasts, etc.). The demand documents include at least sales orders and forecasts, and generate identification schemes corresponding to the demand documents;
[0065] Based on the identification information of the independent demand range, determine the matching of the identification scheme corresponding to the demand range and its demand document, and judge whether this change generates a new unique identifier.
[0066] Optionally, the method further comprises:
[0067] Under the premise of maintaining the same unique identifier, expand the scope of independent requirements corresponding to the unique identifier.
[0068] Optionally, the method further comprises:
[0069] When the supply is insufficient, a net demand is generated, new supply is supplemented, and related material plans are generated.
[0070] The present invention controls the effective demand range and reduces the overall calculation range. When responding to changes in demand, there is no need to continuously record each change in demand and supply. A unique identifier is generated during the first calculation, and the generated supply is marked. When calculating again, the latest supply within the effective demand range is extracted through the original unique identifier to perform supply and demand balance calculation, thereby generating a differential supply within the effective demand range.
[0071] A unique identifier is generated based on the independent demand selected by the user. When the BOM associated with the independent demand is expanded, the related demands are analyzed level by level, the supply documents marked with the unique identifier are screened, the supply gap is calculated, the net demand is generated, and the related plans generated by the net demand are marked with the unique identifier to form the marked supply quantity.
[0072] After the subsequent demand or BOM structure changes, the demand range set by the unique identifier is calculated again. In addition to the original demand associated with the unique identifier, the in-transit production plan and production processing order associated with the unique identifier are screened to expand the effective marked demand range. The supply difference required compared to the previous calculation is directly analyzed in combination with the supply quantity associated with the unique identifier. There is no need to record and analyze the change process of all demand and supply documents. The net demand difference can be directly calculated, and then a new supply plan is generated in response to the demand change. The present invention avoids the need to continuously record each change process for supply and demand changes in the traditional net change algorithm, and analyze the supply and demand difference one by one. The computational overhead brought to the system, such as Figure 2 shown.
[0073] When the material requirement plan performs supply and demand balance calculations, it expands the independent demand for finished products based on the independent demand for finished products (such as sales orders, demand forecasts, etc.) in combination with the BOM structure, analyzes the demand for semi-finished products and materials step by step, and calculates the net demand in combination with the current system inventory and the procurement and production in transit of the corresponding materials to form a supply plan. The generated supply plan can be circulated to downstream businesses in batches for multiple times to carry out procurement, production, warehousing and outbound operations. As time changes, the supply and demand quantities of the corresponding materials continue to change. Examples of related business flows include: Figure 3 shown.
[0074] To cope with the above complex changes in supply and demand, the traditional net change algorithm not only needs to track the change process of each business document, but also needs to accurately extract the corresponding supply and demand changes within two calculation times. The algorithm has high implementation complexity and low calculation efficiency.
[0075] The present invention controls the effective demand range based on the selected independent demand, and uses the identification information of the independent demand to determine whether to generate a new unique identifier, which is used to mark the demand range selected this time. When the demand changes and is calculated again based on the unique identifier, the initial supply and the changed demand can be filtered out through the identifier, which is convenient for responding to changes in demand and calculating the net change as the difference supply to be supplemented.
[0076] like Figure 4 As shown, the first operation uses the selected independent demand range, expands the independent demand based on the associated BOM, analyzes the related demands step by step, and marks the unique identifier as the initial demand. At the same time, the supply documents marked with the unique identifier are screened, the supply gap is calculated, the net demand is generated, and the supply generated for the net demand and the supply allocated by the operation are marked with the unique identifier as the initial supply.
[0077] After the business data has been changed several times, the demand and supply are expressed as follows:
[0078] ①
[0079] ②
[0080] in, and represents the increase / decrease of the ith time, and n / m represents the total number of times. This formula represents the cumulative demand / supply change from the 1st time to the n / mth time.
[0081] According to the definition of the difference supply C to be supplemented after the change, the following formula can be obtained:
[0082]
[0083] After substituting formula ①② for conversion, the net change C can be expressed as:
[0084]
[0085] Since after the first calculation, the net demand generates the supply, the supply and demand balance is achieved within the range of the demand and supply marked by the unique identification, that is: .
[0086] Therefore, the difference supply to be supplemented after the change is finally expressed as:
[0087]
[0088] Since this formula only takes the final demand and supply after the change, it can be used for direct calculation even if multiple changes occur, without paying attention to the change process.
[0089] In actual business, the demand and supply will be transferred through sales orders, production plans, purchase plans, production processing orders, purchase orders and other businesses. In order to obtain the effective changed demand, the unique identifier needs to be transferred during the document transfer process. After business transfer and quantity adjustment (i.e. the supply and demand changes mentioned above), the changed demand and supply in the above formula can still be accurately obtained.
[0090] After the subsequent demand or BOM structure changes, the demand range set by the unique identifier is calculated again, and the valid demand range is selected as the changed demand. According to the marked independent demand document, the in-transit production plan and production processing order are selected as the related demand documents, and the demand of the related demand parts is calculated according to the BOM structure corresponding to the document to form the effective demand after the change.
[0091] The business documents to be stored are selected according to the identification as the effective supply. The difference supply generated by the previous operation can be directly analyzed in combination with the initial supply associated with the unique identification. There is no need to record and analyze the change process of all demand and supply documents. The difference net demand can be directly calculated, and then the new difference supply can be generated according to the change in demand.
[0092] like Figure 5 As shown, in scenario 1, the identifier of the independent demand range is used to determine whether this operation is the first operation. If it is the first operation, a new unique identifier is generated. Since it is a new identifier, the unidentified supply is allocated to the demand, and the net demand is calculated directly.
[0093] Scenario 2: If the demand and supply documents in the system change, the independent demand range is checked for unique identifiers during calculation, and the calculation is performed again based on the original unique identifier. This device filters all related demand and supply quantities based on the historical unique identifier to calculate the supply difference of the demand change.
[0094] Step 1: Select demand documents (including sales orders and forecasts, etc.) to form independent demand within a specified range and generate a unique identification scheme.
[0095] Based on the identification information of the independent demand range (order, material SKU, etc.), the match between the demand range and its unique identifier is determined, and it is confirmed whether a new unique identifier should be generated this time. At the same time, it supports users to manually expand the independent demand range of the identifier while maintaining the same unique identifier, thereby improving the flexibility and autonomy of the effective demand range.
[0096] Step 2: When expanding independent requirements based on the associated BOM, analyze the related requirements step by step. Filter the related requirements within the scope of the independent requirements based on the unique identifier, including the production plan generated by historical calculations and the production processing orders generated by its flow, and confirm the final demand range.
[0097] Step 3: Perform material requirement planning calculations based on the final confirmed demand range and calculate the demand for each material as follows:
[0098] According to the expanded bill of materials, the low-level code of each material is obtained;
[0099] Sort the materials by the size of the low-order code and calculate the demand for each material.
[0100] Step 4: Filter all related supply quantities based on the unique identifier, and generate a temporary supply quantity data table based on the material SKU and time dimensions.
[0101] Step 5: Within the above supply range, match the demand material SKU and demand time according to the low-order code, allocate the supply, generate net demand when the supply is insufficient, supplement and generate new supply, generate relevant material plans, and meet production needs.
[0102] Advantages of the present invention in updating supply data in response to demand changes:
[0103] When BOM changes cause the processing order to increase materials and change the usage, the traditional calculation method needs to identify each independent demand and related demand document one by one to see if there is a change, filter out the change that only occurs between two operations, and then calculate the increase or decrease in demand. Then, based on the BOM structure, the changed demand is expanded step by step, and the supply satisfaction and the difference net demand are analyzed step by step. The calculation is complex and the operation efficiency is low.
[0104] The present invention does not need to record the historical changes in documents of the business system, and does not need to pay attention to the quantity flow and quantity change process of business documents. It uses the latest initial supply at the time of unique identification filtering operation as the comparison benchmark data, and directly calculates the net demand by comparing the demand filtered by the unique identification. This net demand is the incremental supply plan that needs to be generated compared with the data before the demand changes, so as to ensure the supply and demand balance within the specified demand range.
[0105] After using this technical solution, users can perform material shortage analysis based on sales orders in the T+ system, give priority to satisfying the currently selected sales orders to achieve supply and demand balance, ensure that orders are delivered on schedule, and track the execution of related materials by order. Especially for users who design and produce at the same time, due to frequent changes in BOM and frequent adjustments in materials used in processing orders during the production process, it is necessary to continuously maintain the supply and demand balance of the sales order. After using this technology, such demands of customers can be met, and the corresponding demand changes can be continuously responded to, and the difference supply can be continuously supplemented to avoid production interruptions due to material shortages.
[0106] The present invention has been experimentally verified in the T+ system. After the bill of materials and the production processing order are changed, the material requirement planning calculation is performed again. The difference supply caused by the change of the original sales order-related business documents can be analyzed, and a new production and procurement outsourcing plan can be generated to maintain the balance between supply and demand and ensure the steady operation of the order production.
[0107] The embodiment of the present application provides a processing method and device for responding to data changes, including: when expanding independent demands based on associated BOMs, analyzing business data demands step by step, and filtering demand information within the scope of independent demands according to the identifier of business data, wherein the demand information within the scope of independent demands at least includes a production plan generated by historical calculations and a production processing order generated by its circulation, and confirming the final demand range; performing material requirement planning calculations on the demand information within the scope of independent demands to calculate the demand quantity of each material; filtering all associated supply quantities according to the identifier of business data, and generating a temporary supply quantity data table based on material SKU and time dimensions; matching the demand material SKU and demand time according to the temporary supply quantity data table and low-order codes, and allocating supply quantities, and reducing the overall calculation scope by controlling the effective demand range. When responding to changes in demand, there is no need to continuously record each change in demand and supply. By generating a unique identifier during the first calculation, the generated supply quantity is marked, and the latest supply quantity within the effective demand range is extracted through the original unique identifier during the second calculation to perform a supply and demand balance calculation, thereby generating a differential supply quantity within the effective demand range.
[0108] It should be noted that each implementable method in this embodiment may be implemented separately, or may be implemented in combination in any combination without conflict, and this application is not limited thereto.
[0109] Another embodiment of the present application provides a processing device for responding to data changes, which is used to execute the processing method for responding to data changes provided in the above embodiment.
[0110] like Figure 6 , which is a schematic diagram of the structure of a processing device for responding to data changes provided in an embodiment of the present application. The processing device for responding to data changes includes an analysis module 601, a calculation module 602, a generation module 603 and a matching module 604, wherein:
[0111] The analysis module 601 is used to analyze the business data requirements level by level when expanding independent requirements based on the associated BOM, and filter the demand information within the scope of the independent requirements according to the identification of the business data, wherein the demand information within the scope of the independent requirements at least includes the production plan generated by the historical calculation and the production processing order generated by its circulation, and confirm the final demand scope;
[0112] The calculation module 602 is used to perform material requirement planning calculations on the demand information within the independent demand range and calculate the demand quantity of each material;
[0113] The generation module 603 is used to filter all related supply quantities according to the identification of the business data, and generate a temporary supply quantity data table based on the material SKU and time dimensions;
[0114] The matching module 604 is used to match the demand material SKU and demand time according to the supply quantity temporary data table and the low-order code, and allocate the supply quantity.
[0115] Regarding the device in this embodiment, the specific manner in which each module performs operations has been described in detail in the embodiment of the method, and will not be elaborated here.
[0116] The embodiment of the present application provides a processing method and device for responding to data changes, including: when expanding independent demands based on associated BOMs, analyzing business data demands step by step, and filtering demand information within the scope of independent demands according to the identifier of business data, wherein the demand information within the scope of independent demands at least includes a production plan generated by historical calculations and a production processing order generated by its circulation, and confirming the final demand range; performing material requirement planning calculations on the demand information within the scope of independent demands to calculate the demand quantity of each material; filtering all associated supply quantities according to the identifier of business data, and generating a temporary supply quantity data table based on material SKU and time dimensions; matching the demand material SKU and demand time according to the temporary supply quantity data table and low-order codes, and allocating supply quantities, and reducing the overall calculation scope by controlling the effective demand range. When responding to changes in demand, there is no need to continuously record each change in demand and supply. By generating a unique identifier during the first calculation, the generated supply quantity is marked, and the latest supply quantity within the effective demand range is extracted through the original unique identifier during the second calculation to perform a supply and demand balance calculation, thereby generating a differential supply quantity within the effective demand range.
[0117] Another embodiment of the present application further supplements the processing device for responding to data changes provided in the above embodiment.
[0118] Optionally, the computing module is used to:
[0119] According to the bill of materials, obtain the low-order code of each material;
[0120] Sort the materials by the size of the low-order code and calculate the demand for each material.
[0121] Optionally, a matching module is used to:
[0122] Determine independent demands within a preset range according to demand documents, where the demand documents include at least a sales order and a forecast document, and generate an identification scheme corresponding to the demand documents;
[0123] Based on the identification information of the independent demand range, determine the matching of the identification scheme corresponding to the demand range and its demand document, and judge whether this change generates a new unique identifier.
[0124] Optionally, a matching module is used to:
[0125] Under the premise of maintaining the same unique identifier, expand the scope of independent requirements corresponding to the unique identifier.
[0126] Optionally, a matching module is used to:
[0127] When the supply is insufficient, a net demand is generated, new supply is supplemented, and related material plans are generated.
[0128] As for the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.
[0129] The embodiment of the present application provides a processing method and device for responding to data changes, including: when expanding independent demands based on associated BOMs, analyzing business data demands step by step, and filtering demand information within the scope of independent demands according to the identifier of business data, wherein the demand information within the scope of independent demands at least includes a production plan generated by historical calculations and a production processing order generated by its circulation, and confirming the final demand range; performing material requirement planning calculations on the demand information within the scope of independent demands to calculate the demand quantity of each material; filtering all associated supply quantities according to the identifier of business data, and generating a temporary supply quantity data table based on material SKU and time dimensions; matching the demand material SKU and demand time according to the temporary supply quantity data table and low-order codes, and allocating supply quantities, and reducing the overall calculation scope by controlling the effective demand range. When responding to changes in demand, there is no need to continuously record each change in demand and supply. By generating a unique identifier during the first calculation, the generated supply quantity is marked, and the latest supply quantity within the effective demand range is extracted through the original unique identifier during the second calculation to perform a supply and demand balance calculation, thereby generating a differential supply quantity within the effective demand range.
[0130] Optionally, an embodiment of the present application further provides an electronic device, comprising: a processor, a memory, and a computer program stored in the memory and executable on the processor. When the computer program is executed by the processor, the various processes of the above-mentioned method embodiment are implemented, and the same technical effect can be achieved. To avoid repetition, it will not be described here.
[0131] The embodiment of the present application also provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, each process of the above method embodiment is implemented, and the same technical effect can be achieved. To avoid repetition, it is not repeated here. Among them, the computer-readable storage medium is, for example, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk, etc.
[0132] Figure 7 800 is a block diagram of an electronic device 800 shown in the present application. For example, the electronic device 800 may be a mobile phone, a computer, a digital broadcast terminal, a messaging device, a game console, a tablet device, a medical device, a fitness device, a personal digital assistant, etc.
[0133] Reference Figure 7 , the electronic device 800 may include one or more of the following components: a processing component 802 , a memory 804 , a power component 806 , a multimedia component 808 , an audio component 810 , an input / output interface 812 , a sensor component 814 , and a communication component 816 .
[0134] The processing component 802 generally controls the overall operation of the electronic device 800, such as operations associated with display, phone calls, data communications, camera operations, and recording operations. The processing component 802 may include one or more processors 820 to execute instructions to complete all or part of the steps of the above method. In addition, the processing component 802 may include one or more modules to facilitate the interaction between the processing component 802 and other components. For example, the processing component 802 may include a multimedia module to facilitate the interaction between the multimedia component 808 and the processing component 802.
[0135] The memory 804 is configured to store various types of data to support operations on the device 800. Examples of such data include instructions for any application or method operating on the electronic device 800, contact data, phone book data, messages, images, videos, etc. The memory 804 can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic disk or optical disk.
[0136] The power supply component 806 provides power to the various components of the electronic device 800. The power supply component 806 may include a power management system, one or more power supplies, and other components associated with generating, managing, and distributing power to the electronic device 800.
[0137] The multimedia component 808 includes a screen that provides an output interface between the electronic device 800 and the user. In some embodiments, the screen may include a liquid crystal display (LCD) and a touch panel (TP). If the screen includes a touch panel, the screen may be implemented as a touch screen to receive input signals from the user. The touch panel includes one or more touch sensors to sense touch, slide, and gestures on the touch panel. The touch sensor may not only sense the boundaries of the touch or slide action, but also detect the duration and pressure associated with the touch or slide operation. In some embodiments, the multimedia component 808 includes a front camera and / or a rear camera. When the device 800 is in an operating mode, such as a shooting mode or a video mode, the front camera and / or the rear camera may receive external multimedia data. Each front camera and rear camera may be a fixed optical lens system or have a focal length and optical zoom capability.
[0138] The audio component 810 is configured to output and / or input audio signals. For example, the audio component 810 includes a microphone (MIC), and when the electronic device 800 is in an operating mode, such as a call mode, a recording mode, and a voice recognition mode, the microphone is configured to receive an external audio signal. The received audio signal can be further stored in the memory 804 or sent via the communication component 816. In some embodiments, the audio component 810 also includes a speaker for outputting audio signals.
[0139] The input / output interface 812 provides an interface between the processing component 802 and the peripheral interface modules, which may be keyboards, click wheels, buttons, etc. These buttons may include but are not limited to: a home button, a volume button, a start button, and a lock button.
[0140] The sensor assembly 814 includes one or more sensors for providing various aspects of status assessment for the electronic device 800. For example, the sensor assembly 814 can detect the open / closed state of the device 800, the relative positioning of components, such as the display and keypad of the electronic device 800, and the sensor assembly 814 can also detect the position change of the electronic device 800 or a component of the electronic device 800, the presence or absence of contact between the user and the electronic device 800, the orientation or acceleration / deceleration of the electronic device 800, and the temperature change of the electronic device 800. The sensor assembly 814 may include a proximity sensor configured to detect the presence of nearby objects without any physical contact. The sensor assembly 814 may also include an optical sensor, such as a CMOS or CCD image sensor, for use in imaging applications. In some embodiments, the sensor assembly 814 may also include an accelerometer, a gyroscope sensor, a magnetic sensor, a pressure sensor, or a temperature sensor.
[0141] The communication component 816 is configured to facilitate wired or wireless communication between the electronic device 800 and other devices. The electronic device 800 can access a wireless network based on a communication standard, such as WiFi, a carrier network (such as 2G, 3G, 4G or 5G), or a combination thereof. In an exemplary embodiment, the communication component 816 receives a broadcast signal or broadcast operation information from an external broadcast management system via a broadcast channel. In an exemplary embodiment, the communication component 816 also includes a near field communication (NFC) module to facilitate short-range communication. For example, the NFC module can be implemented based on radio frequency identification (RFID) technology, infrared data association (IrDA) technology, ultra-wideband (UWB) technology, Bluetooth (BT) technology and other technologies.
[0142] In an exemplary embodiment, the electronic device 800 may be implemented by one or more application specific integrated circuits (ASICs), digital signal processors (DSPs), digital signal processing devices (DSPDs), programmable logic devices (PLDs), field programmable gate arrays (FPGAs), controllers, microcontrollers, microprocessors, or other electronic components to perform the above methods.
[0143] In an exemplary embodiment, a non-transitory computer-readable storage medium including instructions is also provided, such as a memory 804 including instructions, and the instructions can be executed by a processor 820 of an electronic device 800 to perform the above method. For example, the non-transitory computer-readable storage medium can be a ROM, a random access memory (RAM), a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, etc.
[0144] Figure 819 is a block diagram of a computer-readable storage medium 1900 shown in the present application. For example, the computer-readable storage medium 1900 may be provided as a server.
[0145] Reference Figure 8 , the computer-readable storage medium 1900 includes a processing component 1922, which further includes one or more processors, and a memory resource represented by a memory 1932 for storing instructions, such as an application, that can be executed by the processing component 1922. The application stored in the memory 1932 may include one or more modules, each corresponding to a set of instructions. In addition, the processing component 1922 is configured to execute instructions to perform the above method.
[0146] The computer readable storage medium 1900 may also include a power supply component 1926 configured to perform power management of the computer readable storage medium 1900, a wired or wireless network interface 1950 configured to connect the computer readable storage medium 1900 to a network, and an input and output interface 1958. The computer readable storage medium 1900 may operate based on an operating system stored in the memory 1932, such as Windows Server™, Mac OS X™, Unix™, Linux™, FreeBSD™ or the like.
[0147] It should be noted that, in this article, the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, an element defined by the sentence "comprises a ..." does not exclude the existence of other identical elements in the process, method, article or device including the element.
[0148] Through the description of the above implementation methods, those skilled in the art can clearly understand that the above-mentioned embodiment methods can be implemented by means of software plus a necessary general hardware platform, and of course by hardware, but in many cases the former is a better implementation method. Based on such an understanding, the technical solution of the present application, or the part that contributes to the prior art, can be embodied in the form of a software product, which is stored in a storage medium (such as ROM / RAM, a magnetic disk, or an optical disk), and includes a number of instructions for a terminal (which can be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to execute the methods described in each embodiment of the present application.
[0149] The embodiments of the present application are described above in conjunction with the accompanying drawings, but the present application is not limited to the above-mentioned specific implementation methods. The above-mentioned specific implementation methods are merely illustrative and not restrictive. Under the guidance of the present application, ordinary technicians in this field can also make many forms without departing from the purpose of the present application and the scope of protection of the claims, all of which are within the protection of the present application.
[0150] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed in the present application can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this application.
[0151] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.
[0152] In the embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.
[0153] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
[0154] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.
[0155] If the functions are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application, or the part that contributes to the prior art or the part of the technical solution, can be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for a computer device (which can be a personal computer, server, or network device, etc.) to perform all or part of the steps of the methods described in each embodiment of the present application. The aforementioned storage medium includes: various media that can store program codes, such as USB flash drives, mobile hard drives, ROM, RAM, magnetic disks, or optical disks.
[0156] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any person skilled in the art who is familiar with the present technical field can easily think of changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.
Claims
1. A method for processing a response data change, characterized in that: The method comprises: Select the demand document to form an independent demand within a specified range, generate a unique identification scheme, circulate the unique identification during the document circulation process, and analyze the related demands step by step when expanding the independent demand based on the associated BOM; after the subsequent demand or BOM structure changes, recalculate the demand range set by the unique identification, and filter the related demands within the independent demand range according to the unique identification. The related demands include the production plan generated by the historical calculation and the production processing order generated by its circulation, and confirm the final demand range; Perform material requirement planning based on the final confirmed demand range and calculate the demand for each material; Filter all related supply quantities based on the unique identifier, and generate a temporary supply quantity data table based on the material SKU and time dimensions; According to the temporary supply data table and low-order code, the demand material SKU and demand time are matched, the supply is allocated, and when the supply is insufficient, a net demand is generated, and a new supply is generated to supplement and generate related material plans to meet production needs.
2. The method for processing response data changes according to claim 1, characterized in that: The material requirement planning operation is performed according to the final confirmed demand range to calculate the demand quantity of each material, including: According to the bill of materials, obtain the low-order code of each material; Sort the materials by the size of the low-order code and calculate the demand for each material.
3. The method for processing response data changes according to claim 1, characterized in that: The method further comprises: Determine independent demands within a preset range according to demand documents, wherein the demand documents at least include sales orders and forecast orders, and generate an identification scheme corresponding to the demand documents; Based on the identification information of the independent demand range, determine the matching status of the demand range and the identification scheme corresponding to the demand document it describes, and judge whether this change generates a new unique identifier.
4. The method for processing response data changes according to claim 3, characterized in that: The method further comprises: Under the premise of maintaining the same unique identifier, the scope of independent requirements corresponding to the unique identifier is expanded.
5. A processing device for responding to data changes, characterized in that: The device comprises: The analysis module selects the demand document to form an independent demand within a specified range, generates a unique identification scheme, circulates the unique identification during the document circulation process, and analyzes the related requirements step by step when the independent demand is expanded based on the associated BOM; after the subsequent demand or BOM structure changes, the demand range set by the unique identification is recalculated, and the related requirements within the independent demand range are screened according to the unique identification. The related requirements include the production plan generated by the historical calculation and the production processing order generated by its circulation, and the final demand range is confirmed; The calculation module performs material requirement planning operations based on the final confirmed demand range and calculates the demand quantity of each material; The generation module filters all related supply quantities according to the unique identifier and generates a temporary supply quantity data table based on the material SKU and time dimensions; The matching module matches the demand material SKU and demand time according to the temporary supply data table and low-order code, allocates the supply, generates a net demand when the supply is insufficient, supplements and generates new supply, generates relevant material plans, and meets production needs.
6. The processing device for responding to data changes according to claim 5, characterized in that: The calculation module is used for: According to the bill of materials, obtain the low-order code of each material; Sort the materials by the size of the low-order code and calculate the demand for each material.
7. The processing device for responding to data changes according to claim 5, characterized in that: The matching module is used for: Determine independent demands within a preset range according to demand documents, wherein the demand documents at least include sales orders and forecast orders, and generate an identification scheme corresponding to the demand documents; Based on the identification information of the independent demand range, determine the matching status of the demand range and the identification scheme corresponding to the demand document it describes, and judge whether this change generates a new unique identifier.
8. An electronic device, characterized in that: include: A processor, a memory, and a computer program stored in the memory and executable on the processor, wherein the computer program implements the method according to any one of claims 1 to 4 when executed by the processor.
9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 4 is implemented.
Citation Information
Patent Citations
Material reserved supply and demand matching method and device
CN103559558A
Adaptive material requirement plan (MRP) calculation method
CN105389653A