MDA and Analytical Accounting
Can Multidimensional Analysis and Analytical Accounting be used simultaneously?
Can I ask why you would want to do that?
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
Any views contained within are my personal views and not necessarily Microsoft policy.
This pos...Totaling number of oders by state and Order code ID
I have a very basic understanding of “coding” and am now way out of my league.
I would like to be able to run Query(s) to get totals for “open” or “closed”
or “all” ORDERS by Code3 and State with only following headers.
Open or Closed or All Code3 State
ID# Total of ID#/State
The closest I have been able to come has been with ListofOrders_Crosstab2
TRANSFORM Count(ListofORDERS.Code3) AS CountOfCode3
SELECT ListofORDERS.Code3, Count(ListofORDERS.Code3) AS CountOfCode31
GROUP BY ListofORDERS.Code3
Thanks for...Account Alias in FRx.
Is possible to print accoun alias in a FRx report?
Thanks a lot..
Not unless you enter it somewhere in the row format.
Charles Allen, MVP
"Ana Evelin Rosa" wrote:
> Is possible to print accoun alias in a FRx report?
> Thanks a lot..
Thanks for your question about FRx. Charles was correct, the only way to
accomplish this would be to add that information to the row format. I would
recommend adding this as a Pr...RMS - CRM
I run Dynamics CRM 4.0 and RMS 2.0 .
What options do I have for Accounts integration between these three products
(Crm, Accounts Application, RMS). I was hoping by now there would be a
seemless link but I cannot see one and I've been waiting 4 years now ! :-)
Because we are UK based Accounting 2009 looks our only option as GP seems
far to complex for us.
Can you help me out with these questions ?
1) Does anyone have any news on integrating pos2009 to accounting pro 2009?
2) Should I migrate to accounting pro 2009 and prey that a link is born.
I'm getting fed up of double enter...IE upgrade broke account update
I just upgraded to IE v8 and forgot that all IE upgrades break the
account update feature within MS Money... can someone please remind me
what I have to do in IE to get MSM account updates working again?
firstname.lastname@example.org | 2009-06-27 | 8:46:24 AM wrote:
>I just upgraded to IE v8 and forgot that all IE upgrades break the
>account update feature within MS Money... can someone please remind me
>what I have to do in IE to get MSM account updates working again?
Uninstall Internet Explorer v8
New Life Home Improvement
Arlington, TX USA
...Importing mail accounts
I just installed Office XP 2002, up from 2000. I have
tried to import my mail accounts that I saved in .iaf
files, but when I go to File, Import..., Import Internet
Acct Settings, it immediately says "No internet accounts
found to import"!!! Problem, it doesn't even ask me where
it should be looking for them. Is there a fix or way
around for this?
alphonse <email@example.com> wrote:
> I just installed Office XP 2002, up from 2000. I have
> tried to import my mail accounts that I saved in .iaf
Outlook 2000 in Internet M...Multipul Email accounts
I have been setting up my Outlook 2003 for email accounts
for my wife and myself we have different addresses on the
same IP address Outlook says the addresses are working
but only my account is downloaded from the IP. what is
You should check with your isp for set detail. If your
receiving mail from two isp's, you need to be sure you
have the correct POP3 (incoming) and SMTP(out going)
settings. I use earthlink for my ISP, but I pull mail from
my office e-mail and have different pop3 and SMTP info for
>-----Original Mes...Lookup Issue (V 3.0 CRM)
On my Opportunity Form, I have a look-up field called "customerid".
I need to write some JavScript code that when the user
selects a customer (account) from the customerid
field lookup, the custom field CFScompanyname is automatically fills
in. How do I get the company name from the above LookUp
Does anyone have an idea on how I would go about doing this?
Matt Wittemann, CRM MVP
http:/...Uninstalling Analytical Accounting
Does anyone have instructions on how to uninstall Analytical Accounting from
GP 10? We have a client that has used AA for about a year and they no longer
want to use it.
The best I can do is find instructions related to GP 8, but I would feel
much better using updated processes, if they exist.
Article ID #915903 'How to remove Analytical Accounting from a computer that
has Microsoft Dynamics GP 9.0 installed' has worked for me.
"Scott S." wrote:
> Does anyone have instructions on how to uninstall Analytical Accounting from
> GP 10? We have a client tha...Analytical Periods
I am now in trouble while running Multi-level query in Microsoft Dynamics GP
10.0 Analytical accounting. I have already setup a fiscal year from July to
june of 13 periods of last 2 periods with same date as recommended by
Microsoft where last period is for year end adjustments. When I was selecting
period 3 of an year, it intimated me to select fiscal year from 7 to 12. When
finaly I looked into Reporting period setup of Analytical accouting I found
this error that Fiscal year 2007 which was starting from July 2007 to June
2008 appearing as July 2007 to December 2007 and next year whic...Accounts for customers
Hi, How I can specify the accounts for customers??? I've used
taUpdateCreateCustomerRcd xml but there isn't any fields where I can put the
Sales account, Cost of Sales account, etc, in the customers maintenance I can
specify them, I have great plains 7.5, eConnect 7.5.
Unfortunately, there is no eConnect node that can be used to specify
the distribution on the customer record. To roll out proper accounts,
we first created Customer Class - then manually updated every account
on each class - and then we assigned it customer to that class and it
takes care of the distribution...Accounts
What is your recommened way to handle a user that is not longer with the
companies user account in AD with exchange.
1. if you disable the account does that disable the exchange mailbox?
we do not want this to happen we foward the users mail to their supervisors
for a period of time.
what is the recommended way to handle this situation?
I have similar situation and what i have done is
First change the username and password. ( Don't change Exchange alias )
1) You can choose to keep it that way and have the mails get collected in
mail box and load this mailbox as additional ma...Project Accounting
In Project Accounting, when you are addiing Projects to Employee in the
Project Access List , it would be nice to only see "Open" projects.
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/NewsGroup...Imported statements go into wrong account
I have associated one of my real accounts with the wrong account in Money
2009 delux (current version). How do I remove this association so I can fix
it. Anytime I import now, it no longer gives me the option to pick an
account (since it already knows which one it belong to (i.e. the wrong one))
In microsoft.public.money, singha wrote:
>I have associated one of my real accounts with the wrong account in Money
>2009 delux (current version). How do I remove this association so I can fix
>it. Anytime I import now, it no longer gives me the option to pick an
>account (since...Tooltip not showing on some XP computers.
I have an MFC dlg app. A list control on it with two items.
When moving on items, my tooltip shows. In most XP computers it does work
except few! When I do not embed a manifest for common controls.
and do not provide manifest. It uses system32 dir version, all works fine
(with classic syles showing).
But if manifest is provided or embeded, it uses the WinSxS version of common
controls, but some computers, tooltips arenot showing. All cases
OnToolHitTest is visited, because I have a Beep there, and hear it.
So I can not see a difference in dll file and product infos also!!!
What is the proble...Creating lookups
I would like to create a custom lookup field, but am not sure if it is
possible or if it is how to go about it.
The data types in the customization section do not seem to give lookup as an
Can anyone point me in the right direction?
You have to make a custom entity, then make a relation between this entity
and the entity where the lookup need to be placed.
Finally, add the field to the form
> I would like to create a custom lookup field, but am not sure if it is
&g...Balancing an account #2
MS Money 2004 Premium
I've downloaded 3 months worth of checking statements to
Money and the account balance is way off. I've tried to
fix it with the "balance" feature, but keep making things
worse, not better.
Is there a step by step guide that someone can give me?
I have my bank statements and think the following is the
My earliest downloaded statement starts with a
transaction on November 3rd. My account balance (from my
bank) and the balance that Money shows, are two entirely
different numbers. Is there an easy way to adjust the
beginning numbers...Code to change label colour
I want a label control of a tickbox on a form to change colour if it is
checked, assuming the checked value is YES. I've tried this code but it
Private Sub txtwithdrawn_AfterUpdate()
If Me.txtwithdrawn Is Yes Then
Me.txtwithdrawn_Label.ForeColor = 255
Can anyone help me here.
Sorry for posting too swiftly, realised that checked value should be = True
and it worked.
"Tony Williams" <firstname.lastname@example.org> wrote in message
>I want a label control of a tickbox on a form t...when I open outlook, the messages from POP3 account are all delete
I am very frustrated, and this makes me not use outlook. What to do to have
my other email mailbox unchanged? Thanks!
Are you saying that you have two computers but you want only one
computer to download all messages from the server while the other
computer should download the messages but keep them on the server
for other computer to access them?
If so, then you need to put a check mark around: "Leave a copy of
messages on the server". To get there, try this on the machine
THAT SHOULD NOT DELETE ANY MESSAGES:
1) Open your outlook (if it is not open)
2) On the Me...From an analytical's standpoing -- how to get categories right?
Okay, I'm trying to use Money for what it's supposed to be for,
categorizing everything properly, and not throwing everything into the
But what about a number of odd things, such as:
Stamps or other similar items... I can't call them Groceries, and it
doesn't seem proper to call them Household, either?
Tithing... giving my 10% to my church doesn't seem to have an applicable
I'm sure there are others, but these are the two that have been bugging
me as of late.
In microsoft.public.money, Kenneth Pardue wrote:
...Annoying problem with lookup field
On a client, I have a MOSS 2007 portal with two lists which are not
wroking as expected. One contains people and the other one contains a
lookup field based on data from the first list. When someone which
hasn't got administrative rights logs in and tries to see the
properties of any element in the second list (on DispForm.aspx), they
can't see the lookup field value, and if they try to edit the element,
the dropdown control used to choose a person from the first list
appears empty. Administrator don't have this problem.
The users having the problem have collaboration rig...Showing time as minutes
I have some timed data to enter. Each entry has two values: (1) number
of repetitions and (2) elapsed time in minutes and seconds (mm:ss).
Some sample data is:
I want to enter the data just as shown above. Note that the minutes
may exceed 59. That is, time over an hour is not shown as hh:mm:ss.
I want Excel to calculate the number of repetitions/hour.
Reps mm:ss rph
25 3:22 446
202 15:00 808
99 11:30 517
1405 77:22 1090
The calculations are working correctly, but I am having trouble with
the data entry.
1....Multiply Exchange Accounts
Operating System: Mac OS X 10.5 (Leopard)
Can Office:Mac 2008 Can Entourage handle 2 different exchange accounts at the same time? These was possible with Entourage in Office 2004 Home and Student version.
> Can Office:Mac 2008 Can Entourage handle 2 different exchange
> accounts at the same time? These was possible with Entourage in
> Office 2004 Home and Student version.
Entourage in both the standard version of Office 2008 and Office 2008
Special media Edition supports multiple Exchange accounts.
Entourage in ...Generate Leads/Accounts/Cases from a public website?
My employer asked me to investigate using a public .Net website to help
generate information to be used in CRM. Specifically, he'd like our website
to have webforms that, when filled out and submitted, would generate leads,
accounts, or cases depending on what our needs are (I suspect generating
leads would suffice for now).
Can anyone point me in the right direction on how to accomplish this? I've
found it difficult to find information online concerning this.
We're currently using CRM 3.0 although I'd be interested to know what
differences would be in...Data Source for Analytical Accounting
When I run any of the queries for Analytical Accounting, it processes
partially and then appears to hang.
If I go to the Task Manager, I can see a task for Select Data Source. When I
swtich to the that task, I can select a data source and then must login and
the query finishes writing to Excel.
How can I setup the data source to be saved, selected and logged into,
automatically. It does not seem like this should be something a user has to
do each time.
I am having same problem too,moreover the screen of multilevel query is
displayed at status bar,I cant restore it or close ...