Customer order processing method and system, electronic equipment and storage medium
By obtaining customer orders and combining supplier feedback, optimizing the order of parts production and delivery time, the problem of long turnover of parts inventory in the commercial vehicle field is solved, and production efficiency and cost-effectiveness are improved.
Patent Information
- Application Number
- CN202411340360.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-09-25
- Publication Date
- 2025-01-07
AI Technical Summary
In the field of commercial vehicles, it is difficult for the existing technology to effectively reduce the turnover time of parts inventory, resulting in production efficiency and cost problems caused by off-peak seasons.
By obtaining customer orders, specifying the expected production schedule date and part production priority according to the supplier's production surplus capacity, combining the model part relationship system and supplier feedback, data cleaning and matching processing are carried out to generate the final production schedule, optimize part delivery and Order matching.
It improves the efficiency of mutual transfer between parts and orders, unifies the concerns of different departments, improves production balance and production scheduling efficiency, and can accurately locate the production scheduling date in the face of resource shortage or special circumstances.
Smart Images
Figure CN119273424A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of commercial vehicle production, and in particular to a customer order processing method, system, electronic equipment and storage medium. Background Art
[0002] In the current domestic commercial vehicle field, there are obvious peak and off-peak seasons. Based on the principle of reducing costs and increasing efficiency, optimization is often carried out in many aspects during the low production period, such as providing parts commonality at the process level, improving the forecast accuracy of future orders at the marketing level, and reducing parts inventory turnover time in production. Summary of the invention
[0003] In view of this, the purpose of the embodiments of the present invention is to provide a technical solution suitable for high-frequency and rapid confirmation of production time at the production level for customer orders, so as to achieve the purpose of reducing the inventory turnover time of parts.
[0004] A first aspect of the present invention provides a method for processing a customer order, the method comprising:
[0005] S1, obtaining a new customer order; the customer order includes goods information;
[0006] S2, specifying the estimated production date of the goods and the production priority of each part according to the remaining production capacity of the supplier corresponding to the goods;
[0007] S3, according to the goods corresponding to the estimated production date, determine the parts list, parts demand date and parts expected arrival date of the goods in the customer order from the vehicle model parts relationship system BOM, and specify the supplier corresponding to the parts according to the procurement ratio;
[0008] S4, the supplier provides parts delivery feedback according to the purchase ratio; the parts delivery feedback includes abnormal parts that cannot be delivered as expected;
[0009] S105, determining the order details to be matched according to the parts delivery feedback, performing order matching processing according to the production scheduling priority, and generating and determining the final production scheduling date.
[0010] Furthermore, the production scheduling priority includes generating a priority by sorting based on the number of balancing times, order submission unit, estimated production scheduling date, order source, order submission time, etc.
[0011] Furthermore, the step S105 includes data cleaning and data matching steps; the data cleaning step includes:
[0012] Generate the schedulable time interval for matching orders;
[0013] Complete the incomplete feedback parts according to the supplier's parts delivery feedback and the full parts delivery list, and generate the daily available quantity of parts;
[0014] According to the factory's production process, the customer order is split into multiple lines according to the process to generate order details to be matched;
[0015] The order parts delivery list is generated based on the vehicle model parts relationship system BOM and the order scheduled date.
[0016] Furthermore, the data matching step includes:
[0017] S301, according to the type of abnormal parts, cyclically access the order details to be matched in the same order sorting manner; the order details to be matched include multiple lines of process order records;
[0018] S302, read a line of process order record and obtain the order scheduled date;
[0019] S303, screening the parts that exist in both the order parts delivery date list and the parts daily available quantity according to the order process;
[0020] S304, performing a matching step according to the types of abnormal parts that have been found and the types of abnormal parts that have been fed back; the matching step includes a step of matching deferred parts, a step of matching suspended parts, and a step of matching undeliverable parts; the types of abnormal parts include deferred, suspended, and undeliverable.
[0021] Further, the step of matching the delayed parts includes:
[0022] If the daily available quantity of parts is less than the scheduled order date and the occupied quantity is less than the planned quantity, a success record is recorded and step S302 is executed;
[0023] If there is data that the occupied quantity in the daily available quantity of parts is less than the planned quantity of parts corresponding to the daily available quantity of parts but not less than the scheduled date of the order, then record the failure history and execute step S302;
[0024] If there is no corresponding part in the daily available quantity of the part whose occupied quantity is less than the planned quantity in the daily available quantity of the part, execute the matching pending parts step;
[0025] Further, the step of matching the delayed parts includes:
[0026] If the occupied quantity of the daily available quantity of parts is less than the planned quantity, a success record is recorded and step S302 is executed;
[0027] If the occupied quantity of the daily available quantity of the non-existent parts is less than the planned quantity, the step of matching the undeliverable parts is executed;
[0028] The matching cannot deliver parts steps include:
[0029] If the occupied quantity of the daily available quantity of parts is less than the planned quantity, a success record is recorded and step S302 is executed;
[0030] If there is no part in the daily available quantity where the occupied quantity is less than the planned quantity, step S302 is executed.
[0031] Furthermore, the S105 further includes:
[0032] If there are no matched pending parts or parts that cannot be delivered, and the deferred parts are not all successful resumes, the order scheduled date is used to take one working day backward in the schedulable time interval to execute step S303;
[0033] After the order cycle is completed, the date of the resume will be moved back within the range of the schedulable time interval according to the production cycle of different processes to determine the final scheduling date;
[0034] All resumes are sorted and summarized to generate a visual response report; the response report includes the final production scheduling date.
[0035] In addition, the second aspect of the present invention provides a customer order processing device, the system includes an acquisition module, a designation module, a first processing module, a feedback module and a second processing module, characterized in that:
[0036] The acquisition module is used to acquire a newly added customer order; the customer order includes goods information;
[0037] The designation module is used to designate the expected production date of the goods and the production priority of each part according to the remaining production capacity of the supplier corresponding to the goods;
[0038] The first processing module is used to determine the parts list, parts demand date and parts expected arrival date of the goods in the customer order from the vehicle model parts relationship system BOM according to the goods corresponding to the expected production scheduling date, and specify the supplier corresponding to the parts according to the procurement ratio;
[0039] The feedback module is used for the supplier to provide parts delivery feedback according to the purchase ratio; the parts delivery feedback includes abnormal parts that cannot be delivered as expected;
[0040] The second processing module is used to determine the order details to be matched according to the parts delivery feedback, perform order matching processing according to the production scheduling priority, and generate and determine the final production scheduling date.
[0041] In addition, the third aspect of the present invention provides an electronic device, comprising: one or more processors, a memory, the memory being used to store one or more computer programs; characterized in that the computer program is configured to be executed by the one or more processors, and the program includes steps for executing the customer order processing method described in the first aspect.
[0042] In addition, the fourth aspect of the present invention provides a storage medium storing a computer program; the program is loaded and executed by a processor to implement the steps of the customer order processing method described in the first aspect.
[0043] In the scheme of the present invention, by acquiring a new customer order; the customer order includes goods information; according to the remaining production capacity of the supplier corresponding to the goods, the expected production date of the goods and the production priority of each part are specified; according to the goods corresponding to the expected production date, the parts list, parts demand date and expected arrival date of the parts in the customer order are determined from the vehicle model parts relationship system BOM, and the supplier corresponding to the parts is specified according to the purchase ratio; the supplier provides part delivery feedback according to the purchase ratio; the part delivery feedback includes abnormal parts that cannot be delivered according to the expected time; according to the part delivery feedback, the details of the order to be matched are determined, and the order matching processing is performed according to the production priority to generate and determine the final production date. The parts delivery list generated by combining the order submitted by the marketing department, the factory capacity, and the order BOM structure is combined with the supplier to calculate the parts and quantities that cannot be achieved according to the delivery time, and the order production date is clarified according to the attributes of the order; the supplier feedback parts are converted into the production time of the order and the resume is summarized to generate a balance report. On the one hand, this allows for efficient conversion of parts and orders, unifying the focus of different departments and improving balance and scheduling efficiency; on the other hand, it allows for the order sequence to be adjusted to accurately locate when parts resources are tight or there are special circumstances, and to give executable scheduling dates. BRIEF DESCRIPTION OF THE DRAWINGS
[0044] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for use in the embodiments are briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present invention and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without creative work.
[0045] Figure 1It is a flow chart of a method for processing customer orders disclosed in an embodiment of the present invention;
[0046] Figure 2 is a flow chart of the data matching steps disclosed in an embodiment of the present invention;
[0047] Figure 3 is a flow chart of the data matching steps disclosed in an embodiment of the present invention;
[0048] Figure 4 This is a schematic diagram of the report display result after the matching of this embodiment disclosed in the embodiment of the present invention is completed;
[0049] Figure 5 is a system architecture diagram disclosed in an embodiment of the present invention;
[0050] Figure 6 It is a schematic diagram of the structure of a customer order processing device disclosed in an embodiment of the present invention. DETAILED DESCRIPTION
[0051] Example embodiments will now be described more fully with reference to the accompanying drawings. However, example embodiments can be implemented in a variety of forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this application will be more comprehensive and complete and fully convey the concept of the example embodiments to those skilled in the art.
[0052] In addition, described feature, structure or characteristic can be combined in one or more embodiments in any suitable manner. In the following description, many specific details are provided to provide a full understanding of the embodiments of the present application. However, those skilled in the art will appreciate that the technical scheme of the present application can be put into practice without one or more of the specific details, or other methods, components, devices, steps, etc. can be adopted. In other cases, known methods, devices, realizations or operations are not shown or described in detail to avoid blurring the various aspects of the application.
[0053] The block diagrams shown in the accompanying drawings are merely functional entities and do not necessarily correspond to physically independent entities. That is, these functional entities may be implemented in software form, or in one or more hardware modules or integrated circuits, or in different networks and / or processor devices and / or microcontroller devices.
[0054] The flowcharts shown in the accompanying drawings are only exemplary and do not necessarily include all the contents and operations / steps, nor must they be executed in the order described. For example, some operations / steps can be decomposed, and some operations / steps can be combined or partially combined, so the actual execution order may change according to actual conditions.
[0055] It should be noted that the “plurality” mentioned in this article refers to two or more.
[0056] The implementation details of the technical solution of the embodiment of the present application are described in detail below:
[0057] In the first aspect, the embodiment of the present invention provides a method for processing customer orders, see Figure 1 , the method comprising:
[0058] S101, obtaining a new customer order; the customer order includes goods information.
[0059] Specifically, in this embodiment, the marketing unit of the order management department obtains the customer's newly added daily orders (hereinafter referred to as customer orders) from the demand reporting department unit, wherein the orders include vehicle / spare parts / overseas distribution orders (including the customer's desired delivery time).
[0060] The system accumulates the above orders based on the transportation days (calculated based on the distance between the order delivery location and the production location combined with the marketing distance days formula) and vehicle attributes (loading method, transportation method, etc.), and then calculates forward based on the marketing calendar and the earliest production date that can be scheduled at the factory to obtain the desired factory scheduling date and sends it to the factory.
[0061] S102, specifying an estimated production date for the goods and a production priority order for each part according to the remaining production capacity of the supplier corresponding to the goods.
[0062] Furthermore, the production scheduling priority includes generating a priority by sorting based on the number of balancing times, order submission unit, estimated production scheduling date, order source, order submission time, etc.
[0063] Specifically, in this embodiment, a daily draft plan is formulated, including specifying the estimated production date of the new orders for the new daily orders in combination with the remaining capacity values of the factory's daily production (historical orders will be occupied), the order production priority (by default, according to the balance number, order submission unit, and pre-schedule Sort by production date, order source, order submission time, etc. to generate priority order) For example, the daily production capacity of the factory for car fenders is 500 pieces, and the currently occupied quantity is 450 pieces, so the remaining capacity value for fenders is 50 pieces.
[0064] Further, regarding the order scheduling priority, this embodiment provides an example as follows. For example:
[0065] 1. On September 20, Marketing Unit A submitted two orders A (delivery date October 7) and B (delivery date October 9) in the morning, and one order C (delivery date October 9) in the afternoon.
[0066] 2. Marketing Unit B submitted an order D in the morning (delivery date is October 8), and an order E in the afternoon (delivery date is October 7).
[0067] 3. Order F (delivery date October 8) from Marketing Unit C was put on hold after being balanced on September 16 and then released to September 20.
[0068] 4. The factory submitted an order G (delivery date is October 7) due to work waste.
[0069] Then, the order scheduling rules of this embodiment are: the more balancing times, the higher the priority; in-plant submissions, the higher the priority; the shorter the delivery period, the higher the priority; marketing B takes priority over marketing A; the earlier the submission time, the higher the priority. According to the above rules, the order priority is F>G>E>A>D>B>C.
[0070] S103, according to the goods corresponding to the estimated production date, determine the parts list, parts demand date and estimated parts arrival date of the goods in the customer order from the vehicle model parts relationship system BOM, and specify the supplier corresponding to the parts according to the procurement ratio.
[0071] Specifically, in this embodiment, according to the day-draft plan (including new orders with expected production scheduling dates) executed in the above step S102, the parts list and parts demand date of the new orders are screened out from the BOM system (vehicle type parts relationship system), and the expected arrival date of the parts is calculated according to the different process production cycles of the orders, and the suppliers of the above parts are designated according to the procurement ratio, that is, the full parts list.
[0072] S104, the supplier provides parts delivery feedback according to the purchase ratio; the parts delivery feedback includes abnormal parts that cannot be delivered as expected.
[0073] Specifically, in this embodiment, the supplier responds to the parts that cannot be delivered as expected in the external window interface. Parts delivery feedback includes abnormal parts that cannot be delivered as expected. And the abnormal parts types are divided into three situations: postponed (need to fill in the delivery date), suspended (cannot reply on the same day, need to delay the reply), and unable to deliver (unable to supply).
[0074] S105, determining the order details to be matched according to the parts delivery feedback, performing order matching processing according to the production scheduling priority, and generating and determining the final production scheduling date.
[0075] Specifically, in this step, data cleaning is first performed on the orders to be matched, and then system matching is performed.
[0076] Furthermore, the step S105 includes data cleaning and data matching steps; the data cleaning step includes:
[0077] Generate the schedulable time interval for matching orders;
[0078] Complete the incomplete feedback parts according to the supplier's parts delivery feedback and the full parts delivery list, and generate the daily available quantity of parts;
[0079] According to the factory's production process, the customer order is split into multiple lines according to the process to generate order details to be matched;
[0080] The order parts delivery list is generated based on the vehicle model parts relationship system BOM and the order scheduled date.
[0081] In this embodiment, the daily available quantity of parts can be expressed as follows. For example, in the full parts delivery list, there are 20 a on September 20 and 10 a on September 22. The supplier feedback shows that 2 a on September 20 will not arrive until September 25, and 10 a on September 22 will also not arrive until September 25. According to the full parts delivery list and the supplier feedback information, it can be determined that 3 rows of records are generated: 1. Required to arrive on September 20, and 18 a actually arrived on September 20. 2. Required to arrive on September 20, and 2 a actually arrived on September 25. 3. Required to arrive on September 22, and 10 a actually arrived on September 25.
[0082] Furthermore, the BOM and order schedule date based on the vehicle model and part relationship system are jointly calculated to generate an order parts delivery list. For example, there is an order X dated September 20th, and the X order is a car model called M. The M model has four parts a, b, c, and d in the BOM (here it is renamed: vehicle model bill of materials). By using the X order to obtain data from the BOM through the model M, it can be obtained that the demand date of a, b, c, and d is September 20th. Then according to the process, for example, part c is used in welding (the process sequence is welding -> painting -> final assembly). The demand date of part c is equal to September 17th according to the process parameters. The data set obtained after converting all orders according to this rule is called the order parts delivery list.
[0083] Furthermore, the step S105 includes data cleaning and data matching steps; the data cleaning step includes:
[0084] Generate the schedulable time interval for matching orders;
[0085] Complete the incomplete feedback parts according to the supplier's parts delivery feedback and the full parts delivery list, and generate the daily available quantity of parts;
[0086] According to the factory's production process, the customer order is split into multiple lines according to the process to generate order details to be matched;
[0087] The order parts delivery list is generated based on the vehicle model parts relationship system BOM and the order scheduled date.
[0088] Further, the data matching step, see Figure 2 The data matching step flow chart of this embodiment includes:
[0089] S301, according to the type of abnormal parts, cyclically access the order details to be matched in the same order sorting manner; the order details to be matched include multiple lines of process order records;
[0090] S302, read a line of process order record and obtain the order scheduled date;
[0091] S303, screening the parts that exist in both the order parts delivery date list and the parts daily available quantity according to the order process;
[0092] S304, performing a matching step according to the types of abnormal parts that have been found and the types of abnormal parts that have been fed back; the matching step includes a step of matching deferred parts, a step of matching suspended parts, and a step of matching undeliverable parts; the types of abnormal parts include deferred, suspended, and undeliverable.
[0093] Further, the step of matching the delayed parts includes:
[0094] If the daily available quantity of parts is less than the scheduled order date and the occupied quantity is less than the planned quantity, a success record is recorded and step S302 is executed;
[0095] If there is data that the occupied quantity in the daily available quantity of parts is less than the planned quantity of parts corresponding to the daily available quantity of parts but not less than the scheduled date of the order, then record the failure history and execute step S302;
[0096] If there is no corresponding part in the daily available quantity of the part whose occupied quantity is less than the planned quantity in the daily available quantity of the part, execute the matching pending parts step;
[0097] Further, the step of matching the delayed parts includes:
[0098] If the occupied quantity of the daily available quantity of parts is less than the planned quantity, a success record is recorded and step S302 is executed;
[0099] If the occupied quantity of the daily available quantity of the non-existent parts is less than the planned quantity, the step of matching the undeliverable parts is executed;
[0100] The matching cannot deliver parts steps include:
[0101] If the occupied quantity of the daily available quantity of parts is less than the planned quantity, a success record is recorded and step S302 is executed;
[0102] If there is no part in the daily available quantity where the occupied quantity is less than the planned quantity, step S302 is executed.
[0103] Furthermore, the S105 further includes:
[0104] If there are no matched pending parts or parts that cannot be delivered, and the deferred parts are not all successful resumes, the order scheduled date is used to take one working day backward in the schedulable time interval to execute step S303;
[0105] After the order cycle is completed, the date of the resume will be moved back within the range of the schedulable time interval according to the production cycle of different processes to determine the final scheduling date;
[0106] All resumes are sorted and summarized to generate a visual response report; the response report includes the final production scheduling date.
[0107] Specifically, in this embodiment, data cleaning includes:
[0108] (11) Generate a schedulable time interval for matching orders (excluding factory rest dates and specifying schedulable dates); hereinafter referred to as A (schedulable time interval).
[0109] (22) Supplier feedback parts are completed based on the full parts delivery list, and the daily available quantity of parts is generated; hereinafter referred to as B (Daily Available Quantity of Parts).
[0110] (33) The order is split into multiple lines according to the factory's production process to generate the order details to be matched (the order includes vehicles, self-made parts, and incompletely assembled scattered vehicles); hereinafter referred to as C (order details to be matched).
[0111] (44) The BOM and the order schedule date are calculated together to generate the order parts delivery list, hereinafter referred to as D (order parts delivery list).
[0112] Further, in this embodiment, the system matching process is shown in the attached Figure 3 According to the feedback from suppliers, they are divided into postponement, suspension, and undeliverable. The system matching process includes:
[0113] Step 1, loop through C (order details to be matched) in the same order order;
[0114] Step 2, read a process order record;
[0115] a) If it can be read, go to step 3;
[0116] b) If it cannot be read, execute step 11;
[0117] Step 3, obtain the scheduled order date E;
[0118] Step 4, filter the parts that exist in both D (order parts delivery date list) and B (parts daily available quantity) according to the order process.
[0119] Step 5, sort the parts found in the data cleaning step (22) according to the feedback type of postponed, suspended, and unable to deliver, and execute steps 6, 7, and 8.
[0120] Step 6, matching the delayed parts;
[0121] a) If the quantity in B (daily available quantity of parts) is less than date E and the occupied quantity is less than the planned quantity, record the success record and execute step 5.
[0122] b) If there is a corresponding part in B (daily available quantity of parts) where the occupied quantity is less than the planned quantity in B but there is no data less than date E, record the failure history and execute step 5.
[0123] c) If there is no corresponding part in B (daily available quantity of parts) whose occupied quantity is less than the planned quantity in B, execute step 7.
[0124] Step 7: Match the hanging parts
[0125] d) If the match is completed in step 6, proceed to step 5.
[0126] e) If the occupied quantity in B (daily available quantity of parts) is less than the planned quantity, record the successful record and execute step 5.
[0127] f) If there is no B (daily available quantity of parts) where the occupied quantity is less than the planned quantity, proceed to step 8.
[0128] Step 8, matching undeliverable parts;
[0129] g) Step 5 is executed if step 6 or 7 is matched.
[0130] h) If the occupied quantity in B (daily available quantity of parts) is less than the planned quantity, record the success record and execute step 5.
[0131] i) If there is no B (daily available quantity of parts) where the occupied quantity is less than the planned quantity, proceed to step 5.
[0132] Step 9, record occupancy according to the history;
[0133] j) If there are pending parts that have been matched or parts that cannot be delivered, all resumes will be converted to B
[0134] (Daily Available Quantity of Parts) and proceed to step 2.
[0135] k) If there are no matched pending parts or the parts cannot be delivered and the deferred parts are all successful records, the successful records are converted into the occupied quantity in B (daily available quantity of parts) and step 2 is executed.
[0136] l) If there are no matched pending parts or the parts cannot be delivered and the deferred parts are not all successful records, go to step 10.
[0137] Step 10, use date E (order scheduled date) to select one working day later in calendar A (production schedulable time interval) and execute step 4.
[0138] Step 11: After all order cycles are completed, the date of the records will be moved back within the range of A (schedulable time interval) according to the production cycle of different processes.
[0139] Step 12: Organize and summarize all resumes to generate a visual response report. Figure 4 , which is the report display result after the matching is completed in this embodiment.
[0140] like Figure 5 The system architecture diagram of this embodiment is shown. The system architecture mainly includes three aspects: demand reporting unit, order management department, and supplier. Among them, the demand reporting unit mainly submits the newly added daily order information to the order management department. The order management department formulates a daily draft plan, and then expands it based on MRP, obtains the full parts list, and sends it to the supplier. The supplier executes the parts resource delivery reply based on its own supply capacity, the parts list and the required date. The reply types are divided into three situations: postponement (delivery date needs to be filled in), suspension (unable to reply on the same day, delayed reply is required), and undeliverable (unable to supply).
[0141] The Order Management Department further conducts system matching and implements demand balancing meetings based on the parts resource delivery responses provided by suppliers, and then prepares daily plans to determine the production scheduling method for the orders.
[0142] This embodiment further describes the overall execution process of the system:
[0143] [Example 1]
[0144] 1. The expected production date of the newly added daily order X is September 10, and the expected production date of Y and Z is September 11, with the priority order being Y, Z, and X. After the daily-draft plan is calculated, the expected production date of X, Y, and Z is September 11.
[0145] 2. X, Y, and Z are converted into a parts list with the requirement date of September 11 for two parts, axle a and left front door lower hinge assembly b, based on the BOM (vehicle part relationship) system.
[0146] 3. According to the MRP expansion rules, it is found that axle a is being assembled in the final assembly and the left front door lower hinge assembly b is being assembled in the welding assembly. Therefore, the estimated arrival date of axle a is September 9 and the estimated arrival date of the left front door lower hinge assembly b is September 7.
[0147] 4. The supplier reported that one axle a was delivered on September 11, and one left front door lower hinge assembly b was delivered on September 10.
[0148] 5. When the system matches, it is found that order X has delayed delivery records on September 11 and September 10 according to the priority order. According to the process calculation, the axle will be available on September 13, and the left front door lower hinge assembly will be available on September 15. There are no abnormal records for orders Y and Z.
[0149] 6. After summarizing the history, the schedulable date for order X is September 15, and the schedulable date for Y and Z is September 11. In the balancing meeting, marketing directly schedules order X after confirming the order with a large deviation from the expected date.
[0150] [Example 2]
[0151] 1. The expected production date of the newly added daily order X is September 10, and the expected production date of Y and Z is September 11, with the priority order being Y, Z, and X. After the daily-draft plan is calculated, the expected production date of X, Y, and Z is September 11.
[0152] 2. X, Y, and Z are converted into a parts list with the requirement date of September 11 for two parts, axle a and left front door lower hinge assembly b, based on the BOM (vehicle part relationship) system.
[0153] 3. According to the MRP expansion rules, it is found that axle a is being assembled in the final assembly and the left front door lower hinge assembly b is being assembled in the welding assembly. Therefore, the estimated arrival date of axle a is September 9 and the estimated arrival date of the left front door lower hinge assembly b is September 7.
[0154] 4. The supplier reported that one axle a arrived on September 11 and one left front door lower hinge assembly b was hanging.
[0155] 5. When the system matches, it is found that order X has a suspension record and a delayed delivery record on September 10 according to the priority order. According to the process calculation, axle a needs to be suspended, and the left front door lower hinge assembly b will be available on September 15.
[0156] 6. After summarizing the records, the schedulable date of order X is suspended, and the schedulable date of Y and Z is September 11. In the balancing meeting, marketing and procurement selectively discuss order X, and after negotiation, they can choose to schedule directly and rebalance the next day.
[0157] [Example 3]
[0158] 1. The expected production date of the newly added daily order X is September 10, and the expected production date of Y and Z is September 11, with the priority order being Y, Z, and X. After the daily-draft plan is calculated, the expected production date of X, Y, and Z is September 11.
[0159] 2. X, Y, and Z are converted into a parts list with the requirement date of September 11 for two parts, axle a and left front door lower hinge assembly b, based on the BOM (vehicle part relationship) system.
[0160] 3. According to the MRP expansion rules, it is found that axle a is being assembled in the final assembly and the left front door lower hinge assembly b is being assembled in the welding assembly. Therefore, the estimated arrival date of axle a is September 9 and the estimated arrival date of the left front door lower hinge assembly b is September 7.
[0161] 4. The supplier reported that one axle a was scheduled to arrive on September 11, and one left front door lower hinge assembly b could not be delivered.
[0162] 5. When the system matches, it is found that order X has a record of undeliverable and delayed delivery on September 10 according to the priority order. According to the process calculation, axle a cannot be delivered, and the left front door lower hinge assembly b is available on September 15.
[0163] 6. After summarizing the history, the schedulable date of order X is undeliverable, and the schedulable date of Y and Z is September 11. The technical, marketing, and procurement departments will discuss the balancing meeting, and after negotiation, a clear solution will be determined, including cancellation, direct scheduling, and rebalancing the next day.
[0164] In addition, a second aspect of this embodiment provides a customer order processing device, such as Figure 6 As shown, the device includes an acquisition module 601, a designation module 602, a first processing module 603, a feedback module 604 and a second processing module 605; wherein:
[0165] The acquisition module 601 is used to acquire a newly added customer order; the customer order includes goods information;
[0166] The designation module 602 is used to designate the expected production date of the goods and the production priority of each part according to the remaining production capacity of the supplier corresponding to the goods;
[0167] The first processing module 603 is used to determine the parts list, parts demand date and parts expected arrival date of the goods in the customer order from the vehicle model parts relationship system BOM according to the goods corresponding to the expected production scheduling date, and specify the supplier corresponding to the parts according to the procurement ratio;
[0168] The feedback module 604 is used for the supplier to provide parts delivery feedback according to the purchase ratio; the parts delivery feedback includes abnormal parts that cannot be delivered as expected;
[0169] The second processing module 605 is used to determine the order details to be matched according to the parts delivery feedback, perform order matching processing according to the production scheduling priority, and generate and determine the final production scheduling date.
[0170] In addition, the device is used to execute the corresponding method steps of the first aspect. The second processing module 605 includes data cleaning and data matching step execution; the data cleaning step includes: generating a schedulable time interval for matching orders; completing incomplete feedback parts according to the supplier's parts delivery feedback and the full parts delivery list, and generating the daily available quantity of parts; according to the factory's production process, the customer order is split into multiple lines according to the process to generate the order details to be matched; based on the vehicle model parts relationship system BOM and the order pre-scheduled date, the order parts delivery list is jointly calculated.
[0171] The data matching step includes: according to the type of abnormal parts, cyclically accessing the order details to be matched in the same order sorting manner; the order details to be matched include multiple lines of process order records; reading a line of process order record and obtaining the order scheduled date; screening the parts that exist in the order parts delivery list and the daily available quantity of the parts according to the order process; performing matching steps according to the parts found in the types of abnormal parts and the types of abnormal parts fed back; the matching steps include matching deferred parts steps, matching suspended parts steps, and matching undeliverable parts steps; the types of abnormal parts include deferred, suspended, and undeliverable.
[0172] In addition, an embodiment of the present application also discloses an electronic device, which includes: one or more processors, and a memory, wherein the memory is used to store one or more computer programs; characterized in that the computer program is configured to be executed by the one or more processors, and the program includes steps for executing the customer order processing method described in the first aspect above.
[0173] In addition, an embodiment of the present application further provides a storage medium, which stores a computer program; the program is loaded and executed by a processor to implement the steps of the customer order processing method described in the first aspect above.
[0174] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in terms of function in the above description. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.
[0175] In the several embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. In addition, the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interfaces, devices or units, or it can be an electrical, mechanical or other form of connection.
[0176] The units described as separate components may or may not be physically separated. As a unit, it can be appreciated by those skilled in the art that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in terms of function in the above description. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.
[0177] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above integrated unit may be implemented in the form of hardware or in the form of software functional units.
[0178] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions for a computer device (which can be a personal computer, a server, or a grid device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk and other media that can store program codes.
[0179] The specific implementation methods described above further illustrate the objectives, technical solutions and beneficial effects of the present invention in detail. It should be understood that the above description is only a specific implementation method of the present invention and is not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the scope of protection of the present invention.
Claims
1. A method for processing customer orders, characterized in that: The method comprises: S101, obtaining a new customer order; the customer order includes goods information; S102, specifying an estimated production date for the goods and a production priority order for each component according to the remaining production capacity of the supplier corresponding to the goods; S103, according to the goods corresponding to the estimated production scheduling date, determine the parts list, parts demand date and parts estimated arrival date of the goods in the customer order from the vehicle model parts relationship system BOM, and specify the supplier corresponding to the parts according to the procurement ratio; S104, the supplier provides parts delivery feedback according to the purchase ratio; the parts delivery feedback includes abnormal parts that cannot be delivered as expected; S105, determining the order details to be matched according to the parts delivery feedback, performing order matching processing according to the production scheduling priority, and generating and determining the final production scheduling date.
2. The customer order processing method according to claim 1, characterized in that: The production scheduling priority includes generating a priority by sorting according to the number of balancing times, order submission unit, estimated production scheduling date, order source, order submission time, etc.
3. The customer order processing method according to claim 2, characterized in that: The step S105 includes data cleaning and data matching steps; the data cleaning step includes: Generate the schedulable time interval for matching orders; Complete the incomplete feedback parts according to the supplier's parts delivery feedback and the full parts delivery list, and generate the daily available quantity of parts; According to the factory's production process, the customer order is split into multiple lines according to the process to generate order details to be matched; The order parts delivery list is generated based on the vehicle model parts relationship system BOM and the order scheduled date.
4. The customer order processing method according to claim 3, characterized in that: The data matching step comprises: S301, according to the type of abnormal parts, cyclically access the order details to be matched in the same order sorting manner; the order details to be matched include multiple lines of process order records; S302, read a line of process order record and obtain the order scheduled date; S303, screening the parts that exist in both the order parts delivery date list and the parts daily available quantity according to the order process; S304, performing a matching step according to the types of abnormal parts that have been found and the types of abnormal parts that have been fed back; the matching step includes a step of matching deferred parts, a step of matching suspended parts, and a step of matching undeliverable parts; the types of abnormal parts include deferred, suspended, and undeliverable.
5. The customer order processing method according to claim 4, characterized in that: The step of matching the delayed parts includes: If the daily available quantity of parts is less than the scheduled order date and the occupied quantity is less than the planned quantity, a success record is recorded and step S302 is executed; If there is data that the occupied quantity in the daily available quantity of parts is less than the planned quantity of parts corresponding to the daily available quantity of parts but not less than the scheduled date of the order, then record the failure history and execute step S302; If there is no corresponding part in the daily available quantity of the part where the occupied quantity is less than the planned quantity in the daily available quantity of the part, execute the matching suspended parts step.
6. The customer order processing method according to claim 5, characterized in that: The step of matching the delayed parts includes: If the occupied quantity of the daily available quantity of parts is less than the planned quantity, a success record is recorded and step S302 is executed; If the occupied quantity of the daily available quantity of the non-existent parts is less than the planned quantity, the step of matching the undeliverable parts is executed; The matching cannot deliver parts steps include: If the occupied quantity of the daily available quantity of parts is less than the planned quantity, a success record is recorded and step S302 is executed; If there is no part in the daily available quantity where the occupied quantity is less than the planned quantity, step S302 is executed.
7. The customer order processing method according to claim 6, characterized in that: The S105 further includes: If there are no matched pending parts or parts that cannot be delivered, and the deferred parts are not all successful resumes, the order scheduled date is used to take one working day backward in the schedulable time interval to execute step S303; After the order cycle is completed, the date of the resume will be moved back within the range of the schedulable time interval according to the production cycle of different processes to determine the final scheduling date; All resumes are sorted and summarized to generate a visual response report; the response report includes the final production scheduling date.
8. A customer order processing device, characterized in that: The device comprises an acquisition module, a designation module, a first processing module, a feedback module and a second processing module, and is characterized in that: The acquisition module is used to acquire a newly added customer order; the customer order includes goods information; The designation module is used to designate the expected production date of the goods and the production priority of each part according to the remaining production capacity of the supplier corresponding to the goods; The first processing module is used to determine the parts list, parts demand date and parts expected arrival date of the goods in the customer order from the vehicle model parts relationship system BOM according to the goods corresponding to the expected production scheduling date, and specify the supplier corresponding to the parts according to the procurement ratio; The feedback module is used for the supplier to provide parts delivery feedback according to the purchase ratio; the parts delivery feedback includes abnormal parts that cannot be delivered as expected; The second processing module is used to determine the order details to be matched according to the parts delivery feedback, perform order matching processing according to the production scheduling priority, and generate and determine the final production scheduling date.
9. An electronic device, comprising: One or more processors, a memory, wherein the memory is used to store one or more computer programs; characterized in that the computer program is configured to be executed by the one or more processors, and the program includes steps for executing the customer order processing method according to any one of claims 1-7.
10. A storage medium storing a computer program; the program is loaded and executed by a processor to implement the steps of the customer order processing method according to any one of claims 1 to 7.