Category Archives: GP Administration

Give Time to GP to complete it’s Process before an "End Task"

Posted on by

It was rightly put by Belinda about a Non-Responsive GP & Ending Task and I would like to re-blog the same point.

Often, people don’t understand that they are dealing with a Background Process in GP which is performing either a Posting or Transactional Activity and they straightaway do an “End Task”. This may result in following:

1. User Activity Lock
2. User Transactional Activity Lock – This is a bit critical, as it would not allow that user to even open any Transaction Entry window (which was open when they did the “End Task”)
3. Posting Process Interruption – This is hell critical, as it would keep the transaction in the middle; between Transaction Open and Transaction Posted. This is wreak havoc at times.

Like Belinda said, JUST WAIT. We all know that you are so busy with your Day-To-Day activities and do not have time to stare at GP for more than a minute, but sometimes you do have to understand that it’s a software and it just takes its time to complete a process depending on several factors.

VAIDY

SQL Roles for DYNSA

Posted on by

Nearly a week back, I was facing a weird issue. SDT Advance Options were not working in spite of enabling it.
David Musgrave, as always, came to my rescue and gave me some points to troubleshoot. The following are those points:
1. Is Advance Mode active? YES
2. Have you logged on as SA? NO. I was logged on as DYNSA
3. Does SA has sysadmin rights in SQL? YES it does. But DYNSA did not.
That’s the problem. DYNSA did not have required role(s) on DYNAMICS and Company DBs. It’s always a matter of concern for all SQL Admins to assign this sysadmin role to some user, but it’s not an issue if it’s allocated to DYNSA, since this user is created specifically by Dynamics GP for it’s maintenance.
Once I gave this role to DYNSA, I was able to access Advance Mode in SDT. 
Just make sure that, if you specifically use DYNSA for GP SQL Maintenance, then it must have sysadmin role attached to it.
VAIDY

Microsoft Dynamics GP 2010 Service Pack 1 – Available Now

Posted on by

This one’s very much awaited. And it’s out there for us to download.

More details on David’s Blog: Microsoft Dynamics GP 2010 Service Pack 1.

NOTE: Those who are on GP10 SP5 and not able to upgrade to GP2010, can now do that with GP2010 SP1.

Go ahead and upgrade GP with GP2010.

VAIDY

DynamicsGPAdm User Account for DynamicsSecurityService (Web Services)

Posted on by

Looks like I am bound to troubleshoot and maintain more today. But since that’s the case, I am having a chance to revisit what I have done while installing and configuring the current GP + CRM + Adapter + WebServices.
Having said that, I just cleared one issue and thought I would share post it.
When we install GP Web Services, a Local User Account called DynamicsGPAdm will be created and it will be added to IIS_WPG and IIS_IUSRS group. 
It was all fine till I found that the Dynamics Security Console did not show the necessary details. All I was seeing is a big red X error message and with that a message saying “Console is corrupted or invalid data, blah blah blah…”. Honestly, I was extremely scared to see this, as I was under the impression that everything was fine. I still believe everything was fine, because my GP10-CRM4 Adapter is working as good as it was for the past 2 months.
I had to revisit what I had done to install and checked all IIS Security & Services Security. Everything was perfect till I saw one glaring gap.
The Local User Account DynamicsGPAdm was created with our Server’s Password Policy enforced on it. That means, typically:
1. This account has to change it’s password when it logs on to the server for the first time. (Never happened till date).
2. Password expires in such-and-such days. (The number of days had in fact exceeded in this case).
3. Must meet the Password Requirements. (It obviously didn’t).
Perfect. I kinda hit it on the nail this time. 
I first changed the password of this User Account to meet the Password Requirements. Next I did as shown below:
Just make sure that once you install Web Services, the DynamicsGPAdm must be configured as above.
Significance of DynamicsGPAdm: This is the account which is configured in the Identity of DynamicsSecurityAdminServiceAppPool IIS Application Pool, which is the base for Dynamics Security Service and Console.
VAIDY

Microsoft Dynamics GP10 Service Pack 5 – Available Now

Posted on by

Details of this release is available on David’s, Mariano’s & Jivtesh’s articles, respectively:

1. Microsoft Dynamics GP 10.0 Service Pack 5 – David
2. Microsoft Dynamics GP 10.0 Service Pack 5 now Available – Mariano
3. GP 10.0 SP5 is Out (with lots of AA Fixes) – Jivtesh

David & Jivtesh details us about the core fixes or changes in SP5.

One important point that I have to highlight is: The Incompatibility of SP5 to get upgraded to GP2010 RTM. We have to wait till GP2010 SP1.

People who are planning for a GP2010 Upgrade must tread caution before applying this patch. Go thru’ the SP release notes and FAQs to make sure you really need it for your GP10 environment till you move on to GP2010.

VAIDY

Item Qty Allocated, Oh But Actually Not…! – Issue & Fix

Posted on by

This took my life past 2 days and yesterday I was so relieved to have to fixed.

Issue: For a specific set of Inventory Items, Item Stock information was showing up incorrectly. The Qty Allocated is showing some units, but the user swore on everything in this world that it’s not possible. Well he had a point to substantiate his argument. Upon drilling down from Qty Allocated in Item Qty/Site Maintenance (or Inquiry), nothing showed up.

Troubleshooting Steps:


1. First thing, I checked is whether any of these items had been used on a Service Call Parts Entry. If that’s the case, then Qty Allocated will be of that respective units, but it won’t be listed in the Allocated Documents list when we drill down. Result: NONE.

2. Ran a reconciliation on these items, hoping that it would clear any unnecessary Qty Information. Result: NONE.

Now that’s a real mess. Need some quirky way to find the cause & solution.

3. [CAUTION: Do not try this out unless you know what you are doing.] I took a backup of Live and restored it on Test. Then I updated the Quantity Information in IV00102 table manually based on User’s inputs. BUT, decided to run the reconcile since I was not sure about this manual update. Result: It reverted back whatever I had updated. And back to square one.

GREAT…!!! The above step at least confirmed that there IS A VALID DOCUMENT which is holding this quantity.

4. Queried SOP10200 (SOP Line Work) table to see the lines containing one of these items. There was one SOP Order, which was doubtful. Queried SOP10100 (SOP Header Work) for that Order. THAT’S IT… I FOUND IT…

Cause: The erroneous SOP Order had not been either posted or saved properly. The reason may be due a GP Application Hang which would have forced the user to kill the session. Once we kill the session when we are entering SOP Document, SOP10200 table will contain the records without any issues, but SOP10100 table would lose all the information that we had entered other than SOP Number, SOP Type and SOP Document ID. Not even Customer ID and Default Location.

These items had been allocated on this Order technically, but since the user would have killed the session, he thought he had to reenter the document and did so. Didn’t face this issue, till he ran out of stock.

Solution: I released this SOP Order for the user to retain/delete so it would release those Allocated Units from our Inventory. Check my article, SOP – “This document has been posted.” Error & Resolution, on how to release such SOP Documents.

VAIDY

Upgrading 150+ Companies – Now that’s A REAL UPGRADE

Posted on by

Mariano quotes us from Randal Mayer on How to Upgrade 150+ GP Companies.

I have never even imagined more than 15-20 companies, and this advise IS needed for all of us.

And this post also answers a major question: Is Dynamics GP really capable of handling loads and transactions? Now a customer having 150+ companies in Dynamics GP 9.0. And we have already got Dynamics GP 2010 with SQL Server 2008 R2.

That’s a lesson to all who doubt GP’s capability.

VAIDY

GP, ODBC DSN & 64 Bit Systems

Posted on by

This post is long pending, since I had worked on the topic around 2 months back.

According to GP Installation Instruction, To set up an ODBC data source, enter the name you assigned to the SQL Server when you installed Microsoft SQL Server. A data source name called Dynamics GP also is created using SQL Native Client. If you don’t want to set up an ODBC data source, mark the Do not create a data source option.

It’s very handy (and recommended too) to create the ODBC DSN thru’ GP Installation, when we install GP on a 64 Bit System. We all know that GP is a 32 Bit Application. When we install GP on 64 Bit System, it gets installed with 32 Bit Compatibility.

Typically, on a 64 Bit System there are two ODBC Data Source Maintenance wizards available. One is for 64 Bit and other for 32 Bit. What you open from Control Panel -> Administrative Tools (or Start -> Run -> ODBCAD32.exe), is nothing but default 64 Bit ODBC DSN Maintenance wizard.

If you manually create a System DSN for GP, GP Application does not recognize this DSN at all. We have to actually create a System DSN for GP in 32 Bit ODBC DSN Maintenance wizard, which is accessible from the following path:

C:\Windows\SysWOW64\odbcad32.exe

We have to explicitly open this application from the above path and create System DSN for GP there.

Trust me, both look exactly the same. Application Name ODBCAD32.EXE is also the same for both. But location & compatibility factor is different.

In case, you are stranded when your ODBC DSN is not listed in GP’s Welcome Screen Server Dropdown, on a 64 Bit System, rest assured that you have not created DSN on the correct DSN Maintenance wizard.

VAIDY

How to Configure Word Templates in GP2010 – David Musgrave

Posted on by

This article seems like an extension to what Inside Dynamics GP explained us on GP2010 Word Templates (Feature of the Day Series). But that extended information is what matters for us. You may miss this information if you are not a Developer. Rather it may not sound relevant for you in that case.

David explains How to Configure, and most importantly, Where These Templates are Stored. Quite interesting.

Thanks David, for the insight.

VAIDY

CBM – User [username] is busy with batch [batchname].

Posted on by

As promised in my previous article, here we go.

This is another frequent error message that Users get when they enter CBM Manual Payments in a CBM Batch:

CAUSE: There will be an Activity record inserted when you open a Batch for Payment Entry, in the table CB300006 (Display Name: Batch Entry Records Locked). This does not get cleared at times.

SOLUTION:

I. Follow the Resolution Steps I & II from this article: http://www.vaidy-dyngp.com/2010/04/cbm-checkbook-checkbook-id-is-already.html.

II. Run the following query once above steps are completed.

DELETE CB300006 WHERE USERID = ‘[username]’ AND BACHNUMB = ‘[batch number]’

We are good to go now.

VAIDY