Financial Summary Inquiry Showing zero balances Per Period with Correct Totals

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

Solution:

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:

Best Regards, 
Mahmoud M. AlSaadi