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

Recent Posts

Archives

veeyeskay

Page 19 of 28« First...510...15161718192021222324...Last »

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

Master Budgets in Dynamics GP 2010

Published 10/31/2010 | By veeyeskay

Hi all

In this article, I am going to brief on a new functionality which is available in Dynamics GP v2010. This functionality allows us to combine multiple budgets and create a master budget.

In a scenario where each division… Continue reading →

Posted in Dynamics, General Ledger | Tagged , , | 1 Comment

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

Microsoft Most Valuable Professional (MVP)

Published 10/03/2010 | By veeyeskay

Hi all

To my utmost surprise, I found out yesterday that I have been awarded with the Microsoft® Most Valuable Professional Award for Dynamics GP. This is the first time I am receiving this award and it is definitely a… Continue reading →

Posted in Dynamics, General Topics, Great Plains, Miscellaneous | Tagged , | 13 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 19 of 28« First...510...15161718192021222324...Last »

Interesting Findings & Knowledge Sharing

Copyright © 2012. All Rights Reserved.