How does Costpoint Fixed Assets deal with physical inventory processes?

Costpoint Fixed Assets includes a standard Import Asset Locations screen that enables you to import an ASCII file that has been produced by reading property bar code labels with a bar code scanner.

Using the Import Asset Locations screen, you can move Asset Master record location data from the ASCII input file into Costpoint Fixed Assets.

The System automatically compares the results of the scanned location data with the location data already residing in the Asset Master record and writes the "mis-matches" (exceptions such as an invalid asset/item number or invalid location data) to an Exceptions table. Once you have edited the exceptions, you can use the Import Asset Locations screen to import the corrected data from the Exceptions table to the Asset Master records.

You can specify the functions to be performed in conjunction with the file import, as follows:

  • Print a discrepancies report
  • Update location data in Asset Master records based on the results of the scan
  • Create audit trail records to capture changes made when location data was updated in Asset Master records
  • Create inventory "event" records in the optional Inventory Tracking "bucket"

(In addition to the automatically provided Date field, you can define labels for up to eight user-defined inventory categories, such as Condition, Inv Taken By , and so on. You can automatically populate inventory data using the Import Asset Locations screen in the Fixed Assets Interfaces menu and, in addition, you can manually add, edit delete, view, and report inventory data for your asset records as desired.)

Note: Deltek has developed a front end interface that automatically integrates with the Intermec 2400 series hand-held barcode scanning devices (models 2410, 2415, 2420, and 2425). More information about these scanners can be obtained by visiting the Intermec.com web site.

If you already own different Intermec scanner models or scanners from other manufacturers, you can still use all the functionality of the Import Asset Locations application by re-formatting the produced ASCII file into the prescribed file layout.