CN117391587A - Spare part management system and method - Google Patents
Spare part management system and method Download PDFInfo
- Publication number
- CN117391587A CN117391587A CN202311450372.XA CN202311450372A CN117391587A CN 117391587 A CN117391587 A CN 117391587A CN 202311450372 A CN202311450372 A CN 202311450372A CN 117391587 A CN117391587 A CN 117391587A
- Authority
- CN
- China
- Prior art keywords
- management
- module
- spare parts
- warehouse
- spare
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 49
- 230000008569 process Effects 0.000 claims abstract description 40
- 238000004519 manufacturing process Methods 0.000 claims abstract description 28
- 238000004891 communication Methods 0.000 claims abstract description 5
- 210000001503 joint Anatomy 0.000 claims abstract description 5
- 238000007726 management method Methods 0.000 claims description 178
- 239000000463 material Substances 0.000 claims description 14
- 230000002159 abnormal effect Effects 0.000 claims description 7
- 230000005540 biological transmission Effects 0.000 claims description 5
- 238000012384 transportation and delivery Methods 0.000 claims description 5
- 238000012790 confirmation Methods 0.000 claims description 4
- 238000001914 filtration Methods 0.000 claims description 3
- 238000012423 maintenance Methods 0.000 description 8
- 238000010586 diagram Methods 0.000 description 4
- 238000007689 inspection Methods 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 2
- 230000008901 benefit Effects 0.000 description 2
- 230000003111 delayed effect Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000000227 grinding Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 238000012795 verification Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 238000012550 audit Methods 0.000 description 1
- 239000012141 concentrate Substances 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 230000000737 periodic effect Effects 0.000 description 1
- 230000002035 prolonged effect Effects 0.000 description 1
- 238000012552 review Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL 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
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Strategic Management (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- Economics (AREA)
- Tourism & Hospitality (AREA)
- Data Mining & Analysis (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- General Business, Economics & Management (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Development Economics (AREA)
- Manufacturing & Machinery (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Software Systems (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Computational Linguistics (AREA)
- General Factory Administration (AREA)
Abstract
The invention belongs to the technical field of production management of manufacturing enterprises, and relates to a spare part management system and method. The spare part management system comprises a server and mobile equipment in wireless connection communication with the server, wherein a basic information management module, a spare part management module, a query statistics management module and a system management module are installed and operated in the server, and the spare part management module comprises a warehouse entry management sub-module, an approval management sub-module, a warehouse exit management sub-module, an early warning management sub-module and a warehouse exit management sub-module. The inventory management sub-module is used for inventory management of the inventory spare parts, the early warning management sub-module is used for early warning on the on-machine use period of the inventory spare parts, the approval management sub-module is in data butt joint with WeChat of a third-party software enterprise, and the ex-warehouse management sub-module is used for ex-warehouse management of the workshop inventory spare parts. The invention comprehensively controls the receiving process of spare parts and realizes standardized, normalized and electronic operation flow.
Description
Technical Field
The invention belongs to the technical field of production management of manufacturing enterprises, and particularly relates to a spare part management system and method.
Background
For manufacturing enterprises, spare parts are basic units for organizing manufacturing equipment, management of the spare parts is enhanced, and especially large spare parts which are high in value and play a vital role in equipment operation are facilitated, so that the enterprises can improve efficiency and equipment utilization rate, and the purposes of reducing production cost and improving benefit are achieved.
At present, the spare part management systems of most enterprises concentrate on the management aspects of spare part purchasing, warehousing, ex-warehouse, inventory and the like, and the picking process of the spare part still adopts an off-line operation mode, so that the spare part management systems cannot be in butt joint with spare part ex-warehouse business. And filling out the spare part information of the leading spare part by adopting paper documents off line, and finding out the corresponding leading step by step for approval.
The existing spare part management system cannot meet the production and operation requirements of enterprises. The main technical problems are as follows: 1. the spare parts are various in types and complex in types, the problem that the names of the spare parts under the line and the system names are not uniform is solved, spare parts are easy to get wrong, workshop replacement is delayed, maintenance time is prolonged, and workshop efficiency is reduced. 2. The spare parts are more in types, the approval process is complicated, the off-line approval is difficult to execute according to the process, and the problem that work is delayed because approval personnel cannot be found or the approval process is not executed in place is often caused. 3. The spare part users and the management staff do not realize information sharing, cannot grasp comprehensive information, and are easy to miss in decision making. 4. The traditional spare part operation system documents all need manual maintenance, spare parts are frequently used, the maintenance workload is large, and the manual operation is easy to be wrong. 5. The data analysis report forms needed in the production and management processes are quite large in workload due to the fact that manual account registration is needed, information feedback is not timely, inventory information cannot be mastered timely, spare parts are repeatedly purchased, enterprise cost is greatly increased, and enterprise benefit is affected.
Disclosure of Invention
The invention provides a spare part management system and method aiming at the actual problems existing in spare part management in manufacturing enterprises. The technical scheme adopted by the invention is as follows:
the spare part management system comprises a server and mobile equipment in wireless connection communication with the server, wherein a basic information management module, a spare part management module, a query statistics management module and a system management module are installed and operated in the server, and the spare part management module comprises: the system comprises a warehouse management sub-module, an approval management sub-module, a warehouse-out management sub-module, an early warning management sub-module and a warehouse-out management sub-module.
Preferably, the basic information management module includes: the system comprises a spare part archive management sub-module, a warehouse archive management sub-module, an in-warehouse and out-warehouse category management sub-module, a supplier management sub-module and a self-defined archive management sub-module, wherein the inquiry statistics management module comprises: the system comprises a receiving and inventory management module, a receiving and inventory management module and a system management module, wherein the receiving and inventory management module comprises a receiving and inventory management module and a receiving and inventory management module, and the receiving and inventory management module comprises a receiving and inventory management module and an inventory management module, and the receiving and inventory management module comprises a receiving and inventory management module, and a receiving and inventory management module comprises a receiving and inventory management module and a management module management of the receiving and inventory management module management: the system comprises a user management sub-module, a role management sub-module, a password management sub-module, a parameter setting sub-module and an approval process sub-module.
The spare part management method, which is applied to the spare part management system, comprises the following steps:
the warehouse management submodule is used for carrying out warehouse management on spare parts, linking with purchasing business, realizing information transmission and sharing, enabling a material department to store a handheld PDA to scan a manifest number, downloading the manifest number, scanning a two-dimensional code of the spare parts, acquiring spare part information and cargo position information, and automatically generating a spare part purchasing warehouse entry after confirming the warehouse entry number;
the early warning management submodule is used for early warning the service cycle of the standby spare parts, automatically carrying out early warning prompt after the early warning cycle is reached, carrying out prompt notification in an enterprise WeChat on mobile equipment in a message mode, and checking and implementing the operation condition of the standby spare parts on site after relevant users see the message;
the approval management sub-module is in data butt joint with a third party software enterprise WeChat on the mobile device, if relevant personnel arrive at the site to confirm that the spare parts are indeed required to be replaced, a replacement button is clicked to automatically generate a spare part leading approval list, the stock quantity is automatically checked after the spare part leading approval list is submitted, a prompt dialog box is automatically popped up by a system to prompt that the available quantity is insufficient when the approval quantity is greater than the stock quantity, a user modifies the approval quantity, clicks and submits again after confirming the approval, an approval process is determined according to departments and spare part categories, the approval process is entered according to pre-preset approval steps, and after all the approval processes are finished, a spare part delivery application list is automatically generated and is transmitted to a material department as the basis of leading spare parts;
the warehouse-out management submodule is used for warehouse-out management of the spare parts of the workshop, a PDA (personal digital assistant) is held by a workshop staff to open a warehouse-out application form, the spare part information and the leading number are obtained, meanwhile, the spare part position information is automatically obtained, the workshop staff follows the storage to the corresponding position to lead the spare parts, the handheld PDA is used for scanning the two-dimensional code of the spare parts to submit the leading spare part information and the leading number, after the data are scanned and submitted, the inventory spare part warehouse-out form is automatically generated, the signature is transmitted to the financial module after confirmation, and the spare part warehouse-out form is automatically generated;
the warehouse-returning management submodule is used for warehouse-returning management of spare parts of workshops, the warehouse-returning execution application, approval and warehouse-returning, a warehouse-returning warehouse entry list of the spare parts is automatically generated, and the spare parts are stored in corresponding positions according to goods space information.
Preferably, the spare part receiving approval sheet automatically brings in receiving departments, using positions and spare part information, the receiving approval sheet is associated with inventory information, the stock quantity and unit price of the spare parts are automatically brought out, the total amount is automatically calculated, the planned using period of the spare parts is automatically brought out according to the spare part codes, the last receiving date is automatically extracted according to the departments and the using positions, the actual using period is automatically calculated, and a basis is provided for user decision.
Preferably, the basic information management module makes a spare part coding rule, the codes are different when the specifications and the models of the spare parts are different, the basic information of the spare parts is maintained according to the spare part coding rule, and the specific two-dimensional code of the spare parts is automatically generated.
Preferably, the receiving detail inquiring submodule is used for generating a receiving detail inquiring table of spare parts, and setting an application date, a workshop department, a spare part code and a spare part name as inquiring conditions; the warehouse-in and warehouse-out detail query submodule is used for manufacturing a warehouse-in detail query table and querying the warehouse-in and warehouse-out conditions of spare parts according to time periods, warehouses, departments and spare part codes; the inventory inquiry submodule is used for manufacturing a spare part replacement date inquiry table, inquiring the time of each time of the spare part and the current inventory quantity according to workshops and using positions; the abnormal receiving inquiry submodule is used for manufacturing an abnormal receiving inquiry table of spare parts and filtering out spare parts which do not reach the service cycle; and the receiving and transmitting summarizing sub-module is used for manufacturing a receiving and transmitting inquiring table of spare parts and inquiring and warehousing, delivering and storing conditions of the spare parts according to dates, warehouses and spare parts.
Preferably, the approval process submodule determines an approval process according to the importance degree and the value of departments, categories and spare parts, and performs approval step by step according to the process.
Preferably, whether the category is a general spare part is judged firstly, then a workshop is judged, which workshop work section length and workshop owner approval are determined, if the category is not the general spare part, then whether a large-sized spare part is judged, if the category is the large-sized spare part, then the workshop is judged, and the workshop work section length, the workshop owner approval and the production auxiliary total approval flow are determined.
The invention has the beneficial effects that:
the invention comprehensively manages and controls the receiving process of spare parts, develops a set of management system for spare parts from warehouse entry, receiving and delivering, realizes the functions of bar code management, mobile terminal office, receiving and approval, service cycle management and the like of the spare parts by developing the system, and realizes the standardized, normalized and electronic operation flow of the spare parts, and all-round management links of warehouse entry, receiving and delivering of the spare parts. The system is in communication connection with third-party software, and the approval flow realizes that a computer end and a mobile phone end can be operated simultaneously, so that paperless and mobile office is realized. The method has the specific beneficial effects that:
1. the receiving process of spare parts and the in-out warehouse of the spare parts are combined, and the spare parts and the in-out warehouse of the spare parts are brought into the same system for management and control, so that the rapid transmission and sharing of data information are realized. 2. The spare part receiving process is transferred from offline to online, and can be operated through the mobile phone end, so that the data multi-running and less leg running of people are realized, and the working efficiency is effectively improved. 3. The service cycle of the large spare parts is brought into the system for on-line management and control, so that a large amount of manpower and material resources can be reduced, and the optimal service cycle of the spare parts can be accurately mastered. 4. The early warning of spare parts using period and stock is realized, a basis is provided for equipment maintenance and spare parts replacement, fault shutdown caused by the spare parts can be effectively reduced, the life cycle of the equipment is improved to a greater extent, and the purchasing cost of the spare parts is reduced. 5. By adopting a bar code scanning technology, the data input of spare parts is realized by scanning a two-dimensional code through the handheld terminal, the work of manually inputting and filling in the bill is omitted, and the working efficiency of spare part management and the accuracy of the bill are improved. 6. And a scientific decision basis is provided for an enterprise decision maker by automatically generating a statistical report of various spare parts. 7. And a scientific tracking management system of all-round, integrated and whole-course spare part equipment is established, so that reasonable allocation of spare part resources is effectively realized.
Drawings
FIG. 1 is a schematic diagram of a spare parts management system according to an embodiment of the present invention;
FIG. 2 is a flow chart of a warehouse entry management sub-module of an embodiment of the present invention;
FIG. 3 is a flow chart of an approval management sub-module of an embodiment of the present invention;
FIG. 4 is an exemplary diagram of spare part warning cycle information according to an embodiment of the present invention;
FIG. 5 is an exemplary diagram of a spare part lead approval of an embodiment of the present invention;
FIG. 6 is an exemplary diagram of a spare part availability shortage cue message in accordance with an embodiment of the present invention;
FIG. 7 is a flow chart of a warehouse-out management sub-module of an embodiment of the present invention;
FIG. 8 is a flow chart of an approval process sub-module of an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made apparent and complete in conjunction with the accompanying drawings, in which it is evident that the embodiments described are some, but not all embodiments of the present invention.
The invention provides a spare part management system, which mainly comprises four modules:
1. basic information management module: the system comprises five sub-modules, namely spare part file management, warehouse entry and exit category management, supplier management and custom file management.
The basic information management module is used for maintaining basic files such as spare parts, warehouse and the like, including spare parts files, warehouse files, supplier files, in-out type and custom files. Through the custom file sub-module, the enterprise can establish a required new spare part file according to application requirements.
1.1, a spare part file management sub-module.
The method is used for maintaining basic information of spare parts, and can directly select spare part codes and bring out relevant information of the spare parts when maintaining documents.
1.1.1, formulating spare part coding rules according to the needs, wherein the codes correspond to spare parts, and the codes are different when the specifications and the models of the spare parts are different, for example: the coding rule is spare part production place (length 2 bits, which is divided into 01 domestic, 02 import and 03 random parts) +spare part category (length 2 bits, spare part is divided according to category) +4 bits serial number.
1.1.2, after the spare part coding rule is determined, the coding is required to be maintained according to the coding rule when the spare part in the spare part basic information is maintained, and the information such as the spare part name, specification, model, metering unit, supplier and the like is also required to be maintained, so that the system automatically generates a specific two-dimensional code of the spare part, and the later business operation is facilitated.
1.1.3, the service cycle and the early warning cycle of spare parts can be respectively maintained according to different departments and service parts of workshops in the spare part files; the service period and the early warning period can be maintained according to the guarantee period provided by the provider or according to the historical service period condition, and the early warning period is smaller than the normal service period under normal conditions and is used for prompting maintenance or replacement of spare parts. Such as:
| encoding | Name of the name | Specification of specification | Usage department | Use part | Scheduled use period | Early warning cycle |
| 01010343 | Pump cover | H2313 | A workshop | Charging machine | 90 days | 85 days |
| 01010356 | Pump shaft | C950-3 | A workshop | Grinding machine | 100 days | For 95 days |
| 01005340 | Pump assembly | 10SH-9 | Two workshops | Grinding machine | For 110 days | 105 days |
And 1.2, a warehouse archive management sub-module.
The system is used for maintaining information of a warehouse for maintaining spare parts, including warehouse codes, warehouse names, places, organizations to which the spare parts belong, and the like, can manage goods positions of the warehouse, and can name the goods positions according to areas for later business operation, so that the working efficiency is improved.
And 1.3, a warehouse-in and warehouse-out type management sub-module.
The system is used for setting the types of the access warehouse according to the backup purposes of the spare parts and the like, and unifies the types of the access warehouse with the types of the financial modules.
1.4, a vendor management sub-module.
For the maintenance of basic information of spare parts manufacturers, agents and other intermediaries, including vendor codes, vendor names, vendor categories, addresses, categories, etc.
And 1.5, a custom file management sub-module.
Corresponding spare part files can be set in a self-defined mode according to application requirements.
2. Spare parts management module: comprising the following steps: five sub-modules are adopted in warehouse-in management, approval management, warehouse-out management, early warning management and warehouse-out management, and new sub-modules can be added according to new application requirements; the module is a core module of the management system of the invention.
And 2.1, warehousing management sub-modules.
The warehouse management submodule is used for warehouse service management of spare parts and can be connected with purchasing service to realize information transmission and sharing.
The purchasing department maintains a spare part purchasing order and a production purchasing goods list in the system, the quality inspection department checks the goods list, the goods and materials department stores a handheld PDA and scans the goods list number after the goods and materials department checks the goods and materials are qualified, downloads the goods and materials list details, scans the two-dimensional code of the spare part, acquires the spare part information and the goods position information, submits data after confirming the warehousing quantity, uploads the data into the system, and automatically generates the spare part purchasing and warehousing list.
2.2, an early warning management sub-module.
The early warning management submodule is used for early warning the service cycle of the spare parts.
Referring to fig. 4, according to the number of guarantee days or historical use days provided by the spare part provider, the planned use period and the early warning period of the spare part are maintained in the spare part file, after the early warning period is reached, the system automatically carries out early warning prompt, and prompt notification is carried out in a message mode in enterprise WeChat.
After the user of the workshop maintainer role sees the message, the user can go to the site to check and realize the running condition of spare parts.
And 2.3, an approval management sub-module.
Referring to fig. 3, when the spare parts are used, approval is performed through an approval management sub-module, and the approval management sub-module can be in data butt joint with a third-party software enterprise WeChat, can operate in a management system and can also operate at a mobile phone end.
2.3.1, referring to fig. 4, the "shop maintainer" confirms the operation condition of spare parts on site, if the operation condition is good, the spare parts can be used continuously, if the spare parts do need to be replaced, the "replacement" button can be clicked, and a receiving approval ticket can be automatically generated.
2.3.2, referring to figure 5, the receiving approval ticket automatically brings the receiving department, the using position and spare part information, and the receiving approval ticket is associated with the inventory information, so that the stock quantity and unit price of the spare part can be automatically brought out, the total amount is automatically calculated, the planned using period of the spare part can be automatically brought out according to the spare part codes, the last receiving date is automatically extracted according to the department and the using position, the actual using period is automatically calculated, and a basis is provided for user decision. In addition, the method can also self-control a lead approval bill at a computer end or a mobile phone end aiming at spare parts which are not subjected to periodic management.
2.3.3, referring to figure 6, after the user confirms the content of the examination and approval list, submitting, at the moment, checking the stock quantity by the system, when the examination and approval quantity is larger than the stock quantity, automatically popping up a prompt dialog box by the system to prompt that the available quantity is insufficient, modifying the examination and approval quantity by the user, clicking and submitting again after confirming the approval quantity, determining the examination and approval process according to departments and spare parts types, and entering the examination and approval process according to the examination and approval steps preset in advance.
And 2.3.4, the mobile approval also carries out step-by-step notification prompt on the role users in the approval stream in a message mode, and the users click on the message and can enter a receiving approval ticket to carry out auditing on the content. The user can agree, return, learn, delegate, etc. to the review batch. Checking that no problem clicks to agree to carry out next examination and approval; the audit problem can be clicked back to the last step of modification; the person or role related to the delegation can also be informed to process.
And 2.3.5, after the approval process is completed, automatically generating a spare part warehouse-out application form, and transmitting the application form to a material department as a basis for receiving spare parts.
And 2.4, a warehouse-out management sub-module.
Referring to fig. 7, the ex-warehouse management submodule is used for ex-warehouse business management of the spare parts of the workshops.
2.4.1, after the delivery application form is transferred to the material department, the handheld PDA opens the delivery application form to acquire spare part information and the receiving quantity, and simultaneously, the information of the spare part goods position is automatically acquired, so that the time for manually realizing the spare part goods position can be reduced, and the working efficiency is effectively improved.
2.4.2, taking spare parts by workshop personnel after the spare parts are stored in corresponding goods places;
2.4.3, the handheld PDA is kept to scan the two-dimension code of spare parts to submit the information and the quantity of the spare parts for leading, and the quantity of the spare parts for leaving the warehouse is basically required to be not allowed to be larger than the quantity of the application for leaving the warehouse.
And 2.4.4, automatically generating a stock spare part delivery list after scanning the submitted data.
And 2.4.5, after signature confirmation, transmitting the signature confirmation to a financial module, and automatically generating a spare part warehouse-out bill.
2.5, database-leaving management sub-module
The warehouse-out management submodule is used for warehouse-out service management of the workshop spare parts.
In the use and maintenance process of spare parts, it is inevitable that part of spare parts need to be returned to a warehouse for overhaul or replacement. The library returning also needs to execute three steps of application, approval and library returning.
2.5.1, filling out the warehouse-returning approval list by workshop maintainers through a mobile phone end or a computer end. The use department, the use part and the spare part code (the spare part information is automatically brought out) on maintenance and the reason of warehouse withdrawal.
And 2.5.2, entering an approval process after the user submits the approval process, and approving the approval process according to a preset approval process.
And 2.5.3, after the approval process is completed, automatically generating a spare part warehouse-out application form and transmitting the application form to a material department.
And 2.5.4, keeping and checking whether the spare parts meet the warehouse-out condition by a material department, opening a warehouse-out application form by a handheld PDA, scanning a two-dimension code of the spare parts after confirming the warehouse-out information, acquiring the spare part information and the goods position information, submitting data, uploading the data into a system, and automatically generating the warehouse-out warehouse-in list of the spare parts.
2.5.5, storing spare parts according to the goods position information in corresponding positions.
3. Query statistics management module: five sub-modules, namely, a receiving and dispatching detail query, an entering and exiting detail query, an abnormal receiving and dispatching inventory query and a receiving and dispatching inventory summary; new sub-modules may also be added according to new requirements of the application. The inquiry statistics management module is an important component of the management system, and performs statistics, arrangement, summarization and analysis on various data in the system, so that a user is helped to know information such as warehouse-in, leading-in and warehouse-out conditions of spare parts, various inquiry reports are manufactured according to the needs, a part of inquiry reports are preset in the system, and enterprises can manufacture reports according to the needs, so that powerful support is provided for user decision making.
And 3.1, a receiving detail inquiring submodule which is used for generating a receiving detail inquiring table of spare parts, setting inquiring conditions such as an application date, a workshop department, a spare part code, a spare part name and the like, inquiring receiving conditions of a certain time period, a certain workshop and a certain material according to requirements, and also can be used for receiving cost statistics.
And 3.2, an in-out warehouse detail query sub-module which is used for manufacturing an in-out warehouse detail query table and can query in-out warehouse conditions of spare parts according to time periods, warehouse, departments, spare part codes and the like.
Entry and exit inventory graphic
And 3.3, an inventory inquiry sub-module which is used for manufacturing a spare part replacement date inquiry table and inquiring the time of each time of the spare part and the current inventory quantity according to workshops and using parts.
And 3.4, an abnormal lead query sub-module is used for manufacturing an abnormal lead query table of spare parts, filtering out spare parts which do not reach the service cycle, facilitating the follow-up implementation, and referring to a spare part lead detail query table format.
And 3.5, a receiving and transmitting and storing summarizing sub-module which is used for manufacturing a receiving and transmitting and storing query table of spare parts and spare parts, and can query the conditions of warehouse entry, warehouse exit and inventory according to dates, warehouses, spare parts and the like.
4. And a system management module: comprising the following steps: the user management, role management, password management, parameter setting and approval processes are divided into five sub-modules.
And 4.1, a user management sub-module.
For user registration authentication. The user fills in name, sex, mobile phone number, certificate number, mailbox, etc. and the management system verifies the certificate information to ensure its validity and authenticity, and generates user file after verification.
And 4.2, a role management sub-module.
And a role file is established in the system according to specific post settings, and the authenticated user is endowed with a corresponding role, so that authority allocation and responsibility division are facilitated.
4.3, a password management submodule.
The password rules are set according to the requirements, including password length, composition and the like, and the user must follow the set password rules to set the password when registering. The system encrypts and stores the password of the user, so that the password cannot be revealed. After the password is lost, the user can reset the password by receiving the verification code through the mobile phone.
And 4.4, a parameter setting sub-module.
The method is used for setting parameters preset by the management system so as to meet the personalized requirements of enterprises and ensure the stable operation of the system. Such as: the available insufficient inspection parameter setting comprises non-inspection, inspection and prompting, and the selection setting is carried out according to the requirement.
And 4.5, an approval process sub-module.
And determining a good approval process according to departments, categories, importance degrees, values and the like of spare parts, setting the good approval process, and carrying out approval step by step according to the process.
As shown in fig. 8, the class is firstly judged to be a general spare part, then the workshop is judged, which workshop work section length and workshop main authority are determined to be approved, if not the general spare part, then whether the large spare part is judged, if yes, the workshop is judged again, and the workshop work section length, the workshop main authority and the production auxiliary main authority are determined, so that the specific approval process can be determined by confirming the spare part class and department item by item until the last class and workshop. Through the approval management sub-module, the reasonable acceptance of spare parts can be effectively controlled.
The management system can establish a communication interface with the third party system enterprise WeChat, so that mobile phone terminal bill making and approval for spare parts are realized, and information transmission and data sharing among systems are realized. In addition, the management system performs data pushing and receiving in an interface mode, so that seamless connection with ERP system data is realized, and synchronization and sharing of information are realized.
In the embodiments of the present invention, technical features that are not described in detail are all existing technologies or conventional technical means, and are not described herein.
Finally, it should be noted that: the above examples are only specific embodiments of the present invention, and are not intended to limit the scope of the present invention. Those skilled in the art will appreciate that: any person skilled in the art may modify or easily conceive of changes to the technical solutions described in the foregoing embodiments or make equivalent substitutions for some of the technical features within the technical scope of the present disclosure; such modifications, changes or substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention, and are intended to be included in the scope of the present invention.
Claims (8)
1. The spare part management system is characterized by comprising a server and mobile equipment in wireless connection communication with the server, wherein a basic information management module, a spare part management module, a query statistics management module and a system management module are installed and operated in the server, and the spare part management module comprises: the system comprises a warehouse management sub-module, an approval management sub-module, a warehouse-out management sub-module, an early warning management sub-module and a warehouse-out management sub-module.
2. The spare parts management system according to claim 1, wherein the basic information management module comprises: the system comprises a spare part archive management sub-module, a warehouse archive management sub-module, an in-warehouse and out-warehouse category management sub-module, a supplier management sub-module and a self-defined archive management sub-module, wherein the inquiry statistics management module comprises: the system comprises a receiving and inventory management module, a receiving and inventory management module and a system management module, wherein the receiving and inventory management module comprises a receiving and inventory management module and a receiving and inventory management module, and the receiving and inventory management module comprises a receiving and inventory management module and an inventory management module, and the receiving and inventory management module comprises a receiving and inventory management module, and a receiving and inventory management module comprises a receiving and inventory management module and a management module management of the receiving and inventory management module management: the system comprises a user management sub-module, a role management sub-module, a password management sub-module, a parameter setting sub-module and an approval process sub-module.
3. The spare parts management method, characterized in that the spare parts management system according to claim 2 is applied, comprising the following steps:
the warehouse management submodule is used for carrying out warehouse management on spare parts, linking with purchasing business, realizing information transmission and sharing, enabling a material department to store a handheld PDA to scan a manifest number, downloading the manifest number, scanning a two-dimensional code of the spare parts, acquiring spare part information and cargo position information, and automatically generating a spare part purchasing warehouse entry after confirming the warehouse entry number;
the early warning management submodule is used for early warning the service cycle of the standby spare parts, automatically carrying out early warning prompt after the early warning cycle is reached, carrying out prompt notification in an enterprise WeChat on mobile equipment in a message mode, and checking and implementing the operation condition of the standby spare parts on site after relevant users see the message;
the approval management sub-module is in data butt joint with a third party software enterprise WeChat on the mobile device, if relevant personnel arrive at the site to confirm that the spare parts are indeed required to be replaced, a replacement button is clicked to automatically generate a spare part leading approval list, the stock quantity is automatically checked after the spare part leading approval list is submitted, a prompt dialog box is automatically popped up by a system to prompt that the available quantity is insufficient when the approval quantity is greater than the stock quantity, a user modifies the approval quantity, clicks and submits again after confirming the approval, an approval process is determined according to departments and spare part categories, the approval process is entered according to pre-preset approval steps, and after all the approval processes are finished, a spare part delivery application list is automatically generated and is transmitted to a material department as the basis of leading spare parts;
the warehouse-out management submodule is used for warehouse-out management of the spare parts of the workshop, a PDA (personal digital assistant) is held by a workshop staff to open a warehouse-out application form, the spare part information and the leading number are obtained, meanwhile, the spare part position information is automatically obtained, the workshop staff follows the storage to the corresponding position to lead the spare parts, the handheld PDA is used for scanning the two-dimensional code of the spare parts to submit the leading spare part information and the leading number, after the data are scanned and submitted, the inventory spare part warehouse-out form is automatically generated, the signature is transmitted to the financial module after confirmation, and the spare part warehouse-out form is automatically generated;
the warehouse-returning management submodule is used for warehouse-returning management of spare parts of workshops, the warehouse-returning execution application, approval and warehouse-returning, a warehouse-returning warehouse entry list of the spare parts is automatically generated, and the spare parts are stored in corresponding positions according to goods space information.
4. The spare parts management method according to claim 2, wherein the spare parts acceptance and approval order automatically brings up the acceptance department, the use part and spare parts information, the acceptance and approval order is associated with the stock information, the stock quantity and unit price of the spare parts are automatically brought up, the total amount is automatically calculated, the planned use period of the spare parts is automatically brought up according to the spare parts codes, the last acceptance date is automatically extracted according to the department and the use part, and the actual use period is automatically calculated.
5. The spare part management method according to claim 2, wherein the basic information management module makes a spare part coding rule, the codes are different when the specifications and the models of the spare parts are different, the basic information of the spare parts is maintained according to the spare part coding rule, and a two-dimensional code specific to the spare part is automatically generated.
6. The spare parts management method according to claim 2, wherein the receiving detail query submodule is configured to generate a spare parts receiving detail query table, and set an application date, a workshop department, a spare parts code and a spare parts name as query conditions; the warehouse-in and warehouse-out detail query submodule is used for manufacturing a warehouse-in detail query table and querying the warehouse-in and warehouse-out conditions of spare parts according to time periods, warehouses, departments and spare part codes; the inventory inquiry submodule is used for manufacturing a spare part replacement date inquiry table, inquiring the time of each time of the spare part and the current inventory quantity according to workshops and using positions; the abnormal receiving inquiry submodule is used for manufacturing an abnormal receiving inquiry table of spare parts and filtering out spare parts which do not reach the service cycle; and the receiving and transmitting summarizing sub-module is used for manufacturing a receiving and transmitting inquiring table of spare parts and inquiring and warehousing, delivering and storing conditions of the spare parts according to dates, warehouses and spare parts.
7. The spare parts management method according to claim 2, wherein the approval process submodule determines an approval process according to the importance degree and the value of departments, categories and spare parts, and performs approval step by step according to the process.
8. The spare parts management method according to claim 6, wherein whether the class is general spare parts is judged, then the workshop is judged, which workshop work section length and workshop main approval are determined, if the class is not general spare parts, then whether large spare parts are judged, if the class is large spare parts, then the workshop is judged, and the workshop work section length, workshop main approval and production auxiliary total approval flow are determined.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311450372.XA CN117391587A (en) | 2023-11-03 | 2023-11-03 | Spare part management system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311450372.XA CN117391587A (en) | 2023-11-03 | 2023-11-03 | Spare part management system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117391587A true CN117391587A (en) | 2024-01-12 |
Family
ID=89471776
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311450372.XA Pending CN117391587A (en) | 2023-11-03 | 2023-11-03 | Spare part management system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117391587A (en) |
-
2023
- 2023-11-03 CN CN202311450372.XA patent/CN117391587A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107831750B (en) | IMES intelligent manufacturing execution system | |
| CN110009172B (en) | Asset full life cycle data modeling method based on SG-CIM model | |
| CN110580572B (en) | Product life-span traceability system | |
| CN110334950B (en) | Iron tower intelligent production and group management and control system | |
| WO2007016567A2 (en) | Outsourced service level agreement provisioning management system and method | |
| CN101256647A (en) | Item management system being suitable for garden engineering | |
| US8408459B1 (en) | 4PL system and method | |
| CN108898200A (en) | The singulated system of intelligence, manufacturing schedule management system and its implementation, operating method | |
| CN104636961A (en) | Mobile interconnected invoicing system and invoicing method | |
| CN111462886A (en) | Full life cycle real-time online management system for medical equipment | |
| CN109978497A (en) | A kind of business administration office platform system based on cloud ERP management | |
| CN111353787A (en) | Equipment comprehensive guarantee system based on cloud platform | |
| CN112766849A (en) | Method and system for managing digital tags of full life cycles of associated storage materials | |
| US10176446B2 (en) | System and method for inventory management, cost savings delivery and decision making | |
| CN117391587A (en) | Spare part management system and method | |
| CN117057686A (en) | Intelligent management method, device, equipment and storage medium for material purchase | |
| CN116384883A (en) | Production operation management system of electric energy metering equipment | |
| CN1510600A (en) | Purchasing administration system and method | |
| CN101128814A (en) | Serialized inventory control system and method | |
| CN113592611A (en) | Integrated management system for centralized acquisition and supervision of garbage incineration enterprises | |
| CN116823189B (en) | Supply chain data processing method and device based on robot process automation RPA | |
| WO2006106587A1 (en) | Procurement preparation system and procurement preparation method | |
| CN113141396B (en) | Supply chain cooperative system based on multiple networks | |
| KR100487079B1 (en) | Resources civil official system and the method which use the internet web | |
| CN116882700A (en) | Equipment management system suitable for mill |
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 |