SQL View for to Extract Accruals from Microsoft Dynamics GP Payables Management Module
I recently did a webinar for my employer, ISC Software, on Prepayments and Acruals and as part of the accruals section used a SQL View to extract the accruals to be created; as mentioned in thw webinar, the extract cna be done either using a SmartList or a direct query in SmartConnect. The SQL view has been created using the EOMONTH function which si available only in later versions of SQL… Continue Reading Ian Grieve’s...
Identify and Fix Corrupt SOP Transactions in Microsoft Dynamics GP
A client recently logged a support call whereby reports were showing incorrect information, including for transactions which had been deleted. I did some exploring mof data and found that the Sales Transaction Amounts Work (SOP10200) and Sales User-Defined Work History (SOP10106) tables contained rows for transactions which were not in the Sales Transaction Work (SOP10100) table. From… Continue Reading Ian Grieve’s Article...
SQL View on Sales Order Processing Backorder Transactions
I’ve written this view for a number of different clients over the years, so am posting it here for future reference. It returns only open backorders which have yet top be transferred to order or invoice; it includes PO information so users can easily see if a PO has been raised and if any of it has been receipted. The SQL below includes the CREATE VIEW uv_AZRCRV_SOPOpenBackorders AS /*Created… Continue Reading Ian...
SQL Query to Get Login Password Expiry
I don’t recall exactly why this script was required, but the below SQL query can be used to get the expiration date for logins in Microsoft SQL Server. Some of the data is available directly from the sys.sql_logins table, but other pieces had to be retrieved using the LOGINPROPERTY function: SELECT [‘SQL Logins’].name AS ‘LoginName’ ,LOGINPROPERTY([‘SQL Logins’].name,...
What Data Can SmartConnect Integrate into Microsoft Dynamics GP?
I’ve worked with a number of clients on SmartConnect from eOne Solutions this year as well as discussing with a few prospects. SmartConnect is a very flexible tool which can be used to integrate many different types of data. In this respect, it competes with the Microsoft Integration Manage product, but SmartConnect has many other features over Integration Manager. Discussions on SmartConnect… Continue Reading Ian...
Excluding Folders From a Cron Backup
A while ago, I posted an article on using cron to make backups of folders on Linux web hosting. One issue I’ve become aware of since then is that there are some folders I want to exclude from the backup process. I did some exploring and found the –exclude switch can be used to exclude a single folder; to exclude multiple folders, you can use the switch multiple times. The example below,… Continue Reading Ian...
Error Posting Journals in One Microsoft Dynamics GP Company
A client reported an urgent support call a short time ago that they could not post any journals and were receiving this error when they tried: Insert failed because the following SET options have incorrect settings: ‘CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS’. Verify that SET options are correct for use with indexed views and/or indexes on comp This error was produced for all users in only one of… Continue Reading Ian...
Insert Segments from Text File/CSV into Microsoft Dynamics GP
It seems that while I’ve posted about how to update segment descriptions from CSV in Microsoft Dynamics GP and how to copy them to a new company or even all companies, I’ve never actually posted the script I use to insert them. I needed this script the other day and ended up using the update descriptions one as the basis for a new script to insert segments into Dynamics GP; this script will… Continue Reading Ian...
Management Reporter Currency Does Not Exist Error
I was doing some training on Management Reporter for a client the other week and had an issue to follow up on. The issue was around multicurrency conversion which wasn’t working correctly. When doing some testing around the issue, I was able to reproduce the same currency error the client had encountered: Currency XXXX does not exist for company XXXX. No values will be returned. The currency… Continue Reading Ian...
Deleting a Windows Service
I recently uninstalled an application to notice a few days later that the related service was still showing in the Services applet. I’ve previously posted about adding and removing dependencies from a Windows service. As with adding or removing dependencies, the SC command online program can be used to delete a service: SC DELETE {service name} Read original post Deleting a Windows Service at
Microsoft Dynamics GP Fall 2020 Release Documentation
As of the October 2019 release, Microsoft Dynamics GP moved onto the Modern Lifecycle which offers continuous support and servicing, including bug fixes, new features and the latest tax updates. There will be one major release per year along with at last two hotfix releases through the year. There are a number of resource pages available or updated for the Fall 2020 Release of Microsoft… Continue Reading Ian Grieve’s...
New Year’s Resolutions 2021
It’s that time again, a new calendar year has begun. This year “Happy New Year” has an entirely different meaning to most of us, after what can only reasonably be described as a train wreck of a year. I’m a day late in writing this post this year (even though I’m posting this as Jan 1st), I quite honestly couldn’t find my words yesterday. How was 2020? 2020 started out very well,… Continue...
Hide Chrome Download Bar
I’ve been using Vivaldi as my main browser since v1 was first launched (and used the beta before that), but sometimes need to use a second browser. Vivaldi have made extensive changes to the UI (written their own and used the Chromium renderer?), but all of the other Chromium browsers I’ve tried all have very similar UIs which suggests they aren’t deviating much from the default. This Include… Continue Reading...
SmartConnect Service Won’t Start
This is an issue which I encountered a while ago, but only recently found the screenshots when doing some tidying up. When I installed SmartConnect I had a problem whereby the service would not start. I’d followed my usual implementation steps, but was receiving this error when trying to start the service: Services The eOne SmartConnect Service service on Local Computer started and then… Continue Reading Ian Grieve’s...
SmartConnect Error: “The delete permission was denied on the object…”
A while back a client using SmartConnect reported an error running one integration; this is one of a set of newly created identical integrations running against a set of companies, but only one of them was failing. The error produced was: Task xxxx failed. Map run will end reporting failure. The DELETE permission was denied on the object ‘xxxx’, database ‘xxxx’, schema ‘dbo’ As there was a…...
SmartConnect could not find data
I recently created an integration using SmartConnect for a client as I have many times before; however, when I came to test the integration, my source file was totally ignored and the integration returned an error that no file was found. The integration was using a folder data source with an Excel template; nothing special and something which I have configured many times. I copied the template… Continue Reading Ian...
Missing Security Roles and Tasks After Upgrading to Microsoft Dynamics GP Fall 2020 Release
When upgrading Microsoft Dynamics GP, the security roles and tasks are not automatically updated; this is to avoid overwriting or causing problems with any customizations to these roles and tasks which might have been made. Instead Microsoft provide a set of scripts which you can choose to run to add the missing items. I always recommend clients not directly amend the standard tasks, but make… Continue Reading Ian Grieve’s...
Installing Pi-hole On A Raspberry Pi: Changing the IP Address
I recently built a Raspberry Pi and installed Pi-hole onto it for my Dad. I did all of the work at my house and then took it down to his to install onto his network. I had an issue with doing this as it was not picking up a new IP address (it took me a while to work out that this was the problem). Not knowing Linux very well, it took me longer than it would have done with a Windows machine to… Continue Reading Ian Grieve’s...
Microsoft Dynamics GP Support from ISC Software
I’ve worked with Microsoft Dynamics GP for over 17 years and, like most people, do not work for the company with whom I first started. In fact, I am now on my third company working with Microsoft Dynamics GP (and starting to do some work with Microsoft Dynamics Business Central). 18 months after I left the first company they bowed out of supporting Dynamics GP; I now hear from a former client… Continue Reading Ian...
Workfow Submit button on PM Transaction Entry not working in Microsoft Dynamics GP
I’ve been doing some work with a client to implement the Workflow module of Microsoft Dynamics GP for approvals of Payables Transactions and encountered an oddity; when the user creates a transactions and hits Submit, nothing happens, but was not able to reproduce this on any of my demo or test systems. There was a customised window in use on the client system, so I removed this and tried with… Continue Reading Ian...
Microsoft Dynamics GP Analytical Accounting Open Transactions SQL Query
I was looking into a problem reported by a client recently and needed to check the assignment of Analytical Accounting Transaction Dimension Codes to the AA GL transactions and so wrote the below SQL which I am posting to keep it easily accessible should I need it again. /*Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is… Continue Reading Ian Grieve’s...
Recent ISC Software Webinar: Year-End Best Practice in Microsoft Dynamics GP
In our most recent webinar, we took a look at Year-End Best Practice in Microsoft Dynamics GP. In this webinar, we covered how some key points to action or consider before starting, the order in which the year end should be run before running through the closing process in each of the standard modules in Microsoft Dynamics GP covering not only what to do. but also what the year-end closing… Continue Reading Ian Grieve’s...
Microsoft Dynamics GP Fall 2020 Release New Features: Mask SSN on Human Resource Reports
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Mask SSN on Human Resource Reports Human Resource & Payroll enhancement. A… Continue Reading Ian...
Replaced ClassicPress Cron Job Timing Out
Back in March I blogged about replacing the standard ClasicPress cron job with a system cron running on a schedule. The reason I did this was to improve the efficiency of my sites by having cron called on a schedule rather than every time a page was loaded. However, I’ve recently been adding new functionality to my To Twitter plugin and found that scheduled tweets containing images were not… Continue Reading Ian...
Microsoft Dynamics GP Fall 2020 Release New Features: Disable system print dialog box when printing a Word Template
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Disable system print dialog box when printing a Word Template Distribution… Continue Reading Ian Grieve’s...
Microsoft Dynamics GP Fall 2020 Release New Features: Print all Sales Documents
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Print all Sales Documents Distribution enhancement. In the Print Sales… Continue Reading Ian Grieve’s...
Microsoft Dynamics GP Fall 2020 Release New Features: Export/Import stock counts to Excel
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Export/Import stock counts to Excel Distribution enhancement. The Stock… Continue Reading Ian Grieve’s...
Microsoft Dynamics GP Fall 2020 Release New Features: Remove Fully applied Multicurrency documents from PM HATB
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Remove Fully applied Multicurrency documents from PM HATB Financial… Continue Reading Ian Grieve’s Article...
Microsoft Dynamics GP Fall 2020 Release New Features: Import Credit Card Transactions
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Import Credit Card Transactions Financial enhancement. Importing a credit… Continue Reading Ian Grieve’s...
Microsoft Dynamics GP Fall 2020 Release New Features: Copy and Paste Purchasing Transactions and Distributions
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Copy and Paste Purchasing Transactions and Distributions Financial… Continue Reading Ian Grieve’s Article...
Microsoft Dynamics GP Fall 2020 Release New Features: Match Excel Copy/Paste Decimals Places to Currency Setup
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Match Excel Copy/Paste Decimals Places to Currency Setup Financial… Continue Reading Ian Grieve’s Article...
Microsoft Dynamics GP Fall 2020 Release New Features: Additional User Defined field in General Ledger Transaction Entry
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Additional User Defined field in General Ledger Transaction Entry Financial… Continue Reading Ian Grieve’s...
Microsoft Dynamics GP Fall 2020 Release New Features: Automate full General Ledger Reconcile
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Automate full General Ledger Reconcile Financial enhancement. This feature… Continue Reading Ian Grieve’s...
Microsoft Dynamics GP Fall 2020 Release New Features: 1099-MISC Updates
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the 1099-MISC Updates Financial enhancement. The 1099-MISC form has been revised… Continue Reading Ian...
A re-evaluation of categories and tags in my ClassicPress blog
I started this blog way back in June 2011 and have ended up writing far more blog posts than I ever imagined; this year alone I have written more than 350 posts and this isn’t even my highest post count. Over the years, I’ve covered a number of subjects for which I have created categories and tags; in fact far, far too many of each have been created. I’ve been meaning to take a look at them for… Continue...
azurecurve ClassicPress Plugins: Events
This is part of the azurecurve ClassicPress Plugins which introduces the plugins I have available for ClassicPress. The plugin I am going to cover in this post, is a brand new one written for ClassicPress; Events. Functionality Events allows events such as webinars or conferences to be created via a custom post type; categories, excerpt, details, start and end dates and times and a featured… Continue Reading Ian Grieve’s...
Microsoft Dynamics GP Fall 2020 Release New Features: Add DBA Name field on Vendor Maintenance window for 1099 Vendors
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Add DBA Name field on Vendor Maintenance window for 1099 Vendors Financial… Continue Reading Ian Grieve’s...
Recent ISC Software Webinar: Prepayments and Accruals
In our most recent webinar, we took a look at Prepayments & Accruals in Microsoft Dynamics GP and how both can be processed using standard functionality, before then taking a look at some of the ways in which accruals can be automated. If you want to catch up on this, or any other, webinar, you can do so here. There are three main parts to the webinar (plus the references): Prepayments
Microsoft Dynamics GP Fall 2020 Release New Features: Non-Employee Compensation (NEC) for 1099 form
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Non-Employee Compensation (NEC) for 1099 form Financial enhancement. The IRS… Continue Reading Ian...
Microsoft Dynamics GP Fall 2020 Release New Features: Enable Self Service user type to access User Preferences
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Enable Self Service user type to access User Preferences System… Continue Reading Ian Grieve’s Article on...
Microsoft Dynamics GP Fall 2020 Release New Features: Save per user column layouts on Home Page
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Save per user column layouts on Home Page System enhancement. this new… Continue Reading Ian Grieve’s...
Microsoft Dynamics GP Fall 2020 Release New Features: Schedule Check Links
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Schedule Check Links System enhancement. Check Links is a maintenance… Continue Reading Ian Grieve’s...
Microsoft Dynamics GP Fall 2020 Release New Features: Bulk edit SmartList columns
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Bulk edit SmartList columns System enhancement. With the release of the… Continue Reading Ian Grieve’s...
Microsoft Dynamics GP Fall 2020 Release New Features: Maximum print output to screen
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Maximum print output to screen System enhancement. This new feature is… Continue Reading Ian Grieve’s...
Microsoft Dynamics GP Fall 2020 Release New Features: TLS 1.2
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the TLS 1.2 System enhancement. I discovered in January 2020 that I’d… Continue Reading Ian Grieve’s...
Fix for recent Word template issue available for Microsoft Dynamics GP 2016 in Year End Update
The recent problem with opening Word templates generated from Microsoft Dynamics GP, which was already fixed in Microsoft Dynamics GP Fall 2020 Release, has just had a fix released for Microsoft Dynamics GP 2016. The fix can be downloaded from the patch releases page on CustomerSource in the U.S. 2020 Year-end Update in Dynamics GP which is available for Dynamics GP and Dynamics GP 2016. It’s… Continue Reading Ian...
Microsoft Dynamics GP Fall 2020 Release New Features: Support for Multi-Factor Authentication (MFA)
This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Support for Multi-Factor Authentication (MFA) System enhancement. The Fall… Continue Reading Ian Grieve’s...
Microsoft Dynamics GP Fall 2020 Release New Features: Series Index
This post is the Microsoft Dynamics GP Fall 2020 Release New Features series index for the series where I am going to echo the posts from the Dynamics GP Support and Services Blog on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. The series index, below, will automatically update here on azurecurve|Ramblings of a Dynamics GP Consultant as… Continue Reading Ian Grieve’s...
azurecurve ClassicPress Plugins: Widget Announcements
This is part of the azurecurve ClassicPress Plugins which introduces the plugins I have available for ClassicPress. The plugin I am going to cover in this post, is a brand new one written for ClassicPress; Widget Announcements. Functionality Announce holidays, events, achievements and notable historical figures in a widget. Announcements can be made: One off Monthly Annually Good… Continue Reading Ian Grieve’s Article on...
Hands on with the Microsoft Dynamics GP Fall 2020 Release: Securing the Web Services for external access
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. When using the Web Services for Microsoft Dynamics GP with external access for Workflow approvals, it is important that the webs services be secured to minimise possible attack vectors. Everything covered in this series… Continue Reading Ian Grieve’s...
