Financial / GL accounts used in setup

(1) Share

Report

Posted on by Devon Southall

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:

Microsoft Dynamics GP

All responses (2)

Answers (0)

Devon Southall 93 on at

Like (0)

Report

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 587 on at

Like (0)

Report

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?