Method for receiving and reconciling physical inventory data against an asset management system from a remote location

• US 20030101108A1
• Filed: 11/29/2001
• Published: 05/29/2003
• Est. Priority Date: 11/29/2001
• Status: Active Grant

• Current Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Original Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Inventors: Murray, Lorna M., Botham, Robert A.
• Granted Patent: US 7,624,034 B2
• Time in Patent Office: Days
• US Class Current: 705/28
• CPC Class Codes: G06Q 10/063 Operations research, analysis or management
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 10/0875 Itemisation or classification of parts, supplies or services, e.g. bill of materials
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 20/203 Inventory monitoring

Abstract

The patent discloses a system and related method for taking, receiving and reconciling physical inventory data against an asset management system from a remote location. In the disclosed system, assets as well as their locations are scanned using a hand held bar code scanner. Scanner information is uploaded to a particular location on a web server. Once transferred, the scanner files are converted to an intermediate database. Individual records of the intermediate database are then compared against their corresponding records, if any, in a main asset database by way of a web user interface. Records are modified, rejected or accepted by way of the web user interface, and then accepted records are written to the main asset database. In this way, multiple steps of the reconciliation process may take place at the same time, and reconciliation may be done quickly and efficiently, even from a remote location.

Claims

1. A method of reconciling physical inventory against an asset management database, the method comprising:

taking a physical inventory;

creating raw inventory data;

transferring the raw inventory data to a web server;

converting the raw inventory data into an intermediate database;

creating a copy of the asset management database;

reconciling records in the intermediate database against corresponding records in the copy of the asset management database by way of a web browser; and

updating the asset management database with records accepted during the reconciling step.

2. The method of reconciling physical inventory against an asset management database as defined in claim 1 wherein taking physical inventory and creating raw inventory data further comprises, with a hand held bar code scanning device:

scanning a location code;

scanning assets codes associate with that location code;

repeating the scanning step at a plurality of locations and for a plurality of assets codes;

storing the location codes and the asset codes in the hand held bar code scanning device.

3. The method of reconciling physical inventory against an asset management database as defined in claim 2 wherein storing the location codes and the asset codes in the hand held bar code scanning device further comprises storing the location codes and the asset codes in a file in the hand held bar code scanner.

4. The method of reconciling physical inventory against an asset management database as defined in claim 3 wherein storing the location codes and asset codes in a file further comprises storing the location codes and asset codes in a comma delimited ASCII test file.

5. The method of reconciling physical inventory against an asset management database as defined in claim 3 wherein transferring the raw inventory data to a web server further comprises copying the file to a web server using a file transfer protocol (FTP) program.

6. The method of reconciling physical inventory against an asset management database as defined in claim 3 wherein transferring the raw inventory data to a web server further comprises;

moving the file to an intermediate device; and

then

copying the file from the intermediate device to the web server.

7. The method of reconciling physical inventory against an asset management database as defined in claim 6 wherein moving the file to an intermediate device further comprises broadcasting the file using electromagnetic waves.

8. The method of reconciling physical inventory against an asset management database as defined in claim 6 wherein moving the file to an intermediate device further comprises:

copying the file to a semi-permanent storage device; and

then

copying the file from the semi-permanent storage device to the intermediate device.

9. The method of reconciling physical inventory against an asset management database as defined in claim 8 wherein copying the file to a semi-permanent storage device further comprises copying the file to a floppy disk.

10. The method of reconciling physical inventory against an asset management database as defined in claim 6 wherein moving the file to an intermediate device further comprises moving the file to a computer system having an internet connection.

11. The method of reconciling physical inventory against an asset management database as defined in claim 1 wherein converting the raw inventory data into an intermediate database further comprises converting the raw inventory data into a structured query language (SQL) format database having fields for location codes and associated asset codes.

12. The method of reconciling physical inventory against an asset management database as defined in claim 11 further comprising creating additional fields associated with each asset code to identify a person who performs the reconciliation step.

13. The method of reconciling physical inventory against an asset management database as defined in claim 1 wherein reconciling records in the intermediate database against corresponding records in the copy of the asset management database by way of a web browser further comprises:

invoking a web browser program;

entering a user identification;

entering a password;

displaying corresponding records between the intermediate database and the copy of the asset management database;

reconciling the corresponding records creating reconciled records; and

marking at least some of the reconciled records as accepted.

14. The method of reconciling physical inventory against an asset management database as defined in claim 13 wherein invoking a web browser program further comprises invoking an Internet Explorer®

web browser.

15. The method of reconciling physical inventory against an asset management database as defined in claim 13 wherein displaying corresponding records between the intermediate database and the copy of the asset management database further comprises:

displaying a record from the intermediate database based on an asset code; and

displaying a record from the copy of the asset management database based on the asset code.

16. The method of reconciling physical inventory against an asset management database as defined in claim 13 wherein updating the asset management database with records accepted during the reconciling step further comprises copying to the asset management database reconciled records marked as accepted.

17. The method of reconciling physical inventory against an asset management database as defined in claim 1 wherein taking a physical inventory further comprises taking a physical inventory of computer assets.

18. A method of taking a physical inventory and reconciling the physical inventory against an asset management database, the method comprising:

scanning with a hand held scanner bar codes identifying locations and bar codes identifying assets to create inventory data;

transferring the inventory data from the hand held scanner to a web server;

converting the inventory data into an intermediate database;

reconciling records in the intermediate database against corresponding records in the asset management database by way of a web browser; and

updating the asset management database with records accepted during the reconciling step.

19. The method of taking a physical inventory and reconciling the physical inventory against an asset management database as defined in claim 18 wherein scanning with a hand held scanner bar codes identifying locations and bar codes identifying assets further comprises:

scanning a plurality of bar codes identifying locations; and

scanning a bar code identifying at least one asset associated with each location.

20. The method of taking a physical inventory and reconciling the physical inventory against an asset management database as defined in claim 19 wherein creating inventory data further comprises storing the bar codes identifying the locations and also storing the bar codes identifying assets in a file in the hand held scanner.

21. The method of taking physical inventory and reconciling the physical inventory against an asset management database as defined in claim 20 wherein transferring the inventory data from the hand held scanner to a web server further comprises transferring the file from the hand held scanner to the web server.

22. The method of taking physical inventory and reconciling the physical inventory against an asset management database as defined in claim 21 wherein transferring the file from the hand held scanner to the web server further comprises transferring the file using a file transfer protocol (FTP) program.

23. The method of taking physical inventory and reconciling the physical inventory against an asset management database as defined in claim 21 wherein transferring the file from the hand held scanner to the web server further comprises;

transferring the file from the hand held scanner to an intermediate device; and

transferring the file from the intermediate device to the web server using the FTP protocol.

24. The method of taking physical inventory and reconciling the physical inventory against an asset management database as defined in claim 23 wherein transferring the file from the hand held scanner to the intermediate device further comprises broadcasting the file using electromagnetic radiation.

25. The method of taking physical inventory and reconciling the physical inventory against an asset management database as defined in claim 23 wherein transferring the file from the hand held scanner to the intermediate device further comprises:

copying the file to a disk; and

then

copying the file from the disk to the intermediate device.

26. The method of taking physical inventory and reconciling the physical inventory against an asset management database as defined in claim 23 wherein transferring the file from the hand held scanner to the web server further comprises;

transferring the file from the hand held scanner to a laptop computer; and

transferring the file from laptop computer to the web server using the FTP protocol.

27. The method of taking physical inventory and reconciling the physical inventory against an asset management database as defined in claim 18 wherein converting the inventory data into an intermediate database further comprises converting the inventory data into a structured query language (SQL) database resident on the web server.

28. The method of taking physical inventory and reconciling the physical inventory against an asset management database as defined in claim 18 wherein reconciling records in the intermediate database against corresponding records in the asset management database by way of a web browser further comprises:

making a copy of the asset management database available on the web server; and

reconciling records in the intermediate database against corresponding records in the copy of the asset management database.

29. The method of taking physical inventory and reconciling the physical inventory against an asset management database as defined in claim 28 further comprising, before the step of making a copy of the asset management database, placing an identifying indicia on a portion of each record in the asset management database.

30. The method of taking physical inventory and reconciling the physical inventory against an asset management database as defined in claim 29 wherein updating the asset management database with records accepted during the reconciling step further comprises writing the updated records without the identifying indicia.

31. The method of taking physical inventory and reconciling the physical inventory against an asset management database as defined in claim 30 further comprising, after the reconciling step is complete:

searching the asset management database for records having the identifying indicia; and

thereby

identifying assets that were not found during the physical inventory.

32. The method of taking physical inventory and reconciling the physical inventory against an asset management database as defined in claim 29 wherein placing an identifying indicia on a portion of each record in the asset management database further comprises appending a code to the end of each seat code.

33. The method of taking physical inventory and reconciling the physical inventory against an asset management database as defined in claim 32 wherein appending a code to the end of each seat code further comprises appending the letters “

WH”

to the end of each seat code.

34. A method of reconciling a physical inventory of assets against an asset management database and identifying assets not located in the physical inventory, the method comprising:

placing identifying indicia on each seat record in the asset management database;

taking the physical inventory using a portable bar code scanning device that saves physical inventory data in a data file within the portable bar code scanning device;

transferring the data file to a web server;

transforming the data file into an intermediate database;

reconciling records of the intermediate database against corresponding records in the asset management database;

writing seat records, associated with assets, to the asset management database without the identifying indicia; and

identifying assets not found during the physical inventory in the asset management database by identifying seat records having the identifying indicia.

35. The method of reconciling a physical inventory of assets against an asset management database and identifying assets not located in the physical inventory as defined in claim 34 wherein placing identifying indicia on each seat record in the asset management database further comprises appending a code to the end of each seat code.

36. The method of reconciling a physical inventory of assets against an asset management database and identifying assets not located in the physical inventory as defined in claim 35 wherein appending a code to the end of each seat code further comprises appending the letters “

WH”

to the end of each seat code.

37. The method of reconciling a physical inventory of assets against an asset management database and identifying assets not located in the physical inventory as defined in claim 34 wherein taking the physical inventory using a portable bar code scanning device that saves physical inventory data in a data file within the portable bar code scanning device further comprises, at a plurality of locations:

scanning a location code that uniquely identifies the location; and

scanning at least one asset code of an asset at the location.

38. The method of reconciling a physical inventory of assets against an asset management database and identifying assets not located in the physical inventory as defined in claim 34 wherein transferring the data file to a web server further comprises:

coupling the portable bar code scanning device to an internet connection; and

transferring the data file to the web server using an FTP program.

39. The method of reconciling a physical inventory of assets against an asset management database and identifying assets not located in the physical inventory as defined in claim 34 wherein reconciling records of the intermediate database against corresponding records in the asset management database further comprises:

making a copy of the asset management database residing on the web server;

reconciling records in the intermediate database against corresponding records in the copy of the asset management database.