Depreciation calculations
Use this function to launch a mass calculation the actual asset depreciation and provisions renewing assets in concession for one or several sites of a company or group of companies. This calculation is performed for the selected contexts.
As a general rule, a unit calculation is automatically submitted on creation, modification, or any other action performed on an asset: revision of its depreciation basis, residual value, method change, impairment loss, revaluation, and so on. In this case, there is no need to relaunch the depreciation mass calculation.
Some situations require a mass calculation:
- Modifying certain settings:
- Dividing a fiscal year into periods
- Creating a new depreciation plan
- Modifying a parameter with an impact on the depreciation calculation of a group of assets, which includes parameters for a depreciation method or a depreciation context. - Closing of a fiscal year. The calculation is used to extend the depreciation plan according to the number of fiscal years to be calculated as defined in the Depreciation contexts function, by generating the new records in the DEPREC - Depreciation expense table. The existing records are not recalculated.
You can run a simulated calculation and select the assets to be calculated, the calculation by plan, and the calculation horizon as well as the number of fiscal years broken down into periods to calculate.
Refer to Depreciation simulation
The calculation and closing processes are automatically blocked when the number of managed assets exceeds by 5 percent the maximum number of assets authorized by the limits of the license.
This information is displayed at the function level in the Status of contexts function.
Prerequisites
Refer to documentation Implementation
Screen management
Inactive assets are implicitly excluded from the calculation.
Tab Entry creation screen
Fields
The following fields are present on this tab :
Grid Company selection
| This flag makes it possible to specify that a calculation must be performed on the company. The selection only concerns the company; it is necessary to select unit by unit each site concerned and then each context. |
| This field displays the company code. |
Grid Site selection
| Select this checkbox to run the calculation on this site. |
| Identification code of the site. |
Grid Depreciation contexts
| Select this checkbox to run the calculation on the context. |
| This field displays the title of the depreciation context. |
| This field contains the financial year start date of the considered context. |
| This field contains the current period start date of the considered context. |
Options
|
|
Close
Action icon
All the cpy
Select this option to include all depreciation contexts and sites for the company on the line and selects them in the related grids. You cannot select this option again to clear any or all selections. You need to clear each checkbox individually.
All companies
Select this option to include all companies in the grid. Their sites and contexts are also selected automatically.
Company status
Select this option to view the Status of contexts for the company on the line.
Close
Processing description
For each depreciation plan of the selected context(s), the calculation process is based on the current period, or on the depreciation start period, if the depreciation start date falls after the current period, within the limits of the fiscal year number defined in the Status of contexts function. This number includes current and next fiscal years.
When an asset has been acquired during a previous fiscal year, and that the depreciation total is not available, the process takes control of the depreciation anteriority calculation in order to obtain this value. This situation should only occur during a folder transfer phase.
Calculation optimization
An optimization mechanism of calculations is set up at the level of each context, plan and asset, through the positioning of calculation flags. This mechanism, associated to parameters used to reduce and distribute the operating weight of the calculation, is used to reduce the calculation processing times.
For more information concerning the execution of the calculation optimization, refer to the attached document: Calculation optimization.
Notes:
- From the Action icon on the line, you can view the Status of contexts.
- The asset status regarding the calculation is displayed in the Depreciation plan function
Process log file
A log file is automatically displayed on process completion. The amount of detail in the log file is specified by the value of the NIVTRACE - Log file level parameter (AAS chapter, MIS group). The log file automatically recaps the calculation parameters and, for each calculated company: the calculated contexts, the number of assets to calculate regarding the closing of all contexts (before or after process), the number of calculated assets on the selected contexts as well as any error messages.
It also displays, when necessary, the list of pending setting modifications which are automatically processed before calculation. This process, which is required to change the status of the contexts plans and assets concerned by these modifications is not calculated, and can be separated from the calculation and launched on its own using the Pending Modifications function. Otherwise, it is automatically performed before calculation.
You can view and print the log file any time from the Supervisor function in the Reports > Print/Groupmenu. Select the ATRACE - Print log file report code from the list.
Preset queries
The following preset queries are available as standard in the reference folder:
Code | Title | Contents |
FXENDEX | Depreciation end fiscal year | List of the assets that will be completely depreciated (from an accounting point of view) in the current FY. |
FXVNVR | NV assets = Residual Value | List of the assets for which the net value equals the specified residual value. |
Batch task
This function can be run in batch mode. The standard task FASCALCUL is provided for that purpose.
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
"Company calculation aborted. Impossibility to reserve the whole company for the processing"
All company records must be unlocked to achieve the calculation process.
The message is displayed when the maximum number of processing submission attempts, determined by the NBESSCLC parameter - Number of calculation attempts is reached.
"Too many companies selected simultaneously"
When the calculation process is carried out via the batch server, the parameters of the function must be saved until the actual launch of the processing on the server.
The limit on the global information that can be saved is 500, a control determines when choosing each company if this limit is exceeded; when it does this message is displayed preventing the selection of the company. The process has to be launched more than once. The calculation takes into account the number of contexts to be calculated; the number of authorized companies can vary according to the selected companies.
"Operation impossible: at least a context of company $1$ is desynchronized from the Accounting"
A consistency check is performed between the FY/period breakdown of Accounting and the one of Fixed Assets, when the ACCPERCTL - Accounting period control parameter is set to Yes. When depreciation contexts of a company are not synchronized with accounting, the calculation of this company is not authorized. For the calculation to be carried out, the consistency of the FY/period breakdown must be ensured by launching the Context synchronization processing