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

Recent Posts

Archives

SQL Server

Page 7 of 1012345678910

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

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
Page 7 of 1012345678910

Visitors Map


Click Here for Stumbler

Interesting Findings & Knowledge Sharing

Copyright © 2012. All Rights Reserved.