For any company managing fixed assets, it is necessary to define the depreciation context or contexts to be managed.
Each context groups one or several depreciation plans managed in the same currency and according to the same calendar: the subdivision of their fiscal years and their intermediate period ends are identical.

Thus, a context is used to define:

  • The currency in which the depreciation bases and plans are managed.
  • The type of exchange rate to apply if a conversion must be applied to determine the basis.
  • The list of managed plans, by specifying for each of them, the type of ledger to which it is attached.
  • The fiscal years and the periods in the case when the intermediate ends are managed.
  • The Prorata temporis in weeks management rule, taken into account by some depreciation methods.
  • Keeping or not the context to manage the non financial units via a Production plan.
     
  • The choice, concerning the Accounting and fiscal context, to manage or not the concessions (management only possible if the CCN activity code is activated).

At least one depreciation context must be defined and managed in the company currency.
It is the Accounting and Fiscal depreciation context which, in addition to the Accounting plan dedicated to fill the individual accounts (social accounting) and mandatory, must group the following plans, when they are managed:

  • Fiscal plan
  • Minimum plan
  • Subsidy plan

Other plans are available, especially the IAS/IFRS plan dedicated to fill the consolidated accounts (reporting group). They can be grouped, either in the Accounting and fiscal context if their fiscal year/period distribution is identical to the context, or in any other context.
SEEINFO The management of the IAS plan is possible only if the IAS depreciation management indicator is active in the account core model of the company.

New plans and contexts can be defined at any time. In this case, they are created according to the terms indicated below (Initialization of a new plan) for each asset registered in the company. 

The status of each of the company contexts with respect to the calculation, the accounting interface, the concessions when they are managed, as well as its eligibility for a provisional flow generation and/or for a closing can be viewed via the Status of contexts function.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

The entry screen is made up of two tabs:

  • The Principal tab contains the various context management options and is used notably for each context to define the list of managed plans.
     
  • The following tab is dedicated to the definition of the fiscal years and periods.

Header

The header contains the identification information for the company and the context to be defined or viewed.

Tab Main

In addition to the setup of the different management flags belonging to each of the contexts, this tab is used:

 To indicate its management currency.

  To define the list of managed plans (15 potential plans are proposed), for each.

Reminder: the management of the Accounting and fiscal context is mandatory and must group:

        • The Accounting plan dedicated to load the Social ledger.
        • The Fiscal plan dedicated to the book vs tax depreciation and to the taking into account of the fiscal helps.
        • The Minimum plan dedicated to the management of the deferred type and the Minimum depreciation (when the depreciation charge calculated on the Fiscal plan becomes lower than the one on the Minimum plan, its value is forced with the charge calculated on the Minimum plan).
        • The subsidy plan linked to the subsidy management.

For each plan, it is necessary:

  • To indicate the valuation type used to fill in its Depreciation basis: this is necessarily the CoA valuation for the Accounting, Fiscal and minimum plans, the IAS/IFRS valuation for the IAS/IFRS plan and the subsidy amount for the Subsidy plan. The depreciation basis of the other plans can be freely chosen (CoA valuation, IAS valuation or Value to enter) but it cannot be IAS/IFRS valuation if the IAS/IFRS plan is not managed.
     
  • To specify the Accounting standard followed by the plan.
     
  • To indicate the Ledger in which the accounting postings will be generated when the source of the depreciation basis of the plan is set to To enter.
    - When the depreciation basis is set to CoA valuation the ledger must be set to Social.
    - When the depreciation basis is set to IAS valuation the ledger must be set to IAS.

It is also possible to:

  • To activate the Track flows management. The flow tracking FXDLIFL table will then be loaded during the processing of Provisional flows generation and when closing the fiscal year or the period. The terms related to the Activation / Deactivation of the funds management on a plan are detailed below.

    The accounting change/movement tracking can be carried out:
    - by fiscal file line to allow the production of the funds reports ( for example, the FR code imposed on the Accounting plan of a French company enables the user to generate the preparatory reports to the fiscal statements 2054 and 2055),
    - and/or by account.
     
  • To precise a Linked plan attached to the same context, as this link is used to:
    - calculate and store the charge variance between both plans,
    - maintain the totals of this variance,
    - post this variance, when the LNK - Variance between plans activity code is activated. 
     
    Note related to the derogatory and fiscal reintegration: :
    The comparison between the charges of the Accounting and Fiscal plans is systematically done as long as the Fiscal plan is managed, in order to determine the potential exceptional depreciations (recorded in the DEPREC depreciation table of the Accounting plan) as well as the potential fiscal reintegrations (recorded in the DEPREC depreciation table of the Fiscal plan).
     
  • The last column is used to see, by means of a green flag, whether an entry type setup allowing the posting of expense has been specified.

 To enter the parameters necessary to the initialization of a new plan when the assets are already managed in the company. The terms related to the Initialization of a new plan are detailed below.

  To enter the information required for the management of concessions as well as the provisions for renewal when the latter are managed. This information is only visible if the activity code CCN – Management of concessions is activated. They can only be accessed on the Accounting and fiscal context if 3 plans at least (excluding Fiscal and IAS/IFRS) are defined on this context.

Funds tracking

 The funds tracking can be modified (activation/deactivation) only if no period was closed in the fiscal year.

  Activation of funds tracking management in a plan

If the management of the funds was previously deactivated for a plan, the lines of funds tracking are initialized in the FXDLIFL table for the current fiscal year using the current situation of the assets in the fiscal year.
..\FCT\SEEINFO The initialization of the values of the account changes/modification tracking is done from the values of the assets at the activation of the account changes/modification tracking. If the account changes/modification tracking is deactivated, then reactivated during the same fiscal year, the potential operations usually aiming at making item to item transfers that will have taken place from the fiscal year start will be lost.
This situation can occur in every case when the account changes/modifications are not activated for a plan at the fiscal year start.
.

  Deactivation of funds tracking management in a plan

- If, in a plan, the accounting change/movement management has been previously activated, the lines initialized in the accounting change/movement tracking table (FXDLIFL), during the accounting change/movement tracking activation or at the time of the previous fiscal year end closing, are deleted (the deletion only takes place of lines relative to the current fiscal year).

- If the funds tracking has been activated in the previous fiscal year and closed, then the funds tracking lines are not affected by the deactivation of the tracking. To delete them it is necessary to use the Purging function.

- To modify the funds code by tax statement on a plan, the user must observe the following procedure:

  • 1/ Deactivate the funds code by deleting the Funds code of the concerned plan.
  • 2/ Save the context
  • 3/ Activate the funds tracking by selecting another funds code

..\FCT\SEEWARNING The funds tracking by tax statement (grouping of the accounts) in the Chart of accounts is mandatory for French companies (code FR); it is therefore active and cannot be deactivated.

Initialization of a new plan

The initialization of a new plan, when the assets already exist in the company, will lead to a mandatory update of these assets. In order to guarantee the integrity of the information present in these assets, they are locked during the creation of a new plan ; only the display mode is authorized. Conversely, if the company assets are locked because users are working in their records, any attempt to create a new plan will be refused.

When the assets exist already in the company, two methods can be used to initialize their new plan:

  • Initialization using a template plan
  • Initialization without using a template plan

 Initialization using a template plan

The new plan is initialized using the available values indicated on the entered template plan; the only constraint is that the current fiscal year start date of the new plan must be identical to the fiscal start date on the template plan. If this rule has not been respected, the depreciation totals picked up for previous fiscal years will be incoherent.
When the template plan manages the periodical closings, the division into periods is systematically transferred to the new plan.

Note: the information in the template plan only serve in the initialization of a new plan for existing assets. For new assets, this depreciation plan will be created according to the rules defined at the level of the context.

Special feature : The following information: Currency, Depreciation method and Initial balance sheet value is loaded in the following fashion:

  • Currency: the new plan can be managed in a currency different from the currency used by the template currency, the conversion of the amounts being ensured by the process by applying the value specified in the Exchange rate field.
     
  • Depreciation method: the depreciation method is loaded with the one used in the template plan as it is authorized in the new plan; if not the SA -Without depreciation method is automatically applied.
    Special feature linked to the initialization of the Fiscal plan of a French company : the SA -without depreciation method is automatically applied if the depreciation method of the template plan is different from LP - French linear or FD - French declining .
     
  • Initial balance sheet value: the Initial balance sheet value for the existing assets is initialized with the one found in the template plan used (converted into the currency of the new plan if required) and not with the Original depreciation basis field whose parameters only serve during the creation of new assets.

If the new plan is the IAS/IFRS plan , the IAS/IFRS valuation fields for existing assets are loaded in the following way:

  • The Currency and Exchange rate type fields pick up the values in the Principal tab of the context.
  • The Currencyrate receives the rate indicated in the Exchange rate field in the Principal tab.
  • The Nature and the Account pick up the CoA Nature and CoAAccount .
  • The IAS/IFRS ex tax receipt value picks up the CoA receipt value converted into the currency of the IAS/IFRS context.
  • The IAS/IFRSInvoiced VAT rate picks up the CoA Invoiced VAT rate.
  • The IAS/IFRS recovered VAT ratepicks up the CoA recovered VAT rate.
  • The IAS/IFRS Invoiced VAT amount is calculated using the IAS/IFRS ex tax receipt value and the IAS/IFRS Invoiced VAT rate, except if the CoA invoiced VAT amount is forced, in which case this amount converted into the currency for the IAS/IFRS context is used.
  • The IAS/IFRS recovered VAT amount is calculated by application of the IAS/IFRS recovered VAT rate to the IAS/IFRS Invoiced VAT amount, except if the CoA recovered VAT amount is forced, in which case this amount converted into the currency for theIAS/IFRS context is used..

If the new plan is not part of the Accounting and fiscal context, only the record relative to the first period in the current fiscal year is created. The creation is done using the record concerning the first period of the current fiscal year of the template plan, even if it is not the current period of this fiscal year. To obtain the values of the following periods and the asset "end of life" values, a calculation is required in a second step for the new plan.

If the new plan is part of the Accounting and fiscal contextAll the periods in the current fiscal year of the new plan are created up until the current period, from the record relative to the current period in the current fiscal year of the template plan. The closed periods in the new plan will have their periodic charges initialized to zero. Any adjustment to the current period charge will be taken into account by the calculation. To obtain the values of the current and following periods as well as the asset "end of life" values, a calculation is required in a second step for the new plan.

 Initialization without using a template plan

The new plan is initialized:

  • Either by applying the Associations defined at the "default" level (an association in a plan can only be defined at the "company" level once this plan exists) if they are defined.
     
  • Or by assigning by default the following values:

    - The depreciation method is set to Without depreciation.
    -
    The depreciation start date is initialized with the Purchase date.
    - The specific rules are initialized with the value No specific rule-
    -The other fields are left empty.
    - The Initial balance sheet value is initialized either with the CoA balance sheet value or with the IAS balance sheet value, (potentially converted into the currency used in the new plan) as a function of the entered value (CoA or IAS) in the Original depreciation basis field.

If the new plan is the IAS/IFRS plan, the IAS/IFRS valuation fields for existing assets are loaded in the following way:

  • The Currency and Exchange rate type fields pick up the values in the Principal tab of the context.
  • The Currency rate picks up the rate indicated in the Exchange rate field in the Principal tab.
  • The Nature and the Account pick up the CoA Nature and Account.
  • The ex tax receipt value picks up the CoA ex tax receipt value converted to the currency used in the IAS/IFRS context.
  • The Invoiced VAT rate picks up the CoA Invoiced VAT rate.
  • The Recovered VAT rate picks up the CoA Recovered VAT rate.
  • The Invoiced VAT amount is calculated from the IAS/IFRS ex-tax receipt value and the IAS/IFRS invoiced VAT rate , except if the CoA Invoiced VAT amount is forced in which case the amount converted into the IAS/IFRS context currency is used.
  • - The Recovered VAT amount is calculated by application of the IAS/IFRSrecovered VAT rate to the IAS/IFRSInvoiced VAT amount, except if the CoA Recovered VAT amount is forced in which case the amount converted into the IAS/IFRS context currency is used.

If the new plan is not part of the Accounting and fiscal context, only the record relative to the first period in the current fiscal year is created. 

If the new plan is part of the Accounting and fiscal context, all periods in the current fiscal year of the new plan will be created up to the current period. The closed periods in the new plan will have their periodic charges initialized to zero. Any adjustment to the current period charge will be taken into account by the calculation. To obtain the values of the current and following periods as well as the asset "end of life" values, a calculation is required in a second step for the new plan.
 

Tab FY/Period

This tab is used to define the fiscal years of the context and the periods of each fiscal year.

When parameter ACCPERCTL - Accounting period control is set to Yes, the context division is carried out automatically in the following way:
- the first FY opened is declared as context current FY,
- the first period opened is declared as current period.
The modification of the division FY/period is not authorized in this fuction. It is only carried out through the management of the fiscal years and periods in the Accounting module, followed by the implementation of the Context synchronization (to see the consistency control details between modules Accounting and Fixed assets, please refer to the documentation on parameter ACCPERCTL - Accounting period control).

When it is set to No, the definition of the FY and periods is carried out in the following way:

Definition of the fiscal years

For each context, it is mandatory to create at least two fiscal years: the current fiscal year and the following fiscal year.
On context creation, the right click option Current fiscal year is used to allocate the current fiscal year status to the fiscal year corresponding to the selected line.

On the Accounting and fiscal context:
 - For media companies, it is possible to enter an exceptional depreciation rate conforming to the article 39 bis rule applied to this type of company.
 - When the Minimum depreciation plan is defined, it is possible to enter the parameters related to the deffered depreciation, for the current fiscal year.

Definition of the periods

Each fiscal year can contain up to 24 periods. Dividing a fiscal year into periods is not mandatory; it is used to have intermediary accounting closings: end of month, end of quarter, end of half year, ... as the calculation process takes into account the divisions into periods of the current fiscal year and the two following. It will be possible to generate accounting entries (simulated or actual) of depreciation charges during these periods.
..\FCT\SEEINFO When no period is defined for a context, a period as long as the fiscal year duration is defined by default.

The status of a period conditions the accounting actions: posting of the depreciation expenses, transfer from account to account (capitalization), issues,...
 This status can have the value:
- Closed (after the periodical Closing process)
- Current
- Not opened
- Opened (after a right-click on Open period)

The Posting type of the period: Actual or Simulation.
This setup, used during the process of the accounting interface,only deals with the posting of the charge (the detail of the process according the posting type chosen is described in the documentation on the Generation of the accounting entries).

In creation mode, entry help functions are available by right click on the first line in the period definition: they are used in the automatic creation of monthly, bimonthly, quarter years (3 monthly) or half years (6 monthly) periods calculated from the fiscal year start date.
A Return to zero function is also used to carryout a mass deletion of all of the defined periods.

Other conditions

Modification

The contexts thus defined may be modified, provided that parameter ACCPERCTL - Accounting period control is set to No and that no geographical transfer is recorded in a future period.

- The modification can lead to an update of the existing assets in the context company. In order to guarantee the integrity of the information in these assets, they are locked during the context modification phase; only their display is authorized. Conversely, if the assets in the context company are locked because other users are already working with them, any attempt to modify the context will be refused. 

- When the context modification concerns the period management (sub-division deletion, sub-division modification or modification of the period end dates in the current or next fiscal year):
--> any next fiscal year or period calculation (DEPREC table records) is deleted. A new company calculation for this context will then need to be requested in order to reconstruct the data.
--> The provisional funds, should they be prior to the modified period, are deleted.
--> any provision for renewal calculation in the next fiscal years or periods is deleted. It is the company calculation that will create again theses records.
 
Reminder : Can be split again only:
1/ The unopened periods.
2/ The Current period with the following conditions:
    - that it is not followed by an Open period,
     -that no later period has any Posted amount.

- The subdivision modification of the "Retained for the management of the OPEs" context, leads to the automatic update of the production plan division: for each production plan, the lines of the modified fiscal year are deleted and created again according to the new division of the fiscal year. The total of the UP displayed on the deleted lines is transferred to the first new line; in this case, it is up to the user to distribute this number of UP on the new fiscal year and periods. In the same way, when new fiscal years are created for this context, the production plan lines linked to this context are added according to the division of the new fiscal year.

- When the Concessions are managed in Renewal mode, the modification in the breakdown of the Accounting and Fiscal context leads to the provision plan for renewal being automatically broken down in a similar way.

Deletion

The deletion of a context leads to the modification of all the assets in the company: these assets are locked during the process. Conversely, the deletion of a context is refused if the company assets are locked because other users are already working on these assets.

The context deletion operation also leads to the deletion:

- of each plan linked to the context,
- for each existing assets, of all of the information related to the deleted plans,
- the events associated with the deleted plan,
- any associations defined in the deleted plan,
- of the information related to the deleted plan in the depreciation methods.

Notes :

-
The deletion of the Accounting and fiscal context is prohibited if assets are defined in the company.
- The deletion of the IAS/IFRS plan is prohibited if at least one other plan is defined with the IAS/IFRS valuation such as the value of the Original depreciation basis field.
- The deletion of the context used for the management of the Non-Financial units is prohibited if at least a production plan has been defined for this context.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

"Unknown error in the fund management"
"Error in fund update"
"Read error in the current fiscal year"

These errors are linked to a database corruption; if the problem persists, please contact the support service.

Tables used

SEEREFERTTO Refer to documentation Implementation