RSSCategory: SQL Server 2005

SQL Script for AP-GL Reconciliation – Updated

| 03/07/2012 | 4 Comments
SQL Script for AP-GL Reconciliation – Updated

Hi all Sometime back, I had posted the SQL Script for AP-GL Reconciliation in my blog. At the time of posting the script, it had supported only one account index for AP. Today, I have updated the script to support multiple account indexes for Accounts Payable. Please take a look at the updated script in […]

Continue Reading

SQL Script for AP-GL Reconciliation

| 01/17/2012 | 7 Comments
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 […]

Continue Reading

SQL View for Daily Payment Summary

| 08/05/2011 | 2 Comments
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 […]

Continue Reading

Post Through GL for Computer Checks – with Analytical Accounting

| 08/04/2011 | 0 Comments
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 […]

Continue Reading

Payables HATB With Aging By Payment Terms (using Document Date)

| 07/25/2011 | 2 Comments
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 […]

Continue Reading

Payables HATB With Aging By Payment Terms (using GL Posting Date)

| 07/25/2011 | 1 Comment
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 […]

Continue Reading

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

| 07/25/2011 | 3 Comments
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 […]

Continue Reading