I've added an Extender window to the Customer/Item Maintenance screen, which holds an item specific price which is different from the price on the customer's price level. I've got a stored procedure that allows me to pass the customer and item number, and returns the unit price.
Is there a way to use Extender Logic to run this stored procedure, passing the customer ID and item number from the current line, get the unit price back, and update the unit price field? I'm planning on doing this upon entry into the unit price field, to ensure that all business logic is performed when the user tabs off the field.
All our CSRs currently tab through all the fields when entering, and I'll just make this part of the procedure.
Thanks,
Steve
*This post is locked for comments