CN116862385A - Method, device, computer equipment and storage medium for adjusting difference of production data - Google Patents

Method, device, computer equipment and storage medium for adjusting difference of production data Download PDF

Info

Publication number
CN116862385A
CN116862385A CN202310709809.0A CN202310709809A CN116862385A CN 116862385 A CN116862385 A CN 116862385A CN 202310709809 A CN202310709809 A CN 202310709809A CN 116862385 A CN116862385 A CN 116862385A
Authority
CN
China
Prior art keywords
data
order
stock
bill
production order
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202310709809.0A
Other languages
Chinese (zh)
Inventor
颜驰湘
何小璇
仇婷
李星
袁渝翔
陈辉
李晓斌
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Hunan Kingdee Mobile Internet Technology Co ltd
Original Assignee
Hunan Kingdee Mobile Internet Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Hunan Kingdee Mobile Internet Technology Co ltd filed Critical Hunan Kingdee Mobile Internet Technology Co ltd
Priority to CN202310709809.0A priority Critical patent/CN116862385A/en
Publication of CN116862385A publication Critical patent/CN116862385A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • G06Q10/0875Itemisation or classification of parts, supplies or services, e.g. bill of materials
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F18/00Pattern recognition
    • G06F18/20Analysing
    • G06F18/22Matching criteria, e.g. proximity measures
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/04Manufacturing
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Tourism & Hospitality (AREA)
  • Data Mining & Analysis (AREA)
  • Human Resources & Organizations (AREA)
  • General Business, Economics & Management (AREA)
  • Strategic Management (AREA)
  • General Health & Medical Sciences (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Quality & Reliability (AREA)
  • Finance (AREA)
  • Accounting & Taxation (AREA)
  • Manufacturing & Machinery (AREA)
  • Health & Medical Sciences (AREA)
  • Operations Research (AREA)
  • Primary Health Care (AREA)
  • Development Economics (AREA)
  • Life Sciences & Earth Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Bioinformatics & Cheminformatics (AREA)
  • Bioinformatics & Computational Biology (AREA)
  • Computer Vision & Pattern Recognition (AREA)
  • Evolutionary Biology (AREA)
  • Evolutionary Computation (AREA)
  • General Engineering & Computer Science (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • General Factory Administration (AREA)

Abstract

The application relates to a method, a device, a computer device and a storage medium for adjusting the difference of production data. The method comprises the following steps: inquiring the bill of materials and corresponding process data in real time; acquiring preparation data and process planning data in a production order; the process planning data includes a process execution state; comparing the bill of materials with the stock preparation data to obtain a material difference result, and comparing the process data with the process planning data to obtain a process difference result; and adjusting the production order and downstream receipts thereof based on at least one of the material difference result or the process difference result and the process execution state. The method can be used for more conveniently and rapidly adjusting the production order and the downstream bill.

Description

Method, device, computer equipment and storage medium for adjusting difference of production data
Technical Field
The present application relates to the field of production automation, and in particular, to a method and apparatus for adjusting a difference in production data, a computer device, and a storage medium.
Background
BOM (Bill of materials) and process routes are important control files for guiding the processing and Material receiving processes of the production order, BOM data are embodied in the stock Material details of the production order, and process routes are embodied in the process plan details of the production order.
Due to the change of design in manufacturing enterprises, BOM and process route can be adjusted, and adjustment of production orders and downstream receipts is further caused, and currently, the main adjustment method for the production orders and the downstream receipts is to inquire and adjust corresponding production orders and downstream receipts on a production line one by one according to the adjusted BOM and process route, so that the problem of complex operation exists.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a method, an apparatus, a computer device, and a computer-readable storage medium for adjusting a production order and a downstream bill for a production data difference.
In a first aspect, the present application provides a method for variance adjustment of production data. The method comprises the following steps:
inquiring the bill of materials and corresponding process data in real time;
acquiring preparation data and process planning data in a production order; the process planning data includes a process execution state;
comparing the bill of materials with the stock preparation data to obtain a material difference result, and comparing the process data with the process planning data to obtain a process difference result;
and adjusting the production order and downstream receipts thereof based on at least one of the material difference result or the process difference result and the process execution state.
In one embodiment, the real-time querying of the bill of materials and the corresponding process data includes:
determining an item identifier;
inquiring a corresponding bill of materials in real time according to the item identification; the bill of materials includes one or more sub bill of materials;
determining a process route corresponding to the bill of materials; the process route comprises one or more procedures;
and determining process data corresponding to the working procedure according to the process route.
In one embodiment, the acquiring the stock material data and the process planning data in the production order includes:
determining a corresponding production order according to the item identification;
determining the material preparation data corresponding to the bill of materials in the production order;
and determining process planning data corresponding to the process data in the production order.
In one embodiment, comparing the bill of materials with the stock material data to obtain a material difference result, and comparing the process data with the process planning data to obtain a process difference result includes:
establishing a first corresponding relation between the sub bill of materials and sub stock data according to the working procedure; the stock data comprises one or more sub stock data;
Comparing the sub bill of materials with the sub stock data according to the first corresponding relation to obtain a material difference result corresponding to the working procedure;
establishing a second corresponding relation between sub-process data and sub-process planning data according to the process; the process data includes one or more of the sub-process data; the process planning data includes one or more of the sub-process planning data;
and comparing the sub-process data with the sub-process planning data according to the second corresponding relation to obtain a process difference result corresponding to the process.
In one embodiment, the downstream document is a stock-taking delivery bill or a stock-returning bill; the execution state of the working procedure is that the order is finished, the order is unfinished, the working procedure is finished or the working procedure is unfinished; the adjusting the production order and downstream documents thereof based on at least one of the material variance results or the process variance results, the process execution status includes:
when the process difference result is a new process, adjusting the production order and the material receiving and delivery order based on the fact that the order is finished or the order is unfinished and the new process;
When the process difference result is a modification process, adjusting the production order and the material receiving and delivery order based on the process completion or the process incompletion and the modification process;
and when the process difference result is a deletion process, adjusting the production order and the material return list based on the process incompletion and the deletion process.
In one embodiment, the adjusting the production order and the pick delivery order based on the order being completed or the order not being completed, the adding step comprises:
when the process execution state is that the order is finished, generating a reworked production order according to the newly added process and the production order, and adjusting the stock taking out order according to the newly added process;
and when the process execution state is that the order is not finished, adjusting the production order based on the new process and the corresponding new stock data, and adjusting the stock taking and delivering order according to the new stock data.
In one embodiment, said adjusting said production order and said return order based on said process unfinished and said deleted process comprises:
When the process execution state is that the process is not finished, determining a target process and material to be returned corresponding to the deleting process, deleting the target process and the material to be returned in the production order, and adjusting the material returning list according to the material to be returned;
the method further comprises the steps of:
and when the process execution state is that the process is finished, suspending the target process corresponding to the deleting process so as to manually analyze the target process.
In one embodiment, the downstream document is a stock-taking delivery bill or a stock-returning bill; the adjusting the production order and downstream documents thereof based on at least one of the material variance results or the process variance results, the process execution status includes:
when the material difference result is an increased stock, if the process execution state is that the process is finished, generating an industrial production order according to the increased stock, and adjusting the stock taking out order according to the increased stock;
if the process execution state is that the process is not finished, determining to increase the stock preparation data, and adjusting the production order and the stock taking and delivery order according to the increase stock preparation data.
In one embodiment, the adjusting the production order and its downstream documents based on the process execution status and at least one of the material variance results or the process variance results comprises:
and when the material difference result is reduced material preparation, determining reduced material preparation data if the process execution state is that the process is not finished, and adjusting the production order and the material return list according to the reduced material preparation data.
In a second aspect, the application also provides a device for adjusting the difference of production data. The device comprises:
the inquiring module is used for inquiring the bill of materials and the corresponding process data in real time;
the acquisition module is used for acquiring the material preparation data and the process planning data in the production order; the process planning data includes a process execution state;
the comparison module is used for comparing the bill of materials with the stock preparation data to obtain a material difference result, and comparing the process data with the process planning data to obtain a process difference result;
and the adjustment module is used for adjusting the production order and the downstream bill thereof based on at least one of the material difference result or the process difference result and the process execution state.
In one embodiment, the query module is further configured to determine an item identification; inquiring a corresponding bill of materials in real time according to the item identification; the bill of materials includes one or more sub bill of materials; determining a process route corresponding to the bill of materials; the process route comprises one or more procedures; and determining process data corresponding to the working procedure according to the process route.
In one embodiment, the obtaining module is further configured to determine a corresponding production order according to the item identifier; determining the material preparation data corresponding to the bill of materials in the production order; and determining process planning data corresponding to the process data in the production order.
In one embodiment, the comparison module is further configured to establish a first correspondence between the sub bill of materials and sub stock data according to the procedure; the stock data comprises one or more sub stock data; comparing the sub bill of materials with the sub stock data according to the first corresponding relation to obtain a material difference result corresponding to the working procedure; establishing a second corresponding relation between sub-process data and sub-process planning data according to the process; the process data includes one or more of the sub-process data; the process planning data includes one or more of the sub-process planning data; and comparing the sub-process data with the sub-process planning data according to the second corresponding relation to obtain a process difference result corresponding to the process.
In one embodiment, the downstream document is a stock-taking delivery bill or a stock-returning bill; the execution state of the working procedure is that the order is finished, the order is unfinished, the working procedure is finished or the working procedure is unfinished; the adjustment module is further used for adjusting the production order and the stock-taking and delivery order based on the order being completed or the order being unfinished and the new procedure when the procedure difference result is a new procedure; when the process difference result is a modification process, adjusting the production order and the material receiving and delivery order based on the process completion or the process incompletion and the modification process; and when the process difference result is a deletion process, adjusting the production order and the material return list based on the process incompletion and the deletion process.
In one embodiment, the adjusting module is further configured to generate a reworked production order according to the newly added process and the production order when the process execution state is that the order is completed, and adjust the stock-taking and delivery order according to the newly added process; and when the process execution state is that the order is not finished, adjusting the production order based on the new process and the corresponding new stock data, and adjusting the stock taking and delivering order according to the new stock data.
In one embodiment, the adjusting module is further configured to determine a target process and data to be returned corresponding to the deleting process when the process execution state is that the process is not completed, delete the target process and the data to be returned in the production order, and adjust the return order according to the data to be returned; and when the process execution state is that the process is finished, suspending the target process corresponding to the deleting process so as to manually analyze the target process.
In one embodiment, the downstream document is a stock-taking delivery or return document; the adjustment module is further used for generating an industrial production order according to the increased stock and adjusting the stock-taking and delivery order according to the increased stock if the process execution state is that the process is finished when the material difference result is the increased stock; if the process execution state is that the process is not finished, determining to increase the stock preparation data, and adjusting the production order and the stock taking and delivery order according to the increase stock preparation data.
In one embodiment, the adjustment module is further configured to determine reduced stock preparation data if the process execution status is that the process is not completed when the material difference result is reduced stock preparation, and adjust the production order and the material return order according to the reduced stock preparation data.
In a third aspect, the present application also provides a computer device. The computer device comprises a memory storing a computer program and a processor implementing the steps of the above method when the processor executes the computer program.
In a fourth aspect, the present application also provides a computer-readable storage medium. The computer readable storage medium has stored thereon a computer program which, when executed by a processor, implements the steps of the above method.
In a fifth aspect, the present application also provides a computer program product. The computer program product comprises a computer program which, when executed by a processor, implements the steps of the above method.
The method, the device, the computer equipment, the storage medium and the computer program product for adjusting the difference of the production data are realized by inquiring the bill of materials and the corresponding process data in real time; acquiring preparation data and process planning data in a production order; the process planning data includes a process execution state; comparing the bill of materials with the material preparation data to obtain a material difference result, and comparing the process data with the process planning data to obtain a process difference result; the method for adjusting the production order and the downstream bill thereof based on at least one of the material difference result or the process difference result and the process execution state realizes automatic comparison of the differences, obtains the difference result, and adjusts the production order and the downstream bill thereof according to the difference result.
Drawings
FIG. 1 is an application environment diagram of a method for variance adjustment of production data in one embodiment;
FIG. 2 is a flow chart of a method for variance adjustment of production data according to one embodiment;
FIG. 3 is a flow chart illustrating steps for adjusting a production order and its downstream documents in one embodiment;
FIG. 4 is a schematic diagram of a change handling assembly according to another embodiment;
FIG. 5 is a block diagram showing a construction of a variance adjusting apparatus of production data in one embodiment;
fig. 6 is an internal structural diagram of a computer device in one embodiment.
Detailed Description
The present application will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present application more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the application.
The method for adjusting the difference of the production data provided by the embodiment of the application can be applied to an application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. The data storage system may store data that the server 104 needs to process. The data storage system may be integrated on the server 104, or may be placed on a cloud or other network server, and the present application may be executed by the terminal 102 or the server 104, and this embodiment is described as an example executed by the terminal 102.
The terminal 102 queries the bill of materials and corresponding process data in real time; acquiring preparation data and process planning data in a production order; the process planning data includes a process execution state; comparing the bill of materials with the material preparation data to obtain a material difference result, and comparing the process data with the process planning data to obtain a process difference result; and adjusting the production order and the downstream bill thereof based on at least one of the material difference result or the process difference result and the process execution state.
The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, internet of things devices, and portable wearable devices, where the internet of things devices may be smart speakers, smart televisions, smart air conditioners, smart vehicle devices, and the like. The portable wearable device may be a smart watch, smart bracelet, headset, or the like. The server 104 may be implemented as a stand-alone server or as a server cluster of multiple servers.
In one embodiment, as shown in fig. 2, a method for adjusting the variance of production data is provided, and the method is applied to the terminal 102 in fig. 1, and is illustrated as an example, and includes the following steps:
S202, inquiring the bill of materials and corresponding process data in real time.
The bill of materials (BOM) refers to a file describing a product structure in a data format, and is a product structure data file that can be identified by a computer, and is also a dominant file of ERP (Enterprise Resource Planning ). Process data may refer to data related to process routes. The process route may refer to a rating condition for representing one processing route (processing order) of an enterprise product at an enterprise and standard man-hours in respective processes.
Specifically, determining an item identification; inquiring a corresponding bill of materials in real time according to the item identification; the bill of materials includes one to a plurality of sub bill of materials; determining a process route corresponding to the bill of materials; the process route comprises one or more procedures; and determining process data corresponding to the working procedure according to the process route.
Wherein, the item identifier may refer to a product-related item correspondence identifier, including but not limited to an item number. A sub-bill of materials may refer to a sub-bill of materials belonging to a BOM, e.g., the BOM may be expanded in multiple layers, and each layer of bill of materials of the BOM may serve as a sub-bill of materials. The process refers to the combination of continuous production activities of a worker (or a group of workers) on a work place to a labor object (or several labor objects), and is a basic unit for the production process.
S204, acquiring material preparation data and process planning data in a production order; the process planning data includes a process execution state.
The production order may refer to an order corresponding to a produced product, and the production order includes stock preparation data and process planning data. The stock data may refer to material data required for producing the product in the order, for example, the stock data includes, but is not limited to, material codes, material names, specification models, measurement units, job numbers, unit usage, standard usage, demand numbers, wear rates, wear numbers, demand dates, supply types, supply inventory organizations, stock receiving warehouses, stock receiving departments, stock receiving modes, actual stock sending numbers, manufacturing numbers, planned stock returning numbers, quota control, quota upper limit tolerance, and stock receiving upper limit numbers, and the like. The process planning data may refer to process-related data in a production order, including, for example, a work order number, a outsourcing type, a processing organization, a process number, a process name, a process description, a work center, a processing division, a process quantity, a cumulative rework quantity, an overrun measure, a cumulative implementation quantity upper limit, a report point, an earliest start time, an earliest finish time, a preparation time, a processing time, a time unit, a report quantity, a qualified quantity, a yield quantity, a waste quantity, and the like. The process planning data includes, but is not limited to, process execution status. The process execution status includes, but is not limited to, order completed, order unfinished, process completed, and process unfinished.
Specifically, determining a corresponding production order according to the item identification; determining stock data corresponding to the bill of materials in the production order; process planning data corresponding to the process data in the production order is determined.
S206, comparing the bill of materials with the stock preparation data to obtain a material difference result, and comparing the process data with the process planning data to obtain a process difference result.
The material difference result is obtained after the material list is compared with the material preparation data. The process difference result refers to a difference result obtained after the process data and the process plan data are compared.
Specifically, a first corresponding relation between a sub bill of materials and sub stock data is established according to the procedure; the stock data comprises one or more sub stock data; comparing the sub bill of materials with sub stock data according to the first corresponding relation to obtain a material difference result corresponding to the working procedure; establishing a second corresponding relation between the sub-process data and the sub-process planning data according to the process; the process data includes one or more sub-process data; the process planning data includes one or more sub-process planning data; and comparing the sub-process data with the sub-process planning data according to the second corresponding relation to obtain a process difference result corresponding to the process.
The first correspondence is a correspondence between the sub bill of materials and sub stock data. The sub stock data may refer to data belonging to stock data. The second correspondence is a correspondence between process data and process planning data. Sub-process data may refer to data pertaining to process data. The sub-process planning data may refer to data belonging to process planning data.
In one embodiment, in the difference analysis interface, in response to the comparison operation of the materials, the bill of materials is compared with the material preparation data to obtain difference results of the materials, in response to the comparison operation of the working procedures, the process data and the working procedure planning data are compared to obtain difference results of the working procedures, and the one-key analysis of the differences between the materials or the working procedures is realized.
The difference analysis interface may be an interface for performing a comparative analysis on differences in materials or processes.
In one embodiment, after S206, the obtained material difference result or the process difference result is displayed on the difference analysis interface, so that the difference result is displayed quickly after the material difference result or the process difference result is obtained.
And S208, adjusting the production order and the downstream bill thereof based on at least one of the material difference result or the process difference result and the process execution state.
Wherein the downstream document may refer to a downstream document corresponding to a production order. Optionally, the downstream bill includes a stock-taking out bill or a stock-returning bill, and the stock-taking out bill may refer to a stock-taking out bill generated when stock is taken. The material returning sheet may refer to a material returning sheet generated when returning and preparing materials.
In one embodiment, in the bill adjustment interface, in response to adjustment operation of a production order, adjustment of the production order and downstream bills thereof is performed based on at least one of a material difference result or a process difference result and a process execution state, so that batch adjustment of the production order and the downstream bills thereof is performed by one key according to the difference result.
The document adjustment interface may refer to an interface for adjusting a production order and documents downstream thereof.
In one embodiment, the adjusted production order and its downstream documents are presented in a document adjustment interface.
In one embodiment, the difference result may be a material difference result or a process difference result, and when the difference result is a material difference result and a process difference result, or at least 2 material difference results, or at least 2 process difference results, the production order and documents downstream thereof may be adjusted in an asynchronous manner.
For example, when the difference result is a material difference result and a process difference result, the production order and the downstream bill thereof are adjusted based on the material difference result and the process execution state, respectively, in an asynchronous manner, and the production order and the downstream bill thereof are adjusted based on the process difference result and the process execution state.
And when the difference result is at least 2 material difference results, adjusting the production order and the downstream bill thereof based on each material difference result and the corresponding procedure execution state in an asynchronous mode.
And when the difference result is at least 2 process difference results, adjusting the production order and the downstream bill thereof based on each process difference result and the corresponding process execution state in an asynchronous mode.
In one embodiment, S206 and S208 may be performed in a multithreading and asynchronous manner in response to the corresponding triggering operation, and the adjustment of the variance analysis and the document (the production order and its downstream documents) may be performed or stopped with the triggering operation, greatly improving the interaction capability with the user.
In one embodiment, the downstream document is a stock-out receipt or a stock-out receipt; when the material difference result is that the material preparation is increased, if the process execution state is that the process is finished, generating an industrial production order according to the material preparation increase, and adjusting the material receiving and delivering order according to the material preparation increase; if the process execution state is that the process is not finished, the increase of the stock preparation data is determined, and the production order and the stock taking and delivery order are adjusted according to the increase of the stock preparation data.
Wherein, adding stock may refer to a material difference result obtained when the material bill is more than the material of the stock data. An industrial production order may refer to an auxiliary production order, which is processed by an industrial production order for a business scenario requiring adjustment of a production order pick plan during standard production. The additional stock material data may refer to a portion of the stock material data having more bill of materials than stock material data when the material difference results in the additional stock material.
In one embodiment, when the material difference results in reduced stock, if the process execution status is that the process is not completed, the reduced stock data is determined, and the production order and the return bill are adjusted according to the reduced stock data.
Wherein, the reduction of stock may refer to the material difference result obtained when the material bill is less than the material of the stock data. The reduced stock material data may refer to a portion of the stock material data having more stock material data than the bill of material when the material variance results in reduced stock material.
In yet another embodiment, when the material variance results in reduced stock, no adjustments to the production order and its downstream documents are needed if the process execution status is that the process is complete.
In the method for adjusting the difference of the production data, the bill of materials and the corresponding process data are inquired in real time; acquiring preparation data and process planning data in a production order; the process planning data includes a process execution state; comparing the bill of materials with the material preparation data to obtain a material difference result, and comparing the process data with the process planning data to obtain a process difference result; the method for adjusting the production order and the downstream bill thereof based on at least one of the material difference result or the process difference result and the process execution state realizes automatic comparison of the differences, obtains the difference result, and adjusts the production order and the downstream bill thereof according to the difference result.
In one embodiment, as shown in FIG. 3, the step of adjusting the production order and its downstream orders includes:
s302, when the process difference result is a new process, the production order and the material receiving and delivery order are adjusted based on the new process, which is completed or not completed.
The new process may be a process difference result obtained when the process data is greater than the process of the process plan data.
In one embodiment, adjusting the production order and the pick-up ex-warehouse order based on the order completed or the order unfinished, new procedure includes: when the process execution state is that the order is finished, generating a reworked production order according to the newly added process and the production order, and adjusting the material receiving and delivering order according to the newly added process; when the process execution state is that the order is not complete, the production order is adjusted based on the newly added process and the corresponding newly added material preparation data, and the material receiving and delivering order is adjusted according to the newly added material preparation data.
The reworking production order may refer to an auxiliary production order, and in a standard production process, for a business scenario requiring adjustment of a machining process, the reworking production order is used to process the scenario. The newly added material preparation data may refer to material data corresponding to the new addition when the process data is more than the process of the process plan data, i.e., material data that needs to be newly added.
And S304, when the process difference result is a modification process, adjusting the production order and the material receiving and delivery order based on the completed process or the unfinished process.
And modifying the process, wherein when different processes exist between the process data and the process planning data, the obtained process difference result is obtained.
In one embodiment, adjusting the production order and the pick delivery order based on the process completed or the process unfinished, modified process includes: when the process execution state is that the process is finished, determining a corresponding process identifier according to the modification process, adjusting a production order according to the process identifier, and adjusting a stock taking and delivering order according to the process identifier; and when the process execution state is that the process is not completed, adjusting the production order and the material receiving and delivery order according to the modification process.
The process identifier may be an identifier corresponding to a process, for example, a process number.
And S306, when the process difference result is the deletion process, adjusting the production order and the material return list based on the process incompletion and the deletion process.
Here, the deletion process may be a process difference result obtained when the process data is smaller than the process of the process plan data.
In one embodiment, adjusting the production order and the return order based on the process incompletion and the deletion process includes: when the process execution state is that the process is not finished, determining a target process and to-be-returned stock data corresponding to the deleted process, deleting the target process and the to-be-returned stock data in the production order, and adjusting the stock return list according to the to-be-returned stock data.
The target process may refer to a process of target processing. The material preparation data to be returned may refer to material data which is correspondingly reduced when the process data is less than the process of the process planning data, i.e. material data which needs to be returned.
In one embodiment, when the process execution state is that the process has been completed, a suspension process is performed on the target process corresponding to the deleted process, so that manual analysis is performed on the target process.
In this embodiment, when the process difference result is a new process, the production order and the material receiving and delivering order are adjusted based on the order completed or the order unfinished and the new process, when the process difference result is a modification process, the production order and the material receiving and delivering order are adjusted based on the process completed or the process unfinished and the modification process, and when the process difference result is a deletion process, the production order and the material receiving and delivering order are adjusted based on the process unfinished and the deletion process, so that the accurate adjustment of the production order and the downstream bill according to different process difference results can be achieved.
As one example, the present embodiment is as follows;
1. acquiring a corresponding BOM through inquiring the entered item number, expanding a plurality of layers of the BOM, and inquiring process data by combining a process route;
2. Acquiring a production order through the entered item number, wherein the production order comprises stock preparation data and process planning data;
3. based on the process data corresponding to the BOM and the process route, comparing the difference between the production order and the BOM and the process data from two dimensions of the materials and the working procedure, and displaying a difference result in a technical aspect by adopting an asynchronous and real-time combination mode;
4. FIG. 4 is a schematic diagram of a change handling assembly according to another embodiment; as shown in FIG. 4, the planner can determine whether to process the difference result according to the difference result, if so, the planner can call the change processing component to execute the change action and dynamically adjust the production order and the downstream component (downstream bill), thereby influencing the downstream production execution process and eliminating the difference. A change processing component: the production order and the different downstream components are adjusted according to different reasons of the difference. The assembly comprehensively covers the downstream processing flow based on the process difference (process difference result) and the material preparation difference (material difference result), the flow coverage is higher, and the difference processing is more comprehensive; meanwhile, the states of all downstream nodes are considered, and the execution result is more accurate; the operator does not need to manually judge, the execution speed is higher, and the specific change processing components are shown in the following table 1.
Table 1: change processing component
According to the embodiment, the difference analysis and comparison of the BOM and the preparation data comparison model in the production order and the process data and the comparison model of the process planning data in the production order are realized, and the dynamic change and adjustment of the production order and the downstream components thereof are realized by combining standard production, industrial production and reworking production packaging change processing components. The method supports batch calculation, repeated calculation or interruption calculation according to actual conditions, is simple to operate, has transparent calculation process and has clear comparison result. Furthermore, the progress information is timely reflected through updating the background schedule; the context realizes the intervention difference result of the difference analysis process; meanwhile, the difference comparison between design and production execution is realized on a UI (User Interface), and the data difference is displayed by a specific color.
The problems of difficult analysis and difficult treatment of the difference between the production execution and the BOM and the process design are solved, and the method has the following advantages: one-key analysis of the difference between the production execution and the process design, and rapid display of the difference result; performing a difference result by one key, and adjusting downstream production business by batch production of related business documents; the multithreading and asynchronous processing mode is adopted, the foreground operation user interface is unified, the analysis and execution process can be stopped at any time, and the user experience is effectively improved; the execution efficiency is higher (if 500 change differences exist in one project, the processing according to the original flow takes more than 3 days, only 5 minutes are needed now, and the efficiency is improved by 80000%); the execution results can be traced (which data is explicitly executed, who is executed, and the execution basis).
It should be understood that, although the steps in the flowcharts related to the above embodiments are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.
Based on the same inventive concept, the embodiment of the application also provides a difference adjustment device for the production data, which is used for realizing the difference adjustment method for the production data. The implementation of the solution provided by the device is similar to the implementation described in the above method, so the specific limitation in the embodiments of the differential adjustment device for one or more production data provided below may refer to the limitation of the differential adjustment method for the production data hereinabove, and will not be repeated herein.
In one embodiment, as shown in fig. 5, there is provided a variance adjusting apparatus of production data, comprising: a query module 502, an acquisition module 504, a comparison module 506, and an adjustment module 508, wherein:
and the query module 502 is configured to query the bill of materials and corresponding process data in real time.
An acquisition module 504, configured to acquire stock data and process planning data in a production order; the process planning data includes a process execution state.
The comparison module 506 is configured to compare the bill of materials with the stock material data to obtain a material difference result, and compare the process data with the process planning data to obtain a process difference result.
An adjustment module 508 is configured to adjust the production order and the downstream document thereof based on at least one of the material variance result or the process variance result and the process execution status.
In one embodiment, the query module 502 is also used to determine item identifications; inquiring a corresponding bill of materials in real time according to the item identification; the bill of materials includes one to a plurality of sub bill of materials; determining a process route corresponding to the bill of materials; the process route comprises one or more procedures; and determining process data corresponding to the working procedure according to the process route.
In one embodiment, the obtaining module 504 is further configured to determine a corresponding production order according to the item identifier; determining stock data corresponding to the bill of materials in the production order; process planning data corresponding to the process data in the production order is determined.
In one embodiment, the comparison module 506 is further configured to establish a first correspondence between the sub bill of materials and the sub stock data according to the process; the stock data comprises one or more sub stock data; comparing the sub bill of materials with sub stock data according to the first corresponding relation to obtain a material difference result corresponding to the working procedure; establishing a second corresponding relation between the sub-process data and the sub-process planning data according to the process; the process data includes one or more sub-process data; the process planning data includes one or more sub-process planning data; and comparing the sub-process data with the sub-process planning data according to the second corresponding relation to obtain a process difference result corresponding to the process.
In one embodiment, the downstream document is a stock-out receipt or a stock-out receipt; the process execution state is that the order is finished, the order is unfinished, the process is finished or the process is unfinished; the adjustment module 508 is further configured to adjust the production order and the stock-taking and delivery order based on the order being completed or the order not being completed when the process difference result is the newly added process; when the process difference result is a modification process, adjusting the production order and the material receiving and delivery order based on the completed process or the unfinished process; when the process difference results in the deletion process, the production order and the return order are adjusted based on the process incompletion and the deletion process.
In one embodiment, the adjustment module 508 is further configured to generate a reworked production order according to the newly added process and the production order when the process execution status is that the order is completed, and adjust the stock taking out order according to the newly added process; when the process execution state is that the order is not complete, the production order is adjusted based on the newly added process and the corresponding newly added material preparation data, and the material receiving and delivering order is adjusted according to the newly added material preparation data.
In one embodiment, the adjustment module 508 is further configured to determine, when the process execution status is that the process is not complete, deleting the target process and the data of the material to be returned corresponding to the deleted process, delete the target process and the data of the material to be returned in the production order, and adjust the material return order according to the data of the material to be returned; when the process execution state is that the process is finished, the target process corresponding to the deleted process is suspended so as to manually analyze the target process.
In one embodiment, the adjustment module 508 is further configured to generate an inline production order according to the added stock and adjust the stock-out order according to the added stock if the process execution status is that the process is completed when the material difference result is the added stock; if the process execution state is that the process is not finished, the increase of the stock preparation data is determined, and the production order and the stock taking and delivery order are adjusted according to the increase of the stock preparation data.
In one embodiment, the adjustment module 508 is further configured to determine the reduced stock data when the material difference results in reduced stock, and adjust the production order and the return order according to the reduced stock data if the process execution status is that the process is not completed.
In the embodiment, the bill of materials and the corresponding process data are inquired in real time; acquiring preparation data and process planning data in a production order; the process planning data includes a process execution state; comparing the bill of materials with the material preparation data to obtain a material difference result, and comparing the process data with the process planning data to obtain a process difference result; the method for adjusting the production order and the downstream bill based on at least one of the material difference result or the process difference result and the process execution state realizes automatic comparison of the difference, obtains the difference result, and adjusts the production order and the downstream bill according to the difference result.
The respective modules in the above-described difference adjustment apparatus for production data may be implemented in whole or in part by software, hardware, and combinations thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a terminal or a server, and the computer device is taken as an example of a terminal, and the internal structure diagram thereof may be shown in fig. 6. The computer device includes a processor, a memory, an input/output interface, a communication interface, a display unit, and an input means. The processor, the memory and the input/output interface are connected through a system bus, and the communication interface, the display unit and the input device are connected to the system bus through the input/output interface. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The input/output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless mode can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program is executed by a processor to implement a method of variance adjustment of production data. The display unit of the computer equipment is used for forming a visual picture, and can be a display screen, a projection device or a virtual reality imaging device, wherein the display screen can be a liquid crystal display screen or an electronic ink display screen, the input device of the computer equipment can be a touch layer covered on the display screen, can also be a key, a track ball or a touch pad arranged on a shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.
It will be appreciated by those skilled in the art that the structure shown in FIG. 6 is merely a block diagram of some of the structures associated with the present inventive arrangements and is not limiting of the computer device to which the present inventive arrangements may be applied, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.
In one embodiment, a computer device is provided that includes a memory having a computer program stored therein and a processor that implements the above embodiments when the processor executes the computer program.
In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored which, when executed by a processor, implements the above embodiments.
In one embodiment, a computer program product is provided comprising a computer program which, when executed by a processor, implements the embodiments described above.
It should be noted that, the user information (including but not limited to user equipment information, user personal information, etc.) and the data (including but not limited to data for analysis, stored data, presented data, etc.) related to the present application are information and data authorized by the user or sufficiently authorized by each party, and the collection, use and processing of the related data need to comply with the related laws and regulations and standards of the related country and region.
Those skilled in the art will appreciate that implementing all or part of the above-described methods in accordance with the embodiments may be accomplished by way of a computer program, which may be stored on a non-transitory computer readable storage medium, which when executed may comprise the steps of the embodiments of the methods described above. Any reference to memory, database, or other medium used in embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the embodiments provided herein may include at least one of a relational database and a non-relational database. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processor referred to in the embodiments provided in the present application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic unit, a data processing logic unit based on quantum computing, or the like, but is not limited thereto.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The foregoing examples illustrate only a few embodiments of the application, which are described in detail and are not to be construed as limiting the scope of the application. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the application, which are all within the scope of the application. Accordingly, the scope of the application should be assessed as that of the appended claims.

Claims (12)

1. A method of variance adjustment of production data, the method comprising:
inquiring the bill of materials and corresponding process data in real time;
acquiring preparation data and process planning data in a production order; the process planning data includes a process execution state;
comparing the bill of materials with the stock preparation data to obtain a material difference result, and comparing the process data with the process planning data to obtain a process difference result;
And adjusting the production order and downstream receipts thereof based on at least one of the material difference result or the process difference result and the process execution state.
2. The method of claim 1, wherein the real-time querying of the bill of materials and corresponding process data comprises:
determining an item identifier;
inquiring a corresponding bill of materials in real time according to the item identification; the bill of materials includes one or more sub bill of materials;
determining a process route corresponding to the bill of materials; the process route comprises one or more procedures;
and determining process data corresponding to the working procedure according to the process route.
3. The method of claim 2, wherein the acquiring stock data and process planning data in a production order comprises:
determining a corresponding production order according to the item identification;
determining the material preparation data corresponding to the bill of materials in the production order;
and determining process planning data corresponding to the process data in the production order.
4. The method of claim 2, wherein comparing the bill of materials to the stock material data to obtain a bill of materials difference result, and comparing the process data to the process planning data to obtain a process difference result comprises:
Establishing a first corresponding relation between the sub bill of materials and sub stock data according to the working procedure; the stock data comprises one or more sub stock data;
comparing the sub bill of materials with the sub stock data according to the first corresponding relation to obtain a material difference result corresponding to the working procedure;
establishing a second corresponding relation between sub-process data and sub-process planning data according to the process; the process data includes one or more of the sub-process data; the process planning data includes one or more of the sub-process planning data;
and comparing the sub-process data with the sub-process planning data according to the second corresponding relation to obtain a process difference result corresponding to the process.
5. The method of claim 1, wherein the downstream document is a pick delivery slip or a return slip; the execution state of the working procedure is that the order is finished, the order is unfinished, the working procedure is finished or the working procedure is unfinished; the adjusting the production order and downstream documents thereof based on at least one of the material variance results or the process variance results, the process execution status includes:
When the process difference result is a new process, adjusting the production order and the material receiving and delivery order based on the fact that the order is finished or the order is unfinished and the new process;
when the process difference result is a modification process, adjusting the production order and the material receiving and delivery order based on the process completion or the process incompletion and the modification process;
and when the process difference result is a deletion process, adjusting the production order and the material return list based on the process incompletion and the deletion process.
6. The method of claim 5, wherein the adjusting the production order and the pick delivery order based on the order being completed or the order not being completed, the new process comprises:
when the process execution state is that the order is finished, generating a reworked production order according to the newly added process and the production order, and adjusting the stock taking out order according to the newly added process;
and when the process execution state is that the order is not finished, adjusting the production order based on the new process and the corresponding new stock data, and adjusting the stock taking and delivering order according to the new stock data.
7. The method of claim 5, wherein the adjusting the production order and the return order based on the process incompletion and the deletion process comprises:
when the process execution state is that the process is not finished, determining a target process and material to be returned corresponding to the deleting process, deleting the target process and the material to be returned in the production order, and adjusting the material returning list according to the material to be returned;
the method further comprises the steps of:
and when the process execution state is that the process is finished, suspending the target process corresponding to the deleting process so as to manually analyze the target process.
8. The method of claim 1, wherein the downstream document is a pick delivery slip or a return slip; the adjusting the production order and downstream documents thereof based on at least one of the material variance results or the process variance results, the process execution status includes:
when the material difference result is an increased stock, if the process execution state is that the process is finished, generating an industrial production order according to the increased stock, and adjusting the stock taking out order according to the increased stock;
If the process execution state is that the process is not finished, determining to increase the stock preparation data, and adjusting the production order and the stock taking and delivery order according to the increase stock preparation data.
9. The method of claim 8, wherein the adjusting the production order and its downstream documents based on the process execution status and at least one of the material variance results or the process variance results comprises:
and when the material difference result is reduced material preparation, determining reduced material preparation data if the process execution state is that the process is not finished, and adjusting the production order and the material return list according to the reduced material preparation data.
10. A variance adjustment apparatus of production data, the apparatus comprising:
the inquiring module is used for inquiring the bill of materials and the corresponding process data in real time;
the acquisition module is used for acquiring the material preparation data and the process planning data in the production order; the process planning data includes a process execution state;
the comparison module is used for comparing the bill of materials with the stock preparation data to obtain a material difference result, and comparing the process data with the process planning data to obtain a process difference result;
And the adjustment module is used for adjusting the production order and the downstream bill thereof based on at least one of the material difference result or the process difference result and the process execution state.
11. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any one of claims 1 to 9 when the computer program is executed.
12. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 9.
CN202310709809.0A 2023-06-15 2023-06-15 Method, device, computer equipment and storage medium for adjusting difference of production data Pending CN116862385A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310709809.0A CN116862385A (en) 2023-06-15 2023-06-15 Method, device, computer equipment and storage medium for adjusting difference of production data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310709809.0A CN116862385A (en) 2023-06-15 2023-06-15 Method, device, computer equipment and storage medium for adjusting difference of production data

Publications (1)

Publication Number Publication Date
CN116862385A true CN116862385A (en) 2023-10-10

Family

ID=88225925

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310709809.0A Pending CN116862385A (en) 2023-06-15 2023-06-15 Method, device, computer equipment and storage medium for adjusting difference of production data

Country Status (1)

Country Link
CN (1) CN116862385A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN118071263A (en) * 2024-04-19 2024-05-24 北京谷器数据科技有限公司 Automatic bill of materials changing method, device, electronic equipment and medium

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN118071263A (en) * 2024-04-19 2024-05-24 北京谷器数据科技有限公司 Automatic bill of materials changing method, device, electronic equipment and medium

Similar Documents

Publication Publication Date Title
US20160103903A1 (en) Systems, devices, and methods for generation of contextual objects mapped by dimensional data to data measures
CN113626914A (en) Engineering project management method, device and system based on digital twins
US20140279628A1 (en) Systems and methods of managing employee teams
US20150120368A1 (en) Retail and downstream supply chain optimization through massively parallel processing of data using a distributed computing environment
US20160019488A1 (en) Workflow management device and workflow management method
CN107862436B (en) Method and device for generating bill of material, terminal and computer-readable storage medium
US20140310034A1 (en) Performance indicator analytical framework
JP6709871B2 (en) Generate project artifacts using data model objects
KR20150065719A (en) Techniques to present event information using an event timing visualization
CN105184542A (en) Enterprise resource plan real time management method and system based on material stock state
US20160071033A1 (en) Methods and apparatus for tracking construction material delivery
CN116862385A (en) Method, device, computer equipment and storage medium for adjusting difference of production data
CN106056323A (en) Work navigation panel system based on PDM
CN109190984B (en) Data processing system and method based on data cube model
Dewa et al. Digitalisation OF SHOP-floor operations IN the SOUTH AFRICAN tool, die, and mould-making industry
US20150120367A1 (en) Geospatially relevant supply chain optimization through a networked mobile device that leverages a distributed computing environment
US20140244330A1 (en) System and method for assessing and managing a facility
JP2017072910A (en) Schedule generation apparatus and schedule generation method
CN115660261B (en) Production order information processing method, computer device and storage medium
US20170308837A1 (en) Productivity measurement, modeling and illustration system
CN115409014A (en) Document template generation method and device, computer equipment and storage medium
CN116956817A (en) Part coding method, process flow determining method and flat electronic product
US10552455B2 (en) Analytics enablement for engineering records
CN114510682A (en) Energy consumption calculation method and device, computer equipment and storage medium
US20150120355A1 (en) Mobile terminal management server and mobile terminal management program

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination