RSSCategory: General Ledger

SQL Script for AP-GL Reconciliation

| 01/17/2012 | 6 Comments
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 […]

Continue Reading

Reporting Ledgers and Fixed Asset Depreciations

| 08/17/2011 | 2 Comments
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 […]

Continue Reading

Nice Features for Auditing Information in GP

| 06/26/2011 | 1 Comment
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 […]

Continue Reading

SQL View for AA Accounting Class–GL Account Link Information

| 01/15/2011 | 5 Comments
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 […]

Continue Reading