Home » TIPS AND TRICKS BY MODULES » Fixed Asset Management
Top Websites
- Dynamics GP Help
Over 6300 resources listed. - Mark Polino's DynamicAccounting.net
Over 5100 resources listed. - Rose Business Solutions Blog New
Over 2200 resources listed. - Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
Over 1100 resources listed. - Mariano Gomez at The Dynamics GP Blogster
Over 1000 resources listed. - Microsoft Dynamics Partner Community Blog
Over 900 resources listed. - Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
Over 700 resources listed. - Mohammad Daoud's Dynamics GP Blog
Over 600 resources listed. - Vaidy Mohan at Dynamics GP - Learn & Discuss
Over 500 resources listed. - Inside Microsoft Dynamics GP Official Blog
Over 500 resources listed. - eOne Business Solutions Blog
Over 400 resources listed. - About Dynamics, Development and Life
Over 300 resources listed. - Frank Hamelly at GP2theMax
Over 300 resources listed. - Dynamics CPM
Over 300 resources listed. - BKD Dynamics GP Insights Blog
Over 200 resources listed. - Leslie Vail at Dynamics Confessor Blogspot
Over 200 resources listed. - Victoria Yudin's Dynamics GP Website
Over 200 resources listed.Victoria Yudin - Janakiram M.P. at DynamicsBlogger
Over 100 resources listed. - VS Tools Forum
Over 100 resources listed.Your Resource for Visual Studio Tools for Dynamics GP - Inside Microsoft Dynamics GP Official Blog
Over 100 resources listed. - US Dynamics GP Field Team Blog
Over 100 resources listed. - Catherine Eibner MBS Developer Evangelist
Over 100 resources listed. - Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
Over 100 resources listed. - Dynamics Small Business
Over 100 resources listed. - Belinda, The GP CSI
Over 100 resources listed.
Useful Dynamics GP Links
Search all GP Blogs, Groups and Forums New!
GPWindow is Everything Dynamics GP. Try the Custom GP Search engine which searches high quality GP Blogs, and the Microsoft Dynamics GP Community Forums.
Parent Category: Fixed Asset Management
Links Sort by: Hits | References | Alphabetical
gptip42day - Year-End Close - Fixed Assets
Closing Fixed Assets for the year increases the current Fiscal Year by one year for each book being closed and changes the Year-to-Date Depreciation Amount and YTD Maintenance…
http://gp2themax.blogspot.com/2009/10/gptip42day-year-end-close-fixed-assets.html
Closing Fixed Assets for the year increases the current Fiscal Year by one year for each book being closed and changes the Year-to-Date Depreciation Amount and YTD Maintenance…
Posted by
SQL view for Fixed Assets depreciation in Dynamics GP
http://victoriayudin.com/2010/04/07/sql-view-for-fixed-assets-depreciation-in-dynamics-gp/
Fixed Assets Depreciation Error: Target Date’s fiscal year may not be greater than the current fiscal year for the selected book
http://mohdaoud.blogspot.com/2010/02/fixed-assets-depreciation-error-target.html
You might get an error when trying to depreciate your assets upon the new year as below:
“Target Date’s fiscal year may not be greater than the current fiscal year for the selected…
Posted by
GPTip42day - How do I add a Fixed Asset but not depreciate it?
Occasionally, you may want to add an asset and not depreciate it. This is very simple to…
http://gp2themax.blogspot.com/2010/04/gptip42day-how-do-i-add-fixed-asset-but.html
Occasionally, you may want to add an asset and not depreciate it. This is very simple to…
Posted by
gptip42day - Modify Acquisition Cost of a Fixed Asset
Let's say someone added an asset and transposed some of the numbers in the Acquisition Cost field. Is there a simple way to correct it? Of course!
http://gp2themax.blogspot.com/2009/12/gptip42day-modify-acquisition-cost-of.html
Let's say someone added an asset and transposed some of the numbers in the Acquisition Cost field. Is there a simple way to correct it? Of course!
* click image to enlarge
Open your Fixed Asset General card. See the blue expansion arrow next to the Acquisition Cost field? Click on it to…
Posted by
gptip42day - MACRS Depreciation in GP
A question I run into rather regularly from users is 'Where do I enter the MACRS tables?'. Well, the short answer is, you don't. GP doesn't utilize MACRS tables for calculating MACRS depreciation. Instead, it uses a combination of the many different depreciation methods and averaging conventions available in GP to simulate MACRS.
http://gp2themax.blogspot.com/2009/10/gptip42day-macrs-depreciation-in-gp.html
A question I run into rather regularly from users is 'Where do I enter the MACRS tables?'. Well, the short answer is, you don't. GP doesn't utilize MACRS tables for calculating MACRS depreciation. Instead, it uses a combination of the many different depreciation methods and averaging conventions available in GP to simulate MACRS.
Now, for those of you asking, 'What the heck is MACRS?, the short answer is, can you spell IRS? MACRS stands for Modified Accelerated Cost Recovery System, allows for…
Posted by
gptip42day - Fixed Asset Calendar with more than 12 Periods
Having more than 12 periods in your Fixed Asset Calendar can cause undesirable behavior with depreciation calculation and posting, especially if you make the mistake of running & posting depreciation in the 13th or greater period. I've had to completely clear and rebuild depreciation tables for clients because of this. Here's how to prevent such issues -
http://gp2themax.blogspot.com/2009/09/gptip42day-fixed-asset-calendar-with.html
Having more than 12 periods in your Fixed Asset Calendar can cause undesirable behavior with depreciation calculation and posting, especially if you make the mistake of running & posting depreciation in the 13th or greater period. I've had to completely clear and rebuild depreciation tables for clients because of this. Here's how to prevent such issues -
1. If you have not yet setup your company, regardless of the number of periods you ultimately want to have in your Fiscal Calendar, set it up with 12 periods first. Then build the Fixed Asset Calendar. The FA Calendar is based on…
Posted by
Recommended byhttp://msdynamicsgp.blogspot.com/2009/09/gp-tips.html
Weekly Dynamic: Amortization vs. Straight Line Depreciation
http://msdynamicsgp.blogspot.com/2010/03/weekly-dynamic-amortization-vs-straight.html
Weekly Review: Putting the Fix in Fixed Assets
http://msdynamicsgp.blogspot.com/2009/10/weekly-review-putting-fix-in-fixed.html
Fixed sporting events are bad. Fixed transmissions are good. Fixed Assets are ...well... in between.
Today I want to look at some potential issues in the Fixed Asset module and what you can do about it. I'm using version 8 but these items should apply backwards and forward for several versions. There haven't been that many chages to FA. So here we go:
- The Fixed Asset module has it's own calendar in Tools-Setup-Fixed Assets-Quarter. You may think that this is no big deal, it's used for the mid-quater convention, yada yada. BUT if your Fixed Asset calendar is different from your financial calendar, you can have a mess! What can happen is that if you run depreciation only for the current period,…
Weekly Dynamic: Turning a Project into a Fixed Asset
http://msdynamicsgp.blogspot.com/2009/06/weekly-dynamic-turning-project-into.html
A common request is to turn a Project from the Project Accounting module, into a Fixed Asset in the Fixed Asset module. There is no native functionality to do this and based on my conversations with the Dynamics GP team, it's not coming any time soon so you might as well understand the workaround and it looks like this:
1) Create a Miscellaneous Log Cost Category for Fixed Assets pointing the Contra Account to the FA Clearing account and the…
1) Create a Miscellaneous Log Cost Category for Fixed Assets pointing the Contra Account to the FA Clearing account and the…
Weekly Dynamic: Matching Fixed Asset Costs In Multiple Books
http://msdynamicsgp.blogspot.com/2007/02/weekly-dynamic-matching-fixed-asset.html
As I work on year end tax returns for the company, one of the things we look at every year is our tax vs. book depreciation. One thing we find every year is that there are a few assets where the cost is different between tax and book. In our case, they should always be the same. It's getting better each year but we've still got a small handful this year.
This happens when we adjust the cost of an asset after the fact for additional costs that come in later. These are things like freight, tax, installation, etc. Sometimes these bills arrive 60 days after the asset is…
Posted by
Fixed Asset Integration error: "String was not recognized as a valid DateTime"
http://blogs.msdn.com/developingfordynamicsgp/archive/2010/01/29/fixed-asset-integration-error-string-was-not-recognized-as-a-valid-datetime.aspx
I recently had a support case, running a Fixed Asset integration with Integration Manager, where we received the following error:
DOC 1 ERROR: System.FormatException: String was not recognized as a valid DateTime.
at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
at System.DateTime.Parse(String s, IFormatProvider provider)
at System.Convert.ToDateTime(String…
Fixed Assets Integration fails
http://janakirammp.blogspot.com/2009/11/fixed-assets-integration-fails.html
Consider this scenario. You are implementing Dynamics GP Fixed Assets in your company. None of the Fixed Assets have been imported yet. You have ensured you did all your setups just perfect. Now, It’s turn to import your assets into Asset General window using Integration Manager. It can be handled using Integration Manager eConnect destination adapter for Fixed Assets.
You have…
Fixed Assets Averaging Convention
http://www.rosebizinc.com/gpblog/2009/11/fixed-assets-averaging-convention.html
Dynamics GP Fixed Assets With No Depreciation
http://mohdaoud.blogspot.com/2010/04/dynamics-gp-fixed-assets-with-no.html
Transfer Item From inventory site to a Fixed Assets Item
http://mohdaoud.blogspot.com/2010/03/transfer-item-from-inventory-site-to.html
Really liked the method Mariano used in this post to fulfill a need to have his fixed assets items moved out of the main…
Posted by
Fix Fixed Assets!!!
http://mohdaoud.blogspot.com/2009/10/fix-fixed-assets.html
Mark posted tips about fixed assets, check it out:
Posted by
GPTip42day - Should I be using Daily or Periodic Depreciation Period in Fixed Assets Book Setup?
http://gp2themax.blogspot.com/2010/06/gptip42day-should-i-be-using-daily-or.html
GPtip42day - Reopening a closed Fixed Asset fiscal year
I'm sure this has never happened to anyone, but if by chance you ever inadvertently close the Current FA Fiscal Year, it will prevent you from posting depreciation into any period in the current fiscal year. How do you get around that? It's pretty easy.
http://gp2themax.blogspot.com/2010/02/gptip42day-reopening-closed-fixed-asset_18.html
I'm sure this has never happened to anyone, but if by chance you ever inadvertently close the Current FA Fiscal Year, it will prevent you from posting depreciation into any period in the current fiscal year. How do you get around that? It's pretty easy.
Go Tools>Setup>Fixed…
Posted by
gptip42day - Recalculating Depreciation
http://gp2themax.blogspot.com/2010/01/gptip42day-recalculating-depreciation.html
When you make changes to depreciation-sensitive fields in an asset book record, depreciation needs to be recalculated. Changing any of the following fields requires recalculation –
• Amortization Code
• Amortization Amount
• Averaging Convention
• Cost Basis
• Depreciation Method
• Depreciated-to-Date
• Life-to-Date Depreciation
• Luxury Automobile
• Original Life
• Place-in-Service Date
• Salvage Value
• Switchover
• Year-to-Date Depreciation
• Special Depr Allowance
When you change any of these fields then click ‘Save’, this message appears –
* click image to…
Posted by
Latest links
- Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP
- SOP Quote Warning -Line item quantities are not fully distributed. Do you want to continue ?
- Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP
- SOP Quote Warning -Line item quantities are not fully distributed. Do you want to continue ?
- #PowerApps: Simple Object Proximity and Collision Detection
- Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP
- SOP Quote Warning -Line item quantities are not fully distributed. Do you want to continue ?
- Dynamics GP Update 1099 Information
- Microsoft Dynamics GP February Hotfix 2019 Including Electronic VAT Changes has released!!
- Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP
GPWindow.com
Thank you for your support for GPWindow. It helps us cover part of the hosting costs for GPWindow.