Payables HATB With Aging By Payment Terms (using Document Date)
As a follow up to my script for generating the Payables HATB With Aging By Due Date (using Document Date), I have decided to post a script for the same with aging buckets based on the document date (with the logic of payment terms). This will provide the aging buckets for each transaction based on [...]
July 25, 2011 · 
veeyeskay · 
2 Comments
Tags: HATB, Payables Aging, Payables HATB, Payables Transactions, payment-terms, Trial Balance · Posted in: Accounts Payables, Dynamics, Great Plains, SQL Server, SQL Server 2005 Total Views: 108
Payables HATB With Aging By Payment Terms (using GL Posting Date)
As a follow up to my script for generating the Payables HATB With Aging By Due Date (using GL Posting Date), I have decided to post a script for the same with aging buckets based on the document date (with the logic of payment terms). This will provide the aging buckets for each transaction based [...]
July 25, 2011 · veeyeskay · One Comment
Tags: HATB, Payables Aging, Payables HATB, Payables Transactions, payment-terms, Trial Balance · Posted in: Accounts Payables, Dynamics, Great Plains, SQL Server, SQL Server 2005 Total Views: 89
Payables HATB With Aging By Due Date (using Document Date)
As a follow up to my script for generating the Payables 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 aging buckets for each transaction based on the receivables aging buckets setup. /****************************************************************** Created July 25, 2011 by [...]
July 25, 2011 · veeyeskay · 3 Comments
Tags: By Document Date, HATB, Payables Aging, Payables HATB, Payables Transactions, Trial Balance · Posted in: Accounts Payables, Dynamics, Great Plains, SQL Server, SQL Server 2005 Total Views: 119
Payables HATB With Aging By Due Date (using GL Posting Date)
As a follow up to my script for generating the Payables 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 the aging buckets for each transaction based on the receivables aging buckets setup. /****************************************************************** Created July 25, 2011 [...]
July 25, 2011 · veeyeskay · 4 Comments
Tags: HATB, Payables Aging, Payables HATB, Payables Transactions, Trial Balance · Posted in: Accounts Payables, Dynamics, Great Plains, SQL Server, SQL Server 2005 Total Views: 206
Payables HATB Report (Using GL Posting Date)
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. This script can also be used as a base to reconcile the sub-ledger balances as of [...]
October 9, 2010 · veeyeskay · 5 Comments
Tags: HATB, Payables Transactions, Trial Balance · Posted in: SQL Server 2005 Total Views: 645
Payables HATB Report (Using Document Date)
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 reconcile the sub-ledger balances as of a certain date with the corresponding GL transactions. The [...]
October 8, 2010 · veeyeskay · 5 Comments
Tags: HATB, Payables Transactions, Trial Balance · Posted in: SQL Server, SQL Server 2005 Total Views: 487
SQL View for Payables Transactions with AA Codes
Guys There is a smartlist object for AP 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 AP transaction information along with the analytical accounting information. IF EXISTS ( SELECT * FROM [...]
March 1, 2010 · veeyeskay · 11 Comments
Tags: AA Codes, Analytical Accounting, Dimension Codes, Payables Transactions, SQL View · Posted in: Accounts Payables, Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 Total Views: 813