Fixed Asset - Projected Value Report

With the Fixed Asset - Projected Value report, you see calculated future depreciation and book value. You can print the report for one depreciation book at a time.

The program calculates projected depreciation for two periods:

Open the Fixed Asset - Projected Value report request form.

If you want to include more information, you can select additional fields to be included in the report. To do this, in the Field field, press F3, click the AssistButton and then select the relevant field(s). You can set filters on any of the fields. If you do not set any filters, the report will include all your records.

To print the report, click the Print button. To see the report on screen, click Preview. If you want to save your report and print it later, click Cancel (the program automatically saves your report).

To filter the information in the report, in the Filter field, fill in the relevant information 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: Leave the field blank if you want to include budgeted assets in the batch job, enter No if you want to exclude budgeted assets and Yes if you only want to copy budgeted assets.

Click the up-arrow in the lower left-hand corner of the window to see the table with the results of the filters you have set for the report.

Options

Depreciation Book: Select the code for the depreciation book to be included in the report.

First Depreciation Date: Enter the date to be used as the first date in the period for which you want to calculate projected depreciation.

Last Depreciation Date: Enter the date to be used as the last date in the period for which you want to calculate projected depreciation. This date must be later than the date in the First Depreciation Date field above.

Number of Days: Enter the length of the periods between the first depreciation date and the last depreciation date. The program will then calculate depreciation for each period. If you leave this field blank, the program automatically sets the contents of this field to equal the number of days in a fiscal year, normally 360.

No. of Days in First Period: Enter the number of days that must be used for calculating the depreciation as of the first depreciation date, regardless of the actual number of days from the last depreciation entry. The number you enter in this field will not affect the total number of days from the starting date to the ending date.

Posted Entries From: Enter a date if you want the report to include posted entries. The report will include all types of posted entries that have been posted from that FA posting date.

Group Totals: 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.

Copy to G/L Budget Name: Select the name of the budget you want to copy projected values to.

Insert Bal. Account: Click to insert a check mark if you want the program to automatically insert budget entries with balancing accounts.

Print per Fixed Asset: Click to insert a check mark if you want the report to print information separately for each fixed asset.

Projected Disposal: Click to insert a check mark if you want the report to include projected disposals: the contents of the Projected Proceeds on Disposal field and the Projected Disposal Date field on the FA depreciation book.

Print Amounts per Date: Click to insert a check mark if you want the program to include on the last page of the report a summary of the calculated depreciation for all assets.

Use Accounting Period: Click to insert a check mark if you want the periods between the starting date and the ending date to correspond to the accounting periods you have specified in the Accounting Period table. When you click this field, the Number of Days field will be cleared.



© 2009 Microsoft Corporation. All rights reserved.