Setting up Corporate Accounting and Reporting in Fixed Asset Transactions
'Settings - Fixed Asset Acquisition' (FAS900)
If the corporate accounting and reporting parameter is used in (FAS900), the accounting ledger-specific adjust value type must be defined.
'Corporate Accounting. Specify Vo Nbr Ser' (GLS085)
- FA30 - Extraordinary depreciation and FA90-revaluation
The accelerated depreciation or revaluation of depreciation types connected to 2-'Corporate', 3-'Additional 1', and 4-'Additional 2' will use (GLS085) to retrieve the next voucher number series.
- FA40 - Disposal, FA50-Sales, FA70-Movements
The depreciation and adjustment reversal for all acocunting ledgers will use (GLS085) to retrieve the next voucher number.
'General Ledger. Update Additional Info' (GLS950)
Additional information 40 must be defined. It is created when multiple vouchers are created by a fixed asset transaction. This additional information consists of fixed asset ID, fixed asset sub-number, and fixed asset transaction number
Additional information 40 is used on fixed asset transactions generating multiple vouchers; fixed asset movement (change in financial ownership), fixed asset split/divide, fixed asset sale, fixed asset disposal, and fixed asset revaluation.
'FAM Function. Open' (CRS405)/ 'FAM Function. Open Detail' (CRS406)
FAM function, FA51-Acquisition reversal, is used in FA50-Sales.
The total acquisition cost reversal is written on a separate voucher when a fixed asset is sold. The book of account must be connected to a voucher series with voucher type 0-'Common'.
Fixed Asset Transaction Voucher Number Handling
During corporate accounting and reporting, the voucher number series is retrieved using the year from the accounting date of the transaction.
The depreciation type is connected to the corporate accounting ledger and is connected to period type 4. 'System Calendar. Open Period' (CRS910) which is set to begin in April of the previous year and end in March of the current year.
If the fixed asset was acquired on 20220601, this falls on the third period of the fiscal year 2023. The year-to-date depreciation is run on 202303. The voucher number that will be retrieved is from 2022, which is the year from the accounting date.
To illustrate:
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 |
'Voucher Number Series. Open' (CRS410) used for FA10-Depreciation
| Book of account | From date | Start number | Final number | Last used |
|---|---|---|---|---|
| P10 | 230101 | 231000 | 231999 | - |
| PD2 | 230101 | 232000 | 232999 | - |
| PD2 | 240101 | 242000 | 242999 | - |
Fixed asset 0000000020/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.
Below are the year-to-date depreciation runs on each depreciation type:
| FHACDT | FHVPER | FHVATP | FHFAVA | FHVSER | FHVONO | FHAOTP | FHALDG | FHCHID |
|---|---|---|---|---|---|---|---|---|
| 20230831 | 202308 | 12 | 1000 | P10 | 231000 | 1 | 1 | USER1 |
| 20230930 | 202309 | 12 | 1000 | P10 | 231001 | 1 | 1 | USER1 |
| 20230831 | 202405 | 22 | 1000 | PD2 | 232000 | 2 | 2 | USER1 |
| 20230930 | 202406 | 22 | 1000 | PD2 | 232001 | 2 | 2 | USER1232001 |
Journal Number Series
When setting up corporate accounting and reporting in fixed asset transactions,, the journal number series is retrieved using the year from the accounting date of the transaction.
To illustrate, the depreciation type is connected to the corporate accounting ledger and is connected to period type 4. 'System Calendar. Open Period' (CRS910) is set to begin in April of the previous year to March of the current year.
The fixed asset was acquired on 20220601, which falls on the third period of the fiscal year 2023. The year-to-date depreciation is run on 202303. The voucher number that will be retrieved is from 2022, which is the year from the accounting date.
'Settings - Fixed Asset Acquisition' (FAS900)
These adjusments can be added to a fixed asset:
- Adjustment local
- Adjustment corporate
- Adjustment additional 1
- Adjustment additional 2
Adjustments can only be done through 'Journal Voucher. Enter' (GLS100).
To illustrate, if a fixed asset cost needs to be adjusted in the corporate accounting ledger, the GL01 book of account must be connected to a 2-'Corporate' voucher type. The adjustment does affect thet total acquisition cost of the fixed asset. The adjustment, however, affects the depreciation calculation.
'FA Depreciation Type. Open' (FAS050)
The depreciation type must belong to 1-'Accounting ledger'.
The accounting ledger field decides the period type to use in the depreciation type-specific transaction.
If the depreciation type updates the general ledger, the voucher type connected to FA10 is the same as the accounting ledger used.
For the derogatory depreciation type, the associated depreciation must belong to the same accounting ledger.
You can no longer set the field 'External/Internal depreciation' to 2-'Internal' since it is already managed by corporate accounting and reporting additional features for fixed assets.
'Settings - Asset Revaluation' (FAS910)
The depreciation types used for the fixed asset revaluation must use the same accounting ledger.