Automatic work order data scheduling method based on ERP (Enterprise Resource Planning) system

Abstract

The invention discloses an automatic work order data arrangement method based on an ERP system, and the method comprises the steps: maintaining basic data, obtaining a non-finished product work order list, and sorting the to-be-processed work orders of the non-finished product work order list according to a pre-delivery date; calculating available working hours and available productivity according to the maintained basic data, obtaining a material aligning date of a to-be-processed work order according to a material inventory quantity and a predicted balance, determining an online date through the material aligning date, judging whether the available working hours of the online date meet a preset working hour requirement or not, and if the to-be-processed work order needs to use equipment, determining that the to-be-processed work order needs to use equipment; if yes, whether the available capacity meets the preset capacity requirement or not is judged, and if yes, the work order to be processed is ranked, and ranked information is obtained. According to the method, the more accurate scheduling plan is obtained by splitting the business into the finest granularity, the scheduling efficiency and accuracy are improved, the scheduling plan is closer to the actual situation of a workshop production line, and the problem of pain points which cannot be met by a traditional scheduling system is solved.

Description

Technical Field

[0001] This application relates to the field of automatic scheduling technology, and in particular to a method for automatic scheduling of work order data based on an ERP system. Background Technology

[0002] ERP (Enterprise Resource Planning) management software is an information system centered on management accounting. It identifies and plans enterprise resources to acquire customer orders, complete processing and delivery, and ultimately receive customer payment. ERP management software integrates all internal enterprise resources, planning procurement, production, cost, inventory, distribution, transportation, finance, and human resources to achieve optimal resource allocation and maximize efficiency. Enterprises face challenges in a rapidly changing market environment, including evolving opportunities, pricing, and service levels. They must continuously change and improve their business models to enhance competitiveness. Simply focusing on internal process improvements, product development, and manufacturing enhancements is no longer sufficient to cope with today's market environment.

[0003] Most traditional ERP systems currently offer integrated automatic scheduling solutions, typically based on the required quantities of materials in the Bill of Materials (BOM) structure corresponding to work orders. However, integrating traditional automatic scheduling functionality often presents the following challenges: 1. High implementation difficulty: Enterprises need a mature data foundation (such as accurate process parameters and real-time data interfaces) and require customized algorithm models, necessitating significant time and resource investment. 2. Dependence on data quality: System effectiveness heavily relies on data integrity and accuracy; data silos or errors can lead to plan failures. 3. Difficulty in implementing in complex scenarios: Small and medium-sized enterprises (SMEs) often face challenges due to large order fluctuations and limited equipment capabilities, making it difficult to adapt to complex algorithms and potentially requiring manual intervention in practice. Summary of the Invention

[0004] The purpose of this application is to provide an automatic work order scheduling method based on ERP system work order data, so as to solve the technical problem that existing automatic scheduling methods are difficult to implement. The various technical effects of the preferred technical solution among the many technical solutions provided in this application are described in detail below.

[0005] To achieve the above objectives, this application provides the following technical solutions:

[0006] This application provides an automatic work order scheduling method based on ERP system data, comprising: maintaining basic data, obtaining a list of unfinished finished work orders, and sorting each pending work order in the unfinished finished work order list according to the expected delivery date, wherein the basic data includes daily attendance man-hour data, factory equipment list, machine capacity and equipment maintenance data, and workshop and process maintenance data; calculating available man-hours and available capacity based on the maintained basic data, obtaining the material availability date of the pending work orders based on material inventory quantity and expected inventory balance, determining the online launch date based on the material availability date, and judging the online launch date. If the available working hours meet the preset working hour requirements, and if the pending work order requires the use of equipment, then it is determined whether the available capacity meets the preset capacity requirements. If both are met, the pending work order is scheduled to obtain scheduling information. The pending work orders include finished product work orders and semi-finished product work orders. Based on the sorting result, the remaining pending work orders are scheduled sequentially according to the scheduling algorithm until all scheduling information of the unfinished finished product work order list is obtained. The scheduling algorithm includes at least resource allocation algorithm, capacity planning algorithm, priority scheduling algorithm, constraint satisfaction algorithm, greedy algorithm, as well as numerical calculation and rounding algorithm.

[0007] In some embodiments, obtaining the material availability date of the pending work order based on the material inventory quantity and expected balance includes: obtaining the material inventory information of each sub-component of the pending work order; if the inventory is sufficient, the material availability date is the current system date; if the material inventory is insufficient, resource allocation is performed in chronological order using a material requirements planning algorithm, and the arrival quantity is accumulated in chronological order using a greedy algorithm to obtain the latest delivery date of the purchase order or subcontracting order, which is used as the material availability date; summarizing the first material availability dates of all sub-components of the pending work order, storing and updating the mapping relationship between the material availability date and the material inventory quantity using a LinkedHashMap structure, and aggregating data using a doubly linked list or register maintained by the LRU algorithm; using a conditional filtering algorithm to filter out unavailable latest delivery dates or material availability dates based on occupancy, and using a sorting algorithm to select the latest material availability date as the material availability date of the pending work order.

[0008] In some embodiments, the automatic scheduling method for work order data based on the ERP system includes: using the compareTo algorithm to compare the demand, inventory, and occupied quantity of materials; if the inventory of materials is insufficient, querying the source information of the materials; if the materials are purchased parts or outsourced production parts, using data cleaning and preprocessing algorithms to perform format verification and classification processing on the delivery date data, determining whether the latest delivery date of the purchased parts or outsourced production parts is a batch delivery; if so, using a string parsing algorithm to parse date strings of different formats; using a date estimation algorithm to estimate subsequent delivery dates based on the start date and the number of days between them; using a cyclic allocation algorithm to cyclically allocate the total quantity to different dates according to rules to obtain the delivery dates and corresponding delivery quantities; using a merge sorting algorithm to merge the delivery dates and quantities of multiple batches and sort them by date; and then parsing the batch delivery dates and delivery quantities according to the batch delivery template, wherein the online date is the day after the material completion date of the work order to be processed.

[0009] In some embodiments, the automatic scheduling method for work order data based on the ERP system includes: if the available working hours do not meet the preset working hour requirement, then determining whether the available working hours are greater than a first preset value; if the available working hours are greater than the first preset value, and the work order to be processed is the semi-finished product work order, then determining whether the available working hours in the workshop are greater than or equal to a second preset value; if the available working hours in the workshop are greater than or equal to the second preset value, then updating the production schedule quantity according to the available working hours; if the available working hours are equal to the first preset value, or the available working hours in the workshop are less than the second preset value, then using a date calculation algorithm to delay the launch date to the next day to obtain a new launch date, and re-determining whether the available working hours on the new launch date meet the preset working hour requirement.

[0010] In some embodiments, the automatic scheduling method based on work order data from an ERP system includes: obtaining the available production capacity; if the available production capacity is greater than 0 and the available working hours calculated based on the available production capacity are greater than the second preset value, then scheduling is performed according to the launch date, and the scheduled quantity is returned; if the available production capacity is equal to 0, then the launch date is delayed to the next day to obtain a new launch date, and the available working hours on the new launch date are re-evaluated to see if they meet the preset working hour requirement, and whether the available production capacity meets the preset production capacity requirement.

[0011] In some embodiments, the automatic scheduling method for work order data based on the ERP system includes: if a jig is required, obtaining the corresponding jig quantity, specifications, standard capacity, and equipment number based on the material number; obtaining the equipment quantity based on the equipment number; then determining whether backward compatibility is required based on the specifications; if so, summing the total capacity of all specifications; otherwise, summing the total capacity of the corresponding specification; and then summing the occupied capacity based on the corresponding specification, wherein the material number is obtained from the basic data; if a jig is not required, obtaining equipment information based on the material number, summing the total equipment capacity, and querying the occupied capacity based on the equipment number; and subtracting the occupied capacity from the total capacity to obtain the initial available capacity.

[0012] In some embodiments, after obtaining the initial available capacity, the automatic scheduling method based on work order data from the ERP system further includes: if the work order to be processed is the finished product work order, then determining whether the initial available capacity is greater than the packing quantity; if the initial available capacity is greater than the packing quantity, then setting the initial available capacity to a multiple of the packing quantity; if the initial available capacity is less than or equal to the packing quantity, then setting the initial available capacity to 0; if the work order to be processed is the semi-finished product work order, then determining whether the working hours corresponding to the initial available capacity are greater than or equal to a third preset value; if the working hours corresponding to the initial available capacity are greater than or equal to the third preset value, then updating the production scheduling quantity according to the initial available capacity; if the working hours corresponding to the initial available capacity are less than the third preset value, then setting the initial available capacity to 0; and returning the initial available capacity as the available capacity.

[0013] In some embodiments, the automatic scheduling method for work order data based on the ERP system includes: if the pending work orders have been scheduled, then determining whether the pending work orders are finished work orders; if the pending work orders are finished work orders, then stopping the scheduling process; if the pending work orders are semi-finished work orders, then obtaining the next pending work order from the work order tree for processing; if the pending work orders have not been scheduled, then delaying the launch date to the next day to obtain a new launch date, and re-determining whether the available working hours on the new launch date meet the preset working hour requirements, and whether the available capacity meets the preset capacity requirements.

[0014] In some embodiments, the automatic scheduling method for work order data based on the ERP system includes: obtaining the work order tree, and performing a layer-by-layer traversal starting from the bottom layer of the work order tree, wherein the work order tree includes the finished product work order, each of the semi-finished product work orders of the finished product work order, and each of the semi-finished product work orders of the semi-finished product work orders.

[0015] In some embodiments, the automatic scheduling method for work order data based on the ERP system includes: determining whether the attendance information for the launch date is found; if not found, delaying the launch date to the next day to obtain a new launch date; repeating this process until the attendance information is found, and determining the date on which the attendance information is found as the launch date.

[0016] Implementing one of the technical solutions described in this application has the following advantages or beneficial effects: In this application, by connecting to the ERP system to obtain relevant order, work order, material inventory information, purchase orders or subcontracting orders, BOM structure, and other data, and combining this with pre-entered basic data, an executable scheduling plan for the workshop production line can be automatically planned based on the work orders in the ERP system. During the scheduling process, the work order data is divided into finished product work orders and semi-finished product work orders. The pre-delivery date of the finished product work orders can be obtained through their link with the orders. The pre-delivery date can be used to analyze the priority of each order, thereby effectively sorting the finished product work orders.

[0017] Because semi-finished products need to be produced before finished products, the production of semi-finished products needs to take into account the inventory and in-transit status of materials. In-transit status is further divided into four scenarios: materials arriving within the factory, materials arriving in batches within the factory, materials arriving outside the factory, and materials arriving in batches outside the factory. The actual manpower and equipment capacity of the workshop also need to be considered. This application obtains a more precise scheduling plan by breaking down the business into the finest granularity, improving scheduling efficiency and accuracy. The scheduling plan is closer to the actual situation of the workshop production line, solving the pain points that traditional scheduling systems cannot address. Attached Figure Description

[0018] To more clearly illustrate the technical solutions of the embodiments of this application, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort. In the drawings:

[0019] Figure 1 This is a flowchart illustrating the automatic scheduling method for work order data based on an ERP system, according to an embodiment of this application. Detailed Implementation

[0020] To make the objectives, technical solutions, and advantages of this application clearer, various exemplary embodiments described below will be referenced to the accompanying drawings, which form part of the exemplary embodiments and depict various exemplary embodiments that may be adopted to implement this application. Unless otherwise indicated, the same numbers in different drawings represent the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with this disclosure. It should be understood that they are merely examples of processes, methods, and apparatuses consistent with some aspects of this application disclosed as detailed in the appended claims, and other embodiments may be used, or structural and functional modifications may be made to the embodiments listed herein without departing from the scope and spirit of this application.

[0021] In the description of this application, it should be understood that the terms "center," "longitudinal," "lateral," etc., indicate the orientation or positional relationship based on the accompanying drawings, and are only for the convenience of describing this application and simplifying the description, and do not indicate or imply that the referred element must have a specific orientation, or be constructed and operated in a specific orientation. The terms "first," "second," etc., are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the number of indicated technical features. The term "multiple" means two or more. The terms "connected" and "linked" should be interpreted broadly, for example, they can be fixed connections, detachable connections, integral connections, mechanical connections, electrical connections, communication connections, direct connections, indirect connections through an intermediate medium, and can be the internal connection of two elements or the interaction relationship between two elements. The term "and / or" includes any and all combinations of one or more of the related listed items. Those skilled in the art can understand the specific meaning of the above terms in this application according to the specific circumstances.

[0022] To illustrate the technical solutions described in this application, specific embodiments are provided below, showing only the parts related to the embodiments of this application.

[0023] like Figure 1 As shown, this application provides a method for automatically scheduling work order data based on an ERP system, including the following steps (steps S1 to S3):

[0024] S1. Maintain the basic data, obtain the list of outstanding finished goods orders, and sort the pending orders in the list according to their expected delivery dates. The basic data includes daily manpower and hour data, a list of in-plant equipment, machine capacity and equipment maintenance data, and workshop and process maintenance data. Specifically, the basic data can be maintained by PMC (Production Material Control) and supports importing from Excel. Further, the list of outstanding finished goods orders and order information can be obtained, and the list of outstanding finished goods orders can be sorted in ascending order according to the expected delivery dates of the orders. The finished goods orders can then be scheduled.

[0025] In some embodiments, the ERP database can be used to query a list of outstanding finished goods work orders, their pre-delivery dates, and estimated completion dates based on orders. Orders can include planned orders and formal orders; formal orders correspond to pre-delivery dates, and planned orders correspond to estimated completion dates. Pre-delivery dates can be filled in by the customer when placing the order. The lists are sorted in ascending order based on pre-delivery dates, so that orders with earlier pre-delivery dates appear at the top of the list. Work orders for purchased parts are not sorted; purchased parts refer to work orders in the process route that include "replace label".

[0026] Daily attendance manpower and working hours data refers to the actual production manpower and working hours configuration information for each workshop. The factory equipment list refers to the capacity data of the machine equipment corresponding to the primary key part number without fixtures; its purpose is to determine whether the part number without fixtures exceeds the maximum capacity of the corresponding equipment. Machine capacity and equipment maintenance data refers to the capacity data of the machine equipment corresponding to the fixture part number; its purpose is to determine whether the part number with fixtures exceeds the maximum capacity of the corresponding fixture. Workshop and process maintenance data refers to the workshop and process information of the work order.

[0027] In some embodiments, the automatic scheduling method for work order data based on the ERP system may include: obtaining a work order tree, and performing a layer-by-layer traversal starting from the bottom level of the work order tree. The work order tree includes finished product work orders, each semi-finished product work order of the finished product work order, and each semi-finished product work order of the semi-finished product work order.

[0028] S2. Calculate available working hours and available capacity based on the maintained basic data. Obtain the material availability date of the pending work orders based on the material inventory quantity and expected balance. Determine the launch date based on the material availability date. Determine whether the available working hours on the launch date meet the preset working hour requirements. If the pending work orders require the use of equipment, determine whether the available capacity meets the preset capacity requirements. If both are met, schedule the pending work orders and obtain scheduling information. The pending work orders can include finished product work orders and semi-finished product work orders.

[0029] Specifically, you can query the list of all sub-component materials on a pending work order based on the work order number, loop through the list of sub-component materials, and query the sub-component material information based on the sub-component item number and the procurement document of the work order.

[0030] In some embodiments, obtaining the material availability date of a pending work order based on the material inventory quantity and expected balance may include: obtaining the material inventory information of each sub-component of the pending work order; if the inventory is sufficient, the material availability date is the current system date; if the material inventory is insufficient, resource allocation is performed in chronological order using a material requirements planning algorithm, and the arrival quantity is accumulated in chronological order using a greedy algorithm to obtain the latest delivery date of the purchase order or subcontracting order, which is used as the material availability date; summarizing the first material availability dates of all sub-components of the pending work order, storing and updating the mapping relationship between the material availability date and the material inventory quantity using a LinkedHashMap structure, and performing data aggregation using a doubly linked list or register maintained by the LRU algorithm; using a conditional filtering algorithm to filter out unavailable latest delivery dates or material availability dates based on occupancy, and using a sorting algorithm to select the latest arrival date as the material availability date of the pending work order.

[0031] Specifically, if the material inventory is sufficient, the material's availability flag can be updated to "available," where the available quantity equals the material requirement. The availability date is recorded as the current system date, and the received quantity equals the material requirement. LinkedHashMap is an important class in the Java Collections Framework. Building upon HashMap, LinkedHashMap maintains a doubly linked list that runs through all entries. This list defines the iteration order, providing a predictable iteration sequence and enabling LRU caching. LRU (Least Recently Used) is a cache eviction policy that prioritizes evicting the least recently accessed data when cache space is insufficient.

[0032] In some embodiments, the automatic scheduling method based on work order data in an ERP system may include: using the compareTo algorithm to compare the demand, inventory, and occupied quantity of materials; if the material inventory is insufficient, querying the material's source information; if the material is a purchased part or a subcontracted production part, using data cleaning and preprocessing algorithms to perform format verification and classification processing on the delivery date data, determining whether the latest delivery date of the purchased part or subcontracted production part is a batch delivery; if so, using a string parsing algorithm to parse date strings of different formats; using a date estimation algorithm to estimate subsequent delivery dates based on the start date and interval days; using a cyclic allocation algorithm to cyclically allocate the total quantity to different dates according to rules, obtaining the delivery dates and corresponding delivery quantities; using a merge sorting algorithm to merge the delivery dates and quantities of multiple batches and sort them by date; and then parsing the batch delivery dates and delivery quantities according to the batch delivery template, where the online date is the day after the material completion date of the work order to be processed. Here, BigDecimal's compareTo algorithm is used to compare the demand, inventory, and occupied quantity of materials to determine the sufficiency of material inventory.

[0033] Specifically, if material inventory is insufficient, the main source and expected inventory of the corresponding product information table for the sub-component number can be queried. Further, if in-plant production inventory is insufficient, the latest date of the next level in the BOM is retrieved; if no next level exists, an error is reported. If purchased inventory is insufficient, the latest delivery date of the corresponding purchase order is queried. If outsourced production inventory is insufficient, the latest delivery date of the corresponding outsourcing order is queried. The system determines whether the latest delivery date of the purchase order or outsourcing order indicates a batch delivery situation, iteratively parsing in-transit documents to determine if the latest delivery date indicates a batch delivery. If so, the daily batch delivery date and quantity are parsed according to the batch delivery template; otherwise, the material's completeness date is recorded as the latest delivery date for the current document, and the delivery quantity is the material requirement. The batch delivery format includes date and quantity information.

[0034] For example, a template with the same daily delivery quantity would be: 20240218-Daily-5000;

[0035] The templates with different daily delivery quantities are: 20240422-10000, 20240423-10000, 20240425-15000;

[0036] The template with different intervals is: 20240422-interval N days-10000, where N represents the number of days to be intermittent.

[0037] The latest delivery date for part numbers with uncertain delivery dates is set to 0101.

[0038] The available quantity equals the inventory minus the occupied quantity plus the quantity in transit.

[0039] The projected inventory for purchase orders is the existing inventory plus the projected purchases minus the projected material requisitions. The projected inventory for outsourced orders is the existing inventory plus the projected production minus the projected material requisitions.

[0040] Specifically, the system can summarize the arrival dates of all sub-components in all pending work orders, iterate through all dates to select the latest arrival date, and define this as the latest arrival date for the pending work order. Then, it returns the material availability date, where the online launch date equals the material availability date plus one. The production schedule quantity corresponds to the quantity on the material availability date. If the date exceeds the latest arrival date of all materials, the production schedule quantity is the same as the unscheduled quantity. The number of work orders that can be scheduled equals the work order demand / the sum of the material demand and the material quantity. The production schedule quantity for the first day needs to include the inventory quantity. The production schedule quantity is the minimum available quantity of each material as of the online launch date, combined with the ratio of materials to finished products. The production schedule quantity is the available material quantity multiplied by the ratio.

[0041] In some embodiments, the automatic scheduling method based on work order data of an ERP system may include: if the available working hours do not meet the preset working hour requirements, then determining whether the available working hours are greater than a first preset value; if the available working hours are greater than the first preset value, and the work order to be processed is a semi-finished product work order, then determining whether the available working hours in the workshop are greater than or equal to a second preset value; if the available working hours in the workshop are greater than or equal to the second preset value, then updating the production schedule quantity according to the available working hours.

[0042] If the available working hours are equal to the first preset value, or the available working hours in the workshop are less than the second preset value, the launch date is delayed to the next day using a date calculation algorithm to obtain a new launch date, and the available working hours on the new launch date are reassessed to see if they meet the preset working hour requirements.

[0043] Specifically, available working hours equal the total working hours of the day minus the working hours already used that day. The total working hours of the day equal the total working hours of the day multiplied by the number of employees present that day. For example, the first preset value can be 0, and the second preset value can be 1 hour, which can be adjusted according to actual production needs.

[0044] In some embodiments, the automatic scheduling method based on work order data of an ERP system may include: obtaining the available capacity quantity; if the available capacity quantity is greater than 0 and the available working hours calculated based on the available capacity quantity are greater than a second preset value, then scheduling is performed according to the launch date and the scheduled quantity is returned; if the available capacity quantity is equal to 0, then the launch date is delayed to the next day to obtain a new launch date, and the available working hours on the new launch date are re-evaluated to see if they meet the preset working hour requirements and whether the available capacity meets the preset capacity requirements.

[0045] In some embodiments, the automatic scheduling method based on work order data of the ERP system may include: if a jig is required, the corresponding jig quantity, specifications, standard capacity and equipment number are obtained according to the material number of the material, the equipment quantity is obtained according to the equipment number, and then it is determined whether upward compatibility is required according to the specifications. If it is required, the total capacity of all specifications is summarized; otherwise, the total capacity of the corresponding specification is summarized. Then, the occupied capacity is summarized according to the corresponding specification, wherein the material number is obtained from the basic data.

[0046] If no fixture is required, obtain the equipment information based on the material number, summarize the total equipment capacity, and query the occupied capacity based on the equipment number.

[0047] The initial available capacity is obtained by subtracting the occupied capacity from the total capacity.

[0048] Specifically, upward compatibility can mean, for example, that a 1-ton machine can be produced using 1-ton, 2-ton, and 3-ton machines; a 2-ton machine can be produced using 2-ton and 3-ton machines; and a 3-ton machine can be produced using a 3-ton machine. If the pending work order involves jigs and equipment, the total daily capacity equals the standard jig capacity * (minimum number of jigs and equipment) * attendance hours; if the pending work order only involves equipment, the total daily capacity equals the standard equipment capacity * number of equipment * attendance hours.

[0049] In some embodiments, after obtaining the initial available capacity, the automatic scheduling method based on work order data from the ERP system may further include:

[0050] If the work order to be processed is a finished product work order, then determine whether the initial available capacity is greater than the packing quantity; if the initial available capacity is greater than the packing quantity, then set the initial available capacity to a multiple of the packing quantity; if the initial available capacity is less than or equal to the packing quantity, then set the initial available capacity to 0.

[0051] If the work order to be processed is a semi-finished product work order, then determine whether the working hours corresponding to the initial available capacity are greater than or equal to the third preset value; if the working hours corresponding to the initial available capacity are greater than or equal to the third preset value, then update the production schedule quantity according to the initial available capacity; if the working hours corresponding to the initial available capacity are less than the third preset value, then set the initial available capacity to 0.

[0052] Return the initial available capacity as the available capacity. The third preset value can be 1 hour, which can be adjusted according to actual production needs.

[0053] In some embodiments, the automatic scheduling method for work order data based on the ERP system may further include: if all work orders to be processed have been scheduled, then determine whether the work order to be processed is a finished work order; if the work order to be processed is a finished work order, then stop the scheduling process; if the work order to be processed is a semi-finished work order, then obtain the next work order to be processed from the work order tree for processing.

[0054] If the pending work orders have not been fully scheduled, the launch date will be postponed to the next day to obtain a new launch date. The available man-hours and available capacity on the new launch date will then be reassessed to see if they meet the preset man-hour requirements and the preset capacity requirements.

[0055] In some embodiments, the automatic scheduling method based on work order data of the ERP system may further include: determining whether the attendance information of the work order for the launch date is found; if not found, delaying the launch date to the next day to obtain a new launch date; repeating until the attendance information of the work order is found, and determining the date on which the attendance information of the work order is found as the launch date.

[0056] S3. Based on the sorting results, the remaining pending work orders are scheduled in sequence until all the scheduling information of the unfinished work orders is obtained. The scheduling algorithm includes at least resource allocation algorithm, capacity planning algorithm, priority scheduling algorithm, constraint satisfaction algorithm, greedy algorithm, as well as numerical calculation and rounding algorithm.

[0057] Specifically, resource allocation algorithms can refer to allocating production tasks based on resource constraints such as equipment capacity and manpower hours; capacity planning algorithms can refer to calculating the available capacity of equipment and manpower, and determining the actual available capacity by considering occupancy; priority scheduling algorithms can refer to using larger-specification equipment when the main equipment is insufficient through an upward compatibility mechanism; constraint satisfaction algorithms can refer to considering multiple constraints such as packing quantity multiples, working time limits, and capacity limits; greedy algorithms can refer to arranging as many production quantities as possible under limited resources; and numerical calculation and rounding algorithms can refer to using BigDecimal for accurate numerical calculation and rounding processing.

[0058] In this application, by integrating with the ERP system to obtain relevant order, work order, material inventory information, purchase orders or subcontracting orders, BOM structure, and other data, and combining this with pre-entered basic data, an executable production line scheduling plan can be automatically planned based on the work orders in the ERP system. During the scheduling process, work order data is divided into finished product work orders and semi-finished product work orders. The pre-delivery date of the finished product work orders can be obtained through their link with the orders. The pre-delivery date can be used to analyze the priority of each order, thereby effectively sorting the finished product work orders.

[0059] Because semi-finished products need to be produced before finished products, the production of semi-finished products needs to take into account the inventory and in-transit status of materials. In-transit status is further divided into four scenarios: materials arriving within the factory, materials arriving in batches within the factory, materials arriving outside the factory, and materials arriving in batches outside the factory. The actual manpower and equipment capacity of the workshop also need to be considered. This application obtains a more precise scheduling plan by breaking down the business into the finest granularity, improving scheduling efficiency and accuracy. The scheduling plan is closer to the actual situation of the workshop production line, solving the pain points that traditional scheduling systems cannot address.

[0060] Those skilled in the art will understand that all or part of the features / steps of the above-described method embodiments can be implemented by methods, data processing systems, or computer programs. These features may be implemented without hardware, entirely in software, or in a combination of hardware and software. The aforementioned computer program may be stored in one or more computer-readable storage media. When the computer program is executed (e.g., by a processor), it performs the steps of the above-described method embodiments for automatic scheduling of work order data based on an ERP system.

[0061] The aforementioned storage media capable of storing program code include: static hard disks, solid-state hard disks, random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), optical storage devices, magnetic storage devices, flash memory, magnetic disks or optical disks and / or combinations thereof, that is, they can be implemented by any type of volatile or non-volatile storage devices or combinations thereof.

[0062] This application also provides a processing device embodiment, including one or more processors and a memory; wherein the memory is used to store one or more computer programs, and the one or more processors are used to execute the one or more computer programs stored in the memory, so that the processors execute the features / steps of the above-described embodiment of the automatic scheduling method for work order data based on an ERP system.

[0063] The above description is merely a preferred embodiment of this application. Those skilled in the art will understand that various changes or equivalent substitutions can be made to these features and embodiments without departing from the spirit and scope of this application. Furthermore, under the teachings of this application, these features and embodiments can be modified to adapt to specific situations and materials without departing from the spirit and scope of this application. Therefore, this application is not limited to the specific embodiments disclosed herein, and all embodiments falling within the scope of the claims of this application are within the protection scope of this application.

Claims

1. An ERP system-based work order data automatic scheduling method, characterized in that, The application relates to a method for scheduling production orders, comprising the following steps: maintaining basic data, obtaining a list of unfinished production orders, and sorting each to-be-processed production order in the list according to a delivery date, wherein the basic data comprises daily attendance man-hour data, a list of in-plant equipment, machine capacity equipment maintenance data and workshop and process maintenance data; calculating available man-hours and available capacity according to the maintained basic data, obtaining a material inventory date of the to-be-processed production order according to material inventory quantity and expected inventory, determining an online date through the material inventory date, judging whether the available man-hours of the online date meet preset man-hour requirements, if the to-be-processed production order needs to use equipment, judging whether the available capacity meets preset capacity requirements, and if both meet the requirements, scheduling the to-be-processed production order to obtain scheduling information, wherein the to-be-processed production order comprises a finished product order and a semi-finished product order; according to a sorting result, sequentially scheduling the remaining to-be-processed production orders based on a scheduling algorithm until all scheduling information of the list of unfinished production orders is obtained, wherein the scheduling algorithm at least comprises a resource allocation algorithm, a capacity planning algorithm, a priority scheduling algorithm, a constraint satisfaction algorithm, a greedy algorithm and a numerical calculation and rounding algorithm.

2. The ERP system based work order data automatic scheduling method according to claim 1, characterized in that, The method for obtaining the material inventory date of the to-be-processed production order according to material inventory quantity and expected inventory comprises the following steps: obtaining material inventory information of each sub-piece of the to-be-processed production order, if the inventory is sufficient, the material inventory date is the current system date, if the inventory of the material is insufficient, a material demand planning algorithm is used to allocate resources in time sequence, a greedy algorithm is used to accumulate the arrival quantity in date sequence to obtain the latest delivery date of a purchase order or outsourcing order as the material inventory date, the first material inventory date of all sub-pieces of the to-be-processed production order is summarized, a LinkedHashMap structure is used to store and update the mapping relationship between the material inventory date and the material inventory quantity, a bidirectional linked list or a register maintained through an LRU algorithm is used for data aggregation, a condition filtering algorithm is used to filter the latest delivery date or the material inventory date which is unavailable according to occupation, and a sorting algorithm is used to select the latest material inventory date as the material inventory date of the to-be-processed production order.

3. The method for automatic work order data scheduling based on ERP system according to claim 1, characterized in that, The ERP system-based work order data automatic scheduling method comprises: comparing the demand quantity, the inventory and the occupied quantity of the material by using a compareTo algorithm; if the inventory of the material is insufficient, querying the source information of the material; if the material is a purchased part or an outsourced production part, verifying and classifying the delivery date by using a data cleaning algorithm and a preprocessing algorithm; determining whether the latest delivery date of the purchased part or the outsourced production part is batched to material; if yes, parsing the date strings of different formats by using a string parsing algorithm; based on the start date and the interval days, calculating the subsequent material arrival dates by using a date calculation algorithm; distributing the total quantity to different dates by using a loop distribution algorithm to obtain the material arrival dates and the corresponding material arrival quantities; merging and sorting the delivery dates and the quantities of multiple batches by using a merging and sorting algorithm; and then parsing the batched material arrival dates and the material arrival quantities according to a batched material arrival template, wherein the online date is the day after the material arrival date of the to-be-processed work order.

4. The ERP system based work order data automatic scheduling method according to claim 3, characterized in that, The ERP system-based work order data automatic scheduling method comprises: If the available working hours do not meet the preset working hour requirement, it is determined whether the available working hours are greater than a first preset value; if the available working hours are greater than the first preset value and the to-be-processed work order is the semi-finished product work order, it is determined whether the working hours available in the workshop are greater than or equal to a second preset value; if the working hours available in the workshop are greater than or equal to the second preset value, the scheduling quantity is updated according to the available working hours; If the available working hours are equal to the first preset value or the working hours available in the workshop are less than the second preset value, the online date is delayed to the next day by using a date calculation algorithm to obtain a new online date, and it is re-determined whether the available working hours of the new online date meet the preset working hour requirement.

5. The ERP system based work order data automatic scheduling method according to claim 4, characterized in that, The ERP system-based work order data automatic scheduling method comprises: obtaining an available capacity quantity; if the available capacity quantity is greater than 0 and the available working hours converted according to the available capacity quantity are greater than the second preset value, scheduling is performed according to the online date, and the scheduled quantity is returned; if the available capacity quantity is equal to 0, the online date is delayed to the next day to obtain a new online date, and it is re-determined whether the available working hours of the new online date meet the preset working hour requirement and whether the available capacity meets the preset capacity requirement.

6. The method for automatic work order data scheduling based on ERP system according to claim 1, characterized in that, If a jig needs to be used, the corresponding jig quantity, specification, standard capacity and equipment number are obtained according to the material number of the material, the equipment quantity is obtained according to the equipment number, it is then determined whether upward compatibility is needed according to the specification, if needed, the total capacity of all specifications is summarized, otherwise, the total capacity of the corresponding specification is summarized, and then the occupied capacity of the corresponding specification is summarized, wherein the material number is obtained from the basic data; If no jig needs to be used, the equipment information is obtained according to the material number of the material, the total equipment capacity is summarized, and the occupied capacity is queried according to the equipment number; The initial available capacity is obtained by subtracting the occupied capacity from the total capacity.

7. The ERP system based work order data automatic scheduling method according to claim 6, characterized in that, After obtaining the initial available capacity, the ERP system-based work order data automatic scheduling method further comprises: If the to-be-processed work order is the finished product work order, it is determined whether the initial available capacity is greater than the boxing quantity; if the initial available capacity is greater than the boxing quantity, the initial available capacity is set as a multiple of the boxing quantity, and if the initial available capacity is less than or equal to the boxing quantity, the initial available capacity is set as 0; If the to-be-processed work order is the semi-finished product work order, it is determined whether the initial available capacity corresponding working hours is greater than or equal to a third preset value; if the initial available capacity corresponding working hours is greater than or equal to the third preset value, the initial available capacity is used to update the production scheduling quantity; if the initial available capacity corresponding working hours is less than the third preset value, the initial available capacity is set as 0; The initial available capacity is returned as the available capacity.

8. The ERP system-based work order data automatic scheduling method according to claim 1, wherein the ERP system-based work order data automatic scheduling method comprises: if the to-be-processed work order has been scheduled, it is determined whether the to-be-processed work order is the finished product work order; if the to-be-processed work order is the finished product work order, the scheduling process is stopped, and if the to-be-processed work order is the semi-finished product work order, the next to-be-processed work order is obtained from the work order tree for processing; If the to-be-processed work order has not been scheduled, the online date is delayed to the next day to obtain a new online date, and it is determined again whether the available working hours of the new online date meet the preset working hour requirement and whether the available capacity meets the preset capacity requirement. The ERP system-based work order data automatic scheduling method comprises: obtaining the work order tree, starting from the lowest layer of the work order tree for layer-by-layer traversal, and the work order tree comprises the finished product work order, each semi-finished product work order of the finished product work order, and semi-finished product work orders of each semi-finished product work order.

9. The ERP system based work order data automatic scheduling method according to claim 8, characterized in that, The ERP system-based work order data automatic scheduling method comprises: determining whether the human attendance information of the online date is queried, delaying the online date to the next day to obtain a new online date if the human attendance information of the online date cannot be queried; and repeating until the human attendance information is queried, and the date when the human attendance information is queried is determined as the online date.

10. The method for automatic work order data scheduling based on ERP system according to claim 1, characterized in that, ​

Images