This was the bane of my existence when working in a larger corporate environment for 3 years. We used some SAP product that was written in 1995 using all of the best enterprise methodologies. It was slow, dumb, had obtuse validation rules and required all types of duplicate entry. I hope to never implement such a thing in my own company.