Archive for the ‘General Ledger’ Category
SQL Script for AP-GL Reconciliation
Hi all It has been some time since I have posted something useful on my blog. This was because I was busy writing up and testing the reconciliation script that I had developed to reconcile payables and receivables with the general ledger. In this article, I have posted a script to reconcile payables with general [...]
January 17, 2012 · 
veeyeskay · 
2 Comments
Tags: ap to gl, ap to gl reconcile, General Ledger, payables, Payables Reconciliation, reconcile, Reconciliation · Posted in: Accounts Payables, Dynamics, General Ledger, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 369
Account Level Security and Creating New GL Accounts
When you have Account Level Security enabled for a company, you would have come across the error message shown below, when we try to add a new account number and tab off the account number field. This is because new GL accounts can be created ONLY by a user who has access to all GL [...]
September 18, 2011 · veeyeskay · 3 Comments
Tags: Account Level Security, GL Accounts, grant access to all accounts, organizational structure, organizational structure assignment, permissions · Posted in: Dynamics, General Ledger, Great Plains Total Views: 199
Reporting Ledgers and Fixed Asset Depreciations
Recently, I was assisting a support request where one of our clients were trying to read the window help for the GL Posting window in Fixed Assets in Dynamics GP 2010. The window help was referencing a field called Selected Books, but this field was not visible to them at run time. This is because [...]
August 17, 2011 · veeyeskay · 2 Comments
Tags: fixed assets book, fixed-assets, General Ledger Setup, gl posting, reporting ledgers · Posted in: Dynamics, Fixed Assets, General Ledger, Great Plains Total Views: 237
History for Budget Transactions in Dynamics GP 2010 R2
Once you install Dynamics GP 2010, if you go to the General Ledger Setup, the following options will automatically have the history options marked. Accounts Transactions However, the history option for Budget Transactions is not automatically checked and because of this default setting, the system does not maintain a history of the budget transactions posted [...]
August 16, 2011 · veeyeskay · One Comment
Tags: account history, budget transaction history, budget transactions, General Ledger Setup, transaction history · Posted in: Budget Transactions, Dynamics, General Ledger, Great Plains Total Views: 61
Nice Features for Auditing Information in GP
Hi all I read the recent article posted by Vaidy titled Sales Quote Line Item Cancellation, where he explains the use of the Qty Canceled field and how it helps the companies to track the actual quote and details of the canceled item, rather than deleting the line item completely. As a follow-up article for [...]
June 26, 2011 · veeyeskay · One Comment
Tags: Audit Features, Deletion Prevention, Journal Entry Void, purchase-order, Sales Documents, Voiding · Posted in: Dynamics, General Ledger, Great Plains, Purchase Order Processing, Sales Order Processing Total Views: 167
Table Structure Definitions – Multicurrency Account Master
Hi all Today, I am starting a series of articles where I am planning to explain the table structure of some of the tables in Dynamics GP. To begin with, I am going to explain the Multicurrency Summary Master (as revaluations is one of the concepts which I like most in a multicurrency environment). The [...]
May 3, 2011 · veeyeskay · No Comments
Tags: Account Currencies, Net Change, Period Balances, Post Results To, Revaluation, Revaluation Options · Posted in: Dynamics, General Ledger, Great Plains, Multicurrency Total Views: 365
SQL View for AA Accounting Class–GL Account Link Information
In this post, I am posting a SQL script for fetching the AA Accounting Class Link for various GL accounts in a company. It also provides us some key information about the accounting class that has been defined in Analytical Accounting. SELECT RTRIM(B.ACTNUMST) AS GPACCOUNTNO, RTRIM(A.ACTDESCR) AS GPACCOUNTDESC, ISNULL(D.aaAccountClass, ”) AS AAACCOUNTINGCLASS, ISNU Read the [...]
January 15, 2011 · veeyeskay · 5 Comments
Tags: AA Accounting Class, Analytical Accounting, Data Entry Rule, Dimension Code, GL Accounts, Transaction Dimensions · Posted in: Analytical Accounting, Dynamics, General Ledger, Great Plains, SQL Server, SQL Server 2005 Total Views: 666
Account Rollup Inquiry
Hi all In this article, I am going to provide an insight into the Account Rollup Inquiry. As the name suggests, this window is used to inquire on GL balances at a rolled up level using filters on the various segments on the GL Account Number. We can create various options for inquiring on the [...]
November 23, 2010 · veeyeskay · One Comment
Tags: Account Rollup Inquiry, Account Rollup Inquiry Options, Actuals, budgets, Calculated, Detailed Inquiry, Other Currency, Previous Year · Posted in: Dynamics, General Ledger, Great Plains Total Views: 485
SQL Query for GL Trial Balance – GP 2010
Hi all I decided to post the GL trial balance query with the ledger information for the purpose of analysis. It also contains the MDA information on this. Also, I have added a few more date hierarchies like Week No, Period (named), Quarter, since I realized these could be critical when performing analysis. IF EXISTS [...]
November 17, 2010 · veeyeskay · 2 Comments
Tags: General Ledger, GL Trial Balance · Posted in: General Ledger, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 1,224
SQL Query for GL Summary Balances
Hi all The first post for today is an SQL script for viewing the summary balances for all GL accounts and for all fiscal years and periods, with both the net change amount and the period balance (cumulative) amounts. SELECT Z.* FROM ( SELECT RTRIM(B.[ACTNUMST]) AS GPACCOUNTNO, RTRIM(C.[ACTDESCR]) AS DESCRIPTION, A.[YEAR1] AS Read the rest [...]
November 9, 2010 · veeyeskay · One Comment
Tags: Net Change, Period Balances, Summary Balances, Summary Tables · Posted in: General Ledger, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 759