Hi everyone
We have an issue with reversing migrated fixed assets in bulk. hoping that someone could offer some ides.
We have over 100 fixed assets migrated that need to be reversed.
The issue is that these assets contains fixed asset transactions that had both no GL batch (from migration - purchase+ and depreciation +) and GL batch (depreciation + after migration).
If we reverse this fixed asset with GL turned on, it will also create GL transactions reversing purchase and depreciation from migration.
solution 1) Reverse with GL turned on, find a way to journal back the purchase transactions that should not have GL batch. Issue: unable to identify reversal transitions against original. system does not create a reference.
solution 2) reverse with GL turned on. when fixed asset is migrated again correctly, leave GL on. system will create purchase transaction with GL to make up for the asset account balance. issue: will not be able to migrate “depreciation to period” and “accumulated depreciation”. will have to manually create fixed asset transactions “depreciation+”
many thanks for your suggestion.