News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Record Locking Interfe...

Microsoft Dynamics NAV (Archived)

Record Locking Interfering with Integration with CRM

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hi,

I've heard that when using Kingsway Soft to sync NAV invoice records to an external system, such as Dynamics CRM, that syncing cannot occur while NAV users are using the system and the sync process must wait until after hours. The reason, I've been told, is because of record locking within NAV, caused by users, prevents Kingsway Soft from copying records (and possibly flagging these as copied).

Does NAV record locking usually prevent syncing during the day? Are work arounds available?

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Hannes Holst 5,767 on at

Like (0)

Report

RE: Record Locking Interfering with Integration with CRM

Hello,

This is a question you should ask Kingsway and how they handle it.

NAV does lock records in the SQL-table during write-transactions to guarantee an uncorrupted database.

Normally, NAV will wait until the table is released again and continues with the queued transactions.

This is a built-in behaviour (it's not a bug). Each software vendor (and/or developer) must consider this when creating customized solutions in NAV.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans