Custom Programming
Dynamics TechBrief
MSSQL Deepsearch

How these can help you

How to purchase

Free Dynamics GP Sql Scripts


Collection of Useful Microsoft Dynamics GP Sql Scripts, Tips and Tricks

Display chart of accounts info (originally posted by Claudia)

Long Description:
[This is an edited entry]
GL00100 - Account Master
GL00100 - Account Master Copy A
GL00100 - Distribution Account Master
GL00100 - Breakdown Account Master
GL00100F1 - Account Master Filter1
GL00100F2 - Account Master Filter2
GL00100F3 - Account Master Filter3
GL00100F4 - Account Master Filter4
GL00102 - Account Category Master
GL00103 - Fixed Allocation Master
GL00104 - Variable Allocation Master
GL00105 - Account Index Master
GL00200 - Budget Master
GL00201 - Budget Summary Master
GL01201 - GL_Budget_SUM_MSTR_View
GL10000 - Transaction Work
GL10001 - Transaction Amounts Work
GL10002 - Transaction Clearing Amounts Work
GL10100 - Quick Journal Work
GL10101 - Quick Journal Amounts Work
GL10110 - Account Current Summary Master
GL10111 - Account Summary History
GL10300 - General Ledger Tax Work
GL11000 - GL Distribution Register Temporary
GL11110 - Account Summary Master View
GL11111 - Account Summary History View
GL20000 - Year-to-Date Transaction Open
GL30000 - Account Transaction History
GL40000 - General Ledger Setup
GL40100 - Quick Journal Setup
GL40101 - Quick Journal Account Setup
GL40200 - Segment Description Master
GL40300 - Posting Numbers Setup
GL50010 - General Ledger Period Header Temporary
GL50011 - General Ledger Period Temporary
GL50101 - Allocation Amounts Temporary
GL50102 - Audit Trail Code Temporary
GL50400 - Period Consolidation Activity
GL70500 - General Ledger Report Options
GL70501 - General Ledger Report Options Temporary

Commands with UPDATE, DELETE or DROP can ruin your data! Please use these queries with caution. We highly recommend that you backup your database before trying out these commands and to load them up first on a test server. Use at your own risk.

Associated SQL Command:

Viewed: 15670 times

Submitted by: Claudia

About Claudia

View complete list previous script
next script

Did you find this script useful?
Please reciprocate by submitting your own script
or any proven advice regarding Dynamics GP use. Click here.


Send the script above to a friend

Send to EMAIL: *

Short MESSAGE: *

Sender NAME: *

Sender EMAIL:

Validation code: *  Enter 308

Trademarks: Microsoft™, Microsoft Dynamics™ and/or Microsoft logos, products, and services referenced in this site are either trademarks or registered trademarks of Microsoft Corporation.

Disclaimer: This product is not officially endorsed by Microsoft. Furthermore, this website does not imply representation of Dynamics™ or relationship with Microsoft in any form.