Scribblings of a Microsoft Dynamics GP MVP
Trial Balance Detail report is out of balance in GL
One of the most common problem you come across while using Multicurrency module is the Detailed Trial Balance report in GL being out of balance.Microsoft has already published an automated solution for this issue in the partnersource/customersource.
Here is the excerpt from the KB document to overcome this issue.
Step 1. First, open the Trial Balance Report Options window for the Detailed Trial Balance Report by selecting the report option and click the Modify button.
• If you use Microsoft SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to Programs, point to Microsoft SQL Server 2005, and then clickSQL Server Management Studio.
Method #2: Use the automated solution for “General Ledger Out of Balance” to find the unbalanced journal entries. This solution can be found using the link below to KB 935384.
a. In the Include section, make sure the checkbox for
Unit Accounts is not marked.b. In the Include section, make sure the checkbox for
Inactive Accounts is marked.c. Print the report again.
Step 2. If the Detailed Trail Balance Report is still unbalanced, then you will need to identify the GL transaction that is causing the difference. To do this, use one of the methods below: Method #1: Use SQL scriptsa. Use the appropriate step below to open SQL Server Management Studio:
• If you use
SQL Server 2000, start SQL Query Analyzer. To do this, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.• If you use Microsoft SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to Programs, point to Microsoft SQL Server 2005, and then clickSQL Server Management Studio.
• If you use
Microsoft SQL Server 2008, start SQL Server Management Studio. To do this, click Start, point to Programs, point to Microsoft SQL Server 2008, and then clickSQL Server Management Studio.b. Copy the below script in to a query window and execute against the company database to identify unbalanced journal entries.
select JRNENTRY, sum(DEBITAMT) - sum(CRDTAMNT) from GL20000, GL00100 where ACCTTYPE = 1 group by JRNENTRY having sum(DEBITAMT) - sum(CRDTAMNT) <> 0
Method #2: Use the automated solution for “General Ledger Out of Balance” to find the unbalanced journal entries. This solution can be found using the link below to KB 935384.
KB 935384 – Automated Solutions that are available for the Financial series in Microsoft Dynamics GP
KB 865712 – The beginning balance for the current year does not balance in the General Ledger in Microsoft Dynamics GP
Visit link:
Trial Balance Detail report is out of balance in GL