Archive for the ‘SQL Server’ Category
SQL Script for AP-GL Reconciliation
Hi all It has been some time since I have posted something useful on my blog. This was because I was busy writing up and testing the reconciliation script that I had developed to reconcile payables and receivables with the general ledger. In this article, I have posted a script to reconcile payables with general [...]
January 17, 2012 · 
veeyeskay · 
2 Comments
Tags: ap to gl, ap to gl reconcile, General Ledger, payables, Payables Reconciliation, reconcile, Reconciliation · Posted in: Accounts Payables, Dynamics, General Ledger, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 369
SQL View for Daily Payment Summary
Hi all Based on a request from the community, I have decided to post a script for identifying all the payments made on a specific date from a checkbook and the details of what was voided for the specific date. This query helps a great deal in reconciling the funds that were used for processing [...]
August 5, 2011 · veeyeskay · 2 Comments
Tags: check amount, payment reconciliation, payment summary, voided amount · Posted in: Accounts Payables, Dynamics, Great Plains, SQL Server, SQL Server 2005 Total Views: 137
Post Through GL for Computer Checks – with Analytical Accounting
When you have Analytical Accounting module installed and configured in a GP company, the Post Through GL for Computer Checks gets automatically disabled in the specific company (even if it was turned on). If we try to activate the same manually (with Analytical Accounting activated), we get the following error message and the system prevents [...]
August 4, 2011 · veeyeskay · No Comments
Tags: analytical accounting activation, computer checks, post through general ledger files, post through gl, Posting Setup · Posted in: Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 131
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
Receivables HATB With Aging By Payment Terms (using Document Date)
As a follow up to my script for generating the Receivables 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 21, 2011 · veeyeskay · One Comment
Tags: payment-terms, Receivables Aging, Receivables HATB Report, receivables management, Receivables Reconcoliation · Posted in: Accounts Receivables, Dynamics, Great Plains, SQL Server, SQL Server 2005 Total Views: 109
Receivables HATB With Aging By Payment Terms (using GL Posting Date)
As a follow up to my script for generating the Receivables 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 21, 2011 · veeyeskay · One Comment
Tags: GL Posting Date, payment-terms, Receivables Aging, Receivables HATB Report, Receivables Reconcoliation, Receivables Transactions · Posted in: Accounts Receivables, Dynamics, Great Plains, SQL Server, SQL Server 2005 Total Views: 170
SQL Script for Generating Insert Statements From Table Data
Hi all I was searching Google for some SQL help today and found a very useful script, which I decided to post here for the community. This script generates INSERT statements for table data. This is very handy when you want to script the sample data during customizations etc., to be deployed at another environment. [...]
July 21, 2011 · veeyeskay · One Comment
Tags: Insert Statements, SQL Script, Table Data · Posted in: SQL Server, SQL Server 2005 Total Views: 246