The Dynamics GP Blogster

Majority of times, when we are working with various data sources, we want information to go from one source to another, conditioned to the occurrence of an event. Today, I will show you how to transfer records from a SharePoint list to Azure SQL database tables in response to a timesheet approval event. In the process, you will learn how I leveraged the existing Power Apps Expense template app and converted it into a Timesheet app for the purpose of recording time for various activities  Other topics covered: Working with SharePoint lists and Azure SQL databases "When an item is created or modified" SharePoint connector trigger "Delete Item" SharePoint connector action "Get Items" SharePoint connector action Conditional actions Get Rows and Insert Row SQL connector actions Apply to each action substring(), formatDateTime() Please leave your comments below and let me know what you think. Also, please feel free to suggest topics you would like me to cover....

I realize this one is a really obscure topic, but I thought it was important to bring it to light. Microsoft Office PerformancePoint Server  was an actual thing, it existed, and to the surprise of everyone reading this and not in the channel long enough to remember, Dynamics GP had a connector to it. Summary Microsoft Office PerformancePoint Server was a business intelligence software product released in 2007 by Microsoft. It was discontinued in 2009, then resurfaced with its dashboard, scorecard, and analytics capabilities incorporated into SharePoint Server 2010 - the feature was known as PerformancePoint Services in SharePoint Server 2013. PerformancePoint Server also provided a planning and budgeting component directly integrated with Excel. However, by 2009, the actual Microsoft Dynamics GP connector for PerformancePoint was also discontinued. Back in 2008, I wrote a stub article about it for an article published by Alan Whitehouse . You can read more ab...

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. 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. 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 ...

"2010 will be a milestone year for Microsoft Dynamics GP..." Microsoft Dynamics GP has a new Nostradamus in MVP Mark Polino . Mark looks into his crystal ball and predicts the fortune of Microsoft Dynamics GP 11, BI, Management Reporter and FRx, and the Microsoft Dynamics GP Community as a whole in his latest MSDynamicsWorld article ... heck, the guy even talks politics! Don't miss out on this great article. Until next post! MG.- Mariano Gomez, MVP Maximum Global Business, LLC http://www.maximumglobalbusiness.com/

Folks, as you may (or may not) know Microsoft SharePoint 2010 is feature-complete with the beta release being shipped in the next coming days. Microsoft Office 2010 beta should be out almost simultaneously -- for my previous posts on Microsoft Office 2010 click here . In addition, you may want to clap for this one: SharePoint 2010 will run on Windows 7 and Windows Vista SP2, at least the developer's version, eliminating the need for tedius virtual machine or virtual PC images for those of us who are developers or consultants trying to demonstrate things like Microsoft Business Portal and Workflow. While most of us don't have beta code yet, it is safe to say you can get a head start on setting up a SharePoint 2010 development environment by reading this MSDN entry . Make sure you observe all the system requirements. Here is what SharePoint Senior Director, Tom Rizzo has to say about the product. http://media.nuveminc.net:8080/spc09/tom_rizzo.wmv You may also visit the SharePoi...

Strategies to gear up for the future My new article is out on MSDynamicsWorld.com! This article focuses on the coming shifts in priorities inside IT departments running Microsoft Dynamics GP. The article is based on some of the strategic initiatives coming out of Redmond and carried around to customers and partners over the last few months. You can read the full article here . Until next post! MG.- Mariano Gomez, MIS, MCP Maximum Global Business, LLC http://www.maximumglobalbusiness.com

For those of you who did not attend Convergence 2009 and have been asking about release dates of service packs and new versions of Dynamics GP, the following shows the anticipated product roadmap . Keep in mind that release dates and product features may change on a dime and by no means can be considered absolute Microsoft commitments. One things is very sure: Microsoft Dynamics GP 10.0 Service Pack 4 is just right around the corner and with it comes a revamped Extender product. For those of you wondering about the feature of the customization tools, David Musgrave has some reflections on that subject. Click here to read what he has to say. Plus I have the following to add: if you are a Microsoft Dexterity developer or a Visual Basic for Applications guy, Extender is still not the panacea for complex business requirements. Yes, you will be able to add new windows, yes you will have the ability to create transaction workflows . However, there is only so much Extender can do as ...

As Microsoft continues to launch products on the Windows SharePoint Services (WSS 3.0) and Microsoft Office SharePoint Services (MOSS 2007) platforms, namely PerformancePoint and Workflow , and as they continue to enhance the integration between Dynamics GP and these applications, I thought it would be important to point out some good SharePoint resources, in particular Paul Andrew's blog . Paul is a Microsoft Technical Product Manager for the SharePoint Developer platform and he has compiled a good Getting Started with SharePoint Development article with tons of links to other resources and a good step-by-step approach on how to become a pro. I started learning about SharePoint development techniques about a month ago as part of a project that I am working on and Paul's article has been vital in providing a roadmap to becoming proficient. In addition, I highly recommend this free Microsoft Learning clinic course: Clinic 5045: Inside Look at Developing with Microsoft® Windo...