I have two entities that I need to model in NetSuite:
[LIST]
[*]Physician (basically a contact with a few extra fields)
[*]Insurance Company (very basic requirements; address, contacts, name and some child records)[/LIST]I'm REALLY struggling with whether I should continue to use custom records for these entities or if I should abandon that and extend a built in record (Customer or Contact) to model physicians and ins. co.
I've found myself adding fields like:
[LIST]
[*]Address 1
[*]Address 2
[*]State
[*]Contacts (child records)
[*]Phone
[*]Fax
[*]etc[/LIST]
Obviously these are all fields that exist on the built in records.
The main reason I'm NOT using built in records is that it's very difficult to differentiate a Physician (represented by a Customer record) from a regular customer in the UI. The same is true for Insurance Companies. My users will be VERY confused if they try to create a new Physician and the form says "Customer".
I found a couple hacks here and there to try to fake them out, but it's too much work.
Another example is creating a case, in the Customer drop down I can't have 20k physician's showing up, that would be terrible.
So I think I just answered my own question, but as someone who has designed several databases and maintains a few at this time it drives me nuts knowing that NetSuite has this perfect "Entity" table that they use for:
[LIST]
[*]Customers
[*]Contacts
[*]Vendors
[*]etc[/LIST]In a perfect world this is what I would be able to do:
[LIST=1]
[*]Setup->Customization->Entities->Types->New
[*]Give it a name (IE: "Physician")
[*]Specify an Icon
[*]Check the "Show in Relationships List" option
[*]Do other stuff, I dunno...[/LIST]
To me this doesn't seem like it would be all that hard. NetSuite would add a new entry in the Entity_Type table (I'm guessing, but I bet there is one) for "Physician", a default form would be created and to the rest of my customization efforts it would appear as though there was a legit new record called "Physician" with all the goodies that entities should have.
Would anyone else like that? NetSuite.... this wouldn't be that hard, would it?
Anyway, I'm just venting at this point. I contemplated deleting this post, but maybe someone will have some ideas for me.
Sigh...
-Steve