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
Enhanced Inventory Item Reconciliation
I have several customers suffers reconciling their items the traditional way, they sometimes due to the huge number of transactions finds items contains “Allocated” quantities while it is actually not. The normal process to fix this up is by following the standard procedure by getting all users outside GP > > Go to tools > > Utilities > > Inventory > > Reconcile, easy steps but what if you have a large number of items and wanted to perform this operation? This will definitely take hours.
April 25, 2011 · · No Comments
Tags: additional-fees, dvd, dynamics, dynamics gp general, microsoft, mohammad r. daoud, Reconciliation, services-tools, standard, utilities · Posted in: Blogs I Follow Total Views: 52
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
Dynamics GP Product Reviews
Two more product reviews for Dynamics GP have been added at www.GPWindow.com Check out the review of Omni Price and Nolan Advanced Bank Reconciliation Mekorma MICR – Dynamics GP Product Reviews #1 Greenshades Center – Dynamics GP Product Reviews #2 Nolan Advanced Bank Reconciliation – Dynamics GP Product Reviews #3 Omni Price by Rockton – Dynamics GP Product Reviews #4
November 19, 2010 · · No Comments
Tags: dynamics, dynamicsgp, gp isvs, nolan-advanced, price, product, Reconciliation, review, rockton · Posted in: Blogs I Follow Total Views: 125
SOP Quotations Import – Issue & Solution
Recently, I had to integrate around 1000+ Sales Quotations which comprised of 10000+ Sales Item Lines. This had to be done in a seemingly impossible timeframe, as we were totally running out of schedule
October 19, 2010 · Vaidyanathan Mohan · No Comments
Tags: Customizations, databases, gp functionality, integration, number, number-sequence, perception, Reconciliation, source · Posted in: Blogs I Follow Total Views: 132
SQL view for Dynamics GP Checkbook Register
The view below will return all Checkbook transactions for Dynamics GP. It does not show details for the deposits because I wanted to keep this to one line per transaction, as it appears on the Checkbook Register in GP.
October 14, 2010 · Victoria Yudin · No Comments
Tags: bank rec sql code, bank reconciliation, checkbook, dynamics, gp reports code, gp sql scripts, per-transaction, Reconciliation, suggestion, venkataraman, victoria yudin, victoria-yudin · Posted in: Blogs I Follow Total Views: 121
Maintaining Data Integrity between Sub Ledgers and General Ledger
Hi all I have been involved in the process of reconciliation between the sub ledgers and the general ledger at various clients and there has been various scenarios in which there has been a break between the sub ledgers and the general ledger balances. A few key scenarios are quoted below A transaction posted in [...]
May 16, 2010 · veeyeskay · No Comments
Tags: Accounts Payables, Accounts Receivables, General Ledger, Inventory, Reconciliation · Posted in: Accounts Payables, Accounts Receivables, Dynamics, General Ledger, Great Plains, Inventory Total Views: 2,017
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
Multicurrency Revaluation Series – Part III – Summary Balance Checks and Reconciliation
Hi all This is the second part of the series of articles I am planning to write up on multi-currency revaluation process in Dynamics GP. In the earlier articles titled Multicurrency Revaluation Series – Part I – Revaluation Setup and Multicurrency Revaluation Series – Part II – Revaluation Process Logic, I had given some insight [...]
May 15, 2010 · veeyeskay · No Comments
Tags: Multicurrency, Reconciliation, Revaluation, Summary Tables, Transaction Details · Posted in: Dynamics, General Ledger, Great Plains Total Views: 925