See also: Importing asset data from an Excel spreadsheet
Use the Map Field dialog to map a spreadsheet column to the appropriate field in Fixed Assets CS.
To open this dialog, click the Map Field button for any column in the Data to import grid in the Import Field Map dialog.
Fields & buttons
The read-only field at the top of the Map Field dialog contains the letter of the current column. Use the single arrow buttons to either side of this field to move to the previous or next column. Use the double-arrow buttons to move to the first or last column.
Available group box
From the drop-down list, select an import category to view the list of fields that are available for that category. (Categories include: General, Association, Tax, Book, State, AMT, Other, ACE, and Other Trt1 - Other Trt4.)
Lists all of the fields that are available to import for the selected category. Double-click the field to move it to the Selected pane for the current column.
Selected group box
This read-only field displays the import category of the field that appears in the Selected pane.
This field displays the name of the field that is selected to map to the current spreadsheet column. You can modify the entry in this field only when Association is selected in the Category field and you move one of the custom association fields (Custom 1 - Custom 10) to the Selected pane.