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 / Small and medium business | Business Central, N... / Migrate report from NA...
Small and medium business | Business Central, N...
Suggested Answer

Migrate report from NAV 2016 to Business Central

(0) ShareShare
ReportReport
Posted on by SelfStarter 70

Hi All,

I need to migrate custom reports from NAV 2016 to Business Central 2021 Wave 1. As I am new to Business Central need some help if possible. Can you please let me know the process for migration. Also I would like to mention that my Business Central is in on-premise environment.

Thank you!

I have the same question (0)
  • Suggested answer
    Giambattista Malvasi Profile Picture
    Giambattista Malvasi 195 on at

    Open this:

    simplanova.com/.../

  • SelfStarter Profile Picture
    SelfStarter 70 on at

    Thanks a lot Giambattista for replying. I will try the process mentioned in the link provided by you...

  • Giambattista Malvasi Profile Picture
    Giambattista Malvasi 195 on at

    Don't forget to help the community by verifying the answer if your question has been answered. It will let others know that the topic has verified answer.

  • SelfStarter Profile Picture
    SelfStarter 70 on at

    Sure! as I am successfully done with the process I will verify the answer as yes...

  • SelfStarter Profile Picture
    SelfStarter 70 on at

    Hi Giambattista,

    I was trying out the steps for the reort migration.

    But in my Business central installation there is no finsql.exe file in the path:

    C:\Program Files (x86)\Microsoft Dynamics 365 Business Central\180\RoleTailored Client

    So for the command the command

    cd C:\Program Files (x86)\Microsoft Dynamics 365 Business Central\180\RoleTailored Client

    finsql.exe Command=ExportToNewSyntax, File="F:\NAV Projects\Extensions\CAL\export.txt", Database="NAV2016CU66", ServerName=.\SQLEXPRESS, Filter=Type=report;ID=50078

    I get the error finsql.exe' is not recognized as an internal or external command, operable program or batch file.

    I am not sure if my Business Central installation has an issue or what becasue the instance runs perfectly.

    Can you please suggest on the issue...

  • Suggested answer
    Giambattista Malvasi Profile Picture
    Giambattista Malvasi 195 on at

    you don't have to use 180 to export the report. I believe you need to use 90.

  • SelfStarter Profile Picture
    SelfStarter 70 on at

    Hi Giambattista!

    As per your suggestion I changed the command as below

    cd C:\Program Files (x86)\Microsoft Dynamics NAV\90\RoleTailored Client

    finsql.exe Command=ExportToNewSyntax, File="F:\NAV Projects\Extensions\CAL\export.txt", Database="NAV2016CU66", ServerName=.\SQLEXPRESS, Filter=Type=report;ID=50078

    It didn't throw me an error in cmd and ran smoothly. But in my destination folder no file got exported.

    And when I checked the naverrorlog.txt for error logs it mentioned [29885216] The "exporttonewsyntax" command is not valid.

  • Giambattista Malvasi Profile Picture
    Giambattista Malvasi 195 on at

    you can change destination folder?

  • Suggested answer
    tanya07 Profile Picture
    tanya07 1,638 on at

    As far I remember , The "exporttonewsyntax" parameter only works for 2018 and above.

    You can technically upgrade the 2016 DB to 2018(v11) DB and then use this command.

  • SelfStarter Profile Picture
    SelfStarter 70 on at

    Hi Giambattista,

    Tried it, got the same output as above...

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,010

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,270 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,085 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans