Edit Columns Tab

Item	Notes
Field Category	Select the type of fields you want displayed in the field list. This option allows you to limit the number of fields in the list so you don’t have to scroll through them all.
All Fields	Select this category to display all available fields in the program.
Book Info Fields	Select this category to display additional data entry fields that affect depreciation calculations (in addition to the fields in the Critical Fields category). Most of these fields can have different values in each book.
Report Specific Fields	Select this category to display only the fields that are specially calculated for the selected report. This category contains fields only after you have removed fields from the Report Columns box.
Critical Fields	Select this category to display only the fields that are required to calculate depreciation.
Depreciation Fields	Select this category to display only the fields that contain system-calculated depreciation amounts or information about those amounts (such as the dates for which depreciation was calculated).
Disposal Fields	Select this category to display only fields that pertain to asset disposals.
General Info Fields	Select this category to display only the fields that contain general information about an asset, such as its location, but do not affect the asset’s depreciation calculations.
Tracking Fields	Select this category to display only the fields that are unique to Sage Fixed Assets—Tracking. This category appears only if you use the current organization in Sage Fixed Assets—Tracking.
Transfer Fields (Child)	Select this category to display only fields that pertain to assets that have been created as a result of a transfer.
Transfer Fields (Parent)	Select this category to display only fields that pertain to original assets that have been transferred.
Field List Box	Select the data that you want to include as columns on the report. You can select more than one field at a time. You are limited to a maximum of 20 columns on each report. You can include up to five additional currency columns that you can total to each standard report.
[Add]	Click this button to add the selected field(s) to the Report Columns box.
[Remove]	Click this button to remove the selected field(s) from the Report Columns box.
Report Columns	This field displays the columns that will be displayed on the report. The system displays the leftmost column on the first row, the second column on the second row, and so on. After you make changes to the report columns, you can see how the report will appear by clicking the View Report Layout tab.
Field	This column displays the name of the field in the system. If you have changed the name of the field using the Customize Fields window, the new field name appears in this list. The system displays the new fields added to the report in bold, to distinguish them from the original columns.
Header	This column displays the column header for the field. You can click on the column header and change it. To create a two-line column header, insert a double pipe symbol (\|\|) where you want the break in the column header.
Width	This column displays the width of the column in inches. You can click on the width and change it. If you want to change the overall size of the report in order to display wider columns, you can change the margins and change the page orientation to landscape.
Total?	This field displays whether a field is totaled and subtotaled. The system displays a check mark when a field is totaled and subtotaled; otherwise, the column is blank.
[Up/Down Arrow]	Click these buttons to move the selected field either up or down in the list. As you move the field up, the column is moved to the left on the report.
Total Column Widths	This field displays the total of the column widths without the spaces between the columns.
Column Spacing	Enter the space, in inches, between columns on the report.
Total Width	This field displays the total of the column widths and the space between the columns. (This field does not include the width of the left and right margins.)
Maximum Width	This field displays the total space available for columns and space between columns. This amount is the width of the paper minus the space for the left and right margins. The system displays this amount in red if you have exceeded the maximum width.
(Over)/Under	This field displays the amount of space that is available for use on the report. This amount is the maximum width minus the total width. The system displays negative amounts in red.
Paper Width: (inches)	Set the page orientation of the report.
8.5	Click this option button if you want the report to have an overall page width based on 8.5 inches.
11	Click this option button if you want the report to have an overall page width based on 11 inches.
Margins: (inches)	Enter the left and right margins. Changing each of these fields affects the amount of data that can be displayed on the report.
Left	Click the up and down arrows to specify the left margin of the report. Tip: If you want to place the reports in binders, you may want to increase the left margin to avoid cropping data.
Right	Click the up and down arrows to specify the right margin of the report.
[Restore Defaults]	Click this button to restore the original settings for the standard report on which the customized report is based.

Field Category

Select the type of fields you want displayed in the field list. This option allows you to limit the number of fields in the list so you don’t have to scroll through them all.

All Fields

Select this category to display all available fields in the program.

Book Info Fields

Select this category to display additional data entry fields that affect depreciation calculations (in addition to the fields in the Critical Fields category). Most of these fields can have different values in each book.

Report Specific Fields

Select this category to display only the fields that are specially calculated for the selected report. This category contains fields only after you have removed fields from the Report Columns box.

Critical Fields

Select this category to display only the fields that are required to calculate depreciation.

Depreciation Fields

Select this category to display only the fields that contain system-calculated depreciation amounts or information about those amounts (such as the dates for which depreciation was calculated).

Disposal Fields

Select this category to display only fields that pertain to asset disposals.

General Info Fields

Select this category to display only the fields that contain general information about an asset, such as its location, but do not affect the asset’s depreciation calculations.

Tracking Fields

Select this category to display only the fields that are unique to Sage Fixed Assets—Tracking. This category appears only if you use the current organization in Sage Fixed Assets—Tracking.

Transfer Fields (Child)

Select this category to display only fields that pertain to assets that have been created as a result of a transfer.

Transfer Fields (Parent)

Select this category to display only fields that pertain to original assets that have been transferred.

Field List Box

Select the data that you want to include as columns on the report. You can select more than one field at a time. You are limited to a maximum of 20 columns on each report. You can include up to five additional currency columns that you can total to each standard report.

[Add]

Click this button to add the selected field(s) to the Report Columns box.

[Remove]

Click this button to remove the selected field(s) from the Report Columns box.

Report Columns

This field displays the columns that will be displayed on the report. The system displays the leftmost column on the first row, the second column on the second row, and so on. After you make changes to the report columns, you can see how the report will appear by clicking the View Report Layout tab.

Field

This column displays the name of the field in the system. If you have changed the name of the field using the Customize Fields window, the new field name appears in this list. The system displays the new fields added to the report in bold, to distinguish them from the original columns.

Header

This column displays the column header for the field. You can click on the column header and change it. To create a two-line column header, insert a double pipe symbol (||) where you want the break in the column header.

Width

This column displays the width of the column in inches. You can click on the width and change it. If you want to change the overall size of the report in order to display wider columns, you can change the margins and change the page orientation to landscape.

Total?

This field displays whether a field is totaled and subtotaled. The system displays a check mark when a field is totaled and subtotaled; otherwise, the column is blank.

[Up/Down Arrow]

Click these buttons to move the selected field either up or down in the list. As you move the field up, the column is moved to the left on the report.

Total Column Widths

This field displays the total of the column widths without the spaces between the columns.

Column Spacing

Enter the space, in inches, between columns on the report.

Total Width

This field displays the total of the column widths and the space between the columns. (This field does not include the width of the left and right margins.)

Maximum Width

This field displays the total space available for columns and space between columns. This amount is the width of the paper minus the space for the left and right margins. The system displays this amount in red if you have exceeded the maximum width.

(Over)/Under

This field displays the amount of space that is available for use on the report. This amount is the maximum width minus the total width. The system displays negative amounts in red.

Paper Width: (inches)

Set the page orientation of the report.

8.5

Click this option button if you want the report to have an overall page width based on 8.5 inches.

11

Click this option button if you want the report to have an overall page width based on 11 inches.

Margins: (inches)

Enter the left and right margins. Changing each of these fields affects the amount of data that can be displayed on the report.

Left

Click the up and down arrows to specify the left margin of the report.

Tip: If you want to place the reports in binders, you may want to increase the left margin to avoid cropping data.

Right

Click the up and down arrows to specify the right margin of the report.

[Restore Defaults]

Click this button to restore the original settings for the standard report on which the customized report is based.

Edit Columns Tab

Items on this tab