One of the most common cases is to have incorrect summary balances, which usually rings a bell to run the reconciliation, although, in this specific case, the summary inquiry is showing zero balances per period, while totals are correct.
|Summary Inquiry - Zero Period Balances|
The first step was to check the summary balances tables (open and history), which are (GL10110 and GL10111), which have correct period balances
|GL10110 and GL10111|
Following the case on the profiler shows that the inquiry is checking the General Ledger setup - Reporting Ledger table, which "mistakenly" has no records. Therefore, the inquiry is not being populated with the correct balances.
|General Ledger Setup - Reporting Ledger|
Go to Microsoft Dynamics GP > Tools > Financial > General Ledger.
|General Ledger Setup|
Click on the "Base" option under the Account Balances for Subsidiary windows, this in turn populate the GL40001 table, then click Ok.
Now, the financial summary inquiry is working perfectly as shown below:
Mahmoud M. AlSaadi