Task allocation method and system based on ERP (Enterprise Resource Planning) system
By obtaining business user demand targets in the ERP system, setting comprehensive weights, and dynamically adjusting task sorting based on task urgency and department work progress, the problem of insufficient accuracy and flexibility in task allocation in the traditional ERP system is solved, and efficient and reasonable tasks are achieved. Task allocation.
Patent Information
- Application Number
- CN202411388627.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-08
- Publication Date
- 2025-01-21
- Estimated Expiration
- Not applicable · inactive patent
AI Technical Summary
Traditional ERP systems lack accuracy and flexibility in task allocation, resulting in unreasonable task allocation and waste of resources.
By obtaining the business demand goals of business users, setting comprehensive weights, and combining the urgency of tasks and department work progress, dynamically adjust task sorting to achieve accurate and flexible assignment of tasks.
It improves the accuracy and rationality of task allocation, improves resource utilization and work efficiency, provides strong support for corporate decision-making, and promotes intelligent and efficient corporate operations.
Smart Images

Figure CN119338174A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of enterprise management, and in particular to a task allocation method and system based on an ERP system. Background Art
[0002] In modern enterprise management, the enterprise resource planning (ERP) system plays a vital role as the core of the integrated management information system. It helps enterprises realize the automation, standardization and intelligence of business processes by effectively integrating and optimizing the allocation of various resources of the enterprise. However, although the ERP system plays an important role in enterprise management, the traditional method still faces a series of challenges and shortcomings in task allocation.
[0003] First, traditional ERP systems often lack precision in task allocation. Due to the lack of in-depth understanding and personalized analysis of business user needs, task allocation is often based on fixed rules or templates, which makes it difficult to accurately match the actual needs of each business user. This leads to unreasonable task allocation. Second, traditional ERP systems lack flexibility in task allocation. Faced with rapidly changing market environments and customer needs, companies need to adjust production plans, resource allocation and other task allocation strategies in a timely manner. However, traditional ERP systems often lack dynamic adjustment mechanisms, making it difficult to make timely and accurate adjustments to task allocation based on real-time data and information. This limits the company's response speed and flexibility.
[0004] Therefore, it is necessary to provide a task allocation method and system based on an ERP system to solve the above technical problems. Summary of the invention
[0005] In order to solve the above technical problems, the present invention provides a task allocation method and system based on an ERP system for solving the problem that task allocation in the ERP system is not accurate, reasonable and flexible enough, resulting in waste of resources.
[0006] The present invention provides a task allocation method based on an ERP system, comprising the following steps:
[0007] Based on the business user information in the ERP system, obtain the business demand objectives of each business user;
[0008] Use SQL statements to mark the corresponding primary key field for each business user's business requirement target, and select each business user's ID as a foreign key field to associate with the primary key field;
[0009] Set a comprehensive weight for each primary key field based on the priority of the business user corresponding to the primary key field, the type of the primary key field, and the associated time period of the primary key field;
[0010] Obtain current task information from the ERP system according to the set collection time period, and identify and verify whether each task in the current task information corresponds correctly to the business user through the primary key field and foreign key field;
[0011] After verifying that each task in the current task information corresponds correctly to the business user, the tasks in the current task information are sorted by priority according to the comprehensive weight set for each primary key field;
[0012] The current task information within the set collection time period is statistically analyzed by data analysis methods to obtain the urgency of each task;
[0013] Based on the urgency of each task and the pre-acquired work progress information of each department, each task in the current task information is dynamically sorted and adjusted according to the preset priority top threshold segment, and each task is assigned to each department according to the sorting result.
[0014] Preferably, the process of marking the corresponding primary key field for each business user's business requirement target through an SQL statement, and selecting the ID of each business user as a foreign key field to associate with the primary key field, specifically includes the following steps:
[0015] In the database of the ERP system, obtain the data storing the business demand objectives and mark a unique primary key field for each business demand objective record;
[0016] Select the business user's ID as the foreign key field, and use SQL statements to establish an association constraint between the primary key field and the foreign key field.
[0017] Preferably, the step of setting a comprehensive weight for each primary key field according to the priority of the business user corresponding to the primary key field, the type of the primary key field, and the associated time period of the primary key field specifically includes the following steps:
[0018] According to the contribution of business users in the enterprise, business users are divided into different priorities, including high priority, medium priority and low priority, and a corresponding weight coefficient is assigned to each priority;
[0019] Based on the importance of different types of business needs in enterprise operations, a weight coefficient corresponding to the importance ratio is assigned to each type;
[0020] According to the degree of correlation between the business demand in the primary key field and the current time, the business demand is divided into three related time periods: urgent, near-term and far-term, and a weight coefficient is assigned to each related time period;
[0021] Based on the weight coefficient of the business user's priority, the weight coefficient of the primary key field type, and the weight coefficient of the associated time period of the primary key field, the comprehensive weight of each primary key field is calculated by multiplication and set.
[0022] Preferably, the process of obtaining the current task information from the ERP system according to the set collection time period, and identifying and verifying whether each task in the current task information corresponds to the business user correctly through the primary key field and the foreign key field, specifically includes the following steps:
[0023] Set a collection time period to extract current task information from the ERP system, including task description, task status, and expected completion time;
[0024] Associate the current task information with the business user through primary key fields and foreign key fields;
[0025] By determining whether the foreign key field in the task information corresponds to the foreign key field in the business requirement target table, the correctness of the association between the current task information and the business user is verified. If it is determined that the foreign key field in the task information corresponds to the foreign key field in the business requirement target table, the verification is correct. If it is determined that the foreign key field in the task information does not correspond to the foreign key field in the business requirement target table, the verification is incorrect, and the verification result is identified and fed back.
[0026] Preferably, after verifying that each task in the current task information corresponds correctly to the business user, each task in the current task information is sorted by priority according to the comprehensive weight set for each primary key field, specifically including the following steps:
[0027] According to the value of the comprehensive weight set for each primary key field, each task in the current task information corresponding to each primary key field is sorted in descending order;
[0028] According to the result of the initial sorting, the sorted current tasks are recorded as a task list and stored.
[0029] Preferably, the method of performing statistical analysis on the current task information within the set collection time period by a data analysis method to obtain the urgency of each task specifically includes the following steps:
[0030] Use time series analysis in data analysis methods to perform statistical analysis on the current task information within the set collection time period to obtain the status changes and progress of all tasks;
[0031] Based on the status changes and progress of all tasks, the urgency of each task is evaluated according to the proportion of each task;
[0032] The results of evaluating the urgency of each task are recorded and associated with the recorded task list.
[0033] Preferably, based on the urgency of each task and the pre-acquired current work progress information of each department, each task in the current task information is dynamically sorted and adjusted according to a preset priority top threshold segment, and each task is allocated to each department according to the sorting result, specifically including the following steps:
[0034] Collect statistics on the processing information of historical tasks to set a priority threshold range;
[0035] Compare the urgency of each task with the priority threshold range, determine the tasks whose urgency exceeds the priority threshold range, prioritize them, and sort out the adjusted task order;
[0036] According to the adjusted task ranking, each task is assigned to each department.
[0037] A task allocation system based on an ERP system, the allocation system comprising:
[0038] The data retrieval module is used to obtain the business demand objectives of each business user based on the business user information in the ERP system;
[0039] The association module is used to mark the corresponding primary key field for each business user's business requirement target through SQL statements, and select each business user's ID as a foreign key field to associate with the primary key field;
[0040] The weight definition module is used to set a comprehensive weight for each primary key field based on the priority of the business user corresponding to the primary key field, the type of the primary key field, and the associated time period of the primary key field;
[0041] The collection and verification module is used to obtain the current task information from the ERP system according to the set collection time period, and identify and verify whether each task in the current task information corresponds to the business user correctly through the primary key field and foreign key field;
[0042] The task sorting module is used to initially sort the tasks in the current task information by their corresponding priorities by setting a comprehensive weight for each primary key field after verifying that each task in the current task information corresponds correctly to the business user;
[0043] The statistical analysis module is used to perform statistical analysis on the current task information within the set collection time period through data analysis methods to obtain the urgency of each task;
[0044] The task allocation module is used to dynamically sort and adjust the tasks in the current task information based on the urgency of each task and the pre-acquired current work progress information of each department according to the preset priority top threshold segment, and allocate each task to each department according to the sorting result.
[0045] Compared with the related art, the task allocation method and system based on the ERP system provided by the present invention has the following beneficial effects:
[0046] The present invention achieves preliminary optimization of task allocation by accurately acquiring and matching business users and task information, combined with personalized comprehensive weight setting. Furthermore, according to the urgency of the task and the work progress of the department, the task sorting is dynamically adjusted to ensure the efficiency and rationality of task allocation. It not only improves resource utilization and work efficiency, but also provides strong support for corporate decision-making. Overall, it effectively promotes the intelligence and efficiency of corporate operations, and significantly improves the competitiveness and response speed of the company. BRIEF DESCRIPTION OF THE DRAWINGS
[0047] Figure 1 A flowchart of a task allocation method based on an ERP system of the present invention;
[0048] Figure 2 is a flow chart of step S300 in an embodiment of the present invention;
[0049] Figure 3 The system block diagram of a task allocation system based on an ERP system of the present invention. DETAILED DESCRIPTION
[0050] The present invention will be further described below in conjunction with the accompanying drawings and implementation modes.
[0051] Embodiment 1
[0052] like Figure 1 As shown, a task allocation method based on an ERP system includes the following steps:
[0053] S100, obtaining the business demand objectives of each business user based on the business user information in the ERP system;
[0054] During the specific implementation process, we first navigate to the existing business user information management information database through the ERP system, screen or query specific business user groups, and record the business demand goals for each screened business user, including but not limited to improving production efficiency, reducing costs, and increasing customer satisfaction.
[0055] S200, using SQL statements to mark the corresponding primary key field for each business user's business requirement target, and selecting each business user's ID as a foreign key field to associate with the primary key field;
[0056] In the specific implementation process, the specific steps of step S200 are:
[0057] S201. In the database of the ERP system, data storing business demand targets is obtained, and a unique primary key field is marked for each business demand target record;
[0058] Specifically, data related to business requirement objectives are retrieved from the database, including but not limited to descriptions of business requirements, priorities, expected completion times, etc. For each retrieved business requirement objective record, a unique primary key field is marked for it. It should be noted that the primary key field is an automatically generated serial number or a unique identifier based on certain characteristics of the business requirement objective. The uniqueness of the primary key field ensures that each business requirement objective can be accurately identified in the system.
[0059] For example, for business requirement goal 1: produce 1,000 products A, the priority is high, and the expected completion time is the end of this month; business requirement goal 2: optimize the production process and improve production efficiency, the priority is medium, and the expected completion time is the beginning of the next quarter, then the primary key fields can be marked for these two business requirement goals respectively, such as "BD001" and "BD002", to ensure their uniqueness in the system.
[0060] S202, select the business user's ID as the foreign key field, and establish an association constraint between the primary key field and the foreign key field through an SQL statement;
[0061] Specifically, in the ERP system, each business user is given a unique ID as the foreign key field, and an association constraint between the primary key field and the foreign key field is established by writing an SQL statement.
[0062] S300, setting a comprehensive weight for each primary key field according to the priority of the business user corresponding to the primary key field, the type of the primary key field, and the associated time period of the primary key field;
[0063] In the specific implementation process, the specific steps of step S300 are:
[0064] S301, classifying business users into different priorities according to their contribution to the enterprise, specifically including high priority, medium priority and low priority, and assigning a corresponding weight coefficient to each priority;
[0065] Specifically, the contribution of business users to the enterprise is evaluated based on their performance, work efficiency, innovation ability, etc. in the past period of time (within one year). Based on the contribution evaluation results, business users are divided into three levels: high priority, medium priority and low priority. A corresponding weight coefficient is assigned to each priority. In this embodiment, high priority users are assigned 1.5, medium priority users are assigned 1.0, and low priority users are assigned 0.5, to reflect the different importance of users of different priorities in task allocation.
[0066] S302. Based on the importance of different types of business needs in enterprise operations, a weight coefficient corresponding to the importance ratio is assigned to each type;
[0067] Specifically, by collecting statistics on market demand and customer feedback data, we calculate the importance of different types of business needs in corporate operations, and assign a weight coefficient corresponding to the importance ratio to each type of business need.
[0068] For example, assume that an enterprise has two types of business needs: one is the business need for direct sales of products (Type 1), and the other is the business need for optimizing production processes (Type 2). According to analysis, the importance of Type 1 is higher than that of Type 2, and therefore is assigned weight coefficients of 2.0 and 1.0.
[0069] S303, according to the correlation degree between the business demand in the primary key field and the current time, the business demand is divided into three correlation time periods: urgent, near-term and far-term, and a weight coefficient is assigned to each correlation time period;
[0070] Specifically, analyze the degree of correlation between business needs and the current time, that is, whether the business needs are urgent, whether they need to be completed in the near future, or whether they can be carried out in the long-term plan. Based on the correlation degree analysis, divide the business needs into three related time periods: urgent, near-term and long-term. Assign a weight coefficient to each related time period. For example, suppose the enterprise has three business needs D, E, and F, which belong to the urgent, near-term and long-term related time periods respectively. Then, they are assigned weight coefficients of 3.0, 2.0, and 1.0 respectively.
[0071] S304: Based on the weight coefficient of the priority of the business user, the weight coefficient of the type of the primary key field, and the weight coefficient of the associated time period of the primary key field, the comprehensive weight of each primary key field is calculated by multiplication and set;
[0072] Specifically, the comprehensive weight of each primary key field is calculated by multiplication and set. The specific calculation method is: comprehensive weight of primary key field = weight coefficient of business user priority × weight coefficient of primary key field type × weight coefficient of associated time period of primary key field. According to the calculated comprehensive weight, the business needs are sorted and the corresponding priority is set.
[0073] For example, suppose there is a business demand G, proposed by a high-priority user A, which belongs to the business demand type of direct sales of products (type 1) and belongs to the emergency-related time period. Its comprehensive weight may be calculated as: 1.5 (user A weight coefficient) × 2.0 (type 1 weight coefficient) × 3.0 (emergency-related time period weight coefficient) = 9.0.
[0074] S400, obtaining current task information from the ERP system according to the set collection time period, and identifying and verifying whether each task in the current task information corresponds to the business user correctly through the primary key field and the foreign key field;
[0075] In the specific implementation process, the specific steps of step S400 are:
[0076] S401, setting a collection time period to extract current task information from the ERP system, including task description, task status, and expected completion time;
[0077] Specifically, a reasonable collection time period is set according to the enterprise's operational needs and task allocation cycle. In this embodiment, a collection time period is set from the 1st to the 10th of each month. During the set collection time period, the current task information is extracted from the ERP system, including the task description (i.e., the specific content or goal of the task), task status (such as to be assigned, in progress, completed, etc.) and expected completion time (i.e., the time point or time period when the task should be completed).
[0078] S402, associating the current task information with the business user through the primary key field and the foreign key field;
[0079] Specifically, in the extracted task information, the primary key field and foreign key field of each task are identified, and the task information is associated with the business user using the primary key field and the foreign key field. Specifically, the business user record corresponding to the foreign key field in the task information is searched in the ERP system, and the two are connected.
[0080] S403. Verify the correctness of the association between the current task information and the business user by determining whether the foreign key field in the task information corresponds to the foreign key field in the business requirement target table. If it is determined that the foreign key field in the task information corresponds to the foreign key field in the business requirement target table, the verification is correct. If it is determined that the foreign key field in the task information does not correspond to the foreign key field in the business requirement target table, the verification is incorrect, and the verification result identification is fed back.
[0081] S500: After verifying that each task in the current task information corresponds correctly to the business user, initially sort the tasks in the current task information by their corresponding priorities according to the comprehensive weight set for each primary key field;
[0082] In the specific implementation process, the specific steps of step S500 are:
[0083] S501, performing a preliminary sorting of tasks in the current task information corresponding to each primary key field in descending order according to the value of the comprehensive weight set for each primary key field;
[0084] S502: According to the result of the initial sorting, the sorted current tasks are recorded as a task list and stored.
[0085] S600, performing statistical analysis on current task information within a set collection time period by a data analysis method to obtain the urgency of each task;
[0086] In the specific implementation process, the specific steps of step S600 are:
[0087] S601, using time series analysis in the data analysis method to perform statistical analysis on the current task information within the set collection time period to obtain the status changes and progress of all tasks;
[0088] Specifically, time series analysis is used to associate the status and progress data of tasks with timestamps so that changes in tasks over time can be tracked, and statistical analysis of the status changes and progress of tasks can be performed through periodic analysis.
[0089] For example, if information on 100 tasks is collected, through time series analysis it is found that the status of 30 tasks has changed from "to be assigned" to "in progress" in the past week, and the progress data also shows that these tasks are progressing steadily.
[0090] S602, based on the status changes and progress of all tasks, evaluate the urgency of each task according to the proportion of each task;
[0091] Specifically, based on the status changes and progress of the tasks, a set of urgency assessment indicators are defined, including the remaining completion time of the task, the percentage of completion, the task type (such as urgent tasks, regular tasks, etc.), etc. Then, the defined urgency indicators are used to calculate an urgency score for each task. At the same time, based on the urgency score of each task, their proportion in all tasks is calculated.
[0092] S603: Record the result of evaluating the urgency of each task and associate it with the recorded task list.
[0093] S700, based on the urgency of each task and the pre-acquired current work progress information of each department, dynamically sort and adjust each task in the current task information according to the preset priority top threshold segment, and assign each task to each department according to the sorting result;
[0094] In the specific implementation process, the specific steps of step S700 are:
[0095] S701, collecting statistics on the processing information of historical tasks, and setting a priority threshold range;
[0096] Specifically, collect historical task processing information from the ERP system or other task management systems, including task description, type, urgency, processing time, and completion status, and identify which urgent tasks can usually be completed in a shorter time and which urgent tasks may cause delays or require additional resources, so as to set a priority threshold range.
[0097] In this embodiment, the task data of the enterprise in the past year is analyzed, and it is found that tasks with an urgency of more than 80 points can usually be processed and completed within 24 hours. Therefore, a priority threshold range is set to regard tasks with an urgency of more than 80 points as high priority tasks.
[0098] S702, comparing the urgency of each task with the priority threshold range, determining the tasks whose urgency exceeds the priority threshold range, placing them at the top of the priority list, and sorting out the adjusted task ranking;
[0099] Specifically, the urgency of each task is compared with the set priority threshold range. For tasks whose urgency exceeds the priority threshold range, they are placed at the top of the task list. According to the comparison result, an adjusted task ranking list is obtained.
[0100] For example, there are 10 tasks that need to be assigned currently, of which 3 tasks have an urgency of more than 80 points. In the adjusted task sorting list, these 3 tasks will be placed at the top, and the remaining 7 tasks will be sorted according to other criteria (such as expected completion time, task type, etc.).
[0101] S703. Allocate each task to each department according to the adjusted task ranking;
[0102] Specifically, according to the adjusted task ranking list and the actual situation of each department, the task will be assigned to the most appropriate department. It should be noted that communication is needed with the department heads to ensure that they understand the urgency and importance of the task and agree to accept the assignment.
[0103] Embodiment 2
[0104] like Figure 3 As shown, a task allocation system based on an ERP system applied to a task allocation method based on an ERP system specifically includes:
[0105] The data retrieval module is used to obtain the business demand objectives of each business user based on the business user information in the ERP system;
[0106] The association module is used to mark the corresponding primary key field for each business user's business requirement target through SQL statements, and select each business user's ID as a foreign key field to associate with the primary key field;
[0107] The weight definition module is used to set a comprehensive weight for each primary key field based on the priority of the business user corresponding to the primary key field, the type of the primary key field, and the associated time period of the primary key field;
[0108] The collection and verification module is used to obtain the current task information from the ERP system according to the set collection time period, and identify and verify whether each task in the current task information corresponds to the business user correctly through the primary key field and foreign key field;
[0109] The task sorting module is used to initially sort the tasks in the current task information by their corresponding priorities by setting a comprehensive weight for each primary key field after verifying that each task in the current task information corresponds correctly to the business user;
[0110] The statistical analysis module is used to perform statistical analysis on the current task information within the set collection time period through data analysis methods to obtain the urgency of each task;
[0111] The task allocation module is used to dynamically sort and adjust the tasks in the current task information based on the urgency of each task and the pre-acquired current work progress information of each department according to the preset priority top threshold segment, and allocate each task to each department according to the sorting result.
[0112] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.
[0113] Those skilled in the art can understand that all or part of the steps in the various methods of the above embodiments can be completed by instructing related hardware through a program, and the program can be stored in a computer-readable storage medium, and the storage medium includes a read-only memory (ROM), a random access memory (RAM), a programmable read-only memory (PROM), an erasable programmable read-only memory (EPROM), a one-time programmable read-only memory (OTPROM), an electronically erasable rewritable read-only memory (EEPROM), a compact disc (CD-ROM) or other optical disc storage, magnetic disk storage, magnetic tape storage, or any other computer-readable medium that can be used to carry or store data.
[0114] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity 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, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.
Claims
1. A task allocation method based on ERP system, characterized in that: The allocation comprises the following steps: Based on the business user information in the ERP system, obtain the business demand objectives of each business user; Use SQL statements to mark the corresponding primary key field for each business user's business requirement target, and select each business user's ID as a foreign key field to associate with the primary key field; Set a comprehensive weight for each primary key field based on the priority of the business user corresponding to the primary key field, the type of the primary key field, and the associated time period of the primary key field; Obtain current task information from the ERP system according to the set collection time period, and identify and verify whether each task in the current task information corresponds correctly to the business user through the primary key field and foreign key field; After verifying that each task in the current task information corresponds correctly to the business user, the tasks in the current task information are sorted by priority according to the comprehensive weight set for each primary key field; The current task information within the set collection time period is statistically analyzed by data analysis methods to obtain the urgency of each task; Based on the urgency of each task and the pre-acquired work progress information of each department, each task in the current task information is dynamically sorted and adjusted according to the preset priority top threshold segment, and each task is assigned to each department according to the sorting result.
2. The task allocation method based on the ERP system according to claim 1 is characterized in that: The method of marking the corresponding primary key field for each business user's business requirement target by using an SQL statement, and selecting the ID of each business user as a foreign key field to associate with the primary key field, specifically includes the following steps: In the database of the ERP system, obtain the data storing the business demand objectives and mark a unique primary key field for each business demand objective record; Select the business user's ID as the foreign key field, and use SQL statements to establish an association constraint between the primary key field and the foreign key field.
3. The task allocation method based on the ERP system according to claim 1 is characterized in that: The step of setting a comprehensive weight for each primary key field according to the priority of the business user corresponding to the primary key field, the type of the primary key field, and the associated time period of the primary key field specifically includes the following steps: According to the contribution of business users in the enterprise, business users are divided into different priorities, including high priority, medium priority and low priority, and a corresponding weight coefficient is assigned to each priority; Based on the importance of different types of business needs in enterprise operations, a weight coefficient corresponding to the importance ratio is assigned to each type; According to the degree of correlation between the business demand in the primary key field and the current time, the business demand is divided into three related time periods: urgent, near-term and long-term, and a weight coefficient is assigned to each related time period; Based on the weight coefficient of the business user's priority, the weight coefficient of the primary key field type, and the weight coefficient of the associated time period of the primary key field, the comprehensive weight of each primary key field is calculated by multiplication and set.
4. The task allocation method based on the ERP system according to claim 1 is characterized in that: The method of obtaining the current task information from the ERP system according to the set collection time period, and identifying and verifying whether each task in the current task information corresponds correctly to the business user through the primary key field and the foreign key field, specifically includes the following steps: Set a collection time period to extract current task information from the ERP system, including task description, task status, and expected completion time; Associate the current task information with the business user through primary key fields and foreign key fields; By determining whether the foreign key field in the task information corresponds to the foreign key field in the business requirement target table, the correctness of the association between the current task information and the business user is verified. If it is determined that the foreign key field in the task information corresponds to the foreign key field in the business requirement target table, the verification is correct. If it is determined that the foreign key field in the task information does not correspond to the foreign key field in the business requirement target table, the verification is incorrect, and the verification result is identified and fed back.
5. The task allocation method based on ERP system according to claim 1 is characterized in that: After verifying that each task in the current task information corresponds correctly to the business user, the tasks in the current task information are sorted by priority according to the comprehensive weight set for each primary key field, specifically including the following steps: According to the value of the comprehensive weight set for each primary key field, each task in the current task information corresponding to each primary key field is sorted in descending order; According to the result of the initial sorting, the sorted current tasks are recorded as a task list and stored.
6. The task allocation method based on ERP system according to claim 1 is characterized in that: The data analysis method is used to statistically analyze the current task information within the set collection time period to obtain the urgency of each task, which specifically includes the following steps: Use time series analysis in data analysis methods to perform statistical analysis on the current task information within the set collection time period to obtain the status changes and progress of all tasks; Based on the status changes and progress of all tasks, the urgency of each task is evaluated according to the proportion of each task; The results of evaluating the urgency of each task are recorded and associated with the recorded task list.
7. The task allocation method based on ERP system according to claim 1 is characterized in that: Based on the urgency of each task and the pre-acquired current work progress information of each department, each task in the current task information is dynamically sorted and adjusted according to the preset priority top threshold segment, and each task is allocated to each department according to the sorting result, which specifically includes the following steps: Collect statistics on the processing information of historical tasks to set a priority threshold range; Compare the urgency of each task with the priority threshold range, determine the tasks whose urgency exceeds the priority threshold range, prioritize them, and sort out the adjusted task order; According to the adjusted task ranking, each task is assigned to each department.
8. A task allocation system based on an ERP system, applied to a task allocation method based on an ERP system as claimed in any one of claims 1 to 7, characterized in that: The dispensing system comprises: The data retrieval module is used to obtain the business demand objectives of each business user based on the business user information in the ERP system; The association module is used to mark the corresponding primary key field for each business user's business requirement target through SQL statements, and select each business user's ID as a foreign key field to associate with the primary key field; The weight definition module is used to set a comprehensive weight for each primary key field based on the priority of the business user corresponding to the primary key field, the type of the primary key field, and the associated time period of the primary key field; The collection and verification module is used to obtain the current task information from the ERP system according to the set collection time period, and identify and verify whether each task in the current task information corresponds to the business user correctly through the primary key field and foreign key field; The task sorting module is used to initially sort the tasks in the current task information by their corresponding priorities by setting a comprehensive weight for each primary key field after verifying that each task in the current task information corresponds correctly to the business user; The statistical analysis module is used to perform statistical analysis on the current task information within the set collection time period through data analysis methods to obtain the urgency of each task; The task allocation module is used to dynamically sort and adjust the tasks in the current task information based on the urgency of each task and the pre-acquired current work progress information of each department according to the preset priority top threshold segment, and allocate each task to each department according to the sorting result.
Citation Information
Cited By
Service data issuing control method and system of data center
CN120547241A