Weekly Topic: Sorting Lookups

Did you know what we added several features that made it easier to use Microsoft Dynamics GP?  They reduce the number of clicks it takes to get your work done.

Customers have the ability to choose SmartList Favorites within lookups and select to save that lookup as the default.  Once this has been chosen as the default, the next time the user enters the lookup the list will populate based off the view they selected as the default. 

This gives the customer the flexibility to set the lookups based off how they need to see the data and can save them valuable time in the application.  The Set as Default option is available within the Customer and Prospects, Vendors, Items, Salespeople and Employees lookups. 

Read More:
Weekly Topic: Sorting Lookups

November 13, 2013 · Pam Misialek · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 286

Web Client Wednesday – Microsoft Dynamics GP Reset User Password not working

Continuing with the Web Client Wednesday series, today I wanted to highlight the fact that the web client is still a work in progress. While a lot of ground has been covered over the past 3 years, the product continues to evolve, and of course, in the meantime there will be little issues here and there that may affect the way you work.

Previous articles in the series:

Web Client Wednesday – Browser Support

Web Client Wednesday – User Interface Differences



Just recently I ran into a Microsoft Dynamics GP 2013 web client deployment case where the advanced SQL Server options are enabled to enforce password expiration. These properties are a part of the Enforce Password Policy options on the User Setup window.

User Setup

When a password expires and a user attempts to log into the desktop client, they are immediately prompted to change their password and the Change User Password dialog window displays to allow the user to enter the old password, and enter and confirm the new one.

Change User Password window

The behavior is different under the web client, however. Whenever a password expires, the Change User Password dialog displays as expected, but in this case, the Old Password field is disabled and the user would only be prompted to enter the new password and confirm.

Change User Password dialog on Web Client 

Microsoft Dynamics GP uses the old password to establish a connection to the database – at this point, the user has not validated their SQL credentials – in order to set the new password. If the old password is not supplied the connection cannot be established, which in turn fails the attempt to change the new password.

This issue has been identified as a bug by Microsoft Support in Fargo and is currently in the queue for resolution. If you are affected by this problem, you are encouraged to open a support case and add yourself to the list for a fix.



For more information on how the password system works in Microsoft Dynamics GP, please take a look at the following articles:

Developing for Microsoft Dynamics GP – Why does Microsoft Dynamics GP encrypt passwords?
Developing for Microsoft Dynamics GP – Microsoft Dynamics GP Application Password System
Microsoft Support – FAQ about the Advanced SQL Server options in the User Setup Window

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

More:
Web Client Wednesday – Microsoft Dynamics GP Reset User Password not working

November 13, 2013 · Mariano Gomez · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 468

The Dynamics GP Blogster: Web Client Wednesday – Microsoft …

Microsoft Support – FAQ about the Advanced SQL Server options in the User Setup Window Until next post! MG.- Mariano Gomez, MVP IntellPartners, LLC http://www.IntellPartners.com/. Posted by Mariano Gomez at 8:00 AM …. Exchange Rates Feed – Few days back I got mails from many customers reporting that the exchange rates feed stopped working due to an error with the host, the tool was linked t… 17 hours ago 5 days ago. Dynamics Confessions Blogspot.

Read the article:
The Dynamics GP Blogster: Web Client Wednesday – Microsoft …

November 13, 2013 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 260

Identifying Microsoft Dynamics GP version information

David Meego - Click for blog homepageI had a case recently where the customer’s auditors were asking the customer to prove the version and build of Microsoft Dynamics GP was the same as the version they claimed it was. Basically, the auditor said “provide me proof that you are running GP X SP Y”.

So during this case, I discussed a number of methods with the customer and let them choose what worked best for them. In this case, I was dealing with the customer’s DBA, who did not have access to run the Dynamics GP client, so not all of the methods I provided would have worked for him.

Here is the list I came up with:

  1. From the Login window
     
    When you launch GP the primary Dynamics product dictionary’s version is displayed on the bottom of the Login window.
     
  2. From inside Microsoft Dynamics GP, you can select Help >> About Dynamics. 
     
    This will show the main Dynamics product version as well as the Dexterity version and SmartList version. Other about windows are available for other modules, but have different navigation paths.
     
  3. From the SQL Server we can run select statements to see version data in the Dynamics Utilities tables.
     
    — List of Company IDs
    select CMPANYID, INTERID, CMPNYNAM from DYNAMICS..SY01500
     
    — List of Product Versions for Company specified by Database
    select U.*, C.INTERID, C.CMPNYNAM from DYNAMICS..DU000020 U
    join Dynamics..SY01500 C on C.CMPANYID = U.companyID
    where C.INTERID = ‘TWO’ — Enter desired Company DB name
    order by U.PRODID
     
    — List of Product Versions for System Database
    select * from DYNAMICS..DU000020
    where companyID = -32767
    order by PRODID
     
  4. From Dictionary file properties.
     
    Depending on the version and if the registry associations are working, you can right click on a DIC file and then click Properties. This will show the dictionary version in a Dictionary tab. The version information can also be shown using the tooltip if you hover over a DIC file.
     
    Note: Open DYNAMICS.SET file with Notepad.exe to see installed products. The first line in the file contains the number of products installed. Then the following lines are a list of products with the Product ID followed on the next line by the Product Name. .
     
  5. Support Debugging Tool
     
    Using Support Debugging Tool’s Screenshot feature you can obtain the system status report which lists all dictionaries and their version numbers. SDT Portal: http://aka.ms/SDT
     
  6. CustomerSource
     
    Link: https://mbs.microsoft.com/customersource/ 
     
    Other direct links are available via my blog on the Developer & Consultant Articles & Links page
     
    These include the Service Pack pages:

    Service Pack, Hotfix, and Compliance Update Patch Releases for Microsoft Dynamics GP 10.0 Secure Link
    Service Pack, Hotfix, and Compliance Update Patch Releases for Microsoft Dynamics GP 2010 Secure Link
    Service Pack, Hotfix, and Compliance Update Patch Releases for Microsoft Dynamics GP 2013 Secure Link 
     

  7. Version Information Spreadsheets
     
    Look at the Notes sections on the Service Pack pages (links above) for the Excel Version spreadsheets. Below are the direct links:
     
    Microsoft Dynamics GP 10.0 Version spreadsheet 
    Microsoft Dynamics GP 2010 (v11.0) Version spreadsheet 
    Microsoft Dynamics GP 2013 (v12.0) Version spreadsheet 

With all of these options you should be able to easily confirm your version and compare it against the Version Information Spreadsheets to identify the exactly release you are on.

Enjoy 

David

Read more here:
Identifying Microsoft Dynamics GP version information

November 13, 2013 · David Musgrave · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 403

Weekly Topic: Multi-tenant

Did you know that Microsoft Dynamics GP is multi-tenant?  Do you know why you should care?

The Multi-tenant Microsoft Dynamics GP Web feature provides the ability to host multiple tenants on a single instance of the application.  In basic terms, you can have multiple DYNAMICS databases on the same SQL Server instance.

A few of the reasons you should care:

1.  Makes it easier to host GP in a multi-customer environment.

2.  Customers with many company databases can deploy them in groups making it easier to apply service packs and upgrades.

3.  Web Client.  Enough Said.

4.  It’s multi-tenant the right way.  It gives you control of your deployment with the flexibility to be in the cloud the way you want.

 

Read more here:
Weekly Topic: Multi-tenant

November 12, 2013 · Pam Misialek · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 357

Business Analyzer New Release is out in the App Store

Readers of this blog might remember that I have been a fan of the beautiful business analyzer application for Dynamics GP for a long time. In fact it has been almost 2 years since I posted my video on a windows touch table – Dynamics GP Business Analyzer on a Windows Touch Tablet.

Meanwhile, the product has received a lot of updates, and its a great fit for Windows touch tablets. A new release came out over the weekend, and if you have not yet tested this application – not is a great time. Ian Grieve has great instructions if you need help installing this app – Installing Business Analyzer R5 From The Windows 8 App Store

CFOHOMEPAGE

Continue reading here:
Business Analyzer New Release is out in the App Store

November 12, 2013 · Jivtesh Singh · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 291

Installing Business Analyzer R5 From The Windows 8 App Store

As mentioned in the last post, Business Analyzer R5 is available from the Windows 8 App Store. As both an inveterate blogger and incorrigible tinkerer I figured I might as well blog about my tinkering with the new app. Unfortunately, … Continue reading

Taken from:
Installing Business Analyzer R5 From The Windows 8 App Store

November 12, 2013 · Ian Grieve · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 267