Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

O/ E Item Description Over-Write

Status
Not open for further replies.

ravazz

MIS
Dec 8, 2009
112
JM
Is there any way to prevent users from over-writing the product descriptions in O/E Order Entry or Copy Order
 
You could look at hiding those columns but that's not fool proof. You'd have to go with customization.
 
SQL trigger maybe? Replace description after record insert, something like that.
I've done some stuff with SQL triggers that would not otherwise be possible without heavy customization.
Agreed not ideal but sometimes ya gotta do what ya gotta do.

Sage 300 Certified Consultant
 
In the case of people changing the descriptions of the items on your order I would suggest that only certain people can have access to creating orders.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top