web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Historical data synchr...
Microsoft Dynamics NAV (Archived)

Historical data synchronization after first time using early dates

(0) ShareShare
ReportReport
Posted on by Michael G Ferreira 14

Hello Everyone,

We setup a custom mapping between NAV (Sales Quotes) and CRM (Opportunities and begin the data synchronization.

Everything is working fine.   However, we'd now like to bring in historical sales quotes that were modified before the original data.

That is ...

When we started we wanted last modified as of Jan 1, 2015.    Now we'd like to add the Jan 1, 2014 to Dec 31, 2014 (i.e bring in more history).

We have tried editing the last modified date to align with the early start date.   Thinking the job would then create the missing records.    No luck.

Looking for suggestions on how to load the missing historical data?

thank you in advance for your advise.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,698 on at

    What kind of issues you are facing while changing dates ? Where you are changing dates?

  • Michael G Ferreira Profile Picture
    Michael G Ferreira 14 on at

    As before, opened connector software, edited the data sync maps so it would trigger based on "last modified" date on or after Jan 1, 2014 (this is where I edited dates), click save and activate.  

    Connector job ran finding a number of changes to sync to CRM from NAV yet none of the records between Jan 1, 2014 and December 31, 2014 were synced into CRM.  

    In short, trying to find out how to re-run the job to included older/historical data from before our original load.

  • Suresh Kulla Profile Picture
    Suresh Kulla 50,278 Super User 2026 Season 1 on at

    Update "Check for data modified after" and restart.

  • Michael G Ferreira Profile Picture
    Michael G Ferreira 14 on at

    That's what I did ... set inactive, changed date, set active ...

    or you mean restart service as well?

  • Suresh Kulla Profile Picture
    Suresh Kulla 50,278 Super User 2026 Season 1 on at

    Yes stop the connector and restart it

  • Michael G Ferreira Profile Picture
    Michael G Ferreira 14 on at

    Same result ... finds changes yet nothing new is created.  

  • Michael G Ferreira Profile Picture
    Michael G Ferreira 14 on at

    Stopping and starting the service (as well as retroactively setting the last modified date) did not work.

    We have also tried editing one of our historical records so the last modified date is current (i.e. now).    That record did NOT come across even though it is now within the go-forward range.

    Suggestions?

  • Michael G Ferreira Profile Picture
    Michael G Ferreira 14 on at

    Thinking we removed/deleted the mapping, recreate and retry... Curious if that removes/resets integration keys (bring over duplicate records in CRM one time is fine).    Thank you in advance for assistance.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
TAHER_El_Mehdi Profile Picture

TAHER_El_Mehdi 2

#1
sliderxb Profile Picture

sliderxb 2

#1
broberts Profile Picture

broberts 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans