web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Opening Balance is not...
Finance | Project Operations, Human Resources, ...
Suggested Answer

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

(0) ShareShare
ReportReport
Posted on by SiuKK 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 

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi Sarah,

    Have you tried to run a reconcile for the open year(s) and the previous (historical) closed year in the Finance module ? That should recalculate the opening balance of the accounts.

  • SiuKK Profile Picture
    SiuKK 45 on at

    Hi Beat,

    Thanks for your reply.

    I just tried to reconcile all historical years and the new open year in the Finance module but the result is still the same. Do I need to do it before the year-end close is done?

    Regards,

    Sarah

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi Sarah,

    No, the GL reconcile can be run any time, before or after, and if there is something to recalculate, it would do it.

    Are you using the Datamart with MR 2012 ? or the legacy connector ? it could be that you need to rebuild the DataMart in this case..

    Did your year-end close process completed successfully with all the reports printed out ? no interruptions ?

  • SiuKK Profile Picture
    SiuKK 45 on at

    Hi Beat,

    Yes. We are using MR 2012 but how do I check whether it's Datamart or legacy connector?

    The year-end close process completed successfully without interruptions and the year-end transaction generated seems to be accurate too.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Sarah,

    In all recent MR setups, the company names are followed by a -Curr suffix when they are using the Legacy Connector, which taps directly into the GP companies to retrieve data.

    If the company name in MR has no suffix, then it is likely connected with the DataMart.. at which point you may want to try a refresh.

    Here is a link for directions on how to proceed. You may want to pass this to your DBA or IT department.

    www.gpug.com/.../management-reporter-rebuilding-your-data-mart

    www.encorebusiness.com/.../

    PS: Depending on who installed the MR 2012 in your company, you could also check to get the Legacy connector installed and try to run the same MR reports with the other company link (i.e. TWO-Curr) to validate if it returns the proper numbers, before you scrap the DM database.

  • Greg Byer Profile Picture
    Greg Byer 2,586 on at

    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.  

  • SiuKK Profile Picture
    SiuKK 45 on at

    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

  • SiuKK Profile Picture
    SiuKK 45 on at

    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

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    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.

  • SiuKK Profile Picture
    SiuKK 45 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 565 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans