Category: General Ledger
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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, ISNULL(D.aaAcctClassDescr, ”) AS [...]
Loading ...