Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV forum / On prem NAV extract
Microsoft Dynamics NAV forum
Suggested answer

On prem NAV extract

(1) ShareShare
ReportReport
Posted on by CJ-12071943-0
Greetings,
 
we used nav on prem from 2020-2022.  We moved away from it and now are faced with what to do with the server it is housed on.  We need to keep the financial data for another 5 years.  Is there a way to export and store all the data?  What have others done?
 
Thank you,
Chris
Categories:
Administration and Setup
  • YUN ZHU Profile Picture
    YUN ZHU 63,857 Super User on at
    On prem NAV extract
    Hi, It is best practice to export the required data to Excel.
    In addition, some partners retain the SQL license and continue to access BC data using external tools.
     
    Hope this can give you some hints.
    Thanks.
    ZHU
  • Manish Sharma Profile Picture
    Manish Sharma 8 on at
    On prem NAV extract
    If you are planning to reuse the server then, you can setup a desktop / laptop and move you NAV there, so the audit can be carried out smoothly if required in future.
  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,254 Super User on at
    On prem NAV extract
    most user friendly way would be to keep it alive for another 5 years. 

    If it is enough just to have transactional data, You could export all the needed tables to Excel, but then it could get complicated when users needs to find some additional details about specific transaction (like additional dimensions), and You will not be able to create printouts (like sales invoices) if it is needed.


    I have seen only 1 company where exporting transactional data to excel was enough, others usually keep the system running, with only 1 or 2 users having access to it and providing needed information to other users upon request. 

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans