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

Recent Posts

Archives

Dynamics

Page 15 of 23« First...5...11121314151617181920...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

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

DexSense: IntelliSense for Dexterity – A Boon for Dexterity Developers

Published 08/08/2010 | By veeyeskay

Folks

Not so long ago we all were busy voting for a product suggestion initiated by Mariano Gomez. :)

And here we are, with a wonderful utility developed by Tim Gordon from Alpine Limited called DexSense. This application runs as… Continue reading →

Posted in Customizations, Dynamics, Great Plains | Tagged , , | Leave a comment

IntelliSense in Dexterity – Product Suggestion

Published 06/25/2010 | By veeyeskay

Hi all

For many years now, I am sure every Dexterity developer has been dreaming of a cool IntelliSense feature to be provided in Dexterity. With the ease of coding brought into Visual Studio and this emerging in SQL Server… Continue reading →

Posted in Customizations, Dynamics, Great Plains | Tagged , , | Leave a comment
Page 15 of 23« First...5...11121314151617181920...Last »

Visitors Map


Click Here for Stumbler

Interesting Findings & Knowledge Sharing

Copyright © 2012. All Rights Reserved.