Hands on with the Microsoft Dynamics GP Fall 2020 Release: Create new company
This post is part of the Hands on with the Microsoft Dynamics GP Fall 2020 Release series where I am hands on with the newly released Microsoft Dynamics GP Fall 2020 Release. To create a new company, launch ,em>Gp Utilities and log in using the sa account: On the Welcome stage, click Next: Click Next to run the version check: Set the drop down list to Create a company and click Process: < div class=”azrcrv-im”...
Hands on with the Microsoft Dynamics GP Fall 2020 Release: Add sample company
This post is part of the Hands on with the Microsoft Dynamics GP Fall 2020 Release series where I am hands on with the newly released Microsoft Dynamics GP Fall 2020 Release. To add the sample company, launch GP Utilities and log in using the sa account: On the Welcome step, click Next: Click Next to start the version check: On the Additional Tasks make sure the drop down list is set to Add… Continue Reading Ian Grieve’s...
Hands on with the Microsoft Dynamics GP Fall 2020 Release: Deploy system database
This post is part of the Hands on with the Microsoft Dynamics GP Fall 2020 Release series where I am hands on with the newly released Microsoft Dynamics GP Fall 2020 Release. With the client installed, the next step is to deploy the system database. Do this by launching GP Utilities from the Windows Start menu and log in using the sa account: Click Next on the Welcome step: Select the… Continue Reading Ian Grieve’s Article...
Power Platform: Application Lifecycle Management (Part 3/3) – Build and Release Pipelines
Welcome to the final episode of Power Platform Application Lifecycle Management. In parts 1 and 2 you saw how to prepare your environments, set up an Azure DevOps project, and define Service Connections to your Power Platform environments. In this, the final installment of this 3-part series, you will learn how to create the Build and Release pipelines using the Power Platform Build Tools to… Continue Reading Mariano...
Hands on with the Microsoft Dynamics GP Fall 2020 Release: Install client
This post is part of the Hands on with the Microsoft Dynamics GP Fall 2020 Release series where I am hands on with the newly released Microsoft Dynamics GP Fall 2020 Release. One you have the media downloaded and the .NET Framework 3.5 installed, we can now install the first client. Do this by extracting the download media and running the setup.exe. This will launch the Microsoft Dynamics GP… Continue Reading Ian Grieve’s...
Hands on with the Microsoft Dynamics GP Fall 2020 Release: Install .NET prerequisite
This post is part of the Hands on with the Microsoft Dynamics GP Fall 2020 Release series where I am hands on with the newly released Microsoft Dynamics GP Fall 2020 Release. Before installing any of the Microsoft Dynamics GP components, you need to make sure the system requirements are met. On top of this there is also some prerequisites which need to be met before the Microsoft Dynamics GP… Continue Reading Ian Grieve’s...
ClassicPress plugins from azurecurve
I created this blog in June 2011 with WordPress and for a couple of years I used plugins created by other people. However, as I started looking for more advanced functionality, I found that there were either no plugins which did what I wanted or, at best, did most of what I wanted, but not everything or things I didn’t like. I’d worked in PHP previously (including writing my own MVC… Continue Reading Ian...
Hands on with the Microsoft Dynamics GP Fall 2020 Release: Download
This post is part of the Hands on with the Microsoft Dynamics GP Fall 2020 Release series where I am hands on with the newly released Microsoft Dynamics GP Fall 2020 Release. The full installation media for the 2020 Release of Microsoft Dynamics GP can be downloaded from here and the service pack release here . In this series, I will be using the full installation download as I will be doing… Continue Reading Ian Grieve’s...
Microsoft Dynamics GP Compatibility page updated for Fall 2020 release
I created a GP Compatibility page a while ago to show the compatibility of Microsoft Dynamics GP with the various versions of SQL Server, Windows Server and Windows as a quick reference. I’ve updated it now for the Microsoft Dynamics GP Fall 2002 Release, based on the system requirements documents. The page is accessible from the GP Resources menu along with a number of other pages or external… Continue Reading Ian...
Hands on with the Microsoft Dynamics GP Fall 2020 Release: System Requirements
This post is part of the Hands on with the Microsoft Dynamics GP Fall 2020 Release series where I am hands on with the newly released Microsoft Dynamics GP Fall 2020 Release. There are not many changes to the system requirements for the Microsoft Dynamics GP 2010 Release are not much, if any, different from the prior release; the system requirements for Dynamics GP and the Web Components can be… Continue Reading Ian...
Hands on with the Microsoft Dynamics GP Fall 2020 Release: Series Index
With Microsoft Dynamics GP Fall 2020 Release now available for download, I am going to go hands on and install this new version of the core product and a few of the addons and applications from Microsoft. The below series index will automatically update here on azurecurve|Ramblings of a Dynamics GP Consultant as posts are published; if you’re reading elsewhere, check back to this series index… Continue Reading Ian...
Microsoft Dynamics GP Fall 2020 Release fixes recent Word template issue
A recent update to Microsoft Office broke the Word templates produced from Dynamics GP for both workflow notification/action emails and emailing of Word template documents (such as remittances, orders, invoices and so on). A few days after Microsoft shared details of the problem, they said a fix would be forthcoming and it is included in the 2020 Release. This does mean that if you are on any… Continue Reading Ian Grieve’s...
Microsoft Dynamics GP Fall 2020 Release is now available
Towards the end of last week, on the Dynamics GP Support and Services Blog announced the release of the Microsoft Dynamics GP Fall 2020 Release. You can download the full product or service pack depending on how you plan to install/upgrade Dynamics GP. If you’re doing an upgrade, there is also an upgrade blog series which runs through the important issues to consider when doing an… Continue Reading Ian Grieve’s...
PowerShell Snippets: Output list of folders and sub-folders
This post is part of the series on PowerShell Snippets. The following PowerShell command will export a list of folders and sub-folders from the specified location (the first highlighted section is the starting folder and the second the output path for the CS file): Get-ChildItem -Path \nas3publicmovies -Recurse -Directory -ErrorAction SilentlyContinue | Select-Object FullName | Export-CSV
Importing data from a CSV Download into Microsoft Power BI
What if your Microsoft Power BI report needs to access data from a website, but the only option is a CSV download? In this tiny tip, Belinda will show you how to make a CSV download act like an API. < div class=”wp-block-embed__wrapper”> <div… Continue Reading Belinda Allen’s Article on their blog Importing data from a CSV Download into Microsoft Power BI What if your Microsoft Power BI report needs to...
Bulk watermark images
A couple of days ago, I posted about a website which allowed you to bulk resize images; that site has a sister site which allows images to be watermarked in bulk. The Batch Watermark; you are able to use an image or text as the watermark and it will be applied to all of the uploaded photos: I am not a huge fan of watermarking images, but lots of people will use any photo posted online as if… Continue Reading Ian Grieve’s...
More SEC Football data modeling in Microsoft Power BI Query Editor
In this tiny tip, I show you more Data Modeling I performed on my US College (American) Football South Eastern Conference (SEC) Microsoft Power BI Report. I show how I incorporate parameters with my data and I create a custom title for my report. < div class=”wp-block-embed__wrapper”> <div… Continue Reading Belinda Allen’s Article on their blog More SEC Football data modeling in Microsoft Power BI Query...
Creating a Custom Table in the Microsoft Power BI Query Editor
As I continue building a Microsoft Power BI report that will display the stats for the US College (American) Football South Eastern Conference (SEC); I will show you how I created a custom static table of the 14 teams in the SEC. < div class=”wp-block-embed__wrapper”> <div… Continue Reading Belinda Allen’s Article on their blog Creating a Custom Table in the Microsoft Power BI Query Editor As I continue...
Bulk resize images
A few months ago I posted about the Tiny JPG site which can be used to shrink files for posting online; this site redcues the filesize of the image, but not the dimensions of the image. I am building two sites at the moment (Coppr|Distilleries to Visit and Dark Forge | Tourist Attractions), onto which I will be uploading photographs of the places I have visited. Before uploading the photos, I… Continue Reading Ian Grieve’s...
Generate matching colour palettes
I run a few websites now which means I have had a need to change colours on themes. However, being colourblind, this can be somewhat difficult to mke sure that the colours I am choosing will work together. One site I have found very useful is ColorHexa.com; this is a free color tool providing information about any color and generating matching color palettes for your designs (such as… Continue Reading Ian Grieve’s Article...
Displaying Images in the Data using Microsoft Power BI
I am building a Microsoft Power BI report that will display the stats for the US College (American) Football South Eastern Conference (SEC). In this video, I will show you have I get team logos from my dataset to display. < div class=”wp-block-embed__wrapper”> <div… Continue Reading Belinda Allen’s Article on their blog Displaying Images in the Data using Microsoft Power BI I am building a Microsoft...
Remove PowerPoint animations from slides
PowerPoint is not something I have used very often, but I am now doing webinars on at least a monthly basis at work. I’ve inherited some PowerPoint slidedecks from other people with some features I don’t like; one of those is having to click to display elements on slides. This is something which I now know to be animations and their removal is actually quite straightforward. To remove an… Continue Reading Ian...
Issues with Word Templates
Recently, there have been issues with Dynamics GP and Word Templates, due to some changes to the most recent Microsoft Office build releases. Specifically, documents generated in Word Templates cannot be opened in Microsoft Word, once you’re running a build from Sept 8/9th or newer. Today’s post is an attempt to clarify what the situation is, and what is and is not affected and clarify some of… Continue Reading Jen...
Power Platform: Application Lifecycle Management (Part 2/3) – Solutions and DevOps
In the previous installment, you saw how to work through a set of prerequisites to get you going in your Power Platform Application Lifecycle Management journey. In this video, I will work through building an app and adding it to a solution and show you some additional Azure DevOps configuration options to link your repository to your Power Platform development environment.Topics Covered:1…. Continue Reading Mariano...
There’s Power Apps in my Microsoft Teams
Today, on the first day of the 2020 Virtual Microsoft Ignite, Project Oakdale was highlighted. What is Project Oakdale. It is like the old Reese’s Peanut Butter Cup commercial…. “There is a Power App in my Teams” or There’s Teams on my Power App.” Whichever way you say it, it ROCKS! In this video, I will show you the creation of a Power App, using a table that I’ll create in… Continue Reading...
Creating Data Parameters with Suggested Values in Microsoft Power BI
I have shown you already how to create parameters with SQL Server data in Microsoft Power BI. This time, I am going to show how to use a suggested list, so rather than manually entering data, I can select my parameter from a dropdown list. By the way, if you are a US College (American) football fan, you will be excited about the report that is being built! < div class=”wp-block-embed__wrapper”> <div… Continue...
Disable sounds for all Windows 10 Notifications
I’ve been switching off sounds for notifications for different programs for a while as I find the notuification chime far too loud compared to other program sounds, but as I am doing this on five or more machines, it is getting somewhat irritating. I eventually started thinking about a global switch off and wanted to see if this was possible, but since Microsoft moved settings out of the… Continue Reading Ian...
Our Favourite Add-ons from the recent ISC Software Webinar
In our most recent webinar, on Our Favourite Add-ons, we took a look at six of the add-ons which are preferred solutions from our senior consultants. They all meet a requirement which numerous clients have given to us at different times. Usually, there are several plugins which offer similar functionality which would meet these requirements, but these six add-ons are the ones which we… Continue Reading Ian Grieve’s Article...
Creating data source parameters for SQL Server in Microsoft Power BI
If you want to model data against a development SQL Server environment and deploy against a production SQL Server, in Microsoft Power BI, this video is for you. In this Tiny tip, I will show you how to create a Parameter, edit your data source, export, and import your work.
Error opening Word templates from Microsoft Dynamics GP Workflow Action emails
A client reported a problem with workflow approvers opening the batch edit list on a Microsoft Dynamics GP General Ledger Batch Approval workflow action email this morning; only a few users are having problems while everyone else is working without problem. The users with the problem are getting this error when trying to open the Transaction Edit List report on the email: Microsoft WordWord… Continue Reading Ian Grieve’s...
Power Platform: Application Lifecycle Management (Part 1/3) – Prerequisites
This series is in response to multiple requests by my viewers to address the topic of Power Apps Application Lifecycle Management (ALM). This series is intended to breakdown the entire process in as much detail as possible, without lengthy explanations on how to get it done or, as often happens, little to no explanations on how you arrived at a particular step or result. My first installment… Continue Reading Mariano...
What happened to #TipTuesday?
Hey, everyone reading this… no, I haven’t fallen off the face of the earth. I’m hoping to get back into regular blogging this Fall. Ahem, I mean Autumn. (that’s for David Musgrave ). I’ve been fortunate to stay safe & healthy as well as maintain most of my business during COVID-19, that’s the good news. There have been a few unrelated things that have kept me away from my normal blogging…...
Using Microsoft Power BI Q&A to ask about a specific field in a column
Yesterday I had the pleasure of hanging out with the Microsoft Modern Excel and Power BI user Group. We were talking about Q&A and discovered, together, a method of asking about data based on the value of a specific column. While using the Q&A feature of Microsoft Power BI, I have done things like “Show me the revenue where the state is MN” but I had asked in this method. We were… Continue Reading Belinda...
Upcoming Microsoft Dynamics GP Webinars from ISC Software
I’ve been quite busy both in and out of work recently and have lagged in the writing of blog posts, so I thought I’d let you know of the three upcoming monthly webinars I’ll be delivering for ISC Software. We run these webinars on a monthly basis, with occasional extra webinars added to the schedule so it is worth checking the Webinar Schedule page every so often. The upcoming webinars are:
Show Workflow Approval Status of posted Microsoft Dynamics GP General Ledger batches
I recently deal with a support call for a client where they were having problems creating a report which showed the approval status of GL batches. Building the WfBusObjKey was more complicated than I expected as it requires the date and time from the batch; for an unposted journal this can easily be retrieved from the PA Report Posting Definitions Master (SY00500) table, but for posted batches… Continue Reading Ian...
Renaming and Hiding Fields in Microsoft Power BI
Microsoft Power BI allows for the hiding of fields in Report Mode. In this Tiny Tip video, I will show you how hiding fields affect Q&A and DAX. Today’s DAX Expression: Customer and Class = Customers[Customer Name] & ” ” & Customers[Customer Class] <div… Continue Reading Belinda Allen’s Article on their blog Renaming and Hiding Fields in Microsoft Power BI Microsoft Power BI allows for the...
Power Automate: Transfer records from SharePoint list to Azure SQL database
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… Continue Reading Mariano...
Using DAX with Conditional Formatting in Microsoft Power BI
OK, I have this table visual in my Microsoft Power BI Report and I want to highlight a row if a column value is “Yes” but do nothing to the background if the value is “No”. In this Tiny Tip video, I will show you how to achieve this very thing. Today’s DAX Expression: Hold Background Color = VAR _HoldColor = SELECTEDVALUE(Customers[Hold]) RETURN IF(_HoldColor = “Yes”, “#A0D1FF”) <div… Continue Reading...
What’s New in the Microsoft Dynamics GP October 2020 Release
I’ve been keeping my out for any news of the next version of Microsoft Dynamics GP but haven’t seen anything on the official blogs (if I’ve missed it, I’d appreciate someone pointing me in the direction), but there have been some recent articles from other partners listing some of the upcoming new functionality. One such article is from Aisling Dynamics Consulting, LLC on the ERP Software… Continue...
Microsoft Dynamics GP Workflow Payables Batch Approval email not including Word template
A client has recently been working on a project to implement approval workflows in a few modules of Microsoft Dynamics GP, but had an issue with the Payables Transaction Approvals notification emails not always including the Word template which all of the steps are marked to include. There appeared to be no pattern on which approval emails either did or did not include the Word template; a user… Continue Reading Ian...
Setting Geographic Data Categories in Microsoft Power BI Q&A
Ever use a map visual in Microsoft Power BI, but the locations are not correct? In this Tiny Tip I will show you how to categorize geographic fields. For example, we will take the city field and define it as a City. If you were trying to display information for the city of New York, Texas, you would not want it to display as the state of New York. <div… Continue Reading Belinda Allen’s Article on their blog Setting...
Notepad++ Find and Replace numbers in square brackets
I was working with some text the other day which included a lot of references using numbers in square brackets; I needed to remove this text and wanted an easy way of doing it. I did a little research and found that Notepad++, an application I already use, can do regular expression find and replace. The regular expression for a number surrounded by square brackets is: [(d+)] To use the… Continue Reading Ian Grieve’s...
Books referenced by Bernard Cornwell in the Sharpe series’ historical notes
The Richard Sharpe series is a series of historical fiction novels and short stories by Bernard Cornwell centred on the character of Richard Sharpe, charting Sharpe’s progress in the British Army during the Napoleonic Wars, starting from his early career in India through to the Battle of Waterloo and beyond (further details on the series can be found on Wikipedia). In some of the books,… Continue Reading Ian Grieve’s...
Using Q&A to assist in User Adoption of Microsoft Power BI
User adoption of any application is a “Hard road to Hoe”. Sorry, the southerner in me breaks out every now and then. In this Tiny Tip video, I’ll show you how to make a Microsoft Power BI report page, that will help end users have control over what they see. <div… Continue Reading Belinda Allen’s Article on their blog Using Q&A to assist in User Adoption of Microsoft Power BI User adoption of any...
Creating Suggested Questions in Microsoft Power BI Q&A
If you have ever used the Microsoft Power BI Q&A visual, you know it creates “Suggested Questions” for you based on your dataset. In this Tiny tip, I’ll show you have to create your own list of suggested questions, ones that are relevant to you and your users! <div… Continue Reading Belinda Allen’s Article on their blog Creating Suggested Questions in Microsoft Power BI Q&A If you have ever used the Microsoft...
Find text in any SQL object
I needed to find custom triggers or views which referenced a certain table and although I thought I had a script which would find text in a SQL object like a trigger, view or stored procedure, I couldn’t find one when I searched my site the other day. It only took me a few minutes to write one; the first highlighted text is the text to search for and the second a limitation on the name of the… Continue Reading Ian...
Using Synonyms in Microsoft Power BI Q&A
The Q&A is a super cool visual in Microsoft Power BI. In this Tiny Tip I will show you how to add synonyms to your data fields so Q&A can recognize different terms that end users may enter. For example, what if you call your customers “Guests” or “Clients”? If you do, this tip is for you! <div… Continue Reading Belinda Allen’s Article on their blog Using Synonyms in Microsoft Power BI Q&A The Q&A is...
Using a DAX function as a Report Title in Microsoft Power BI
Using the Card Visual as a Report Title and a value can save you space on a Microsoft Power BI Report. In this Tiny Tip I will show you how to make a DAX measure become text for a Report Title. Because it is a visual, it will even be interactive with the remainder of the report! <div… Continue Reading Belinda Allen’s Article on their blog Using a DAX function as a Report Title in Microsoft Power BI Using the Card...
SQL script to create macro to delete items in Microsoft Dynamics GP
I’ve been doing some work with SmartConnect for a client recently where one of the integrations was creating new items. As the project progressed, some of the items which had been imported needed to be replaced with different item numbers. To ensure we didn;t cause problems, I didn’t want to delete items through SQL directly, due to the number and variety of tables involved, so needed to come… Continue Reading Ian...
Permissions error exporting Microsoft Dynamic GP SmartList Object
A client recently reported a problem whereby users were no longer able to export a SmartList favourite to Excel as they were receiving a permissions error when the Excel file opened: The SELECT permission was denied on the object ‘uv_AZRCRVBudgetByMonth’, database LIVE’, schema ‘dbo’ I did some checking and realised that the problem was that the file being opened when the user tried to do an…...
