RSSCategory: Accounts Payables

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

Posting Interruptions in Accounts Payable – Check Runs

| 11/24/2011 | 3 Comments
Posting Interruptions in Accounts Payable – Check Runs

Recently, I was responding to a forum discussion where the issue mentioned was as shown below. “Occasionally, one of the subsystems that we integrate invoices from will send over an invoice with an incorrect date (11/20/1911 instead of 11/20/2011).  These invoices post just fine.  However, when we process a check run that includes an invoice […]

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

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