[...] To see more tips and tricks for GP Reports Viewer, SQL , SSRS and Crystal Reports, take a look at the GP Reports Viewer newsletters. There are also more SQL Server coding tips on this blog. [...]
[...] SQL Server Coding Tips [...]
[...] more tips like this, take a look at my SQL Server Coding Tips page. To receive new tips as soon as they are published, sign up for the GP Reports Viewer [...]
[...] more tips like this, take a look at my SQL Server Coding Tips page. To receive new tips as soon as they are published, sign up for the GP Reports Viewer [...]
[...] SQL Server Coding Tips [...]
[...] 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 [...]
Using credit cards to pay vendors in Dynamics GP
SQL view for Payables GL distributions in Dynamics GP
Year end close in Dynamics GP
SQL view with all SOP line items in Dynamics GP
Granting access to a new SmartList in Dynamics GP
SQL view to show AP apply information in GP
SQL view for Payables payment apply detail in GP
SQL view for all posted GL transactions in Dynamics GP
Sales Transaction Entry GL distributions in Dynamics GP
SQL view for sales by item by month
Assign sequential numbers in SQL Server
SQL view for current Receivables aging detail in Dynamics GP
SQL view for current Payables aging detail in Dynamics GP
Changing part of a string in SQL Server using REPLACE
SQL view for sales quantities by item by site by year
SQL view for Fixed Allocation Accounts in Dynamics GP
Happy New Year – 2013
How to add a sparkline to a report in SSRS
Voiding a partially applied Payables transaction in Dynamics GP
Big announcement for Microsoft Dynamics GP’s Extender module
Victoria Yudin: Hi Rolan,
There is no way to 'edit' this once pos...
Rolan Hinayon: Hi Victoria
I am newbie here but it feels li...
Victoria Yudin: Cal,
Yes, DYNGRP needs to be granted permissions ...
Calvin: Thanks Victoria, that worked. I gave permissions t...
Victoria Yudin: Cal,
Did you grant permissions on your view to D...
Calvin Lee: Hi Victoria,
I created a SLB from a view and can ...
Victoria Yudin: Thanks Lyn! I have updated the page with the versi...
lynbarr: FYI, MR 2012 RU5 = 2.1.1037.15...
Victoria Yudin: Carrie,
That would be scenario 2. In GP 2010 and ...
Carrie John: This process works great when it's a non-PO transa...
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.