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
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
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
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
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
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
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