Featured Post

Dynamics GP 2016 R2 is Now Available .. and #MSDynGP will Always be Avilable

The Microsoft Dynamics GP team announced today that Microsoft Dynamics GP 2016 R2 has released . Dynamics GP 2016 R2 continues the grea...

Wednesday, December 23, 2015

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

No comments:

Post a Comment