Home » SQL SCRIPTS » General Ledger (SQL)
Top Websites
- Dynamics GP Help
Over 5400 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 900 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
Latest links
- Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP
- SOP Quote Warning -Line item quantities are not fully distributed. Do you want to continue ?
- The 10th and 11th ways you can lose your SQL data...
- Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP
- SOP Quote Warning -Line item quantities are not fully distributed. Do you want to continue ?
- eConnect error: The target principal name is incorrect. Cannot generate SSPI context.
- Additional settings for Management Reporter 2012 CU16 Hotfix 3815274 – Microsoft Dynamics GP Community
- Dynamics GP Modify Account Format Setup – iSolutions Partners
- Microsoft Dynamics GP upgrades failing on CONCAT_NULL_YIELDS_NULL error message – Microsoft Dynamics GP Community
- Dynamics GP Mass Modify Chart of Accounts GL – iSolutions
GPWindow.com
Thank you for your support for GPWindow. It helps us cover part of the hosting costs for GPWindow.