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: 11734 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 830
Levitra Vendita Comprare Propecia Acquisto Female Viagra Acquisto Cialis Jelly Viagra Super Active Levitra Originale Viagra online Levitra Compresse Divisibili Disfunzione Erettile Ecografia Comprare Priligy Viagra Generico Comprare Brand Cialis Kamagra Oral Jelly Viagra Originale 100mg Acquisto Kamagra Flavored Propecia Generico Comprare Levitra Comprare Viagra Jelly
lunette soleil chaussure femme nike roshe Air max nike lunette soleil carrea nike air force nike chaussure adidas yeezy chaussure new balance lunette soleil oakley nike huarache Chaussure asics nike air huarache adidas stan smith nike free nike presto chaussures sport chaussure converse Air max casquette
igf-1 canada jintropin canada jintropin canada hygetropin canada hgh canada jintropin jintropin hgh kigtropin hygetropin hgh hygetropin hgh comprar hygetropin comprar hgh jintropin precio
nike shox nike air max mujer joyas tiffany nike huarache polo ralph lauren Zapatillas adidas air max zapatos louis vuitton Adidas Superstar Zapatos adidas zapatos christian louboutin bolsos michael kors nike air max nike roshe
nike shox hogan scarpe calcio Tiffany christian louboutin Scarpe Adidas superstar Scarpe Reebok Adidas Scarpe nike sb Scarpe nike air force air jordan adidas scarpe Tacchi
viagra prezzo cialis originale levitra generico kamagra prezzo levitra senza ricetta acquisto kamagra viagra generico viagra originale kamagra gel viagra online cialis 5 mg levitra prezzo comprare viagra comprare kamagra comprare levitra comprare cialis cialis prezzo kamagra oral jelly cialis generico cialis generico prezzo

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.