News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Financial Reporter pic...

Finance | Project Operations, Human Resources, ...

Answered

Financial Reporter picking old data after backup restore

(2) Share

Report

Report

Posted on by Mandeep.S

219

Hello,

We have an on-prem D365 FnO (10.0.40).

Last week there was a problem with the FinancialReporting SQL database and we had to restore an older (7 day old) backup. Now when I run Financial reports, the 7-day old data is picked up. How do I resync FinancialReporting to AXDB?

Thanks

Categories:

Dynamics 365 Finance

All responses Img

All responses (2)

Answers Img

Answers (1)

Mandeep.S 219 on at

Like (0)

Report

Financial Reporter picking old data after backup restore

Thanks Andre,

That worked!
Verified answer

André Arnaud de Cal... 291,472 Super User 2024 Season 2 on at

Like (1)

Report

Financial Reporter picking old data after backup restore

Hi Mandeep,

You can perform a 'reset' action on the DataMart database. Read the documentation for more information: Reset the Financial reporting data mart - Finance & Operations | Dynamics 365 | Microsoft Learn

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,472 Super User 2024 Season 2

#2

Martin Dráb 230,560 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans