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

Recent Posts

Archives

Accounts Receivables

Page 2 of 3123

Receivables HATB With Aging By Due Date (using Document Date)

Published 07/21/2011 | By veeyeskay

Hi all

As a follow up to my script for generating the Receivables HATB by Document Date, I have decided to post a script for the same with aging buckets based on the due date. This will provide the… Continue reading →

Posted in Accounts Receivables, Dynamics, Great Plains, SQL Server, SQL Server 2005 | Tagged , , , | 3 Comments

Receivables HATB With Aging By Due Date (using GL Posting Date)

Published 07/21/2011 | By veeyeskay

Hi all

As a follow up to my script for generating the Receivables HATB by GL Posting Date, I have decided to post a script for the same with aging buckets based on the due date. This will provide… Continue reading →

Posted in Accounts Receivables, Dynamics, Great Plains, SQL Server, SQL Server 2005 | Tagged , , , | 5 Comments

Understanding Voucher Numbers in Receivables & Payables

Published 05/08/2011 | By veeyeskay

All of us know that the document number field in the Receivables Transaction Entry and the voucher number field in the Payables Transaction Entry has a maximum of 20 characters. However, on the transaction entry windows, these fields ONLY allow… Continue reading →

Posted in Accounts Payables, Accounts Receivables, Dynamics, Great Plains | Tagged , , | 1 Comment

SQL View for Receivables Transactions with AA Codes

Published 01/15/2011 | By veeyeskay

Guys

There is a smartlist object for Receivables transactions, but this smartlist does not show the analytical accounting information in it.

So in this post, I have decided to post a SQL view to generate a view to show receivables… Continue reading →

Posted in Accounts Receivables, Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2005 | Tagged , , , , | 5 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

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
Page 2 of 3123

Visitors Map


Click Here for Stumbler

Interesting Findings & Knowledge Sharing

Copyright © 2012. All Rights Reserved.