Microsoft Product Support

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg
Showing posts with label Microsoft Office. Show all posts
Showing posts with label Microsoft Office. Show all posts

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

Monday, 26 November 2012

Microsoft Dynamics GP Excel Dashboards

Posted on 16:48 by Unknown
Over the past two weeks, I have downloaded, installed, and been playing with my latest demo toy: Excel Dashboards for Microsoft Dynamics GP! In all fairness, this is not a new product, but rather a research being conducted by the Microsoft Dynamics GP Product Management team on the subject of Business Intelligence. However and to drive the topic, they have created a really cool dashboard using Microsoft Excel 2013, which I also happen to be running on my machine.

Excel Dashboard

Installation

The first thing to do is to download the dashboard which you can find here. Of course, most of the settings are tailored for my friend and Microsoft Program Manager, Jared Hall's computer, who kindly put this dashboard together for your delight, so some work is needed to make things work.

Once you have downloaded the spreadsheet, you will need to follow each of the steps provided on the Instructions sheet in the workbook, including running an embedded stored procedure against your company databases. This stored procedure compiles some GL ratios and piggy back on a few already pre-written table valued functions created for the SRS KPI reports.

Dashboard Instructions sheet

The additional steps (3 thru 6) explain how to change the data connections to look at the company database in your environment. Very key is, if you ARE NOT running Microsoft Dynamics CRM, you should follow step 6 to disable the data connections. In particular, I did not have CRM on my laptop, so I removed the data connections and remove the rows where data was supposed to be pulled from CRM to have a clean looking spreadsheet.

I have now showed this dashboard to two prospective clients and needless to say they have all drooled over it, since it works with the financial data in real time. This dashboard plus the Microsoft Dynamics GP 2013 Web Client, and Microsoft Excel 2013 have all been a total hit!

NOTE: Microsoft Office 2013 is available via MSDN or you can download the preview from the Microsoft Office site.

Of course, a research won't be complete without feedback, so here's where you come in. The Microsoft Dynamics GP Product Management team is asking you to answer 3 simple questions:

1. What changes would you make to the current dashboard? Of course, to answer this one you effectively need to have downloaded and play with it for a bit.

2. What other dashboards and what information would you incorporate according to your role in your organization?

3. Of course, what do you do? What's your role in the organization and what challenges do you face?

Please feel free to direct your answers to the Inside Microsoft Dynamics GP blog as comments to the original article:

Business Intelligence Investigation

Now, to my esteemed colleagues in the Product Management team, it would be cool if these questions could be added to a short survey on your site (or elsewhere) as it would make people want to actually provide some feedback... just saying!

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/
Read More
Posted in Dynamics GP 12, Dynamics GP 2010 R2, Microsoft Office, Reporting | No comments

Monday, 16 July 2012

Installing 64-bit Microsoft Access on a 64-bit environment running 32-bit Microsoft Office

Posted on 12:04 by Unknown
If you do much systems installation as I do, you may have become aware that the Microsoft Access Database Engine redistributable is required for Management Reporter process service to read report data from Excel workbooks. However, if Management Reporter is installed on a 64-bit environment, you must install the 64-bit version of Microsoft Access 2010 Database Engine redistributable.

See the Microsoft Access 2010 Database Engine redistributable page for more information and to download the component.

On the other hand, some specific (and widely used) features in Microsoft Dynamics GP 2010 require 32-bit Microsoft Office - Email and Word Templates features.

See the Technology Requirements for Microsoft Dynamics GP 2010 and Microsoft Dynamics GP 2010 R2 Features page for more information.

To overcome the issue, this is, being able to install 64-bit Microsoft Access Database Engine redistributable, side by side with a 32-bit Microsoft Office installation, you must install the redistributable package in passive mode.

You will need to open the Command prompt (Start | Run | type CMD and press Enter) and change the path to the directory where the redistributable package was downloaded, then type the following:

64-bit Microsoft Access Database Engine redistributable installation 
This should allow you to proceed with your Management Reporter 2012 installation.

Until next post!

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

Wednesday, 13 July 2011

Microsoft's upcoming products available for download

Posted on 19:26 by Unknown
A bit away from the Microsoft Dynamics GP world, but at the same time so close, here are some very good news on the upcoming release of Microsoft SQL Server "Denali", Office 2010 and SharePoint, and Internet Explorer.

Microsoft SQL Server Code Name 'Denali'

Download SQL Server Code Name "Denali" CTP3

SQL Server Code Name "Denali" Community Technology Preview
(CTP3) provides the foundation for the cloud-ready information
platform, and will help customers unlock insights across the
organization and quickly build solutions that extend data across

on-premises and public cloud.
Microsoft Office 2010

Office 2010 and SharePoint 2010 Service Pack 1 Now Available

Service Pack 1 is now available for the 2010 family of products, including Office, SharePoint, Project Server, FAST, Search Server, and Groove Server. For more on deployment, see these articles: Apply Office 2010 Service Pack 1 and Deploy Service Pack 1 for Project Server 2010. Also, download the Service Pack 1 for SharePoint Foundation 2010 and SharePoint Server 2010 White Paper.


Internet Explorer 10

Internet Explorer 10: Platform Preview 2

The latest preview build of Internet Explorer 10, Platform Preview 2,
is now available for download. With the second Platform Preview,
developers can start working with several site-ready HTML5
technologies.
Remember... should you decide to try any of this code, do so in a test environment.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/
Read More
Posted in Internet Explorer, Microsoft Office, SharePoint, SQL Server | No comments

Wednesday, 6 October 2010

Chat About Microsoft Office and Windows with Microsoft MVP Experts

Posted on 12:12 by Unknown
I have been asked to share with you an upcoming public chat involving some of our Microsoft Office and Windows MVPs. MVPs have volunteered to answer Windows and Office questions directly from the public in a live chat! Can you help spread the word about this public chat? Thanks in advance for your assistance and feel free to join us for the chat next week.

Chat About Microsoft Office and Windows with Microsoft MVP Experts
October 14, 2010
10:00 A.M. - 11:00 A.M. Pacific Time
Additional Time Zones

Would you like to learn more about the cool new features in Microsoft Office 2010 and Microsoft Windows 7 and what has changed since previous versions? Do you use Microsoft Office but would like to learn tips and tricks to be more productive at home, school or at work? Perhaps you are a new user who has questions on how to get started with Windows 7 or using the Office ribbon? Or would like to learn how to protect your computer from malware and viruses. Or perhaps you are just stuck and need answers.

My fellow Microsoft Office and Windows Most Valuable Professionals (MVPs) are here to help!

The MVPs are the same people you see in the technical community as authors, trainers, user groups leaders and answerers in the Microsoft forums. For the first time ever Microsoft have brought these experts together as a collective group to answer your questions live. MVPs will be on hand to take questions about Microsoft Office 2010 or Office 2007 products such as Word, Excel, PowerPoint, Outlook, Access, Project, OneNote and more. As well as the Windows 7 and earlier versions such as Windows Vista. In addition to Microsoft Office, the chat will cover Windows related topics such as upgrading, setup and installation, securing your PC, Internet Explorer, personalizing your computer desktop or having fun with Windows Live Essentials to share photos, make movies and more. All levels of experience are welcome from beginners and students to intermediate power users.

Please join us for this informative Q&A style chat and bring on your basic and your tough questions!

Join the Chat!
October 14, 2010
10:00 A.M. - 11:00 A.M. Pacific Time
Additional Time Zones

Add to Calendar

Social Networking

You can follow this on Twitter at #msmvpchat
Join the event on Facebook: Chat about Microsoft Office & Windows with MVP Experts!

Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/
Read More
Posted in Events, Microsoft Office, Windows 7 | No comments

Friday, 1 October 2010

Microsoft Dynamics GP 2010 Word Templates summary

Posted on 12:00 by Unknown
Microsoft Dynamics GP 2010 Word Templates offer new presentation capabilities to the traditional customer/vendor facing Report Writer reports. This week was just a superficial scratch of the myriads of things that are possible to achieve. Like with everything else, I am sure there are limitations, but it will take some time to discover what those are. Nonetheless, I will continue exploring this topic and bring to you my findings

Articles Covered

How to add a "Terms and Conditions" page to a Microsoft Dynamics GP Word Template document
Debugging Microsoft Dynamics GP 2010 Word Templates
How to resize logo in Microsoft Dynamics GP Word Templates
The Open XML SDK 2.0 for Microsoft Office

Acknowledgements

I have to thank Microsoft's Rob Wagner for his invaluable support and guidance throughout the week. Rob also provided the cool code and pointed to the online resources available on the Open XML subject.

Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/
Read More
Posted in Dynamics GP 2010, Microsoft Office, Word Templates | No comments

The Open XML SDK 2.0 for Microsoft Office

Posted on 04:00 by Unknown
Along with the introduction of Microsoft Dynamics GP 2010 Word Templates came a little known software development kit: Open XML SDK 2.0.

Open XML is an open ECMA 376 standard and is also approved as the ISO/IEC 29500 standard that defines a set of XML schemas for representing spreadsheets, charts, presentations, and word processing documents. Microsoft Office 2007 and Microsoft Office 2010 all use Open XML as the default file format for rendering spreadsheets, documents, and presentations.

The Open XML file formats are useful for developers because they use an open standard and are based on well-known technologies: ZIP and XML.

The Open XML SDK 2.0 for Microsoft Office is built on top of the System.IO.Packaging API and provides strongly typed part classes to manipulate Open XML documents. The SDK also uses the .NET Framework Language-Integrated Query (LINQ) technology to provide strongly typed object access to the XML content inside the parts of Open XML documents.

In the case of Microsoft Dynamics GP 2010, the assembly enables developers to easily read-from and write-to Microsoft Word documents using their favorite language in Microsoft Visual Studio. The following image depicts the assembly in the Global Assembly Cache (GAC).


You can find more examples and a cool tool available at the Open XML SDK 2.0 download site. Using this tool, Rob Wagner was able to compare the original template shipped with GP and the modified version I created, when troubleshooting some issues I was having when adding a new section to the original template – see Debugging Microsoft Dynamics GP 2010 Word Templates.

Using the Open XML to work with Word documents

The following C# console application demonstrates how to use OpenXML to add a new table to the end of a document (similar to the text added in the “terms and conditions” article).

//---------------------------------------------------------------------
// This file is a Microsoft Dynamics GP Business Intelligence Code Sample.
//
// Copyright (C) Microsoft Corporation. All rights reserved.
//
//This source code is intended only as a supplement to Microsoft
//Development Tools and/or on-line documentation. See these other
//materials for detailed information regarding Microsoft code samples.
//
//THIS CODE AND INFORMATION ARE PROVIDED AS IS WITHOUT WARRANTY OF ANY
//KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE
//IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A
//PARTICULAR PURPOSE.
//---------------------------------------------------------------------

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Wordprocessing;
using wp = DocumentFormat.OpenXml.Wordprocessing;

namespace NewTableAdHocText
{
class Program
{
public bool AddTableAdHocText(string WordDocPath, string TextPath)
{
try
{
//read the ad-hoc text and store it for later
StreamReader srStreamReader = new StreamReader(TextPath);
String sString = srStreamReader.ReadToEnd();

//open the word document and it's main document part
using (WordprocessingDocument wdWordDoc = WordprocessingDocument.Open(WordDocPath, true))
{
MainDocumentPart mdpWordDocMainPart = wdWordDoc.MainDocumentPart;
//create then add a new paragraph
wp.Paragraph wppParagraph = new wp.Paragraph(new wp.ParagraphProperties(new wp.ParagraphStyleId() { Val = "NoSpacing" }));
mdpWordDocMainPart.Document.Body.Append(wppParagraph);
//create new markup for the table
Table wppTable = new Table(
new TableProperties(
new TableStyle() { Val = "TableGrid" },
new TableWidth() { Width = "0", Type = TableWidthUnitValues.Auto },
new wp.TableBorders(
new TopBorder() { Val = BorderValues.None },
new LeftBorder() { Val = BorderValues.None },
new BottomBorder() { Val = BorderValues.None },
new RightBorder() { Val = BorderValues.None, },
new InsideHorizontalBorder() { Val = wp.BorderValues.None },
new InsideVerticalBorder() { Val = wp.BorderValues.None }),
new TableLook() { Val = "04A0", FirstRow = true, LastRow = false, FirstColumn = true, LastColumn = false, NoHorizontalBand = false, NoVerticalBand = true }),
new TableGrid(
new GridColumn() { Width = "11016" }),
new TableRow(
new TableCell(
new TableCellProperties(
new TableCellWidth() { Width = "11016", Type = wp.TableWidthUnitValues.Dxa }),
new Paragraph(
new ParagraphProperties(
new ParagraphStyleId() { Val = "NoSpacing" },
new KeepLines(),
new PageBreakBefore(),
new ParagraphMarkRunProperties(
new RunFonts() { Ascii = "Trebuchet MS", HighAnsi = "Trebuchet MS" },
new FontSize() { Val = "17" },
new FontSizeComplexScript() { Val = "17" }),
new LastRenderedPageBreak(),
new Run(
new RunProperties(
new RunFonts() { Ascii = "Trebuchet MS", HighAnsi = "Trebuchet MS" },
new FontSize() { Val = "17" },
new FontSizeComplexScript() { Val = "17" },
new Text(sString)))))))); //text for the run comes from the adhoc text document
//add then save the table to the document
mdpWordDocMainPart.Document.Body.Append(wppTable);
mdpWordDocMainPart.Document.Save();
}
}
catch (Exception e)
{
Console.WriteLine(e.InnerException);
return false; //failure
}
return true;
}

static void Main(string[] args)
{
new Program().AddTableAdHocText(args[0], args[1]);
}
}
}

The above example shows how simple it is to:

1) Crack open a word document.
2) Append a table to the end with specific properties.
3) Insert some ad-hoc text into the table.

The major advantage is the strongly typed interface to office document. You don’t need COM interoperability to manipulate any document.

You can download the sample project at the bottom of this article.

Downloads

NewTableAdhocText.zip - C# command line application to demonstrate adding a table at the end of a Word Document.

Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/
Read More
Posted in C#, Code, Microsoft Office, OpenXML, Visual Studio 2008, Word Templates | No comments

Thursday, 30 September 2010

How to resize logo in Microsoft Dynamics GP Word Templates

Posted on 14:32 by Unknown
Getting used to the new Word Templates functionality can be a bit challenging at times. One of those challenges came in the form or a simple question: "How to resize the logo on the template?". One thing to keep in mind is that most objects on a Microsoft Dynamics GP Word Template document live inside of content controls. With that said, here are the steps to achieve this, taking the SOP Blank Invoice Form Template* as an example:

1. Under Report Template Maintenance, select the SOP Blank Invoice Form template from the More Reports list.

2. Click the New button to create a new template. For this example, we will create the template based on the existing template and we will call it SOP Blank Invoice Form Icon. Click Ok to continue.



3. Highlight the newly created template, then click the Modify button to open Microsoft Word.



4. Click on the Picture content control to add a logo image.



Note: This image must also exist in the Image library under Template Configuration.

5. Select the logo, right-click, and chose Remove Content Control.



6. Highlight the image and resize accordingly. The following is a sample of the resized image with some extra text to go along:



NOTE: The logo is part of the Header section of the document.

7. Save the modified template to a different directory where it can be imported from later on, for example, My Documents. Close Microsoft Word.


8. Back to Report Template Maintenance, click the Add Template button and select the newly modified template from the My Documents folder. Replace the existing one when prompted.

9. Click the Assign button, then mark the company you want to assign the template to. Then, click on Set as Default to make the new template the default template for the company. Click Save to continue. Click Save to continue.


10. Back to the Report Template Maintenance window, highlight the original template and click the Assign button and choose Company. Unmark the company and choose Save.


NOTE: This will ensure that the copied version of the original template prints always.

11. To test, select a SOP invoice and print.


Hope you found these steps simple to follow and that you are enjoying the new Word Templates feature in Microsoft Dynamics GP 2010.

Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/
Read More
Posted in Dynamics GP 2010, Microsoft Office, Reporting, Sales Order Processing, Word Templates | No comments

Tuesday, 28 September 2010

Debugging Microsoft Dynamics GP 2010 Word Templates

Posted on 05:00 by Unknown
In my previous article I outlined a few steps to add a page of terms and conditions to an invoice form. However, these changes did not come without their challenges. When I initially started out working on this customized template, my "natural instinct" was to add a new section to the Word template and unlink the header and footer from the previous section, then add the text. To complicate matters a bit more, I had added this new template as a modified version of a modified report - SOP Blank Invoice Form Template (Modified). Typically this is what would be encountered in a GP environment anyways as most standard GP invoice forms were customized even before the Word Templates functionality even existed in GP.

Somehow, these changes managed to crash and display a message in the Template Processing Exceptions(TPE) window and I ended up with this error:


One or more templates could not be processed. View the exception log for more details.

Well, that was a good start... but, where was the exception log?

Of course, being the well connected individual that I am - Ehem! - I sent this one off to my good friend Rob Wagner over at Microsoft Business Division, who is also known as "The Word Templates God" in some circles. Rob pointed me to a new DEX.INI setting available for Word Templates:

TPELogging=TRUE

In Rob's own words, "FYI, dex.ini TPELogging=TRUE is used to gather where an exception has occurred. It points the combine process where I will go in and debug the TPE.".

The log is created in the %temp% directory where the actual Word document is rendered and its content looks something like this:

10 hours. 57 minutes.13 seconds. 901 milliseconds. :20050: Combine.Unhandled

TPE was indicating that there was an issue with an exception not being handled when the XML data from Report Writer was being combined with the actual Word template.

This allowed Rob and his team to start tracking down the issue with my template from the source code and provide me with an alternate route to solve my problem.

As a final note, it seems there is an issue as well with TPE not clearing some process after choosing to remove the exception from the Report Processing Status window. In turn, this prevents shutting down GP via the Exit option, having to use the Windows Task Manager to force the termination of the DYNAMICS.EXE process. Rob's team is on this too.

Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/
Read More
Posted in DEX.INI, Dynamics GP 2010, Microsoft Office, Troubleshooting, Word Templates | No comments

Monday, 27 September 2010

How to add a "Terms and Conditions" page to a Microsoft Dynamics GP Word Template document

Posted on 11:51 by Unknown
It's officially Microsoft Office Word Templates week here at The Dynamics GP Blogster!

With the integration of Microsoft Word Templates into Microsoft Dynamics GP 2010, the possibilities of delivering professional looking business facing documents increased 1000-fold. Now, Microsoft Dynamics GP users want to take full advantage of Word's editing and document formating capabilities to introduce extra information in their business facing documents that was simply quite complex or impossible to achieve with Report Writer.

A common request among users is to add a Terms and Conditions page to a SOP invoice form. For this example, we will use the SOP Blank Invoice Form report. You can follow these steps to achieve just that:

1. If you haven't done so, enable the SOP Blank Invoice Form Template* report under the Template Configuration Manager window. Click Save to continue.



2.  Open the Report Template Maintenance window and choose the SOP Blank Invoice Form from the More Reports option.

[NOTE: If you are working with a modified version of the SOP Blank Invoice Form created in Report Writer and exposed to Word Templates, then choose Modified from the Status drop-down list.

3.  Click the New button  on the Report Template Maintenance window to create a new template based on the existing one. For this example, we will call this template SOP Blank Invoice Form with Conditions. Click the Create button when finished.


You should now see the new template version in the Available Templates pane in the Report Template Maintenance window.

4. Click on the Modify button to open the SOP Blank Invoice Form Template with Conditions template in Microsoft Word. Position the cursor beneat the Total field and insert a 1 row by 1 column table.


Add the Terms and Conditions text inside the table as shown below.


5. Highlight the newly added table and its text, then click on the Paragraph expansion button under the Home ribbon to open the options window. Click on the Line and Page Breaks tab and mark the Keep Lines Together and Page Breaks Before check marks. Click Ok to continue.


Note that the table has now moved to a second page.

6. Save the modified Word template in your My Documents folder to avoid loosing your changes when you close Word then reimport the template in the Report Template Maintenance window. Assign the template to the company and make it the Default template.


NOTE: You can also choose to assign the template to specific customers if needed, however, for demo purposes, we are choosing to default the template.

7. Print a SOP invoice choosing the Blank form to ensure the template prints as expected.

NOTE: At the end of this article I realized I had modified the SOP Blank History Invoice Form Template. Print a historical invoice instead as the results should be the same.

Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/
Read More
Posted in Dynamics GP 2010, Microsoft Office, Word Templates | No comments

Friday, 2 July 2010

Microsoft Dynamics GP 2010 and Office Web Components

Posted on 14:00 by Unknown
A recurring question throughout these days of upgrades to Microsoft Dynamics GP 2010 is what version of Microsoft Office Web Components (OWC) is compatible with Microsoft Dynamics GP 2010. In this article, I will address this question by explaining what is OWC and how it is used.

OWC are a collection of Component Object Model (COM) controls for publishing spreadsheets, charts, and databases to the Web and are required to support the display of metrics on a Microsoft Dynamics GP home page. These components have been released with various versions of Microsoft Office, as shown below.







Source: OfficeBlogs.net

The latter is important to understand, because the Microsoft Dynamics GP home page is an HTML rendering done from Dexterity code with the aid of some XSL and cascading stylesheets. The HTML code embeds calls to OWC functions via JScript to display the metrics.

The current supported version of OWC is Microsoft Office 2003 Web Components for versions 9, 10, and 2010.

So now that we have gotten past this point, Office Web Components have been discontinued in Office 2007 (so don't expect to see them in Office 2010 either), and are not included, except as a part of Microsoft Office Project Server 2007. However, they will still be available for download from Microsoft's website. Microsoft has not yet offered a complete replacement for the Office Web Components. However, developers can use a combination of third party products, Excel Services or Visual Studio Tools for Office to provide similar functionality.

My guess is that Fargo will continue to use OWC until there is a new roadmap in place for the product. We may have started to see some of this with the use of the Dundas Chart Controls, featured in Microsoft Dynamics GP 2010 if using SSRS metrics.

Please let me know what you think.

Related Articles

Microsoft Office 2003 Web Components - download

KB Article 916673 - Error message when you view the home page in Microsoft Dynamics GP: "Metrics are not available because Microsoft Office Chart..."

Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
Read More
Posted in Dexterity, Home Page, Microsoft Office, Office Web Components | No comments

Friday, 14 May 2010

Undocumented DEX.INI switch cuts down SmartList export times to Microsoft Office Excel

Posted on 09:21 by Unknown
Ok, so why the journalistic type nature of this article? Well, if like many users out there you tend to export tens of thousands of records out of Microsoft Dynamics GP using SmartList and you complain about the export's performance, then I guarantee you will want to read Patrick Roth's new article Smartlist: Exports slowly to Excel - Part 1.

In his article, Patrick details an undocumented DEX.INI setting that changes the way records are exported from SmartList into Microsoft Office Excel. The feature was added since release 10 and remains active in release 2010.

SmartlistEnhancedExcelExport=TRUE

Patrick further explains the feature trades formatting for performance, so if you are an Excel wizz just looking to get data out so you can do the rest on your own, then this switch is for you.

The DEX.INI is the Microsoft Dynamics GP defaults file containing setup and operating information about Microsoft Dynamics GP. Each line of information, or setting, in the file contains information such as where your files are located, and whether certain functions, such as displaying print dialog boxes, should be performed.

Additional Resources

DEX.INI on this blog - click here
DEX.INI at Dynamics Confessor blog - click here
DEX.INI at Developing for Dynamics GP blog - click here

Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/
Read More
Posted in Around the Blogosphere, DEX.INI, Microsoft Office, SmartList and SmartList Builder | No comments

Monday, 8 February 2010

"Advanced Excel for Microsoft Dynamics GP" Training

Posted on 07:47 by Unknown
My friend, MVP Mark Polino is hosting a 2-day class from March 1 - 2, 2010 at the IBIS, Inc., offices in Norcross, Georgia (20 minutes north of downtown Atlanta). Mark promises some blood after you leave this class as nothing will hold you back anymore from connecting Microsoft Dynamics GP and Microsoft Office Excel -- not my words!

Take advantage of this unique opportunity to get some training from one of the best in the business, so click here for more information.

Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/
Read More
Posted in Events, Microsoft Office, Training | No comments
Older Posts Home
Subscribe to: Posts (Atom)

Popular Posts

  • The Dynamics GP Blogster's best articles of 2012
    It's that time of the year again! Time to say goodbye to the outgoing year, 2012, and receive the new one, 2013, making all sort of reso...
  • Running Fixed Assets Depreciation causes Microsoft Dynamics GP to "hang"
    I just completed a full upgrade of Microsoft Dynamics GP from version 9 to version 2010 R2 for a client and they were going through their fi...
  • Resetting GP desktop position and size with the Support Debugging Tool
    Just recently I worked on an issue being experienced by several Microsoft Dynamics GP users in a Citrix environment. The users would report ...
  • Microsoft Dynamics Convergence Atlanta 2011: Day 3
    Day 3: April 12, 2011 Today started with David and I meeting in the Speaker Room catching up on the previous days activities. Of course, if ...
  • Microsoft SQL Server performance boosting settings for Microsoft Dynamics GP - Part 1
    Part 1 of 2 - Microsoft SQL Server performance boosting settings for Microsoft Dynamics GP. Disclaimer: this is not a "one-size-fits-al...
  • Vote for your 2012 GPUG All Star
    The time has come again to vote for the next year's GPUG All Star awards. Surprisingly, I have been nominated to this award along with f...
  • Running Windows 8.x Business Analyzer app on a laptop with SQL Reporting Services
    If you are a consultant, chances are you run your Microsoft Dynamics GP application demo environment on a laptop along with Microsoft SQL Se...
  • "Unable to access SnapIn config data Store" accessing Web Management Console
    For quite some time I had been running into this error when attempting to access the Microsoft Dynamics GP 2013 Web Management Console appl...
  • Microsoft Dynamics GP Architectural Foundations Series - Built to Fit
    This is article 5 of 7 from the series Microsoft Dynamics GP Architectural Foundations Series - featuring Microsoft's Tim Brookins . Tim...
  • Microsoft Dynamics Convergence 2011 sessions are now out!
    If you are attending Microsoft Dynamics Convergence this year, it's a good time to begin planning the sessions you want to attend. The ...

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)
      • Visual Studio Tools for Microsoft Dynamics GP 2013...
      • Web Client Wednesday: Microsoft Dynamics GP on Azure
    • ►  November (8)
    • ►  October (5)
    • ►  September (5)
    • ►  August (3)
    • ►  July (8)
    • ►  June (5)
    • ►  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