Has anyone used the Asset Management Module and if so did you find an easy way to get all the depreciation methods, Federal and state depreciation in there as well?
Thanks!
I have helped a couple of Epicor users implement asset management. You need to create the depreciation method “ids”, however, there are several “out-of-the-box” depreciation calculation methods:
-
Rate Straight Line -
Life Straight Line -
Sum of Year Digits -
Declining Balance -
Declining Balance to Straight Line -
MACRS -
User Defined formula
In my experience, they pretty much cover the gambit of depreciation methods.
Yes, you can have separate depreciation registers that are used to calculate Book, State and Federal depreciation using different depreciation methods, if you so choose
Andy Cicala
Partner
[TGem_final]
Delivering Effective Business Solutions
Mobile: (973) 615-5033
www.trigemco.com
Acicala@trigemco.commailto:Acicala@trigemco.com
Thanks!
I think I have everything going but when I import my assets that I have already depreciated is the only way to enter the depreciation one by one on the asset entry screen?
Anthony
DMT supports asset additions
You need to perform 3 different DMT’s
-
Assets -
Asset Register -
Asset Addition
You want the Asset Additions to have a type of MISC and the InterGroup flag needs to be set to true. The InterGroup flag is the magical flag that allows you to enter prior year/period depreciation.
I included the DMT maps for those as well.
Let me know if you have any questions
Andy Cicala
Partner
[TGem_final]
Delivering Effective Business Solutions
Mobile: (973) 615-5033
www.trigemco.com
Acicala@trigemco.commailto:Acicala@trigemco.com
FixedAssetDMT.xlsx (45.3 KB)
2 Likes
Thanks! That helps a lot!
I have all of the assets imported from the Asset Setup, but I have no way to import the assets to “Asset Addition”. We currently do not have DMT for Epicor. Do you know of any other way to import to “Asset Addition” without having to manually do it?
Argh!
Unfortunately no. If you’re a tech weenie, maybe you can build an updateable dashboard but I rely on guys like Jose to bail me out of those jams 
Andy Cicala
Partner
[TGem_final]
Delivering Effective Business Solutions
Mobile: (973) 615-5033
www.trigemco.com
Acicala@trigemco.commailto:Acicala@trigemco.com
Thanks Andy, one last question. Do you know companies that use the module for asset tracking and capitalized assets or just capitalized assets?
Both. If you don’t want to capitalize it, just create the asset. Don’t add it to the asset register or perform an asset addition. You can make it inactive when disposed.
Andy Cicala
Partner
[TGem_final]
Delivering Effective Business Solutions
Mobile: (973) 615-5033
www.trigemco.com
Acicala@trigemco.commailto:Acicala@trigemco.com
1 Like
Sometimes you can use the grid views to import data, I am not familiar with Asset Addition screens. Right click on the grid and select copy to excel. In excel add the rows you want to import. Then copy the excel data and right click on the grid and select paste insert. You many need to do a customisation on the form to add required fields if they are not shown on the grid.
Brett
The grid view on asset addition only allows you to add to one asset at a time. Even at that when you add it that way you cannot add depreciation to the import table.
Anthony
Does anyone know how to mass delete out of the setup asset screen (Asset maintenance)?
Anthony
Andy,
I see your post on setting up Assets dated November 2016. We are using 10.1.600.24. The templates may have changed. Where do I get the DMT maps/templates from? Do my existing assets have to be DMT’d in on all three DMT maps?
I also see that you mention MACRS as one of the out of the box depreciation methods. Can you direct me to how I find it?
Thank you!
We are using Straight Line Half Year (coming over form SAGE FAS) but do not see a way to create this formula using the custom method . Do you have a way to create this formula?
1 Like
Hi Ed
Hope all is well
If I read your question correctly, I think you could just get away with using straight line and a convention of half year. No need for a custom formula
My direct email is
ajcicala@stephengould.com. might be easier.
Andy Cicala
Manager, Applications
T
+1 973 428 1500 x172
C
+1 973 615 5033
2 Likes
The recommendation worked. However, the problem we have is how to import partially depreciated assets (we are importing form FAS)? The only way we get anything to work is to set the INTERGROUP flag to TRUE and we also have to have a value in CurrentCostValue field. This then inflates the total for the depreciation schedule by this amount (Book value is fine though). If you leave it BLANK then it won’t do anything. (perplexed). The only option I can think of is to try a DMT for these assets instead of just the IMPORT from the menu bar.
Thanks
Hi Ed
We are converting from Lawson but I don’t think that matters.
Yes, you are correct. In order to load Asset “beginning balances”, they MUST be loaded as Intergroup additions. I would suggest that you use DMT but you don’t
have to. Ifyou check the intergroup checkbox, the Previous years depreciation boxes will light up and allow you to enter that data. When I was testing, I just did it using the entry screens. You do need to have fiscal calendar that goes back to the earliest
asset acquisition date. I had to create calendar entries going back to 1999. I argued with Epicor over this because it didn’t always work this way, but it does now.
I attached a spreadsheet tool that I used to create the DMT data. The tool provides for 3 things – data import, data transformation, and creates the DMT data
for import into Epicor. There is an instructions tab. I had to DMT 3 tables, Assets, Asset Register Detail and then Asset Additions. The same order as if I was doing it manually.
On the tool, you will find the following tabs:
Fixed_Asset_DMT_Tool.xlsx (89.8 KB)