Home » SQL SCRIPTS » General Ledger (SQL)
Top Websites
- Dynamics GP Help
Over 6500 resources listed. - Mark Polino's DynamicAccounting.net
Over 5100 resources listed. - Rose Business Solutions Blog New
Over 2200 resources listed. - Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
Over 1100 resources listed. - Mariano Gomez at The Dynamics GP Blogster
Over 1000 resources listed. - Microsoft Dynamics Partner Community Blog
Over 900 resources listed. - Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
Over 700 resources listed. - Mohammad Daoud's Dynamics GP Blog
Over 600 resources listed. - Vaidy Mohan at Dynamics GP - Learn & Discuss
Over 500 resources listed. - Inside Microsoft Dynamics GP Official Blog
Over 500 resources listed. - eOne Business Solutions Blog
Over 400 resources listed. - About Dynamics, Development and Life
Over 300 resources listed. - Frank Hamelly at GP2theMax
Over 300 resources listed. - Dynamics CPM
Over 300 resources listed. - BKD Dynamics GP Insights Blog
Over 200 resources listed. - Leslie Vail at Dynamics Confessor Blogspot
Over 200 resources listed. - Victoria Yudin's Dynamics GP Website
Over 200 resources listed.Victoria Yudin - Janakiram M.P. at DynamicsBlogger
Over 100 resources listed. - VS Tools Forum
Over 100 resources listed.Your Resource for Visual Studio Tools for Dynamics GP - Inside Microsoft Dynamics GP Official Blog
Over 100 resources listed. - US Dynamics GP Field Team Blog
Over 100 resources listed. - Catherine Eibner MBS Developer Evangelist
Over 100 resources listed. - Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
Over 100 resources listed. - Dynamics Small Business
Over 100 resources listed. - Belinda, The GP CSI
Over 100 resources listed.
Useful Dynamics GP Links
Search all GP Blogs, Groups and Forums New!
GPWindow is Everything Dynamics GP. Try the Custom GP Search engine which searches high quality GP Blogs, and the Microsoft Dynamics GP Community Forums.
Parent Category: General Ledger (SQL)
Links Sort by: Hits | References | Alphabetical
SQL view for all posted GL transactions in Dynamics GP
http://victoriayudin.com/2009/08/11/sql-view-for-all-posted-gl-transactions-in-dynamics-gp/
Below is a SQL script to create a view showing all posted General Ledger transactions in Dynamics GP. This has the common columns asked for on reports, but you can certainly add your own as needed. For additional SQL code, please visit my GP Reports page. A few notes on this view:
- Year-end close transactions are excluded
- Only functional amounts are brought in
- Unposted transactions will not be shown
~~~~~
CREATE VIEW view_Posted_GL_Trx
AS
/*******************************************************************
view_Posted_GL_Trx
Created Aug 11, 2009 by Victoria Yudin - Flexible Solutions, Inc.
For updates see http://victoriayudin.com/gp-reports/
- Returns…SQL Views – Active Chart of Accounts
http://rldu.wordpress.com/2010/06/22/sql-views-active-chart-of-accounts/
The following view returns all the active accounts in your General Ledger Chart of Accounts. …
Posted by
SQL Script – Default Item Class GL Accounts
http://rldu.wordpress.com/2010/06/23/sql-script-default-item-class-gl-accounts/
Have you ever need to take a look at what your Item Class General Ledger accounts are, but…
Posted by
GL Query For Posted and Unposted GL Transactions
http://mohdaoud.blogspot.com/2008/11/gl-query-for-posted-and-unposted-gl.html
Get the YTD Account Balance in GP via SQL
http://msdynamicsgp.blogspot.com/2009/12/get-ytd-account-balance-in-gp-via-sql.html
In the newsgroup Victoria Yudin provided SQL code to get the YTD account balance for an…
SQL View for all Posted GL Transactions
http://msdynamicsgp.blogspot.com/2009/08/sql-view-for-all-posted-gl-transactions.html
Victoria Yudin has a great post up SQL code designed to show all posted GL Transactions in…
SQL Script for Revaluation Process
http://cvakumar.com/msdynamics/2010/03/18/sql-script-for-revaluation-process/
SQL Code for GL Trial Balance
http://cvakumar.com/msdynamics/2009/04/26/sql-code-for-gl-trial-balance/
Weekly Dynamic: SQL to Show Transactions for a Certain Account
http://msdynamicsgp.blogspot.com/2009/05/weekly-dynamic-sql-to-show-transactions.html
Let's say that you are analyzing an account and want to see all the transactions that hit a particular account to see the related and offsetting accounts. Sure you can do that transaction by transaction via Detail Inquiry but it's tough to do analysis that way. Smartlists won't really give you what you…
Posted by
SQL Script – Default Item Class GL Accounts
http://msdynamicsgp.blogspot.com/2010/06/sql-script-default-item-class-gl.html
Weekly Dynamic:Accounts Over Budget SQL for Dynamics GP
http://msdynamicsgp.blogspot.com/2010/07/weekly-dynamicaccounts-over-budget-sql.html