Generating Report on Depreciation

Select the “Report on Depreciation” link under “EDK - Reports for Fixed Assets Management”.

The “Report on Depreciation” page appears.

Enter the following fields :

Report Option	Use the drop-down list box to specify the report option. The system lists the following options: Select the “Processed Depreciation” option to view depreciation details that have been processed. Select the “Simulate Depreciation” option to view depreciation details that have not been processed. By default the system displays “Simulate Depreciation”.
Depreciation Book Code	Use the drop-down list box to select the book type for which depreciation details must be viewed. The system displays the option: “Corp”, along with all the depreciation books defined for the login OU company. The system displays “Corp” by default.
Finance Book	Use the drop-down list box to select the finance book for which depreciation details must be viewed. The system displays a list of all the posting finance books that are applicable to the login organization unit if “Corp” is specified as the book type.
Financial Year	Use the drop-down list box to select the financial year of the company for which you want to view the report on depreciation. The system displays all the financial years that are open and provisionally closed. By default, the system displays the earliest open year in this field if “Processed Depreciation” is specified as the report option; otherwise the system leaves the field blank.
Financial Period From	Use the drop-down list box to select the financial period from which depreciation details must be viewed. The system lists all the financial periods associated to the financial year selected. Note that the value specified in this field must be less than the value specified in the “Financial Period To” field. By default, the system displays the period prior to the current financial period if the current year is specified as the financial year, otherwise the system displays the last financial period.
Financial Period To	Use the drop-down list box to select the financial period up to which depreciation details must be viewed. The system lists all the financial periods associated to the financial year selected, if “Processed Depreciation” is specified as the report option. Otherwise, the system lists all the open financial periods including the current financial period.
Simulation Basis	Use the drop-down list box to specify the basis on which you want to simulate the report on depreciation. The system lists the following options: Asset Class - Select this option if you want to simulate a depreciation report based on the asset class Asset No - Select this option if you want to simulate a depreciation report based on the asset number. Cost Center - Select this option if you want to simulate a depreciation report based on the cost center to which it belongs. Balance of Assets - Select this option if you want to simulate a depreciation report based on all the assets that have not been processed for depreciation. Ensure that a value is specified in this field, if “Simulate Depreciation” is specified as the report option. By default the system leaves the field blank.
Simulation Upto Date	The date until which you want to view the simulated report on depreciation (Date Format). Ensure the following: The current period is specified as the “Financial Period To” if a value is to be specified in this field. No value is specified in this field if “Processed Depreciation” is specified as the report option.
Asset No.	Enter the asset number for which depreciation needs to be viewed. The system generates the report on depreciation for the asset numbers specified in the “Asset No.” field. Ensure that a value is specified in this field if “Asset No.” is specified as the “Simulation Basis”. Help facility available
Asset Class	Use the drop-down list box to select the asset class for which the depreciation details need to be viewed. The system generates the report on depreciation for the asset class selected. Note that if you want to view the depreciation details for all the asset classes, select the option ‘ALL’. By default, the system displays “All”.
Depreciation Category	Use the drop-down list box to select the depreciation category. The system lists all the depreciation categories defined in the “Create Depreciation Setup” activity of the “Asset Depreciation Setup” business component. Note that if an asset class is specified, the system lists only those categories that are mapped to that asset class. By default the system leaves the field blank.
Cost Center	The code identifying the cost center where the assets are located, for which you want to generate the report on depreciation. The value entered here must have been defined in the “Create Cost Center/Unit” activity of the “Cost Setup” business component. Ensure that a value is specified in this field if “Cost Center” is specified as the “Simulation Basis”. Help facility available
Process Run # From	Enter the process run number from which you want to view the depreciation report. Note that the value specified in this field must be lesser than the run number specified in the “Process Run # To” field. By default the system leaves the field blank.
Process Run # To	Enter the process run number until which you want to view the depreciation report. By default the system leaves the field blank.
Process Run Status	The status of the process run for which you want to view depreciation details. The system lists the options, “Processed”, “Confirmed”, “Deleted”, “Partially Confirmed”, “Partially Processed”, and “Reversed”. The system displays “Processed” by default if “Processed Depreciation” is specified as the report option. Otherwise the system leaves the field blank.
Report Detail	The level of detail at which you want to generate the report on depreciation. The system displays the following options; Asset-Tag Level – Select this option if you want to view depreciation details against each tag. Cap. Document Level – Select this option if you want to view depreciation details against each capitalization document. Period Level - Select this option if you want to view all the depreciation details grouped for a particular period. The system displays “Asset-Tag Level” by default.
Include Suspension	Indicate whether you want to view depreciation details for suspension periods also. You can select either “Yes” or “No”. The system displays “Yes” by default.

Click the “Generate Report” push button to generate the report on depreciation in Excel format.

The system performs the following:

While computing depreciation for the assets, the Financial Year Start Date is considered as the start date and the Financial Period End date is considered as the end date.
Charges the depreciation on the asset for a full period if the convention is mid month and the in-service date of the asset falls on or before the 15th of the depreciation processing period.
Does not calculate any depreciation if the in-service date of the asset falls after the 15th of the depreciation processing period.