Skip to Main Content
Sage 200 UKI Ideas Portal
Status Idea Accepted - Gauging Support
Categories Database
Created by Tim Critchley
Created on May 7, 2024

Prevent duplication of URNs

On very rare occasions you may see duplicate URNs posted to the Sales Ledger due to environmental issues (deadlocks etc), this could possibly be prevented by setting a constraint on the SLPostedCustomerTran URN field field in the database to prevent duplicates. The same could apply to suppliers.