Fixed asset barcode management system of a network branch in Guangdong Province
chrispeng [ad_1]
Broadcasting Network Zhuhai Branch fixed asset barcode management system software requirements. Fixed asset management is an important part of the daily management of enterprises and institutions. How to strengthen management of the ever-increasing fixed assets and equipment in the process of enterprise development is an important issue faced by enterprises and institutions.
Due to the continuous development of enterprises and the continuous increase of fixed assets, enterprises have problems with scattered data and long statistical time in asset management, and the problems that cannot be reflected in the books in time when assets are transferred.Due to the large workload of inventory, the information is not reflected in time, which often leads to the repeated purchase of assets, which greatly increases the cost of the enterprise and affects the efficiency of the enterprise
The headquarters of the Zhuhai Branch of Guangdong Radio and Television Network Co., Ltd. is located in Zhuhai. At present, the Zhuhai branch has Zhuhai Doumen Branch and Zhuhai Jinwan Branch, both of which are formed with the provincial headquarters and branches in other regions of the province. The local area network of the company uses Yonyou NC5.6 ERP management system to connect to the ORACLE 10G database for asset management.
The fixed asset barcode management systems of Zhuhai Branch, its subsidiary Zhuhai Doumen Branch, Zhuhai Jinwan Branch, etc. are independent management systems. The data sources in the barcode management system include headquarters NC asset card data and their respective physical management forms. Parts.
1.1 Brief description of software requirements
For the Zhuhai branch’s fixed assets and physical management (hereinafter referred to as assets), the physical system barcode management is mainly to meet the requirements of daily barcode printing, asset inventory, departmental asset self-inquiry management, and asset inventory remarks.When the warehouse outbound management system imports data from NC to the barcode system, it will automatically generate a temporary serial barcode number–>enter the corresponding information such as the applicant and project information and print the corresponding barcode–>the system automatically saves the information
1.2 Daily use process of asset barcode
1.2.1 The personnel of the physical department use the system stipulated physical management form to import or read the data to the asset barcode management system through NC, and print the barcode and paste it;
1.2.2 The barcode management system allows the operator to perform daily general condition inquiries, and the operator can modify and adjust the remarks of the asset storage location, user, user department, management department, etc., within the designated authority;
1.2.3 When the warehouse outbound management system of Zhuhai headquarters imports data from NC to the barcode system, it will automatically generate a temporary serial barcode number -> enter the corresponding information such as the applicant, project project information and print the corresponding barcode – >The system automatically saves information
1.2.4 The asset information data of the barcode management system is consistent with the asset information of the NC system, that is, after the asset information of the NC system changes, the asset information of the barcode management system will also be updated, so as not to affect the query results of the barcode system operator;
1.2.5 The warehouse outbound information data of the Zhuhai headquarters is consistent with the outbound information of the Zhuhai headquarters of the NC system, that is, after the inventory information of the NC system changes, the inventory information of the barcode management system will also be updated, so as not to affect the barcode system Operator’s query results;
1.3 Warehouse outbound management and receiving and dispatching categories include: engineering outbound, maintenance equipment outbound, and home installation services
The warehouse management system of Zhuhai headquarters will automatically generate a temporary serial bar code number from NC export of project requisition outbound, maintenance equipment outbound, and household installation business data to the bar code system (a serial bar code for major equipment such as workstations) Management) à enter the corresponding information such as the applicant, project information and print the corresponding barcode à the system automatically saves the information à convert the required equipment into asset code management.
1.4 Hardware required by barcode management software
2Scheme design of barcode technology applied to asset management
2.1 Data source
2.1.1 For the original fixed assets in the NC system
2.1.2 Physical management
2.1.3 Warehouse outgoing management and receiving and dispatching categories include: outgoing engineering use out of warehouse, outgoing maintenance equipment out of warehouse and in-home installation business
2.1.3.1 Project Requisition and Release
2.1.3.2 Delivery of maintenance equipment
2.1.3.3 Home installation service
The physical management of Zhuhai branch, its subsidiary Zhuhai Doumen branch, and Zhuhai Jinwan branch are imported into the asset barcode management system for system management in accordance with the form in the prescribed format of the system. According to the physical management Excel report in the system format à import the system for query à barcode printing and pasting à barcode collection and inventory à report output, printing management, etc.
3. Server-side system module
4 Barcode asset management system software design
4.1 System function
4.2 Data Management
4.2.1 Data source
4.2.1.1 Provincial Headquarters Asset Card Data Import
SVA Zhuhai and its affiliated companies import the company’s asset card data into the barcode management database from the provincial headquarters database;
4.2.1.2 EXCEL report data import in physical management system format
4.2.2 Data backup
4.2.3 Data Recovery
4.2.4 Query data export
4.2.4.1 System data
4.3 Asset Management
4.4 Warehouse Outbound Management
4.4.1 Requisition and outgoing of the project
4.4.2 Delivery of maintenance equipment
4.4.3 Home installation business
4.5 Report Center
4.5.1 Fixed Assets Table
4.5.2 Physical management table
4.5.3 Project Requisition and Outbound Table
4.5.4 Maintenance equipment outbound table
4.5.5 Home installation business table
5. The advantages of using barcodes for asset management
In order to strengthen asset management, improve internal management, and provide enterprise managers with a more scientific basis for decision-making, barcode technology is introduced to implement barcode management on fixed assets. Barcode technology can help enterprises realize the information management of assets, solve the problems that often occur in asset management that are inconsistent with accounts and accounts, reduce blind spots in the management of fixed assets in corporate management, and enable corporate leaders to sit in the office. Be able to understand the overall situation of all the assets of the enterprise. With the application of barcode technology in asset management, it will bring good economic and management benefits, especially in the management of large group companies, which are mainly manifested in the following aspects.
1. Improve the management efficiency of the head office to the branches. The combination of bar code technology and information system can enable the head office to quickly and timely understand the asset management status of the branch company, which not only improves the efficiency of the company’s management department, but also enables managers to have an overall grasp of the company’s asset status.
2. Improve asset management efficiency and reduce asset management costs. Through bar code technology, the past year-end inventory and statistics of fixed assets have been changed. The use of fixed assets can be inquired at any time, and the use and depreciation of fixed assets can be grasped at any time. This greatly improves the efficiency of the company’s management department and avoids repeated purchases of fixed assets. Cause waste and reduce labor costs.
3. Optimize procurement methods and improve the management of fixed assets. Through bar code technology, you can have a clear understanding of the fixed assets situation, avoid the waste caused by blind procurement, and improve the management level. Bar code technology can enable the company to comprehensively and quickly grasp the company’s use of fixed assets.
Companies can set up their own bar code generation rules, and the companies themselves can code and print labels. Asset management barcode can realize the tracking management of the entire asset life cycle of the physical fixed assets from purchase, use, maintenance, maintenance, warranty, and retirement. Solve the inconsistency of accounts, cards, and objects in asset management, improve the accuracy of asset inventory, and reduce the intensity and difficulty of asset management. Help system users to achieve the full-process comprehensive, precise, meticulous, and timely and dynamic fixed asset management requirements.
6. Features of Barcode Management System
The platform of the entire system is a multi-layer application system structure, and the data is concentrated in the service center of the Guangdong Province headquarters for processing. It has the following characteristics:
1. Practicality and economy. The overall structure of the system adopts the B/S model, the data is concentrated in the headquarters, and all data import and export are performed on the server side, and the branch does not need to increase additional network infrastructure investment.
2. Advancement and maturity. Using the Internet/Intranet network transmission application technology, the data is interacted based on the HTTP protocol. The technical realization is the current advanced access mode, and the technology maturity is also guaranteed.
3. Reliability and stability. The reliability and stability of the network are established on the basis of the existing Guangdong Radio and Television Network Co., Ltd. network, which can meet business needs.
4. Security and confidentiality. In the system design, not only consider the full sharing of information resources, but also pay attention to the protection and isolation of information. Therefore, the system should take different measures for different applications and different network communication environments, such as system security such as VLAN inside the system. Mechanism, data access authority control, etc.
5. Scalability and easy maintenance. In order to adapt to the changing requirements of the system, the simplest method and the lowest investment must be fully considered to realize the expansion and maintenance of the system. When adding a new department for the use of fixed assets, it only needs to be connected to the existing Internet/Intranet.
7. Barcode management system structure
8. Barcode management system hardware configuration
8.4 Asset Barcode Label
8.5 Whole Tree Ribbon
9. System configuration quotation form
7 NC fixed asset interface server software PS2100 1 set of custom development 3 server side
NC warehouse management outbound interface server software PS2200 1 set of custom development 1 server side
Physical management system report interface server software PS2300 1 set of customized development 3 server side
8 client software PC2100 1 set of customized development 20 clients
9 PDA software PM2100 1 set of customized development 3 handheld terminal
Total equipment
10 Installation, commissioning, training on-site service 1 item
Including free maintenance for one year, including tax total: RMB one ten thousand two hundred and one hundred yuan
10. Service Commitment
The hardware products sold by the company are guaranteed free for one year from the date of sale. After the warranty period, the company improves a variety of services to choose from.
10.1 Software maintenance and after-sales service commitment:
The software is maintained free of charge for 12 months.
For common problems, the company provides technical support for instant messaging such as telephone, fax, e-mail or QQ to respond to customers in a timely manner.
10.2 Technical support and service items:
Standard warranty service
Telephone support: Monday to Friday, 9:00 am to 5:30 pm. Professional technical support and services are provided by software, hardware, and system engineers respectively. Repair the equipment sent to the user free of charge, and be responsible for replacing damaged parts.
Provide on-site maintenance and technical support services. Provide training, installation, on-site testing and consulting.
Service after the warranty period:
The company implements lifelong maintenance and upgrade services for the developed system.
When the service is provided after 12 months, the radio and television will bear the travel expenses, labor expenses and consumable expenses.
[ad_2]
