web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Best way to setup entities for Fixed Asset Tracking

(0) ShareShare
ReportReport
Posted on by

I'm currently trying to setup a way of registering Fixed Assets in CRM 2011 On Premises (RU 15). I've created a bunch of entities and it's starting to look good. The bit I'm a little stuck with at the moment is the best way of converting my assets into entities.

I currently have an "asset" entity that contains things such as the make, model and type of asset. For instance a Dell E5500 Laptop. My question is around how best to record the details of the asset. For instance I would want to record the CPU, RAM, Screen Size, HDD, MAC addresses and so-on of the laptop. But if the asset were a TV instead, I wouldn't need most of the fields that were suitable for the Laptop asset type.

I could turn the "asset" entity into a super entity that contains dozens of fields and then organise them on the form in sections using script to show and hide the relevant bits. But that seems extremely wasteful, and it will be a bit of a nightmare to manage if I need the same field to appear in several different sections (such as Screen Size needing to be in both the Laptop and TV sections).

The alternative is that I create a separate entity for each asset type. This will allow me to collect exactly the information I need for the type of asset that I'm adding. The downside of this is that I'm not sure how to set it up on my main "asset" form so that it shows me a 'sub form' if you like where I can enter the details of my new asset. A subgrid would probably be OK for looking at assets that have already been added to the system, but I don't think it'll work for adding new ones.

Having to go into the laptop entity, enter some details, and then go into the asset entity and enter some details and then tie the two records together is going to unwieldy and prone to errors, hence my desire to try and get everything on one form.

I appreciate some custom code is likely to be needed, and I'm quite prepared to roll up my sleeves and get stuck in, I'm just not sure of the best way to organise things so that I don't either paint myself into a corner, or end up with a system that's so awkward to use that it will be ignored.

Thanks in advance for any suggestions you may have.

Phil.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    ScottDurow Profile Picture
    21 on at

    Hi! It sounds like you have a good understanding of the options. The most common approach is to add all attributes to the order product entity but if this results in >100 attributes create a N:1 relationship to multiple sub-product entities. If this approach isn't going to work (and it sounds like you have explored them already) you'll need to use a custom solution such as http://acquire.cincom.com

    I don't recommend developing your own solution because the product attribute functionality in CRM2015 will likely fit your needs.

    Hope this helps,

    Scott

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans