Analysis of Printing Enterprise Information Management System (I)

With the rapid development of computer network technology, more and more companies use information systems to improve their own management, and strive to remain invincible in the fierce market competition. As a traditional processing industry, the process of printing and processing is complicated and has many links. If you do not pay attention to it, you will miss out and cause great waste. Therefore, it is very important to use information systems for management.

Before the printing company establishes the information management system, the selection of the database is very important. It should combine specific functional requirements of the system and comprehensively consider various factors. The network version of FOXbase database has a powerful processing capacity and a high degree of flexibility to meet the needs of printing companies, is also a database commonly used by printing companies. This article mainly studies how printing companies build their own information management system based on the FOXbase database.

The composition of the database

Printing companies can establish a database of information management system users according to actual needs. The user database is mainly composed of the following sub-databases.

1. Business Management

Including order management, quote management, customer information management and customer service. Can achieve customer contact. Source contact. Arrange business plans, coordinate with dispatch centers, arrange printing. Summarize basic functions such as business completion, outsourcing plans, reminding of unpaid amounts exceeding a predetermined period, customer service management (customer feedback/complaints, etc.).

2. Production management

Including the dispatch center system, prepress, printing, postpress subsystem, and equipment management, it is the core of the printing enterprise.

3. Material Management

Including material inventory, material procurement, finished/semi-finished products, lead return, material count.

4. Financial Management

Conduct cost analysis, calculation and cost difference analysis management, business accounting, material accounting, cashier, audit management, salary, accounts, and fixed asset management.

5. other

Statistics and analysis of personnel, public information, etc.

Data flow analysis

The business department contacts with the customer, obtains the order and obtains the contact with the related department (whether the material can satisfy, the production can satisfy), if passes the examination then submits to the dispatch center, by it according to the delivery deadline prearranges, and can give on time to deliver The reply of the goods. The business department needs the dispatch center to arrange the appropriate prepress on the basis of the overall progress and print product requirements. Printing, post-printing processes and making printed copies.

After the order is confirmed, it is submitted to the dispatch center for production arrangement. The dispatch center determines the priority of production, the satisfaction of materials and production resources, arranges appropriate schedules, publishes production orders, determines production processes, and transfers them to the production department (prepress, printing, and postpress processing). When the material cannot be satisfied, it needs to contact with the department of materials and the materials department will make a purchase plan.

The pre-press department shall contact the department of materials according to the requirements of the production order and obtain the required materials (film, alcohol, developer, etc.), indicating the relevant matters. After the production is completed, the labeling is completed, the next production can be performed, and the merchandise is transferred to the next process.

The printing department contacts the prepress department and, if there is a problem, feeds the information back to the prepress department. The printing department contacts with the materials department according to needs and receives the required materials (paper, ink, etc.) for printing. After the printing is completed, it is marked as completed, indicating that it can accept other printing arrangements and transfer the semi-finished products to the post-press processing department.

The post-press processing department also has to feed back information on the finished cattle products and contact the materials department to obtain related materials. After the finished product is completed, count the number of qualified products, contact the dispatch center in time, make up the mantissa, and then pack it into the warehouse.

Before the customer picks up the goods, he needs to contact the business department, and the business department sends out the manifest. The shipment will be delivered to the designated location according to the order request. The finance department is responsible for the specific amount of money and follow-up management of the closing status.

In addition to the daily raw materials, semi-finished/finished products management (the semi-finished products in the printing companies generally flow in the workshop, the inventory does not manage them; but when the time is suspended, the semi-finished products are stored in the warehouse), the materials department is also responsible for the purchase of materials, material suppliers, Management and so on. After the material department purchases raw materials, it will check the income database. If problems are found, return the materials and fill in the relevant documents. When the production department collects raw materials, it fills in the picking list, and the remaining materials in the production process are returned to the warehouse.

The flow of information between various departments can be realized through the internal LAN of the company. Information exchange with the outside can be realized through the Internet.

Database content

　　 1. Shared database

(1) The business department mainly uses the following database:

Order bank - mainly stored order number, customer code. Product name, required quantity, specification, unit price. Whether to print proofs, date of signing, date of delivery, delivery method, place of delivery, shipping cost, settlement method, settlement period, currency, business person, time of order, packing instruction (packing method, size, etc.), Remarks and so on.

Customer Management Library - Mainly store customer information, customer code, customer name, region, address, contact information, contact person, remarks, etc.

Customer Service Library - Mainly store order number, customer code, service content, reason, remarks, etc.

(2) The production department mainly uses the following database:

Scheduling information database - mainly stores the production order number, order number, schedule date, due date, prepress and printing and postpress processing process requirements, dispatching personnel, confirming personnel, responsible personnel, remarks, etc.

Prepress information base - mainly store production order number, order number, prepress category, production staff 1, production staff 2 ..., prepress requirements, sub edition, new and old versions, completion date, remarks, etc.

Print Information Library - mainly stores production order number, order number, printing type, unit 1, unit 2..., printing requirements, printing method, completion date, paper name, total number of papers, number of semi-finished products, color code or description, Loss amount, remarks, etc.

Postpress library - mainly stores production order number, order number, postpress category, arrangement information, postpress requirements, completion date, etc.

Equipment Management Library - Mainly store equipment files, equipment registration cards, equipment usage files, equipment maintenance, equipment update, renovation, depreciation, scrap situation, equipment changes, configuration changes, notes and so on.

(3) The database used by the materials management department includes:

Material Management Library—mainly stores material number, name, specification, quantity, unit, unit price, amount, purchase, acceptance, storage, accounting, supplier, invoice number, date, and notes.

Picking warehouse - mainly stores the serial number, name, specifications, unit, quantity (planned / actual issued), unit price, amount, picker, handler, date, remarks, etc.

Return material storehouse - mainly store number, name, specification, unit, quantity, returning person, handler, date, remarks and so on.

Finished product/semi-finished product database—mainly stores the serial number, name, specifications, unit, quantity, personnel in and out of warehouse, handler, date of loading and unloading, and remarks.

Inventory library - mainly stored number, name, specifications, unit, book, number of accounts, actual inventory, inventory, custodian, date, notes, etc.
Purchasing and material supplier base - mainly store supplier's material code, commodity name, price, price change, batch request, specification, delivery place, mode of transport, payment method, currency, supplier code, name, address, contact Methods, contacts, reputation records (on-time delivery status / quality / after-sales service, etc.), supplier technical level, equipment and capabilities, purchase order confirmation status (confirmed / unconfirmed / in progress / completed), etc.

(4) Personnel Information Database: It mainly stores employee's code, name, personal data and other information.

(5) Financial Information Bank: It mainly stores information on loan management information, salary management, and finance.

2. The non-shared database is a non-shared, exclusive database, depending on the internal conditions of the printing company. In principle, in order to relieve network transmission and server pressure and improve the performance of the entire system, it should be placed on the local machine.

The data operations involved in the above systems mainly include: data entry, update, deletion, backup, data statistics, sorting and indexing, retrieval, database association, update, and linking.