Connecting to Harvest in Power Query
Nov10

Connecting to Harvest in Power Query

Today’s post is the start of a “mini-series” where I’ll document how I’m working with some different APIs for custom reporting. Today’s post is about Harvest, an app I use for time tracking and billing. This series is aimed at users who may have similar requirements to mine, which was pulling data out of different application APIs for analysis in Power BI and/or Excel. In my limited… Continue...

Read More
During Upgrade Company Locked In Microsoft Dynamics GP Utilities
Nov10

During Upgrade Company Locked In Microsoft Dynamics GP Utilities

I did an upgrade for a client recently which encountered a problem in one company and crashed; when resuming the upgrade, the Upgrade these companies? step showed a lock against the company which had encountered the problem: It’s a while since I encountered this and I had to look up how to remove the lock; it’s quite simple to do with a small SQL script. To remove the lock, run the below in… Continue Reading...

Read More
Power BI matrix column width sizing
Nov09

Power BI matrix column width sizing

I’ve been working with Power BI a lot lately on a “passion project” for myself. I’ll be starting to share more about that in the coming days but first I wanted to share a little tip (that I wish we didn’t need!) for sizing columns on Matrix visuals in Power BI. I’ve read a number of other posts and suggestions around creating a measure with all “X’s” but they have never worked for… Continue Reading Jen...

Read More
“The selected company is not configured as a company of the current Microsoft Dynamics GP system database” Error
Nov09

“The selected company is not configured as a company of the current Microsoft Dynamics GP system database” Error

We been doing a lot of work with a client recently to split their US and UK based systems. The original scope involved implementing Microsoft Dynamics GP for a new company based in the UK; the databases were originally created on the US system and then split off by copying the company database and the system database onto a UK based SQL Server. Along with the client, we did some tidying up of… Continue Reading azurecurve’s...

Read More
Error in Microsoft Dynamics GP When Purchasing Requisitions
Nov08

Error in Microsoft Dynamics GP When Purchasing Requisitions

I did some work recently to assist a client to upgrade Microsoft Dynamics GP to the latest version on an isolated test system. They had previously had the Reporting Services and refreshable Excel reports deployed, but weren’t sure if they were being used. When we did the upgrade we did not deploy the new versions of the reports while we awaited a decision from the end users as to whether any… Continue Reading...

Read More
GP Upgrades – series wrap-up
Nov05

GP Upgrades – series wrap-up

Well, it’s finally the end of the series and this one is a short-ish one where I review some last minute tips. Posts in the series Series introProcess overviewKnow your environment (part 1)Know your environment (part 2)Know your environment (part 3)Know your environment (part 4)Know your environment (part 5)Know your environment (wrap-up)Testing Random tips! As I wrap up this… Continue Reading Jen Kuntz’s Article on...

Read More
“The transaction amount is not fully distributed” Error in Integration Manager
Nov05

“The transaction amount is not fully distributed” Error in Integration Manager

I helped a client create a bank transaction integration in Integration Manager the other day. It’s been a while since I created an integration like this, so we created it as I would a general ledger integration with a header and distribution file with two distributions for each transaction. However, when we ran the integration, we received this error message: The transaction amount is not… Continue Reading...

Read More
“You do not have authorization to post bank transactions” Error in Microsoft Dynamics GP
Nov04

“You do not have authorization to post bank transactions” Error in Microsoft Dynamics GP

A client reported an issue recently whereby they could not post bank trasactions. This had previously been working, but had recently become a probkem. When trying to post, they received this error message: Microsoft Dynamics GP You do not have authorization to post bank transactions. I did some checking around and found that the Allow Transaction Posting checkbox for bank transactions in… Continue Reading azurecurve’s...

Read More
GP Upgrades – testing
Nov03

GP Upgrades – testing

Much of the upgrade series so far has been about “knowing your environment”. As I get closer to the end of the overall series, there are a couple more topics to discuss. Today’s topic is testing and what to consider/plan for. Posts in the series Series introProcess overviewKnow your environment (part 1)Know your environment (part 2)Know your environment (part 3)Know your… Continue Reading Jen Kuntz’s Article on their...

Read More
Error When Trying to Change User Password in Microsoft Dynamics GP
Nov03

Error When Trying to Change User Password in Microsoft Dynamics GP

We’ve been implementing Microsoft Dynamics GP for a client recently. After creating some new user accounts, I was sending details to the users, when I realised that I couldn’t remember the password structure (I’d been distracted onto another project between creating the accounts and sending the email). I went back into the User Setup window (Administration area page » Setup » System » User)…...

Read More
Microsoft Dynamics GP October 2021 Release Feature of the Day: Default 1099 to Single Feed
Nov02

Microsoft Dynamics GP October 2021 Release Feature of the Day: Default 1099 to Single Feed

This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Default 1099 to Single Feed Financial enhancement. For ease of use,… Continue Reading azurecurve’s...

Read More
GP Upgrades – know your environment wrap-up
Nov01

GP Upgrades – know your environment wrap-up

This is the last post in the upgrade series that is specifically about “knowing your environment”. After this I will branch out into other topics but for now, I am doing a catch-all of smaller things I may not have noted in prior posts. Posts in the series Series introProcess overviewKnow your environment (part 1)Know your environment (part 2)Know your environment (part 3)Know your… Continue Reading Jen Kuntz’s...

Read More
Microsoft Dynamics GP October 2021 Release Feature of the Day: Copy Payroll Transactions from Excel
Nov01

Microsoft Dynamics GP October 2021 Release Feature of the Day: Copy Payroll Transactions from Excel

This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Copy Payroll Transactions from Excel Payroll enhancement. Many… Continue Reading azurecurve’s...

Read More
GP Upgrades – know your environment part 5
Oct30

GP Upgrades – know your environment part 5

My last post was about integrations and what to consider for that in terms of testing and planning. Today’s post is about reporting. The previous posts are linked below for what I’ve covered thus far in the series! Posts in the series < ol>Series introProcess overviewKnow your environment (part 1)Know your environment (part 2)Know your environment (part 3)Know your environment (part… Continue Reading Jen...

Read More
Microsoft Dynamics GP October 2021 Release Feature of the Day: Project Code Modifier
Oct29

Microsoft Dynamics GP October 2021 Release Feature of the Day: Project Code Modifier

This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Project Code Modifier Project Accounting enhancement. In Dynamics GP… Continue Reading...

Read More
Microsoft Dynamics GP October 2021 Release Feature of the Day: Remove Carbon Copy Email in Workflow Maintenance
Oct28

Microsoft Dynamics GP October 2021 Release Feature of the Day: Remove Carbon Copy Email in Workflow Maintenance

This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Remove Carbon Copy email in Workflow Maintenance System… Continue Reading azurecurve’s Article on...

Read More
Microsoft Dynamics GP October 2021 Release Feature of the Day: SafePay – Display Employee Name From Check
Oct27

Microsoft Dynamics GP October 2021 Release Feature of the Day: SafePay – Display Employee Name From Check

This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the SafePay – Display employee name from Check Payroll… Continue Reading azurecurve’s Article on their...

Read More
GP Upgrades – know your environment part 4
Oct27

GP Upgrades – know your environment part 4

My last post was a few months ago and since then I’ve gotten a little distracted with other things (summer, nicer weather, etc.). I’m ready to try to catch up and finish this upgrade series, continuing on for now with the “know your environment” topic. So far I have covered some product terminology, product types & ISV products, and a bit about identifying external applications. In this… Continue Reading Jen...

Read More
Microsoft Dynamics GP October 2021 Release Feature of the Day: Sales Inquiry GoTo
Oct26

Microsoft Dynamics GP October 2021 Release Feature of the Day: Sales Inquiry GoTo

This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Sales Inquiry GoTo Financial enhancement. In the Sales Order… Continue Reading azurecurve’s...

Read More
Microsoft Dynamics GP October 2021 Release Feature of the Day: Workflow Approvers Count
Oct25

Microsoft Dynamics GP October 2021 Release Feature of the Day: Workflow Approvers Count

This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Workflow Approvers Count System enhancement. An option has been… Continue Reading azurecurve’s...

Read More
Microsoft Dynamics GP October 2021 Release Feature of the Day: Save Settings for All in One Viewer
Oct22

Microsoft Dynamics GP October 2021 Release Feature of the Day: Save Settings for All in One Viewer

This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Save Settings for All in One Viewer Financial enhancement. Microsoft… Continue Reading...

Read More
Microsoft Dynamics GP October 2021 Release Feature of the Day: Default Email on form 1096
Oct21

Microsoft Dynamics GP October 2021 Release Feature of the Day: Default Email on form 1096

This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Default Email on form 1096 Financial enhancement. For Dynamics GP… Continue Reading azurecurve’s...

Read More
Microsoft Dynamics GP October 2021 Release Feature of the Day: Add Autopost for Workflow Batches
Oct20

Microsoft Dynamics GP October 2021 Release Feature of the Day: Add Autopost for Workflow Batches

This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Add Autopost for Workflow Batches System enhancement. With this… Continue Reading azurecurve’s...

Read More
Microsoft Dynamics GP October 2021 Release Feature of the Day: Save Payroll Transaction Entry Defaults
Oct19

Microsoft Dynamics GP October 2021 Release Feature of the Day: Save Payroll Transaction Entry Defaults

This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Save Payroll Transaction Entry Defaults Payroll enhancement. In US… Continue Reading azurecurve’s...

Read More
Microsoft Dynamics GP October 2021 Release Feature of the Day: Mask Social Security Number on W-2
Oct18

Microsoft Dynamics GP October 2021 Release Feature of the Day: Mask Social Security Number on W-2

This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Mask Social Security Number on W-2 Human Resources… Continue Reading azurecurve’s Article on their...

Read More
Microsoft Dynamics GP October 2021 Release Feature of the Day: Save Inquiry Sort Options
Oct15

Microsoft Dynamics GP October 2021 Release Feature of the Day: Save Inquiry Sort Options

This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Save Inquiry Sort Options Financial enhancement. This new Financial… Continue Reading azurecurve’s...

Read More
Microsoft Dynamics GP October 2021 Release Feature of the Day: Summary Post Cash Receipt at Batch
Oct14

Microsoft Dynamics GP October 2021 Release Feature of the Day: Summary Post Cash Receipt at Batch

This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Summary post Cash Receipt at Batch Financial… Continue Reading azurecurve’s Article on their blog...

Read More
Microsoft Dynamics GP October 2021 Release Feature of the Day: Update Account Description in Mass Modify
Oct13

Microsoft Dynamics GP October 2021 Release Feature of the Day: Update Account Description in Mass Modify

This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Update Account Description in Mass Modify Financial enhancement. A… Continue Reading azurecurve’s...

Read More
Microsoft Dynamics GP October 2021 Release Feature of the Day: Scroll Through Account Segments
Oct12

Microsoft Dynamics GP October 2021 Release Feature of the Day: Scroll Through Account Segments

This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Scroll through Account Segments Financial enhancement. This is a… Continue Reading azurecurve’s...

Read More
Microsoft Dynamics GP October 2021 Release Feature of the Day: Series Index
Oct11

Microsoft Dynamics GP October 2021 Release Feature of the Day: Series Index

This post is the Microsoft Dynamics GP October 2021 Release Feature of the Day series index for the series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. The series index, below, will automatically update here on azurecurve|Ramblings of a Dynamics GP… Continue Reading azurecurve’s Article...

Read More
Microsoft Dynamics GP October 2021 (18.4) Now Available
Oct08

Microsoft Dynamics GP October 2021 (18.4) Now Available

The October 2021 (18.4) release of Microsoft Dynamics GP is now available for download; the official post release announcement is here. The full download is here and the hotfix update for upgrading from 18.2 or 18.3 is here . The latest features and functions added or enhanced are: Financials Scroll Through Account Segments. Default Inquiry Sort Options (Receivables, Payables, Bank… Continue Reading azurecurve’s Article on...

Read More
PHP Snippets: If Statements
Oct06

PHP Snippets: If Statements

This post is part of the PHP Snippets series where I will be covering the basics of developing in PHP. One of the most basic statemnts you’ll use in PHP is the if statement which is used for conditional statements which perform different actions. The most basic form is the basic if itself which executes when one condition is true: $time = date( “H” ); if ( $time < 12 ){ echo “Good...

Read More
PHP Snippets: Sprintf
Sep29

PHP Snippets: Sprintf

This post is part of the PHP Snippets series where I will be covering the basics of developing in PHP. The sprintf function provides the same functionality as the printf function, but silently. This means you would either need to echo the output or concatenate it with a string and echo that string. $number = 500; $string = ‘miles’; echo sprintf( ‘But I would walk %d %s’, $number, $string ); Click…...

Read More
PHP Snippets: Printf
Sep22

PHP Snippets: Printf

This post is part of the PHP Snippets series where I will be covering the basics of developing in PHP. The printf function is similar to the echo function in that it will output text, but differs in that it outputs a formatted string. The syntax of the printf function is: printf( string, arg 1, arg 2, … ) Multiple arguments can be provided to the function for each of the placeholders to be… Continue Reading...

Read More
Upgrade Fails on Item Master (IV00101)
Sep16

Upgrade Fails on Item Master (IV00101)

Most Microsoft Dynamics GP upgrades run through quickly ad without issue but every so often one will encounter a problem. I had one of the upgrades which encountered a problem recently with a client we’d taken over the support from a previous partner. We always recommend that a test upgrade be done on a standalone server before live to identify exactly this sort of issue. We restored all of… Continue Reading...

Read More
PHP Snippets: Quotes
Sep15

PHP Snippets: Quotes

This post is part of the PHP Snippets series where I will be covering the basics of developing in PHP. Both single and double quotes are supported in PHP, but there is a significant difference in how they are handled. Single quotes are output “as is” and are the quickest form of quoting. When using single quotes, you would need to concatenate variables with a string to output them:

Read More
SQL Snippets: SELECT INTO
Sep14

SQL Snippets: SELECT INTO

This post is part of the series on SQL Snippets. I occasionally need to make a backup of a SQL table and all rows within; while you can create a table and insert the content, this is the long way of doing. Instead you can use SELECT INTO to both create a table with the correct columns and also to copy the data. In the below example I am creating a new table suffixed with the date; the first

Read More
PHP Snippets: Echo
Sep08

PHP Snippets: Echo

This post is part of the PHP Snippets series where I will be covering the basics of developing in PHP. Almost everything you write in PHP ill have an output to the user; the simplest way of doing this is to use the in-built echo function (which you can use with or without parentheses). The below example is a simple echo to output one line of text: echo ‘Hello world!’; You can output multiple… Continue Reading...

Read More
ClassicPress Petitions – Let Your Voice Be Heard
Sep07

ClassicPress Petitions – Let Your Voice Be Heard

ClassicPress started life as a hard-fork of WordPress 4.9; one of the differentiators is the Gutenberg block editor which started by replacing the TinyMCe editor (now generally referred to as the “classic editor”) and is now beig rolled out through other part of a WordPress site. However, this is just one of the differentiators. One of the largest other differences is the decision making… Continue Reading...

Read More
Enable Extensions in Vivaldi Private Mode
Sep06

Enable Extensions in Vivaldi Private Mode

I don’t use browser private/incognito modes very often, but sometimes when I do I also want some of the installed Extensions to be available. My browser of choice is Vivaldi and it does allow you to enable extensions, on a per extension basis, in private mode. To do this, open the Extensions page from the menu or using Ctrl+Shift+E and click the details button on the plugin you want to enable… Continue Reading...

Read More
ClassicPress 1.3.0 Now Available
Sep05

ClassicPress 1.3.0 Now Available

Earlier this week, the releae of ClassicPress version 1.3.0 was announced; this release focuses on improving accessibility (a11y) which is a key focus for ClassicPress (both the core itself as well as strongly recommending that developers work with accessibility in mind) and one which has a lot of people switching from WordPress as Gutenberg is less accessible that the editor used in… Continue Reading azurecurve’s Article...

Read More
Microsoft Dynamics GP Reporting Services Reports Not Supported on SQL Express
Sep03

Microsoft Dynamics GP Reporting Services Reports Not Supported on SQL Express

Usually when installing or upgrading Microsoft Dynamics GP for clients they will use SQL Server Standard and sometimes Enterprise; very rarely, I’ll encounter a mall client who is using or wants to use SQL Server Express. SQL Server Express is a free version of SQL Server, but which has some limitations. SQL Server Reporting Services (SSRS) is not one of those limitations; you can install SSRS… Continue Reading...

Read More
Error With Microsoft Dynamics GP Historical Company Name in Jet Reports
Sep02

Error With Microsoft Dynamics GP Historical Company Name in Jet Reports

I’ve worked with Jet Reports against Microsoft Dynamics GP with a few clients over the last couple of years (as well as writing a book on using it with Microsoft Dynamics GP). One recent client I was working with developed some reports against the live companies, but we had a problem when trying to include some data from historic companies (after a merger, new companies were created and the… Continue Reading...

Read More
PHP Snippets: Series Index
Sep01

PHP Snippets: Series Index

I started developing plugins for WordPress back in 2014 and switched to ClassicPress in early 2019. I’ve been writing a series of posts on ClassicPress Plugin Development and thought a companion series on developing in PHP might be useful to people looking to make a start. Over this series of PHP snippets, I’ll be covering the basics of developing in PHP. The series index, below, will update… Continue Reading...

Read More
Update Microsoft Dynamics GP Account Categories From Text File
Aug31

Update Microsoft Dynamics GP Account Categories From Text File

I’ve recently been working with a client to implement Jet Reports as a replacement for Management Reporter. As part of this implementation, it was necessary to change the account categories in Microsoft Dynamics GP. This particular client has over 1 million account strings in their chart of account which meant any update could not be done manually. While it could technically be done through… Continue Reading...

Read More
SQL Snippets: Create and Use Database Role to Restrict Access
Aug30

SQL Snippets: Create and Use Database Role to Restrict Access

This post is part of the series on SQL Snippets. I create a lot of SQL objects such as views, tables, stored procedures and so on. If they will be used from within Microsoft Dynamics then they can simply be assigned to the DYNSA role, but if they are for use in custom reporting or integrations then separate security will be required. Usually for reporting, and especially for integrations,… Continue Reading azurecurve’s...

Read More
Check For Colour Accessibility (A11y)
Aug29

Check For Colour Accessibility (A11y)

I’ve posted about a few useful websites as a way of remembering and finding them again. Today I am posting another one which is about colour accessibility. Back in September 2020, I posted about a site called ColorHexa which you can use to generate matching colour palettes. This is good as far as it goes, but for web design best practice is that websites need to be accessible. This is… Continue Reading azurecurve’s...

Read More
ClassicPress Plugin Development: Save an Options Page
Aug28

ClassicPress Plugin Development: Save an Options Page

This post is part of the ClassicPress Plugin Development series in which I am going to look at both best practice for developing plugins and how I approach some requirements as well as some of the functions I commonly use. Once you have an options page created, you need to create the process to save the options when the user changes them. The example I am using in this post is from my Remove… Continue Reading azurecurve’s...

Read More
Error Entering Invoice in Microsoft Dynamics GP When Multiple Bins Enabled
Aug27

Error Entering Invoice in Microsoft Dynamics GP When Multiple Bins Enabled

I’ve been working on a project implementing Microsoft Dynamics GP for a new client recently. They are a manufacturing company who have bins enabled for storing and tracking items as they move through the factory; goods booked in or out through POP and SOP were also recorded to and from bins. One day during UAT (user acceptance testing) I received an email from the client that users were… Continue Reading azurecurve’s...

Read More
VBA To Insert Next Microsoft Dynamics GP DD Transaction Code
Aug26

VBA To Insert Next Microsoft Dynamics GP DD Transaction Code

I am tending to encourage clients to use SmartConnct from eOne Solutions for integrating data into Microsoft Dynamics GP, but I do still have quote a few clients using Integration Manager. SmartConnect supports the use of custom eConnect nodes which I have created for a few clients, either manually or through using Node Builder (also from eOne). You can accomplish the same result through… Continue Reading azurecurve’s...

Read More