Design method of production scheduling early warning and alarm mechanism system based on ERP

By designing a multi-system-connected early warning and alarm management platform in the ERP system, the problems of inventory management and delivery delays in the production process are solved, and accurate grasp of production progress and inventory is achieved, delayed delivery situation is reduced, and improved Production scheduling efficiency.

CN114548865BActive Publication Date: 2024-11-22SHANDONG MEILING BODE CHEM MACHINERY CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202210145186.4
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-02-17
Publication Date
2024-11-22
Estimated Expiration
2042-02-17

AI Technical Summary

Technical Problem

In the fierce market competition environment, the company faces problems of suspension of work and delayed delivery, and the existing technology is difficult to optimize the efficiency of production process, resulting in the problem of inventory management and delivery delays not being effectively solved.

Method used

A production scheduling early warning and alarm mechanism system based on ERP was designed. Through the integration of sales, production, procurement and warehouse management units, a multi-system-connected early warning and alarm management platform is formed, and the plan execution results and data dynamic comparison are captured in real time, and the plan execution results and data are automatically triggered. Warning and warning, generate workflow boards and notify designated personnel, so as to achieve accurate grasp of production progress, equipment shipment time and material inventory.

Benefits of technology

It has achieved accurate grasp of production progress, equipment delivery time and material inventory, reduced inventory backlog and delayed delivery, provided strong evidence for management measures, and improved the controllability and efficiency of production scheduling.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114548865B_ABST
    Figure CN114548865B_ABST
Patent Text Reader

Abstract

The present invention relates to a design method of a production scheduling early warning and alarm mechanism system based on ERP, and belongs to the field of ERP management technology. The steps of the present invention are as follows: S1: Retrieve relevant data of the ERP system: The ERP system is divided into a sales management unit, a production management unit, a procurement management unit, and a warehouse management unit; S2: Form an indicator library for early warning and alarm: The indicator library integrates data with the material management unit and the equipment management unit through the ERP system to form an early warning and alarm management platform with multiple systems connected from top to bottom and from left to right; S3: Design an early warning and alarm mechanism system, and perform data comparison and integration processing; S4: Generate an early warning and alarm workflow dashboard. The present invention can accurately grasp the production progress, equipment delivery time, material arrival time, and material inventory, realize controllable scheduling of the overall production situation, provide strong evidence for the implementation of management measures, reduce the generation of inventory, and effectively avoid the situation of delayed delivery of equipment.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The invention relates to a design method for a production scheduling early warning and alarm mechanism system based on ERP, and belongs to the technical field of ERP management. Background Art

[0002] In the fierce market competition environment, customers require shorter and shorter delivery times. Although production technology has made great progress and the degree of production automation has been greatly improved, the problems of downtime and delivery delays that plague the company have not been solved. How to optimize the efficiency of each process link has become a top priority. Summary of the invention

[0003] In view of the above-mentioned defects in the prior art, the present invention proposes a design method for a production scheduling early warning and alarm mechanism system based on ERP.

[0004] The design method of the ERP-based production scheduling early warning and alarm mechanism system of the present invention comprises the following steps:

[0005] S1: Retrieve relevant data from the ERP system: The ERP system is divided into four major units: sales management unit, production management unit, procurement management unit, and warehouse management unit. In terms of ERP system integration, full consideration is given to the functional and data integration requirements of the platform project to achieve smooth interaction and sharing of business data, including:

[0006] Sales management unit: realize the management of sales return orders, inventory checking, sales invoices, sales receipts, accounts receivable details and accounts receivable summary;

[0007] Production management unit: manage product information, production process information and shipment information;

[0008] Procurement management unit: realizes the management of purchase order query, purchase order detail query, purchase order statistics, purchase order summary table, purchase order detail query, purchase quotation query, purchase quotation detail query and procurement statistics;

[0009] Warehouse management unit: realize the management of warehouse entry order, inventory checking, warehouse entry details, inventory counting and in-and-out storage summary;

[0010] S2: Form an indicator library for early warning and alarm: The indicator library integrates data with the material management unit and the equipment management unit through the ERP system to form an early warning and alarm management platform that connects multiple systems vertically and horizontally. It is divided into the following steps:

[0011] S21: The early warning and alarm management platform includes at least the following modules:

[0012] Sales order module: publish new plans and change plans in real time; capture plan execution results in real time to form a plan closed loop and dynamically compare them with defined indicators;

[0013] Purchase order module: Generates a commodity purchase order based on the sales order for inventory management personnel to purchase;

[0014] Procurement plan module: submitted by the procurement department to reflect its procurement needs and implementation requirements;

[0015] Workshop process module: real-time collection of production process plan completion data, material consumption data, real-time acceptance of new plans, change plan information, display of detailed plan execution results, and dynamic comparison with defined indicators;

[0016] Process outsourcing module: used for outsourcing order management, process planning management, workshop material delivery, workshop material receipt, material receipt inspection, outsourcing settlement, and cost accounting;

[0017] Dynamic inventory module: used to dynamically track the entire process of raw materials and finished products, match and verify the physical materials and material information, and determine the best logistics and transportation plan based on logistics information;

[0018] S22: The front end can freely set and adjust the defined parameters, and capture the early warning and alarm management platform in real time;

[0019] S3: Design early warning and alarm mechanism system, data comparison and integration processing, including:

[0020] Sales order early warning-alarm module: automatic early warning of equipment delivery date in advance, automatic warning of overdue delivery;

[0021] Purchase order early warning-alarm module: automatic early warning of purchase order completion date in advance, automatic warning of overdue;

[0022] Procurement plan early warning-alarm module: automatic early warning of the procurement plan completion date in advance, automatic warning of overdue completion;

[0023] Workshop process early warning-alarm module: automatic early warning of workshop process completion date in advance, automatic warning of overdue completion date;

[0024] Outsourcing process early warning and alarm module: automatic early warning of the outsourcing process completion date in advance, automatic warning of overdue completion date;

[0025] Warehouse stagnant material early warning - alarm module: automatic warning for materials that are no longer used after a specified date;

[0026] Warehouse material preparation warning-alarm module: automatic warning if materials are not prepared beyond the specified date;

[0027] S4: Generate early warning and alarm workflow dashboard: The early warning and alarm mechanism system issues a workflow dashboard generation instruction. The workflow dashboard generation instruction generates an early warning-alarm module in the workflow dashboard. The displayed data is associated with the ERP system in real time to be updated in real time according to data changes in the ERP system, and the designated personnel are notified to view the workflow dashboard.

[0028] Preferably, in step S2, the early warning and alarm management platform is a part of the early warning and alarm mechanism system, which together with the ERP system, workflow dashboard, and designated personnel constitute the early warning and alarm mechanism system.

[0029] Preferably, in step S22, the indicator library is based on the early warning and alarm management platform as the data source, and defines an indicator library system. By analyzing the data source itself, an early warning is given for abnormal situations that occur, and a warning is issued for the risks triggered by abnormal processing.

[0030] Preferably, in step S3, the early warning and alarm mechanism system is triggered by at least one of the sales order early warning-alarm module, the purchase order early warning-alarm module, the procurement plan early warning-alarm module, the workshop process early warning-alarm module, the process outsourcing early warning-alarm module, the warehouse stagnant material early warning-alarm module, and the warehouse material preparation early warning-alarm module, or any combination thereof.

[0031] Preferably, in step S3, the early warning and alarm mechanism system includes the following items:

[0032] Warning type, document type, planned completion date, warning days, remaining days, order number, product name, material number, including:

[0033] There are two types of warnings: warning and overdue.

[0034] Preferably, the design method of the ERP-based production scheduling early warning and alarm mechanism system of the present invention further includes the following steps:

[0035] S7: Expand collaborative applications on mobile terminals: Expand APP on mobile terminals to further improve the timeliness of business processing; accurately grasp the production progress, equipment delivery time, material arrival time, and material inventory, realize controllable scheduling of the overall production situation, and provide strong evidence for the implementation of management measures.

[0036] The beneficial effects of the present invention are: production progress, equipment delivery time, material arrival time, and material inventory can all be accurately mastered, achieving controllable scheduling of the overall production situation, providing strong evidence for the implementation of management measures, reducing inventory generation, and effectively avoiding delayed equipment delivery. BRIEF DESCRIPTION OF THE DRAWINGS

[0037] Figure 1 It is the overall process principle block diagram of the present invention.

[0038] Figure 2 It is a structural diagram of the early warning and alarm mechanism system in step S3. DETAILED DESCRIPTION

[0039] The technical solutions in the embodiments of the present invention will be described clearly and completely below in conjunction with the accompanying drawings in the embodiments of the present invention.

[0040] like Figure 1 As shown, the design method of the production scheduling early warning and alarm mechanism system based on ERP of the present invention comprises the following steps:

[0041] S1: Retrieve relevant data from the ERP system: The ERP system is divided into four major units: sales management unit, production management unit, procurement management unit, and warehouse management unit. In terms of ERP system integration, full consideration is given to the functional and data integration requirements of the platform project to achieve smooth interaction and sharing of business data, including:

[0042] Sales management unit: realize the management of sales return orders, inventory checking, sales invoices, sales receipts, accounts receivable details and accounts receivable summary;

[0043] Production management unit: manage product information, production process information and shipment information;

[0044] Procurement management unit: realizes the management of purchase order query, purchase order detail query, purchase order statistics, purchase order summary table, purchase order detail query, purchase quotation query, purchase quotation detail query and procurement statistics;

[0045] Warehouse management unit: realize the management of warehouse entry order, inventory checking, warehouse entry details, inventory counting and in-and-out storage summary;

[0046] S2: Form an indicator library for early warning and alarm: The indicator library integrates data with the material management unit and the equipment management unit through the ERP system to form an early warning and alarm management platform that connects multiple systems vertically and horizontally. It is divided into the following steps:

[0047] S21: The early warning and alarm management platform includes at least the following modules:

[0048] Sales order module: publish new plans and change plans in real time; capture plan execution results in real time to form a plan closed loop and dynamically compare them with defined indicators;

[0049] Purchase order module: Generates a commodity purchase order based on the sales order for inventory management personnel to purchase;

[0050] Procurement plan module: submitted by the procurement department to reflect its procurement needs and implementation requirements;

[0051] Workshop process module: real-time collection of production process plan completion data, material consumption data, real-time acceptance of new plans, change plan information, display of detailed plan execution results, and dynamic comparison with defined indicators;

[0052] Process outsourcing module: used for outsourcing order management, process planning management, workshop material delivery, workshop material receipt, material receipt inspection, outsourcing settlement, and cost accounting;

[0053] Dynamic inventory module: used to dynamically track the entire process of raw materials and finished products, match and verify the physical materials and material information, and determine the best logistics and transportation plan based on logistics information;

[0054] S22: The front end can freely set and adjust the defined parameters, and capture the early warning and alarm management platform in real time;

[0055] S3: Design early warning and alarm mechanism systems, such as Figure 2 As shown, data comparison and integration processing, where:

[0056] Sales order early warning-alarm module: automatic early warning of equipment delivery date in advance, automatic warning of overdue delivery;

[0057] Purchase order early warning-alarm module: automatic early warning of purchase order completion date in advance, automatic warning of overdue;

[0058] Procurement plan early warning-alarm module: automatic early warning of the procurement plan completion date in advance, automatic warning of overdue completion;

[0059] Workshop process early warning-alarm module: automatic early warning of workshop process completion date in advance, automatic warning of overdue completion date;

[0060] Outsourcing process early warning and alarm module: automatic early warning of the outsourcing process completion date in advance, automatic warning of overdue completion date;

[0061] Warehouse stagnant material early warning - alarm module: automatic warning for materials that are no longer used after a specified date;

[0062] Warehouse material preparation warning-alarm module: automatic warning if materials are not prepared beyond the specified date;

[0063] S4: Generate early warning and alarm workflow dashboard: The early warning and alarm mechanism system issues a workflow dashboard generation instruction. The workflow dashboard generation instruction generates an early warning-alarm module in the workflow dashboard. The displayed data is associated with the ERP system in real time to be updated in real time according to data changes in the ERP system, and the designated personnel are notified to view the workflow dashboard.

[0064] Embodiment 1:

[0065] In step S2, the early warning and alarm management platform is a part of the early warning and alarm mechanism system, which together with the ERP system, workflow dashboard, and designated personnel constitute the early warning and alarm mechanism system.

[0066] In step S22, the indicator library is based on the early warning and alarm management platform as the data source, and defines the indicator library system. By analyzing the data source itself, it gives early warnings for abnormal situations and warns of risks caused by abnormal processing.

[0067] In step S3, the early warning and alarm mechanism system is triggered by at least one of the sales order early warning-alarm module, the purchase order early warning-alarm module, the purchase plan early warning-alarm module, the workshop process early warning-alarm module, the process outsourcing early warning-alarm module, the warehouse stagnant material early warning-alarm module, and the warehouse material preparation early warning-alarm module, or any combination thereof.

[0068] In step S3, the early warning and alarm mechanism system includes the following items:

[0069] Warning type, document type, planned completion date, warning days, remaining days, order number, product name, material number, including:

[0070] There are two types of warnings: warning and overdue.

[0071] The design method of the ERP-based production scheduling early warning and alarm mechanism system of the present invention also includes the following steps:

[0072] S7: Expand collaborative applications on mobile terminals: Expand APP on mobile terminals to further improve the timeliness of business processing; accurately grasp the production progress, equipment delivery time, material arrival time, and material inventory, realize controllable scheduling of the overall production situation, and provide strong evidence for the implementation of management measures.

[0073] The process management center of the early warning and alarm system includes the following modules:

[0074] Work that needs to be processed urgently, daily work, daily inquiries, daily reports, work reminders, work inspections, work reports, unfinished work, completed work, processed work, work processed by agents, and work not processed by entrusted agents.

[0075] Embodiment 2:

[0076] According to the sales order early warning-alarm module designed in the present invention, the [boiler feed water preheater vertical pipe component] in the sales order is checked, and it is found that its early warning type is warning and the early warning days are 5 days, which is then fed back to the designated personnel for review.

[0077] Designated personnel further track the purchase order early warning-alarm module to check whether the [nuts] in the purchase order have been purchased. If the early warning type is warning and the early warning days are 5 days, it means that there is a problem with the purchase and further tracking is required.

[0078] Designated personnel will further track the procurement plan early warning-alarm module to check whether the [hot water heater] in the purchase order has been included in the procurement plan. The early warning period is 10 days. If the early warning type is a warning, there is a problem with the procurement and further tracking is required.

[0079] Designated personnel will further track the workshop process early warning-alarm module to check whether the [Tube bundle transferred to workshop]-[Metalworking Group 5-CNC Group 2]-[Tube bundle] in the team plan has been completed. The early warning days are 15 days. If the early warning type is warning, it means that there is a problem with the workshop process and further tracking is required.

[0080] Designated personnel will further track the process outsourcing early warning-alarm module to check whether the [Pipe box sealing]-[Pipe box sealing outsourcing molding] in the process outsourcing has been completed. The early warning days are 5 days. If the early warning type is warning, it means that there is a problem with the process outsourcing and needs to be further tracked.

[0081] Designated personnel will further track the warehouse stagnant material early warning-alarm module to check whether there is any stagnation in the [non-aromatic distillation tower water cooler] of the stagnant material. The early warning period is 90 days. If the early warning type is warning, it means that there is a problem with the stagnant material and further tracking is required.

[0082] Designated personnel will further track the warehouse material preparation early warning-alarm module to check whether there are any omissions in the warehouse material preparation. The early warning period is 5 days. If the early warning type is warning, it means that there is a problem with the warehouse material preparation and further tracking is required.

[0083] The beneficial effects of the present invention are: production progress, equipment delivery time, material arrival time, and material inventory can all be accurately mastered, achieving controllable scheduling of the overall production situation, providing strong evidence for the implementation of management measures, reducing inventory generation, and effectively avoiding delayed equipment delivery.

[0084] The present invention can be widely used in ERP management situations.

Claims

1. A design method for a production scheduling early warning and alarm mechanism system based on ERP, characterized in that: The steps include: S1: Retrieve relevant data from the ERP system: The ERP system is divided into four major units: sales management unit, production management unit, procurement management unit, and warehouse management unit. In terms of ERP system integration, full consideration is given to the functional and data integration requirements of the platform project to achieve smooth interaction and sharing of business data, including: Sales management unit: realize the management of sales return orders, inventory checking, sales invoices, sales receipts, accounts receivable details and accounts receivable summary; Production management unit: manage product information, production process information and shipment information; Procurement management unit: realizes the management of purchase order query, purchase order detail query, purchase order statistics, purchase order summary table, purchase order detail query, purchase quotation query, purchase quotation detail query and procurement statistics; Warehouse management unit: realize the management of warehouse entry order, inventory checking, warehouse entry details, inventory counting and in-and-out storage summary; S2: Form an indicator library for early warning and alarm: The indicator library integrates data with the material management unit and the equipment management unit through the ERP system to form an early warning and alarm management platform that connects multiple systems vertically and horizontally. The specific steps are as follows: S21: The early warning and alarm management platform includes at least the following modules: Sales order module: publish new plans and change plans in real time; capture plan execution results in real time to form a plan closed loop and dynamically compare them with defined indicators; Purchase order module: Generates a commodity purchase order based on the sales order for inventory management personnel to purchase; Procurement plan module: submitted by the procurement department to reflect its procurement needs and implementation requirements; Workshop process module: real-time collection of production process plan completion data, material consumption data, real-time acceptance of new plans, change plan information, display of detailed plan execution results, and dynamic comparison with defined indicators; Process outsourcing module: used for outsourcing order management, process planning management, workshop material delivery, workshop material receipt, material receipt inspection, outsourcing settlement, and cost accounting; Dynamic inventory module: used to dynamically track the entire process of raw materials and finished products, match and verify the physical materials and material information, and determine the best logistics and transportation plan based on logistics information; S22: The front end can freely set and adjust the defined parameters, and capture the early warning and alarm management platform in real time; S3: Design early warning and alarm mechanism system, data comparison and integration processing, including: Sales order early warning-alarm module: automatic early warning of equipment delivery date in advance, automatic warning of overdue delivery; Purchase order early warning-alarm module: automatic early warning of purchase order completion date in advance, automatic warning of overdue; Procurement plan early warning-alarm module: automatic early warning of the procurement plan completion date in advance, automatic warning of overdue completion; Workshop process early warning-alarm module: automatic early warning of workshop process completion date in advance, automatic warning of overdue completion date; Outsourcing process early warning and alarm module: automatic early warning of the outsourcing process completion date in advance, automatic warning of overdue completion; Warehouse stagnant material early warning - alarm module: automatic warning for materials that are no longer used after a specified date; Warehouse material preparation warning-alarm module: automatic warning if materials are not prepared beyond the specified date; S4: Generate early warning and alarm workflow dashboard: The early warning and alarm mechanism system issues a workflow dashboard generation instruction, which generates an early warning-alarm module in the workflow dashboard. The displayed data is associated with the ERP system in real time to be updated in real time according to the data changes in the ERP system, and the designated personnel are notified to view the workflow dashboard; In step S2, the early warning and alarm management platform is a part of the early warning and alarm mechanism system, which together with the ERP system, workflow dashboard, and designated personnel constitute the early warning and alarm mechanism system; In step S22, the indicator library is based on the early warning and alarm management platform as the data source, and defines the indicator library system. By analyzing the data source itself, an early warning is given for abnormal situations that occur, and a warning is issued for the risks triggered by abnormal processing; In step S3, the early warning and alarm mechanism system is triggered by at least one of the sales order early warning-alarm module, the purchase order early warning-alarm module, the purchase plan early warning-alarm module, the workshop process early warning-alarm module, the process outsourcing early warning-alarm module, the warehouse stagnant material early warning-alarm module, and the warehouse material preparation early warning-alarm module, or any combination thereof; In step S3, the early warning and alarm mechanism system includes the following items: Warning type, document type, planned completion date, warning days, remaining days, order number, product name, material number, including: There are two types of warnings: warning and overdue. The design method further comprises the following steps: S7: Expand collaborative applications on mobile terminals: Expand APP on mobile terminals; master production progress, equipment delivery time, material arrival time, and material inventory to achieve controllable scheduling of the overall production situation.