May 2012
M T W T F S S
« Apr    
 123456
78910111213
14151617181920
21222324252627
28293031  

Recent Posts

Archives

SQL Server 2005

Page 7 of 9123456789

Receivables HATB Report (using Document Date)

Published 11/07/2010 | By veeyeskay

Hi all

Today, I have decided to post a script for the Receivables Historical Aged Trial Balance (HATB), which is generated by picking transactions based on the GL posting date for the receivables transactions.

This script can also be used… Continue reading →

Posted in Accounts Receivables, Dynamics, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 | Tagged , , | 5 Comments

SQL Query – Sales Accounts Due Report

Published 11/06/2010 | By veeyeskay

Hi all

In this article I have posted the SQL query for generating the Accounts Due report in the sales module.

SELECT  B.CUSTNMBR ,
        B.CUSTNAME ,
        A.DOCNUMBR ,
        C.DOCDESCR AS DOCTYPE ,… Continue reading →
Posted in Dynamics, Great Plains, Sales Order Processing, SQL Server 2005, SQL Server 2008 | Tagged , | 3 Comments

Budget Analysis Query

Published 10/31/2010 | By veeyeskay

Hi all

Today, I am going to post a script which allows you to analyze budgets vs. actuals for Microsoft Dynamics GP. There is an inquiry window available in Dynamics GP for viewing the budgets vs. actuals analysis. But this… Continue reading →

Posted in Dynamics, General Ledger, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 | Tagged , , , | 1 Comment

Payables HATB Report (Using GL Posting Date)

Published 10/09/2010 | By veeyeskay

Hi all

I had posted the script for the Payables HATB using document date logic in my earlier post.

Today, I have decided to post this script which is generated by picking transactions based on the GL posting date.… Continue reading →

Posted in SQL Server 2005 | Tagged , , | 5 Comments

Payables HATB Report (Using Document Date)

Published 10/08/2010 | By veeyeskay

Hi all

Today, I have decided to post a script for the Payables Historical Aged Trial Balance (HATB), which is generated by picking transactions based on the GL posting date.

This script can also be used as a base to… Continue reading →

Posted in SQL Server, SQL Server 2005 | Tagged , , | 5 Comments

GL Transactions with AA Details

Published 09/13/2010 | By veeyeskay

Hi all

Today I decided to post a simple SQL code to fetch GL Transaction Details along with dimension codes from the Analytical Accounting module.

SELECT  A.aaGLHdrID,
        A.JRNENTRY,
        A.RCTRXSEQ,
        A.… Continue reading →
Posted in Analytical Accounting, Dynamics, General Ledger, Great Plains, SQL Server 2005, SQL Server 2008 | Tagged , , , , | 5 Comments
Page 7 of 9123456789

Visitors Map


Click Here for Stumbler

Interesting Findings & Knowledge Sharing

Copyright © 2012. All Rights Reserved.