You’re offline. This is a read only version of the page.
We accidentally opened a work order for pick-up on two registers (started pick-up on one, but opened then finished on another). While the work order was completed as "pick up entire order" on that second register, it's now still showing as an active work order when called up by any register. Bad.
Obviously, RMS should have been programmed with this circumstance in mind. (Bug!)
Is there anyway to fix this through RMS? Or would it require directly accessing the SQL database and closing out the work order there manually somehow?
Thanks!
*This post is locked for comments
I've seen this problem a couple times and fixed it the same way you did. MS should definitely make it so Workorders can't be opened on multiple registers at the same time or maybe give an error if it has been closed or saved elsewhere since being opened.
That looks good and should work should someone need it. Thanks!
Turns out I didn't need it. RMS for some reason doubled the items on the Work Order, so it showed one Received To Date (RTD) and one On Order for no good reason. To fix it, I recalled the work order, set the on order amounts to 0 and completed the transaction which showed no deposit and no balance. (I should have noticed earlier that the order total was double what it was supposed to be.)
Thank you!
The best way is through the sql tables. That way it doesn't double up the payment or void the work order.
update [Order] set closed =1, deposit = 0 where ID = {Work Order Number}
replace {Work Order Number} with the number of the work order you need to close. You can find this in Journal View if you are recording receipts and don't have the number.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (