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
