Use this function to perform a 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.
You can also use this function to view the new depreciation methods and to carry out any modification required.

Before being carried out in real mode, you can run the process in Simulation to assess the result using 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.

..\FCT\SEEINFO  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

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

This function is composed of:

  • A Header that is used to specify the processing options and to choose the company and the financial sites to which the assets to be processed belong.
     
  • The Parameters tab used to enter the new account allocations.
     
  • The Depreciation plans tab that is used to view any new depreciation methods determined by the field associations and to carry out any modifications required.
     
  • The Extended selection tab that is used to select the assets to be processed.

Management method for the window

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 process or to Recall a Memo code with previously used settings.

Setting up the process includes:

- Entering the process 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.

-Entering new accounting allocations.

- Selecting 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 you complete the setup, you can save your settings by clicking Memo to Recall later.

Process launch

Once the setup is done, it is possible to:

  • Either directly apply the entered parameters to each of the selected assets, by clicking OK. A coherence check on the new accounting allocations as well as the new methods is then carried out. For an asset with an error, the previous allocation and method are conserved and an error message is inserted in the process report.

    Note: When an update of the Residual value is requested, OK is not available and you  must go to the Check window to enter the market value of each asset.
     
  • Or go through an intermediate control stage of the entered parameters by clicking Check.
     
    A control window opens containing two tables.
     
    1/ The first presents the list of assets selected and for each of them, if no error is detected, the new accounting allocations.
     
    2/ The second table contains the depreciation plans for the asset highlighted by the cursor in the first table and on which a depreciation method change has been requested. If the asset has an accounting allocation error, no depreciation method is displayed in this table.
     
    You can:

    - View the depreciation new methods.
    - Identify lines with errors with potential errors in red, along with the corresponding error messages. The assets with errors are not updated with the parameters entered; they are displayed with their original method parameters.
    - Correct or adjust the depreciation parameters.

Click Save to validate any modification of one or more depreciation parameters carried out on an asset. To cancel the modifications under way on the asset, click Cancel.
After the manual adjustments are complete, click End to close the control window; the setup entry window is displayed again, which makes it possible to either confirm the mass update by clicking OK or click End to cancel the update.

Process description

An accounting allocation change performs the following operations:

  • Update of the assets with the new allocations and depreciation methods, as long as the following rules are respected:
     
    1/ An allocation change leading to a CoA account Nature of Charge or Fixed asset in process is not applied to assets with the nature Fixed asset in service, when an earlier depreciation total exists for one of the asset plans (outside of IAS/IFRS plan). The same goes for the IAS/IFRS accounting nature when an IAS/IFRS depreciation total exists for the IAS/IFRS plan.
     
    2/ On exiting the account transfer, the assets must be posted to at least one fixed asset account either according to the CoA standards or to the IAS/IFRS standards.
     
  • For each, generation of: 

    - A Main event of Allocation change (FASCHGIMP) 
    - If necessary, of method change event (FASMTC)
    - As many Secondary events of Allocation change (FASCHGIMP), as periods with a Definitive posting on the original allocations (both on the current fiscal year and the next one).

    - The effective operating date is saved in the EVTDAT field.
    - The effective accounting date is saved in the CPTDATINT field.
     
    Note :

    When the allocation change corresponds to a start-up (transfer from an In progress account to an In service account), the EVTDAT field is loaded with the Date put into service, and the CPTDATINT field is loaded with the furthest of these dates: Depreciation start date, Start date of the current period.
     
    When the allocation change does not involve a transfer from an In progress account to an In service account:
     
    1/ In the Main event FASCHGIMP: EVTDAT and CPTDATINT display the furthest of these dates: Depreciation start date, Start date of the current period.
     
    2/ In the Secondary event FASCHGIMP: EVTDAT is loaded with the start date of the period concerned (already posted in Final) and CPTDATINT is loaded either with the start date of the current period (for events pertaining to the closed periods of the current fiscal year), or the start date of the period concerned (for events pertaining to the open periods of the current or next fiscal year).
     
    The inquiry of events in the Event journal window that can be accessed from the Other info tab of the Assets management function.
    In this window, the Main events can be identified thanks to the FASTRFC_01.jpg icon displayed at the beginning of the line. Double-clicking this icon expands the tree view of the list of Secondary events linked to it. 
    In the event content, the field EVTPRINC - Main event of type Local menu, enables the distinction between main event and secondary event, both events are linked by an alphanumeric field: TIMSTPP - Time stamp. 

Header

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.

Options

  • Simulation
    This check box, selected by default, is used to carry out a simulation of an accounting allocation change 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 on completion of the process, showing the process options, the selection criteria, the new accounting allocations as well as, for each of the plans involved, any new methods. 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.

    If this check box is selected, the log file is displayed in the form of a detailed report presenting, in addition to the information indicated above, the list of the successfully processed assets as well as their previous accounting allocations.

Note: Viewing and printing 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.

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.

SEEINFO  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 Setup definition

This tab is used to:

  • Specify the reason justifying the allocation change.
     
  • Modify the accounting allocations:
     
    - Holding type: Only the value In property can be selected. It cannot be applied except to assets where the holding type is In lease contract and for which no leasing contract reference has been entered.
     
    - Classification of the assets as Held for sales: This classification stops the depreciation for the IAS/IFRS plans.

    - Family and/or Accounting code 
     
  • View the new Nature and CoA allocation (and any IAS/IFRS if the IAS/IFRS standards are managed) if the accounting code is modified, either directly, or by means of the application of the section associations after the modification of the Family.

..\FCT\SEEINFO The effective date of the allocation change is automatically determined as follows:

  • If the accounting allocation change does not involve the switch from a fixed asset account In process to an account In service, the operation effective date and the accounting effective date have two different values: Depreciation start date, Start date of the current period.
  • If the accounting allocation change does involve the switch from a fixed asset account In process to an account , the operation effective date is the first use date, and the accounting effective date is the furthest of the following: Start-up date and Current period start date.

Tab Deprec plans

This tab is made up of a table containing as many lines as there are depreciation plans managed by the company. It is used to:

  • View the impact of the accounting allocation change (Family and/or Code) on the depreciation methods of each plan. Each of the elements in the method modified in this way if Update is set to Yes.
     
  • Select each of the plans on which the new method will be applied. This selection is carried out by activating the Process indicator. It is possible, for the selected plans, to carry out any adjustment necessary on one or several elements of the depreciation method. To do so, the Update indicator preceding it must be set to Yes, if it isn't already. 
    The plans which the Process indicator is not active for, keep the depreciation methods which were applied to them before the accounting allocation change process.
     
  • Specify the effective date of the method change. It can either be:

    - The Period start date
    - The FY start date
    - The Depreciation start date
     
    When the allocation change goes along with a method change, the process modalities linked to the selection of the effective date are described below.
  • Define the management terms of the potential variance on the depreciation when the change of method takes effect at the asset depreciation start date, which is earlier than the start date of the current fiscal year.

    Note on the first use of the fixed assets: When the change of accounting allocation corresponds to a first use, the effect must have the value of the Depreciation start date and the compensation for the difference must be filled using the value of the Period charge. This adjustment is managed as follows:
    - The cumulative of the previous FY E-1 equals 0 (the forcing flag is set to Yes)
    - The charge that should have been applied in E-1 is adjusted in the current period of fiscal year E (the adjustment is added to the charge of this period).

     

Potential effective dates and processing terms

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.
The variance between the new and the former total can be processed, as the user wishes, according to one of the following modalities:
- In carry-forward See Example 1.
- Fiscal year exceptional charge. See Example 2.
- Period exceptional charge. See Example 3.
- Integrated to the fiscal year charge. See Example 4.
- Integrated to the period charge. See Example 5.

 Current F Fiscal year start date

The depreciation total on FY-1 end is not recalculated.
The F fiscal year charge will be recalculated using the new method, which is necessarily based on a residual method applied to the depreciation net value at the start of the F fiscal year.
The charge of the P period will contain the regulation of the charges of the closed periods.
See Example 6.

 Start date of current period P

The depreciation total on FY-1 end is not recalculated.
The depreciation total of the closed periods of the current fiscal year is not recalculated.
The "residual" F fiscal year charge [P period start - F fiscal year end] will be calculated using the new method, which is necessarily based on a residual method applied to the depreciation net value at the start of the P period.
This charge of the "residual" fiscal year will be distributed on the P period and the following of the F fiscal year.
The charge of the F Fiscal year will be equal to the total: charges of closed periods before method change + charge of "residual" fiscal year.
See Example 7.

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.
The charge of the P period will contain the regulation of the charges of the closed periods.
See Example 8.

 Start date of current period P

The depreciation total of the closed periods of the current fiscal year is not recalculated.
The depreciation charge of the "residual" fiscal year [P period start - F Fiscal year end] will be calculated using the new method, mandatorily based on a residual method.
This charge of the "residual" fiscal year will be distributed on the P period and the following of the F fiscal year.
The charge of the F Fiscal year will be equal to the total: charges of closed periods before method change + charge of "residual" fiscal year.
See Example 9.

 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.

Effective date and consecutive method changes:

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.

  • During P2, a change of method is made to be effective at Period start.
    During P3, only a change of method to be effective at Period start will be possible.
  • During P1, a change of method is made to be effective at Fiscal year start.
    During P3, a change of method to be effective at Fiscal year start or a change of method to be effective at Period start will be possible.

Examples of method change

Depreciation start date less than Current fiscal year FY
  • Example 1

    Effectiveness: Depreciation start date
    Chosen terms: Variance on total at the end of F-1 in Carry forward balance

    - Depreciation start date: 01/07/2004 (i.e. 184 holding days)
    - Asset value: 10,000
    - Method: linear
    - Duration: 5 years
    - Current fiscal year: 01/01/2006 - 31/12/2006
    - Current period: 01/04/2006 - 30/06/2006
    - Depreciation total on FY-1 end: 3,005.46
    - Duration change (extended to 6 years)

Fiscal year

Period

Fiscal year start total

Fiscal year charge

Period charge

Period end total

Carry-forward
(1)

01/01/04 -
31/12/2004

(1,005.46)
838.05

01/01/05 -
31/12/2005

(2,000.00)
1,667.00

01/01/06 -
31/12/06

01/01/06 - 31/03/06

3,005.46

2,000.00

493.15

493.15

01/04/06 -
30/06/06

(3,005.46)
(1) 2,505.05

1,667.00

(2) 333.50

826.65

(-500.41)

01/07/06 -
30/09/06

2,505.05

1,667.00

420.17

1,246.82

01/10/06 -
31/12/06

2,505.06

1,667.00

420.18

1,667.00

01/01/07 -
31/12/07

01/01/07 -
31/03/07

(3) 4,172.05

1,667.00

411.04

411.04

01/04/07 -
30/06/2007

4,172.05

1,667.00

415.61

826.65

01/07/07 -
30/09/2007

4,172.05

1,667.00

420.17

1,246.82

01/10/07 -
31/12/07

4,172.05

1,667.00

420.18

1,667.00

01/01/08 -
31/12/08

5,839.05

1,667.00

01/01/09 -
31/12/2009

7,506.05

1,667.00

01/01/10 -
31/12/10

9,173.05

826.95

01/01/11 -
31/12/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 posted as Carry-forward at the start of F financial year.
The new total at the end of F-1 (2,505.05) cancels and replaces the previous one (3,005.46), even though the forcing flag is set to Yes for this total.

(2) The charge of the fiscal year is recalculated using the new duration, the charge of the P period contains the depreciation total variance of the closed periods of the F fiscal year:
(10,000.00 x 16,67 %) = 1,667.00 x (181 days / 365 days) = 826.65 - 493.15 = 333.50

(3) At the closing of 2006 fiscal year, the total at the end of the year is calculated as follows:
New total at the end of 2005 re-caculated after the change of method + Charge of 2006
Let us consider: 2,505.05 / 1,667.00 = 4,172.05


Depreciation start date less than Current fiscal year FY
  • Example 2

    Effectiveness: Depreciation start date
    Chosen terms: Variance on total at the end of F-1 in Exceptional charge of the fiscal year

    - Depreciation start date: 01/07/2004 (i.e. 184 holding days)
    - Asset value: 10,000
    - Method: linear
    - Duration: 5 years
    - Current fiscal year: 01/01/2006 - 31/12/2006
    - Current period: 01/04/2006 - 30/06/2006
    - Depreciation total on FY-1 end: 3,005.46
    - Duration change (extended to 6 years)

Fiscal year

Period

Fiscal year start total

Fiscal year charge

Period charge

Period end total

Fiscal
exception.(1)

01/01/04 -
31/12/2004

(1,005.46)
838.05

01/01/05 -
31/12/2005

(2,000.00)
1,667.00

01/01/06 -
31/12/06

01/01/06 - 31/03/06

3,005.46

2,000.00

493.15

493.15

01/04/06 -
30/06/06

3,005.46

1,667.00

(2) 333.50

826.65

(-500.41)
-248.15

01/07/06 -
30/09/06

3,505.46

1,667.00

420.17

1,246.82

(-500.41)
-126.13

01/10/06 -
31/12/06

3,505.46

1,667.00

420.18

1,667.00

(-500.41)
-126.13

01/01/07 -
31/12/07

01/01/07 -
31/03/07

(3) 4,172.05

1,667.00

411.04

411.04

01/04/07 -
30/06/2007

4,172.0

1,667.00

415.61

826.65

01/07/07 -
30/09/2007

4,172.05

1,667.00

420.17

1,246.82

01/10/07 -
31/12/07

4,172.0

1,667.00

420.18

1,667.00

01/01/08 -
31/12/08

5,839.0

1,667.00

01/01/09 -
31/12/2009

7,506.05

1,667.00

01/01/10 -
31/12/10

9,173.05

826.95

01/01/11 -
31/12/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 posted as Exceptional charge for the F fiscal year, this exceptional charge must be distributed on the current period and the following ones.
For the period [01/04/06 - 30/06/06]: -500.41 x (181 / 365) = -248.15
For the period [01/07/06 - 30/09/06]: -500.41 x (273 / 365) - (-248.5) = -126.13
For the period [01/10/06 - 30/12/06]: -500.41 - -374.28 = -126.13

(2) The charge of the fiscal year is recalculated using the new duration, the charge of the P period contains the depreciation total variance of the closed periods of the F fiscal year:
(10,000.00 x 16,67 %) = 1,667.00 x (181 days / 365 days) = 826.65 - 493.15 = 333.50

(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 + Exceptional charge of 2006
Let us consider: 3,005.46 + 1,667.00 -  500.41 =  4,172.05

Depreciation start date less than Current fiscal year FY
  • Example 3

    Effectiveness: Depreciation start date
    Chosen terms: Variance on total at the end of F-1 in Exceptional charge of the period

    - Depreciation start date: 01/07/2004 (i.e. 184 holding days)
    - Asset value: 10,000
    - Method: linear
    - Duration: 5 years
    - Current fiscal year: 01/01/2006 - 31/12/2006
    - Current period: 01/04/2006 - 30/06/2006
    - Depreciation total on FY-1 end: 3,005.46
    - Duration change (extended to 6 years)

Fiscal year

Period

Fiscal year start total

Fiscal year charge

Period charge

Period end total

Fiscal
exception.(1)

01/01/04 -
31/12/2004

(1,005.46)
838.05

01/01/05 -
31/12/2005

(2,000.00)
1,667.00

01/01/06 -
31/12/06

01/01/06 - 31/03/06

3,005.46

2,000.00

493.15

493.15

01/04/06 -
30/06/06

3,005.46

1,667.00

(2) 333.50

826.65

(-500.41)

01/07/06 -
30/09/06

3,505.46

1,667.00

420.17

1,246.82

01/10/06 -
31/12/06

3,505.46

1,667.00

420.18

1,667.00

01/01/07 -
31/12/07

01/01/07 -
31/03/07

(3) 4,172.05

1,667.00

411.04

411.04

01/04/07 -
30/06/2007

4,172.05

1,667.00

415.61

826.65

01/07/07 -
30/09/2007

4,172.05

1,667.00

420.17

1,246.82

01/10/07 -
31/12/07

4,172.05

1,667.00

420.18

1,667.00

01/01/08 -
31/12/08

5,839.05

1,667.00

01/01/09 -
31/12/2009

7,506.05

1,667.00

01/01/10 -
31/12/10

9,173.05

826.95

01/01/11 -
31/12/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 posted as Exceptional charge for the P period, when the change of method was carried out.

(2) The charge of the fiscal year is recalculated using the new duration, the charge of the P period contains the depreciation total variance of the closed periods of the F fiscal year:
(10,000.00 x 16,67 %) = 1,667.00 x (181 days / 365 days) = 826.65 - 493.15 = 333.50

(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 + Exceptional charge of 2006
Let us consider: 3,005.46 + 1,667.00 -  500.41 =  4,172.05


Depreciation start date less than Current fiscal year FY
  • Example 4

    Effectiveness: Depreciation start date
    Chosen terms: Variance on total at the end of F-1 integrated to the charge of the fiscal year

    - Depreciation start date: 01/07/2004 (i.e. 184 holding days)
    - Asset value: 10,000
    - Method: linear
    - Duration: 5 years
    - Current fiscal year: 01/01/2006 - 31/12/2006
    - Current period: 01/04/2006 - 30/06/2006
    - Depreciation total on FY-1 end: 3,005.46
    - Duration change (extended to 6 years)

Fiscal year

Period

Total
fiscal year start

Fiscal
fiscal year

Fiscal
period

Total
period end

01/01/04 -
31/12/2004

(1,005.46)
838.05

01/01/05 -
31/12/2005

(2,000.00)
1,667.00

01/01/06 -
31/12/06

01/01/06 -
31/03/06

3,005.46

2,000.00

493.15

493.15

01/04/06 -
30/06/06

3,005.46

(1) 1,166.59

(2) 85.35

578.50

01/07/06 -
30/09/06

3,005.46

1,166.59

294.05

872.55

01/10/06 -
31/12/06

3,005.46

1,666.59

294.04

1,166.59

01/01/07 -
31/12/07

01/01/07 -
31/03/07

(3) 4,172.05

1,667.00

411.04

411.04

01/04/07 -
30/06/2007

4,172.05

1,667.00

415.61

826.65

01/07/07 -
30/09/07

4,172.05

1,667.00

420.17

1,246.82

01/10/07 -
31/12/07

4,172.05

1,667.00

420.18

1,667.00

01/01/08 -
31/12/08

5,839.05

1,667.00

01/01/09 -
31/12/2009

7,506.05

1,667.00

01/01/10 -
31/12/10

9,173.05

826.95

01/01/11 -
31/12/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



Depreciation start date less than Current fiscal year FY
  • Example 5

    Effectiveness: Depreciation start date
    Chosen terms: Variance on total at the end of F-1 integrated to the charge of the period

    - Depreciation start date: 01/07/2004 (i.e. 184 holding days)
    - Asset value: 10,000
    - Method: linear
    - Duration: 5 years
    - Current fiscal year: 01/01/2006 - 31/12/2006
    - Current period: 01/04/2006 - 30/06/2006
    - Depreciation total on FY-1 end: 3,005.46
    - Duration change (extended to 6 years)

Fiscal year

Period

Total
fiscal year start

Fiscal
fiscal year

Fiscal
period

Total
period end

01/01/04 -
31/12/2004

(1,005.46)
838.05

01/01/05 -
31/12/2005

(2,000.00)
1,667.00

01/01/06 -
31/12/06

01/01/06 -
31/03/06

3,005.46

2,000.00

493.15

493.15

01/04/06 -
30/06/06

3,005.46

1,166.59

(1) -166.91

326.24

01/07/06 -
30/09/06

3,005.46

1,166.59

(2) 420.17

746.41

01/10/06 -
31/12/06

3,005.46

1,666.59

420.18

1,166.59

01/01/07 -
31/12/07

01/01/07 -
31/03/07

(3) 4,172.05

1,667.00

411.04

411.04

01/04/07 -
30/06/2007

4,172.05

1,667.00

415.61

826.65

01/07/07 -
30/09/2007

4,172.05

1,667.00

420.17

1,246.82

01/10/07 -
31/12/07

4,172.05

1,667.00

420.18

1,667.00

01/01/08 -
31/12/08

5,839.05

1,667.00

01/01/09 -
31/12/2009

7,506.05

1,667.00

01/01/10 -
31/12/10

9,173.05

826.95

01/01/11 -
31/12/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 (1,667.00 - 500.41 = 1,169.59) and posted in the charge of the P period.
Let us consider [1,667.00 x (181 / 365) - 493.15] + (-500.41) = -166.91

(2) The charge of each following period does not contain any variance on the total at the end of F-1. The calculation is as follows:
1,667.00 x (273 / 365) - 326.24 + (500.41 ) = 420.17 --> total at the end of 3rd period = 746.41
1,667.00 c (365 / 365) - 746.41 + (500.41 ) = 420.18 --> total at the end of 4th period = 1,166.59

(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


Depreciation start date less than Current fiscal year FY
  • Example 6

    Effectiveness: F Fiscal year start date
    Imposed terms: Recalculation of the FY fiscal year using the new method based on a residual mode. The charge of the P period contains the regulation of the charges of the closed periods.

    - Depreciation start date: 01/07/2004 (i.e. 184 holding days)
    - Asset value: 10,000
    - Method: linear
    - Duration: 5 years
    - Current fiscal year: 01/01/2006 - 31/12/2006
    - Current period: 01/04/2006 - 30/06/2006
    - Depreciation total on FY-1 end: 3,005.46
    - Duration change (extended to 6 years)

Fiscal year

Period

Total
fiscal year start

Fiscal
fiscal year

Fiscal
period

Total
period end

01/01/04 -
31/12/2004

1,005.46

01/01/05 -
31/12/2005

2,000.00

01/01/06 -
31/12/06

01/01/06 -
31/03/06

3,005.46

2,000.00

493.15

493.15

01/04/06 -
30/06/06

3,005.46

(1) 1,554.82

277.87

771.02

01/07/06 -
30/09/06

3,005.46

1,554.82

391.90

1,162.92

01/10/06 -
31/12/06

3,005.46

1,554.82

391.30

1,554.82

01/01/07 -
31/12/07

01/01/07 -
31/03/07

4,560.28

1,554.81

383.38

383.38

01/04/07 -
30/06/2007

4,560.28

1,554.81

387.64

771.02

01/07/07 -
30/09/2007

4,560.28

1,554.81

391.89

1,162.91

01/10/07 -
31/12/07

4,560.28

1,554.81

391.90

1,554.81

01/01/08 -
31/12/08

6,115.09

1,559.08

01/01/09 -
31/12/2009

7,674.17

1,554.81

01/01/10 -
31/12/10

9,228.98

771.02

01/01/11 -
31/12/11

10,000.00


(1) The new charge of 2006 fiscal year equals to: Net value start of 2006 x (number of days in 2006 / number of days between 01/01/2006 and the depreciation end date: 30/06/2010).
Let us consider: (10,000 - 3005.46) x (365 / 1,642 days) = 1,554.82
The duration change is performed in the current period [01/04/2006 - 30/06/2006]; the charge of this period is equal to: Charge of fiscal year x (number of days until 30/06/2006 / number of days in 2006) - Depreciation total of P-1.
Let us consider: [1,554.82 x (181 / 365)] - 493.15 = 277.87


Depreciation start date less than Current fiscal year FY
  • Example 7

    Effectiveness: P Period start date.
    Imposed terms: Recalculation of the "residual" fiscal year charge using the new method based on a residual mode. This charge of the "residual" fiscal year is distributed on the P period and the following of the F fiscal year.

    - Depreciation start date: 01/07/2004 (i.e. 184 holding days)
    - Asset value: 10,000
    - Method: linear
    - Duration: 5 years
    - Current fiscal year: 01/01/2006 - 31/12/2006
    - Current period: 01/04/2006 - 30/06/2006
    - Depreciation total on FY-1 end: 3,005.46
    - Duration change (extended to 6 years)

Fiscal year

Period

Total
fiscal year start

Fiscal
fiscal year

Fiscal
period

Total
period end

01/01/04 -
31/12/2004

1,005.46

01/01/05 -
31/12/2005

2,000.00

01/01/06 -
31/12/06

01/01/06 -
31/03/06

3,005.46

2,000.00

493.15

493.15

01/04/06 -
30/06/06

3,005.46

(2) 1,645.14

(1) 381.20

874.35

01/07/06 -
30/09/06

3,005.46

1,645.14

385.40

1,259.75

01/10/06 -
31/12/06

3,005.46

1,645.14

385.39

1,645.14

01/01/07 -
31/12/07

01/01/07 -
31/03/07

4,650.60

1,529.00

377.01

377.01

01/04/07 -
30/06/2007

4,650.60

1,529.00

381.21

758.22

01/07/07 -
30/09/2007

4,650.60

1,529.00

385.39

1,143.61

01/10/07 -
31/12/07

4,650.60

1,529.00

385.39

1,529.00

01/01/08 -
31/12/08

6,179.60

1,533.19

01/01/09 -
31/12/2009

7,712.79

1,529.00

01/01/10 -
31/12/10

9,241.79

758.21

01/01/11 -
31/12/11

10,000.00


(1) The charge of the method change period is calculated as follows:
(10,000 - 3,005.46 - 493.15 ) x (275 days / 1,552 days) x (91 days / 275 days) = 381.20
1,552 days = depreciation residual duration, corresponding to the period [01/04/2006 - 30/06/2010]
275 days = residual duration in the fiscal year, equal to the period [01/04/2006 - 31/12/2006]
91 days = period duration [01/04/2006 - 30/06/2006]

(2) The new charge of 2006 fiscal year equals to:
493.15 + [(10,000 - 3,005.46) x (275 days / 1,552 days)] = 1,645.14


Depreciation start date greater than or equal to the current FY fiscal year start and less than the current period P start
  • Example 8

    Effectiveness: Depreciation start date
    Imposed terms: Recalculation od the charge of F fiscal year using the new method
    The charge of the P period contains the regulation of the charges of the closed periods.

    - Depreciation start date: 01/02/06 (i.e. 334 holding days)
    - Asset value: 10,000
    - Method: linear
    - Duration: 5 years
    - Current fiscal year: 01/01/2006 - 31/12/2006
    - Current period: 01/04/2006 - 30/06/2006
    - Duration change (extended to 4 years)

Fiscal year

Period

Total
fiscal year start

Fiscal
fiscal year

Fiscal
period

Total
period end

01/01/06 -
31/12/06

01/01/06 -
31/03/06

1,830.14

323.29

323.29

01/04/06 -
30/06/06

2,287.67

(1) 704.11

1,027.40

01/07/06 -
30/09/06

2,287.67

630.13

1,657.53

01/10/06 -
31/12/06

2,287.67

630.14

2,287.67

01/01/07 -
31/12/07

01/01/07 -
31/03/07

2,287.67

2,500.00

616.44

616.44

01/04/07 -
30/06/2007

2,287.67

2,500.00

623.29

1,239.73

01/07/07 -
30/09/2007

2,287.67

2,500.00

630.13

1,869.86

01/10/07 -
31/12/07

2,287.67

2,500.00

630.14

2,500.00

01/01/08 -
31/12/08

4,787.67

2,500.00

01/01/09 -
31/12/2009

7,287.67

2,500.00

01/01/10 -
31/12/10

9,787.67

212.33

01/01/11 -
31/12/11

10,000.00


(1) The charge of the fiscal year is recalculated using the new duration. The charge of the P period contains the depreciation total variance of the closed periods of the F fiscal year:
2,287.67 X (150 days / 334 days) = 1,027.40 - 323.29 = 704.11


Depreciation start date greater than or equal to the current FY fiscal year start and less than the current period P start
  • Example 9

    Effectiveness: P Period start date.
    Imposed terms: Recalculation of the "residual" fiscal year charge using the new method based on a residual mode. This charge of the "residual" fiscal year is distributed on the P period and the following of the F fiscal year.

    - Depreciation start date: 01/02/06 (i.e. 334 holding days)
    - Asset value: 10,000
    - Method: linear
    - Duration: 5 years
    - Current fiscal year: 01/01/2006 - 31/12/2006
    - Current period: 01/04/2006 - 30/06/2006
    - Duration change (extended to 4 years)

Fiscal year

Period

Total
fiscal year start

Fiscal
fiscal year

Fiscal
period

Total
period end

01/01/06 -
31/12/06

01/01/06 -
31/03/06

1,830.14

323.29

323.29

01/04/06 -
30/06/06

(2) 2,221.36

(1) 628.09

951.38

01/07/06 -
30/09/06

2,221.36

634.99

1,586.37

01/10/06 -
31/12/06

2,221.36

634.99

2,221.36

01/01/07 -
31/12/07

01/01/07 -
31/03/07

2,221.36

2,519.26

621.19

621.19

01/04/07 -
30/06/2007

2,221.36

2,519.26

628.09

1,249.28

01/07/07 -
30/09/2007

2,221.36

2,519.26

634.99

1,884.27

01/10/07 -
31/12/07

2,221.36

2,519.26

634.99

2,519.26

01/01/08 -
31/12/08

4,740.62

2,526.16

01/01/09 -
31/12/2009

7,266.78

2,519.26

01/01/10 -
31/12/10

9,786.04

213.96

01/01/11 -
31/12/11

10,000.00


(1) The charge of the method change period is calculated as follows:
(10,000 - 323.29 ) x (275 days / 1,402 days) x (91 days / 275 days) = 628.09
1,402 days = depreciation residual duration, corresponding to the period [01/04/2006 - 31/10/2006]
275 days = residual duration in the fiscal year corresponding to the period [01/04/2006 - 31/12/2006]
91 days = period duration [01/04/2006 - 30/06/2006]

(2) The new charge of 2006 fiscal year equals to:
323.29 + [ (10,000 - 323.29 ) x (275 days / 1,402 days)] = 2,221.36


Tab Extended selection

This tab is used to enter the assets 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 entry of a selection criterion is performed as follows:

1/ Enter a field or  use the Lookup tool to select one from the FXDASSETS - assets table.

2/ 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 and you can use wild card characters.

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.


Batch task

This function can be run in batch mode. The standard task FASTRFC is provided for that purpose.

Specific Buttons

Check

This button leads to the display of a control window containing two tables:

  • The first table contains the list of selected assets and presents for each of the assets their new accounting allocations where no error has been detected. The potential lines with errors are identified by color display.
    This list can be updated by deleting the lines corresponding to the assets to be excluded from the process.
      
  • The second table contains the depreciation plans for the asset highlighted by the cursor in the first table and for which a depreciation method change has been carried out.

    It is used to:

    - Identify, by the color display, any lines with errors along with their corresponding error messages. An asset with an error is not updated with the new parameters; it is displayed with the parameters of the original method.

    - Modify/correct, if necessary, one or several method parameters. After correction, the line for the asset that is now free from errors, is no longer displayed in a specific color,


If you enter the Rate, select To be recalculated from the Action icon menu to cancel the entry and to re-zero the field.
The rate is automatically loaded during the next calculation.
 
Click Save to validate any modification of one or more depreciation parameters carried out on an asset . To cancel the modifications under way on the asset, click Cancel. After the manual adjustments are complete, click End to close the control window. The parameter entry window is displayed again, making it possible to either confirm the mass update by clicking OK or to cancel the update by clicking End.

Memo

AFC/CPTVAL/70/20

Recall

AFC/CPTVAL/70/30

Delete Memo

AFC/CPTVAL/70/40

Error messages

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

If the specific rule no longer applies at the purchase date, make sure you have the rights to apply it.

This message relates to the 40% deduction [15/04/15-14/04/17] Specific rule for a French company.

It displays when the asset purchase date is after 14/04/17, either changed or entered on creation. You can select Yes or No to dismiss the message.

Yes: Applies the rule even if the purchase date is past 14/04/17.

No:   Creation or updates are not applied and you need to change the Specific rule to None or cancel the action.

Tables used

SEEREFERTTO Refer to documentation Implementation