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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Locking users not to be able to change SalesReps when proocessing in Order entry
- Thread starter hushman
- Start date
Two ways:
You can create a customized version of the OE screen with a macro (or VB6) where you can implement that control.
Another way is to use Orchid's Extender product to build that business logic control.
If the salespeople codes are defaulted from what is in AR and shouldn't be changed, or, once the original sales order is created you don't want the SP codes to be changed, you could also look at a SQL trigger to send an email if someone changes them. That doesn't prevent the user from changing but you can send out an email to say: "Hey <username>, do not change the salesperson codes on orders like you did on order <order number>." That will stop them soon.
You can create a customized version of the OE screen with a macro (or VB6) where you can implement that control.
Another way is to use Orchid's Extender product to build that business logic control.
If the salespeople codes are defaulted from what is in AR and shouldn't be changed, or, once the original sales order is created you don't want the SP codes to be changed, you could also look at a SQL trigger to send an email if someone changes them. That doesn't prevent the user from changing but you can send out an email to say: "Hey <username>, do not change the salesperson codes on orders like you did on order <order number>." That will stop them soon.
- Status
Similar threads
- Locked
- Question
- Locked
- Question