Reassigning accounts changes owenr on ALL objects....

We had a sales guy leave so I reassigned his accounts to various other
reps....worked great EXCEPT it reassigned all objects related to that
Account....even the completed ones. Where it screws me up the most is
on orders already created and the reportinig that I have created....it
moves those historical orders to new rep. reports have to be based on
order owner vs created by because we have admins that do some order
entry.

Is there any way to reassign account and NOT have it change the owner
on any activity/order/etc that has been completed or is in the
past??????

maybe an append query at the database level?????
0
drumguy61
3/3/2004 11:15:56 PM
crm 35858 articles. 1 followers. Follow

1 Replies
815 Views

Similar Articles

[PageSpeed] 39

drumguy61-google@yahoo.com (SteveT) wrote in message news:<4635de59.0403031515.275d599a@posting.google.com>...
> We had a sales guy leave so I reassigned his accounts to various other
> reps....worked great EXCEPT it reassigned all objects related to that
> Account....even the completed ones. Where it screws me up the most is
> on orders already created and the reportinig that I have created....it
> moves those historical orders to new rep. reports have to be based on
> order owner vs created by because we have admins that do some order
> entry.
> 
> Is there any way to reassign account and NOT have it change the owner
> on any activity/order/etc that has been completed or is in the
> past??????
> 
> maybe an append query at the database level?????

Bump???? Anyone????
0
drumguy61
3/5/2004 5:38:06 PM
Reply:

Similar Artilces:

Help: How to view Investments across accounts.
For example, I have GM in Account A and GM in Account B, how can I see combined activity for GM all in one report. Some of the reports, IIRC, allow grouping by investment. The Portfolio page also does this. "kingViggo" <kingViggo@discussions.microsoft.com> wrote in message news:BD7B7A14-5CE0-46B7-B6E9-DD3A24CFEF53@microsoft.com... > For example, I have GM in Account A and GM in Account B, how can I see > combined activity for GM all in one report. ...

Change Series Formulas for all charts on worksheet
I have a workbook with a 'template' worksheet that has 4 charts that reference data contained only in this worksheet . When I copy the 'template' and rename it (say Project1), the 'Series Values', 'Series Name', and 'Title' reference in the formula bar continue referencing the 'template' worksheet. I found the code shown below and it works for chart 'Series Values', 'Series Name', but NOT the chart 'Title' that I have referenced in the formula bar. Credit to: http://peltiertech.com/Excel/Charts/ChgSrsFmla.html#ixz...

Exception appears after changing project's directory structure (VS
Hi, Problem synopsis: I've recently tried to reorganize our project, by dividing our files into various directories, instead of them all lying at the top-level directory. After changing the project to mimic the new structure and fixing the "Additional Include Directories" setting to point to all the new directories, the project compiles. Yet now we get an exception thrown as the program starts up. As can be seen below, it seems like the exception is thrown from CArray (which is why I posted to this group), however it might just be that the heap is out of memory, and when C...

How do I change my default browser from MS Excel 2002. Links cur. #2
I place internet links in my spreadsheets for Excel 2002. When I click the link, it takes me to Internet Explorer Browser. How can I change it to use Netscape as the default browser? Thank you pizzaman wrote: > I place internet links in my spreadsheets for Excel 2002. When I > click the link, it takes me to Internet Explorer Browser. How can I > change it to use Netscape as the default browser? > Thank you Have you set Netscape as your default browser? ...

How to edit more then 250 objects with outlook
Even I try to edit items in public folder with own outlook makros, the process stopped after 250 items. Message in log-file was: "The limit...". Is there a value in exchange or in the registry to grow up these limit? H.Krause So what is the rest of the message in log? Heiko wrote: > Even I try to edit items in public folder with own outlook makros, the > process stopped after 250 items. Message in log-file was: "The > limit...". Is there a value in exchange or in the registry to grow up > these limit? > > H.Krause "Kirill S. Palagin" <kp...

Change default search to Value, not formula?
Every time I start a word search, the default searches for fomulas instead of value. So everytime I have to open up the option button and change it to value instead of formula. How do I change that default setting? lbbss Saved from a previous post: Excel tries to help by remembering the last settings you used--except for the first search in that session. You can use that to your advantage. You could make a dummy workbook and put it in your xlStart folder. Have a macro in that workbook that does a find (and sets all the stuff the way you like). Then closes and gets out of the way. ...

Replace XmlDocument underlying XPathNavigator object
Hello, I am trying to dynamically load a document in Infopath 2007. I would like to capture the FormEvents_Loading event and load the data from the database. The aim is to replace the maindatasource with the xml that I have retreived. InfoPath exposes the MainDataSource via the XPathNavigator. I have attempted to repalce the XPathNavigator's document and I run into the following error: "Operation is not valid due to current position of Navigator". I would be grateful for any assistance on how to replace the document underlying the XPathNavigator. Many thanks, Reena...

Color of Tracked Changes
This is a multi-part message in MIME format. ------=_NextPart_000_00AD_01C90402.A5C051E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I recently started to use Excel 2007 I have a shared worksheet which I sent to a colleague for review. After = I received it back, and looked for his changes I could barely see them = as the color was too faint a really pale yellow. How can I change the color to a bolder color NC ------=_NextPart_000_00AD_01C90402.A5C051E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Enc...

Changed some users to New Exchange 2003 Server
We recently acquired a brand new exchange 2003 server and have moved some mailboxes from the old exchange 2003 server to the new one. I was wondering if there is a hands off way of changing all of the end users profiles to point to the new server (usernames are still the same) in outlook 2000? Thanks in advance! If the old server is still in place and is in the same administrative group, then you shouldn't need to do anything. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outl...

How do I change the US date setting in the event schedule planner
Help! I'm using a lovely little template called event schedule planner - however it shows the date in US date format and I need the UK format (dd.mm.yyyy) how do I change it in this template please? If this is Word 2007/2010 then the chances are that it uses date content controls to display the dates. You can change them all with a macro Sub Macro1() Dim oCC As ContentControl For Each oCC In ActiveDocument.ContentControls If oCC.Type = wdContentControlDate Then oCC.DateDisplayLocale = wdEnglishUK oCC.DateDisplayFormat = "dd.MM.yyyy" End ...

How to? Anyway to have two Exchange mail box for one user account?
Hi, Just wondering if one domain user can have two exchange mail box. The reason is, that the VP in our company wants his secretary to receive every piece of e-mail he gets. That was fine until I learned how many e-mail that VP gets per day, which quickly overwhelm secretary'y mail box. So, my idea is to setup another mailbox just to take care VP's forwarding e-mail, while the original mailbox will not receive any VP's mail. Is it possible? Thanks for any help. Jadefox Sort of. Set up a second mailbox and point the alternative delivery for the VP to that mailbox. Give the sec...

Change another user's Out-Of-Office settings?
Aside from pretending to be that user and opening up their mailbox (or granting yourself mailbox rights and setting it as your "primary" mailbox), is there a way for an administrator to set or remove another user's out-of-office reply mode and message? I'd suggest opening up that user's mailbox in Outlook, but the administrator has to create a new Outlook profile, add or change the mailbox they're opening, and go back and forth from there to your own profile. It's possible for an admin to open another user's mailbox and set out-of-office in Outlook, as long ...

editing embedded objects in task (outlook 2000)
Hi, I'm going to use embedded Excel worksheets in a task, but once I finished inserting it, I am unable to edit it again. The object is visible in the edit area when the task is opened, but nothing happen when I select the object and click on the "Edit | Worksheet Object | Edit" or right- click on the object and then "Edit". Is there anyone who experienced similar problem, and found any resolution. Thanks in advance for your help, Balazs ...

Display account description in Requisition item entry
Display the account description for the selected account in the Item Entry screen in Business Portal Requistion Management. ---------------- 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=...

Global change of event/appt location?
I'm looking for a way to change all locations for events and/or appointments (which are also "events", right? All of the meetings I had scheduled for two places are now going to be held in two other places. In Excel or Word, I'd just do a global search and replace, and I'd be done Other reason: I imported national and religious holidays. Text of the form "(xxx Religious Holiday)" appears all over, and it's in the location field rather than in the category field. As long as I can handle (1), I'll eliminate all of this extra text, expecially on my poc...

Project accounting- changing project's status
When we create our own projects, it will not allow us to change the status from "estimate" to another choice (the screen is the Project Maintenance Window [cards-project-project]). An error message appears saying, "You cannot create Projects with a status other than Estimate." When we try to add hours to the project we created, it says we cannot do that becuase the project is in "estimate" and should be "open" instead. We are hoping it is another security issue that can be fixed. Thanks for any help. Hi check the security in the project setup w...

Change the characteristics of X Axis
i have a graph that i hightlight data by week, and i would like t indicate a seperator per week. each week displays 3 pieces of data on the chart eg week 401 ( this is week 1 in 2004) would appear 3 times then week 402 would have three pieces of data and so on, but i want clear indicator of the week change, i am easy on how this i done....colour a line or and other suggestion. here is a screenshot of my chart, hopefully you will see what i a waffling on about. [image: http://members.lycos.co.uk/redtilefc/graph.jpg] my setup is as follows: so i am not sure how i am gonna modi...

http mail account setup
hello, i have recently installed office xp on a windows xp machine and i'm trying to get outlook to handle all 3 of my email accounts as i did with outlook express previously. one acct is POP3 and the other 2 are hotmail. i got the first one set up with no problems, but every time i attempt the second it says the server is unavailable. is there a setting in outlook that needs to be changed? thanks oh, also is it possible to get the inbox status of outlook (instead of outlook express) displayed on the welcome screen of windows xp? since i'm trying to switch over it tells me ...

Link bar style changes when I publish my pages what causes this?
I'm using a laptop with Windows 7 Preimum and Front Page 2003. When I publish my site pages my link bar style changes from the style I selcted to the default base style. How can I stop this? -- CharlieD This is a common problem. The work-around is to open the online site and set the link bar style there. -- Ron Symonds Microsoft MVP (Expression Web) http://www.rxs-enterprises.org/fp Reply only to group - emails will be deleted unread. "Charlie D" <cdeputy@hotmail.com> wrote in message news:39DDD540-C2CA-4F80-AD58-3142215E3367@microsoft.com.....

Multiple email accounts Outlook 2007
Hi all, I set up two email accounts in Outlook 2007. Clicking the Send/Receive button successfully downloads email from both accounts. I can only send email from the default account, however. If I try to send from the second account I'm prompted for username/password and even though the boxes by default have the same smtp info as my primary account it just keeps popping up the box prompting me for username/password -- even if I hit cancel. I thought that both accounts would use the same outgoing mail server; just different incoming servers. I would like email sent from the ...

How to increase the maximum account length value?
I want to add a sample company TWO into my Great Plains, however; I found that the maximum account length value is "8", and the length of segments are 4-2-2. Therefore I cannot add TWO into GP. In order to add TWO, the segments must be 3-4-2. Is there anyway to increase the maximum account length? Thanks! You would need Reformatter from Crporate Renaissance Group "Kane" <Kane@discussions.microsoft.com> wrote in message news:C0BDBDEC-67FD-4C61-8924-3ABF998E2821@microsoft.com... >I want to add a sample company TWO into my Great Plains, however; I found >...

Problem with account after installing Connector
I just installed Microsoft Outlook Connector for MSN and i can't access my accounts under Outlook 2003 : properties, check mail... When i try i have an error like "problem in registry or installation...". I tried to uninstall MSN Explorer, Microsoft Outlook Connector, Office 2003. But nothing work. Please help, i can't use Outlook 2003 now ! do a detect and repair and create a new profile. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines ...

Merging account records 06-05-07
Hi, all: We've noticed that, when two accounts are combined, their activities history is not redirected to the master record, so some activities are lost (they remain related to the inactive record). Has anybody a suggestion about how to make the system behaves in a different way? (We'd like all the activities done for the combined record are updated so they start to point to the remaining record when the merging is completed). Thanks a lot in advance. Something is wrong. Try to create two new accounts with some history activity and then merge. Does this work ok? Fr...

sbs administrator account name changed now sbsbackup stops working
Hello, I while back i posted about how people were trying to hack into my computer, so i changed the administrator bane following the guide from ms. Now my sbs backup will not run, here is the log. I have also run vssadmin list writers and there are no errors reported. 2/3/2010 10:00 PM ------------------------------- Date: 2/3/2010 Time: 10:00 PM User: SYSTEM ------------------------------- Backup Runner started. Launching NTBackup: ntbackup.exe backup "@C:\Program Files\Microsoft Windows Small Business Server\Backup\Small Business Backup Script.bks" /d "...

How do I change the Read-Only notebook status
I have a new laptop. Upon uploading my notebooks, and openning, all are in read-only status. Where do I change permissions? -------- Original-Nachricht -------- > I have a new laptop. Upon uploading my notebooks, and openning, all are in > read-only status. Where do I change permissions? 1. Where did your notebooks come from ? USB-Flash drive, CD, file share .... File system NTFS ? 2. Where are they located now ? locally on your laptop, on a file share, on a Sharepoint server ? Bernd ...