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

Recent Posts

Archives

Yearly Archives: 2010

Page 40 of 87« First...510152025...36373839404142434445...5560657075...Last »

Dynamics GP ISV Product Reviews at GPWindow.com

Published 11/08/2010 | By
We are starting the GP ISV Product review series at www.GPWindow.com . With research inputs from Chetna and implementation inputs from Tina and Rubal - I think there will be content that will be of use to both GP Users and GP Consultants Continue reading →
Posted in Blogs I Follow | Tagged , , , , , , , , , , , , | Leave a comment

GP2010 – Sales Charts & KPIs – Top Items By Sale Amount – Stored Procedure Bug

Published 11/08/2010 | By Vaidyanathan Mohan
I stumbled across a bug (of sorts) in GP2010 SSRS Charts & KPIs for Sales Module. GP2010 has got default Charts & KPIs designed in SSRS and we have quite hands full of Charts & KPIs which covers most of our basic requirements. Continue reading →
Posted in Blogs I Follow | Tagged , , , , , , , | Leave a comment

Integration Manager and Analytical Accounting

Published 11/08/2010 | By
If you in the trenches with Analytical Accounting and considering the use of Integration Manager, check out these two posts Using Integration Manager with Analytical Accounting by David Musgrave When you use Integration Manager on a system with Analytical Accounting (AA) installed, integrations often fail because Analytical Accounting will open windows which are unhandled by Integration Manager. Continue reading →
Posted in Blogs I Follow | Tagged , , , , , , , , , , , | Leave a comment

SmartView Available from Today.

Published 11/08/2010 | By
One of the primary things that mid market companies look for in an ERP system is better and faster access to data. One of the most loved features of Microsoft Dynamics GP is SmartList and SmartList Builder - and that is because it provides an extremely simple interface to access all the data captured within your ERP system Continue reading →
Posted in Blogs I Follow | Tagged , , , , , , , , | Leave a comment

GL Reconciliation SQL Script – Payables

Published 11/07/2010 | By veeyeskay

Hi all

This script can be used as a base to reconcile the receivables sub-ledger balances as of a certain date.

DECLARE @ASOFDATE AS DATETIME
 
SET @ASOFDATE = '2017-04-12'
 
SELECT  Z.*
FROM    ( SELECT    A.[… Continue reading →
Posted in Accounts Payables, Dynamics, General Ledger, Great Plains, SQL Server 2005, SQL Server 2008 | Tagged , , | 6 Comments

GL Reconciliation SQL Script – Receivables

Published 11/07/2010 | By veeyeskay

Hi all

This script can be used as a base to reconcile the receivables sub-ledger balances as of a certain date. 

DECLARE @ASOFDATE AS DATETIME
 
SET @ASOFDATE = '2017-04-12'
 
SELECT  Z.*
FROM    ( SELECT    A.[… Continue reading →
Posted in Accounts Receivables, Dynamics, General Ledger, Great Plains, SQL Server 2005, SQL Server 2008 | Tagged , , | 5 Comments

Receivables HATB Report (using GL Posting Date)

Published 11/07/2010 | By veeyeskay

Hi all

I had posted the script for the Receivables 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 Accounts Receivables, Dynamics, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 | Tagged , , | 5 Comments
Page 40 of 87« First...510152025...36373839404142434445...5560657075...Last »

Interesting Findings & Knowledge Sharing

Copyright © 2012. All Rights Reserved.