Design and implementation of the hottest wireless

Design and implementation of wireless bar code warehouse management system

with the development and application of information technology in manufacturing industry, most enterprises have established a comprehensive information management system with product data management PDM and enterprise resource management ERP as the core. However, in the whole day check-in Festival on July 13, 2016, due to the lack of technical means of on-site management and refined management, information data is often inconsistent with physical data

the basic requirements of storage management in construction machinery manufacturing industry are: a) realize first in first out and batch management; b) Accurate and fast warehousing, outbound and distribution data; c) Inter warehouse transfer and location change are convenient and accurate; d) Real time and dynamic physical management on site; e) Convenient statistical analysis of inventory structure; f) Closely integrated with ERP; g) Ensure that the accounts are consistent with the goods

the coding principle of ERP warehousing management is generally category management, that is, one item corresponds to one code, so it is impossible to realize batch management of items. Although some ERP has the function of batch management, it lacks effective means to ensure the one-to-one correspondence between the physical object and the data, which often leads to the serious problem of inconsistency between the account and the material. The introduction of bar code technology and wireless warehouse management system is an effective way to solve the above problems

1 introduction to bar code and wireless network

bar code is composed of bars and spaces with different widths and reflectivity, which are compiled according to certain coding rules to express a group of numerical or alphabetic information. It is widely used in logistics information management systems. As a bridge between wired local area network and wireless network, wireless access point (AP) realizes the real-time transmission of data between the field and the system. The "warehouse management system" (WMS) established by using the above technology realizes the effective combination of on-site logistics and system information flow

2 hardware and software system composition (1) poor scientific and technological innovation

WMS hardware system includes server, personal computer (PC), wireless network access point (AP), bar code printer, personal digital assistant (PDA), carbon tape and label. The wireless connection between the on-site PDA and the server is realized through the AP. Because the metal parts and metal shelves may interfere with the signal, the location and quantity of the AP layout need to be determined according to the on-site test. The number of AP layout can be appropriately increased and the same ID name can be set. When an AP fails or the signal is disturbed, PDA will automatically connect to the AP with the strongest signal to ensure the safety of data transmission. If there is an outdoor storage area, waterproof labels and waterproof carbon tapes need to be used, and a separate printer should be equipped to avoid the trouble of replacing labels and carbon tapes when printing waterproof labels. The number of PDAs is allocated according to the number of warehouse keepers. Each warehouse keeper is responsible for using and keeping PDAs, which is clear and easy to manage

Figure 1 hardware system structure diagram

software system includes warehouse management system, PDA application system, PDA interface service and ERP interface service. The design scheme has two forms: one is "extended", which uses the warehouse management module function of the existing ERP to develop the PDA application program for PDA field data collection and field business operation, and provides the tentacle of ERP warehouse management extending to the field, as shown in Figure 2

Figure 2 Schematic diagram of "extended" software system structure

wms does not store real warehousing business data, but only system data such as users and permissions (as shown by the dotted line, system data is transmitted through ERP interface services and PDA interface services). PDA obtains business data through PDA interface service, and directly returns it to ERP system after completing business operations. The characteristic of this method is that the development workload is reduced, and the storage management function of the original ERP is used as much as possible. The second is "complete", developing a complete set of bar code warehouse management system, and realizing two-way real-time data synchronization through ERP interface service, as shown in Figure 3. WMS stores complete warehouse management data, has complete warehouse management functions, and obtains business data through ERP interface service. WMS (3) electrical control line refers to international standards and assigns PDA on-site business operations through PDA interface service. After the business operations are completed, WMS transmits the data back to ERP system through ERP interface service. The feature of this scheme is to make up for the deficiency of ERP storage management function and ensure the normal operation of other functions of ERP

Figure 3 "complete" software system structure diagram

3 main business process design

the wireless barcode warehouse management system described in this paper adopts the "complete" design scheme to realize the barcode management of the main business processes (purchase warehousing, distribution warehousing, sales return, purchase return, inventory)

3.1 purchase warehousing

the business process of purchase warehousing is shown in Figure 4. WMS receives the material receipt that passes the ERP inspection through the ERP interface service, and the inspection department prints and pastes the barcode according to the qualified quantity. PDA automatically obtains the details of items to be warehoused through PDA interface service. The warehouse keeper uses PDA to scan the barcode of articles, scan the warehouse location, and put the articles on the shelf. PDA automatically generates the warehousing order and uploads it to WMS and ERP to complete the warehouse process

3.2 delivery delivery delivery

the business process of delivery delivery is shown in Figure 5. First, WMS obtains the ERP delivery notice through the debugging of ERP door and window corner strength testing machine and the use of interface services. WMS combines or decomposes the delivery notice according to the delivery warehouse, customer, delivery location and the principle of first in first out, and makes the initial delivery instruction. If there are some items without delivery instructions due to insufficient inventory, you can make a supplementary delivery instruction after the inventory is sufficient for supplementary delivery. PDA automatically obtains the details of the items to be delivered through the PDA interface service. The warehouse keeper scans the barcode of the items with PDA according to the location and quantity of the outbound items instructed by PDA, and the items are removed from the shelf. In the delivery process, after the goods are delivered to the designated place, the customer and the delivery personnel receive the goods on site and confirm the receipt on the PDA. If the confirmed quantity is consistent with the outbound quantity, the PDA automatically generates the outbound order and uploads it to WMS and ERP. If the confirmed quantity is inconsistent with the delivery quantity, WMS system can make a differential delivery instruction for differential delivery

Figure 5 distribution and delivery business flow chart

3.3 sales stock return

sales stock return (similar to stock in) can be divided into two cases, one is to use the original barcode of the returned items, and the other is to regenerate the barcode. The difference between the two methods lies in whether ERP is dominant or WMS is dominant. This system adopts the method of returning the stock and regenerating the printed barcode, with ERP as the leading and WMS as the auxiliary implementation

the business process of sales stock return is shown in Figure 6. First, WMS receives the ERP Sales stock return instruction through the ERP 121 service, and the inspection department prints and pastes the article barcode. PDA automatically obtains the details of the items to be returned to the warehouse through the PDA interface service. The warehouse keeper uses PDA to scan the barcode of the items, scan the warehouse location, and put the items on the shelves. PDA automatically generates the sales stock return form, uploads it to WMS and ERP, and completes the sales stock return process

Figure 6 sales return business flow chart

3.4 purchase return

purchase return business (similar to delivery) process is shown in Figure 7. First, WMS receives ERP purchase return instructions through ERP interface service. PDA automatically obtains the details of the items to be returned through the PDA interface service. The warehouse keeper scans the barcode of the items according to the location and quantity indicated by PDA, and the items are removed from the shelf. PDA automatically generates a purchase return order and uploads it to WMS and ERP to complete the purchase return process

3.5 inventory

the inventory business process is shown in Figure 8. First, the inventory plan is made in WMS according to the warehouse area or the type of goods. PDA automatically obtains the details of the goods to be counted through the PDA interface service. The warehouse keeper scans the barcode of the goods according to the location and quantity of the goods to be counted as instructed by the PDA, completes the inventory entry and uploads it to WMS. WMS compares the recorded data with the inventory data, and generates the counting profit and loss sheet. The counting adjustment can be carried out only after the counting profit and loss sheet is approved. Upload the count sheet to ERP through ERP interface service to complete the count process

4 barcode and document design

4.1 definition of article management type

considering the price, shelf life, importance, packaging form, management requirements and other factors of articles, three article management types are defined. a) Category management (Mark 2): bar codes correspond to article codes one by one, which are mainly used for common standard parts with large quantities and no shelf life; b) Batch management (Mark 1): barcode corresponds to article code and batch one by one, which is mainly used for supporting parts and outsourced processing parts in large batches; c) Single item management (Mark 0): bar codes correspond to single items one by one, and are mainly used for key items with high prices

4.2 barcode label design

the information displayed by the barcode label includes: part number, name, specification, standard, warehousing date and barcode, as shown in Figure 9. The barcode has 14 bits, and the coding rules are shown in Figure 10

4.3 document design and coding rules

document category number is shown in Table 1, and document coding rules are shown in Figure 11. For example, document rkl means the purchase receipt document with serial number 1 in January, 2010

5 function realization

according to the above design scheme, the functions realized by PC application program of WMS system are shown in Table 2, and the functions realized by PDA application program are shown in Table 3

6 conclusion

this system realizes batch management and first in first out management of warehousing business, improves the efficiency and accuracy of business operations, optimizes business operation processes, and strengthens the execution of warehousing management. The implementation effect is as follows:

(1) establish a management mode of on-site guidance and on-site operation. The warehouse management operations are completed on the warehouse site. PDA on-site guides the operation of goods on and off the shelf. PDA on-site operation data and real-time interaction with the management system reduce paper documents

(2) it realizes the rapid acquisition of relevant information of items and the rapid preparation of information obtained by scanning bar codes through PDA. PDA can query inventory, location, items and other information anytime and anywhere, reduce the difficulty of item identification by warehouse keepers and improve the accuracy of item identification

(3) the business process is optimized to avoid the problem of inconsistency between information flow and physical flow. When entering the warehouse, the articles are first put on the shelf and regenerated into a warehouse order. When leaving the warehouse, the articles are first removed from the shelf and then generated into a warehouse order. When distributing, the articles are first put out of the warehouse before printing the distribution order. After the customer confirms the receipt, they are uploaded to ERP

(4) improve the ability of item management. You can customize the type of item management (batch, single piece, type) according to the management requirements. The system automatically determines the delivered items according to the first in first out principle, and provides real-time dynamic inventory structure analysis and report generation functions. (end)