We have an employee who clicked Ok without changing the Deposit amount to keep to zero and now we are stuck with a deposit from a layaway that was cancelled. How can we remove this deposit so it balances out in RMS??
Thanks
*This post is locked for comments
Hi,
To reopen a Work Order simply use this update statement in SQL Management Studio, this is once you connect to the database of course.
update top (1)
set a.closed = '0'
from dbo.[order] AS A
where a.id = ' work order number here'
After you set the closed status to '0', you will be allowed to open the Work Order. Change the kept deposit to zero and tender out to complete.
Scott has a good idea, but this will not remove the deposit amount from the Layaway report if ran for closed Layaways.
If you need that removed, then you have to edit the [order] table and set the deposit column to 0.00
Hello Dan,
Thank you for your question.
You should be able to issue a return of the layaway.
If not, you can simply process a return to a non-inventory item for the amount of the deposit that was entered on the layaway.
Thank you,
Scott Wardzinski
Microsoft Dynamics RMS & POS Support Engineer
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (