Article ID: 2428683 - View products that this article applies to.
The Trial Balance Detail report in GL is out of balance due to an unbalanced journal entry, or rounding difference using Multi-currency.
To print the Trial Balance Detail report, click on Reports, point to Financial and click on Trial Balance. Under Reports, select Detailed. Insert a report option or create a new report option. In the Trial Balance Report Options window, select the report restrictions as needed and save. Print the report to verify if the total debit amount is equal to the total credit amount.
Follow the steps below to locate unbalanced journal entries:
Step 1: Print the Trial Balance report
Step 2: Identify unbalanced General Ledger transaction(s)To identify unbalanced GL transaction(s), use one of the options below. To run a script that will identify the GL transaction for you, go to the Option 1: "Fix it for me" section. To run a script yourself that will identify the GL transaction, go to the Option #2: "Let me fix it myself" section.
Option #1: Fix it for meTo have us run a script that will identify (not 'fix') the GL transaction automatically, click the Fix this problem button or link. Click Run in the File Download dialog box, and then follow the steps in the Fix it wizard.
Fix this problem
Microsoft Fix it 50422
Note This wizard may be in English only; however, the automatic fix also works for other language versions of Windows.
Note If you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.
Option #2: Let me fix it myselfTo identify (not 'fix') the GL transaction yourself, follow these steps:
Method #1: Use SQL scripts
KB 935384 - Automated Solutions that are available for the Financial series in Microsoft Dynamics GP
Step 3: FixOnce you have identified the unbalanced journal entry, the course of action will vary depending on if it is in a current open year, or in a historical year as follows:
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.
Article ID: 2428683 - Last Review: December 16, 2014 - Revision: 9.0