hMailServer: Connect Outlook 2019 Professional
Aug05

hMailServer: Connect Outlook 2019 Professional

Way back in 2015 I did a series on using hMailServer in virtual machine demo environments as a lighter alternative to Exchange. The last post in that series was on connecting Outlook to hMailServer. I am still using hMailServer, but the new version of Outlook, 2019, has changed the process of connecting. In this post, I’m going to run through connecting Outlook 2019 Professional to… Continue Reading Ian Grieve’s...

Read More
Inventory Reconcile Cannot Be Run While Users Are Posting Invoices
Aug02

Inventory Reconcile Cannot Be Run While Users Are Posting Invoices

If you try to run the Inventory Reconcile utility ((Inventory area page » Utilities » Reconcile)) when users are posting invoices, the following error message will be displayed (the same message will be displayed during a Year-End Close): You cannot complete this process while invoices are being posted If users are not posting invoices, this KB article shows all of the tables which need to… Continue Reading Ian...

Read More
Implementing Node Builder: Conclusion
Aug01

Implementing Node Builder: Conclusion

This post is part of the series on Implementing Node Builder; Node Builder is a product which allows additional eConnect nodes to be easily created for use with SmartConnect. I was somewhat surprised that the most recent version available was the 2011 version; I think this shows that Node Builder is not a very popular product, but I am slightly surprised by this as SmartConnect seems to be a… Continue Reading Ian Grieve’s...

Read More
Implementing Node Builder: Connection Issue
Jul31

Implementing Node Builder: Connection Issue

This post is part of the series on Implementing Node Builder; in particular I m creating a node to add EFT Bank information when adding a creditor. The first time I installed Node Builder I received an error when trying to log in: Connection Failed A connection error occurred while trying to connect o the Node Builder database. Check the server settings to ensure Node Builder is pointing to… Continue Reading Ian Grieve’s...

Read More
Form Processing with PowerApps AI Builder
Jul30

Form Processing with PowerApps AI Builder

In this video I explore the recently released AI Builder Form Processing component, by creating and training a utilities billing model. I also show how to build a real life PowerApps application to take advantage of the utility billing model and some elements and considerations while doing so. You can find more information on AI Builder here:<a… Continue Reading Mariano Gomez’s Article on their blog Form Processing with...

Read More
Implementing Node Builder: Registration
Jul30

Implementing Node Builder: Registration

This post is part of the series on Implementing Node Builder; Node Builder is a product which allows additional eConnect nodes to be easily created for use with SmartConnect. With Node Builder installed we can now launch and register it. Node Builder will be available via the Windows Start menu. When launched, you will be prompted to enter the SQL Server and a user account to connect with;… Continue Reading Ian Grieve’s...

Read More
Implementing Node Builder: Installation
Jul29

Implementing Node Builder: Installation

This post is part of the series on Implementing Node Builder; Node Builder is a product which allows additional eConnect nodes to be easily created for use with SmartConnect. With Node Builder downloaded, we can now start the implementation. The download is a zip file containing NodeBuilder.exe. Extract and run this file. On the Welcome step, click Next: The Choose a file location step allows… Continue Reading Ian Grieve’s...

Read More
Implementing Node Builder: Downloading
Jul26

Implementing Node Builder: Downloading

This post is part of the series on Implementing Node Builder; Node Builder is a product which allows additional eConnect nodes to be easily created for use with SmartConnect. Node Builder can be downloaded from the eOne Solutions website; there is no requirement to leave your email address when downloading: Click to show/hide the Implementing Node Builder Series Index Implementing Node… Continue Reading Ian Grieve’s...

Read More
Implementing Node Builder: System Requirements
Jul25

Implementing Node Builder: System Requirements

This post is part of the series on Implementing Node Builder; Node Builder is a product which allows additional eConnect nodes to be easily created for use with SmartConnect. The version of Node Builder available to download, is Node Builder 2011. Neither the online nor downloadable manual specify any system requirements other than Microsoft Dynamics GP. It’s important to note that Node… Continue Reading Ian Grieve’s...

Read More
Implementing Node Builder: What is Node Builder?
Jul24

Implementing Node Builder: What is Node Builder?

This post is part of the series on Implementing Node Builder. Node Builder is a complimentary product to the SmartConnect integration tool (which I blogged about a few months ago); SmartConnect works by providing an integration layer on top of eConnect which allows non-developers to create integrations for Microsoft Dynamics GP; Node Builder allows these same non-developers to create… Continue Reading Ian Grieve’s Article...

Read More
Power Platform – Did you know? Mobile Apps
Jul23

Power Platform – Did you know? Mobile Apps

This video explores some basic capabilities available with the PowerApps, Microsoft Flow, and Power BI mobile applications.  Here I only highlight 3 of those capabilities:1. Pinning PowerApps applications to the device home screen and marking an application as favorite2. Create a Flow workflow from a template or from blank3. Annotating a Power BI dashboards and tiles for easy follow up Until… Continue Reading Mariano...

Read More
Excel Navigation tips
Jul23

Excel Navigation tips

Today’s #TipTuesday is yet another Excel tip. This one is about navigation, and some tips around things I use every day when I’m working in Excel. Some of these are particularly useful if you are using Excel to get a set of data ready for an integration, which often is the world I’m living in. Sometimes I’ve integrating right from Excel and sometimes I’m working with something where… Continue Reading Jen Kuntz’s Article on...

Read More
Implementing Node Builder: Series Index
Jul23

Implementing Node Builder: Series Index

Earlier this year I did a series of posts on the SmartConnect integration solution from eOne Solutions; I then followed up with a post on creating a simple General Journal integration. In this series of posts I am going to take a look at the Node Builder product which allows you to easily create additional nodes for integration. If you’re reading this on azurecurve, the series index, below,… Continue Reading Ian...

Read More
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
PowerShell for Hyper-V: Suspend VM
Jun17

PowerShell for Hyper-V: Suspend VM

This post is part of the series on PowerShell for Hyper-V. The following PowerShell command can be used to suspend (pause) a virtual machine (replace the highlighted section with the name of your virtual machine): Suspend-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
Edge Canary: Dark Mode
Jun14

Edge Canary: Dark Mode

Microsoft have recently announced they are ditching the current version of their Edge browser in favour of a Chromium based browser. In this series, I am going to take a look at the Canary version of this new browser. Microsoft have been adding dark modes to other applications and websites, but have unfortunately not done so with the new Edge. At the least I’d expect it to respect the Windows… Continue Reading Ian...

Read More
PowerShell for Hyper-V: Save VM
Jun14

PowerShell for Hyper-V: Save VM

This post is part of the series on PowerShell for Hyper-V. The following PowerShell command can be used to save a virtual machine (replace the highlighted section with the name of your virtual machine): Save-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 Save...

Read More
Edge Canary: Add Extension From Chrome Play Store
Jun13

Edge Canary: Add Extension From Chrome Play Store

Microsoft have recently announced they are ditching the current version of their Edge browser in favour of a Chromium based browser. In this series, I am going to take a look at the Canary version of this new browser. As mentioned in the last post, Microsoft have their own store for extensions, but Edge also supports the installation of extensions direct from the Google Play Store. When in the… Continue Reading Ian...

Read More
PowerShell for Hyper-V: Shut Down VM
Jun13

PowerShell for Hyper-V: Shut Down VM

This post is part of the series on PowerShell for Hyper-V. The following PowerShell command can be used to shut down a virtual machine (replace the highlighted section with the name of your virtual machine): Stop-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 Save...

Read More