System/Setup SQL Code

Dynamics GP System and Setup SQL Code

9 Responses to “System/Setup SQL Code”

  1. 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?


  2. 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:

      • If accounting records must be kept in different functional currencies to conform to local requirements
      • When using Dynamics GP Payroll and there are different Federal ID Numbers
      • If there are entities that have different fiscal periods
      • Some types of businesses require separate accounting books to be kept to comply with various federal and state regulations
      • 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.



  3. Nishcalen Chinappa Reply December 21, 2011 at 6:09 am

    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


  4. Nishcalen Chinappa Reply December 21, 2011 at 6:07 am

    Thank you so much for all your help


  5. Nishcalen Chinappa Reply November 24, 2011 at 9:27 am

    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,



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: