Fixed Asset - Analysis Report

This report shows an analysis of your fixed assets with various types of data for both individual assets and groups of assets. On the Fixed Assets tab, you can set filters if you want the report to include only certain fixed assets. On the Options tab, you can choose among a number of options to tailor the report to meet specific needs.

Note that all dates in relation to this report are FA posting dates. (The Fixed Asset - G/L Analysis, which is similar, uses posting dates. The amounts in the report are calculated from FA ledger entries.

Fill in the fields on the tabs as follows:

Fixed Asset

No.: Enter the numbers of the fixed assets to be included in the report. To see the existing numbers, click the AssistButton in the Filter field.

FA Class Code: Enter the codes for the FA classes to be included in the report. To see the existing codes, click the AssistButton in the Filter field.

FA Subclass Code: Enter the codes for the FA subclasses to be included in the report. To see the existing codes, click the AssistButton in the Filter field.

Budgeted Asset: Enter Yes in the Filter field if you want the report to include only budgeted assets. If you do not want budgeted assets to be included in the batch job, enter No in this field.

Click the up-arrow at the lower left-hand corner of the window to see the result of the filters you have set for the report.

Options

Depreciation Book: Click the AssistButton and select the code for the depreciation book to be included in the report.

Starting Date: In this field, you must enter the date you want the report to start.

Ending Date: In this field, you must enter the date you want the report to end.

Date Field 1 and Date Field 2: The report has two columns in which two types of dates can be displayed. In each of these fields, click the AssistButton and select one of the nine available types.

Amount Field 1, Amount Field 2 and Amount Field 3: The report has three columns in which three types of amounts can be displayed. In each of these fields, click the AssistButton and select one of the 11 available types.

In the field to the right of each amount field, click the AssistButton and then select how the amounts will be calculated. The options refer to the starting date and the ending date. (Net Change means the period between these two dates.)

Group Totals: In this field, you can enter a group type if you want the report to group the fixed assets and print group totals. For example, if you have set up six FA classes, then select the FA Class option to have group totals printed for each of the six class codes. To see the available options, click the AssistButton. If you do not want group totals to be printed, select the blank option.

Print per Fixed Asset: Click this field to enter a check mark if you want the report to print a line for each fixed asset.

Only Sold Assets: Click this field to enter a check mark if you want the report to show information only for sold fixed assets.

Budget Report: Click this field to enter a check mark if you want the report to calculate future depreciation and book value. This is valid only if you have selected "Depreciation" and "Book Value" for Amount Field 1, 2 or 3.

Click the Print button to print the report. If you want to see the report on the screen before printing, click the Preview button. If you do not want to print the report now, click Cancel to close the window.



© 2009 Microsoft Corporation. All rights reserved.