Developing PowerApps and Flow apps with Azure Cognitive Services’ Computer Vision
Jul11

Developing PowerApps and Flow apps with Azure Cognitive Services’ Computer Vision

This is a session I presented at the recent Azure Virtual Day Camp, hosted by Dynamic Communities’ D365UG, on June 26, 2019.In this presentation I show how to leverage Azure Cognitive Services’ Computer Vision service with PowerApps and Flow to build a badge scanner. In addition, I show how to use some simple, but powerful PowerApps and Flow functions to do string and image manipulation.  <br… Continue...

Read More
#PowerApps – A look at the new JSON() serializer function
Jul10

#PowerApps – A look at the new JSON() serializer function

In this video I take a look at the newly released JSON() serialization function and how it can be used to serialize an image, added to PowerApps in the month of June. You can read the full details on the PowerApps Blog article, JSON for canvas apps. Also, take a look at the video created by PowerApps MVP, April Dunham on the subject, along with her intro to AI Builder.Until next post!MG.-<br… Continue Reading Mariano...

Read More
#PowerApps #PowerBI: Cash flow in Power BI and PowerApps – THR1014
Jun29

#PowerApps #PowerBI: Cash flow in Power BI and PowerApps – THR1014

This past Microsoft Business Applications Summit 2019 – Atlanta, I teamed up with fellow Microsoft MVP, Belinda Allen to deliver a 20 minutes theater session showing how to build a cash flow in Power BI, then use Microsoft Flow to get notifications based on specific conditions in the report, and embedding the cash change calendar as a tile in a PowerApps application.We had a lot of fun putting… Continue Reading Mariano...

Read More
The Dynamics GP Blogster: #PowerApps: Componentizing Google Maps
Jun09

The Dynamics GP Blogster: #PowerApps: Componentizing Google Maps

Hi PowerAppers!PowerApps Canvas Apps Components remain one of those features that seem to have endless possibilities. I have, for quite some time now, been working with the Google Maps API in many of my applications to return a static image pointing to a specific location on the map.As I moved from application to application, I noticed that I always ended up doing the same operations: format… Continue Reading Mariano...

Read More
#MSDYN365BC: Building a Development Environment for Microsoft Dynamics GP ISVs – Selecting a Source Control Provider
May29

#MSDYN365BC: Building a Development Environment for Microsoft Dynamics GP ISVs – Selecting a Source Control Provider

So far, I have covered the process of setting up both the Microsoft Dynamics 365 BC containerized application components, along with the VS Code IDE and AL language extensions. We also built the “Hello World” extension on BC’s Customer List page and deployed it to our container by following some simple debugging steps. You can read more about it in the following articles:#MSDYN365BC: Building… Continue Reading...

Read More
The Dynamics GP Blogster: #MSDYN365BC: Building a Development Environment for Microsoft Dynamics GP ISVs
Apr30

The Dynamics GP Blogster: #MSDYN365BC: Building a Development Environment for Microsoft Dynamics GP ISVs

In the previous 3 articles of the series, I talked about the rationale for selecting a container based environment for development purposes, we also installed Docker and downloaded and installed the Microsoft Dynamics 365 Business Central containers for Docker. This then set us on a path to installing the development IDE and selecting a source code control provider to host our AL… Continue Reading Mariano Gomez’s Article...

Read More
Building a Development Environment for Microsoft Dynamics GP ISVs Part 3/3
Apr19

Building a Development Environment for Microsoft Dynamics GP ISVs Part 3/3

In Part 2 of this series, we covered the full installation of Docker Desktop, used to run the Dynamics 365 Business Central containers. We also saw how to use PowerShell to enable both the Hyper-V and Containers features on Windows 10.This article will focus on the installation and troubleshooting of the Dynamics 365 Business Central containers and will provide step by step instructions on… Continue Reading Mariano Gomez’s...

Read More
Building a Development Environment for Microsoft Dynamics GP ISVs Part 2/3
Apr13

Building a Development Environment for Microsoft Dynamics GP ISVs Part 2/3

In Part 1 of this series, I outlined the principles and detailed the reasoning behind why we chose to build our Microsoft Dynamics 365 Business Central development environment using Windows Docker containers. In the Dynamics GP world, we are not quite used to containers, so let me start with the definition, straight from the horse’s mouth (so to speak). According to the wizards over at… Continue Reading Mariano...

Read More
Building a Development Environment for Microsoft Dynamics GP ISVs Part 1/3
Apr10

Building a Development Environment for Microsoft Dynamics GP ISVs Part 1/3

This is my first foray into the world of Microsoft Dynamics 365 Business Central (BC) development and this series of articles is meant to help Microsoft Dynamics GP ISVs understand the process of building a BC development environment, identify similarities with a Dynamics GP development environment, and fully utilize your accumulated experience. Yes, there’s tons of literature out there, but… Continue Reading Mariano...

Read More
“Database must be compatibility level 130 or higher for replication to function” when setting up #MSDYN365BC Intelligent Cloud sync
Apr04

“Database must be compatibility level 130 or higher for replication to function” when setting up #MSDYN365BC Intelligent Cloud sync

As of recent, I’ve been honing on my Microsoft Dynamics 365 Business Central (BC) skills, without leaving my beloved Microsoft Dynamics GP behind. One of the things that I have been working on is making sure customers understand the BI insights gained via data replication between the two systems. As a result, I am always working through the replication configuration a few times a… Continue Reading Mariano Gomez’s...

Read More
Numeric Up/Down control with persisted button press event using components
Mar26

Numeric Up/Down control with persisted button press event using components

I just recently returned from the Microsoft MVP Global Summit 2019 where I had a chance to meet some of the top minds in the Microsoft PowerApps and Flow space. This was a truly exciting moment as I have been learning from the very same MVPs I met – yes, we do learn from each other!In one of my hallway discussions, I ran into my buddy Mehdi Slaoui Adaloussi, Principal Program Manager at… Continue Reading Mariano...

Read More
Named Printers and Redirected Printers in RDP environments
Mar07

Named Printers and Redirected Printers in RDP environments

A lot of the guiding principles for deploying Named Printers in a Terminal Server or Citrix environment comes from two of my favorite articles, written by my good friend and fellow Microsoft Business Applications MVP, David Musgrave (twitter: @winthropdc). David happens to be the creator of Named Printers and probably understands the product better than anyone I know. You can read his… Continue Reading Mariano Gomez’s...

Read More
#PowerApps: Using Components to create a Digital Clock – Part 2
Mar05

#PowerApps: Using Components to create a Digital Clock – Part 2

In Part 1 of this series, you saw how my first version of the digital clock went. Although it got the job done, it was plagued with repetitive code, repetitive controls, and over saturation of variables, which in turn rendered the application hard to follow, and worse yet, affected performance.In this article, I will show how to use PowerApps Components to promote reusability and decrease the… Continue Reading Mariano...

Read More
The Dynamics GP Blogster: #PowerApps: Using Components to create a Digital Clock
Mar04

The Dynamics GP Blogster: #PowerApps: Using Components to create a Digital Clock

Building a Digital Clock the traditional wayWhen I first set out to build a digital clock with night mode, I figured I was just going to start from what I know. Each digit of the clock is composed for 7 segments and each segment would behaves in a binary way based on the number that it needs to display. To create each segment, I would use a Rectangle from the Icons gallery. Since I initially… Continue Reading Mariano...

Read More
Simple Object Proximity and Collision Detection
Feb14

Simple Object Proximity and Collision Detection

As of late, I have been very interested in all things “Motion” as it relates to developing PowerApps applications – see #PowerApps: Motion Patterns with Parametric Equations. Although, most of the apps you will see tend to be around solving business problems, you cannot really dismiss the capabilities of PowerApps as a gaming platform. The Basics In this article, I explore a simple… Continue Reading Mariano...

Read More
Motion Patterns with Parametric Equations
Feb11

Motion Patterns with Parametric Equations

As of late, I have been experimenting with motion in Microsoft PowerApps. This has actually helped me to revisit different mathematical models describing the motion of objects throw a two-dimensional space. As a result, I have created this video explaining how to create the following motion patterns: You can download the msapp file from the PowerApps Community Apps Gallery here.Until next… Continue Reading Mariano Gomez’s...

Read More
Analyzing expense receipts with Azure Cognitive Services and Microsoft Flow
Nov04

Analyzing expense receipts with Azure Cognitive Services and Microsoft Flow

Recently, Business Applications MVP Steve Endow and I delivered a session at the User Group Summits in Phoenix, and in particular, to the GPUG Summit titled, “Microsoft Dynamics GP and Azure Services”. In this course we detailed a number of Azure Services (among the hundreds) that could potentially be used with Microsoft Dynamics GP.Being that I have also been working my way through… Continue Reading Mariano...

Read More
Installing the Microsoft Azure Integration Runtime
Oct19

Installing the Microsoft Azure Integration Runtime

The Integration Runtime (IR) is a customer managed data integration infrastructure used by Azure Data Factory to provide data integration capabilities across different network environments. It was formerly called as Data Management Gateway. It is used by Business Central and Dynamics GP to provide a one-way data synchronization between your on-premises SQL Server hosting your company… Continue Reading Mariano Gomez’s...

Read More
Provisioning a Microsoft Dynamics 365 Business Central demo tenant
Oct08

Provisioning a Microsoft Dynamics 365 Business Central demo tenant

With the release of Microsoft Dynamics GP 2018 R2, I had a first look at the update process, then quickly ran into a situation where the option to set up intelligent cloud insights wasn’t showing in my already provisioned Microsoft Dynamics 365 Business Central tenant – See, “Set up Intelligent Cloud” option not showing for Microsoft Dynamics 365 Business Central tenants.I also noted that… Continue...

Read More
“Set up Intelligent Cloud” option not showing for Microsoft Dynamics 365 Business Central tenants
Oct03

“Set up Intelligent Cloud” option not showing for Microsoft Dynamics 365 Business Central tenants

I was (still am!) seriously excited about the release of Microsoft Dynamics GP 2018 R2 – I mean, how can you not? This Intelligent Cloud thing is just superb! The simple premise of being able to sync your data to Microsoft Dynamics 365 Business Central and use the power of the cloud to get actionable insights is just too good to pass up on.See my article, Microsoft Dynamics 365 Business… Continue Reading Mariano...

Read More
The Dynamics GP Blogster: Updating to Microsoft Dynamics GP 2018 R2
Oct03

The Dynamics GP Blogster: Updating to Microsoft Dynamics GP 2018 R2

Yesterday marked the release of Microsoft Dynamics GP 2018 R2 to the English speaking market – other languages soon to follow. After a few hiccups in the download process (make sure you clear your browser cache before attempting to download), I was able to get my hands on the 1.81 GB zip file containing the actual installation media (1.92 GB unzipped).Since this is not a major release, I went… Continue Reading Mariano...

Read More

The Dynamics GP Blogster: Calling SQL Server stored procedures from Microsoft Dexterity

Back in January of 2009, I wrote an article showing a method of calling a SQL Server stored procedure from Dexterity by calling a stored procedure prototype script (sproc) in sanScript.See, Calling SQL Server stored procedures from Microsoft Dexterity (January 26, 2009).This sproc tells the runtime engine (Dynamics.exe) that it must connect to either the system or company database to run… Continue Reading Mariano Gomez’s...

Read More
Missing Dexterity Shared Components cause Word Templates processing to hang
Jul27

Missing Dexterity Shared Components cause Word Templates processing to hang

Working recently on an issue, I ran into a situation where I would get the following template processing error attempting to print a SOP Invoice – if you look at the bottom status bar, next to the user ID, you will see a Template Processing accompanied by a yellow warning triangle. Upon inspecting the Template Processing status, I ran into the following Exception Detail message:The… Continue Reading Mariano Gomez’s...

Read More
the perfect complement for Microsoft Dynamics GP users
Jul25

the perfect complement for Microsoft Dynamics GP users

Microsoft Dynamics GP users rejoice!If you were a part of the long list of users, partners, and ISVs scared by some imaginary deadline set (by Microsoft) for you to migrate from Dynamics GP and onto Dynamics 365 Business Central, it’s now my pleasure to separate fact from fiction in this era of, well, fake news – at least in the Dynamics space.Microsoft has recently published the October ’18… Continue Reading...

Read More
Microsoft Dynamics GP July Hotfix packed with some long awaited features
Jul24

Microsoft Dynamics GP July Hotfix packed with some long awaited features

If you missed it, the Microsoft Dynamics GP Development team has delivered the July Hotfix for versions 2015, 2016, and 2018. What has me really excited are a number of features that were included in this release – I will skip the bug fixes as those are always welcome – as follow:Support for TWAIN driversWhy is this important? TWAIN is an API and a communications protocol that regulates… Continue Reading Mariano...

Read More
Installing Visual Studio Tools for Microsoft Dynamics GP project templates for Visual Studio 2017
Jun06
Read More
GPUG Amplify South Africa 2018 – Wrap Up
Jun06

GPUG Amplify South Africa 2018 – Wrap Up

GPUG Amplify South Africa is been over for a bit over a week, yet there’s still sense of a conference with a lot potential and room for growth. For some background, I helped organize the preceding event, reIgnite GP 2017 and was a part of the keynote speech delivered last year. In addition, I delivered 6 sessions around various Microsoft Dynamics GP topics, but primarily my focus was on… Continue Reading Mariano...

Read More
GPUG Amplify South Africa 2018 – Post Conference
Jun01

GPUG Amplify South Africa 2018 – Post Conference

Wednesday, May 23, 2018After a long couple days, and especially after Day 2 presentation marathon, I decided to sleep in a bit this morning. I had a commitment at midday to meet with the Premier team. Premier has sponsored my trips to South Africa over the last two years, which has allowed me to participate in both reIgnite GP and GPUG Amplify South Africa conferences, so I wanted to take the… Continue Reading Mariano...

Read More
The Dynamics GP Blogster: GPUG Amplify South Africa 2018
May21
Read More
GPUG Amplify South Africa 2018
May14
Read More
The Dynamics GP Blogster: Deploying Microsoft Dynamics GP on an Azure SQL Managed Instance
Apr28
Read More
Microsoft Dynamics GP is not in “Maintenance Mode”
Mar26
Read More
The Dynamics GP Blogster: Microsoft Dynamics GP: Running System and Company Databases on Azure SQL
Feb26
Read More
How to Manually Replace the Web Client SSL Certificates
Feb09
Read More
Microsoft Dynamics GP and TLS 1.0
Jan26
Read More
The Dynamics GP Blogster: Microsoft Dynamics GP 2018 installation
Dec09
Read More
The Dynamics GP Blogster: Building Microsoft Dexterity Cross-Dictionary Applications with GP Power Tools
Nov28
Read More
The Dynamics GP Blogster: Retrieving dictionary build numbers outside of Dynamics GP
Nov24
Read More
Unhandled database exception Save operation on table ‘ASI_SOP_HDR_MSTR_Explorer” has caused an unknown error (39)
Nov22
Read More
Copying Quick Links from one Microsoft Dynamics GP user to another
Nov21
Read More
The Dynamics GP Blogster: Duplicating a Microsoft Dexterity window on the same form
Nov07
Read More
Read More
The Dynamics GP Blogster: #DevOps Series: Building Dexterity Applications with Visual Studio Team Services
Sep26
Read More
Building Dexterity Applications with Visual Studio Team Services Part 3/3
Sep26
Read More
Building Dexterity Applications with Visual Studio Team Services Part 2/3
Aug17
Read More
Building Dexterity Applications with Visual Studio Team Services Part 1/3
Aug01
Read More
The Dynamics GP Blogster: #DevOps Series: Upgrading Microsoft Dexterity VSS and TFS repositories to Visual Studio Team Services
Jul19
Read More
Microsoft Dexterity Source Code Control with Visual Studio Team Services
Jul17
Read More
Customizing Safe Pay file name
Jul14
Read More
Read More