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
Grid Company selection
Calculate (field FLGCLCCPY) |
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. |
Company (field CPY) |
This field displays the company code. |
Grid Site selection
Calculate (field FLGCLCFCY) |
Select this checkbox to run the calculation on this site. |
Site (field FCY) |
Identification code of the site. |
Grid Depreciation contexts
Calculate (field FLGCLCCNX) |
Select this checkbox to run the calculation on the context. |
Context (field CNX) |
This field displays the title of the depreciation context. |
FY start date (field DATSTRFIY) |
This field contains the financial year start date of the considered context. |
Period start (field DATSTRPER) |
This field contains the current period start date of the considered context. |
Options
Force the depreciation calculation (field FLGFASCLC) |
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. You must clear checkboxes individually remove all or one company, site, or context.
|
Company status |
Select this option to view the Status of contexts for the company on the line. |
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/Group menu. 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