Hi there,
Is it a significant issue to add a Pending Order table that allows the Order Entry clerk to continue entering the data, but if it goes over limit, the entry is temporarily saved in this separate table.
When an authorised user enters the system, he is warned of "Over Limit" orders requiring authorisation, reviews and posts back to the main database.
I suppose you have then got to take into consideration that a) manager requires further information; and b) action on orders rejected.
In the User or Group Setup section, one could not only define who can post, but also include email addresses to auto-shoot reminders?
In a paper type environment, the Order Entry clerk can print out Orders requiring special approval, send to manager for signature and he can both manually authorise on paper, and go onto the computer and select those orders he approves.
Wishful thinking perhaps... :-)
Regards.