GL Reconciliation SQL Script – Receivables
Hi all This script can be used as a base to reconcile the receivables sub-ledger balances as of a certain date. DECLARE @ASOFDATE AS DATETIME SET @ASOFDATE = ’2017-04-12′ SELECT Z.* FROM ( SELECT A.[OPENYEAR] TRXYEAR, A.[ORTRXSRC] AS ARAUDITTRAIL, A.[ORMSTRID] AS ARCUSTOMERNO, A.[ORCTRNUM] AS ARDOC Read the rest of this entry
November 7, 2010 · 
veeyeskay · 
5 Comments
Tags: Accounts Receivables, General Ledger, Receivables Reconcoliation · Posted in: Accounts Receivables, Dynamics, General Ledger, Great Plains, SQL Server 2005, SQL Server 2008 Total Views: 577
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
Dynamics GP Year End Procedure
Year End Closing for Dynamics GP Module must be done in following order A)
December 7, 2009 · Sandip Jadhav · No Comments
Tags: Accounts Receivables, amounts, calendar, customer, fixed-assets, General Ledger, Inventory, microsoft, new-year, reference, sales, Sales Order Processing, Summary · Posted in: Blogs I Follow Total Views: 262