NAV uses optimistic Concurrency for all the transaction except for posting. During posting, NAV locks the ledgers and sub ledgers, basically any table that has primary key of “Entry No.”. In Order for posting to work NAV has kept the posting process to as fast as possible. Most partners forget this import part during implementation and modification of the system. Most of the big projects where the user count is greater than 50 and high transaction volume by the user, NAV system starts to show the weakness of its design.
Posted inDynamics NAV & BC Tips & tricks