webERP Forum

Full Version: Abandoned Work Orders
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I noticed if you go to "New Work Order", up on entry into the screen a workorder record is created and the next number is used up from the counter. If you don't use the order or click "Cancel" and leave the screen another way (close browser window, change menus) the workorder record becomes abandoned in the DB with no way to Cancel later.
Anybody else experience this or have an issue with it? Most other WebERP screens don't create a database record upon entry.
I am wondering if a cleanup script should be added to the login and what criteria we should add to ensure we don't delete a work order somebody is in the process of creating?
Something like Required date in the past (x days) and no woitems table connected means abandoned?

I'm getting 10-15 abandoned orders per month
Yes - I made a mistake with this script so the work order number is incremented before it is committed. Needs a bit of TLC to fix - never got around to it. Better to fix at source me thinks than develop a clean up script.
Reference URL's