You’re offline. This is a read only version of the page.
75,730
*This post is locked for comments
Richard,
Yes, you can set up one asset with averaging convention ‘Mid-Month (15th)’ while others with full period. Just set/change the Averaging Convention to ‘Mid-Month (15th)’ using Asset Book window (Cards >> Fixed Assets >> Book)
Even when assets are depreciated in group, depreciation is calculated based on each asset’s Depreciation Method and Averaging Convention.
Depreciation Method depends upon how you want the depreciation amount is calculated. You can read Depreciation methods and calculations in fixed asset documentation for information related how monthly depreciation is calculated for each depreciation method.
You can use the ‘Straight-Line Orig Life’ and the Switchover ‘No Switch’ with the Averaging Convention to ‘Mid-Month (15th)’.
Rubal,
Rubal, I have a follow up fixed asset question. This is regarding depreciation methods. Since I’ve been using the system I’ve set up all assets as per below.
I’ve always used ‘Full Period’ for the averaging convention. Now we are being asked to set up just one asset and calculate mid-month depreciation.
I noticed that I can select ‘Mid-Month (15th)’ for my averaging convention. The place in service date will most likely be the 11th for this particular asset.
My question is can we have just one asset set up with Mid-Month depreciation while the rest are full period?
Also, would the Depreciation Method remain ‘Straight-Line Orig Life’ and the Switchover ‘No Switch’.
I just wanted to check with you since I’ve never had any assets set up this way.
You are welcome!
Rubal, thank you for your prompt and thorough explanation. I do not do much with Fixed Assets so I was bit lost here.
Y6685.Report2.pngou can undo depreciation using the Depreciate Asset window (Microsoft Dynamics GP menu >> Tools >> Routines >> Fixed Assets >> Depreciate One Asset). Just enter the target date in past.
You can undo depreciation for one asset at time. You cannot undo depreciation for multiple assets at a time.
Also, you can only undo deprecation of asset for current year only. You will need to change the year in Book set up window for backing out depreciation of last year.
Summarized steps are:
1. Use the Depreciate Asset window (Microsoft Dynamics GP menu >> Tools >> Routines >> Fixed Assets >> Depreciate One Asset) to undo depreciation up to 12/31/2010.
2. Change the Current Fiscal Year to 2010 using Book Setup window(Microsoft Dynamics GP menu >> Tools >> Setup >> Fixed Assets >> Book)
3. Use the Depreciate Asset window (Microsoft Dynamics GP menu >> Tools >> Routines >> Fixed Assets >> Depreciate One Asset) to undo depreciation up to Placed In Service Date.(I am assuming assets were placed in service in 2010)
4. Change back the Current Fiscal Year to 2011 Book Setup window(Microsoft Dynamics GP menu >> Tools >> Setup >> Fixed Assets >> Book)
5. Post the undo transaction to GL using the Fixed Assets General Ledger Posting window(Microsoft Dynamics GP menu >> Tools >> Routines >> Fixed Assets >> GL Posting)
6. Use the Fixed Assets to General Ledger Reconciliation report (Reports >> Fixed Assets >> Activity >> select Fixed Assets to General Ledger Reconciliation) to get any other transactions details
a. Generate report summary format for assets you want to delete
b. You will need to reverse the account balance displayed in report. I have added screenshots of the report below
7. Enter the GL adjust for transaction prepared in last steps
8. Delete the asset using Asset Delete Utility window (Microsoft Dynamics GP menu >> Tools >> Utilities >> Fixed Assets >> Delete)
You can test these steps in Test environment before making changes in live company.
Screenshots
Note: depreciation and accumulated depreciation are zero after undo depreciation.
Rubal,
Thank-you for the information. I’m not sure where I would go in the Fixed Asset System to select ‘undo depreciation’ though. So if I need to reverse 2010 depreciation and 2010 is already closed I would need to post the total amount in one period? Most likely Dec. 2010.
Also, I assume I would reverse the depreciation and then delete the asset. Are there any other steps?
Richard,
You can undo the depreciation of the asset by specifying the target date in the past. You will need undo depreciation upto the “Placed In Service Date” of the asset to completely reverse the depreciation. Use the post to Fixed Assets General Ledger Posting window to post the undo depreciation transactions. If periods are already closed, you can post summary transaction in one period. If periods are not closed, you can post each period’s undo depreciation in corresponding period.
You will need to manually enter a GL adjustment entry to reverse to any remaining transactions related to the assets. You can use the Fixed Assets to General Ledger Reconciliation report (Reports >> Fixed Assets >> Activity >> select Fixed Assets to General Ledger Reconciliation) to get details of transactions. Enter the Asset ID in report restriction. Prepare the adjustment entry before deleting the asset because once asset is deleted, you will not be able to generate the report for it.
You can use the Asset Delete Utility window (Microsoft Dynamics GP menu >> Tools >> Utilities >> Fixed Assets >> Delete) to delete the asset. Please note that this window only removes the asset related records from Fixed Assets module.
Rubal,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (