Reply:

MDA and Analytical Accounting
Can Multidimensional Analysis and Analytical Accounting be used simultaneously? ------=_NextPart_0001_857158BF Content-Type: text/plain Content-Transfer-Encoding: 7bit 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) http://www.microsoft.com/Dynamics mailto:David.Musgrave@online.microsoft.com http://blogs.msdn.com/DevelopingForDynamicsGP 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 below: TRANSFORM Count(ListofORDERS.Code3) AS CountOfCode3 SELECT ListofORDERS.Code3, Count(ListofORDERS.Code3) AS CountOfCode31 FROM ListofORDERS GROUP BY ListofORDERS.Code3 PIVOT ListofORDERS.State; Thanks for...

Account Alias in FRx.
Hi, Is possible to print accoun alias in a FRx report? Thanks a lot.. -- Evelin. Not unless you enter it somewhere in the row format. -- Charles Allen, MVP "Ana Evelin Rosa" wrote: > Hi, > > Is possible to print accoun alias in a FRx report? > > Thanks a lot.. > -- > Evelin. ------=_NextPart_0001_31E0DFAA Content-Type: text/plain Content-Transfer-Encoding: 7bit Evelin, 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? Regards, Mike k5map@arrl.net | 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 -- Steve Bell New Life Home Improvement Arlington, TX USA ...

Importing mail accounts
Hi, 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? TIA alphonse <anonymous@discussions.microsoft.com> wrote: > I just installed Office XP 2002, up from 2000. I have > tried to import my mail accounts that I saved in .iaf > files, 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 the problem. Jeff H. 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 each account >-----Original Mes...

Lookup Issue (V 3.0 CRM)
Hello, 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? Thanks In the onChange event of the customerid field, put a javascript like: var custName=crmForm.all.customerid.DataValue[0].name; { crmForm.CFScompanyname.value=custName; } -- 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. Thanks 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. Regards 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? thanks 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. -- ACG ---------------- 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 option. Can anyone point me in the right direction? Thanks Saira 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 -- Best regards Casper Jensen CRM Extensions www.crmextensions.com "Saira" wrote: > 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 problem: 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 doesn't work Private Sub txtwithdrawn_AfterUpdate() If Me.txtwithdrawn Is Yes Then Me.txtwithdrawn_Label.ForeColor = 255 End If End Sub Can anyone help me here. Thanks Tony Sorry for posting too swiftly, realised that checked value should be = True and it worked. Thanks Tony "Tony Williams" <tw@invalid.com> wrote in message news:eKob1EoYIHA.220@TK2MSFTNGP04.phx.gbl... >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 "Miscellaneous" category. 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 category. I'm sure there are others, but these are the two that have been bugging me as of late. Ken 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: Reps mm:ss 25 3:22 202 15:00 99 11:30 1405 77:22 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
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel 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. gemcconnell@officeformac.com wrote: > 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?
Greetings all, 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. Thanks I am having same problem too,moreover the screen of multilevel query is displayed at status bar,I cant restore it or close ...