Linggui adhesive tape industry ERP solution

Linggui adhesive tape industry ERP solution

The ERP system of Linggui adhesive tape industry is based on its own intellectual property ERP product (Linggui ERP System Software www.lgerp.cn) and draws on the management and implementation experience of a number of super large Taiwan-funded manufacturing enterprises, after the implementation of the well-known adhesive tape factory in the local area, we will extract and integrate various management systems to develop and design ERP systems for the adhesive tape industry.

I. Requirement Analysis

Compared with super-large Taiwan-funded manufacturing enterprises, the encoding diversity of products in the adhesive tape industry is not complex for lingui ERP. However, many characteristics of local enterprises determine the distinctive characteristics of their informatization needs, such as flexible management systems and short order delivery periods. The ERP requirements of adhesive tape industry are as follows:

1. Order Management

A basic requirement of modern enterprise management is order-based production. In the Linggui ERP system, order information is the main soul of the entire system and runs through the whole process from production arrangement to shipment collection, all stock preparation, scheduling, semi-finished products, finished products, inventory and shipment are conducted on the basis of orders. Therefore, whether order data is entered quickly and accurately, whether order data is fully searched, whether order sensitive data can be controlled based on permission, and whether order progress tracking is simple and clear are the key points.

2. Plan Management

Plan management is the most important, complex, and headache in the manufacturing industry. Therefore, many enterprises are in disorder. It requires the scheduler personnel to know whether all persons, machines, and materials are in place, and to know the plan implementation, equipment running status, and order delivery priority in a timely manner. The Planning Management Subsystem urgently needs to share information, learn the production plan progress of the workshop in a timely manner, and coordinate abnormal incidents, timely understanding of inventory, materials in place plan, task completion and quality inspection, providing data for the production statistics and query functions, and facilitating the scheduler to supervise the actual production conditions.

3. Production Management

First-line workshop production personnel are directly produced according to the production orders. Therefore, the production orders are required to have complete and clear information, and the materials receiving data must be accurate, after the production task is completed, data should be input into the system in a timely manner, and the data collected from the workshop should be provided in a timely manner, such as the output, consumption, and equipment running status.

4. Procurement Management

Procurement Management personnel cannot fully understand enterprise procurement requirements in a timely manner, including production requirements and stock-up requirements, resulting in delayed replenishment of the database. In addition, procurement management personnel cannot track the implementation of procurement orders in a timely manner, resulting in delayed arrival and quality problems. This directly affects the production and procurement subsystem to implement complete procurement process control, form material requirements → material in place plan → purchase order → Arrival notice → data stream of warehouse receiving order, so that the purchasing department can monitor the material procurement execution status in a timely manner; at the same time, the Procurement Order is dynamically tracked to quickly and easily obtain various situations of arrival within a certain period of time. The buyer can handle the situation, such as reminding the supplier of the other party; in addition, the procurement personnel can query the payment status of the materials to be delivered, the supplier's arrears of invoices, and the expiration payment information at any time, so as to facilitate financial preparation and timely payment.

5. Sales Management

The sales department urgently needs to have a timely understanding of the Order progress, order production quality, and related inventory, real-time Monitoring of the order production progress, product inventory, delivery, receivables, etc., to generate various types of sales reports in real time; the characteristics of local enterprises also require that the Order, review, and other links be skipped, inventory is directly sold. Some customers depend on other organizations and need to provide different operation capabilities for actual customers and invoicing customers. In addition, strengthen the Management of customer information, customer contact records, customer credit, and customer service, effectively explore potential customers, improve service quality, effectively control and urge customers to withdraw payments in a timely manner.

6. Inventory Management

The warehouse contains raw materials, semi-finished products, finished products, spare parts, low-value consumable products, etc. There are a wide variety of materials and a large quantity. In addition, most of them are prone to delayed delivery and disorderly delivery, therefore, the inventory management subsystem is expected to efficiently manage the types, quantities, and amounts of raw materials in the warehouse. Relevant departments can query relevant data in real time to achieve data integration, for example, the sales department or procurement department can query the current inventory in real time. In addition, it provides a certain warning function for the inventory, and monitors and generates alarms for the inventory and retention period of the warehouse materials.

7. device management

Because the Engineering Department and the Quality Control Department cannot understand the equipment operation, equipment maintenance plan, and inventory of spare parts in the warehouse in a timely manner, it is expected that the equipment management subsystem can integrate all equipment services into an organic whole, focus on how to manage devices, and help device management personnel dynamically track, manage, and analyze the entire process of device management activities.

8. Quality Management

It is hoped that quality control records can be managed through the quality management subsystem. Other departments can quickly query quality inspection information, analyze inspection records, and form quality reports and charts, help the Quality Management Department conduct quality analysis.

Ii. Core Ideas

The ERP system of Linggui adhesive tape industry takes product sales management as the core and relies on production management to effectively implement sales management and timely control of market information through the combination of marketing management and customer management; through inventory management and optimization of production scheduling, reasonable control of enterprise logistics, effective integration of supply, production, and sales business and financial information; the invoicing system improves the accuracy of prediction and reduces inventory, improve Delivery and supply capabilities, reduce workflow cycles, increase productivity, reduce supply chain costs, reduce overall procurement costs, shorten production cycles, and speed up market response.

Iii. Overall Structure

Overall System Structure

The system consists of the system framework, basic data management, subsystems, and plug-in modules. subsystems can be divided into management systems, personnel systems, procurement systems, materials systems, and customs systems based on the actual needs of enterprises, the plug-in module refers to other modules developed by enterprises by using the development interfaces provided by the system. The production management system is divided into order management, production management, plan management, inventory management, marketing management, customer management and accounting management.

The system uses the Client/Server (C/S) architecture, and uses network interconnection devices and communication facilities to connect to the computer hardware resources of enterprises.

We recommend that you use Windows as the network operating system and windows as the operating system for each site.

On the basis of physical integration, a unified enterprise-wide database is established, and sqlserver2000 is used as the system database system.

Iv. Features of main function modules

The ERP system of Linggui adhesive tape industry is an information management system developed based on the management experience of super large Taiwan-funded enterprises and the actual production and operation conditions of the local adhesive tape industry. The main process is as follows:

1. Order Management Module

In addition to providing accurate and quick order entry functions, the system can also automatically check the customer's credit status to avoid the company's operational risks. The system will automatically check the unit price and prohibit low-price sales; automatically refer to the most similar order data to minimize the occurrence of manual input errors. As the main information throughout the entire process of ordering, planning, production, inventory and shipment, in addition to providing various search and query conditions for easy query, it can also avoid unauthorized staff to see the company's sensitive information. After an order is entered, its progress details are displayed on the order progress page. After shipment is completed, the order can be automatically closed to minimize manual operations. In addition, after the order entry review is passed, the system can automatically match the appropriate sluggish inventory in the inventory to reduce the inventory.

2. Manufacturing Management Module

The production plan in this module is mainly divided into the production load and production order, including finished products, semi-finished products, raw materials and supplementary materials. After the order is reviewed, the system can automatically calculate the demand for its semi-finished products, paper cores and cartons, and compare it with the stock of raw materials in stock, to calculate the load of each part that requires production or procurement. In actual production, due to the stock of raw materials, the specification of the raw materials to be allocated may not be necessarily the same as that automatically calculated by the system, the raw materials to be allocated may be allocated to other orders for production due to temporary production scheduling. Therefore, how to manage the plan accurately and flexibly remains a major challenge. Fortunately, we have developed an effective plan management module based on our research and practice. The data of the production order is taken from the Order, which effectively solves the inconsistency between the customer order and the production order. There are also unified production time, equipment running status and quality inspection columns on the instruction sheet, which provides a standard and simple basis for workshop personnel to collect production data.

3. Inventory Management Module

This module provides functions such as warehouse receiving, warehouse picking, inventory check, inventory monthly settlement, and inventory query, timely and effective inventory information warning is achieved through batch management of inventory materials, space management, query and re-inspection of expired products, and safety stock management; in addition, it provides relevant interfaces with procurement, sales, workshops, and quality systems to implement flow management and control in all aspects of the enterprise's goods receiving, storage, and shipping processes. According to the actual requirements of enterprise management, detailed materials in and out comparison is provided to facilitate material tracking and document verification. The system also provides detailed input, consumption, and storage reports for various materials. before the system is implemented, it takes at least seven to eight days for the company to make a report from inventory check to delivery, it consumes a lot of manpower and material resources. After the system is implemented, the process is shortened to 2 to 3 days.

4. sales and customer management module

This module tracks and manages the entire sales process through quotation management, customer order, order review, shipment, customer return, sales invoice, and collection record registration; it effectively solves problems such as inconsistency between customers and invoicing customers, provides the customer's payment record query and account details at any time, and controls orders and sales based on the customer's credit conditions to reduce enterprise operation risks. By providing functions such as customer archival data management, customer classification management, customer visiting record management, and potential customer management, enterprises can improve customer satisfaction and loyalty, and ultimately improve their market competitiveness.

5. Procurement Management Subsystem

This sub-system purchases common materials through the procurement request-inquiry-price-bidding-procurement-receipt-inspection-payment and other complete procurement process and the procurement of common materials-procurement-receipt -- payment and other simple contract procurement processes, tracking and management of procurement business processes. By combining with the production planning module, procurement of raw materials for production is simplified. Through the establishment of a complete supplier file and supplier delivery capabilities, product quality, after-sales services and other content to realize supplier evaluation.

6. Account Management Module

This module provides regular collection input and other handwritten receipt form input, and can automatically write off the corresponding shipping documents, generate account details and detailed customer statements that can be traced to each shipment document item. Provides accounts receivable, account details, overdue receivables, period receivables, and aging analysis at any time. "Available at any time" indicates that you can query the account information of any day on any day, not only after the end of the month to complete the operation.

7. Customs Management Module

This module is combined with the order management module and the sales module. It provides application, management, and manual management for customs clearance, and manages the entire process from filing, customs clearance, reporting, and verification. The product name, specification, quantity, and amount are automatically extracted from the order and shipment form, and customs declaration documents are generated automatically, and Customs invoices are printed. This simplifies the customs declaration process and improves the accuracy of customs declaration data.

8. device management module

This module implements centralized and unified management of basic device information, equipment operation, equipment accidents and faults, equipment movement, and equipment maintenance plans, provide various query and statistical analysis reports to supervisors at all levels so that they can understand the various situations of relevant equipment at any time and take timely measures.

9. Quality Management Module

This module comprehensively manages the quality and quality information in the production process by providing quality inspection procedures, checkpoints, inspection items, and other functions. This module is combined with the equipment management module, multiple quality reports are generated through statistical analysis to analyze the supply quality of raw material suppliers and technical transformation and quality control of the production quality of the Organization, so as to improve the quality of enterprise products.