Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Fiscal Period Recalcul...
Microsoft Dynamics GP (Archived)

Fiscal Period Recalculated now MR2012 is showing ghosted Accounts

(0) ShareShare
ReportReport
Posted on by sueconrod 337

Customer recalculated his fiscal period by mistake.  Had him run Financial Reconcile, dropped the Smart Connect DM and recreated.  Now on his February report he sees $5,000 on an account and when he drills in it does not exist.  The same $5,000 shows up in March and you can drill to it.  The customer is using a 4-4-5 calendar and I did notice that the five accounts that he is off on all have the same issue and for the same date February 23 which is the beginning of his fiscal period in March.  Has anyone else run into this and how do you resolve.

*This post is locked for comments

  • Verified answer
    sueconrod Profile Picture
    sueconrod 337 on at
    RE: Fiscal Period Recalculated now MR2012 is showing ghosted Accounts

    Finally got it working.  Found out that AST had gone in and stopped the services and the integration to Data Mart but did not delete the DataMart.  Had them go back in do the same and this time actually delete and then go into the console and add the ERP for datamart and then had client reconcile financial one more time and everything is working

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Fiscal Period Recalculated now MR2012 is showing ghosted Accounts

    Just as I pushed my last suggestion, I remembered a post about the 4-4-5 fiscal period setup not working with the Data Mart configuration of Management Reporter in Dynamics GP.  Here is the Thread.  It seems the Legacy mode works fine, as it pulls directly from GP.

    community.dynamics.com/.../108433.aspx

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Fiscal Period Recalculated now MR2012 is showing ghosted Accounts

    Sue,

    In my experience, recalculating Fiscal periods, does not change financial data until Financial Reconcile is run against the new period structure.  I would recommend thoroughly checking the current Fiscal Period Setup to ensure it is accurate.

    It sounds like you did destroy and recreate the Data Mart for Management Reporter, after the changes were made. Given this is the case, I would recommend the following approach to resolving this problem.

    Check the Fiscal periods, make sure they are perfect, then rerun Financial Reconcile, then clear cached financial data and destroy and recreate the Management Reporter Data Mart. Make sure you have a backup first.

  • sueconrod Profile Picture
    sueconrod 337 on at
    RE: Fiscal Period Recalculated now MR2012 is showing ghosted Accounts

    BTW customer is not using Analytical Accounting

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

News and Announcements

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans