How can I view all contacts for all sub-accounts of accounts?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Crm
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Workflow question, regarding emailing to owner of another entity I am trying to create a workflow rule to send email to account owner after two weeks when service ticket regarding to account is closed. When I'm creating email I can only find following available logical users (account/contact, account, contact,owner's manager, owner). I need to send the email to account owner. Is this possible somehow?? example case. Customer Test has owner Ted Tester, and his team member creates service ticket to Customer Test and closes it. I would like to send email to Ted Tester after two weeks after ticket is closed. As a reminder. I can send the email to team member who own's the ticket. Or the customer directly, but not to the owner of the account. Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94765
  - 2
    - how to create relationship between Account and Contact relationshi Hey all- I'm writing an application that creates accounts in CRM 3.0 automatically using the web service. So far, so good. The problem I'm having is programmatically assigning accounts to the contacts. If my accounts are already created in CRM, I should just be able to grab their guid and assign it to the contact using contact.parentcustomerid, right? Well, if that's the case, what should the code look like? How do I assign values to the type of Customer? If that's not right, can someone point me in the right direction? I got this sample code from one forum but it doesn't work for me. Example 1) Change lookups with code like this: contact.parentcustomerid = new CRMLookup(); contact.parentcustomerid.value = account.accountid.value; contact.parentcustomerid.type = EntityName.account.ToString(); Example2) You can also use the helper class and just use: contact.parentcustomerid = CrmSdk.CrmTypes.CreateCustomer(account.accountid.v alue, EntityName.account.ToString()); I don't know why i can't use the above code? It gave me this exception Error 3 The type or namespace name 'CrmTypes' does not exist in the namespace 'CrmSdk' (are you missing an assembly reference?). Please help me to sort this out. Thanks in advance -- Thanks Sol Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94761
  - 3
    - List Price, Standard Cost, Current Cost Hello, It appears that the fields Total Amount and Detail Amount on an Oppurtunity, Quote, Order, Invoice are calculated from the Product Qauntity and Price Per Unit. I am trying to figure out how the following fields from Product are used or reported List Price, Standard Cost, Current Cost. cheers, Michael Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94760
  - 4
    - delete data Hello, we have CRM v3 installed in a test evironment. we have added test data for customers, products. we have created oppurtunities to invoices. we would like to delete all of this data. is there a way to do it without uninsalling and reinstalling the software? cheers, Michael. Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94757
  - 5
    - CRM 4.0 Install Issue I am trying to install CRM 4.0 on SBS2003R2 running SQL 2005 with sp2 (9.0.3042) but I get an error "Setup requires SQL Server Reporting Services 2005 Hotfix for role creation on SQL Reporting Service SP2 Workgroup edition at the specified Reporting Services Report Server http://localhost/ReportServer." I cannot find this hotfix anywhere. Has anyone had this problem? Where can I find this hotfix? thanks, Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94756
  - 6
    - Can't connect remotely after upgrading to Vista I just installed CRM 3 Rollup2 on a new Vista laptop and I can't connect from outside the office using the Microsoft VPN client. I connect successfully over the VPN but it doesn't authenticate my User. I suspect this is a VPN/Vista connection issue and am wondering if anyone else has come across this and have a solution? Thank you Lloyd Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94751
  - 7
    - Merging ntext fields removes carrage returns, additional spaces and line breaks CRM 3.0 and 4.0 We have been dealing with this issue for a long time and are still exhibiting the issue in CRM 4.0. When merging some description fields (ntext) from our case records all the line feeds, carriage returns, extra spaces (more than a single space in a row) are removed and the field is merged as one paragraph of text. Can anyone explain why this occurs and how to fix it? -- Gary Herbstman Byte Solutions, Inc. http://bytesolutions.com Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94747
  - 8
    - Workflow send e-mail CC optional recipients fails when field empty When using workflow to send email we want to populate the CC field from an "additional contact" field that is not always populated. When the field is populated in the CRM record, the workflow functions fine. If the "additional contact" field is left empty, workflow fails and remains in an error state. I know I can create additional rules in the workflow to check for the field containing data but it does not seem like the extra work and complexity should be needed. Anyone have any other ideas? Bug? -- Gary Herbstman Byte Solutions, Inc. http://bytesolutions.com Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94744
  - 9
    - Save and Close Error in accounts and contacts Hi - Just upgraded to CRM 4 and am noticing an error when accessing via the web: When I his either save and close or save and new in an account or a contact I get an error popup - "Microsoft Dynamics CRM has encountered an error Please tell Microsoft about this problem..... The XML report that is sent to MS is as follows: Microsoft Dynamics CRM Error Report Contents <CrmScriptErrorReport> <ReportVersion>1.0</ReportVersion> <ScriptErrorDetails> <Message>Syntax error</Message> <Line>106</Line> <URL>/ORG NAME/sfa/conts/edit.aspx?id={13E72404-FE22-4E0D-BBE1-32CA08311FC1}</URL> <PageURL>/ORG NAME/sfa/conts/edit.aspx?id={13E72404-FE22-4E0D-BBE1-32CA08311FC1}</PageURL> <Function></Function> <CallStack> </CallStack> </ScriptErrorDetails> <ClientInformation> <BrowserUserAgent>Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; InfoPath.2; .NET CLR 1.1.4322; OfficeLiveConnector.1.0)</BrowserUserAgent> <BrowserLanguage>en-us</BrowserLanguage> <SystemLanguage>en-us</SystemLanguage> <UserLanguage>en-us</UserLanguage> <ScreenResolution>1680x1050</ScreenResolution> <ClientName>Web</ClientName> </ClientInformation> <ServerInformation> <OrgLanguage>1033</OrgLanguage> <OrgCulture>1033</OrgCulture> <UserLanguage>1033</UserLanguage> <UserCulture>1033</UserCulture> <OrgID>&XXXXXXX;</OrgID> <UserID>&XXXXXXXXX;</UserID> <CRMVersion>4.0.7333.3</CRMVersion> </ServerInformation> </CrmScriptErrorReport> Any ideas would be greatly appriciated. Thanks! Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94742
  - 10
    - This message has not yet been submitted for delivery CRM 4.0 We have been experiencing long delays when sending email from CRM 4.0. Generally about 30 minutes. When viewing the e-mail from the contacts history, the top of the e-mail displays a message: This message has not yet been submitted for delivery CRM 4.0 Eventually the mail delivers and the message goes away. This occurs for any CRM mail, manual, merges or workflow. We have Exchange 2003 on a separate server with the CRM connector. Anyone else experiencing this? -- Gary Herbstman Byte Solutions, Inc. http://bytesolutions.com Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94741
  - 11
    - Mobile express for CRM3.0 / W Mobile 6 I bought a htc TyTNII and I would like to run wcrm mobile for CRM3.0 on it. The installation manual says nothing needs to be installed on the PDA itself, only a whole lot of things need to be done on the CRM-server. Following the instructions for that, I have a Windows Mobile configuration screen added to CRM now, which seems to do would it should do. 1. However I have no idea how to open the crm mobile application now. What alias to use instead of the 'normal' http://mscrm? 2. Should I copy the 'Mobile application'- and 'Adfministrative interface' directory? I now copied them in a directory under Program files. Should I have copied it to a directory in the inetpub-directory? 3. Is it correct that nothing should be installed on the pda? If not, what should be installed on it and where to find that. 4. I installed CRM Mobile Express. Are there otrher versions? Should I have installed an other version? Where to find? 5. The installation guide tells me to set the location for the draftXML.xml and PublishedXML.xml in (I chose C:\Program Files\Microsoft CRM Mobile\ as the location for the files, see remark above) C:\Program Files\Microsoft CRM Mobile\Administrative Interface, not in the respective subdirectories C:\Program Files\Microsoft CRM Mobile\Administrative Interface and C:\Program Files\Microsoft CRM Mobile\Mobile Application. Is that correct or should they be located within each subdirectory? Thanks in advance. Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94738
  - 12
    - bulk change of all telephonenumbers I have all telephonenumbers entered in the format +31555-555555 or 055-5555555 or 0555-555555 (or 06-55555555 for mobile phone). Now I want to start making phonecalls directly using this field, so I will have to delete the minus sign in it. What is an easy way to do that? There are over 500 contacts in the database each with 1, 2 or 3 phonenumbers. Is there an SQL command for that? Other suggestions? Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94737
  - 13
    - Dynamics CRM / MS-CRM Addon Catalog Hello Everyone, there is a new online Microsoft Dynamics community addon catalog available for everyone to access: http://www.microsoftdynamicsaddons.com/ It is searchable, and it has the ability to rank and leave comments on specific addons. Everyone is encouraged to look at the site and give their input so others can have more information about the solutions. Also ISV's are encouraged to list their addons on the site (it's free!) **This post was made per the recomendation of the Microsoft Community team: http://www.microsoft.com/dynamics/community/relatedcommunitieslanding.mspx Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94727
  - 14
    - Javascript Error hi there, MS CRM 3.0 on SBS. When using the quick create Contact form I am getting JS errors. Don't think any mods have been created on the form but now I cannot find where the Contact quick create form lives in customizations. Can you point me to where the form lives so I can see if any custom code has been added that is causing this or has anyone seen this out of the box? Thanks, Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94726
  - 15
    - Workflow in CRM 4.0 not working Just did an upgrade to CRM 4.0 from 3.0. Now it appears that my workflows are not working. It seems that they do not even attempt to run. In CRM3 there was a workflow service, but after the upgrade and a reboot, I have no CRM Workflow service - is there supposed to be one? Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94724
  - 16
    - Sales Orders with a multi-part order Hi all, Is there a way to autofill line items in a sales order with an item that is comprised of multiple items as part of a kit. For example, if you had an instrument that when you enter the instrument as a line item on the sales order then the order would auto fill not only the instrument but all the accessories included with the instrument as additional line items. A solution to this would help us resolve data entry / omission errors and be a real time saver. -- Jim Bourque Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94722
  - 17
    - View all individual email templates Does anyone know if it is possible to view all individual email templates -- view other user's individual email template??? Thanks! Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94715
  - 18
    - Failed move data for ISV Config I have seen this issue on the MS Knowledgebase and on the newsgroup, but my problem seems a bit different. I did a fresh install of my laptop along with the CRM 4 Outlook client. When I try to go offline, I get "Failed to move data for entity 'ISV Config' during action Insert, countRows=1." I have seen similar issues posted with specific entities noted - but the ISV Config seems different from what I have been reading. I followed the KB article, but still the same problem. Any suggestions? Thanks - JM Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94714
  - 19
    - CRM 4.0 Mail Merge Error: Record 1 contains too many data fields Hi, I have heavily customized the Account area in my CRM installation. There are 311 attributes. When I use the mail merge functionality using the 4.0 web client, after I open a word xml template and following pressing the "CRM Mail Merge" command button, I get the following error in a pop-up error window twice "Record 1 contains too many data fields". This happens again after the recipient selection form displays without any data and after the user presses OK. Does anyone know what is causing this? This happens even if no fields are selected in the data fields selection box before the document is opened in Word. Jeffrey Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94710
  - 20
    - Error with Microsoft CRM add-in for outlook It's on an XP, has rollup 2, and is on outlook 2007. I get the following error message on one of the computers at my office: Outlook experienced a serious problem with the 'microsoft crm outlook addin' add-in. And the following are in my event log: Accepted Safe Mode action : Microsoft Office Outlook. Faulting application outlook.exe, version 12.0.6212.1000, stamp 46e03e45, faulting module crmaddin.dll, version 3.0.5300.1555, stamp 45e00303, debug? 0, fault address 0x00096834. Hanging application rundll32.exe, version 5.1.2600.2180, hang module hungapp, version 0.0.0.0, hang address 0x00000000. Faulting application outlook.exe, version 12.0.4518.1014, stamp 4542840f, faulting module unknown, version 0.0.0.0, stamp 00000000, debug? 0, fault address 0x0011ba61. If anyone has any idea how to fix this I'd appreciate it. I have been unable to find a solution through microsoft - but maybe there is one I haven't seen. Thanks. Jeff M. Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94709
  - 21
    - How to import contacts and companies into CRM 4 We have recently upgraded from CRM 3 to CRM 4. In CRM 3 you could import contacts and associate them to a company via the company GUID. I want to import both contacts and companies at the same time and link them together. Is this possible? I know the standard import tool is very basic and does not have the capability to do this. Your help will be most appreciated. Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94705
  - 22
    - Increment Months by 1 in a date field Hi all, I have this code to increment months on a date field, it returns 12/31/1969 var time = new Date(); var month =parseInt(time.getMonth()+1); crmForm.all.bmo_raisedorderdate.DataValue = month; Please help me, what am i missing. Many thanks -- phumulaniluyandacollinlembede Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94703
  - 23
    - Importing Campaign Response I'm having trouble importing campaign responses from .csv. Under bulk imports I'm receiving error that "Data in row did not match the import type". All I'm importing is the Parent Campaign and the subject according to documentation found here http://www.microsoft.com/dynamics/crm/using/marketing/emailcampresp.mspx Can someone tell me what i'm doing wrong? Thanks Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94702
  - 24
    - Reports Is there any way to control how a report is exported to PDF when it's exported from the report viewer? It seems that when I run a report in CRM (v3 and Reporting Services 2000) and then export it to PDF, it puts the report on 3 pages. Is there a way to for it to scale to fit the page when I export? Thanks, James Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94701
  - 25
    - WebService retrive error Hello, I have a problem with a javascript web service. I have a custom entity which is linked by product entity. In the OnChange event of a lookup ptoduct i would like to interogate the custom entity passing as parameter the selected product id and return some data from this custom entity. I have the following code: var xml =""+ "<?xml version=\"1.0\" encoding=\"utf-8\" ?>"+ "<soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/ envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">"+ "<soap:Body>"+ "<query xmlns:q1=\"http://schemas.microsoft.com/crm/2006/Query \" xsi:type=\"q1:QueryExpression\" xmlns=\"http:// schemas.microsoft.com/crm/2006/WebServices\">"+ "<q1:EntityName>CUSTOM ENTITY NAME</q1:EntityName>"+ "<q1:ColumnSet xsi:type=\"q1:AllColumns\"/>"+ "<q1:Distinct>false</q1:Distinct>"+ "<q1:Criteria>"+ "<q1:FilterOperator>AND</q1:FilterOperator>"+ "<q1:Conditions>"+ "<q1:Condition>"+ "<q1:AttributeName>SELECTED PRODUCT ID</q1:AttributeName>"+ "<q1:Operator>PRODUCT ID VALUE</q1:Operator>"+ "</q1:Condition>"+ "</q1:Conditions>"+ "</q1:Criteria>"+ "</query>"+ "</soap:Body>"+ "</soap:Envelope>"+ ""; var xmlHttpRequest=new ActiveXObject("Msxml2.XMLHTTP"); xmlHttpRequest.open("POST","http://crm:5555/mscrmservices/ 2006/crmservice.asmx",false); xmlHttpRequest.setRequestHeader("SOAPAction","http:// schemas.microsoft.com/crm/2006/WebServices/RetrieveMultiple"); xmlHttpRequest.setRequestHeader("Content-Type", "text/ xml;charset=utf-8"); xmlHttpRequest.setRequestHeader("Content-Length", xml.length); xmlHttpRequest.send(xml); var resultXML=xmlHttpRequest.responseXML; alert (resultXML.xml); but when i place this code in the onchenage event it stops to " xmlHttpRequest.send(xml);" and retrives me the "An unexpected error occured" error. Is it something wrong in my code? Many thanks, Marius Z Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94693
- Next
  - 1
    - Workflow problem Hi, Ive setup a rule in the workflow manager to email a template on creation of a new lead in CRM v3.0 SBE. When a lead is created , We get a "Not enough privilege to access the Microsoft CRM object or perform the requested operation" logged in the debug log and the job ends up in the workflow monitor as paused. (The workflow service is running as NT AUTHORITY\NETWORK SERVICE). However, if the rule is manually run as apply rule from the GUI, the template works ok. Any suggestions where to look first to solve the workflow issue? Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94690
  - 2
    - Microsoft CRM should allow you to customise Price List Item In order to allow for the implementation of more complex product catalogues within Microsoft CRM I would like to be able to customise the prices list item entity to create new attributes and relationships. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=6768af2e-4bc1-4ceb-8ef5-753ae3721e66&dg=microsoft.public.crm Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94687
  - 3
    - Hide "delete" functionality for Opportunity I have the need to disable the "delete opportunity" functionality forcing users to "close" the opportunity with a reason within CRM 3.0. This update needs to be in two places: 1) Opportunity main form, where there is <Action\Delete Opportunity> which I was able to accomplish with the following code: Code ------------------- var DisableOpt = document.getElementById("_MIonActionMenuClickdelete3"); DisableOpt.style.display='none'; ------------------- 2) Sales\Opportunities main screen, where there is the delete "X" o the screen. [image http://farm3.static.flickr.com/2265/2199809885_772307e9ac.jpg?v=0] The name of the control is _MBdoActioncrmGrid3delete via IE De Toolbar. Can someone assist with a reference on how to make this happen, or i it is at all possible? Thanks. Stev -- ungai http://www.techtalkz.com - Technology and Computer Troubleshooting Forum Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94683
  - 4
    - Re: Credit Note and Microsoft CRM [I could not find the original message and original response from my mail server -- hence not responding to original thread] I asked: Is it so that there is still no real solution (i.e. negative amount) for Credit Note in Microsoft CRM? --- Mike <mlo...@lunadevelopment...> replied: Out of the box, yes this is still the case. However, customizations will allow you to create a credit note/return/RMA etc. One reason for this is the fact that CRM was never meant to be used as an order processing system, and only records those metrics to produce reports about your sales pipeline, etc. Consider using Dynamics GP to do the rest of the financial stuff. --- Hmmm, to my understanding the knowledge of customers' purchases (orders and invoices) is something one would expect to find from a CRM -- and to that end it should be neccesary to be able to get credit notes as well into CRM -- or for what purpose the CRM has the order and invoice consepts? We are running accunting in a different software and will download orders and invoices dat from there to CRM, and would like to use the CRM's built-in order/invoice concepts but are unable to load credit notes, as there is no provision for negative amount. pekka Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94680
  - 5
    - Customisation Import Error Hi, I have a test CRM system and a live CRM system. I exported all customisations from the test system and imported to the live system ok. Now I export 1 Account entity customisation, I opened the customisation in Notepad, did nothing and save the file as it is. Now I re-import the Account customisation file and it give me a "invalid XML schema" error... anyone any idea? Thanks! Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94673
  - 6
    - How do you customise CRM 4.0 Help file In CRM 3.0 you could customise the help file for the specific organisation. How to do this in CRM 3.0 is avaliable at http://msdn2.microsoft.com/en-us/library/aa681364.aspx How do you customise CRM 4.0 Help file Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94671
  - 7
    - Unable to use DynamicEntity() to exeute a response Hi, My CRM client has two custom entities set up, and I can use Dynamic Entity to create a record against those custom entities, respectively. Now, I created an entity for generating a sequence number and the plug- in will read the value and parse the incremented value to those entities. The original entities are related to "account" and "contact". The one that I created does not associated to any entity. For those two entities, I can able to create or update record with using Dynamic entity. However, the one that I create (for the sequece number) is not. I am able to retrieve of that custom entity with using Metadata SDK. What step I should do (before publishing) when I create the entity so it is able to reference with using Dynamic Entity to create or update the records? Thanks Karl Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94670
  - 8
    - How can you hide system defined views in CRM 4.0 In CRM 3.0 you could share the System view to remove them from a users list of views. I cannot see the Share functionality of Views in CRM 4.0 to do the same thing. How can you hide system views in CRM 4.0 Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94669
  - 9
    - CRM 4.0 Workflow links Hello, I am needing to have Workflow send an email with a link to given item. For example if a person is assigned a task, I want the email to contain the link to the task. I understand how to have it create the email but I do not know how to have it send the link. I appreciate the help! Thanks, Chris Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94666
  - 10
    - How to Assign a PreferredSystemUserID as Task Owner during Workflo We have a business process for Accounts, which involves completion of certain activities. We use a workflow rule to stream-line creation of 'task' activities assigned to certain users to follow through on certain steps in the process. We are using the preferred user (preferredsystemuserid) to represent the user assigned as the client service rep for the Account. We then apply a workflow rule to build various activities, one of which is a task that needs to be assigned to the client service rep assigned to the Account (as noted in the preferred user attribute). How do you go about setting the Owner of the Task using the Preferred System User defined for the Account. Currently, we are having to set the owner to a specific user, who would then need to re-assign the owner. Maybe I missed something during the workflow rule, but I could not see a way to set the Owner of the task using the Preferred User reference. Our only alternative is to have a work-flow rule for each Preferred User that may be assigned to an Account, and then the related task created by the workflow could then use a specific user. Yet, I would have supposed that the workflow manager would have provided for this scenario. Is it possible that we need to use a different Activity (Phone Call, etc.)? TB Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94663
  - 11
    - Error enabling users in 4.0 Hi, Just upgraded to version CRM 4.0 on a test server using the 90 day trial key and everything went well. Yesterday the Gold Partner Enterprise key arrived and I upgraded the license. I went into user management and tried to enable some of the users I had disabled during test. Got the error below. Has anyone else experienced this? Thanks, Manso [SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.SystemUserPrincipals' with unique index 'cndx_SystemUserPrincipals'. Cannot insert duplicate key row in object 'dbo.SystemUserPrincipals' with unique index 'cndx_SystemUserPrincipals'. The statement has been terminated. The statement has been terminated.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +149 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135 Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command) +123 Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate) +120 Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command) +12 Microsoft.Crm.BusinessEntities.BusinessProcessObject.ExecuteNonQuery(IDbCommand command, ISqlExecutionContext context) +245 Microsoft.Crm.ObjectModel.SystemUserServiceInternal`1.PopulateSystemUserPrincipals(Guid userId, ExecutionContext context) +144 Microsoft.Crm.ObjectModel.SystemUserServiceInternal`1.SetDisabledStatus(BusinessEntityMoniker moniker, SystemUserState state, ExecutionContext context) +915 Microsoft.Crm.ObjectModel.SystemUserServiceInternal`1.Enable(BusinessEntityMoniker moniker, ExecutionContext context) +215 Microsoft.Crm.ObjectModel.SystemUserServiceInternal`1.SetState(BusinessEntityMoniker moniker, Int32 newState, Int32 newStatusCode, ExecutionContext context) +74 Microsoft.Crm.BusinessEntities.BusinessProcessObject.SetStateStatus(BusinessEntityMoniker moniker, Int32 newState, Int32 newStatusCode, ExecutionContext context) +19 Microsoft.Crm.ObjectModel.SystemUserService.Microsoft.Crm.Sdk.IStateful.SetStateStatus(BusinessEntityMoniker , Int32 , Int32 , ExecutionContext ) +17 Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94654
  - 12
    - Setup/Publish Reports for MS CRM 4.0 Professional on Separate Server? 1) I installed MS CRM 4.0 Professional on ServerA and specified that the data and report server will be ServerB. 2) No default reports were installed to ServerB; however, it does appear to have created a DeploymentName_MSCRM folder in Report Manager on ServerB. 3) I then read somewhere that "MS CRM SRS Data Connector" needed to be installed on the Report Server (ServerB) so I subsequently did that. How do I get the reports installed to the DeploymentName_MSCRM folder on ServerB now? Instructions I've seen mention running PublishReports.exe FROM THE REPORT SERVER to do that but it is installed on the CRM Server (ServerA), not the Report Server (ServerB). What am I missing here - how do I get the out of the box CRM reports onto my Report Server (ServerB)? Thanks in advance! Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94652
  - 13
    - Update MSCRM 3.0 4.0 with redeploying Hello all, I have a old server "Windows 2003 Standard with SQL 2005" that contain Microsoft CRM 3.0 with all my contact, to do, calendar, all my customization and all my stuff. Also, I have buy a new server and this new server have a clean installation of Microsoft CRM 4.0 (this server have a Windows 2003 Standard with SQL 2005"). My question is what is the best way to easily export all my customization, contacts, to do, calendar, and all my stuff. from my Microsoft CRM 3.0 and import to my new server that contain my clean installation of Microsoft CRM 4.0 ? The both server are on the same domain. Thank for your help. Sylvain. Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94651
  - 14
    - e-mail campaign Hi, We want to use email campaign in CRM 3.0 with below requirements: Add TEXT Add EMBEDDED PICTURE Add ATTECHMENT I can not find solution for these simple requirements. Does anybody know how to do it? I don't think that only our company wants to EMBEDE PICTURES to email. Is it possible in CRM 4.0 ? Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94650
  - 15
    - Calculated field Hello, in Settings Customization I added two new attributes to the Oppurtunity entity. EstCommRate and EstCommission. I added the new fields to the Oppurtunity Form. I looked at the SQL tables to verify the fields exist and out of curiosity. I am only making customizations through Settings Customization. on the Oppurtunity Form I want Est.Commission = Est Sales Volume x EstCommRate. How do I setup that formula and where? I would like the new fields carry forward when an Oppurtunity is converted to a Quote and a Quote is converted to an Order and so on. cheers, Michael Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94644
  - 16
    - mobile solutions for CRM 4 For CRM 3 was CRM Mobile and CRM Mobile Express. What is or will be for CRM 4? Where I could find informationa about it? Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94639
  - 17
    - Server version Hi I've been told by the reseller that CRM3 does not work on Windows DataCenter. Is this the case? The product is so old that DataCenter was probably still only OEM available. TIA. Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94637
  - 18
    - How to disable "delete opportunity" menu item and action? I have the need to disable the "delete opportunity" functionality, forcing users to "close" the opportunity with a reason. This update needs to be in two places: 1) Sales\Opportunities main screen, where there is the delete "X" on the screen. 2) Opportunity main form, where there is <Action\Delete Opportunity>. Can someone assist with a reference on how to make this happen? Thanks. Steve. Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94636
  - 19
    - Mapping opportunity product to quote product I've got some custom attributes in the Opportunity product and quote product to hold some extra information regarding the customer's quote.Write-In Products isn't an option. The problem is, when I convert the Opportunity to a quote, the information in the custom attributes of the Opportunity Product do not get passed over to the Quote Product. I searched this question here and I found out that there was a KB article from Microsoft about this problemen ( http://support.microsoft.com/kb/914921 ) But this only applies to CRM 3.0 and I am using CRM 4.0 Can anyone help me with this? Thanks in advance Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94628
  - 20
    - CRM 4 Printing Workflows We are using CRM4 and have created a number of workflows. I was just wondering if there would be any way to print these workflow, or create a document showing the steps of the workflow? This would just be very useful to save me alot of documentation time. Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94622
  - 21
    - CRM Workflow Manager Does it matter where you run the CRM workflow manager from in terms of your entire network or from the CRM server? thanks Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94613
  - 22
    - CRM 4.0 Workflow rules dont execute Hello, when we run workflow rules (on demand rules as well as permanently running rules) all the rules dont execute and remain in the waiting stage. Any ideas how to solve this problem? kind regards Daniel Reichel Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94610
  - 23
    - How to prevent closing of opportunity Hi, I need help to prevent users from closing an opportunity after checkin the modified actual close date. I've tried using the code below that i've get from one of the threads to stop user from closing the opportunity, but it didn't work. document.all._MIreactivate.action="alert('Closing Opportunit deactivated');"; Can anyone advise me how to solve this? Thanks for helping = -- stacynl http://www.techtalkz.com - Technology and Computer Troubleshooting Forum Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94609
  - 24
    - MS CRM 4.0 Hosted versions Can any one tell me which versions of MS CRM titan are hosted one? Else are all three versions be hosted? Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94605
  - 25
    - problem in upgrading to crm 4.0 Hi All I am facing following error while upgrading to CRM 4.0 Setup requires sql server reporting services 2005 hotfix to create reporting services role When I click on details of the error I get following message "There is a cumulative hotfix available ".. when I go to the links I get lot of hot fix but nothing above description. Has anybody faced the same issue I have also upgraded windows 2003 Small business server to windows 2003 small business server 2003 r2. Please advice regards Rakesh Agarwal Tag: How can I view all contacts for all sub-accounts of accounts? Tag: 94604

I have an account with more sub-accounts. Each sub-account has one ore more
contacts.
Normally I can see only contacts associated directly with that account, not
with sub-accounts.
When a select that parent accounts, I'd like to see all the contacts from
all sub-accounts. It is possible ?

Top

RE: How can I view all contacts for all sub-accounts of accounts? by FrankLee

FrankLee
Sun Jan 20 12:00:00 CST 2008

That is the current v4.0 Out of Box functionality.

The relationship is there, so building a SRS report is a good option for
this. Or SDK...

Good luck.

Frank Lee, Microsoft CRM MVP
http://microsoft-crm.spaces.live.com
http://www.workopia.com/Links.htm

"Paul P" wrote:

> I have an account with more sub-accounts. Each sub-account has one ore more
> contacts.
> Normally I can see only contacts associated directly with that account, not
> with sub-accounts.
> When a select that parent accounts, I'd like to see all the contacts from
> all sub-accounts. It is possible ?
>

Top