myGPcloud
myGPcloud Blog
myGPcloud on Twitter
Rose Business Solutions
RoseASP
Linda Rose LinkedIn
Rose Business Solutions on YouTubeReconcile to GL Easily
February 13th, 2008 | 
Author: Have you used this yet? In GP 10 there’s a routine (Microsoft Dynamics GP menu >> Tools >> Routines >> Financial >> Reconcile to GL) that will assist you in reconciling Payables Management and Receivables Management to the General Ledger. This routine matches transactions in RM & PM, to GL and shows the results in Excel.
From the GP 10 documentation:
During normal business operations, thousands of transactions can be processed. When working with this volume of transactions, standard processes might be inadvertently changed or unintended entries made and posted. As a result, the payables or receivables balances on a General Ledger trial balance report might not match the corresponding balance on trial balance reports printed in Payables Management or Receivables Management. Some specific examples might include the following :
• A transaction is posted to—but not through—General Ledger and is deleted before it’s posted in General Ledger.
• A transaction is posted to General Ledger, but the amounts are changed before it’s posted in General Ledger.
Use the Reconcile to GL window to generate a Microsoft Excel spreadsheet that can help you match transactions in General Ledger with the originating transactions in Payables Management and Receivables Management. This spreadsheet can provide information that helps you enter adjusting transactions that reconcile any discrepancies.
Transactions are displayed on the spreadsheet using the functional currency. To be included in the spreadsheet, transactions must be posted and exist in either an Open or History table. Transactions also must include distributions to either the Accounts Payable account or Accounts Receivable account, or the Discount Available account in Payables Management or Receivables Management.
The results are categorized as follows:
Posted in 
Tags: 
4 Responses to “Reconcile to GL Easily”
Leave a Reply
The first time I tried to run the GL reconciliation, I got the following message:
When you perform the “Reconcile to GL” process for Payables Management in Microsoft Dynamics GP 10.0, you receive the following error message:
[Microsoft][SQL Native Client][SQL Server]Violation of PRIMARY KEY constraint ‘PK##Tablename’. Cannot insert duplicate key in object ‘dbo.##Tablename’.
Note In this error message, Tablename is a placeholder for the table name.
There is a TechKnowledge 952380 that contains a zipped file with a SQL query that will fix the problem.
Remember that you should backup the database before running SQL queries.
After I ran the SQL query, the reconciliation process ran fine.
Reconciling GP now easier with The Closer. Along with being a better solution for AP & AR, The Closer also handles Inventory, SOP, COGS, Accrued Purchases and CASH. Check out http://www.reporting-central.com
[...] This post was mentioned on Twitter by RoseBusinessSolution. RoseBusinessSolution said: Reconcile to GL Easily in Dynamics GP: http://tinyurl.com/27wqrpp [...]
[...] This post was mentioned on Twitter by RoseBusinessSolution. RoseBusinessSolution said: Reconcile to GL Easily in Dynamics GP: http://tinyurl.com/27wqrpp [...]