Sage CRM

Sage CRM v7.1.d.4 s... Trying to delete custom fields but the delete button is missing from this installation. Any ideas?

Aaron, are you the only one doing CRM installs and are just having these challenging situations or are you the only one having these challenging situations? Not talking to your evil twin these days?

@AaronClark - Are you 100% certain this is a field added by you (or your client)? Are there delete buttons for any custom fields? To test, create a dummy field on Company entity. Click the field and check if Delete is there. If the delete button shows up, something odd has happened to your database. If it doesn't show up, we can still resolve the problem but it is very unusual to say the least. BTW - the resolution is: 1. Go into MS SQL. 2. Pull up the Custom_Edits table. 3. Find the field in question (use the colp_colname field). 4. Set Colp_CanDelete = 'Y'. That should work.

@JeffSchwenk: I honestly don't know. Maybe I'm the only one who cares enough to fix these things. :-) Who knows. @PeterWolf: I am 100% certain that I added the field. I added it myself this morning to show the client what it would look like. I don't think Sage would like a field called ""comm_dummy."" I have a feeling that there are some deeper system issues here -- I've had a couple of time-outs when running some of the queries today.

Bizarre. My fix should still work for you. Please let me know. Regarding the time-outs, how much data is there in Sage 100 and in Sage CRM? We talking about 10s of thousands of customers or more? Which queries are timing out?

675 customers. It's a brand new CRM install. The query that was timing out was the stored procedure ""fixViewsMetadata."" And yes, the fix did work. Thank you very much for that.