Mark Polino's Blog, page 254
March 12, 2012
Are you ready for new features and functionality in Microsoft Dynamics GP? It is time to start planning your upgrade! - Microsoft Dynamics GP Support Blog
Kelly Youells, the upgrade queen, asks Are you ready for new features and functionality in Microsoft Dynamics GP? It is time to start planning your upgrade!
Viewing reports in XPS - Management Reporter 2012 Feature Highlight - Dynamics Corporate Performance Management
Also from Dynamics Corporate Performance Management comes a look at Viewing reports in XPS - Management Reporter 2012 Feature Highlight
Microsoft Dynamics Partners Mull Their Role in an Azure ERP World | PCWorld Business Center
PC World has a new article where Microsoft Dynamics Partners Mull Their Role in an Azure ERP World
Maybe we'll get more at Convergence as well.
Creating secure report links - Management Reporter 2012 Feature Highlight - Dynamics Corporate Performance Management
Continuing their look at the new features in Management Reporter 2012, Dynamics Corporate Performance Management looks at Creating secure report links.
Free Dynamics GP Books?! | DynamicsCare
Remember, at Convergence 2012 you can get Free Dynamics GP Books?! including the Microsoft Dynamics GP 2010 Cookbook and the Microsoft Dynamics GP 2010 Reporting book.
Checkout the DynamicsCare link Free Dynamics GP Books?! for details.
Weekly Dynamic: ODBC and Excel
Over the last couple of weeks we've looked at some SmartConnect/Excel integration items for Dynamics GP. I've got one more for you.
We were integrating from SmartConnect to GP using Excel as the source. We'd had some problems with filtering incoming data with this version of SmartConnect. The spreadsheet source had 20 rows of headers, one for each potential company, but most of them were blank. These were fixed and populated by data from another excel tab. Below the headers were detail lines that corresponded to the headers.
So how was I going to filter out just the populated lines? I would have to do it in Excel. I dreaded writing some kind of array formula to make it happen and then I remembered ODBC.
As a test, I used Excel's ODBC functionality to look back into the sheet of the same workbook I was in. This let me write a simple, SQL-like "Select * from blah blah blah" to filter the data into a new Excel sheet. I repointed the integration to the new Excel sheet and it worked perfectly. Problem solved. This was just way too easy.
