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

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
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
The Dynamics GP Blogster: #FabrikamDay: the holiday that wasn’t
Apr13
Read More