Page 1 of 9212345678910...2025303540...Last »

Inventory Cycle Count

Stock count requirements:
Before you set up and use stock counts, you should be aware of the requirements and restrictions. Item types Only Sales Inventory or Discontinued items can be assigned to a stock count. “Freeze” inventory when starting a stock count It’s a good business practice to restrict access to the inventoried items that are being counted during a stock count.
Steps:
     Create Stock Count Schedule

Goto –> Dynamics GP–>Inventory–>Stock Count Schedule

Stock Count Schedule 





















When you’re ready to begin work on a stock count at a specific site, create a stock count schedule-  specify which item-site combinations are to be included in this stock count. (If you’re using multiple bins, you specify which item-site-bin combinations are included.) You can save the stock count schedule or you can choose to start it. You also can reuse stock counts.
To create a reusable stock schedule, mark the Reuse option.
If you need to add many items in your stock count click on “Mass Add” button.  
Stock Count Mass Add




























You have many option to add Mass Items base on Range you have selected. Like Item Number or Class or by Site ID.
Once Item Range is selected then click on Add Button
In my example I have selected one Item: SUGAR.

Stock Count Schedule with Item




























When you’ve finished, choose Save and close the window. Need to call back Stock Count ID again to start Stock Count.
Starting a stock count schedule
Use the Stock Count Schedule window to start a stock count. If the stock count can be started—if there are no exceptions—the status of the count will be changed to Started, stock count forms will be printed and information about the on-hand quantity of each item-site combination will be captured.
Choose Start Count.
When you start a stock count schedule, the quantity on hand for each line in the stock count schedule is captured. Later, the actual count number quantities will be compared to the captured values to create default variance transactions. 
The report destination window for the Stock Count Exceptions report appears. Choose the destination for the Stock Count Exceptions report.

Stock Count Schedule





























Please select Print on Hand Quantities and Print Item Lot or Serial Number if you need to count by Tracking Option then Click on OK.

Below report will print if there is no exceptions.

Stock Count Form

















Use this report to do your physical stock count.
  
Open Stock Count Entry
Got–> Dynamics GP–>Transaction>>Inventory–>Stock Count Entry

Stock Count Entry

























Select Your Stock Count ID
It will display all items. If Item is Lot/Serial –> Click on Serial/Lot button and can enter count quantity.

Stock Lot Count Entry Screen


























Click Okay to go main screen- Stock Count Entry.
On Stock Count Entry screen:
1)      Distribution- It will show each Items GL Distributions.
2)      Serial/Lot- Enter Inventory count by Lot or Serial as explained above.
3)      Unposted Transaction Button- To display if there is unposted transaction are   
         considered in stock count or not for specific item.
4)      Trx History- It display total historical transactions for specific item
Once you have enter Count system will enter Variance for you.  
e.g. Stock Count Lot Number Entry screen.

Stock Count Lot Entry Screen




























Click Okay to goto Main screen.

























If you’re using autoposting options for stock count variances,variance transactions will be posted and reports will be printed when you process a stock count. If you’re not using autoposting, variance transactions are saved in a batch; you’ll need to post the batch.

Once you are satisfied with result click “Process” button.
System will prompt for following Reports:

1)  Exception Report























Effects of processing a stock count
When you process a stock count, several things happen:
  • Variance transactions are created. If the Autopost Stock Count Variances option is marked, the transactions also will be posted.
Cost information for variance transactions will be based on the cost of the items at the time of the stock count. Cost information is based on the item’s cost trends, so variance transactions might not match the true cost of the items. 
  • New Next Stock Count Dates are calculated for the items in the stock count schedule. 
  • History information about the results of the stock count is stored. History is kept to be the basis of the Accuracy Comparison report, which helps you monitor the accuracy of your stock counts over time.
  • If the stock count wasn’t marked to be reused, it’s deleted. If it was marked to be reused, the stock count results are cleared and the status of the count is set to Available.
  • The exceptions report for processing a stock count is printed. The report lists the problems, if any, that prevent the stock count information from being processed. Even if a stock count is successfully processed, the exceptions report is printed. If the stock count had no variance transactions that is noted in the exception report; otherwise, the report lists the batch number and variance transaction numbers used.
Goto –>Inquiry–>Inventory–>Inventory Transaction.

Inventory Adjustment

Until Next Post.. !!!!










Continue reading here:
Inventory Cycle Count

June 13, 2015 · Sandip Jadhav · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 37

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 3

Ok, I’m officially tired! Day 2 did not leave much room to sleep with a presentation, expo, dinner, and Rock-n-Rave (even though I did not stay long).

However, today I had to gut it out for our repeat session, CS15G024-R2 Microsoft Dynamics GP 2015: Customizing the user interface, which was scheduled for 11:00 AM.

CS15G024-R2 Microsoft Dynamics GP 2015: Customizing the user interface
Mariano Gomez and David Musgrave

We had 64 people in our session and really had an enthusiastic crowd despite the Rock-n-Rave precedent. The session went on as planned and we feel we had a bit more organization in our delivery.

Once our session finished, I ran off to Kevin and Dan’s session, CS15G014 – Leveraging Microsoft Dynamics GP 2015: Service Based Architecture for better integrations.

Kevin Racer and Dan Lothspeich

This session was truly informative as Kevin and Dan walked through the evolution of the work environment and how it has been impacted by the ever increasing hours we spend working, the ever decreasing workforce age, our own understanding of the Internet, the increasing workload many of us are challenged with, and the endless ways to communicate. This all has led companies to seek increased computing resources to process massive amounts of data which cloud computing seems to deliver well via a service oriented architecture model. This service model has driven the appification of software functionality, a technique by which software functions are exposed as services to be consumed by other software applications.

This brings us to the Microsoft Dynamics GP Service Based Architecture model, which seeks to expose parts of Dynamics GP as services to be consumed by other applications, also allowing Dynamics GP to consume services.

Microsoft Dynamics GP Service Based Architecture

The key to this technology evolution has been the enhanced interoperability with Microsoft .NET built within the Microsoft Dexterity toolset and leveraged via the Dynamics GP application. Kevin then went on to conduct a short demo on the endpoint URI structure and patterns to access the Dynamics GP services and showed off some of the cool discovery tools available, while detailing the security flow and authentication mechanisms required to access the Dynamics GP services.

Then we had eOne demoing their latest product, Service Builder which allows users and developers to expose any part of GP as a service, similar to how SmartList Builder exposes GP data. In fact, the idea is to also allow users to expose smart lists as services. Other applications include being able to expose Microsoft Dynamics GP windows and the underlying Dexterity scripts as services, conceivably allowing any function within GP to be consumed by other applications.

Well, I could go on and on, but hopefully you get the point. Kevin and Dan’s session is available on the Virtual Convergence site, here.


I returned to the Expo to try and catch up with David who had attended another session, but decided to go visit some folks I hadn’t seen yet. After saying hi and catching up with David, we returned to the Omni Hotel in preparation for the OneRepublic concert and to decompress from the day. I had invited a good friend of mine and I left to pick her up and return to the Phillips Arena.

The OneRepublic concert motto: “One Believable Convergence Celebration”

Once inside the arena, we quickly head to the floor area to get a good view of the group for the opening. In the meantime, we were enjoying some of the cool music being played. The group came on stage with their song Light it Up to open the concert.

The concert got progressively better with the group artists hitting some solos.

Well, the night was really a good one, but it was time to wrap up and get home.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

Read more here:
Microsoft Convergence Atlanta 2015 (#CONV15) – Day 3

April 2, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 51

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 1

Keynote and General Session

I know, it’s been over a week since Microsoft Convergence 2015 closed its doors, however, I did not want the time to go by without reliving some of the things I personally experienced throughout the event. With early mornings and late evenings it became impossible to write blog posts as things were happening, considering my own involvement with quite a few of the activities and presentations at Convergence.

Day 1 started out with David and I rushing through Atlanta’s traffic to get to the Georgia World Congress Center. From there we would head over to the Phillips Arena for the Opening Keynote Speech. We got there at the tail end of the presentation of Dance 411. The Dance 411 Foundation’s mission is to foster the well-being of urban youth and young adults through self-expression. They provide a quality education and exposure to the discipline of dance, drama and music. Judson Althoff, President Microsoft North America was in the middle of interviewing JJ Crampton and Sindy Scheider, both directors of the Foundation and requesting everyone filled out the Convergence event evals, for which Microsoft would make a donation to the Foundation.

Dance 411

Once the dance group completed their presentation, Althoff was once on stage to talk about the Atlanta Youth Project and Truly Living Well Center for Natural Urban Agriculture and the volunteering work done in conjunction with the Convergence attendees who signed up for community outreach, now a staple of these events. The community outreach video was accompanied by an original song by The Groove Merchants.

Upon the conclusion of the community outreach video, Althoff was back on stage to describe the upcoming days at Convergence and some of the guest speakers that attendees would have a chance to experience. He also alluded to the fact that the event itself, Convergence, is also evolving and changing, just like the businesses present at the event. He also noted that Convergence used to be a Dynamics only event. Microsoft has expanded the event and evolved it to actually incorporate all of its innovations. Convergence has become the Premier Business Event.

Without further due, Satya Nadella was on stage to talk about how Microsoft is empowering every person and every organization on the planet to achieve more, via the “systems on intelligence”.

Satya Nadella on Microsoft’s Vision

The systems of intelligence interact with the systems of record to make sense of the data collected. Microsoft is focusing on the automation of the systems of intelligence, with the richness of its cloud infrastructure. To further talk about how other industries are taking advantage of the technologies that drive the systems of intelligence, Satya welcomed Seattle Seahawks’ Russell Wilson.

Seattle Seahawks Russell Wilson

Russell described how he uses OneNote to track all his activities on and off the field and how the National Football League (NFL) leverages Microsoft Surface during the games to analyze team formations, plays, and players in near real time – Microsoft is a sponsor of the NFL.

The rest of the presentation focused around the use of other technologies such as Yammer within Microsoft itself. Also there was a cool case study on how AccuWeather is leveraging Microsoft Azure to deliver custom and personalized weather to both consumers and businesses.

AccuWeather

After the case studies, it was time for Mark, Belinda, and I to head over to the GWCC to wire up for the Microsoft Dynamics GP General Session, to be held at the Sydney Marcus Auditorium. Upon arrival, I went back stage to check in and had a chance to capture this picture with the engineering team at work.

Video and Audio Engineering Room

This year, the Microsoft Dynamics GP General Session featured a number of info-bites showing what each of the presenters were doing at different stages during the 90’s and various terminologies born from that time.

Little bits of information before session

This year’s Dynamics GP General Session would focus on product strategy and roadmap, and as customary, it began with with Errol Schoenfish welcoming all attendees and discussing the Microsoft Cloud for Business strategy, which features Office 365, Azure, and the business applications, including Microsoft Dynamics GP. Errol went on to demo a Time Management app (#IfErrolCanDoIt) showing how it would work on various device platforms.

Then came the highlight of the event (ehem!): The MVP Duel featuring Mark Polino and I, with a special guest, Belinda Allen. Our presentation, showcasing a number of new features in Microsoft Dynamics GP 2015, went very smooth and features were well received by the audience.

The MVP Duel – From left to right: MVPs Mark Polino, Belinda Allen, and Mariano Gomez

Up next was the customer story featuring Rural Renewable Energy Alliance (RREAL), a non-profit dedicated to make solar energy available to low income families.

Next up was Jennifer Ranz to demo a day in the life of a RREAL employee. Jenn showed the dashboards released for Office 365 and PowerBI. Jason Edens from RREAL came on stage to talk about how their company is leveraging Microsoft Dynamics GP to run their business.

The session went on with other demos and a glimpse into the future of Microsoft Dynamics GP. First up was Jeff Trosen to talk about the evolution of the Microsoft Dynamics GP roadmap. Chad Sogge came up next to talk about the new HTML 5 interface and provide a demo of how this new web client technology will allow for a better user experience across browsers and devices.

Errol Schoenfish and Chad Sogge on the Future of Microsoft Dynamics GP Web Client

I had to finally get a shot of the audience.

Microsoft Dynamics GP General Session Attendance

Well, in my next post, I will talk about the sessions we delivered throughout the rest of the event.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

See more here:
Microsoft Convergence Atlanta 2015 (#CONV15) – Day 1

March 30, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 62

#CONV15 – Convergence 2015 Atlanta – Day 0 – PreGame

David Meego - Click for blog homepageConvergence2015

The conference starts today with the partner only pre Convergence event, PreGame.

PreGame

The PreGame is organised by Dynamic Partner Connections and is a partner focussed half day event. It is described as “Over 600 Microsoft Dynamics partners gathered in Atlanta, to hear from 70 expert speakers during 25 partner-centric sessions contributing to 1 Dynamics Partner Community”.

The day started with Mariano and I going to Georgia World Congress Center to register for Convergence 2015.

Welcome
Welcome to Convergence 2015

While at the main entrance between Buildings A and B, we met with some of the LATAM Microsoft team.

Mexico Office
LATAM Microsoft Dynamics Team with Mariano and David.
Do their tops mean that I have lost my Superpower?

We then walked over to the Westin Peachtree Plaza hotel for the start of the PreGame event. This was my first chance to meet up with some of the other Microsoft Dynamics GP MVPs (other than Mariano) and with some of the GPUG team.

GPUG & MVP
David Musgrave, John Lowther MVP, Belinda Allen MVP,
Kim Peterson GPUG, Mariano Gomez MVP and Bob McAdam GPUG

At this time I should point out a common misconception. I am not a Microsoft MVP and have never been one. As a Microsoft employee for 13.5 years I was not eligible and I have to be outside of Microsoft for 12 months before I can be eligible. So, even though the actual MVPs and many in the community treat me as an “Honorary MVP”, it is not official.

For my first session I went to the session “ISV Confidential: How to Work the Microsoft Dynamics Ecosystem and Get Results”. It was a great session with a number of experienced ISVs on the panel giving us the benefit of their experience. They explained how big flashy product launches are not as effective as the prolonged approach with reputation building and word of mouth marketing. A consistent and long term marketing presence is needed to build the client base. It was also a good opportunity for me to get some feedback on the pricing model I am planning for the rebadged Support Debugging Tool.

We then had a Dynamics GP general session: “Product Strategy and Roadmap”. This was a preview of the content we would see in the Convergence Dynamics GP general session, with a bit more depth. It allowed the partners to be ready for any questions their customers attending Convergence might have.

The usual suspects were there, including Errol Schoenfish, Pam Misialek, Chad Sogge and Jeff Trosen.

Errol
Introduction by Errol Schoenfish. #IfErrolCanDoIt

Not sure if Pam is telling me off for taking a photo, emphasizing a point or throwing down a rap tune.

Pam
Pam Misialek laying down the law

The main take away points from this session where the latest product roadmap slide. The Roadmap now shows planned releases for GP 2015 R2 and GP 2015 R3 as well as the next version in the latter half of 2016 onwards.

Roadmap
Microsoft Dynamics GP Roadmap

We also got to see some more details of what is planned for the upcoming releases. Below is a summary slide of what is planned for the GP 2015 R2 release due mid 2015.

GP2015R2_Features
Microsoft Dynamics GP 2015 R2 features

We had a demo of the All-in-One document viewer for Purchasing which allows you to see the entire flow of documents between Requisitions, Purchase Orders, Invoices and Receivings for a vendor. Very cool. This All-in-One view will be added to other series (Sales, Inventory, etc.) in future releases.

We also had a preview of the next generation of the Web client which will work on HTML5 rather than Silverlight. This will make the vision of any browser on any device a reality.

After the general session, I went to the “User Panel: What Do Customers Really Expect?” session. This was an interesting session which hopefully helped partners to understand how to best work with their customers. A great example that came out of that session shows how not to have good relations with a customer. Without mentioning any names: A customer who had not heard from their partner for a while, invites the partner to lunch to touch base and re-establish a working relationship. The partner sends three representatives who enjoyed a nice meal paid for by the customer. Shortly after, the customer receives an invoice for 6 hours consulting (3 consultants for 2 hours). An excellent example for relationship building… NOT.

The final session for the day was the PreGame Closing Keynote featuring the new Vice President Dynamics Partner Sales and Programs, Direct of ERP Partner Strategy, Victor Morales.

Before Victor spoke we had a presentation from Brian Deming who introduced us to the new independent, non-profit membership organisation which will service the professionals for all Dynamics products. Its initial focus will be on certifications for Dynamics GP and Dynamics NAV and eventually for Dynamics SL. This organisation is The Association of Dynamics Professionals and its website can be found at http://dynamicspro.org/. Please go to the site to register your interest. They plan to officially launch the association in September 2015, however, if you are interested in helping with the development of the certification exams, please contact them now.

DynamicPro
The Association of Dynamics Professionals

Hal Howard then spoke to us about Dynamic Communities (including the user groups, such as GPUG) and  gave us some interesting statistics.

DynamicCommunities
Dynamic Communities

Finally, we heard from Victor Morales, who explained how he is still new and learning lots about Microsoft and his new role. He is very open to feedback and improving the working relationships between Microsoft and its Dynamics Partners.

Victor
Victor Morales

Victor also provided us with some statistics of how both the Microsoft Cloud and Microsoft Dynamics ecosystems are growing.

CloudAndDynamics
Microsoft Cloud and Dynamics Momentum

The session finished with a quick question and answer session. The day ended with the Microsoft Partner Reception where partners could relax and have a drink and some nibbles and chat with other partners. The networking that occurs at these sorts of receptions can be some of the most valuable time spent at a conference.

One last stop: Mariano and I went to the MVP Mingle held at Stats Food & Drink. This event was sponsored by FastPath and Data Masons and allowed the MVPs for all the Dynamics products to socialise and relax together. I abused my “Honorary MVP” status and gate crashed. Well, Mariano was my transport home, so I was not going to lose him. I spent much of the night chatting with Beat Bucher (another Honorary MVP).

During the closing session, the upcoming events were highlighted, so here is a quick reminder to mark your calendars.

  • reIMAGINE 2015 in Fargo, ND, USA on 21-23 September 2015
  • GPUG Summit 2015 in Reno, NV, USA on 12-16 October 2015
  • PreGame at Summit 2015 in Reno, NV, USA on 13 October 2015

Hope to see you at these events.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Conference, Dynamics, GP, Microsoft, News Tagged: Conference, Convergence 2015, News

View post:
#CONV15 – Convergence 2015 Atlanta – Day 0 – PreGame

March 30, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 72

Upgrade from GP 2010 to GP 2013 R2

3d man with Q & A

Question: How do you upgrade from GP 2010 build 2390 to GP 2013 R2

Answer: The documentation from Microsoft that delineates the upgrade path from GP 2010 to GP 2013 R2 is missing the current build of GP 2010 (as of 3/16/2015). The document from Microsoft can be found here: https://mbs.microsoft.com/partnersource/northamerica/support/hot-topics/HOT_TOPIC_MDGP2013Upgrade#UpgradePaths.

The line missing is how to upgrade to GP 2013 R2 from 11.00.2390. The answer is that you have to upgrade to 12.00.1826. The build numbers for both GP 2010 and GP 2013 R2 are achieved after installing the January 2015 Hotfix. Thanks go out to Paul Degneau, at Standard Process www.Standardprocess.com, for suggesting this to me.

Enjoy!

Leslie

Original post:
Upgrade from GP 2010 to GP 2013 R2

March 17, 2015 · Leslie Vail · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 85

Dynamics GP hosting – a great experience with RoseASP

I recently had a great experience that I would like to share. We have a client that was on a very old version of Dynamics GP (8.0), very old version of SQL (2000) a very, very old server (going on 10 years), and outsourced IT. Long story short, their server went down, they lost 2 out of the 3 […]

Read this article:
Dynamics GP hosting – a great experience with RoseASP

March 16, 2015 · Victoria Yudin · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 83

You receive "You are not allowed to use Microsoft Dynamics GP. Please sign out and sign in with an authorized account" when accessing Web…

One of the cool things about Microsoft Dynamics GP 2015 is the new Web Client Identity Management feature. Having the ability to access Microsoft Dynamics GP with your Windows Directory or Windows Azure credentials without ever needing a SQL login account is just beautiful.

The Theory – Part 1: GP Utilities

The theory is fairly simple: you have a Microsoft Dynamics GP user account, which in turn is tied to a Windows Active Directory account or Windows Azure Active Directory account. User accounts are stored in the User Master table (dbo.SY01400) in the system database, which has been beefed up with a new column called Active Directory Object GUID (ADObjectGuid) to store the actual GUID of the directory or organizational account mapped to the GP user.

User Setup window

However, because Microsoft Dynamics GP continues to be dependent on SQL authentication for all intends and purposes, it continues to need a SQL login to be able to access the Dynamics GP database objects. This is where the new Web Client SQL Login user comes into play.

If you have done a new install of Microsoft Dynamics GP 2015, you would have noticed a new window called Manage Web Client SQL Server Login during the GP Utilities process. This window prompts for SQL credentials that will be used to access the SQL server database objects from Web Client.

Manage Web Client SQL Server Login window (GP Utilities)

If you are doing an upgrade, you will need to direct your attention to the drop-down list in the Additional Tasks window to find it — more on this later.

Additional Tasks window (GP Utilities)

When you enter the credentials in the Manage Web Client SQL Server Login window, the actual SQL Server security principal is created with the same password encryption at the database level. To understand more about this, read Why does Microsoft Dynamics GP encrypt passwords by David Musgrave over at Developing for Dynamics GP.

The Theory – Part 2: Web Client

When you are installing the Web Client itself, you are once again prompted to enter the Web Client SQL Server Login credentials. At this stage you MUST enter the same account information entered when you ran the GP Utilities.

This information is stored in the TenantConfiguration.xml file (in a single-machine instance) under the SessionCentral folder. The same information is used by the Service Based Architecture service (GPService service) to gain access to database resources, hence there’s also a TenantConfiguration.xml file (again, in a single-machine instance) under the GPService folder. These two folders can be located under your Program FilesMicrosoft DynamicsGP Web Components root folder.

Now that your AD or Organizational account is tied to your GP user account, when you launch the web client and your AD credentials are validated against IIS, a security token is created and passed on to Session Central service, which in turn spins up a runtime process passing on your AD account credentials in the GP Login window. The log in process itself will use the Web Client SQL Server login to access the system database and in particular the User Master table to validate the AD account GUID against the one stored in the table. If all matches, you are allowed access and from there on you go about your business.

The Problem

This brings us to the topic of this post…

As it turns out, during that handshake between Session Central and the Runtime service to pass off the AD credentials, I received the following error:

Further review of the Dynamics application and services log in Event Viewer, shows the following error:

System.Security.Cryptography.CryptographicException: Padding is invalid and cannot be removed.
   at System.Security.Cryptography.CapiSymmetricAlgorithm.DepadBlock(Byte[] block, Int32 offset, Int32 count)
   at System.Security.Cryptography.CapiSymmetricAlgorithm.TransformFinalBlock(Byte[] inputBuffer, Int32 inputOffset, Int32 inputCount)
   at System.Security.Cryptography.CryptoStream.FlushFinalBlock()
   at System.Security.Cryptography.CryptoStream.Dispose(Boolean disposing)
   at System.IO.Stream.Close()
   at Microsoft.Dynamics.GP.Web.Foundation.AesCryptographer.Decrypt(String value)
   at Microsoft.Dynamics.GP.Web.Services.Session.TenantServiceXmlHandler.ResolveTenantPasswords(Tenant tenant)
   at Microsoft.Dynamics.GP.Web.Services.Session.TenantServiceXmlHandler.GetTenantDetails(String identity, String tenantName)
   at Microsoft.Dynamics.GP.Web.Services.Session.Service.SessionCentralService.CreateSession(String tenantName, UserContext userContext)

Typically, any Crypto exception is directly related to credentials. So I traced back my steps after the upgrade and realized I had created the Web Client SQL server login account manually — after all, I had not seen the option in the GP Utilities drop down to do so. Of course, this would mean that the password was un-encrypted on SQL server and wouldn’t match the password stored in the TenantConfiguration.xml file. In retrospect, had I even used GP Utilities to setup the account and entered a different password from the one I entered during the Web Client install, I would have received the same error.

The Solution

Knowing that in essence what I had was a password mismatch between the value stored in TenantConfiguration.xml and the password at the SQL Server level, I decided to make things simple and removed the database user (sp_dropuser) corresponding to the security principal and the actual security principal (sp_droplogin) then re-launched GP Utilities and created the account once more, this time making sure the password matched what I had entered when installing the Web Client.

Once I launched the Web Client and entered my Windows credentials information, I was able to experience the beauty of single sign-on all the way to the company database I had selected as my default company.

Also, it is worthwhile to mention that Service Based Architecture was failing validation, but I will address this in my next article.

Acknowledgements

I want to thank Chris Rudolph with the Microsoft Dynamics GP Software Engineering team for his valuable insight into working through this issue. Chris also helped me with understanding some deep architecture stuff that I will be presenting in a future related article to this one.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

Read More:
You receive "You are not allowed to use Microsoft Dynamics GP. Please sign out and sign in with an authorized account" when accessing Web…

March 12, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 95