How to migrate NAV 2016 India IN to Business Central Part 1

Поділитися
Вставка
  • Опубліковано 9 лис 2024

КОМЕНТАРІ • 116

  • @2005ANILKUMAR
    @2005ANILKUMAR 3 роки тому +1

    very useful and wonderful explanation

  • @priyanshujoshi8305
    @priyanshujoshi8305 3 роки тому +1

    Very useful video sir👍thanks

  • @mohamedelseidy4600
    @mohamedelseidy4600 3 роки тому +1

    Very very helpful continue

  • @manshuverma5060
    @manshuverma5060 3 роки тому +1

    Very informative 👍

  • @8ullaa
    @8ullaa 3 роки тому +1

    Very informative

  • @ketanpjain
    @ketanpjain Рік тому

    Hello Rishab,
    On the step: "Any customer specific fields created in the below tables, has to be merged in the Upgrade90014x.IN.fob." I have changes in "Item" table. Can you please help me on how to merge the changes into the upgrade fob??

  • @sahilluthra8757
    @sahilluthra8757 2 роки тому +1

    Nice Video but didn't understand one thing. Where is the setup for v14 IN localisation. Can you please share the download link.

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому +1

      download.microsoft.com/download/c/6/4/c64076e6-7a9e-4a7b-b2e4-1b35fcbe3eae/Dynamics.14x.IN.3478340.DVD.zip

    • @sahilluthra8757
      @sahilluthra8757 2 роки тому +1

      @@rishabhshukla2240 Thank You So much Rishabh. Your video is really helping me out. Can you please tell one more thing, While installing the apps after synching I get an error and it says 'Cannot install apps due to the state of tenant: OperationalWithSynFailure.' I am unable to resolve it.

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      @@sahilluthra8757 thank you !…..go to tools -> Sync schema -> check only you can do it from powershell as well

  • @ManiKandan-mi1ld
    @ManiKandan-mi1ld 3 роки тому +1

    very useful.. Please share it the upgrade microsoft document link

    • @rishabhshukla2240
      @rishabhshukla2240  3 роки тому +1

      docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/india-data-migration-toolkit-overview

    • @ManiKandan-mi1ld
      @ManiKandan-mi1ld 3 роки тому +1

      @@rishabhshukla2240 thank you so much

  • @knsaicharan
    @knsaicharan 10 місяців тому

    Hi Rishab, I'm actuallly upgrading from NAV2016 to BC22 there is a lot of data in GST and TDS and they are not migrated, because in NAV GST table is in 16k series and in BC14 it is in 18k series. Please suggest me a solution how to get that data in BC14 is there any tool for this. I have used xml and config package to insert data but it's tideous as I have around 27L GST and TDS data?

  • @arunkumarp8219
    @arunkumarp8219 2 роки тому

    Hello Rishabh
    In 23:40 minute you created the new Field in the Standard Table 16404 GST Group, but I think that we need to either create a table extension or a new Table. Pls suggest whether we should create a new or Extension.

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      Hi Arun I am adding that field in upg gst group table not on standard one… so when you are going to import w1 objects and remove in range objects then toolkit will move the data of those fields and tables to upg tables and then we move that upg tables data to main extension tables that’s when you will move that fields data to table extension.

  • @krishna7dce
    @krishna7dce 16 днів тому

    The UPG General Ledger Setup does not exist. Identification fields and values: Primary Key=''. hi sir, when I run the start data migration from BC14 getting this error. How to resolve this ?

  • @girishbisht8041
    @girishbisht8041 5 місяців тому +1

    i not understand about w1 objects

  • @arunkumar0129
    @arunkumar0129 2 роки тому +1

    Hi @Rishabh
    In 28:10 minute You are importing W1 fob file. How to get W1 objects fob file to import.

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      When you install IN BC14 it restores a W1 DB you can export it from there.

    • @arunkumar0129
      @arunkumar0129 2 роки тому

      @@rishabhshukla2240 Which folder it is ??? I mean name because I checked every folder in IN BC14 but I didn't find that W1 obj file

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      @@arunkumar0129 its not in folder , when you instal BC14 restore SQL demo db which is W1, you can export all object from there.

    • @nishantpatel2275
      @nishantpatel2275 2 роки тому

      @@rishabhshukla2240 Can you please share that Fob file to me.

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      @@nishantpatel2275 I can’t share it here but you can install any W1 BC14 DB to get those FOB

  • @anujpartapsingh2961
    @anujpartapsingh2961 2 роки тому +1

    Hi Rishabh,
    You are refering documentation in your video, but I am not able to find any documentation. Can you please point me where I can find it?

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/india-data-migration-toolkit-overview

    • @anujpartapsingh2961
      @anujpartapsingh2961 2 роки тому +1

      @@rishabhshukla2240 Thank You Rishabh

  • @sourabhsinghrajput4072
    @sourabhsinghrajput4072 2 роки тому +1

    Hi.. I have not done any upgradation and migration yet earlier. And I want to migrate from navision 2017 to business central on cloud. So can you let me know from scratch that what should I do?

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      Hi Sourabh, I believe in general steps are pretty much same except the part where we install India specific apps and all...If you are not doing to migration for India localization then I suggest that you look into the 2nd part of this video where I take a custom BC14 DB to Business central 18. in your case only extra step should be to open 2017 DB to BC14.

  • @rakeshtewatia715
    @rakeshtewatia715 2 роки тому

    Hi Rishab.
    I am upgrading from Nav 2013 to Nav BC 14. I want to know what happened with the data of structure table i.e. data that is present in 13K series. I have data on Structure table but the steps you mentioned don't provide details for the same. Please suggest the solution.Thanks :)

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому +1

      Hi Rakesh, structures are converted and configured in to use cases in tax engine now, all though during migration data is holded up in upg tables till bc14 in case you want to write any specific business logic for the records

  • @Manojkumar-m1k8m
    @Manojkumar-m1k8m Рік тому

    i need a quer for deleting break points and server instance

  • @bhushanborse6872
    @bhushanborse6872 Рік тому

    Could not find file firstparty.ruleset.json getting error while publishing indiaupgradetable extension

  • @kedarsingh1039
    @kedarsingh1039 2 роки тому

    Hi rishabh how we can only application upgrade nav 13 IN version to Business central not data?

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      Hi Kedar, in that case you only need to move your customization to extension app or apps and publish them on any IN based tenant.

  • @nishantpatel2275
    @nishantpatel2275 2 роки тому +1

    Hello sir,
    Can you provide download link for BC14ALLObjectW1(IN) Object..?

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому +1

      download.microsoft.com/download/c/6/4/c64076e6-7a9e-4a7b-b2e4-1b35fcbe3eae/Dynamics.14x.IN.3478340.DVD.zip

  • @ramankumar9476
    @ramankumar9476 2 роки тому

    Hello, Where did you find that BC14 IN localization?

  • @datamandataman
    @datamandataman Рік тому

    The schema synchronization may result in deleted data. The following destructive changes were detected: Table: 4, Currency Field: 13700, Currency Numeric Description: Deleted Field: 13701, Currency Decimal Description: Deleted Field: 13702, Excise Rounding Type: Deleted Field: 13703, TDS Rounding Type: Deleted Field: 13704, Excise Rounding Precision: Deleted Field: 13705, TDS Rounding Precision: Deleted Field: 16500, TCS Rounding Type: Deleted Field: 16501, TCS Rounding Precision: Deleted Field: 16600, GST Inv. Rounding Type: Deleted Field: 16601, GST Inv. Rounding Precision: Deleted Table: 9, Country/Region Field: 13700, Country Code for eTDS/TCS: Deleted Table: 14, Location Field: 13701, Purch. Invoice Nos.: Deleted Field: 13702, Purch. Receipt Nos.: Deleted Field: 13703, Sales Invoice Nos.: Deleted Field: 13704, Sales Shipment Nos.: Deleted Field: 13707, Excise Bus. Posting Group: Deleted Field: 13708, E.C.C. No.: Deleted Field: 13714, State Code: Deleted Field: 16360, Subcontracting Location: Deleted Field: 16361, Subcontractor No.: Deleted Field: 16362, T.A.N. No.: Deleted Field: 16363, T.I.N. No.: Deleted Field: 16364, Service Tax Registration No.: Deleted Field: 16500, T.C.A.N. No.: Deleted Field: 16501, Composition: Deleted Field: 16502, Export or Deemed Export: Deleted Field: 16503, Composition Type: Deleted Field: 16504, Trading Location: Deleted Field: 16505, Testing Location: Deleted Field: 16506, Input Service Distributor: Deleted Field: 16507, Sales Shipment Nos. (Captive): Deleted Field: 16508, Purch. Credit Memo Nos.: Deleted Field: 16509, Sales Return Receipt Nos.: Deleted Field: 16510, Sales Credit Memo Nos.: Deleted Field: 16511, Purch. Ret. Shipment Nos.: Deleted Field: 16512, Transfer Shipment Nos.: Deleted Field: 16513, Transfer Receipt Nos.: Deleted Field: 16514, Purh. Invoice Nos. (Trading): Deleted Field: 16515, Sales Invoice Nos. (Trading): Deleted Field: 16516, Sales Ret Rcpt Nos. (Trading): Deleted Field: 16517, Purch. Ret Shpt Nos. (Trading): Deleted Field: 16518, Purch. Rcpt. Nos. (Trading): Deleted
    Getting Error in Sync-Nav
    Tenant while followed every step as shown in video..... Sir, Do you have any idea which step I am Missing.

  • @arunkumarp8219
    @arunkumarp8219 2 роки тому

    Hello Rishabh
    After Importing Upgrade Toolkit in Nav2016
    I tried for Data Upgrade but I am getting error called You do not have permissions on Code unit UPG8081.W1:Execute & You do not have following Permissions on Code unit Report Layout Upgrades ; Execute
    What should I do for this .......??

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      Hi @Arun, seems more like a license issue to me, can you ensure you are using developer license ?

    • @arunkumarp8219
      @arunkumarp8219 2 роки тому

      @@rishabhshukla2240 Yes I am using developer license only

  • @vishaltakte1
    @vishaltakte1 2 роки тому +1

    Hi rishabh ,
    i am running command synch schema with validation in BC 14 . it will give below error
    PS C:\windows\system32> sync-navtenant bc14_Windows -mode checkonly
    sync-navtenant : The schema synchronization may result in deleted data. The following destructive changes were detected:
    Table: 4, Currency
    Field: 13700, Currency Numeric Description: Deleted
    Field: 13701, Currency Decimal Description: Deleted
    Field: 13702, Excise Rounding Type: Deleted
    Field: 13703, TDS Rounding Type: Deleted
    Field: 13704, Excise Rounding Precision: Deleted
    Field: 13705, TDS Rounding Precision: Deleted
    Field: 16500, TCS Rounding Type: Deleted
    Field: 16501, TCS Rounding Precision: Deleted
    Field: 16600, GST Inv. Rounding Type: Deleted
    Field: 16601, GST Inv. Rounding Precision: Deleted.
    please let me know i need to do with validation or force

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      it means that you Sync is making destructive changes in the database. check if UPG table app has these tables in it if yes then on Sync schema it should move its data to those tables.

    • @vishaltakte1
      @vishaltakte1 2 роки тому

      @@rishabhshukla2240UPG table app having this table. but it is not allowed to sync with validation an d all this field are 13000 to 16000 range field ,if we do with force then data will not transfer upgrade table extension

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      @@vishaltakte1 if the table is available there then check if the fields are in Sync. ex - check if Currency table and UPG Currency table has field 16600 with "GST Inv. Rounding' or not. if they all are same and they all are in sync then Sync with validation should work else if any field is missing in UPG table then you have to manually create it there.

    • @vishaltakte1
      @vishaltakte1 2 роки тому +1

      @@rishabhshukla2240 can you provide your contact no

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      @@vishaltakte1 not here :) but drop me a mail on rishabh.rishabh.shukla1@gmail.com I will send it there.

  • @surajthapa4555
    @surajthapa4555 2 роки тому

    Hi, when are run data upgrade, i getting error ( The Demo Database NAV (9-0) databse has version 1051 which is not supported by this version of Microsoft Dynamics 365 Business Central Server.

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      Hi Suraj, run Sync-Navtenant

    • @surajthapa4555
      @surajthapa4555 2 роки тому

      @@rishabhshukla2240 , Thanks, its Work and how to download (BC14AllObjectW1) fob file.

    • @surajthapa4555
      @surajthapa4555 2 роки тому

      Sir, I getting error, when i trying Sync Schema all tables.......Sync-NAVTenant : Function 'GetTableSyncSetupW1' in the upgrade codeunit '104000' has failed because of the following
      error: 'You do not have the following permissions on CodeUnit UPG.W1: Execute.
      To view details about your permissions, see the Effective Permissions page. To report a problem, refer to the
      following server session ID: '7'.'.
      At line:1 char:1
      + Sync-NAVTenant NAV-2016 -Mode CheckOnly

  • @surajthapa4555
    @surajthapa4555 2 роки тому +1

    Hi, we have on premise business central 19 ver license . can i use ver 14 on production environment.

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      If its for India then NO, you should not be using BC14-IN for production as its only there for doing data migration.

    • @surajthapa4555
      @surajthapa4555 2 роки тому

      Okay, thanks

  • @Jasmine-ht5ef
    @Jasmine-ht5ef 2 роки тому

    Hi Rishabh
    After importing W1 objects and Upgrade toolkit objects
    While Doing Synchorize schema im getting a error Saying
    The Specified Upgrade table 19000 does not exist. Can u tell me where do i find 19000 series objects ? Am i missing something?

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      I think you have not installed "Dynamics.14x.IN.3478190.DVD\extensions\IndiaUpgradeTables.app"

    • @Jasmine-ht5ef
      @Jasmine-ht5ef 2 роки тому

      @@rishabhshukla2240 yes I have published this extension. I Performed the steps as u mentioned in Video.

    • @Jasmine-ht5ef
      @Jasmine-ht5ef 2 роки тому +1

      @@rishabhshukla2240 Only Publishing IndiaUpgradeTables is enough or i want give Install-navapp??

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      yes only publish should work, all though I am not able to understand why your DB in BC14 is asking for schema sync with 19000 table, as that table is part of BC19 India localizations.

    • @Jasmine-ht5ef
      @Jasmine-ht5ef 2 роки тому

      @@rishabhshukla2240 Im upgrading from nav 2013 r2. first i have upgraded from nav 2013 R2 to nav 2016, then nav 2016 to BC 14
      In Upgrade toolkit objects , Codeunit UPG IN, base table are getting copied to 19000 series

  • @Vishal-pn5ue
    @Vishal-pn5ue 2 роки тому

    Why Delete this Object Sir

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      Hi Vishal, you have to as first, they are no longer in use and second you have to import W1 on BC14

  • @mdistiakalam9139
    @mdistiakalam9139 2 роки тому

    Can you give the documentation as a pdf file?

  • @santanupal5507
    @santanupal5507 2 роки тому

    Sir, we are waiting for your reply.

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      Hi Santanu....what was question ? sorry I forgot to check the comments from last couple of days

    • @santanupal5507
      @santanupal5507 2 роки тому

      @@rishabhshukla2240I saw your video on how to migrate NAV 2016 India (IN) to Business Central Indian Version. A few queries arise to ask you.
      1> I used "Dynamics.365.BC.47804.W1", the world version of all objects backup for migration. Is this version OK?
      Because there is no Business Central world version, details are specified in this video.
      2> For example, I made customization in Customer Table (id: 21) without any custom field, whether the system would be migrated the code automatically or not.
      3> It will be helpful to us if you create a video about how to migrate Business Central (14) Indian Version to Current Business Central Indian Version.
      4> While open NAV 2016(IN) db in Business Central 14(IN) version through Development Environment system prompt for data conversation. At the time of converting database with validation with synchronization its taking more then unusual time. Currently it has taken 1.5 days. Can you advise on this?
      5>I got this error while use below options(for migration) in Microsoft Dynamics 365 Business Central (IN) Version 14.0.47832
      Tools>Sync. Schema For All Tables>Check Only
      drive.google.com/file/d/1-O1nZw2n4E6KtCAfuOz0KSdR6jzVVn3t/view?usp=sharing

  • @sandeepsinglacayash
    @sandeepsinglacayash 3 роки тому +1

    Can you provide download link for BC 14 extension.

    • @rishabhshukla2240
      @rishabhshukla2240  3 роки тому

      It’s with bc14 India DVD.

    • @rishabhshukla2240
      @rishabhshukla2240  3 роки тому +1

      Sorry ...Instead of reply I removed some messages :) use this link for DVD : download.microsoft.com/download/c/6/4/c64076e6-7a9e-4a7b-b2e4-1b35fcbe3eae/Dynamics.14x.IN.3478340.DVD.zip

    • @rajprince3758
      @rajprince3758 3 роки тому +1

      @@rishabhshukla2240 Is this the latest DVD from BC 14 Indian localization? If I want to migrate Cu62 NAV 2016 to BC 14, Can i use this?

    • @rishabhshukla2240
      @rishabhshukla2240  3 роки тому +1

      @@rajprince3758 yes it is

  • @priyagupta2790
    @priyagupta2790 3 роки тому +1

    Hi Rishabh sir,
    While upgrading the NAV2016 to BC14 (i'm following your video), But stuck on while publishing the IndiaUpgradeTables.Source after field migration in UPG table. Facing the below error(Can you suggest am i missing some steps):
    Compilation started for project 'India Upgrade Tables' containing '185' files at '12:36:28.411'.
    error AL1033: An error occurred while loading the included rule set file d:\Priya\India BC Upgrade\Dynamics.14x.IN.3478340.

    • @rishabhshukla2240
      @rishabhshukla2240  3 роки тому +1

      Hi @Priya , check your settings.json there must be a setting for ruleset file. you either remove that line on settings.json or copy the ruleset file on that location.

    • @priyagupta2790
      @priyagupta2790 3 роки тому

      @@rishabhshukla2240 Yes resolved. Thank you sir

    • @arunkumarp8219
      @arunkumarp8219 2 роки тому

      Hi Priya, I am doing NAV 2016 - BC 14 Migration. How you did Standard Tables Extensions.

  • @arunkumarp8219
    @arunkumarp8219 2 роки тому

    Hi @Rishabh Shukla
    In 35:50 minute. I am trying to sync the data but i am getting below error
    Sync-NAVTenant : Changes to the tenant database could not be applied. Affected tables will not be available.
    The first error was:
    The specified upgrade table with the ID 19000 does not exist.
    Before you choose Copy or Move, you must have created a table that can be used during the upgrade. You must also have
    compiled the table object.
    Retry the operation when the problem has been resolved.
    At line:1 char:1
    + Sync-NAVTenant BC14FRMNAV16
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (0:Int32) [Sync-NAVTenant], NavCommandException
    + FullyQualifiedErrorId : MicrosoftDynamicsNavServer$BC14FRMNAV16,Microsoft.Dynamics.Nav.Management.Cmdlets.SyncNa
    vTenant
    How to resolve this......????

    • @kesavanm4490
      @kesavanm4490 2 місяці тому

      Did you resolve this issue?
      I'm also facing the same issue

  • @SanjayThakur-st3rt
    @SanjayThakur-st3rt 2 роки тому

    Hi Rishabh,
    As we get Data Upgrade Start" below error is coming, please advice...
    ---------------------------
    Microsoft Dynamics NAV Development Environment
    ---------------------------
    The database has version 1051 which is not supported by this version of Microsoft Dynamics 365 Business Central Server. Please contact your administrator.
    ---------------------------
    OK
    ---------------------------
    Regards,
    Sanjay

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      Hi Sanjay, you need to run Sync-NavTenant cmdlet

    • @ManishSharma-jd6ww
      @ManishSharma-jd6ww 2 роки тому

      @@rishabhshukla2240
      SessionId : 158 CodeunitId : 104000 FunctionName : CreateExcelTemplateWebServices CompanyName : StartTime : 23-08-2022 19:16:39
      Duration : State : FailedPendingResume Error : Function 'CreateExcelTemplateWebServices' in the upgrade codeunit '104000' has failed because of the following error: 'The server stopped the session (ID: 158) because of a stop session request.'. ExecutionSourceId : 00000000-0000-0000-0000-000000000000 PostUpgrade : False
      Getting this when Data Upgrade

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      can you check the event log and see the exact error message ?

  • @santanupal5507
    @santanupal5507 2 роки тому

    I saw your video on how to migrate NAV 2016 India (IN) to Business Central Indian Version. A few queries arise to ask you.
    1> I used "Dynamics.365.BC.47804.W1", the world version of all objects backup for migration. Is this version OK?
    Because there is no Business Central world version, details are specified in this video.
    2> For example, I made customization in Customer Table (id: 21) without any custom field, whether the system would be migrated the code automatically or not.
    3> It will be helpful to us if you create a video about how to migrate Business Central (14) Indian Version to Current Business Central Indian Version.
    4> While open NAV 2016(IN) db in Business Central 14(IN) version through Development Environment system prompt for data conversation. At the time of converting database with validation with synchronization its taking more then unusual time. Currently it has taken 1.5 days. Can you advise on this?
    5>I got this error while use below options(for migration) in Microsoft Dynamics 365 Business Central (IN) Version 14.0.47832
    Tools>Sync. Schema For All Tables>Check Only
    drive.google.com/file/d/1-O1nZw2n4E6KtCAfuOz0KSdR6jzVVn3t/view?usp=sharing

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      @Santanu,
      my response :
      1. No, you should use BC14 IN version, yes they are same but BC14 IN has difference UPG fob and apps.
      2. NAV 2016 IN and BC are two different products, hence there is refactoring and redesigning as well so you have to move your code by yourself.
      3. its a 2 part video :) see the second part for this.
      4. you should do a cleanup before starting upgrade for unwanted tables. (like change log and all)
      5. you have missed the step of publishing app for india upg tables.

    • @santanupal5507
      @santanupal5507 2 роки тому

      @@rishabhshukla2240 Thanks a lot Sir.

  • @santanupal5507
    @santanupal5507 2 роки тому

    Sir, can u provide me the download link of BC14AllObjectW1 version.

    • @rishabhshukla2240
      @rishabhshukla2240  2 роки тому

      download.microsoft.com/download/c/6/4/c64076e6-7a9e-4a7b-b2e4-1b35fcbe3eae/Dynamics.14x.IN.3478340.DVD.zip

    • @ketanpjain
      @ketanpjain Рік тому

      Santanu, were you able to get this? I am still figuring this step out.