You’re offline. This is a read only version of the page.
Announcements
45
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
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.
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
community.dynamics.com/.../management-reporter-2012-not-recognizing-new-budget-in-column-definitions
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.
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
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).
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
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.
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
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.
#1
André Arnaud de Cal...
294,259
Super User 2025 Season 1
#2
Martin Dráb
232,988
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
