Microsoft Product Support

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Tuesday, 25 June 2013

How does Microsoft Dynamics GP determine which account to use when sending emails

Posted on 08:26 by Unknown
One of the advantages of working with Microsoft Outlook is its ability to configure multiple email accounts.  Recently, a partner was working with a customer that supports multiple companies, so a such, each employee has an email account per company supported.

The partner was under the impression that Microsoft Dynamics GP "looked" at the mailbox for the email account opened at the time of sending an email, but came to the conclusion it wasn't the case as the customer could not get emails sent through a second email account.

So how does Microsoft Dynamics GP determine which email account to use when sending emails via Microsoft Outlook?

The mailbox information is determined based on the default email account configured in Microsoft Outlook. To check for the default email account in Microsoft Outlook, follow one of the following two procedures:

Method 1: Control Panel

1. Open the Control Panel
2. Double-click on User Account and Family Safety
3. Click on Mail to Open the Mail Setup - Outlook window
4. Click on the Email Accounts button to open the Account Settings window

Account Settings window

Method 2: Outlook

1. From inside Microsoft Outlook, click on the File menu
2. Click on the Account Settings drop-down button under the Account Information pane.

Account Settings button


3. Click on the Account Settings option in the drop-down and this should open the previously shown Account Settings window.

Now, the account marked with the checkmark next to it will be the default account used by Microsoft Dynamics GP when sending emails.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/
Read More
Posted in Microsoft Office, Troubleshooting | No comments

Friday, 21 June 2013

Microsoft Dexterity Training Roadshow - Next Stop: Boston

Posted on 13:03 by Unknown
(C) Microsoft Corporation

The Microsoft Dexterity Training Roadshow rolls around the United States with its next and final stop in Boston, Massachusetts from July 15 - July 19, 2013. Our training will be hosted in the Regus Business Center, from 9:00 AM to 5:00 PM.




Regus Business Center
60 State Street, Suite 700
Boston, MA 02109

We still have some seats left, so if you want to learn some of the development techniques used by Microsoft Dynamics GP developers this is your chance. For registration information, click here.

Stay tuned as we will announce our second Roadshow coming up.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/
Read More
Posted in Dexterity, Training | No comments

Thursday, 20 June 2013

Microsoft Dynamics GP Technical Airlift 2013

Posted on 15:19 by Unknown

The Microsoft Dynamics GP Technical Airlift 2013 hosted by GP Partner Connections is a little less than 3 months away, so if you are a Microsoft Dynamics GP partner please register now.

As is customary, I will be attending the Technical Airlift as a presenter this year and will really be rocking a cool new session:


Developing for the Web Client: a Microsoft Dexterity perspective
September 18 • 1:15pm - 2:15pm

In this session, I will be presenting some new (and not so new) techniques used by Microsoft Dexterity developers to render integrating applications on the Web Client. Come learn about user interface standards, ribbons, command forms, selective programming (Web Client vs Rich Client), techniques for converting your VBA customization to Web Client compatible customizations, and performance killers.

Lot's to cover in one hour, but trust me, you will walk out of this session with some good tips for your bag of tricks.

See you in beautiful Fargo, North Dakota.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/
Read More
Posted in GPUG, Technical Conference, Training | No comments

Wednesday, 19 June 2013

How to do a "Save As" in SmartList Builder

Posted on 18:09 by Unknown
Ever wish you could do a "Save As" in SmartList Builder? Have you been working on a very complex SmartList and got to a point where things are working and now you need to make additional changes and you don't want to mess up the work you have done so far?

Just recently, I came across a request for being able to save a SmartList Builder smartlist under a different name - hence the "Save As" title. However, as you know SmartList Builder does not offer the ability to perform such operation out of the box. So here are some steps for you to do a "Save As" with Smartlist Builder:

1. Open SLB's Export Lists window and click on the list you would like to duplicate.
MSDGP | Tools | SmartList Builder | Export

Export Lists window
Enter or identify a path and file name for the list to be exported. Click the Export button when finished.

2. Edit the exported XML file with a text editor, for example Notepad. Search and replace all occurrences of the list ID in your file with the new name.

XML file edited in Notepad
Save the file when finished and exit the editor.

3. Open the SLB's Import Lists window and choose the file you previously exported, now containing the changes you made in step 2.

Import Lists window

Click the Import button to perform the actual import.

4. Return to SmartList Builder to verify the imported record.

Duplicated List

It would be nice sometimes if some of these features were provided straight out of the box, but with some understanding of the functionality and little creativity almost anything can be accomplished.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/
Read More
Posted in SmartList and SmartList Builder | No comments

Friday, 7 June 2013

Microsoft SQL Server security roles and Microsoft Dynamics GP SSRS reports

Posted on 07:00 by Unknown
It's not uncommon to find system administrators and consultants alike struggling to deploy Microsoft Dynamics GP SRS reports in an environment, while trying to keep these reports secured. I find that the main issue revolves around understanding the different moving parts: domain accounts, GP user logins, the SQL Server database roles created for reporting, the reports web site security, the reports folder security and the list goes on.

So here is a list of resources that I believe will help with this:

The best place to start is the SQL Server Reporting Services Guide, which has all of the information for installing, deploying and setting up security for SRS reports to use with Dynamics GP. This guide is available for download from the Microsoft Download Center.

Microsoft Dynamics GP 2013 Guide: SQL Server Reporting Services

In order for users to access SRS reports (default) for Dynamics GP, they need to have the following permissions:

1. Access to the Reporting Services web site (native mode) or report library (SharePoint Integrated). I have found the following resources to be extremely useful when configuring Reporting Services security in native mode:

Granting Permissions on a Native Mode Report Server

If you are dealing with Reporting Services in SharePoint Integrated mode, the following is a good resource:

Security Overview for Reporting Services in SharePoint Integrated Mode


2. Permissions to the SRS report files themselves. The following TechNet video shows just that:


3. Database security roles (RPT_ ) under the DYNAMICS and/or company databases in order to pull data into the SRS reports. You will want to take a look at the following KB article 954242 - Frequently asked questions about the integration of SQL Server Reporting Services (SSRS) with Microsoft Dynamics GP 10.0 and Microsoft Dynamics GP 2010, which can be found at:

http://support.microsoft.com/kb/954242

I hope you find these resources useful.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/
Read More
Posted in Security, SQL Reporting Services, Troubleshooting | No comments
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

Popular Posts

  • The Open XML SDK 2.0 for Microsoft Office
    Along with the introduction of Microsoft Dynamics GP 2010 Word Templates came a little known software development kit: Open XML SDK 2.0. Ope...
  • Year-to-year Inventory Margin Report using the PIVOT operator in T-SQL
    As of late I have been camping out at the SQL Developer Center's   Transact-SQL Forum  and I have to say, I have learned a great deal fr...
  • Web Client Wednesday - Browser Support
    Last week MVP Mark Polino started a series called Web Client Wednesdays, which is actually a Microsoft Dynamics GP community outreach to st...
  • SmartList Designer: a nice addition to Microsoft Dynamics GP 2013 SP2
    12.00.1482 - the build number for Microsoft Dynamics GP SP2 - brought with it a new list of awesome enhancements. The SmartList reporting to...
  • Granting Access and Binding Defaults when recreating SQL Tables: a follow up
    In his most recent article, Granting Access and Binding Defaults when recreating SQL Tables , my good friend, David Musgrave, points out how...
  • VBA - Suppressing CTRL+Break or CTRL+C in VBA Customizations
    VBA is by far one of the best customization tools available to Microsoft Dynamics GP developers and as such it is widely used across a numbe...
  • Printing to screen and PDF file causes default printer to change to Acrobat PDF Writer
    A user recently reported a strange Microsoft Dynamics GP behavior when trying to print any report in to file in PDF format, while simultaneo...
  • Rejecting duplicate checks during Bank Transactions import with Integration Manager
    One of the interesting things about checkbooks setup in Microsoft Dynamics GP is that you have the ability to prevent duplicate checks from ...
  • Microsoft Dynamics GP Add-In for Microsoft Word not enabling despite several attempts to install
    Just recently, I ran into a situation with the Microsoft Dynamics GP Add-In for Microsoft Word where, after following all the installation s...
  • Adobe PDF Converter error when sending report to PDF in Microsoft Dynamics GP
    Just recently, I was working on a few Report Writer reports for a client and assisting with installing the latest Adobe Acrobat Standard ver...

Categories

  • Ad Campaigns
  • ADO
  • Adobe Acrobat
  • Analytical Accounting
  • Architecture
  • Around the Blogosphere
  • Article
  • Azure
  • Bank Reconciliation
  • Best of 2009
  • Best of Series
  • Best Practices
  • Bing Maps Enterprise
  • Books
  • Business Alerts
  • Business Analyzer
  • C#
  • Code
  • COM
  • Community
  • Compliance
  • Connect
  • Continuum
  • Convergence
  • Corporate Performance Management
  • CRM
  • Database Maintenance Utility
  • Decisions Conference
  • DEX.INI
  • DEXSQL
  • Dexterity
  • Discussions
  • Drill-Down Builder
  • Dynamics GP 10
  • Dynamics GP 11
  • Dynamics GP 12
  • Dynamics GP 2010
  • Dynamics GP 2010 R2
  • Dynamics GP 2013
  • eConnect
  • EFT
  • Electronic Banking
  • Encumbrance
  • Events
  • Extender
  • Field Services
  • Fixed Assets
  • Forecaster
  • From the Newsgroups
  • FRx
  • Functionality
  • General Ledger
  • GPUG
  • Home Page
  • Human Resources
  • Humor
  • IMHO
  • Installation
  • Integration
  • Integration Manager
  • Internet Explorer
  • Inventory
  • Kinnect
  • Maintenance
  • Management Reporter
  • Manufacturing
  • Menus for Visual Studio Tools
  • Microsoft Office
  • Modifier
  • Multicurrency Management
  • Multitenancy
  • MVP Summit
  • MVPs
  • Named Printers
  • Navigation Pane
  • Notes
  • ODBC
  • Office Web Components
  • OLE Container
  • Online Services
  • OpenXML
  • Partner Connections
  • Payables Management
  • Payroll
  • Performance
  • PO Commitments
  • Printer Compatibility
  • Product Feedback
  • Project Accounting
  • Purchasing
  • Receivables Management
  • RemoteApp
  • Report Writer
  • Reporting
  • Roadmap
  • SafePay
  • Sales Order Processing
  • Season Greetings
  • Security
  • Service Call Management
  • SharePoint
  • SmartList and SmartList Builder
  • SQL Reporting Services
  • SQL Scripting
  • SQL Server
  • Support Debugging Tool
  • Tax Updates
  • Technical Conference
  • The Partner Event
  • The Technology Corner
  • Training
  • Translation
  • Troubleshooting
  • Upgrades
  • VAT
  • VB.NET
  • VBA
  • VBScript
  • Visual Studio 2008
  • Visual Studio Tools
  • Web Client
  • Web Services
  • Windows 7
  • Windows 8
  • Word Templates
  • XBox
  • XBRL

Blog Archive

  • ▼  2013 (68)
    • ►  December (2)
    • ►  November (8)
    • ►  October (5)
    • ►  September (5)
    • ►  August (3)
    • ►  July (8)
    • ▼  June (5)
      • How does Microsoft Dynamics GP determine which acc...
      • Microsoft Dexterity Training Roadshow - Next Stop:...
      • Microsoft Dynamics GP Technical Airlift 2013
      • How to do a "Save As" in SmartList Builder
      • Microsoft SQL Server security roles and Microsoft ...
    • ►  May (5)
    • ►  April (2)
    • ►  March (11)
    • ►  February (6)
    • ►  January (8)
  • ►  2012 (101)
    • ►  December (8)
    • ►  November (6)
    • ►  October (15)
    • ►  September (16)
    • ►  August (9)
    • ►  July (4)
    • ►  June (4)
    • ►  May (6)
    • ►  April (4)
    • ►  March (11)
    • ►  February (4)
    • ►  January (14)
  • ►  2011 (158)
    • ►  December (7)
    • ►  November (17)
    • ►  October (7)
    • ►  September (8)
    • ►  August (8)
    • ►  July (12)
    • ►  June (12)
    • ►  May (13)
    • ►  April (23)
    • ►  March (21)
    • ►  February (10)
    • ►  January (20)
  • ►  2010 (168)
    • ►  December (15)
    • ►  November (11)
    • ►  October (12)
    • ►  September (24)
    • ►  August (13)
    • ►  July (12)
    • ►  June (8)
    • ►  May (17)
    • ►  April (14)
    • ►  March (9)
    • ►  February (16)
    • ►  January (17)
  • ►  2009 (5)
    • ►  December (5)
Powered by Blogger.

About Me

Unknown
View my complete profile