Small and medium business | Business Central, N...

Migrate report from NAV 2016 to Business Central

(0) Share

Report

Posted on by SelfStarter

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!

All responses (13)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

RE: Migrate report from NAV 2016 to Business Central

Hello,

I would highly recommend you look at ForNAV.

https://www.fornav.com/

They have a way to convert NAV AL to Business Central.

Thanks,

Steve
Sam William 15 on at

Like (0)

Report

RE: Migrate report from NAV 2016 to Business Central

Microsoft Business Central Upgrade brings technological benefits and features enhancement. With 100s of successful upgrades, our experienced team is well equipped to help you transition from Navision to Dynamics 365 Business Central. Contact us for smooth migration NAV 2016 to Business Central 2021 Wave 1.
SelfStarter 70 on at

Like (0)

Report

RE: Migrate report from NAV 2016 to Business Central

Hi Tanya,

Thanks for your reply!

But if I need to upgrade some customized reports in NAV 2016 to Business Central, do I need to upgrade the entire database?
SelfStarter 70 on at

Like (0)

Report

RE: Migrate report from NAV 2016 to Business Central

Hi Giambattista,

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

tanya07 1,636 on at

Like (0)

Report

RE: Migrate report from NAV 2016 to Business Central

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.
Giambattista Malvasi 195 on at

Like (0)

Report

RE: Migrate report from NAV 2016 to Business Central

you can change destination folder?
SelfStarter 70 on at

Like (0)

Report

RE: Migrate report from NAV 2016 to Business Central

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.
Suggested answer

Giambattista Malvasi 195 on at

Like (0)

Report

RE: Migrate report from NAV 2016 to Business Central

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

Like (0)

Report

RE: Migrate report from NAV 2016 to Business Central

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...
SelfStarter 70 on at

Like (1)

Report

RE: Migrate report from NAV 2016 to Business Central

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