Microsoft Dynamics GP 2013 Service Pack 1 – Released


Over at Microsoft Dynamics GP Support & Services blog, announcement of Microsoft Dynamics GP 2013 Service Pack 1 release has been posted.

The post also details everything about this SP and you would want to read it thoroughly to understand this release and its significance.

VAIDY

Where is my Custom Reminder window to add reminders to my GP home page?


I was reported with a very vague issue: user could not create a custom reminder from a smartlist. He received an error message as follows:

Snip20130417_3

Basically, below is the window which user is trying to open:

Snip20130417_5

Ideally, you would think that this window is a part of Microsoft Dynamics GP dictionary. But it is NOT. It is a part of Smartlist dictionary.

But trick here is, you cannot see this window listed on when you try to assign this window a particular Security Task using Security Task Setup window. Then, how? How would I give access to this window?

After around an hour or so, with several script logs and profilers misleading me, I found one interesting statement on SQL Profiler trace, that was executed when the user tried opening that window:

Snip20130417_6

Exactly after this SQL statement, the above error message was thrown at the user. Which means, I must focus my troubleshooting efforts on this table; DYNAMICS..SY10000. This table is simply called User Security.

When user tried to open Custom Reminder window, system checked this table and see whether this user has got access to a window whose resource ID is 1452 in dictionary 0 (which is nothing but product Microsoft Dynamics GP) inside company ID 1 (which is my production GP company).

I was always thinking about something in Smartlist (which is, without any doubt), but system was checking something else in a different dictionary altogether. I wanted to see the window in Microsoft Dynamics GP dictionary which is of resource ID 1452. Opened the DYNAMICS.DIC on Dexterity and checked it, only to realise with disbelief that it was referring to following window:

Snip20130417_7

I did not understand first. Why would it check something totally irrelevant from what user wanted to open? Why would it check access to this window, when opening a window in different dictionary? I have no answer to these questions.

But I just thought I would take a chance. I checked this user’s security task setup and found that Reminders window was not assigned. I assigned that window for this user as shown below:

Snip20130417_8

Tested whether he could open Custom Reminder. To my utter disbelief, IT DID.

So, if somebody is facing same issue and has already lost almost all your hair, here you have, a solution that would bring upon peace.

VAIDY

GP 2013 Home Page (Re)Design Horrors


Well, I could understand what you might think after reading the title of this post AND if you had read my previous post on GP 2013 Home Page Redesign.

I did admit that the redesign was kind of great for users. Ian Grieve had commented back with an important #FAIL factor of this redesign.

With that #FAIL factor, I just got one more to crib about. So lets list it:

  1. You cannot scroll within a frame. You MUST rely on mouse clicks(or a trackpad). You have no other option. (Thanks Ian, for your feedback with this point).
  2. If you ever want to realign the frames of a module (for instance Manufacturing), you can. But wait, that would stay ONLY TILL THAT SESSION IS ACTIVE. Once you log out from GP and log on back, your realignment is gone. Poof!!!

I am sure it is going to be highly irritating for users who rely mostly on GP home page.

And with that above statement, I now reverse my opinion on my first post.

VAIDY

Canada is Phasing Out Penny – How it affect GP Transactions?


Canada is so bold in phasing out Penny from its coinage. It is a very bold move. But how does it affect Microsoft Dynamics GP? How customers could adapt to this new situation?

Microsoft Dynamics GP Support team has answers to it. Read their post on their blog: Phasing out Penny in Canada.

Very informative and important post.

VAIDY

Possibility of Changing Account Format of COA


Over at Dynamics GP Support and Services Blog, Andrea Melroe describes on possibility of changing the account format of COA, rules involved, limitations and more important factors.

Excellent post and I am sure many GP customers and partners can learn a thing or two from this all important post.

VAIDY

Importance of PO Line Item Entry Dates


How many of you, PO users, use the following dates on a PO Line Item Detail Entry window in Dynamics GP?

Snip20130216_1

GP defaults all appropriate fields with User Date, but user can change it with actuals.

These dates are not mere dates. They offer critical means to improve vendor followups. And this could be done per PO line item. For instance, you can create a SmartList custom alert and add it on your GP home page (Reminder Cue) for those PO line items whose Current Promised Date is reached & PO line status is not Closed, Received or Cancelled.

It’s a pain, though, to make this dates entry happen. In my case, users always would say that it’s too much of a data entry and they already have something else as followup mechanism. But trust me, they are fooling themselves (first) and the company overall.

VAIDY

Document Attachment in Microsoft Dynamics GP 2013


I am a bit late on this topic. We already have many posts (including Feature of the Day – Inside Microsoft Dynamics GP) on this written by several community members. So instead of repeating it again, I am just adding pointers here to those posts.

To just brief what it is: Document Attachment is a new feature in Microsoft Dynamics GP 2013, which would enhance the way we currently deal with document attachments on a record. If you had sensed it right, yes it’s almost like OLE Notes, but much more than that.

This scores above OLE Notes, purely on grounds of three main factors:

  1. It doesn’t restrict itself to 32 bit architecture, like OLE notes container does.
  2. It is compatible with Web Client, but OLE notes is not.
  3. It stores the attachments on company specific SQL tables. You heard it right. It stores on database by harnessing SQL Server’s file stream, if I am not wrong.

More information about this (and how to use) could be read on below posts:

VAIDY

OLE Notes & GP 2013 Web Client – Mariano


It’s a bit hard to take it, but reality being the OLE Notes attachment feature won’t work on GP 2013 Web Client for current technical reasons.

Read his post here: OLE Notes and Microsoft Dynamics GP 2013 Web Client

That brings to us a new feature called Document Attachment in Dynamics GP 2013. This can be used instead of OLE Notes. It looks just perfect for me to start using it instead of OLE. Not just because of the incompatibility with web client, but also due to it’s robust features.

More can be read in my next post and also Mariano’s.

VAIDY

Microsoft Dynamics GP 2013 – Feature Videos


Awesome way to learn what’s new in Microsoft Dynamics GP 2013.

Inside Microsoft Dynamics GP (official GP blog) has posted a list of all Microsoft Dynamics GP 2013 Feature videos.

I personally checked out some videos and it’s highly informative, but have not gone thru’ the entire collection though.

Go ahead and explore the videos. I am sure you will start planning to optimise some of your business processes after seeing these new features.

VAIDY

Collections Management for Microsoft Dynamics GP Moves Out To Professional Advantage


Microsoft seems to be in a mood to give back all modules to its original developers. First it was Extender, then it was Audit Trails, Electronic Signatures, Risk Management Suite; now it’s the turn of Collections Management.

Errol Schoenfish, on Microsoft Dynamics GP official blog, announces that Collection Management for Microsoft Dynamics GP transits to Professional Advantage; it’s original developers.

Any licensing and module procurement would be affected only from June 1st, 2013. We have both CustomerSource and PartnerSource links to learn more about this transition.

Interesting…

VAIDY