Import Asset Disposals

The Import Asset Disposals application facilitates the initialization of large numbers of fixed asset disposal edit records into Costpoint.

You typically process this screen when moving disposal edit records from one Costpoint database to another, but you can also use it to import disposal edit records from a legacy system. The application imports a delimited ASCII file of fixed assets disposal data generated by the Export Asset Disposals application when importing with a file. Users can also script data into import tables set up for this purpose. Scripting the import disposal data into the import tables would generally be done when setting up disposal edit records from a legacy system. In either case, before the data reaches the fixed assets tables, the application performs validations that are otherwise available only when manually adding records one at a time through the Manage Disposal Transactions screen or via the Create Multiple Disposal Transactions screen.

The Import Asset Disposals application stops users from importing data from a file with a fiscal year and period in the header row that does not match Costpoint's Current Fiscal Year and Current Period as displayed on the Configure Posting Settings screen. The Import Asset Disposals application only uploads an input file with a fiscal year and period that matches the Posting Settings in the “receiver” Costpoint database. This feature ensures that mass disposal record transfers from one Costpoint database to another are uploaded into the receiver database in the same Fixed Assets year and period in which the assets were downloaded from the provider database.

The timing of the upload is important. Asset disposal records must be available for posting in the correct period to prevent problems in Costpoint. All records that have depreciation posted against them need to be imported in the correct Fixed Assets Year and Period in order to be posted in a timely manner and thus avoid incorrectly recorded depreciation expense on depreciable assets.

There are two ways to work with input files in Costpoint:

  • You can access the input file from the network by using Alternate File Locations.
  • You can upload the input file to the Costpoint database; in which case, no further access to network folders is necessary.

If you decide to use the first option, click in the File Location field to select an alternate file location. If you choose the second option, leave the File Location field blank and use the File Upload Manager to upload the input file to the Costpoint database.