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
- 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'
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'.
- 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.
- 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 2024Period 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
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.
FHSEQ7 | FHACDT | FHVPER | FHVATP |
---|---|---|---|
20231010000000050 | 20230801 | 202308 | 1 |
20231010000000100 | 20230801 | 202308 | 10 |
20231010000000150 | 20230831 | 202308 | 12 |
20231010000000250 | 20230930 | 202309 | 12 |
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:
FHSEQ7 | FHACDT | FHVPER | FHVATP |
---|---|---|---|
20231010000000200 | 20230831 | 202308 | 22 |
20231010000000300 | 20230930 | 202309 | 22 |
FHFAVA | FHVOTP | FHALDG | FHCHID |
---|---|---|---|
1000 | 0 | 0 | USER1 |
1000 | 0 | 0 | USER1 |
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)
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 |