You’re offline. This is a read only version of the page.
Hello there,
I'm here seeking for some help about the GP Fixed assets module.
So far, the assets depreciations are all calculated using Excel sheets and entered manually into GP with GL entries which is long process to do every months. To save time, they decided to use the Fixed Asset module. So my job is to enter lot of assets, make sure GP calculate expected amounts and test features to fully integrate Fixed assets with Purchasing and payable modules. I don't think it's going to be a big deal. More than half the job is already done and seems to work as intended.
My problem is: some of our assets have their depreciations calculated in a very ODD way. And when I say "odd", I mean, "really uberly odd". It's nothing close to any real accounting method. Yes, I'm try to convince them to change it for something that would make more sense like "Straight-line" and they'll probably do it. But for now, my job is to enter all assets since may 2014 and make sure GP calculates the depreciations as they did until today. So I have to use that "odd" method if I want to reproduce the same amounts.
Is there a way to have custom depreciation tables?
I read a lot on the Internet, tons of user guides and Microsoft courses but I found nothing that could help me. So I was seeking help here where I could maybe find some experts on that module. :)
I mention I was trying to use ACRS table to do it. And it could have worked. Problem is ACRS table only use one decimal and it lacks precision alot. Maybe if I could get 2 decimals, I could make a work around until they aknowledge to change for "Straight-line". Any way (even using SQL) to have 2 decimals in ACRS tables?
I appreciate help you all will provide. Thanks very much and have a nice day!
Florence
*This post is locked for comments
Hello Roger,
Yep, we were investigating this while you were posting your reply and we realized that this field was stored as smallint and that we would be stuck with it anyway even if we were trying to modify the input window.
Really unfortunate. :(
And we made so much research that we don't believe there is any trick to have custom depreciation. Still, if any user, very experienced with fixed assets module, knows a trick that could help us, we would be glad to hear from it. :)
Well, after a discussion with the accountant, he decided to change method for something more appropriate and they'll run "straight-line" for 2016 and future years. This ACRS table will only be used for historical purpose and so we'll use rounded rate and try to get amount as close as possible to what they calculated in the past.
Hopefully, in the future, GP will have a custom depreciation method for those exceptions. But I believe that using more traditional accounting methods is always the best and I'm glad they made the change.
Thanks for your help!
Wish everyone a nice day and a good week-end!
Regards,
Florence
Unfortunately Florence, the DYNAMICS..ACRSTBL uses smallint to store the percentages so it looks like the smallest you can do in that table is one decimal point equivalent. 4.0 percent is 40 in the tables.
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 (