RFID RECEIVING PROCESS FOR USE WITH ENTERPRISE RESOURCE PLANNING SYSTEMS
A Radio Frequency Identification (RFID) receiving method for use with an Enterprise Resource Planning (ERP) system is provided. The method includes reading, at a receiving point, information from RFID tags included on delivered items, which are not recorded on an Advanced Shipment Notification (ASN). An item arrival journal including item arrival lines is generated. By calling a mapping form, the item arrival lines are displayed along with RFID tag information indicative of delivered items. Then, mapping form logic is used to automatically map at least some of the delivered items corresponding to the RFID tags to item arrival lines to thereby match delivered items with ordered items.
Latest Microsoft Patents:
The present application is a continuation of and claims priority of U.S. patent application Ser. No. 11/101,062, filed Apr. 7, 2005, the content of which is hereby incorporated by reference in its entirety.
BACKGROUND OF THE INVENTIONThe present invention relates to Enterprise Resource Planning (ERP) systems. In particular, the present invention relates to methods and systems for utilizing Radio Frequency Identification (RFID) tags with ERP systems.
Enterprise resource planning (or ERP) is a phrase used to describe a broad set of activities supported by multi-module application software that helps a manufacturer or other business manage the important parts of its business, including product planning, parts purchasing, maintaining inventories, order tracking, interacting with suppliers, providing customer service, finance, human resources, etc. Often, an ERP system uses or is integrated with a relational database system. An example of an ERP system is Microsoft® Business Solutions-Axapta®. Axapta provides functionality to support many needs of a business, for example including: manufacturing; distribution, supply chain management, project management, financial management, human resource management, business analysis, enterprise portal, commerce gateway, etc.
There is an ongoing effort to introduce transmitters, such as RFID tags, into consumer goods. In particular, RFID tags are being used to identify products. An RFID tag is energized when it is placed in the proximity of an RFID tag reader. This causes circuitry within the RFID tag to transmit digital data which is received by the tag reader and stored in memory. The data can be used to identify the goods associated with the RFID tag. RFID tags can be placed on the individual goods themselves, and/or they can be placed on pallets or containers used to ship the goods. Ideally, RFID tags can be used to assist in automating the inventory and supply chain processes.
With a wide range of capabilities, RFID tags are a growing area in tracking technology. Unlike barcodes, RFID tags can be read through thick packaging and are unaffected by moisture and heat making them highly effective in manufacturing and distribution environments. RFID tags enable automatic identification with no physical contact. Depending on the specific type of RFID tag employed, the read range extends from a few inches to hundreds of feet.
In general terms, RFID is a means of identifying an object using a radio frequency transmission, typically 125 kHz, 13.56 MHz or 800-900 MHz. RFID has been extensively used in applications such as toll collection, access control, ticketing, and car immobilization devices (also called immobilizers). In recent years, the technology has received increased attention due to a confluence of actions including technology advancement, heightened security concerns, supply chain automation, and a continuing emphasis on cost control within industrial systems.
The AIDC (Automatic Identification Data Capture) industry is moving rapidly towards the use of RFID in a number of high-value and high-volume market segments. The primary benefit of RFID tags over barcodes is their ease of use and reliability. RFID tags can be read or written at distances up to several feet, while in motion, in any orientation, regardless of dirt or smudges, and through intervening objects. Perhaps most significant is the fact that many RFID tags can be read at once automatically, while barcodes have to be scanned manually, one by one.
An RFID tag will only communicate when it is in range of a read/write device (a transceiver, a transmitter/receiver, or a reader) and can be accessed at anytime. RFID tags are durable and have a long life span, no battery requirement with most tag types, and large data memory capacity. RFID tags are available in a variety of different shapes and sizes.
In construction an RFID tag has a microchip attached to an antenna. RFID tags are developed using a frequency according to the needs of the system including read range and the environment in which the tag will be read. Tags are either active or passive. Active RFID tags are powered by an internal battery and are typically read/write devices. Active RFID tags are more expensive and larger than passive RFID tags. However, they are also more powerful and have a greater read range. Passive RFID tags are powered by the field generated by the reader. Passive tags are typically much lighter than active tags, less expensive, and offer a virtually unlimited operational lifetime. However, they have shorter read ranges and require a higher-powered reader than active tags.
An RFID reader, usually connected to a personal computer, serves the same purpose as a barcode scanner. It can also be battery-powered to allow mobile transactions with RFID tags. The RFID reader handles the communication between the information system and the RFID tag. An RFID antenna connected to the RFID reader, can be of various sizes and structures, depending on the communication distance required for a given system's performance. The antenna activates the RFID tag and transfers data by emitting wireless pulses.
While RFID tags can be used to collect additional data related to a supply chain process, fully using this data can present problems, particularly in existing ERP systems. For example, while an RFID tag can provide information which identifies the particular goods associated with the tag, it does not provide information which would allow a purchaser to know which of multiple like or identical products a particular received item corresponds to. For instance, in a supply chain when a manufacturer regularly orders (through purchase orders) the same item, when a shipment including a pallet containing that item arrives, if an Advanced Shipment Notification (ASN) is not received as well, it is not readily apparent which purchase order the received item corresponds to. Other obstacles exist which may prevent the RFID tag information from being fully utilized to improve the process.
SUMMARY OF THE INVENTIONUsing RFID tags to streamline business processes requires integrating the information into business software such that the information us useful as well as is not disruptive to the existing functionality of the software. The invention provides formats, schemas and processes to enter the information into business software supply chain and inventory control software without affecting other functionality.
A Radio Frequency Identification (RFID) receiving method for use with an Enterprise Resource Planning (ERP) system is provided. The method includes reading, at a receiving point, information from RFID tags included on delivered items, which are not recorded on an Advanced Shipment Notification (ASN). An item arrival journal including item arrival lines is generated. By calling a mapping form, the item arrival lines are displayed along with RFID tag information indicative of delivered items. Then, mapping form logic is used to automatically map at least some of the delivered items corresponding to the RFID tags to item arrival lines to thereby match delivered items with ordered items.
Other features and benefits that characterize embodiments of the present invention will be apparent upon reading the following detailed description and review of the associated drawings.
Radio frequency identification (RFID) is a technology which can aid manufacturers and distributors to gain improved visibility into their supply chain, by increasing the number of data capture points in their supply chain. The aim is to put RFID tags on pallets, cases or items so they can be uniquely identified and tracked in the supply chain. The tracking can be done by collecting the data about when a unique pallet/case/item was registered at a specific location. This data can then be collected by an RFID middleware application (an RFID server) and fed to an ERP system, where it will be processed accordingly using methods of the present invention.
By introducing RFID into ERP systems such as Axapta®, processes related to receiving and shipping items and pallets will be more streamlined and optimized. Using RFID tags to streamline business processes requires integrating the information into business software such that the information is useful as well as is not disruptive to the existing functionality of the software. The present invention provides formats, schemas and processes to enter the information into business software supply chain and inventory control software without affecting other functionality.
The invention is operational with numerous other general purpose or special purpose computing system environments or configurations. Examples of well-known computing systems, environments, and/or configurations that may be suitable for use with the invention include, but are not limited to, personal computers, server computers, hand-held or laptop devices, multiprocessor systems, microprocessor-based systems, set top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, telephony systems, distributed computing environments that include any of the above systems or devices, and the like.
The invention may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The invention is designed to be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules are located in both local and remote computer storage media including memory storage devices.
With reference to
Computer 110 typically includes a variety of computer readable media. Computer readable media can be any available media that can be accessed by computer 110 and includes both volatile and nonvolatile media, removable and non-removable media. By way of example, and not limitation, computer readable media may comprise computer storage media and communication media. Computer storage media includes both volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, digital versatile disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can be accessed by computer 110. Communication media typically embodies computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any information delivery media. The term “modulated data signal” means a signal that has one or more of its characteristics set or changed in such a manner as to encode information in the signal. By way of example, and not limitation, communication media includes wired media such as a wired network or direct-wired connection, and wireless media such as acoustic, RF, infrared and other wireless media. Combinations of any of the above should also be included within the scope of computer readable media.
The system memory 130 includes computer storage media in the form of volatile and/or nonvolatile memory such as read only memory (ROM) 131 and random access memory (RAM) 132. A basic input/output system 133 (BIOS), containing the basic routines that help to transfer information between elements within computer 110, such as during start-up, is typically stored in ROM 131. RAM 132 typically contains data and/or program modules that are immediately accessible to and/or presently being operated on by processing unit 120. By way of example, and not limitation,
The computer 110 may also include other removable/non-removable volatile/nonvolatile computer storage media. By way of example only,
The drives and their associated computer storage media discussed above and illustrated in
A user may enter commands and information into the computer 110 through input devices such as a keyboard 162, a microphone 163, and a pointing device 161, such as a mouse, trackball or touch pad. Other input devices (not shown) may include a joystick, game pad, satellite dish, scanner, or the like. These and other input devices are often connected to the processing unit 120 through a user input interface 160 that is coupled to the system bus, but may be connected by other interface and bus structures, such as a parallel port, game port or a universal serial bus (USB). A monitor 191 or other type of display device is also connected to the system bus 121 via an interface, such as a video interface 190. In addition to the monitor, computers may also include other peripheral output devices such as speakers 197 and printer 196, which may be connected through an output peripheral interface 195.
The computer 110 is operated in a networked environment using logical connections to one or more remote computers, such as a remote computer 180. The remote computer 180 may be a personal computer, a hand-held device, a server, a router, a network PC, a peer device or other common network node, and typically includes many or all of the elements described above relative to the computer 110. The logical connections depicted in
When used in a LAN networking environment, the computer 110 is connected to the LAN 171 through a network interface or adapter 170. When used in a WAN networking environment, the computer 110 typically includes a modem 172 or other means for establishing communications over the WAN 173, such as the Internet. The modem 172, which may be internal or external, may be connected to the system bus 121 via the user input interface 160, or other appropriate mechanism. In a networked environment, program modules depicted relative to the computer 110, or portions thereof, may be stored in the remote memory storage device. By way of example, and not limitation,
Referring now to
Pallet 215 represents a container on which, or in which, goods or items 220 are received in response to one or more purchase orders. An RFID tag 225 is, in some embodiments, secured to pallet 215 for identification purposes. In these or other embodiments, the individual goods or items 220 also each have their own RFID tag 230. Under the control of middleware server 205, RFID reader 210 transmits electromagnetic signals toward RFID tags 225 and 230 in order to elicit a response signal from the tags. Tags 225 and 230 can be any desired type of RFID tag, including inductively coupled RFID tags, capacitively coupled RFID tags, battery powered RFID tags, etc. In some well known embodiments of RFID tags, the inductively or capacitively coupled RFID tags are powered by the magnetic field generated by the reader. An integral antenna on the tag receives the magnetic energy, and the tag communicates with the reader using RF communication. The tag modulates the magnetic field in order to retrieve and transmit data back to the reader 210 and to middleware server 205. The data encrypted on the RFID tag, which is retrieved and transmitted back to the RFID reader 210, includes information indicative of the source or manufacturer of the item(s), a product code for the item(s), serial numbers for the item(s), etc. In some embodiments, this information is stored on middleware server 205.
In exemplary embodiments, the information read from the RFID tags is encrypted with an Electronic Product Code (EPC) number. The EPC is a product identification standard established by EPCglobal in an attempt to unify and standardize product identification techniques. The EPC is built around a basic hierarchical idea that can be used to express a wide variety of different, existing numbering systems. The EPC is divided into numbers that identify the manufacturer and product type. The EPC can also use extra digits, for a serial number, to identify unique items. An example EPC number is 305 is shown in
-
- 1. Header 310, which identifies the length, type, structure, version and generation of the EPC;
- 2. Manager Number 315, which identifies the company or company entity;
- 3. Object Class 320, which is similar to a stock keeping unit or SKU (the object class is, or includes, the Global Trading Identification Number or GTIN); and
- 4. Serial Number 325, which is the specific instance of the Object Class being tagged.
Additional fields may also be used as part of the EPC in order to properly encode and decode information from different numbering systems into their native (human-readable) forms.
Referring now to
First the tag read steps are described. As illustrated at 405 in
Next, the ERP system registration steps are described. As shown at step 425, an item arrival journal, and lines within the journal are created. The item arrival journal is created by calling an item arrival form. A screenshot depicting an example embodiment of arrival form 500 is provided in
Arrival form 500 includes a journal ID display field or portion 505 which displays an ID or name for the arrival journal, and in the case of creation of a new journal, allows the journal ID to be entered. A description field or portion 510 displays a description for the journal, for example a name. Arrival form 500 also includes a number of input control elements, for example in the form of buttons, tabs, check boxes, etc. In arrival form 500, a lines button 515 can be selected using an input device to call a lines form 600 as shown in the example screen shot of
Lines form 600 includes descriptive fields or portions such as item number field 605, warehouse field 610, batch number field 615, location field 620, pallet ID field 625, serial number field 630 and quantity field 635. Where applicable, the data for these fields is automatically mapped from purchase orders to lines form 600. Lines are also created “manually”, as represented in step 425 by the phrase “manual process.” As described above, this manual process utilizes, if known, details of the items received as default values entered in default values screen 700 shown in
Referring back to
Although mapping form 800 facilitates automatic mapping as described, there is also a manual component to the mapping process when necessary or desired. This manual mapping is also carried out using mapping form 800. If the system cannot determine which arrival line 806 a particular EPC line 811 should map to (for example due to multiple orders, conflicting quantities, partially filled orders, etc), manually mapping can be carried out. To create a manual mark the user has to select one of the item arrival lines in the mapping form, then select one of the tag reads and finally select the “Map” button 820. If check box 825 is selected, only unmatched lines will be available for manual mapping. Otherwise, if check box 825 is not selected, the automatic mappings can be overridden and manual mapping can be effected. When the mapping is complete, the EPC numbers are inserted on the pallet table. With the selection of a button such as an “OK” or “Apply” button, the match or mapping data is saved, as indicated at step 440. The EPC number is saved into the pallet table 950 shown in
The pallet or container ID is either created upfront, before the mapping from is activated, or it is automatically generated when the OK/Apply button is activated. When saving the data, the pallet or container ID is saved into a corresponding field (i.e., Pallet ID field 625 shown in
Although the present invention has been described with reference to particular embodiments, workers skilled in the art will recognize that changes may be made in form and detail without departing from the spirit and scope of the invention.
Claims
1. An integrated RFID receiving system and an ERP system, comprising:
- an RFID reader device configured to read, at a receiving point, information from RFID tags included on delivered items, which are not recorded on an Advanced Shipment Notification (ASN);
- an ERP server, interfaced with the RFID reader via a middleware server, comprising software modules configured to: create an item arrival journal including item arrival lines; and generate a mapping form to display the item arrival lines and the RFID tag information indicative of delivered items, the mapping form including logic to automatically map at least some of the delivered items corresponding to the RFID tags to item arrival lines to thereby match delivered items with ordered items.
2. The apparatus of claim 1 wherein the software modules are configured to read information from the RFID tags by:
- identifying an encrypted Electronic Product Code (EPC) number in each of the RFID tags; and
- decrypting the identified EPC number to obtain information included in the EPC number.
3. The apparatus of claim 2 wherein the decrypted information comprises a Global Trading Identification Number (GTIN).
4. The apparatus of claim 1 wherein the software modules are configured to store information read from each of the RFID tags in a table on the ERP system.
5. The apparatus of claim 1 wherein the ordered items are manually selected from a purchase orders database included in the ERP system when creating the item arrival journal.
6. The apparatus of claim 1 wherein the ERP server comprises a software module configured to generate an arrival items form, which is a UI element that includes form logic to select the ordered items and to display the items arrival list.
7. A computer readable medium including information read from RFID tags included on delivered items, which are not recorded on an ASN, the computer readable medium having computer-executable instructions for performing steps comprising:
- creating an item arrival journal including item arrival lines;
- generating a mapping form which displays the item arrival lines and the RFID tag information indicative of delivered items; and
- automatically mapping, using mapping form logic, at least some of the delivered items corresponding to the RFID tags to item arrival lines to thereby match delivered items with ordered items.
Type: Application
Filed: Mar 19, 2010
Publication Date: Dec 9, 2010
Applicant: MICROSOFT CORPORATION (Redmond, WA)
Inventors: Flemming Gregersen (Hilleroed), Kenneth Puggaard (Frederikssund), Thomas Vest (Roenne)
Application Number: 12/727,622
International Classification: H04Q 5/22 (20060101);