# Asset Management Module **Category:** [Epicor ERP 10](https://www.epiusers.help/c/e10/5) **Created:** 2016-10-11 14:38 UTC **Views:** 16131 **Replies:** 17 **URL:** https://www.epiusers.help/t/asset-management-module/35767 --- ## Post #1 by @asmith1057 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! --- ## Post #2 by @acicala 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.com

--- ## Post #3 by @asmith1057 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 --- ## Post #4 by @Edge DMT supports asset additions --- ## Post #5 by @acicala 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.com

FixedAssetDMT.xlsx (45.3 KB) --- ## Post #6 by @asmith1057 Thanks! That helps a lot! --- ## Post #7 by @asmith1057 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? --- ## Post #8 by @acicala 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.com

--- ## Post #9 by @asmith1057 Thanks Andy, one last question. Do you know companies that use the module for asset tracking and capitalized assets or just capitalized assets? --- ## Post #10 by @acicala 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.com

--- ## Post #11 by @bmanners 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 --- ## Post #12 by @asmith1057 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 --- ## Post #13 by @asmith1057 Does anyone know how to mass delete out of the setup asset screen (Asset maintenance)? Anthony --- ## Post #14 by @remke_e10help 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! --- ## Post #15 by @efalkowski 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? --- ## Post #16 by @acicala 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 [ 35 South Jefferson Road Whippany NJ 07981](https://www.google.com/maps/place/35+S+Jefferson+Rd,+Whippany,+NJ+07981/@40.8248638,-74.4376433,17z/data=!3m1!4b1!4m5!3m4!1s0x89c3a7b1349a620b:0xd45740a13e27d585!8m2!3d40.8248638!4d-74.4354493) [stephengould.com](http://www.stephengould.com/) --- ## Post #17 by @efalkowski 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 --- ## Post #18 by @acicala 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) --- **Canonical:** https://www.epiusers.help/t/asset-management-module/35767 **Original content:** https://www.epiusers.help/t/asset-management-module/35767