Attribute update
This function is available only if the CCN activity code – Concession is activated and if the asset transmission by renewal is managed.
It authorizes the mass modification of one of the following information of a selection of assets in company concession. As a matter of fact, this update is no longer directly authorized for assets after they have been created:
- Renewal date
- Contractual Renewal Obligation
- Flag Asset transmitted against indemnity
- Update code
Notes:
- The update of attributes is forbidden on issued assets.
- It is also prohibited to update the Contractual renewal obligation of assets to renew which are part of a renewal preparation operation.
In order to ensure the integrity of the information displayed in the selected assets, the assets are locked during the process. Nevertheless, the inquiry of assets is authorized.
Prerequisites
Refer to documentation Implementation
Screen management
This function is composed of:
- A header, to specify the processing options and to choose the company and the financial sites to which the assets to be processed belong
- The Action parameter tab, used to specify the attribute to modify
- The Extended selection tab, used to select the assets to be processed.
Screen management method
The management is the same for this window as for all the mass process functions that can be applied to assets.
Process setup
First, it is necessary to set up the processing or use the Call button to recall an existing processing 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 presenting the values of the various parameters applied during the process, the details of the old and new values for each of the updated assets and the list of assets containing errors, as well as the error reason.
-Selecting the company and the potential other financial sites where the assets are registered.
- Entering the parameters linked to the update.
- Carrying out the selection of assets potentially involved in the process (Extended selection tab).
When the setup of a process is completed, it is possible to save it under an identification code using the Memo button. It is then possible to recall it at a later date for use in an update.
Running the process
Once the setup is performed, it is possible to:
- Either directly apply the entered parameters to each of the selected assets, by clicking OK. A consistency check on the new value is carried out; if there is an error for an asset, the previous value is kept and an error message is inserted in the log file report.
- Or go through an intermediate control stage of the entered parameters by clicking the Check button.
A window is displayed. It contains the list of selected assets and gives the value of the modified attribute for each asset. This modification can have an impact on the Effective renewal obligation. Therefore, the value of this flag is also displayed.
This window is also used to identify by color display the potential lines with errors along with the corresponding error messages. The assets with errors are not updated; they are displayed with their original values.
The assets that correspond to the selection criteria but with unchanged parameter values, do not appear as errors. They are excluded from the list of assets.
- Click the End button to close the control window; the setup entry window is displayed again, which makes it possible to either confirm the mass update by clicking the OK button or the End button to cancel the update.
Header
The header contains the processing options and is used to select the company, as well as the site(s) in which the assets are registered.
- Simulation:
This box, checked by default, is used to carry out an attribute modification simulation on the selected assets. The modification of the assets is not recorded in the database.
The impact of the processing on the assets can be viewed in the log file displayed at processing completion.
- Detailed log file:
A log file is systematically displayed upon completion of the process, which shows the process options, the selection criteria, the update setup as well as the number of selected assets, the number of updated assets and the number of assets not processed as a result of an error. Assets with errors are listed with the reason of the error.
When this box is ticked, the log file is displayed in the form of a detailed report presenting, in addition to the information listed above, the list of assets successfully processed. The value of the attribute is displayed for each asset before and after the update.
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.
Options
Simulation (field FLGSIM) |
This check box is selected by default and runs the closing in simulation mode. In this case, controls and the process are carried out but there are no updates recorded in the database. Clear this check box to run in actual mode. In this case, you cannot reverse the closing and updates are recorded in the database. If you are using intermediate commits, it is recommended that the NIVTRACE – Log file level parameter (AAS chapter, MIS group) value is 0. |
Report (field FLGETA) |
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. |
Detailed log file (field FLGDET) |
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
field FLGCPY |
Help common to all the mass processings. When the company setupACCPERCTL - Control of accounting periods (chapter AAS, group CPT) has the value 'Yes', the company is not displayed in the list if at least one of its contexts is not synchronized with the accounting period/fiscal breakdown. The desynchronization status of a context is visible in the screenDetailed status of contexts that can be accessed from the Actions icon.In that screen, on the Calculation tab, the field Modification type has the value 'CNX' and the field Modified parameter has the value 'DESYNC'.In this case, it is necessary to launch the processing of Contexts synchronization. |
Company (field CPY) |
This field displays the company code. |
Grid Site selection
field FLGFCY |
The grid displays the list of the sites attached to the companies and for which the user has authorizations. |
Company (field FCYCPY) |
Identification Code for the company which the site is linked to. |
Site (field FCY) |
Identification code of the site. |
Company selection – Site selection
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 parameterACCPERCTL - 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 Contexts synchronization process.
The situation of de-synchronization of a context can be viewed on the Detailed status of contexts,Calculation tab (the value of the Modification type field is CNX and the value of the field Parameter modified 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.
Tab Parameter definition
This tab is used to:
- Select the attribute to modify: Renewal Provisional date, Renewal Contractual Obligation, Transferred against indemnity and Update code.
It is not possible to modify several attributes simultaneously.
- To enter the new value of this attribute as well as the update reason.
Attributes
Renewal (field UPDTYP) |
Select, by activating the corresponding radio button, the attribute to modify. The update can be on one attribute at a time. |
Values
Provisional date (field RNWDAT) |
Help common to the unitary and mass processing of terms update. |
Contractual obligation (field OBYRNWCON) |
Help common to the unitary and mass processing of terms update.
|
Transmitted against indemnity (field TPAFLG) |
Help common to the unitary and mass processing of terms update. |
Update code (field CCNACTCOD) |
Reason (field REN) |
This mandatory field is used to specify the reason for the modification. |
Tab Extended selection
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 a field or use the Lookup tool to select one from the FXDASSETS - assets table.
2/ Then select the operator: All, Equal, Not equal to, Greater than or equal to, Less than, Less than or equal to, Like.
The 'Like' operator is valid only for numeric fields. Wildcards can be used.
3/ Enter a value. Use the Lookup tool for a list of possible values in the related local menu or in a table (miscellaneous table, common table, accounting table, etc.).
You can:
- Enter the criteria in the form of an expression. The formulas of this type can be entered by right-clicking the fields in the FXDASSETS - asset table.
- Enter a selection formula using the formula editor.
Block number 1
Processing description
A non-simulated update carries out following operations:
- Application of the new value of the modified attribute.
- Update of each of the fixed assets according to the processing terms described below.
- Generation of an event FASCCN - Attributes update.
Updating the renewal provisional date results in:
- Setting the asset on To recalculate at provision level.
- Updating the provisional date with the entered date. When no date is entered, the modification will apply only to the assets for which the date has been entered, and will result in de-forcing this date and load it with the end date of the asset industrial depreciation.
Updating the contractual obligation results in:
- The asset being set to To recalculate at provision level.
- Possibly modifying the position of the Effective renewal obligation flag.
Refreshing the update code results in:
- Setting the asset to To recalculate at provision level.
- Updating the asset with the entered update code.
Updating theTransferred against indemnity flag results in:
- Setting the asset toTo recalculate at provision and depreciation level.
If the flag changes from No to Yes:
- The depreciation method of the plan managing the amortization is set to SA. If the depreciation method was AR, a method change event would be generated, and have as the effective date:
- either the fiscal year start date when the depreciation total on fiscal year start is equal to 0,
- or the depreciation start date if the asset has a depreciation total on fiscal year start. The adjustment of this total is calculated as Exceptional depreciation for the period. This results in the recovery of the total for the previous period end in the period depreciation expense and the recovery of the total for the previous fiscal year end on period exceptional depreciation. - The Effective Renewal Obligation flag is deactivated.
- The asset and the Accounting and fiscal context are set to To be calculated.
- The provisions for renewal are reversed.
If the flag changes from Yes to No:
- The depreciation method of the plan managing the amortization moves to AR with an end date based on the concession end date. A method change event is generated with the period start date as the effective date.
- If the asset has been subject to a contractual renewal obligation and if the industrial depreciation end date is prior to the concession end date, the Effective renewal obligation flag is automatically activated.
- The asset and the Accounting and fiscal context are positioned as To be calculated.
The user can view the events in the Event journal window that can be accessed from the Other info tab of the Assets management function.
Specific Buttons
Recall |
Click this action to enter a Memo code to load the settings associated with the code. |
Delete Memo |
Click this action to delete a Memo code. |