SOP Master Numbers not being assigned properly

A unique document number could not be found. please check setup. I been with a situation where my customer were getting the above messages, noticed that the system is updating the master number in SOP40100 to a smaller number which sometimes being exist in SOP10100 or SOP30200

Go here to see the original:
SOP Master Numbers not being assigned properly