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 / 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 12

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 12 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,243 Super User 2025 Season 2 on at

    Update "Check for data modified after" and restart.

  • Michael G Ferreira Profile Picture
    Michael G Ferreira 12 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,243 Super User 2025 Season 2 on at

    Yes stop the connector and restart it

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

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

  • Michael G Ferreira Profile Picture
    Michael G Ferreira 12 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 12 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

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 > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans