Use this window to perform the mass modification of the account allocation for all the assets or for a selection of assets, belonging to one or more financial sites in a single company.
This change can affect the Holding type, the classification of the assets as Held for sale, the Asset group and/or the Accounting code, the Date put into service. It is used to perform start-up operations: transfer of a Fixed assets in progress account to a Fixed assets in service account.
If the section associations are defined for the Asset object, any change of the accounting allocation can generate method changes in one or more depreciation plans.
This window can also be used to view the new depreciation methods and to carry out any modification required.
Before being carried out in real mode, the processing can be run in simulation mode in order to assess the result via the report. To avoid having to re-enter the parameters at the time of each simulated then actual process start, the parameters linked to the account allocation change as well as the selection criteria can be saved.
The assets for which an allocation change is prohibited are excluded implicitly from the process. These are:
- inactive assets,
- assets with the In template holding type,
- assets which have been subject to an actual asset issue,
- assets in the process of an intra-group transfer,
Refer to documentation Implementation
This function is composed of:
The management is the same for this window as for all the mass process functions that can be applied to assets.
First of all, the user needs to set up the process or to recall an existing setup using the button. The existing setup will have been previously saved under a Memo code.
The setup of the processing consists in:
- Entering the processing options. By default, the process is carried out in Simulation mode and generates a Detailed Log file displaying the different parameters applied at the time of the process execution as well as the list of updated assets.
- Selecting the company and potential other financial sites where the assets are registered.
- To enter the new accounting allocations.
- To select the depreciation plans on which the deprecation methods determined by applying the field associations or entered manually are to be applied.
- Carrying out if necessary a selection of the assets concerned by the process.
Note: when the setup of a processing is completed, it is possible to save it under an identification code using the button. It is then possible to recall it at a later date for use in a method change.
Once the setup is done, it is possible to:
Any modification of one or more depreciation parameters carried out on an asset, must be validated by the button. To cancel the modifications in progress on the asset, click .
Once the manual adjustments are completed, click the button to close the control window; the system displays again the entry window for parameters, which enables the user either to validate the mass update by clicking , or to abort the update by clicking the button.
An accounting allocation change performs the following operations:
Presentation
The header contains the process options and is used to select the company as well as the site(s) that are referenced to the assets to be processed.
Close
Fields
The following fields are present on this tab :
Options
|
This box is checked by default. It specifies that the processing is carried out in simulation mode. In this case, the controls and the process are carried out but no modification of the database is recorded. |
|
This indicator can be accessed only when one or several reports are linked to the massive process. In this case, the activation of this indicator enables the user to print these reports. |
|
A log file is automatically displayed on process completion, showing the processing parameters. A Statistics section gives the number of selected assets, the number of assets updated as well as the number of assets not processed due to an error. Assets with errors are listed with their error reason. The viewing and printing of log files are possible at any time via the report code ATRACE - Print log file print request, obtained from the Supervisor function in the Print/Group print menu. |
Grid Company selection
|
Help common to all the mass processings.
|
|
The Identification Code for the company. |
Grid Site selection
|
The grid displays the list of the sites attached to the companies and for which the user has authorizations. |
|
Identification Code for the company which the site is linked to. |
|
Identification code of the site. |
Close
Note: the viewing and printing of the log files is possible at any time via the Print log file print request of the ATRACE report code, obtained from the Supervisor function in the Print/Group print menu.
These tables display both the list of managed companies for which the user is authorized and the list of financial sites corresponding to these companies where the user is authorized.
When the company parameter ACCPERCTL - Control of accounting periods (chapter AAS, group CPT) has Yes for value, the company is not displayed in the list as soon as at least of one its context is not synchronized with the accounting period/fiscal breakdown. In this case, it is necessary to launch the Context synchronization process.
The desynchronization status of a context can be viewed on the Detailed status of contexts, Calculation tab (the value of the Modification type field is set to: CNX and the value of the field Modified parameter is DESYNC).
It is necessary to select the company and the sites in which the assets involved in the processing, are registered. After the selection of the company, all the sites linked to the company are selected by default. The user can de-select those that are not concerned by the processing.
Provided they belong to the same company, the site(s) involved in the processing can be directly selected, in which case the company to which they belong is automatically selected.
Reminder: the assets must be registered in sites attached to the same company. Selecting a second company, or sites linked to another company, leads to the de-selection of the first company selected, after validation of a confirmation message.
After having selected the company or the site(s), it is possible to refine the selection by entering other selection criteria in the dedicated Extended selection tab.
Presentation
This tab is used:
The effective date of the allocation change is automatically determined as follows:
Close
Fields
The following fields are present on this tab :
Transfer parameters
|
This field is used to enter the reason for an account posting change. This information is mandatory. |
Transfer type
|
This indicator is linked to the field that follows. It enables the user to force the value of the field when it is activated. |
|
Help common to the single and mass processes for the account posting change. |
|
Help shared by the unit and mass processings of accounting allocation change. |
|
Help shared by the unit and mass processings of accounting allocation change. Classifying an asset as held for sale stops the depreciation of the asset for each IAS/IFRS plan and changes the depreciation method to 'Residual'. If the classification date is greater than the current period end, the method will not go to 'Residual' upon closing the period containing the classification date. Prior to update 8.0.0: |
|
Use this field to specify the sufficient value which is expected for the sale when a sales date is entered in the Classified for sale field. It can only be accessed when the Asset held for sale option is checked. |
|
  |
|
This indicator is linked to the field that follows. It enables the user to force the value of the field when it is activated. |
|
Help shared by the unit and mass processings of accounting allocation change. The definition screen of the Asset groups, which can be accessed by right-clicking the field, can be used to: |
|
This indicator is linked to the field that follows. It enables the user to force the value of the field when it is activated. |
|
Help shared by the unit and mass processings of accounting allocation change. |
|
Help shared by the unit and mass processings of accounting allocation change. |
|
This field, non modifiable, displays the nature of the CoA account. |
|
Help shared by the unit and mass processings of accounting allocation change.
|
|
This field displays the IAS/IFRS account, i.e. the accounting classification towards the IAS/IFRS national norms. It is loaded with the IAS/IFRS fixed asset account, defined at the level of the Accounting code it cannot be entered. |
|
This field displays the nature of the IAS/IFRS account. |
Close
Presentation
This tab contains a table with as many lines as there are depreciation plans managed by the company. It is used to:
Close
Fields
The following fields are present on this tab :
Grid New deprec methods
|
Indicator activated by double-click, which enables the user to precise the change of method generated by the modification of the account posting (Group and/or Accounting code) must be applied to the plan. |
|
The code for the depreciation plan. |
|
Help common to the single and mass processes for the account posting change.
Specificities: when it corresponds to a first use, the account posting change is necessarily effective on the Depreciation start date. |
|
Help common to the single and mass processes for the account posting change. |
|
When set to Yes, this forcing indicator enables to force the value of the field to which it is associated. |
|
Help shared by the unit and mass processings of accounting allocation change. |
|
  |
|
Help common to the single and mass processes for the account posting change. The choice of the mode is submitted to the following restrictions:
The modification of the amortization mode can lead to the modification of the Depreciation start date of the plan and its loading, according to the setup carried out at the level of the Depreciation method, either with the First use date, or with the Purchase date, or with the Posting date. |
|
  |
|
  |
|
  |
|
Upon opening the window, this indicator, if set to Yes, signals that the value of the field to which it is linked, has been updated on applying the field association. It can only be modified if the Process indicator is active. If set to Yes, the indicator enables to enter or change this value. |
|
Help common to the single and mass processes for the account posting change. The rules for the entry and the value of the depreciation duration are a function of the depreciation method entered:
|
|
  |
|
Upon opening the window, this indicator, if set to Yes, signals that the value of the field to which it is linked, has been updated on applying the field association. It can only be modified if the Process indicator is active. If set to Yes, the indicator enables to enter or change this value. |
|
Help common to the single and mass processes for the account posting change. The rules for the entry of the depreciation rate are a function of the depreciation method entered:
|
|
When set to Yes, this indicator enables to force the value of the field to which it is associated. It can only be modified if the Process indicator is active for the plan. |
|
Help common to the single and mass processes for the account posting change. This field is linked with the management of the IT (Ordinario/Anticipato) mode. It is displayed only if the mode is allowed for company's country and can be entered only if the Maj flag is set to Yes. It is used to enter the depreciation rate used by the IT depreciation method (Ordinario/Anticipato) in order to calculate the Anticipato depreciation.
|
|
When set to Yes, this indicator enables to force the value of the field to which it is associated. It can only be modified if the Process indicator is active for the plan. |
|
Help common to the single and mass processes for the account posting change. |
|
Upon opening the window, this indicator, if set to Yes, signals that the value of the field to which it is linked, has been updated on applying the field association. It can only be modified if the Process indicator is active. If set to Yes, the indicator enables to enter or change this value. |
|
Help common to the single and mass processes for the account posting change. When the corresponding Update indicator is set to Yes, this field displays the specific rule code defined by the field associations. |
|
This field is used to enter a fiscal help. The amount should be less than the net value at the period start.
|
|
When set to Yes, this indicator enables to force the value of the field to which it is associated. It can only be modified if the Process indicator is active for the plan. |
|
Help common to the single and mass processes for the account posting change. The depreciation accelerator coefficient is used to manage depreciation modes: Declining balance, Belgian declining, Russian straight-line, Russian declining, Russian constant and Softy Russian modes. It can only be modified for these depreciation modes. |
|
Upon opening the window, this indicator, if set to Yes, signals that the value of the field to which it is linked, has been updated on applying the field association. It can only be modified if the Process indicator is active. If set to Yes, the indicator enables to enter or change this value. |
|
Help common to the single and mass processes for the account posting change. |
|
This field , non modifiable, displays the financial year start date of the context which the plan belongs to. |
|
This field, non modifiable, displys the periode start date of the plan. |
|
This field, non modifiable, reminds the user of the asset amortisation start date. |
|
  |
|
This field reminds the user of the accounting standard retained for the management of the depreciation plan. |
|
  |
Close
The table below presents the adjustment or processing terms applied to each asset, according to the effective date of the method change.
1/ The depreciation start date is less than the start date of the current FY fiscal year.
Effective date | Processing Terms |
Depreciation start date | The depreciation total on FY-1 end is recalculated. |
Current F Fiscal year start date | The depreciation total on FY-1 end is not recalculated. |
Start date of current period P | The depreciation total on FY-1 end is not recalculated. |
2/ The depreciation start date is greater than or equal to the start date of the current FY and less than the start date of the current period P.
Effective date | Processing Terms |
Depreciation start date | The charge of the F fiscal year will be recalculated using the new method. |
Start date of current period P | The depreciation total of the closed periods of the current fiscal year is not recalculated. |
3/ The depreciation start date is greater than or equal to the start date of the current period P.
Effective date | Processing Terms |
Depreciation start date | The charge of period P (or the depreciation start period) will be recalculated based on the new depreciation method. |
A list of examples is provided below, illustrating the implementations and processing terms available.
During an ongoing fiscal year, multiple depreciation method changes can be carried out. The implementation of a method change cannot be prior to the previous change.
Example
Let us consider a fiscal year containing 4 periods: P1, P2, P3 and P4.
Fiscal year | Period | Fiscal year start total | Fiscal year charge | Period charge | Period end total | Carry-forward |
01/01/04 - | (1,005.46) | |||||
01/01/05 - | (2,000.00) | |||||
01/01/06 - | 01/01/06 - 31/03/06 | 3,005.46 | 2,000.00 | 493.15 | 493.15 | |
01/04/06 - | (3,005.46) | 1,667.00 | (2) 333.50 | 826.65 | (-500.41) | |
01/07/06 - | 2,505.05 | 1,667.00 | 420.17 | 1,246.82 | ||
01/10/06 - | 2,505.06 | 1,667.00 | 420.18 | 1,667.00 | ||
01/01/07 - | 01/01/07 - | (3) 4,172.05 | 1,667.00 | 411.04 | 411.04 | |
01/04/07 - | 4,172.05 | 1,667.00 | 415.61 | 826.65 | ||
01/07/07 - | 4,172.05 | 1,667.00 | 420.17 | 1,246.82 | ||
01/10/07 - | 4,172.05 | 1,667.00 | 420.18 | 1,667.00 | ||
01/01/08 - | 5,839.05 | 1,667.00 | ||||
01/01/09 - | 7,506.05 | 1,667.00 | ||||
01/01/10 - | 9,173.05 | 826.95 | ||||
01/01/11 - | 10,000.00 |
Fiscal year | Period | Fiscal year start total | Fiscal year charge | Period charge | Period end total | Fiscal |
01/01/04 - | (1,005.46) | |||||
01/01/05 - | (2,000.00) | |||||
01/01/06 - | 01/01/06 - 31/03/06 | 3,005.46 | 2,000.00 | 493.15 | 493.15 | |
01/04/06 - | 3,005.46 | 1,667.00 | (2) 333.50 | 826.65 | (-500.41) | |
01/07/06 - | 3,505.46 | 1,667.00 | 420.17 | 1,246.82 | (-500.41) | |
01/10/06 - | 3,505.46 | 1,667.00 | 420.18 | 1,667.00 | (-500.41) | |
01/01/07 - | 01/01/07 - | (3) 4,172.05 | 1,667.00 | 411.04 | 411.04 | |
01/04/07 - | 4,172.0 | 1,667.00 | 415.61 | 826.65 | ||
01/07/07 - | 4,172.05 | 1,667.00 | 420.17 | 1,246.82 | ||
01/10/07 - | 4,172.0 | 1,667.00 | 420.18 | 1,667.00 | ||
01/01/08 - | 5,839.0 | 1,667.00 | ||||
01/01/09 - | 7,506.05 | 1,667.00 | ||||
01/01/10 - | 9,173.05 | 826.95 | ||||
01/01/11 - | 10,000.00 |
Fiscal year | Period | Fiscal year start total | Fiscal year charge | Period charge | Period end total | Fiscal |
01/01/04 - | (1,005.46) | |||||
01/01/05 - | (2,000.00) | |||||
01/01/06 - | 01/01/06 - 31/03/06 | 3,005.46 | 2,000.00 | 493.15 | 493.15 | |
01/04/06 - | 3,005.46 | 1,667.00 | (2) 333.50 | 826.65 | (-500.41) | |
01/07/06 - | 3,505.46 | 1,667.00 | 420.17 | 1,246.82 | ||
01/10/06 - | 3,505.46 | 1,667.00 | 420.18 | 1,667.00 | ||
01/01/07 - | 01/01/07 - | (3) 4,172.05 | 1,667.00 | 411.04 | 411.04 | |
01/04/07 - | 4,172.05 | 1,667.00 | 415.61 | 826.65 | ||
01/07/07 - | 4,172.05 | 1,667.00 | 420.17 | 1,246.82 | ||
01/10/07 - | 4,172.05 | 1,667.00 | 420.18 | 1,667.00 | ||
01/01/08 - | 5,839.05 | 1,667.00 | ||||
01/01/09 - | 7,506.05 | 1,667.00 | ||||
01/01/10 - | 9,173.05 | 826.95 | ||||
01/01/11 - | 10,000.00 |
Fiscal year | Period | Total | Fiscal | Fiscal | Total |
01/01/04 - | (1,005.46) | ||||
01/01/05 - | (2,000.00) | ||||
01/01/06 - | 01/01/06 - | 3,005.46 | 2,000.00 | 493.15 | 493.15 |
01/04/06 - | 3,005.46 | (1) 1,166.59 | (2) 85.35 | 578.50 | |
01/07/06 - | 3,005.46 | 1,166.59 | 294.05 | 872.55 | |
01/10/06 - | 3,005.46 | 1,666.59 | 294.04 | 1,166.59 | |
01/01/07 - | 01/01/07 - | (3) 4,172.05 | 1,667.00 | 411.04 | 411.04 |
01/04/07 - | 4,172.05 | 1,667.00 | 415.61 | 826.65 | |
01/07/07 - | 4,172.05 | 1,667.00 | 420.17 | 1,246.82 | |
01/10/07 - | 4,172.05 | 1,667.00 | 420.18 | 1,667.00 | |
01/01/08 - | 5,839.05 | 1,667.00 | |||
01/01/09 - | 7,506.05 | 1,667.00 | |||
01/01/10 - | 9,173.05 | 826.95 | |||
01/01/11 - | 10,000.00 |
(1) The variance between the new total on FY-1 and the previous one: 2,505.05 - 3,005.46 = -500.41 must be integrated to the charge of the fiscal year. Let us consider 1,667.00 - 500.41 = 1,169.59
(2) The charge of the fiscal year is recalculated using the new duration, which contains the variance on the total at the end of F-1. The charge of the P period contains the depreciation total variance of the closed periods of the F fiscal year:
1,166.59 X (181 days / 365 days) = 578.50 - 493.15 = 85.35
(3) At the closing of 2006 fiscal year, the total at the end of the year is calculated as follows:
total at the end of 2005 + Charge of 2006
Let us consider: 3,005.46 / 1,166.59 = 4,172.05
Fiscal year | Period | Total | Fiscal | Fiscal | Total |
01/01/04 - | (1,005.46) | ||||
01/01/05 - | (2,000.00) | ||||
01/01/06 - | 01/01/06 - | 3,005.46 | 2,000.00 | 493.15 | 493.15 |
01/04/06 - | 3,005.46 | 1,166.59 | (1) -166.91 | 326.24 | |
01/07/06 - | 3,005.46 | 1,166.59 | (2) 420.17 | 746.41 | |
01/10/06 - | 3,005.46 | 1,666.59 | 420.18 | 1,166.59 | |
01/01/07 - | 01/01/07 - | (3) 4,172.05 | 1,667.00 | 411.04 | 411.04 |
01/04/07 - | 4,172.05 | 1,667.00 | 415.61 | 826.65 | |
01/07/07 - | 4,172.05 | 1,667.00 | 420.17 | 1,246.82 | |
01/10/07 - | 4,172.05 | 1,667.00 | 420.18 | 1,667.00 | |
01/01/08 - | 5,839.05 | 1,667.00 | |||
01/01/09 - | 7,506.05 | 1,667.00 | |||
01/01/10 - | 9,173.05 | 826.95 | |||
01/01/11 - | 10,000.00 |
Fiscal year | Period | Total | Fiscal | Fiscal | Total |
01/01/04 - | 1,005.46 | ||||
01/01/05 - | 2,000.00 | ||||
01/01/06 - | 01/01/06 - | 3,005.46 | 2,000.00 | 493.15 | 493.15 |
01/04/06 - | 3,005.46 | (1) 1,554.82 | 277.87 | 771.02 | |
01/07/06 - | 3,005.46 | 1,554.82 | 391.90 | 1,162.92 | |
01/10/06 - | 3,005.46 | 1,554.82 | 391.30 | 1,554.82 | |
01/01/07 - | 01/01/07 - | 4,560.28 | 1,554.81 | 383.38 | 383.38 |
01/04/07 - | 4,560.28 | 1,554.81 | 387.64 | 771.02 | |
01/07/07 - | 4,560.28 | 1,554.81 | 391.89 | 1,162.91 | |
01/10/07 - | 4,560.28 | 1,554.81 | 391.90 | 1,554.81 | |
01/01/08 - | 6,115.09 | 1,559.08 | |||
01/01/09 - | 7,674.17 | 1,554.81 | |||
01/01/10 - | 9,228.98 | 771.02 | |||
01/01/11 - | 10,000.00 |
Fiscal year | Period | Total | Fiscal | Fiscal | Total |
01/01/04 - | 1,005.46 | ||||
01/01/05 - | 2,000.00 | ||||
01/01/06 - | 01/01/06 - | 3,005.46 | 2,000.00 | 493.15 | 493.15 |
01/04/06 - | 3,005.46 | (2) 1,645.14 | (1) 381.20 | 874.35 | |
01/07/06 - | 3,005.46 | 1,645.14 | 385.40 | 1,259.75 | |
01/10/06 - | 3,005.46 | 1,645.14 | 385.39 | 1,645.14 | |
01/01/07 - | 01/01/07 - | 4,650.60 | 1,529.00 | 377.01 | 377.01 |
01/04/07 - | 4,650.60 | 1,529.00 | 381.21 | 758.22 | |
01/07/07 - | 4,650.60 | 1,529.00 | 385.39 | 1,143.61 | |
01/10/07 - | 4,650.60 | 1,529.00 | 385.39 | 1,529.00 | |
01/01/08 - | 6,179.60 | 1,533.19 | |||
01/01/09 - | 7,712.79 | 1,529.00 | |||
01/01/10 - | 9,241.79 | 758.21 | |||
01/01/11 - | 10,000.00 |
Fiscal year | Period | Total | Fiscal | Fiscal | Total |
01/01/06 - | 01/01/06 - | 1,830.14 | 323.29 | 323.29 | |
01/04/06 - | 2,287.67 | (1) 704.11 | 1,027.40 | ||
01/07/06 - | 2,287.67 | 630.13 | 1,657.53 | ||
01/10/06 - | 2,287.67 | 630.14 | 2,287.67 | ||
01/01/07 - | 01/01/07 - | 2,287.67 | 2,500.00 | 616.44 | 616.44 |
01/04/07 - | 2,287.67 | 2,500.00 | 623.29 | 1,239.73 | |
01/07/07 - | 2,287.67 | 2,500.00 | 630.13 | 1,869.86 | |
01/10/07 - | 2,287.67 | 2,500.00 | 630.14 | 2,500.00 | |
01/01/08 - | 4,787.67 | 2,500.00 | |||
01/01/09 - | 7,287.67 | 2,500.00 | |||
01/01/10 - | 9,787.67 | 212.33 | |||
01/01/11 - | 10,000.00 |
Fiscal year | Period | Total | Fiscal | Fiscal | Total |
01/01/06 - | 01/01/06 - | 1,830.14 | 323.29 | 323.29 | |
01/04/06 - | (2) 2,221.36 | (1) 628.09 | 951.38 | ||
01/07/06 - | 2,221.36 | 634.99 | 1,586.37 | ||
01/10/06 - | 2,221.36 | 634.99 | 2,221.36 | ||
01/01/07 - | 01/01/07 - | 2,221.36 | 2,519.26 | 621.19 | 621.19 |
01/04/07 - | 2,221.36 | 2,519.26 | 628.09 | 1,249.28 | |
01/07/07 - | 2,221.36 | 2,519.26 | 634.99 | 1,884.27 | |
01/10/07 - | 2,221.36 | 2,519.26 | 634.99 | 2,519.26 | |
01/01/08 - | 4,740.62 | 2,526.16 | |||
01/01/09 - | 7,266.78 | 2,519.26 | |||
01/01/10 - | 9,786.04 | 213.96 | |||
01/01/11 - | 10,000.00 |
Presentation
This tab is used to enter the asset selection criteria.
It contains five lines, each of them used to enter a criterion, with each criterion being linked to the next one by one of the following logical operators: And, Or.
The process for selection criteria entry is as follows:
1/ Enter, or select from the list obtained by a right click in the field in the asset table FXDASSETS which contains the information to which the selection is applied.
2/ Then select the operator: Any, Equal, Different, Greater than or equal, Less than, Less than or equal, Like.
The Like operator is valid only for numeric fields. It allows the use wild cards.
3/ Enter a value. The list of possible values for the chosen field can be obtained with a right click when these values are contained in a local menu or in a table (miscellaneous table, common table, accounting table, etc.).
The user can also:
- enter the criteria in the form of an expression; the formulas of this type can be entered by right-clicking the fields in the asset table FXDASSETS,
- enter a selection formula by calling the formula editor.
Reminder: The selection options are the same as those used in the standard Advanced selection function. For more information, see the documentation on the application object ergonomics.
Close
Fields
The following fields are present on this tab :
Block number 1
Block number 2
|
Indicate a field from the table. |
|
Libellé du champ. |
|
Indicate the comparison operation:
|
|
Indicate the comparison value (without quotation marks for the alphanumeric fields). |
|
|
Indicate the link between criteria lines. Example : If Expr1 and Expr2 or Expr3 (Expr = expression) are entered we would have : (Expr1 & (Expr2 | (Expr3))) |
Block number 3
|
Indicate if necessary an expression to complete the search. The criterion is added to the previous criteria by the link AND. The expression cannot contain fields from a table other than the principal table for the object. These can be indexed. |
|
Si cette case est cochée, l'expression est définie comme valeur par défaut modifiable. |
Close
This function can be run in batch mode. The standard task FASTRFC is provided for that purpose.