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 the Sage Fixed Assets—Tracking program. This category appears only if you use the current company 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	Use this field to 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]	Select this button to add the selected field(s) to the Report Columns box.
[Remove]	Select this button to remove the selected field(s) from the Report Columns box.
Report Columns	The system uses this field to display 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 selecting the View Report Layout tab.
Field	The system uses this column to display 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	The system uses this column to display the column header for the field. You can select 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	The system uses this column to display the width of the column in inches. You can select 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?	The system uses this field to display 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 Arrow] / [Down Arrow]	Select 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.
Column Spacing	Use this field to enter the space, in inches, between columns on the report.
Total Width	The system uses this field to display 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	The system uses this field to display 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.
(Over)/Under	The system uses this field to display 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)	Use these fields to set the page orientation of the report.
8.5	Select this option button if you want the report to have an overall page width based on 8.5 inches.
11	Select this option button if you want the report to have an overall page width based on 11 inches.
Margins: (inches)	Use these fields to enter the left and right margins. Changing each of these fields affects the amount of data that can be displayed on the report.
Left	Select the up and down arrows to specify the left margin of the report. Tip: If you plan to place your reports in binders, you may want to increase the left margin to avoid cropping your data.
Right	Select the up and down arrows to specify the right margin of the report.
[Restore Defaults]	Select 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 the Sage Fixed Assets—Tracking program. This category appears only if you use the current company 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

Use this field to 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]

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

[Remove]

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

Report Columns

The system uses this field to display 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 selecting the View Report Layout tab.

Field

The system uses this column to display 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

The system uses this column to display the column header for the field. You can select 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

The system uses this column to display the width of the column in inches. You can select 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?

The system uses this field to display 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 Arrow] / [Down Arrow]

Select 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.

Column Spacing

Use this field to enter the space, in inches, between columns on the report.

Total Width

The system uses this field to display 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

The system uses this field to display 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.

(Over)/Under

The system uses this field to display 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)

Use these fields to set the page orientation of the report.

8.5

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

11

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

Margins: (inches)

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

Left

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

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

Right

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

[Restore Defaults]

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

Edit Columns Tab

Items in this window