Syspro Scripting

I have a customer that I track the production of every Stock Code that is processed through the Production Floor.  This is done outside of Syspro via a custom program.  The issue they have run into is that Syspro users were sometimes changing a Sales Order Detail line that is already in production.  The user was not aware that certain Stock Codes were already in production.  Sometimes the user might actually be changing the Stock Code or the Order Quantity.  I developed a vb script that queries the Production Floor database to see if the Stock Code is already in production and notifies the user accordingly. (The user gets a list of what work centers the product has been through along with the date and time.)  The link between Syspro and the Production database is using the Sales Order and Line Number, thus thwarting the Stock Code change scenario.