chase 9/23/2019 4:29:20 PM

Duplicate master numbers on nonrelated sales orders

It has been a few months since we have seen sales order that duplicate already existing master numbers. But in the recent month, we have been getting bombarded with duplicate master numbers. I have a job running, that notifies me the moment a duplicate has been created, but there is no clear fix for this. Has anyone found a way to nip this error? If you have any sql advice, that would be great as well.
Version: GP 2015
Section: Dexterity, Dynamics GP, SQL Scripts


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3