Creation of a fixed asset disposal created duplicate Acquisition and Disposal lines, asset balance is zero, but negative balance left on asset roll forward report.
How should you correct this.
Voucher Transaction date Fixed asset number Transaction type Amount Fixed asset group
FAACQ-00000098 01/12/2021 VEHCO000240 Acquisition 4153.6 MOTOR_O
FADEP-00003962 31/12/2021 VEHCO000240 Depreciation -346.13 MOTOR_O
FADEP-00003962 31/12/2021 VEHCO000240 Depreciation adjustment -424.29 MOTOR_O
FADEP-00006620 31/01/2022 VEHCO000240 Depreciation -346.13 MOTOR_O
FADEP-00008013 28/02/2022 VEHCO000240 Depreciation -346.13 MOTOR_O
FADEP-00010644 31/03/2022 VEHCO000240 Depreciation -346.13 MOTOR_O
FADEP-00013327 30/04/2022 VEHCO000240 Depreciation -346.13 MOTOR_O
FADEP-00014612 31/05/2022 VEHCO000240 Depreciation -346.13 MOTOR_O
FADEP-00015947 30/06/2022 VEHCO000240 Depreciation -346.13 MOTOR_O
FADEP-00018435 31/07/2022 VEHCO000240 Depreciation -346.14 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Depreciation adjustment -11.18 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Depreciation adjustment -3.14 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Disposal - scrap 0.00 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Disposal - scrap 0.00 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Net book value 949.08 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Net book value -3.14 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Acquisition (prior years) -4,153.60 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Acquisition (prior years) -4,153.60 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Depreciation (prior years) 346.13 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Depreciation (prior years) 346.13 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Depreciation (this year) 2,422.92 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Depreciation (this year) 2,422.92 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Depreciation adjustments (prior years) 424.29 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Depreciation adjustments (prior years) 424.29 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Depreciation adjustments (this year) 11.18 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Depreciation adjustments (this year) 14.32 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Profit/Loss -949.08 MOTOR_O
FADPL-00001359 01/08/2022 VEHCO000240 Profit/Loss 3.14 MOTOR_O
Roll Fwd Report -949.08
Disposal parameters are Disposal Scrap - Posting profiles are below.
Book Groupings Account relation Post value Sales value type Main account Offset account
SLLR Group MOTOR_O Depreciation (prior years) All 100509 800799
SLLR Group MOTOR_O Depreciation (this year) All 100509 800799
SLLR Group MOTOR_O Net book value All 800799 800799
SLLR Group MOTOR_O Acquisition adjustments (this year) All 100504 800799
SLLR Group MOTOR_O Acquisition adjustments (prior years) All 100504 800799
SLLR Group MOTOR_O Acquisition (this year) All 100504 800799
SLLR Group MOTOR_O Acquisition (prior years) All 100504 800799
SLLR Group MOTOR_O Depreciation adjustments (this year) All 100509 800799
SLLR Group MOTOR_O Depreciation adjustments (prior years) All 100509 800799
I think the issue is that this asset is linked to a Main fixed asset and when the asset NBV was move to this new asset the Create depreciation toggle was not turned on, so has created duplicate Disposal entries.
The journal posted was of transaction type Disposal - Scrap with no values.
Not sure why but I'm unable to post screen shots.
Hi DonDon,
Can you share the setup of the disposal parameters for the asset group linked to this asset? It may be the case that there are too many lines or another wrong configuration.
Can you also share a screenshot if the asset roll forward report?
Hi @DonDon
Can you share a screenshot of a Journal you posted and output you are seeing in Finance & Operation?
Has anyone modified the Roll Forward report?
Please check standard Report and Book Transaction for better clarification.
Let us know if this helps.
Thanks,
André Arnaud de Cal...
292,074
Super User 2025 Season 1
Martin Dráb
230,900
Most Valuable Professional
nmaenpaa
101,156