Activating Corporate Accounting and Reporting in Fixed Assets

This document explains how existing records in the fixed asset value per period table, FFAHIS, are updated. This also explains how you specify settings to enable fixed asset transactions to support multiple accounting ledger solutions.

Fixed Asset Value per Period table - FFAHIS

The fixed asset value per table FFAHIS includes these fields:
  • Sequence number - This determines the chronological sequence of the fixed asset transactions as recorded in FFAHIS.
  • Fixed asset transaction number - This determines where the transaction was created and groups the vouchers created during fixed asset sale, disposal, movement or recode, split /divide, and revaluation.

    Example: Fixed asset transaction number 'AP100000050' means that the transaction was created using a supplier invoice. Note that the first four characters are the FAM function used.

  • Accounting ledger - This holds the information to which the accounting ledger transaction belongs if the depreciation type does not update the general ledger.
  • Voucher type - This is updated if the fixed asset transaction updates the general ledger.
  • Accounting date - This holds the transaction accounting date. This is used in conjunction with the local accounting ledger period type setup in 'Company. Connect Division' (MNS100) to retrieve the journal number and the voucher number series.

Before running 'F16MMTOG00200'

Ensure that there is no erroneous transaction in 'Trans Work File. Restart Erroneous Jobs' (GLS037).

'Fixed Asset. Print Historical Values' (FAS530) must be printed correctly. This is important since the fix program uses an open query similar to the one used by this report.

After running 'F16MMTOG00200'

After running the fix program, all existing FFAHIS records that updated the general ledger prior to the activation of the corporate accounting and reporting for fixed assets are displayed in 'Fixed Asset. Display Vouchers' (FAS230), but without the fixed asset transaction number.
Note: The accounting date on the manually created fixed asset record is taken from the acquisition date of the fixed asset.

When the FFAHIS record does not update the general ledger, the value period 'To Date' from 'System Calendar. Open Period' (CRS910) is used as the accounting date.

Updated records in FFAHIS cannot be reversed.

Updating the Value Period

The value period (VPER) in FFAHIS is updated through 'FA Depreciation Plan. Create Automatic'. Option 4-Activate. Corporate accounting for fixed assets updates the value period according to the period type the depreciation type is connected to. The change ID in FFAHIS is updated with 'FASCAR'.

Before the update:
  • Corporate Accounting and Reporting must be enabled for the division with the appropriate balance keys set in 'Settings - Corporate Accounting' (GLS080).
  • (CRS910) must be defined and connected to the appropriate balance ketys in (GLS080).
  • Corporate accounting and reporting parameter must be used in 'Settings - Fixed Asset Acquisition' (FAS900).

    The value period (VPER) in FFAHIS is updated through 'FA Depreciation Plan. Create Automatic'. Option 4-'Activate corporate accounting for Fixed Assets'.

    Using the accounting date that was automatically set by the fix program 'F16MMTOG00200', the value period update is according to the period type the depreciation type is connected to.

    The change ID in FFAHIS is updated with FASCAR.

After the update:

The value period of the updated FFAHIS records is now according to the period type setup of the accounting ledger to which the depreciation type is connected to.

Example:
  • Depreciation type 10 is connected to 1-'Local' accounting ledger and is connected to period type 1
  • Depreciation type 10 is connected to 2-'Corporate' accounting ledger and is connected to period type 4
  • System calendar for period type 1:
    Year 2023
    Period From date To date
    01 20230101 202301031
    02 20230201 20230228
    03 20230301 20230331
    04 20230401 20230430
    05 20230501 20230531
    06 20230601 20230630
    07 20230701 20230731
    08 20230801 20230831
    09 20230901 20230930
    10 20231001 20231031
    11 20231101 20231130
    12 20231201 20231231
  • System calendar for period type 4:

    Year 2024
    Period From date To date
    01 20230401 20230430
    02 20230501 20230531
    03 20230601 20230630
    04 20230701 20230731
    05 20230801 20230831
    06 20230901 20230930
    07 20231001 20231031
    08 20231101 20231130
    09 20231201 20231231
    10 20240101 20240131
    11 20240201 20240229
    12 20240301 20240331
Depreciation type 10
Description Value type Remarks
Purchase value type 1 As defined in (FAS900)
Total acquisition cost 10 As defined in (FAS900)
Year-to-date depreciation 12

Depreciation type 20

Description Value type Remarks
Purchase value type 1 As defined in (FAS900)
Total acquisition cost 10 As defined in (FAS900)
Year-to-date depreciation 22

Fixed asset 0000000010/001 was purchased on 20230801 and was activated on 20230821 amounting to 24000. The fixed asset is set to be depreciated for two years and is connected to two different depreciation rules: depreciation type 10-'Linear' which updates the local accounting ledger; and depreciation type 20-Linear which updates the corporate accounting ledger. Two year-to-date depreciation runs were posted on the fixed asset.

The fix program was run in 20231010.

Depreciation type 10
Table 1.
FHSEQ7 FHACDT FHVPER FHVATP
20231010000000050 20230801 202308 1
20231010000000100 20230801 202308 10
20231010000000150 20230831 202308 12
20231010000000250 20230930 202309 12
(Continuation of Table 1)
FHFAVA FHVOTP FHALDG FHCHID
24000 0 0 USER1
24000 0 0 USER1
1000 0 0 USER1
1000 0 0 USER1

Depreciation type 20

After the fix program run:

Table 2.
FHSEQ7 FHACDT FHVPER FHVATP
20231010000000200 20230831 202308 22
20231010000000300 20230930 202309 22
(Continuation of Table 2)
FHFAVA FHVOTP FHALDG FHCHID
1000 0 0 USER1
1000 0 0 USER1
After running the 'FA Depreciation Plan. Create Automatic'. Option 4-'Activate corporate accounting for Fixed Assets':
Table 3.
FHSEQ7 FHACDT FHVPER FHVATP
20231010000000050 20230801 202308 1
20231010000000100 20230801 202308 10
20231010000000150 20230831 202308 12
20231010000000250 20230930 202309 12
20231010000000200 20230831 202405 22
20231010000000300 20230930 202406 22

(Continuation of Table 3)

Table 4.
FHFAVA FHVOTP FHALDG FHCHID
24000 0 0 FASCAR
24000 0 0 FASCAR
1000 0 0 FASCAR
1000 0 0 FASCAR
1000 0 0 FASCAR
1000 0 0 FASCAR