Help, I am new to this!
How do I get MS Money to assign category to a transaction
based on Payee?? Seems like it can do it for manually
entered ones, but not for downloaded transactions
...Fun with SQL and CRM Help needed
Ok. I've been tasked with setting the "Address Name" for every contact
equal to the name of the parent company.
I know I can write an SQL query to do this, I just can't figure out
where the relationship is between contacts accounts and the
customeraddressbase table. So, heres what I need to do:
Open Contact, Get Contacts Parent Customer Name, Put Parent Customer
Name into Address Name for the contacts main address.
The database is relatively new, we just finished a very botched import
from ACT! not to long ago. this is the latest "Fix" that I've been
asked to...HOW DO i ALPHABETIZE A LIST OF SCHOOL (NOT NAMES) IN EXCEL
HOW DO I ALPHABETIZE A LIST OF SCHOOLS
Please don't type in ALL CAPS. It is considered to be "shouting" and rude.
Microsoft MVP Excel
"GERRIREN" <GERRIREN@discussions.microsoft.com> wrote in message
> HOW DO I ALPHABETIZE A LIST OF SCHOOLS
Select all of the cells involved in all columns and rows, then use Data Sort
and it will lead you through the process.
> HOW DO I ALPHABETIZE A LIST OF SCHO...WINDOWS folder 4.5GB Is it normal?
On my exchang2003 box my Windows folder is the size spesified...Is this
healthy and/or normal? Is there any way i can reduce this size WITHOUT
CASING PROBLEMS/ISSUES OF ANY KIND on my server. thanks for the ideas.
Sounds about right.
If you've cached web pages offline, you can delete them. Pretty much
anything else could potentially be a problem or issue down the road.
"MSExchange2003Student" <email@example.com> wrote in message
> On my exchang2003 box my Windows folder is the size spe...Move CRM databases
We have MS CRM 3.0, Reporting Services, and CRM/ReportServer databases on a
single server. We now want to move the CRM and Reporting services
databases to a SQL Server 2000 cluster. Anyone know if there is a tool to
do this or do we need to move them manually and update the database and
metabase keys in HKLM\Software\Microsoft\MSCRM ?
There is no tool to do thisa automatically. YOu can read the Implementation
Guide where it talks about disaster recovery. Basically you can restore your
database to a new sql server and then point your crm web server at the new
sql system by...Proactive Alerts in CRM
Is there a way to set up alerts or notifications if certain things are
happening in the CRM. Such as a date being overdue, a person tried to get
into a section they are not supposed to, etc. Thanks.
Client Solutions Manager
Workflows should be able to do most of the alerting about things being
overdue to either send an email or create a task
People cannot get into anything they are not supposed to. If they are
locked out of say... invoices through security, the option does not
Kyle Conquy wrote:
> Is there a way to set up alerts or notifications if ...Planning to Upgrade Great Plains eEnterprise 6.0 to version 9.0
Hi Planning to upgrade from version eenterprise 6.0 running on SQL7.0 to
Dynamics 9.0 on SQL 2005 anyone has done it? if so please post.
We have done it several times already.
We can do it for you.
> Hi Planning to upgrade from version eenterprise 6.0 running on SQL7.0 to
> Dynamics 9.0 on SQL 2005 anyone has done it? if so please post.
I have done upgrades from 6. to 9.0
Always print reports before and after each version upgraded and compare.
Backup the Reports Dictionary.
Create a package file...CRM and Small Business Financials
Has anyone heard through the grapevine about any plans for CRM and Small
Business Financials in the future? SBF would be a great product for us, but
we find a gaping hole in that there doesn't seem to be any type of Sales
Force Automation or CRM option that works with SBF. Why would any company
with a sales force switch to SBF back end without a front end option as
well? Seems like MS missed the boat on that one!
Presentations Direct - "Document Finishing Solutions"
On October 4, 2007, the Microsoft Dynamics Retail Management System (RMS)
team will host an Open Forum Live Chat. In this chat, our experts will take
questions on any Microsoft Dynamics RMS topic.
If we get a high volume of questions during the Open Forum chat, our experts
might not be able to respond to all of them within the chat timeframe. In
that event, our experts will respond after the chat ends, to the extent
possible, and their answers will be included in the transcript for the chat.
The transcript will be posted to the using
Si...Microsoft CRM Asynchronous Processing Service (client)
We recently moved our deployment from one server to another. We were having
issues this morning and when I started to look into things like are the
services running, I notices two instances of Microsoft CRM Asynchronous
1) Microsoft CRM Asynchronous Processing Service
2) Microsoft CRM Asynchronous Processing Service (client)
Does anyone have any idea what the 2nd one is? I've never seen that before.
Have you installed microsoft data migration manager ? if i recall my
memory the second one is because of data migration manager .
Blog : http://ms...Smartlist builder SQL problem
I have been trying to create a calculated field in the smartlist builder in
Dynamics GP. The calculated field is supposed to show the amount of time
until a service call runs out of SLA. The actual code for that works fine (
see the @SLA section of the code). But I also need it to have it so that
before it returns a time it checks to see if there is any data in the arrival
date and time columns, if there is data in there then it should just say "LA
Met". Also some of the rows do not have SLAs and they return a number:
955138:39 I want to set the calculated field to displa...Can't installt IBF on CRM Server
first i'm install IBF On my CRM v1.2 (it's name crm)
after that i'm try to install IBF for CRM on my CRM Server
but in Step "Publish Metadata" i'm type "http://crm:8082" and click
but it's show message box "The Information Bridge metadata service
location is not avaliable" and can't install it.
but i can access "http://crm:8082/IBFWriteService.asmx" and
"http://crm:8081/IBFReadService.asmx". so how can i install it ?
...How do I change the Product Key code and the User name of Microsoft Office 2008 once installed on Mac OSX 10.5.1?
How do I change the Product Key code and the User name of Microsoft Office 2008 once installed on Mac OSX 10.5.1?
On 2/26/08 5:15 PM, in article firstname.lastname@example.orgR9absDaxw,
"email@example.com" <firstname.lastname@example.org> wrote:
> How do I change the Product Key code and the User name of Microsoft Office
> 2008 once installed on Mac OSX 10.5.1?
Delete these two files:
~:Library:Preferences:Microsoft:Office 2008:Microsoft Office 2008
where ~ is your home folder, and
HD:Applications:Microsoft Office 2008:Office:OfficePID.plist
Diane, ...Someone's using my domain name to send e-mails
I came into work this morning and I received an e-mail from myself. An
e-mail I never sent. From: Annsmith@mydomain.com To: Annsmith@mydomain.com
How is this possible?. The message was for weight loss pills. I look after
the computers in the office so I have to find an answer for this problem.
Also, last week, an employee received and e-mail from someone using our
domain name. email@example.com. Right away I knew it was fake because we
don't use that kind of naming convention here at the office and I'm the only
one who sets up the e-mail addresses.
We use Outlook 2000 and excha...How to Connect to SQL Server??
Earlier today, I had to change strategies for retrieving information that I
need for a utility program I am working on. Essentially, the program
performs some low level Windows profile translations as we move to a new
domain structure (AD) and a new standardized ID convention.
We presently have two formats of standardized user IDs: one in our
pre-merger format and used with the older NT domains, and a new standardized
user ID. I have a table in SQL Server 2000 that contains two fields, one for
each type of ID, and the table contains approximately 275,000 rows.
This program is going t...Outlook slow saving attachments to nt 4.0 server
After upgrading to Windows XP Professional, Outlook 2000
is extremely slow in saving attachments to a Windows nt
4.0 server with Service Pack 6.0a. All service packs and
updates were installed in both Outlook and Windows XP.
...Problem logging in to CRM by a not-Admin user
I am having a problem logging in for certain CRM users. If they don't belong
to a local CRM server administrators group, they cannot log in. They get, I
believe, 403.1 error. Once added to that local group, they can log in just
fine. CRM site is configured as the trusted site to use curent AD username
and password. CRM is set to use Windows intergated authentication. I have an
open incident with IIS group without much luck. I believe the problem is
within a user. Does he (she) have to belong to a special group to gain access
P.S. Integrated HF is applied.
are they using th...Named mutex behaviour
I am using a named mutex and have a question about its behaviour when
used within the same process multiple times AND across processes.
The named mutex I am using, is used by another process in the system.
Within my own process I am using a dll which also is making use of the
mutex. If I dont use the dll there isnt a problem and things work out
as illustrated in scenario 1 below.
Do Work Wait
Release Do Work
...Q: Re: Title in front of person's name..
As I enter names in Outlook 2000, I would like their title to appear before
their name in both the contact listing, and when I send an email..
Dr. Joe Smith... instead of just Joe Smith.. and then having to click 'Full
Name' to reveal the title of Dr.
Also, is their a way to add additional titles to the list? I also deal with
religious that use Sr. (Sister) and Fr. (Father), as well as Deacon...
...CRM Sales for Outlook 1.2
We are using mscrm 1.2 successfully for a while now (no
mail router, no outlook client). Now we tried to
integrate it into our exchange environment using the
outlook client. Online is working fine but the offline
functionality isn't working. Obviously the local msde-
database is not getting any data.
The error message is: "Metadata-Cache error, No entity!"
The log says:
MSCRM Platform Error Report:
Error: Exception from HRESULT: 0x80040E00.
Error Message: Exception...Get name of active sheet
I have one sheet in my workbook named "Work Data".
If this sheet is active, then the following expression
.... will return a string of "Work Data". However, I don't
want the name of the string in the sheet tab, I want the name from
my VBA project window (named Sheet1). How can I retrieve
the VBA name of my sheet??
Be aware though that newly added sheets since the workbook was opened while
the VBE is closed will not have a codeName. There are various workarounds to
force one, ...Add a list of words in a senders name to rule?
I would like to create a "cleanup" rule to run periodically. I would
like to be able to put a list of domain names in a list, then have a
rule where if any of those domain names are in the sender name they
will be moved into the deleted folder. I get a lot of mail that I
don't want to filter, but don' necessarily read everday either, and it
mounts up. So, it would be nice if once ever couple of months I could
go in,run the cleanup rule and clear the old ones out.
You can do this by creating a rule that looks for "specific words in the
sender's address"...How do I insert ISBN numbers starting with 0?
couple of ways
select the range where the ISBN numbers are going into and choose format /
cells - text
enter them using an ' in front of each one (e.g. '0123123213) the ' won't
show when printed or viewed
enter them with spaces or non-numeric characters
Let us know how you go
"Chris" <Chris@discussions.microsoft.com> wrote in message
be a little respectful when asking for help. write the query in the body
of the message.
-------------------...Where to get Data Migration Framework 3.0
Can someone tell me where to download the Data Migration
Framework version that works with MS CRM 3.0?
Thanks in advance
"Samuele Marconcini" wrote:
> Can someone tell me where to download the Data Migration
> Framework version that works with MS CRM 3.0?
...Business Portal 2.0 Installation on GP 7.5
Has anybody successfully implemented Business Portal in
I have set up Business Portal on a notebook which acts as
the application server, web server as well as terminal
server for demo purposes. I have tried to access the Great
Plains windows from the tasks hyperlink in each center but
I failed. I get error messages. I am also not able to view
published FRx reports from the portal. It seems that I
need to know SharePoint to modify the pages & web parts
but I am unable to find any relevant helpful documentation.
Can anybody help me?