Finance | Project Operations, Human Resources, ...

Opening Balance is not showing in Management Reporter after Year-end process

(0) Share

Report

Posted on by SiuKK

Hi,

I have just performed a Year-End Close and the Trial Balance for the new year shows an updated opening balance for my Balance Sheet accounts. I can locate my year-end close transactions with period 0 and the transaction looks fine. However, in my management reporter, the Balance Sheet is not showing an accumulated balance with prior year ending balance (opening balance for new year). For example, my period 1 net balance is $500 and opening balance is $1000 so it should show as $1500 but it is not no matter if I choose YTD or YTD/BB on the management reporter column.

One thing I note is that when I query on Smartlist, the prior year open year is showing "blank" for period 0, but the new year-end transaction is showing open year 2022. May I know if that could be the issue or how should I approach this issue?

Regards,

Sarah

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (15)

Answers (0)

Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

RE: Opening Balance is not showing in Management Reporter after Year-end process

Sarah,

I did a quick test in my Fabrikam (TWO) demo company with MR 2012 CU16 (one of the latest build), where my current open year is 2024:

My column definition is very simple and looks like this:

This should technically return the opening balance in the YTD column.

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

RE: Opening Balance is not showing in Management Reporter after Year-end process

Sarah,

Debugging problems in MR through the forums isn't quite easy, as there are a lot of moving parts in MR, not to speak about the various CU versions of MR, which we don't know which one you have. There has been a bug reported in the past about the Budget values not retrieved properly from GP.

This case is something you would need to work more closer with either your partner or open a technical support case with Microsoft.

Aside of the obvious usual problems that users encounter on MR, it's hard to assist remotely without 'seeing' the system..

docs.microsoft.com/.../account-balance-is-missing-when-exclude-inactive-accounts-is-checked

community.dynamics.com/.../management-reporter-balances-wrong

technologyblog.rsmus.com/.../

www.frxbuzz.com/.../

support.microsoft.com/.../account-balance-is-missing-in-management-reporter-2012-for-dynamics-gp-when-exclude-inactive-accounts-is-checked-4228b3a4-55f7-06af-2ddc-1a4159c53c61

community.dynamics.com/.../management-reporter-2012-not-recognizing-new-budget-in-column-definitions

https://support.microsoft.com/en-us/topic/microsoft-management-report-does-not-display-budget-amounts-for-budgets-that-use-a-date-range-ee0f55fc-0dda-2b2a-9972-0f46177c1c26

Was this reply helpful? Yes No
Greg Byer 2,586 on at

Like (0)

Report

RE: Opening Balance is not showing in Management Reporter after Year-end process

With the Legacy provider, MR is reading directly from the GL tables. If the data is correct in the GL20000, you should see the same amounts in MR. I'd look at the report design and make sure everything is correct there.

Is the company in the report set correctly?

Is there are a range of accounts on the row?

Is the column set to BASE or something else for the Period?

You may want to try a simple report with only one account in the row. Then add a Periodic column and see if you get the correct amount for that.

Was this reply helpful? Yes No
SiuKK 45 on at

Like (0)

Report

RE: Opening Balance is not showing in Management Reporter after Year-end process

Hi Beat,

I hope this is the case that it's not linked to DataMart because I actually have another issue on MR that it cannot capture the budget amount that I have imported as well. At the end, I just create an Excel Refreshable report to get my figures for my report.

We do have a few GP companies for testing and I have ensured that I select the company in MR that I'm running but still there is no luck to get them right.

Regards,

Sarah

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

RE: Opening Balance is not showing in Management Reporter after Year-end process

Sarah,

This is good news, and the fact that your companies are linked thru -Curr names means also there is no DataMart in the game and you don't have to worry about rebuilding the DM DB.

Do you have multiple GP companies ? Can you check if your default selected company in MR is the one you're running the TB report against ? (you can see the 'default' company name at the bottom of the MR Designer window, in the status bar).

Was this reply helpful? Yes No
SiuKK 45 on at

Like (0)

Report

RE: Opening Balance is not showing in Management Reporter after Year-end process

Hi Beat,

I have run the first SQL query and it does show the year-end close transactions for my new open year 2022 with sourcedoc 'BBF' and periodID 0.

For the second SQL query, only the current year 2022 are showing HISTORYR 0 and all others are showing as 1 so I believe all historical years are closed already.

Regards,

Sarah

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

RE: Opening Balance is not showing in Management Reporter after Year-end process

Hi Sarah,

Yes, this means you're not using the DataMart connector.

If you do have access to SQL Management Studio (or someone that has), can you please run the following query:

SELECT top 100 * FROM [TWO].[dbo].[GL20000]

where OPENYEAR = 2021

and SOURCDOC = 'BBF'

and PERIODID = 0

Replace the [TWO] database name by your company DB name and the OPENYEAR by the new FY.

If the books were closed properly, the current open year should show those entries, if there are none, it means something wasn't completed during the year-end process.

Also, please run this script to show which FY are currently historical and which ones are open:

select top 20 * from TWO.dbo.SY40101

Again, replace the TWO company name by your own company DB name.

Was this reply helpful? Yes No
SiuKK 45 on at

Like (0)

Report

RE: Opening Balance is not showing in Management Reporter after Year-end process

Hi Greg,

I have checked the Summary Inquiry window that the Beginning Balance does not match my YTD/BB and Period Balance does not match my YTD as well. However, since my company name has suffix of -Curr, is that mean it's not related to the Data mart?

Regards,

Sarah

Was this reply helpful? Yes No
SiuKK 45 on at

Like (0)

Report

RE: Opening Balance is not showing in Management Reporter after Year-end process

Hi Beat,

After checking, the company names are followed by a -Curr suffix so is that mean it's not related to the Data Mart?

Regards

Sarah

Was this reply helpful? Yes No
Greg Byer 2,586 on at

Like (1)

Report

RE: Opening Balance is not showing in Management Reporter after Year-end process

Hi Sarah,

Along with what Beat has posted, I would check the balances in the GL20000, or the Summary Inquiry window. MR should match what is there. The YTD/BB balance in MR should match the Beginning Balance in the Summary Inquiry. The YTD in MR should match the Period Balance in the Summary Inquiry. If the MR amount does not match that, then you'll most likely need to rebuild the data mart.

Was this reply helpful? Yes No