[...] tips like this can be found on my SQL Server Coding Tips page. For more Dynamics GP code, check out my GP Reports page. Filed under: GP Reports code, SQL [...]
[...] SQL Server Coding Tips [...]
SQL view for Payables GL distributions in Dynamics GP
Using credit cards to pay vendors in Dynamics GP
Year end close in Dynamics GP
SQL view for Payables payment apply detail in GP
SQL view to show AP apply information in GP
SQL view with all SOP line items in Dynamics GP
SQL view for all posted GL transactions in Dynamics GP
Granting access to a new SmartList in Dynamics GP
Sales Transaction Entry GL distributions in Dynamics GP
Microsoft Dynamics Mayhem
SQL view for current Receivables aging in Dynamics GP
SQL view for sales quantities by item by year
SQL view for customer yearly totals in Dynamics GP
SQL view for vendor yearly totals in Dynamics GP
Happy New Year – 2012
SQL view to show monthly totals for Dynamics GP Vendors
Decisions Fall 2011 – GP Day is today
Protect your investment in Microsoft Dynamics GP
SQL view for SOP email setup in GP 2010
Victoria Yudin: Lyndy,
How about adding a column for life to date...
Victoria Yudin: JRB,
Thanks for the more detailed explanation, I ...
Lyndy Januszewski: Hello! Your SQL Views are always helpful Victoria...
JRB: Victoria,
Thanks for the reply.
Within both ...
Victoria Yudin: Hi Geraldine,
Yes! Thank you so much for the add...
Geraldine: I ran the SQL you've given me to show that DR &...
Victoria Yudin: Hi Saras,
FAYEAR is the Fixed Assets year and FAP...
Victoria Yudin: Hi Sean,
I have not run into this before. Reall...
Victoria Yudin: JRB,
If Multicurrency (MC) is enabled, it's for a...
JRB: I am in the process of getting familiar with GP 20...
Hi Victoria
Awesome, thanks u so much for ur reply.
Please mark me for the future questions.
Many thanks indeed…….
Hi Victoria
How to reset the password in GP 10.0 if the user is not logged off properly. When the administrator reset the password, message appears like “password has not been changed. The User is logged in”.
Do I have to reset password through Backend ‘ SQL Server’ and how it should be done. Please Explain……
Many Thanks
Sharmila,
I would recommend getting all users out of GP and running the following in SQL Server Management Studio:
Delete DYNAMICS..SY00800
Delete DYNAMICS..SY00801
Delete DYNAMICS..ACTIVITY
Delete TEMPDB..DEX_LOCK
Delete TEMPDB..DEX_SESSION
-Victoria
I was trying to upgrade our GP development server to SP2 and when I ran Utilities, it told me that someone was logged in, However, I already ran the SP2 install and couldn’t log in to GP to kick them out. I found several solutions to remove a user stuck in GP, including a couple of KB from Microsoft, but yours is the one that did the trick.