Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Financial / GL accounts used in setup

Posted on by 93

Folks,

I am looking for a script to see where Financial / GL accounts is used in setup. I have found this view online:  Dynamics GP Essentials: Which are the Posting Accounts in my GP Company ! - SQL Script (mahmoudsaadi.blogspot.com)

But on a quick review it appears to be missing several places with accounts – I don’t think Manufacturing setup posting accounts, multicurrency setup, class (item/customer/vendor) accounts and individual asset FA accounts are included. (also inventory site masking – but that might get ugly)

Is there a better view that someone has built before I start digging into it?  (cross-posted in case you see this question more than once :-)  ) 

Thanks!

Devon

Categories:
  • Devon Southall Profile Picture
    Devon Southall 93 on at
    Financial / GL accounts used in setup
    Kerry,
    The purpose is for a client who is trying to harmonize the chart of accounts across multiple companies.  They wanted to know what GL accounts are used in the System setup like under Tools > Setup  > posting > Posting Accounts or   Tools > Setup > Financial > Currency Accounts as examples.  
     
    The script referenced is a fabulous start... it just doesn't have "everything" that a standard deployment might use (even Fabrikam).     Before I started on adding the rest -- I was just asking if anyone else has "fixed" this script.     
     
    Best,
    Devon 
  • Nanook Software Profile Picture
    Nanook Software 587 on at
    Financial / GL accounts used in setup
    I need to ask, what is it you are trying to accomplish?
    When you reference 'setup' which setup?
    A new GL account?
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans