SQL Script to Reconcile GL vs. AA Balances for Accounts Payable
Hi all Some time back, I had posted an article to reconcile between GL and AA tables. This article can be found here. Today I had decided to write up a simple SQL script to reconcile the balances for every account currency combination between the General Ledger tables and the Analytical Accounting tables specifically to [...]
January 17, 2011 · 
veeyeskay · 
One Comment
Tags: Account Balances, Accounts Payables, Analytical Accounting, Reconciliation · Posted in: Accounts Payables, Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2005 Total Views: 635
SQL Script to Reconcile GL vs. AA Balances
Hi all Having used Analytical Accounting for quite some time now, I have come across various issues in Analytical Accounting module, which has caused serious data discrepancy between the General Ledger tables and the Analytical Accounting tables. So I had decided to write up a simple SQL script to reconcile the balances for every account [...]
May 16, 2010 · veeyeskay · 6 Comments
Tags: Account Balances, Analytical Accounting, General Ledger, Reconciliation · Posted in: Analytical Accounting, Dynamics, General Ledger, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 Total Views: 1,772