Take company offline

Today’s #TipTuesday is a feature that was introduced in GP 2013 R2: taking a company offline for maintenance or other periodic routines.

What is it?

This is a feature under the Administration page > System > Utilities area. The purpose of it is simply to prevent users from logging into one or more companies so that you can be working in it exclusively. Why might you do this? The most common reasons would be some kind of maintenance like running checklinks, or some routine like year-end close, or some kind of utility operation like using a Combiner/Modifier tool perhaps.

How to use it

First, navigate to the Administration page > System > Utilities > Take Company Offline.

Insert one or more companies from the left hand list of companies in your system, into the box on the right hand side of the window. In my example, I’ve moved over my Test Company. Let’s say I want to refresh the Test Company so I want to keep people from logging into it while I do that.

I could change the “Offline Message” but I chose not to for this example. This wording is what is displayed to the users selecting an offline company when they log in.

What happens if a user is already logged in?

If users are in the company(ies) you are trying to take offline, you will get this warning message:

At this stage, you can click Yes to open the Send Message window to send a message to those users who are logged in.

When you do this, it will automatically filter the window to the “Users in Offline Companies” so you don’t bother your other users. In this case, I typed out a custom message and clicked on Send.

After a brief delay (10-20 seconds perhaps?), my test user “jen” got the notification message as expected:

At this point, note there is no “automatic” anything, the user is not kicked out of the offline company, so it would be up to you, the administrator to ensure your users get out of the company you want to take offline. The pop message is simply an alert.

What happens if I try to log in?

Naturally, I wanted to test a couple of different scenarios to prove how this works with different settings. My “jen” user is a normal user inside of GP in terms of security (i.e. not a POWERUSER). However, that login did have “sysadmin” in SQL (server role).

So, when “jen” tried to log into GP, here is what happened:

First, the company shows “*Offline*” in the company drop down list for visual verification for users. I selected it anyway, and clicked OK.

I was prompted with this message: “Do you want to continue and log on to the company?”. I clicked Yes and sure enough, I could log into the offline company.

But wait a minute… there is no user set to have “offline” access in this company, so why did that work?

The simple reason is “jen” has the sysadmin server role in SQL so Dynamics GP must be looking at that and allowing those users to log in even with no specified “User with offline access” in Company Setup. That’s a good thing. If you don’t know which user has offline access, simply log in with ‘sa’ briefly or any other GP login that has SQL sysadmin rights in the back-end. (Edit: per a comment on this article, users in the POWERUSER role in GP also have access to offline companies).

What does a regular user see?

Here is what message a normal user would see:

Normal users, i.e. users who are not sysadmins in SQL and not the user who has offline access, see this message with only “OK” as an option and no ability to log in.

That’s it for this one… pretty straight-forward!

3 thoughts on “Take company offline

  1. Reply
    MARIANO M GOMEZ BENT - October 23, 2018

    I like this feature, but unfortunately this and the whole login experience are not integrated with company databases being offline in SQL. It would be a nice feature to have.

    1. Peter Kwasnicki - November 12, 2018

      That would be nice Mariano if GP would show companies offline in SQL as also offline in GP. Of course, there are many times when you want the company offline in GP, even if it’s not offline in SQL.
      Also, just to add slightly to the article, the only users who can log into a company once it’s offline are: the GP user listed in the “User with offline access” box, members of the GP POWERUSER role, and GP users who are members of the SQL sysadmin role.

    2. Jen Kuntz - November 12, 2018

      Hi Peter,

      Thanks for the comment. I have edited the post to add POWERUSER as a user who can use an offline company. I agree that both you and Mariano that it would be nice to be in sync with SQL “offline”.


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to top