Posts Tagged With: Dynamics GP

GP Power Tools build 22 hotfix available for download (May 02, 2017)

Good day GPUGgers !

As many of you may know (or not), I’m an avid user of GP Power Tools (former Support Debugging Tool, aka SDT) since the tools was launched in 2006, and recently worked very closely with David to bring fixes & enhancements to the product, as I’ve been running Windows 10 since a few months in production on my laptop, where I’ve GP 2013 R2 & GP 2016 R2 (in Test) clients installed.

Windows 10 having changed quite a few things in regards of screen management and multi-monitor setup, plus a few other small hindrance (like the invisible window frames), it has been quite an interesting journey in the past months.

Here are the changes that were brought into this update for the build 22:

Version 16.00 build 22 (Released 02-May-2017) Installer: 16.00.0022.4

  •          Updated Trigger Setup window to stop asking to reset script when changing Menu Trigger text.
  •          Updated Company Color Themes to use User Display Preference settings for Link Fields and Required Fields.
  •          Updated Company Color Themes to override User Display Preference color settings when needed for inverted themes.
  •          Added fix for Dynamics GP Bug where Apply button on User Display Preferences only works one time.
  •          Added additional checks to ensure correct window handle is used when repositioning and retitling windows.
  •          Update default values for Email, Logging and Administrator settings to enable recommended features for new installs.
  •          Adjusted window repositioning code when capturing window handle for 3rd party products to use foreground window method.

One of the important updates for me is about the handling of the windows, as I’m running a setup with 3 displays (Laptop LCD + 2 external 22″ monitors), and I think that nowadays this is a pretty common setup. Since the Windows position memory feature was introduced in build 22 by David, I had a few issues where my other application windows (Outlook, Office, Explorer) would randomly be snapped to the the lower right or left corner of the display it was showing, even it was not related to GP, and this specially annoying when you had a larger posting batch going on your GP client, as you couldn’t work with other windows without having them snapping away under your mouse :-).

Based on the feedback I provided to David, he was able to correct his code and now checks for the proper identification of the window’s title, and if that title does not match the expected value, the code will stop the Automatic Window Position check (this can also happen with 3rd-party ISV products, though part of GP, they are not recognized as such).

Thanks to a feature added a while ago, but not fully used yet,  it provides  an additional DEX.ini settings that allows you to trace in detail what’s going on with your GP forms while your client is active. That helped us to identify the issue caused by non-GP windows.

MBS_Debug_LogWinData=TRUE

Be careful to not leave that option on longer than it would be necessary for you to debug a problem with some forms in GP, because it will fill up the GPPT log quite quickly.

Each GP form/window entry would look something like this (extract from the GPPT log):

2017-05-05 09:44:07 : ** Start of Log **
2017-05-05 09:44:07 : Version: 12.00.0022, Last Modified: 02-May-2017.
2017-05-05 09:44:07 : Automatic Trigger Mode Trigger CPY_DIR_DEPOSIT Unregistered
2017-05-05 09:44:07 : Automatic Trigger Mode Trigger VENDOR_EFT Unregistered
2017-05-05 09:44:07 : ** End of Log  **

2017-05-11 08:02:24 : Automatic Window Position    : window UPR_Employee_MNT of form UPR_Employee_MNT.
2017-05-11 08:02:24 : Dynamics GP Application Pos  : (114,57), Content Offset: (202,167).
2017-05-11 08:02:24 : Dynamics GP Zero Position    : (316,224).
2017-05-11 08:02:24 : Primary Desktop Actual Size  : (1680,1050), not used if per monitor setting available.
2017-05-11 08:02:24 : Primary Desktop Work   Size  : (1680,1010), not used if per monitor setting available.
2017-05-11 08:02:24 : Monitor Desktop Actual Pos   : (0,0) - (1680,1050), Size: (1680,1050), Device: \\.\DISPLAY1.
2017-05-11 08:02:24 : Monitor Desktop Work   Pos   : (0,0) - (1680,1010), Size: (1680,1010).
2017-05-11 08:02:25 : Monitor Desktop Physical Size: (1680,1050), DPI Scaling: 100%.
2017-05-11 08:02:25 : Dexterity reports Window Pos : (9,33) - (656,489), Size: (647,456).
2017-05-11 08:02:25 : Windows reports Window Pos   : (332,257) - (981,771), Size: (649,514).
2017-05-11 08:02:25 : Windows Window Scaled Pos    : (332,257) - (981,771), Size: (649,514), use instead of Dexterity settings.
2017-05-11 08:02:25 : Windows Window Border Offset : (7,3).
2017-05-11 08:02:25 : Adjusted Dynamics GP Zero Pos: (323,224), adjusted horizontal position for border offset.
2017-05-11 08:02:25 : Updated Dexterity window Pos : (9,33) - (658,547), Size: (649,514).
2017-05-11 08:02:25 : Dexterity Window + Offset Pos: (332,257) - (981,771), Size: (649,514).

Quite interesting and helpful when you’re an administrator and trying to figure out what’s going on with your GP client, especially if you run that on a shared environment like Citrix or Terminal Server.

If you’re already a GPPT subscriber, go and download the latest build 22 from the Mekorma site and install it. If you’re not a GPPT user yet, I encourage you strongly to grab a copy and ask for the free 30 Days trial key. You’re going to love it.

Until next time, have a great Day!

@GP_Beat

Categories: Citrix - TS, Dynamics GP, GPPT - GP Power Tools, System Administration | Tags: , , | Leave a comment

First GPUG local chapter meeting for Montreal QC

Friday Nov. 21st was the first local GPUG chapter meeting held in the brand new offices of Microsoft downtown Montreal. The meeting was scheduled from 8:30am to noon, but I showed up there five minutes before eight to be sure that everything was ready in time. I arrived at the door at the same moment as the nice lady from the reception and we had a short chat about the company I’m working for, which she found very interesting  (who’s not fascinated by CSI Miami😊?), before she led me to the room that was reserved for the meeting.

The New Microsoft Offices in Montreal

The New Microsoft Offices in Montreal

 

The new conference rooms are really nice and the setup was quick and easy (kudos to that new control console for the projector in form of a mini touch pad). The first attendees arrived already ahead of time at 8:00 and were promptly headed to the room.. At 8:30 we had 4 attendees in the room, out of the 8 that had registered to the meeting… so we waited a little moment more, starting to chat about GPUG and the recent Summit in St-Louis. Shortly after arrived the catering service with coffee, some pastries and fruits.. Thank You GPUG for this sweet attention.

As no other participants showed up, we decided to start the meeting and went on with the opening of the session and starting the discussion about kicking off a new local chapter in Montréal. The discussion went on well for about 20 minutes to explain what the purpose and the benefits of a local GPUG Chapter are.

After that brief intro, we moved to the actual meat of the morning, an educational session about Disaster Recovery Planning for Dynamics GP, a session that I had presented at the GPUG Summit in St-Louis last month. The PowerPoint material can be found here : GPA01-GPUGSummit2014_SessionDeck_DisasterRecovery.

After the session presentation and a short cofee break, it was time to have a brief review of the previous month’s GPUG Summit 2014 in St-Louis, MO. The video below will provide you a quick glimpse of what the event was like.

Here is also a short presentation of the next GPUG Summit 2015 destination, the beautiful Reno Lake Tahoe in Nevada.

RenoTahoeLogoBadge_CMYK_Orange_VisitRenoTahoe_REV-Outlined-Fonts-w-URL-(1)

 

The meeting went on with the presentation of member’s showcase, as I made a half-hour introduction of Ultra-Electronics Forensic Technology Inc., also known as FTI. I went thru the history of the company and our current position in the market, with a presence in more than 60 countries around the world, and being a leader in the domain of ballistic identification. More about FTI can be found here : http://forensictechnology.com/about/

 

Ultra Electronics acquires Forensic Technology

I think I was able to capture the audience with the presentation of our company, especially when considering that most people associate Forensics with the CSI TV show (see more about this here). However, not many people know that the ballistic identification system that is used in the TV show is really an full working IBIS station that FTI sold to the producer many years ago. For those who want to know more about our company, there is a full load of brochure to download from our site.

As we came to the end of the morning, it was time to wrap the meeting and head back to our respective offices. My feeling is that it was a first step into what I hope will be a long successful local GPUG Chapter. Despite the fact that we were only five people attending this first meeting, I’m confident that we’ll be able to build a strong chapter. From the discussion that I had with one of the present partner, there seems to be way over 300 customers using Dynamics Great Plains in the greater Montreal area, so there is definitely room for more members :-).

For now, there were no nomination to fill the position for the local chapter, but I welcome any member to register and fill for a position.Below is an excerpt from the GPUG Chapter manual :

Local Chapter Leadership Roles
Persons leading Chapters must be Microsoft Dynamics GP Users. The roles defined below, provide guidelines
for what common duties are necessary for a smooth running chapter:
Chair Person

  • Oversees delivery of and facilitates Chapter Meetings
  • Serves as a point person to GPUG and represents the chapter
  • Communicates final agenda, location, schedule and other items needed to execute the meetings
  • Helps find and selects subject matter experts who can help present
  • Oversees survey/feedback/continuous improvement of their chapter
  • Provides feedback to GPUG on topics, presenters, member participation
  • Participates in GPUG Chapter Leadership calls and training when possible

Co-Chair Person

  • Will assist in sharing duties with Chair Person

Vice Chair for Membership

  • Oversees chapter membership roster for accuracy and completeness
  • Welcomes attendees, updates attendance reports and submits to GPUG
  • Generates creative ideas to drive User and Partner attendance
  • Participates in GPUG Chapter Leadership calls and training when possible

Vice Chair for Communication

  • Oversees communication to members at a local level via GPUG Collaborate, social media, etc.
  • Assists in driving attendance by utilizing the GPUG membership directory, partners, ISVs
  • Document activities of meetings, presenters and topics and record Chapter history
  • Submits summary of meeting for GPUG Magazine (photos are great)
  • Participates in GPUG Chapter Leadership calls and training when possible

 

The following openings are available :

  1. Co-Chair Person
  2. Vice Chair for Membership
  3. Vice Chair for Communication

GPUG has a great wealth of material to support the regional chapters and provides also the logistics to help organize the meetings, so there isn’t really a giant amount of prep work, except to plan at least two presentations for each meeting.

The 2015 Meeting Dates have been set and should help everyone to plan accordingly their attendance :

1. Wednesday Feb. 18th, 2015
2. Wednesday April 15th, 2015
3. Wednesday Aug. 19th, 2015
4. Wednesday Nov. 18th, 2015

The meetings for Q1/Q2 will be held in Microsoft’s offices downtown Montréal, from 8:30 to Noon again. For the second part of the year, we might be able to have them organized at one of the members corporate office and take the opportunity for a member showcase.

Some of the 2015 Meeting Topics that were suggested:

1. GP 2015 & GP 2013
2. GP Web Client
3. Support Debugging Tool
4. BI & Reporting/Project Accounting

 I want to Thank again here the people from Microsoft Canada in Montreal, especially Stephan Mondoux for inviting us to use their brand new meeting rooms, and of course Whitney Derks & Jennifer Dufresne from GPUG for arranging the catering. Thank you also to the participants that took some time off from their work to attend this event.

The goal for next year is to spread the word and try double the number of attendees we had for this first meeting. Until then, I wish everyone a Merry Christmas and a Happy New Year.

Your truthfully  chapter Chair Person.

PS: Bellow is the link for the regional GPUG Chapter certificate.

Canada-Quebec_GPUG 2014 Chapter Certificate

Categories: Dynamics GP, GPUG | Tags: , , , | Leave a comment

ALS Ice Bucket Challenge

So here I am… for almost a week now there has been a whole social rumble that went around the globe and hitting Twitter & FB like crazy… Though this doesn’t seem really related to Dynamics GP or ERP at all, it hit me actually because some fellow Dynamics GP friend and blogger, MVP Jivtesh Sing nominated me and another great GP buddy, David Musgrave, to take the challenge of the ALS Ice Bucket..Seems nobody can escape it, as it hit also Microsoft’s founder Bill Gates and the current MS Business Solutions VP, Kirill Tatarinov.

First of all I thought that I’m not going to participate in those silly / crazy social ring events that go around and come back once in a while… not me, I’m not that kind of guy, nah not me… but this morning a whole new information came to my hear.. I very close friend of mine that I work with was in the hospital last night to visit her nephew. As I’m a great admirer of people that have achieved something in life and have great respect for my colleague too, I was really touched by this story and decided to take the challenge. Listen to this quick video of her nephew, who happened to get on the news last night on CTV channel. He has been diagnosed in 2005 of ALS and is now in his 9th year, which is extreme considering the disease. Most people don’t live up to the 4th or 5th year.

And I already did posted my contribution to the Canadian ALS Support Organisation and as of this morning they had passed the mark of 500k$ raised so far with an objective of 1$mio… By the time I’m writing this, the mark has already passed 780k$ !!! less than 12 hours to raise 250k$… lets go and break that million dollars goal.

And now the  funny part 🙂

It’s now my turn to nominate someone, and to keep the ball rolling inside the Dynamics GP community, I’m challenging here Mark Rockwell from Rockton Software, Erroll Schoenfish from Microsoft, and to send back the ball to the southern hemisphere, our national Canadian astronaut Chris Hadfield who happens to be in Australia this week (Chris actually has no connection with Dynamics GP, but I love & admire what he does).

I’m looking forward to see your own recording and who’s next on the list  🙂

Have fun !

Categories: Fun, GPUG, News | Tags: , , , | 5 Comments

Use the Support Debugging Tool to tackle GP security issues

Last week our HR department people had training about the HR module in GP… it was a very formal training of two hours from an external consultant, and as such it wasn’t going very deeply into the subject. But enough to say that he showed our users about some of the hidden gems in the HR module that they weren’t even aware of: the Letter Writing assistant function.

Since I had given them access to the Fabrikam Company in GP for evident privacy purposes, I had also created some training users for the sake of this exercise, not wanting them use their regular GP users.

Having assigned those users regular GP Security role for the HR module (this would likely be HR_MANAGER & HR_GENERALIST), they were supposed to get covered for almost everything… Think so? Not really… In their attempt to create default Security Roles in GP to cover most of the functionality in GP, Microsoft sometimes didn’t checked if all the roles where properly assigned to corresponding tasks, and that those security tasks were also related to actual existing resources in the system…

We all know that by default GP has numerous Security Roles (> 50), Security Tasks (> 450) and Resources (> 9000), resulting in thousands of security combinations in the system, that it is very difficult to test all combination and make sure nothing was missed.

Now what to do when you hit the infamous error message in GP about denied access to resources?

Dynamics GP Security Denial Message

Dynamics GP Security Denial Message

Call your system Administrator of course :-)… but what if you are the system admin? The answer will be to use the Support Debugging Tool (SDT in short). This tool is free for every Dynamics GP customer and you’ll find more details about it on the web (http://aka.ms/sdt). If you don’t have it installed now, you’ll have to contact your Microsoft partner and ask for the latest release for your GP version.

The tool was written and developed by my good friend David Musgrave that works for Microsoft Australia. I’m not going to enter into the history behind the SDT; there is plenty of links on the site.

Where to Start with the SDT?

Once you have the SDT installed into your Dynamics GP client, you’ll get and additional menu entry under your main GP menu >> Tools >> Support Debugging Tools (CTRL-D). From the SDT main menu you can access the user manual by hitting F1 and open the PDF document (assuming the installation was done properly and the PDF was copied into the program folder).

I encourage you to read thru the guide, it is very well written and explains all the aspects of the tool. Don’t be afraid by the length of the document (about 200 pages), the most important information is covered in Chap 2 & 3 in about 40-50 pages. We’re going to focus today on the Security Profiler (Chap. 2, pp 52-59), and see how this tool can help you to identify in about 5 min. what is causing your denial of access in GP.

Warning: the content and usage of the SDT can be dangerous if used inappropriately in Dynamics GP. I always suggest to test this out in a TEST environment or TEST company before your actually apply this to a production system. Over the course of the time, when you become more confident with the tool, you’re going to love it and install it across all your GP clients. This will make your administrator life much easier. Also, most sensitive functions of the SDT are protected by the system password, and assuming that you have set one, it will ask you every time for it before letting you access a critical function.

10 simple steps

That said, let’s start with the Security Profiler and see how we can identify in 10 steps the security issue.

  1. Start the Security profiler from the SDT ‘Debugger’ menu:  Debugger >> Security Profiler
    This will open a new form that you can minimize to the bottom of your screen. I suggest creating a shortcut to the security profiler; it’s a tool you’re going to use often.
  2. Go to the resource that you want to access with the user that is denied of it. In our example we want to access the Applicant form in HR and want to launch the “Write Letters” assistant, in order to use the ‘Prepare an Applicant Letter’ wizard. Click on the menu until you hit the security error message.
  3. Restore the Security Profiler window and locate the last line…

    Security Profiler window (regular user)

    Security Profiler window (regular user)

  4. Use the Export menu option to save the result of the tracing to an XML file (best place is the shared Data folder on the server, thus you can open that XML file from another GP client with a Power User.
  5. Either login in the same session with a different user that has access to GP Security and preferably a system admin, or use another client from a different system and has access to the saved XML file.
  6. Import the XML file previously saved into the Security Profiler and select the line that has the red denial sign in front of the line. With higher privileges, you now get another option to check the security settings.

    Security Profiler window (Power User or SA)

    Security Profiler window (Power User or SA)

  7. When you click on the Security button, the SDT will open a window and show you a tree-like view of the resource that was denied.

    SDT Security Tree View

    SDT Security Tree View

  8. Expand the left side tree labeled “Access Granted” and drill down to the lowest level to get a list of the Security Tasks and Roles assigned to the required resource.
  9. On the right side you see a list of the users with a small box checked (which means access is granted to all companies, grey would mean only partial company access and blank no access at all).
  10. Double click on the user name to open the User Security Setup form of GP. Scroll down until you get to the Security Role that was displayed in the Security Information pane on the left side and check the box on that line. Save the changes for that user and ask him/her to log back into GP and try to access the denied resource.

Et Voilà! You just solved your first security mystery in Dynamics GP.

This is only one facet of the multiple functions that the Support Debugging tool can offer. Go thru the user guide and familiarize yourself with the other functions.

Good luck with your daily Dynamics GP administration.

Categories: Dynamics GP, SDT - Support Debugging Tool, System Administration | Tags: , , | Leave a comment

Tracking User activity in Dynamics GP

What is it all about?

There were lots of inquiries recently following a forum question about how to deal with the user’s ACTIVITY table in Dynamics GP. Some company are adding user licenses when they feel being short or having too much users complaining about the inability to login into GP, because all the licenses are used up in the system.

Now there is always a question that comes up in this situation: how many of my GP licenses are really in use and how much are currently stranded users that have been disconnected by the system or closed on the ‘hard’ way (i.e. killed their GP session) the client because it was not responding or they were stuck in a loop not being able to logoff properly.

The Way Dynamics GP tracks the user licenses is through the table DYNAMICS..ACTIVITY in the system database of the SQL server. From the registration key, Dynamics know how much user licenses are granted to this server and thus tracks the count in that table. Now when user proceed with normal login / logout, the table gets updated every time and puts a time stamp in the fields  LOGINDAT & LOGINTIM in the form of a long Date string. This is a way to know since how long a user has been logged in GP, but doesn’t tell you if the user is actually working or not in GP actively. This can only be achieved by monitoring closely the processes running inside of GP itself. Some 3rd party tools like the Rockton GP Toolbox and Willoware GP Powerpack offer that kind of functions.

Dynamics GP offers a way to track the login/logout activity in the system itself, but that doesn’t help more if looking for ‘inactive’ users or stranded logins. This would only serve as a kind of statistics log. To enable the user login/logout tracking, go to “Microsoft Dynamics GP menu >> Tools >> Utilities >> System >> Activity Detail” and select the appropriate range of users or company to enable / disable the login/logout activity.  The table that is tracking the activity is SY05000 from the DYNAMICS system DB.

Now what to do? How to get rid of stranded users?

A simple way to get rid of stranded user’s login in the ACTIVITY table is to delete the entries from that table, after you make sure the user is really no longer working in GP.

In a usual  9-to-5 office environment, this is pretty easy to achieve, because most of the GP activity will take place during those office hours, thus making it easy to determine who is working or not and I doubt that you’ll have a lots of users working off-hours let’s say around 11PM or even 1AM in the morning.

But you don’t want to setup your clock and get up in the midst of the night to flush your ACTIVITY table, so your SQL Agent is your best friend in this sense.  All you have to do is create a scheduled job that would run a script and clear out the table.

What I do is filter the DELETE action and leave out user logins that I know might be used (i.e. the ‘sa’ user account or my own one, because I might doing some nightly maintenance on GP).  The script for the job would look like this:

Delete from ACTIVITY
       where
LOGINDAT < GETDATE()-1 and  –> optional, cleans out only logins older then 24hrs
       (USERID <> sa or USERID <> xxxxx)

Your Step 1 for the job would look like this below. Schedule it to be run every night before you do your SQL backups routine (or later if this happens to be earlier in the evening). Mine runs at midnight. Make sure you make it run under the DYNAMICS Database.

Setup a CleanUp Job in SQL Management Studio

Setup a CleanUp Job in SQL Management Studio

To complete this, I use also a stored procedure that I run on schedule one or two hours before the cleanup task and that sends me the list of the stranded users in the ACTIVITY table. The code for this makes usage of a send-mail feature in SQL that needs to be enabled in order to work (see comment from next chapter).

The code goes like follow:

USE [master]
GO

/****** Object:  StoredProcedure [dbo].[usp_GPLoggedUsers_overtimed]    Script Date: 2013-04-04 08:01:49 ******/

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

–=============================================
— Author:           < Beat BUCHER >
— Create date: 2009-09-08 / 10:22 /
— Description:      The script validates which user account is logged in Dynamics GP
—                   since more then 750 min (12,5 hrs) and sent the report by e-mail
–=============================================

CREATE PROCEDURE [dbo].[usp_GPLoggedUsers_overtimed]

AS
BEGIN

       — SET NOCOUNT ON added to prevent extra result sets from

       — interfering with SELECT statements.

       SET NOCOUNT ON;
IF EXISTS
(
select datediff(mi,logindat+logintim, getdate()) as DURATION, –convert(datetime, convert(varchar(15), GetDate(), 114), 114) – LOGINTIM as DURATION,
USERID,
              CMPNYNAM,
LOGINDAT,
LOGINTIM

              from DYNAMICS.dbo.ACTIVITY
where datediff(mi,logindat+logintim, getdate()) > 750
)

              BEGIN
DECLARE @SQL varchar(8000)

              SET @SQL = ‘select datediff(mi,logindat+logintim, getdate()) as DURATION, USERID,
CMPNYNAM,
LOGINDAT,
LOGINTIM
from DYNAMICS.dbo.ACTIVITY where datediff(mi,logindat+logintim,getdate()) > 750′

               –print @SQL

               EXEC msdb.dbo.sp_send_dbmail@recipients = ‘xxxx@domain.com’,
@subject = ‘Users Logged in beyond limit’,
@body = ‘Attached is a list of users that have been logged in beyond the limit’,                 @query = @SQL,
@attach_query_result_as_file = ‘TRUE’,
@query_result_width = 250

      END

END
GO

Change the @recipients variable content to fit your needs accordingly.

I’m constantly hitting the max user license limit. Is there a way to monitor this?

Yes there is. This actually implies some setup on the SQL server side, since by default the function to send out e-mails is disabled from SQL 2005 and up (SQL 2000 still had it enabled by default, but not much systems are running on this old SQL version today). This goes behind the topic of this article, but you have to make sure with your DBA or SQL admin that the sp_sendmail stored procedure is enabled and proper notification and SQL-mail is configured in the server. There are plenty of SQL forums and sites that discuss this in detail.

Since this blog environment doesn’t allow uploading attachments, I have to explode the entire code here in the text.

declare @limit int, @current int
declare
@msg varchar(80)
declare
@threshold decimal(5,2)

set @limit = 16  /* current Great Plains limit – unable to extract from reg keys of table */

set @threshold = 0.85

select @current  = count(*) from ACTIVITY

print ‘Current = ‘ + str( @current)

if @current
>= @limit begin
set @msg = ‘Great Plains user limit of ‘ + str( @limit) + ‘ has been hit.’

       exec master.dbo.sp_sendmail
@recipients
= ‘xxxxx@domain.com;’
, @subject = ‘Great Plains User limit hit’

 — @message = @msg

end
else

if @current >=( @limit * @threshold  ) begin

       set @msg = ‘Great Plains user connections (‘ + str( @current ) + ‘) exceeds ‘ + ltrim(str( @threshold * 100)) + ‘ % limit of the available ‘ + str( @limit) + ‘.’

        exec master.dbo.sp_sendmail


@recipients = ‘xxxx@domain.com;’
, @subject = ‘Great Plains User count exceeds threshold’
, @body = @msg

end

 

The best way to make this work is to put this in a SQL Job that will be scheduled to run every 5 minutes or so (adjust to your needs) during the business hours. In my setup below, there is another step to collect stats information about the login activity in GP, which allows me to draw some nice charts in Excel. This too goes behind the topic of this article, but I can cover that in a later blog post if there is some interest for it. Just let me know by leaving a comment at the bottom.

GP_UserCountLimit

I hope this will help some users to get better in control with their Dynamics GP user licenses. As mentioned at the beginning, 3rd party tools have way more to offer and can be very handy to handle such situation, but they come with a price tag $$$$ attached, whereas those proposed solutions are free to implement.

I had worked for a company that didn’t wanted to understand the benefit of buying a product like Rockton’s Toolbox to kick out inactive users from GP and rather spend a lot of their precious dollars by adding new GP user licenses… When I left the company, the user license count was up to 48 users and we didn’t had much more active GP users then my current  company, and we run with only 16 concurrent licenses, barely hitting the maximum (it happened maybe 3-4 times since I joined the company).

My total user count in GP is 137 users from which about 40 are login into GP on a regular basis (more than a dozen times within the last 6 months), and about 20 heavy users, almost every day in GP. I never run out of licenses with the help of the Rockton GP Toolbox. I mention this product because it is the one our company bought several years ago when it was still called OmniTools, but other products in the market is doing a similar job.

From what I have discussed with Microsoft during my last Convergence participation, we may soon see a built-in function in GP to manage that kind of issues (i.e. inactivity timeout and maintenance lockout from the system in order to carry on upgrades), so cross your fingers.

Enjoy and start to work on a better control of your GP environment.

Categories: Dynamics GP, System Administration | Tags: , , , | 4 Comments

Is it Possible to Change the Account Format for the Chart of Accounts in GP?

Andrea Melroe wrote a nice post over on the Dynamics GP community blog about this topic. Recently we faced the situation were we had to merge or rename numerous of your GL accounts in the various GP companies we have and it was affecting equally the different segments that were setup at the original system implementation. After the whole exercise, we went down from some 1800 GL accounts to less than 1200, that’s more than 30% reduction.

We used the two different approaches, depending on the amount of account that were to merge/rename : either the Excel / CSV import method, or the direct input of the segments to change. Both work equally fine and the decision to use on or the other only depends on the amount and type of changes you have to carry thru the system.

Remember to execute all those action while you’re alone in the system and with the ‘sa’ user only. Read the complete post here : https://community.dynamics.com/gp/b/dynamicsgp/archive/2013/01/22/is-it-possible-to-change-the-account-format-for-the-chart-of-accounts-in-gp.aspx

Categories: Dynamics GP, PSTL | Tags: , , | Leave a comment

Create a free website or blog at WordPress.com.