Dynamics GP System and Setup SQL Code
- Change fiscal period names query to change fiscal period names
- Fiscal Years and Periods queries to find fiscal years and periods
- Security Details in GP 10.0 and 2010
- Security Roles and Tasks in GP 10.0 and 2010
- Security and SmartList Details in GP 10.0 and 2010
- SOP Email Setup in GP 2010 shows the status and format of the SOP email setup for each customers as well as the email addresses for the default bill to address
- User Activity in GP shows all the users logged in and a count of the batches, resources and tables each user has locked or open
Victoria-
I wasn’t sure where to post this, but we are debating using the organizational structure to segregate entities in a single database. Primarily we want to eliminate a huge amount of intercompany entries, but I am wondering if there is any actual reporting you can leverage using the organizational setup? It seems the org struct centers more around access, control, and visibility rather than any real reporting capabilities?
Tom,
I am not aware of any exiting reporting that leverages the organizational structure.
-Victoria
HI Victoria,
my company is opening up a branch in the UK, is it a good idea to have uk setup as a site in GP or have a separate company all together and how would multicurrency become easy for Finance as well as for IT
Farman,
There is no short or easy answer to this, as it will depend on a great many variables and your specific situation. There are some cases where it is clearly needed to set up a separate company, here is a quote from my book on implementing GP:
There are situations when separate companies are clearly recommended in Dynamics GP:
There is additional discussion in the book on this subject, but often it is best to get together with your GP Partner to discuss your specific needs so they can recommend the best solution for you.
-Victoria
Victoria, sorry to bug again. this script does not return all active users. What i need is a script to return all enabled users in GP
Thank you so much for all your help
Hi Victoria,
I want to ask a silly question. I need to run a script in SQL that will return all active users in Dynamics GP 2010. Please assist me,
Regards
Nish
Nish,
My SQL View for User Activity in Dynamics GP can help with this.
-Victoria
Nish,
Typically ‘active users’ means all users that are currently logged into GP. Is your definition something different? If so, can you please explain what your definition of ‘active users’ is?
-Victoria