GP Power Tools Build 26 & 27 New Features: New in Build 27: Database Tools Module Enhancements
Jul18

GP Power Tools Build 26 & 27 New Features: New in Build 27: Database Tools Module Enhancements

This post is part of the New Features in GP Power Tools Build 27 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The fourth area of new features I’m going to cover, is the Database Tools module in which there is one new feature: SQL Login Maintenance window A new SQL Log… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 27: Developer Tools Module Enhancements
Jul17

GP Power Tools Build 26 & 27 New Features: New in Build 27: Developer Tools Module Enhancements

This post is part of the New Features in GP Power Tools Build 27 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The third area of new features I’m going to cover, is the Developer Tools module in which there are a number of new features: SQL GoTos Triggers against Modal… Continue Reading Ian...

Read More
Excel’s hidden gem: IFERROR
Jul16

Excel’s hidden gem: IFERROR

Today’s #TipTuesday is yet another Excel tip. Can you tell I’ve been working with spreadsheets a lot lately? My blogs tend to follow my work and these last 3 weeks have been no exception. As I run into things or use something I haven’t touched in a while, I tend to blog about it! This tip is about what I believe to be a hidden gem in Excel and that is the IFERROR formula. Over the years, I… Continue Reading Jen...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 27: Administrator Tools Module Enhancements
Jul15

GP Power Tools Build 26 & 27 New Features: New in Build 27: Administrator Tools Module Enhancements

This post is part of the New Features in GP Power Tools Build 27 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The second area of new features I’m going to cover, is the Administrator Tools module in which there are a number of new features: Automatic Launch… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 27: System Module Enhancements
Jul12

GP Power Tools Build 26 & 27 New Features: New in Build 27: System Module Enhancements

This post is part of the New Features in GP Power Tools Build 27 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The first area of new features I’m going to cover, is the System module in which there are a number of new features: Select logs to capture on startup Show user… Continue Reading...

Read More
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
GP Power Tools Build 26 & 27 New Features: New in Build 27: Series Index
Jul11

GP Power Tools Build 26 & 27 New Features: New in Build 27: Series Index

This post is the series index for the New Features in GP Power Tools Build 27 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. In this sub-series I am going to take a look at the new features introduced in build 27; the posts are broken down by module for easy reading. GP… Continue Reading Ian...

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
GP Power Tools Build 26 & 27 New Features: New in Build 26: Database Tools Module Enhancements
Jul10

GP Power Tools Build 26 & 27 New Features: New in Build 26: Database Tools Module Enhancements

This post is part of the New Features in GP Power Tools Build 26 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The fourth area of new features I’m going to cover, is the Database Tools module in which there are a number of new features: New password length Database… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 26: Developer Tools Module Enhancements
Jul09

GP Power Tools Build 26 & 27 New Features: New in Build 26: Developer Tools Module Enhancements

This post is part of the New Features in GP Power Tools Build 26 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The third area of new features I’m going to cover, is the Developer Tools module in which there are a number of new features: Publish Script by Users and/or… Continue Reading Ian...

Read More
Excel VLOOKUP – numbers as text & vice versa
Jul09

Excel VLOOKUP – numbers as text & vice versa

Have you ever tried a VLOOKUP formula in Excel where you’re looking up something that is numeric but stored as text, or vice versa? So annoying, when you seem to have one set of data one way and the lookup in another, right? Today’s #TipTuesday is all about helping you with a couple of formula tweaks to make this a bit easier. Example 1 – Text to Number The first example is a simple… Continue Reading Jen...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 26: Administrator Tools Module Enhancements
Jul08

GP Power Tools Build 26 & 27 New Features: New in Build 26: Administrator Tools Module Enhancements

This post is part of the New Features in GP Power Tools Build 26 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The second area of new features I’m going to cover, is the Administrator Tools module in which there are a number of new features: Control Features by… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 26: System Module Enhancements
Jul05

GP Power Tools Build 26 & 27 New Features: New in Build 26: System Module Enhancements

This post is part of the New Features in GP Power Tools Build 26 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The first area of new features I’m going to cover, is the System module in which there are a number of new features: Window Visibility System Status Report Send… Continue Reading...

Read More
40% discount on Dynamics 365 for Dynamics GP users
Jul04

40% discount on Dynamics 365 for Dynamics GP users

40% discount on Dynamics 365 for Dynamics GP users ” Incremental Group Dynamics GP is one of Microsoft’s ERP solutions for small and medium businesses (SMBs). For existing users of Dynamics GP thinking about when to upgrade, Microsoft is offering an excellent discount if you move to Dynamics 365 Business Central. Microsoft is offering a 40% discount on licences to users of Dynamics GP if you upgrade to Dynamics 365...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 26: Series Index
Jul04

GP Power Tools Build 26 & 27 New Features: New in Build 26: Series Index

This post is the series index for the New in Build 26 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. In this sub-series I am going to take a look at the new features introduced in build 26; the posts are broken down by module for easy reading. GP Power Tools Build 26 & 27… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: Changes Since Last Series
Jul03

GP Power Tools Build 26 & 27 New Features: Changes Since Last Series

This post is part of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. One of the key changes to GP Power Tools, is that it is now directly distributed by WinthropDC rather than by a third party. The third party route was taken, I believe, as a quick way to market after David Musgrave

Read More
GP Power Tools Build 26 & 27 New Features: Series Index
Jul02

GP Power Tools Build 26 & 27 New Features: Series Index

There are a large number of ISV products available to extend Microsoft Dynamics GP, and I’ve taken a look at a very few of them recently. One I looked at last year was the GP Power Tools from Winthrop DC< the company of Microsoft MVP David Musgrave. I took a Hands On look at implementing the GP Power Tools product followed by going hands on with two of the modules: System Module Administrator… Continue Reading Ian...

Read More
Excel tip – “corner” copy
Jul02

Excel tip – “corner” copy

Today’s #TipTuesday post is a little Excel tip. It’s one of those things that I assume most people know it, and then I work wth someone and watch them use Excel and end up teaching it to someone. I call it corner copy but I’m sure there’s some official name! There are 2 parts to this tip really: one is the copy via double clicking on the lower right corner and the bigger tip is the little… Continue...

Read More
MVP Renewal for 2019/2020
Jul01

MVP Renewal for 2019/2020

I’m thrilled to announce that I’ve been renewed as a Microsoft MVP in Business Applications (Dynamics GP focussed) for the next year, through to July 1, 2020. Renewal is never guaranteed and I don’t take it for granted that I will be renewed. In fact, writing this post last year, I wasn’t sure I would make the cut this year at all. What is a Microsoft MVP? During renewal this… Continue Reading Jen...

Read More
PowerShell Snippets: Start-Sleep
Jul01

PowerShell Snippets: Start-Sleep

This post is part of the series on PowerShell Snippets. The following PowerShell command will sleep for the supplied number of milliseconds (replace the highlighted section with the number of milliseconds to sleep): Start-Sleep -Milliseconds {milliseconds} Click to show/hide the PowerShell Snippets Series Index PowerShell Snippets Write-Output Start-Sleep (Visited 5 times, 1 visits… Continue Reading Ian Grieve’s Article on...

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
PowerShell Snippets: Write-Output
Jun28

PowerShell Snippets: Write-Output

This post is part of the series on PowerShell Snippets. The following PowerShell command will output the supplied message to the PowerShell console (replace the highlighted section with the message to output): Write-Output {message] Click to show/hide the PowerShell Snippets Series Index PowerShell Snippets Write-Output Start-Sleep (Visited 8 times, 1 visits today) Continue Reading Ian Grieve’s Article on their blog PowerShell...

Read More
PowerShell Snippets: Series Index
Jun27

PowerShell Snippets: Series Index

From time to time, I write snippets of PowerShell, which I am going to post into this series for easy recall in future. PowerShell Snippets Write-Output Start-Sleep (Visited 16 times, 1 visits today) Continue Reading Ian Grieve’s Article on their blog PowerShell Snippets: Series Index The links in this blog may lead to third-party Web sites to provide access to third-party resources to assist you in finding other services and/or...

Read More
Dynamics GP & Office 365
Jun25

Dynamics GP & Office 365

Today’s #TipTuesday is a post about Office 365 and Dynamics GP and is specific to email functionality such as emailing Purchase Orders, EFT Remittances and Sales Documents. Rest assured that most other functionality other than email seems straight-forward and works no matter what (like exporting from Smartlist). (At least that’s my experience although there may be exceptions I am unware… Continue Reading Jen...

Read More
DAX 101 – Wrap up in Microsoft Power BI
Jun24

DAX 101 – Wrap up in Microsoft Power BI

In this (DAX 101) Video series, I’ve created DAX (Data Analysis eXpression) Columns and Measures. In this final video in DAX 101, I’ll put some of the work together to create some new visuals. DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data. Today’s DAX Expressions: Net Margin = SUM(‘Sales Line Items'[Gross… Continue Reading Belinda Allen’s Article...

Read More
Network Shell Snippets: Delete Bound SSL Certificate
Jun24

Network Shell Snippets: Delete Bound SSL Certificate

This post is part of the series on Network Shell Snippets. The following Network Shell command will delete the bound SSL certificate: netsh http delete sslcert ipport=0.0.0.0:28666 Change the highlighted section to the port number to which the SSL certificate is bound. Click to show/hide the Network Shell Snippets Series Index Network Shell Snippets View URL Reservations Delete URL… Continue Reading Ian Grieve’s Article on...

Read More
Network Shell Snippets: Delete URL Reservation
Jun21

Network Shell Snippets: Delete URL Reservation

This post is part of the series on Network Shell Snippets. The following Network Shell command will delete the specified URL reservations: netsh http delete urlacl URL={reserved url} Replace the highlighted section, including the curly brackets, with the URL reservation to be removed. Click to show/hide the Network Shell Snippets Series Index Network Shell Snippets View URL… Continue Reading Ian Grieve’s Article on their...

Read More
Network Shell Snippets: View URL Reservations
Jun20

Network Shell Snippets: View URL Reservations

This post is part of the series on Network Shell Snippets. The following Network Shell command will list all URL reservations: netsh http show urlacl Click to show/hide the Network Shell Snippets Series Index Network Shell Snippets View URL Reservations Delete URL Reservation Delete Bound SSL Certificate (Visited 9 times, 1 visits today) Continue Reading Ian Grieve’s Article on their blog Network Shell Snippets: View URL...

Read More
Network Shell Snippets: Series Index
Jun19

Network Shell Snippets: Series Index

I have a few Network Shell (netsh) snippets of code which I’ve used recently, which I thought I’d post here. There is nothing complicated in what I am posting, I just need somewhere I can easily locate them again in future. Network Shell Snippets View URL Reservations Delete URL Reservation Delete Bound SSL Certificate (Visited 10 times, 1 visits today) Continue Reading Ian Grieve’s Article on their blog...

Read More
Outlook credentials issue – JenKuntz.ca
Jun19

Outlook credentials issue – JenKuntz.ca

A little while ago, I was trying to add one of my Office 365 email accounts back to Outlook and it wasn’t working. I forgot that I needed an app password because I have MFA (Multi-factor authentication) enabled on my domain/tenant. I initially put in my “regular” password and was expecting it to kick back and let me try again; however, it didn’t do that. Adding an account… Continue Reading Jen Kuntz’s Article on their...

Read More
PowerShell for Hyper-V: Resume VM
Jun18

PowerShell for Hyper-V: Resume VM

This post is part of the series on PowerShell for Hyper-V. The following PowerShell command can be used to resume a suspended virtual machine (replace the highlighted section with the name of your virtual machine): Resume-VM -Name {VM name} Click to show/hide the PowerShell for Hyper-V Series Index PowerShell for Hyper-V Avoid Error Running PowerShell Scripts Start VM Shut Down VM

Read More
Using DAX Measures across multiple Queries in Microsoft Power BI
Jun17

Using DAX Measures across multiple Queries in Microsoft Power BI

  In this Video, I’ll create a DAX (Data Analysis eXpression) Measure.  This measure creates the Salesperson Commission amount.  To achieve this, I’ll have to multiply two fields together that reside in different queries. DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data. Today’s DAX Expression: Commission :=… Continue Reading Belinda Allen’s Article...

Read More
No Canadian Payroll 2019 Mid-Year Tax Update! – JenKuntz.ca
Jun11

No Canadian Payroll 2019 Mid-Year Tax Update! – JenKuntz.ca

There’s no #TipTuesday today since I had website issues over the weekend and was unable to access it to prepare something. So, this will be a form of a tip in lieu of another topic! There will be no mid-year tax update for Canadian Payroll for Dynamics GP this year, zippo, nada, zilch! Imagine that, not a single jurisdiction has a tax change this mid-year. That’s got to be a… Continue Reading Jen Kuntz’s Article on their...

Read More
Using DAX Measures that Counts the number of Invoices in Microsoft Power BI
Jun10

Using DAX Measures that Counts the number of Invoices in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) Measure.  This measure will be used to count the number of Invoices.  The same measure will show the number of invoices for each Customer and the numbers of invoices for which each item appears. DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data. Today’s DAX… Continue Reading Belinda Allen’s Article...

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
Making Tooltips easier to read in Microsoft Power BI
Jun07

Making Tooltips easier to read in Microsoft Power BI

In this video, I’ll show you how to format Tooltips in a Microsoft Power BI visual to make them easier on the eyes.  The default of white letters on a black background can be difficult to read.  This 2-minute video will show you simple changes that make tooltips more powerful!

Read More
‘The requested operation could not be completed due to a file system limitation’ – azurecurve
Jun06

‘The requested operation could not be completed due to a file system limitation’ – azurecurve

When I joined ISC Software I received a new laptop which was pretty much a blank slate except for Windows itself. This meant that I had to install and configure everything I needed (I prefer this as it means I can configure everything exactly as I want it). Due to having an SSD, instead of an HDD, in the laptop, I also got an external SSD which I am using for hosting my virtual machines… Continue Reading Ian Grieve’s...

Read More
PowerShell to Promote Domain Controller – azurecurve
Jun05

PowerShell to Promote Domain Controller – azurecurve

When testing Microsoft Dynamics GP, I often need a domain controller within my set of virtual machines. I’ve been promoting a server to be a domain controller manually, but it recently occurred to me that I could probably do the same task using PowerShell. After doing some research, I came up with four commands which will rename and restart the server, install the Active Directory… Continue Reading Ian Grieve’s Article on...

Read More
Back to consulting! – JenKuntz.ca
Jun05

Back to consulting! – JenKuntz.ca

There’s an expression “you can take the girl out of consulting but you can’t take the consulting out of the girl”. OK, so that’s not really how that goes, but it fits the situation! As of June 1st (2019), I’m resuming my consulting business – Kuntz Consulting Inc. – and am back to being a Microsoft partner and independent consultant. This is so new that I haven’t even… Continue Reading Jen Kuntz’s Article on their...

Read More
Are you using what you’ve purchased? – JenKuntz.ca
Jun05

Are you using what you’ve purchased? – JenKuntz.ca

Today’s #TipTuesday isn’t a technical tip, it’s more of a business tip. I’ve written this to be specific to Dynamics GP, although what I describe may apply to other applications and software licensing. I have not worked with licensing on any other ERP packages to know if this might be a general rule of thumb or not. If you’ve been using Dynamics GP for any length of time, it… Continue Reading Jen Kuntz’s Article on their...

Read More
SQL Stored Procedure to Generate Sequential Number – azurecurve
Jun04

SQL Stored Procedure to Generate Sequential Number – azurecurve

While much of the work I do is directly with Microsoft Dynamics GP, I also do work for clients which isn’t directly related. I’ve created code to generate numbers a few times in the past and figured I might as well post the base code I use for this to make it easier to find in future. I’ve created it in such a way that several unique numbers can be stored and incremented. The first… Continue Reading Ian Grieve’s Article on...

Read More
Using DAX Measures that calculate by row rather than a summary, in Microsoft Power BI
Jun03

Using DAX Measures that calculate by row rather than a summary, in Microsoft Power BI

  In this Video, I’ll create a DAX (Data Analysis eXpression) Measure.  This measure will be used to calculate the total sales price.  Check out this video to see how to create a measure that performs “Aggregation with Iteration”; which is a fancy way of saying DAX needs to calculate the total sales price for each row, then sum it together.  Look at the two examples below and… Continue Reading Belinda Allen’s Article...

Read More
Add Company Access Back to sa User – azurecurve
Jun03

Add Company Access Back to sa User – azurecurve

We’re busy doing some work for a client for whom we’ve recently taken over the support of their Microsoft Dynamics GP implementation. For the initial set of projects, we’re assisting them in the creation of a standalone test systemm. When you do this, the first thing you need to do is log in using the sa account and reset passwords. However, we found that at some point in the past,… Continue Reading Ian Grieve’s Article on...

Read More
Prepare New SD Card For Raspberry Pi OS: Conclusion – azurecurve
Jun01

Prepare New SD Card For Raspberry Pi OS: Conclusion – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Copy Files To The SD Card – azurecurve
May31

Copy Files To The SD Card – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Creating a Conditional Title with DAX in Microsoft Power BI
May31

Creating a Conditional Title with DAX in Microsoft Power BI

In this Video, I’ll use DAX to make a visual Title be conditional based on a selection in a filter, using Microsoft Power BI.

Read More
Find SQL Function In All Databases – azurecurve
May31

Find SQL Function In All Databases – azurecurve

I did a few posts back in 2016 on finding objects in SQL (a column in all tables, =’https://www.azurecurve.co.uk/2016/02/find-all-custom-sql-objects-in-database/’>all custom sql objects in a database and trigger in all databases). I needed to find if a function existed in all databases, so I produced the following script which searches in all Microsoft Dynamics GP databases: — drop… Continue Reading Ian...

Read More
Prepare New SD Card For Raspberry Pi OS: Download NOOBS – azurecurve
May30

Prepare New SD Card For Raspberry Pi OS: Download NOOBS – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Is there a POP Historical Received Not Invoiced Report Available? – azurecurve
May30

Is there a POP Historical Received Not Invoiced Report Available? – azurecurve

I’ve had a couple of people recently ask if it is possible to get a historical version of the Shipments Received but not invoiced* SmartList favourite (located under . Within SmartList, this is not possible as the point-in-time calculations required for a historical report are too complex for a SmartList, even one driven by a view. While historically this report wasn’t available in… Continue Reading Ian Grieve’s Article on...

Read More
Format SD Card – azurecurve
May29

Format SD Card – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More