An ERP system-based dynamic feeding back-calculation processing method, device and medium
By using the dynamic material input back-calculation method of the ERP system, a BOM table is constructed and inventory matching queries are performed to generate material input production orders. This solves the problem of material input back-calculation deviation, improves production efficiency and inventory management accuracy, and reduces production costs.
Patent Information
- Application Number
- CN202410633019.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-05-21
- Publication Date
- 2026-08-25
- Estimated Expiration
- 2044-05-21
AI Technical Summary
Existing methods for calculating material input are susceptible to various uncertainties, leading to calculation deviations, making accurate prediction and adjustment difficult, and increasing production risks.
A dynamic material input back-calculation method based on the ERP system is adopted. By constructing a BOM table, matching and querying, determining inventory usage, and generating material input production orders, manual intervention is reduced and the degree of automation is improved.
It improved work efficiency, reduced inventory risk, optimized material usage strategies, ensured timely material supply, reduced production costs, and improved the flexibility and accuracy of inventory management.
Smart Images

Figure CN118550914B_ABST
Abstract
Description
Technical Field
[0001] This application relates to the field of enterprise information systems (ERP), and in particular to a dynamic material feeding back calculation method, equipment, and medium based on an ERP system. Background Technology
[0002] Material input back-calculation, a commonly used method in production planning and cost control, is important and practical. However, existing material input back-calculation methods are based on fixed calculation models and preset production condition parameters. In actual production, many uncertainties exist, such as raw material quality, unstable raw material supply, equipment status, and the production environment, all of which can dynamically change. These changes may cause deviations between the actual input quantity and the calculated value. Faced with these uncertainties, accurate prediction and adjustment are impossible, thus increasing production risks. Summary of the Invention
[0003] This application provides a dynamic material feeding back calculation method, equipment, and medium based on an ERP system to solve the following technical problems: existing material feeding back calculations are prone to deviations, are easily affected by various uncertain factors, are difficult to make accurate predictions and adjustments, and increase production risks.
[0004] The embodiments of this application adopt the following technical solutions:
[0005] On one hand, this application provides a dynamic material input back-calculation processing method based on an ERP system, including: constructing a Bill of Materials (BOM) table based on available inventory data in a production business system; performing a matching query on the BOM table according to the target production product to obtain the required material information; determining the available inventory usage of the maximum available production inventory based on the inventory results of the required material information to obtain a usage result; wherein, the usage result includes: a checked usage result and a non-checked usage result; if the usage result is the non-checked matching result, then determining the product quantity of the target production product based on the required material information; if the matching result is the checked matching result, then looping through the available inventory of each required material information in the BOM table to determine the product quantity of the target production product; and generating material input production order information based on the product quantity and the BOM table.
[0006] This application's embodiments reduce the need for manual product structure identification and material retrieval by directly obtaining required material information, thus improving work efficiency. It avoids errors or omissions that may occur during manual product structure identification. It ensures timely supply of required materials, reducing inventory risk. It optimizes material usage strategies in the production process, improving material utilization and production efficiency. It provides a clear understanding of the available inventory and matching status of each required material, offering strong support for production decisions. It also reduces the possibility of human intervention and errors, further ensuring smooth production and reducing production costs. Simultaneously, it improves the flexibility and accuracy of inventory management. By utilizing automatic matching and available inventory judgment, it reduces the tedious process of manual operation, improving work efficiency and accuracy. It also provides a more intuitive understanding of the inventory status and matching status of required materials, offering strong support for procurement decisions and helping enterprises ensure timely supply of required materials.
[0007] In one feasible implementation, a Bill of Materials (BOM) table is constructed based on available inventory data in the production business system. Specifically, this includes: classifying the available inventory data according to preset production data types to determine product type data and material type data; wherein the product type data includes product data and product quantity data; and the material type data includes material data and material quantity data; performing attribute tabulation processing on the product type data under relevant data structures based on a unique primary key to obtain a master BOM table; performing attribute tabulation processing on the material type data under relevant data structures based on the BOM primary key in the master BOM table to obtain subsidiary BOM tables; and associating the master BOM table and the subsidiary BOM tables under a master-slave relationship to form the final BOM table.
[0008] In one feasible implementation, the BOM table is matched and queried according to the target product to obtain the required material information. Specifically, this includes: splitting the data attributes of the target product to obtain target attribute items; wherein, the target attribute items include at least: alias items, column name items, data type items, and data content items; querying the BOM master table in the BOM table using the target attribute items to obtain product information; and querying the BOM sub-tables in the BOM table based on the product information to obtain the required material information.
[0009] In one feasible implementation, based on the inventory results where the required material information is located, a usage judgment is made on the available inventory of the maximum production capacity to obtain a usage result. Specifically, this includes: matching several inventories in the production business system based on the storage address of the required material information to obtain the specified inventory; judging the available inventory of the specified inventory under the maximum production capacity to obtain judgment result information; if the judgment result information is the available inventory under the maximum production capacity, then checking the available inventory for usage judgment to obtain the usage result.
[0010] In one feasible implementation, if the usage result is the "no matching check" result, then the product quantity of the target production product is determined based on the required material information. Specifically, this includes: if the usage result is the "no matching check" result, obtaining the required material information and extracting the BOM master table and BOM sub-table from the BOM table associated with the required material information; and determining the product quantity based on the "no matching check" result based on the required material information, the product quantity data in the BOM master table, and the material quantity data in the BOM sub-table.
[0011] In one feasible implementation, if the usage result is the check matching result, then the available inventory of each required material information in the BOM table is looped to determine the product quantity of the target production product. Specifically, this includes: if the usage result is the check matching result, then the sum of the specified inventory quantities corresponding to each material parameter in the BOM sub-table of the BOM table is looped, and the required material information, product quantity data in the BOM master table, and material quantity data in the BOM sub-table are determined in multiple loops; based on the required material information, the product quantity data in the BOM master table, and the material quantity data in the BOM sub-table, the minimum production product quantity in multiple loops is determined, and the minimum production product quantity is determined as the product quantity based on the check matching result.
[0012] In one feasible implementation, generating material input production order information based on the product quantity and the BOM table specifically includes: querying relevant auxiliary attribute items of the auxiliary materials of the target production product according to the product quantity and the BOM table to obtain auxiliary product information; and determining the material input production order information based on the product quantity, the auxiliary product information, and the BOM table.
[0013] In one feasible implementation, the data attributes of the available inventory include at least: material type attribute, warehouse attribute to which the material belongs, available quantity attribute of the material, and specified inventory attribute corresponding to the warehouse.
[0014] Secondly, embodiments of this application also provide a dynamic material feeding back calculation processing device based on an ERP system. The device includes: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor to enable the at least one processor to execute a dynamic material feeding back calculation processing method based on an ERP system as described in any of the above embodiments.
[0015] Thirdly, embodiments of this application also provide a non-volatile computer storage medium, characterized in that the storage medium is a non-volatile computer-readable storage medium, the non-volatile computer-readable storage medium stores at least one program, each program includes instructions, and when the instructions are executed by a terminal, the terminal executes a dynamic material feeding back calculation processing method based on an ERP system as described in any of the above embodiments.
[0016] This application provides a dynamic material feeding back calculation processing method, equipment, and medium based on an ERP system. Compared with the prior art, the embodiments of this application have the following beneficial technical effects:
[0017] 1. By matching and querying the BOM table, the required material information can be obtained directly, reducing the process of manually identifying product structure and visiting the required materials, and improving work efficiency.
[0018] 2. It allows for a comprehensive understanding of the specific material information required for the target product, avoiding errors or omissions that may occur when manually identifying the product structure.
[0019] 3. It can promptly remind inventory managers to replenish stock, ensuring the timely supply of required materials and reducing inventory risks.
[0020] 4. Based on the available inventory of each required material, the material usage strategy in the production process was optimized, improving material utilization and production efficiency.
[0021] 5. It provides a clear understanding of the available inventory and matching status of each required material, offering strong support for production decisions.
[0022] 6. It can quickly generate product quantity and material input production order information for the target product, reducing the possibility of manual intervention and errors.
[0023] 7. It avoids production delays caused by inaccurate or incomplete material information, ensures the smooth progress of the production process, and reduces production costs.
[0024] 8. It can meet various needs in inventory counting operations, improving the flexibility and accuracy of inventory management.
[0025] 9. By automatically matching and determining available inventory, the tedious process of manual operation is reduced, improving work efficiency and accuracy.
[0026] 10. It provides a clear understanding of the inventory status and matching of required materials, offering strong support for procurement decisions and helping companies ensure the timely supply of necessary materials. Attached Figure Description
[0027] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort. In the drawings:
[0028] Figure 1 A flowchart of a dynamic material feeding back calculation method based on an ERP system is provided for embodiments of this application;
[0029] Figure 2 This is a schematic diagram of a dynamic material feeding back calculation processing device based on an ERP system, provided as an embodiment of this application. Detailed Implementation
[0030] To enable those skilled in the art to better understand the technical solutions in this application, the technical solutions in the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, and not all embodiments. Based on the embodiments of this specification, all other embodiments obtained by those skilled in the art without creative effort should fall within the scope of protection of this application.
[0031] It should be noted that the material input back-calculation in an enterprise ERP system has the following main advantages:
[0032] 1. Optimize production planning: By calculating raw material inputs, companies can more accurately understand the raw material requirements during the production process, thereby developing more reasonable production plans. This helps avoid raw material waste and inventory backlog, and improves production efficiency and resource utilization.
[0033] 2. Cost Reduction: Back-calculation of raw material requirements helps companies accurately control production costs. By precisely calculating raw material needs, companies can avoid over-purchasing or under-purchasing, reducing unnecessary capital occupation and waste. At the same time, optimizing production planning also helps reduce other costs in the production process, such as labor costs and equipment depreciation.
[0034] 3. Improve product quality: Back-calculation of raw material input helps ensure the quality of raw materials during the production process. By accurately calculating raw material requirements, companies can ensure that the purchased raw materials meet production requirements, avoiding production delays or product quality problems caused by raw material quality issues.
[0035] 4. Responding to Market Changes: Back-calculation of material input helps companies respond quickly to market changes. When market demand changes, companies can adjust their production plans in a timely manner based on the back-calculation results, ensuring that the products produced meet market demand and improving market competitiveness.
[0036] In conclusion, reverse calculation of material input is of great significance in the production process of enterprises, helping to accurately control production plans, effectively reduce costs, steadily improve product quality, and quickly respond to market changes. Therefore, enterprises should attach importance to the application of reverse calculation of material input to improve production management and enhance overall competitiveness.
[0037] This application provides a dynamic material feeding back calculation method based on an ERP system, such as... Figure 1 As shown, the dynamic material feeding back calculation method based on the ERP system specifically includes steps S101-S106:
[0038] S101. Construct a Bill of Materials (BOM) based on available inventory data in the production business system.
[0039] Specifically, the available inventory data needs to be categorized according to the preset production data types to determine the product type data and material type data. Product type data includes product data and product quantity data. Material type data includes material data and material quantity data.
[0040] Furthermore, based on the unique primary key, the product type data is tabulated according to the relevant data structure to obtain the BOM main table.
[0041] Furthermore, based on the BOM primary key in the BOM master table, the material type data is processed into attribute tables under the relevant data structure to obtain the BOM sub-table.
[0042] Furthermore, the BOM master table and BOM slave table are linked by a master-slave relationship to form the BOM table.
[0043] Table 1
[0044] Primary key ID Varchar(36) Unique primary key product Product Varchar(36) Products to be produced Product Quantity Qty Decimal(20,8) Standard quota quantity of products
[0045] Table 2
[0046] BOM primary key BOMID Varchar(36) BOM (Bill of Materials) primary key materials Material Varchar(36) Materials needed to produce products Material quantity Qty Decimal(20,8) Quantity of materials required to produce the product
[0047] In one embodiment, Table 1 is the master BOM table based on available inventory data, and Table 2 is the subsidiary BOM table based on available inventory data. Using the master and subsidiary BOM tables, product type data and material type data can be divided and matched according to attribute items.
[0048] S102. Based on the target product, perform a matching query on the BOM table to obtain the required material information.
[0049] Specifically, the target product is first processed by splitting its data attributes to obtain target attribute items. These target attribute items include at least: alias items, column name items, data type items, and data content items.
[0050] Furthermore, by querying the main BOM table in the BOM table using the target attribute items, product information can be obtained.
[0051] Furthermore, based on the product information, the BOM sub-table in the BOM table is queried to obtain the required material information.
[0052] S103. Based on the inventory results of the required material information, determine the available inventory of the maximum production available inventory and obtain the usage result. The usage result includes: checking the usage result and not checking the usage result.
[0053] Specifically, the first step is to match several inventories in the production business system with the storage addresses of the required material information to obtain the specified inventory.
[0054] Furthermore, the available inventory under maximum productivity is determined by the specified inventory, and the determination result information is obtained.
[0055] Furthermore, if the judgment result is the available inventory with maximum productivity, then the available inventory is checked and used to obtain the usage result.
[0056] Table 3
[0057]
[0058] In one embodiment, Table 3 is an attribute table corresponding to available inventory. The data attributes of available inventory include at least: material type attribute, warehouse attribute to which the material belongs, available quantity attribute of the material, and specified inventory attribute corresponding to the warehouse.
[0059] S104. If the result is "no matching result check", then determine the quantity of the target production product based on the required material information.
[0060] Specifically, if the result is that no matching result is checked, the required material information is obtained, and the main BOM table and the sub-BOM table associated with the required material information are extracted.
[0061] Furthermore, based on the required material information, the product quantity data in the master BOM table, and the material quantity data in the slave BOM tables, the product quantity is determined without checking the matching results.
[0062] In one implementation, the result is used without checking the matching results. Based on the material quantity data in the BOM sub-table, the product quantity data in the BOM master table, and the material quantity data in the BOM sub-table, the quantity of products to be produced is calculated. Depending on the actual situation, the quantity of a specific material to be fed is determined, and the product quantity is calculated. Product quantity = Material feeding quantity * Product quantity in the BOM master table / Material quantity in the BOM sub-table.
[0063] S105. If the result is a check and matching result, then loop through the available inventory of each required material in the BOM table to determine the quantity of the target product.
[0064] Specifically, if the result is a check for matching results, the system loops through the sum of the specified inventory quantities corresponding to each material parameter in the BOM sub-table of the BOM table, and determines the required material information, product quantity data in the BOM master table, and material quantity data in the BOM sub-table for multiple loops.
[0065] Furthermore, based on the required material information, the product quantity data in the main BOM table, and the material quantity data in the secondary BOM table, the minimum production quantity for multiple cycles is determined, and the minimum production quantity is set as the product quantity based on the check matching results.
[0066] In one embodiment, if the result is a check match, then all materials under the BOM table are iterated through. Within the loop, the sum of the warehouse available quantities specified in the parameters for each material is retrieved. Based on the sum of the available required material quantities, the quantity of products to be produced in this cycle is calculated. Product quantity = Material input quantity in this cycle * Product quantity in the main BOM table / Material quantity in the sub-BOM table. From all the cycle results, the minimum production quantity is taken as the current product quantity, thus determining the minimum production quantity across multiple cycles. This minimum production quantity is then determined as the product quantity based on the check match result.
[0067] Table 4
[0068]
[0069]
[0070] In one embodiment, Table 4 is the result table for enabling the check. When product A and its corresponding BOM are input, the contents of Table 4 will be output. Depending on the parameter settings, it can be divided into enabling the check (checking the usage result) and disabling the check (not checking the usage result). When the check is disabled, the reference warehouse is used directly to output the product quantity forming the production order. When the check is enabled, the specified warehouse (i.e., specified inventory) is used to loop through the sum of the specified inventory quantities corresponding to each material parameter in the BOM sub-table of the BOM table, and the required material information, product quantity data in the BOM master table, and material quantity data in the BOM sub-table are determined in multiple loops, finally outputting the product quantity.
[0071] S106. Generate material feeding and production order information based on product quantity and BOM.
[0072] Specifically, based on the product quantity and the BOM (Bill of Materials), it is also necessary to query and process the relevant auxiliary attribute items of the auxiliary materials for the target production product to obtain auxiliary product information.
[0073] Furthermore, based on the product quantity, auxiliary product information, and BOM (Bill of Materials), the material input production order information is determined.
[0074] In addition, this application embodiment also provides a dynamic material feeding back calculation processing device based on an ERP system, such as... Figure 2 As shown, the dynamic material feeding back-calculation processing equipment based on the ERP system specifically includes:
[0075] At least one processor 201. And a memory 202 communicatively connected to the at least one processor 201. The memory 202 stores instructions executable by the at least one processor 201, enabling the at least one processor 201 to execute:
[0076] Construct a Bill of Materials (BOM) based on available inventory data from the production business system;
[0077] Based on the target products to be produced, the BOM table is matched and queried to obtain the required material information;
[0078] Based on the inventory results of the required material information, the available inventory of the maximum production available inventory is used to determine the usage result; the usage result includes: checking the usage result and not checking the usage result;
[0079] If the result is "no matching check", then determine the quantity of the target product to be produced based on the required material information.
[0080] If the result is a check for matching results, then loop through the available inventory of each required material in the BOM table to determine the quantity of the target product to be produced.
[0081] Based on the product quantity and BOM (Bill of Materials), generate material feeding and production order information.
[0082] This application's embodiments reduce the need for manual product structure identification and material retrieval by directly obtaining required material information, thus improving work efficiency. It avoids errors or omissions that may occur during manual product structure identification. It ensures timely supply of required materials, reducing inventory risk. It optimizes material usage strategies in the production process, improving material utilization and production efficiency. It provides a clear understanding of the available inventory and matching status of each required material, offering strong support for production decisions. It also reduces the possibility of human intervention and errors, further ensuring smooth production and reducing production costs. Simultaneously, it improves the flexibility and accuracy of inventory management. By utilizing automatic matching and available inventory judgment, it reduces the tedious process of manual operation, improving work efficiency and accuracy. It also provides a more intuitive understanding of the inventory status and matching status of required materials, offering strong support for procurement decisions and helping enterprises ensure timely supply of required materials.
[0083] The various embodiments in this application are described in a progressive manner. Similar or identical parts between embodiments can be referred to mutually. Each embodiment focuses on describing the differences from other embodiments. In particular, the device and medium embodiments are basically similar to the method embodiments, so the description is relatively simple; relevant parts can be referred to the description of the method embodiments.
[0084] The devices and media provided in this application are one-to-one with the methods. Therefore, the devices and media also have similar beneficial technical effects as their corresponding methods. Since the beneficial technical effects of the methods have been described in detail above, the beneficial technical effects of the devices and media will not be repeated here.
[0085] Those skilled in the art will understand that embodiments of this application can be provided as methods, systems, or computer program products. Therefore, this application can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, this application can take the form of a computer program product embodied on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.
[0086] This application is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of this application. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart... Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.
[0087] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.
[0088] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.
[0089] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.
[0090] Memory may include non-persistent storage in computer-readable media, such as random access memory (RAM) and / or non-volatile memory, such as read-only memory (ROM) or flash RAM. Memory is an example of computer-readable media.
[0091] Computer-readable media includes both permanent and non-permanent, removable and non-removable media that can store information using any method or technology. Information can be computer-readable instructions, data structures, modules of programs, or other data. Examples of computer storage media include, but are not limited to, phase-change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technologies, CD-ROM, digital versatile optical disc (DVD) or other optical storage, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other non-transferable medium that can be used to store information accessible by a computing device. As defined herein, computer-readable media does not include transient computer-readable media, such as modulated data signals and carrier waves.
[0092] It should also be noted that the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes said element.
[0093] The above description is merely an embodiment of this application and is not intended to limit the scope of this application. Various modifications and variations can be made to this application by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of this application should be included within the scope of the claims of this application.
Claims
1. A dynamic material input back-calculation processing method based on an ERP system, characterized in that, The method includes: Based on the available inventory data in the production business system, construct a Bill of Materials (BOM) table, specifically including: Based on the preset production data types, the available inventory data is classified to determine product type data and material type data; wherein, the product type data includes: product data and product quantity data; the material type data includes: material data and material quantity data; Based on the unique primary key, the product type data is tabulated using the relevant data structure to obtain the BOM main table. Based on the BOM primary key in the BOM master table, the material type data is subjected to attribute tabulation processing under the relevant data structure to obtain the BOM sub-table. The BOM master table and the BOM slave table are associated with a master-slave relationship to form the BOM table; Based on the target product, the BOM table is matched and queried to obtain the required material information; Based on the inventory results of the required material information, the available inventory of the maximum production available inventory is used to determine the availability of the specified inventory, and the usage result is obtained; wherein, the usage result includes: checking the matching result and not checking the matching result; If the usage result is that no matching result is checked, then the quantity of the target production product is determined based on the required material information, specifically including: If the usage result is that no matching result is checked, then the required material information is obtained, and the BOM main table and BOM sub-table associated with the required material information are extracted; Based on the required material information, the product quantity data in the BOM master table, and the material quantity data in the BOM slave table, determine the product quantity based on the condition of not checking the matching results; If the usage result matches the check result, then loop through the available inventory of each required material in the BOM table to determine the quantity of the target production product, specifically including: If the usage result is the check matching result, then loop through the sum of the specified inventory quantities corresponding to each material parameter in the BOM sub-table of the BOM table, and determine the required material information, product quantity data in the BOM master table, and material quantity data in the BOM sub-table in multiple loops; Based on the required material information, the product quantity data in the main BOM table, and the material quantity data in the secondary BOM table, the minimum production product quantity in multiple cycles is determined, and the minimum production product quantity is determined as the product quantity based on the check matching result. Based on the product quantity and the BOM (Bill of Materials), material feeding and production order information is generated.
2. The dynamic material feeding back calculation method based on an ERP system according to claim 1, characterized in that, Based on the target product, the BOM table is matched and queried to obtain the required material information, specifically including: The target product is split into data attributes to obtain target attribute items; wherein, the target attribute items include at least: alias item, column name item, data type item, and data content item; By querying the main BOM table in the BOM table using the target attribute items, product information can be obtained. Based on the product information, the BOM sub-table in the BOM table is queried to obtain the required material information.
3. The dynamic material feeding back calculation method based on an ERP system according to claim 1, characterized in that, Based on the inventory results of the required material information, the available inventory of the maximum production available inventory is used to determine the usage result, which specifically includes: Based on the storage address of the required material information, several inventories in the production business system are matched accordingly to obtain the specified inventory; The specified inventory is used to determine the available inventory under maximum productivity, and the determination result information is obtained. If the judgment result information is the available inventory with maximum productivity, then the available inventory is checked and used to obtain the usage result.
4. The dynamic material feeding back calculation method based on an ERP system according to claim 1, characterized in that, Based on the product quantity and the BOM (Bill of Materials), a material feeding production order is generated, specifically including: Based on the product quantity and the BOM table, query the relevant auxiliary attribute items of the auxiliary materials of the target production product to obtain auxiliary product information; Based on the product quantity, the auxiliary product information, and the BOM (Bill of Materials), the material feeding production order information is determined.
5. The dynamic material input back-calculation processing method based on an ERP system according to claim 1, characterized in that, The data attributes of the available inventory include at least: material type attribute, warehouse attribute to which the material belongs, available quantity attribute of the material, and specified inventory attribute corresponding to the warehouse.
6. A dynamic material feeding back-calculation processing device based on an ERP system, characterized in that, The device includes: At least one processor; and, A memory communicatively connected to the at least one processor; wherein, The memory stores instructions executable by the at least one processor, enabling the at least one processor to execute a dynamic material feeding back calculation method based on an ERP system according to any one of claims 1-5.
7. A non-volatile computer storage medium, characterized in that, The storage medium is a non-volatile computer-readable storage medium, which stores at least one program. Each program includes instructions, which, when executed by a terminal, cause the terminal to perform a dynamic material feeding back calculation processing method based on an ERP system according to any one of claims 1-5.
Citation Information
Patent Citations
Method for planning enterprise resources
CN101833711A
Server order inspection method and device, electronic equipment and medium
CN114463095A