Versions 2022.1 and higher of Sage Fixed Assets Single User, Network, and Premier let you dispose of active assets in bulk from a spreadsheet. You build an import file, map the fields to Sage Fixed Assets, validate the data, and then import
Note: function is only available on a subscription support plan. To move to a subscription plan, call Sage Fixed Assets Sales at 800-368-2405.
Resolution
Before you start
Make a backup. See How to back up a company. A template is installed with the product. Find Import Full and Part Disposals Template.xls in the product folder on the workstation:
Sage Fixed Assets Depreciation
Sage Fixed Assets Depreciation - Network
Sage Fixed Assets Premier Depreciation
The default path is C:\Program Files (x86)\Sage Fixed Assets\<product>\User Files. Keep the import file and the import mapping file on a drive local to the workstation.
Step 1: Build the import file in Excel
Set up a spreadsheet with the fields below. Field order does not matter. You map each field to Sage Fixed Assets later.
Required fields for all disposals:
System Number
Disposal Date
Disposal Method (required if mapped, see the disposal method codes below)
Optional fields for all disposals:
Cash Proceeds
Non-Cash Proceeds
Expenses of Sale
Extra required fields for a partial disposal:
Partial-Book
Partial-Amount
Extra optional field for a partial disposal:
Partial-Description
Save the file as xlsx, xls, or CSV to a known location. The default location is the User Files folder listed above.
Step 2: Run Custom Import in Sage Fixed Assets
Select File, Company Utilities, Custom Import.
Select Browse, go to the import file, choose the file format, select the file, then select Open.
Select Next.
Choose the Company and database to import into, then select Next.
Select Dispose Asset, then select Next.
Choose a field map option:
Create New Field Map for a first-time import, or for an import file with a different field arrangement.
Use Saved Field Map to reuse an existing map file (*.imp) that matches the import file. You can edit the map here if the import file has changed.
Map the fields, then select Next.
Select Validate to check the import file and mapping. Only valid records import. Invalid records do not.
Review the Import Exception report. Fix any errors before you continue. You can ignore warnings.
When validation shows no invalid records, select Import.
NOTE:
A sample map file, Import Full and Part Disposals Template.imp, is stored next to the Excel template in the User Files folder.