I’ve been a long-term member of the Microsoft Dynamics GP community and within the last two years joined a second community; that of ClassicPress.
Merry Christmas to evryone in both communities and I look forward to working with you all again next year.
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 copies and amend the copy (this provides a way to roll back to the standard versions should there be a need).
The update scripts are available from the Dynamics GP Support and Services Blog and I have updated my links on the GP Missing Security Scripts page to link to that blog and the script directly; if you’re using an additional product such as Project Accounting, Enhanced Intrastat, VAT Daybook or HR & Payroll there are additional scripts on the blog post which you can run.
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 work out the solution. I spent some time searching online and came up with three commands which are run at the command line (once you’ve connected using SHH; IPv6 was working, but not IPv4 , so I was able to connect to the Pi, but not give the router the IP for use as the DNS Server).
ipaddr
sudo dhclient -r eth0
sudo dhclient -1 eth0
The above is basically the equivalent of ipconfig /renew on Windows.
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 the standard window and got exactly the same result. Some more testing showed that when the action pane was disabled and the old style toolbar being used, the Submit button was missing.
I had tried a 2018 RTM versaion and not been able to reproduce, but this was becuase I had one setting diferent. In Payables Management Setup (), my systems were all set to allow the voucher number to be overridden, but the client had disabled this option.
When we changed this setting in their test company, the workflow submit worked correctly.
I did some further checking and was able to confirm that this is a bug in the Dynamics GP 2018 version which was resolved in the R2 version; the workaround is to allow the voucher number to be overridden and the solution is to upgrade.
Fortunately, we are already talking to this client about upgrading Microsoft Dynamics GP to the latest version; in the short-term they’ll allow override in test while the build and test of the workflows are complete and the deploy to live should tie in with the upgrade project.
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 an IT Professional (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
SELECT
*
FROM
AAG30000 AS aaGLHdr
INNER JOIN
AAG30001 AS aaGLDist
ON
aaGLDist.aaGLHdrID = aaGLHdr.aaGLHdrID
INNER JOIN
AAG30002 AS GLAssign
ON
GLAssign.aaGLHdrID = aaGLDist.aaGLHdrID
AND
GLAssign.aaGLDistID = aaGLDist.aaGLDistID
INNER JOIN
AAG30003 AS aaGLCode
ON
aaGLCode.aaGLHdrID = GL Assign.aaGLHdrID
AND
aaGLCode.aaGLDistID = GLAssign.aaGLDistID
AND
aaGLCode.aaGLAssignID = GLAssign.aaGLAssignID
INNER JOIN
AAG00401 AS aaTrxDimCodeSetp
ON
aaTrxDimCodeSetp.aaTrxDimID = aaGLCode.aaTrxDimID
AND
aaTrxDimCodeSetp.aaTrxDimCodeID = aaGLCode.aaTrxCodeID
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 process does. If you want to catch up on this, or any other, webinar, you can do so here.
In this blog post, I am going to recap the webinar and include some links to documentation from Microsoft which will expand on some areas with more detail. The topics I’ll cover are:
There are five key points I always stress when discussing year-end closes with clients:
Continue reading “Recent ISC Software Webinar: Year-End Best Practice in Microsoft Dynamics GP”
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 few versions back, Microsoft added the Social Security Number (SSN) mask for payroll; this original change has prompted a request for this new functionality.
In the Human Resources Preferences window (), towards the bottom of the window a new SSN Mask button has been added.
By default on the install, everything will be marked as masked, so if you would like to see the SSN on the report you will need to unmark it from this window.
If you open the Report Masking window and no reports are listed, this script from Microsoft can be run to populate the default information. The selected reports can be amended through the window.
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 working. I did some exploring and discovered that the problem was that cron jobs timeout after 30 seconds and processing one large, or several smaller, image would exceed this timeout.
I then found that an alternative method of calling cron seemed to run much faster and I was no longer having problems with the cron job timing out. This alternative method uses wget:
wget -q -O - https://{your domain}/wp-cron.php?doing_wp_cron >/dev/null 2>&1
The highlighted section should be replaced with your domain.
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 enhancement.
With the Fall 2020 GP update, you can now use Named Printers to skip the Print Dialog and enable one-click printing of Word Templates.
To enable this feature you must first have Named Printers setup, you can find instructions for a new setup here.
Once you have the basic Named Printers setup, you can mark each printer to use Named Printers for Templates. Just open the Assign Named Printers window. Go to Tool, click setup, choose system, and click Named Printers.
Once you open this window, all you need to do is click the Setup button and select the Printer ID the users usually use, then mark the ‘Use Named Printer when printing word Templates’ checkbox. Click Save on the Setup Named Printers window, and now when users click print the document will be sent directly to the printer after generation.
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 documents window, there is now an option called “Print ALL Documents”. With the addition of this option there is now even more flexibility to print/email exactly how you want.
The Print All Documents, gives you the ability to tell Microsoft Dynamics GP when you want to actually print out all documents regardless if it was emailed or not. When you select E-mail and Print All documents the system will E-mail every document it can, then print all documents included in the range regardless if emailed or not. You can also select both ‘Print Document’ and ‘Send Document in E-mail’, and Microsoft Dynamics GP will E-mail every document it can, then print all other documents not setup for email.
The Microsoft blog post includes some examples of how this functionality can be used.
As Béat Bucher notes in the comments, this may be useful to clients who want to retain a PDF copy of the documents produced, even when they have been emailed.