web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Clearing old deposits ...
Microsoft Dynamics RMS (Archived)

Clearing old deposits from the system

(0) ShareShare
ReportReport
Posted on by Community Member

Occasionally someone will invoice a work order without properly redeeming the deposit. this creates closed work orders with the deposit liability still sitting on this report. As a double check we balance our general ledger for deposits against our deposit report, which is getting further out of balance on a monthly basis. there appears to be no way to go into RMS and pull up a closed work order to reverse this mistake. Is there a method of removing this phantom deposit on a closed work order?

 

Second deposit question=- is there a method for effectively searching deposits in store operations? They seem to report on the X/Z but are not searchable in the tender summary  when there is an issue with a deposit its like trying to find a needle in a haystack

 

 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Clearing old deposits from the system

    I am interested in how you manage to not apply the deposit when tendering out the work order.  Every time I recall and pickup a work order with a deposit RMS automatically subtracts the deposit from the total due.

    If you can send me the process you are using maybe we can get this resolved.  

    You can also see the deposit amount on work orders by running a Work Order (Summary) report from SO Manager.  This does not tell you if they were redeemed or not because you should be able to close a work order without redeeming the deposit.

    Thanks

  • Community Member Profile Picture
    Community Member on at
    RE: Clearing old deposits from the system

    Ed,  what i believe has happened is an employee recalls a work order and begins to make changes.  If you delete all of the line items in the work order you can close it without redeeming the deposit. You then can't open the work order again because it is listed as closed and you can't apply the deposit. We've had to create work around that are messing up our accounting department as we now have several closed work orders in the system with deposits still hanging on them. I've communicated to my team but this has happened up to 10 times now in the system. Any way to rectify this?

    Pat

  • Community Member Profile Picture
    Community Member on at
    RE: Clearing old deposits from the system

    Is it mandatory for you to collect deposit when the cashier creates work order? 

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Clearing old deposits from the system

    There is no easy way to solve this problem.  The system does prompt for the amount of deposit to keep,  If the employee changes the figure then the register performs a refund.

    If not, then the store keeps the deposit, which shows up on the report you are running.

    If you don't want the deposit to show, then you have to manually edit the [Order] table and set the deposit field to 0.00

    This can be accomplished with SQL Server Management studio.  

    ALWAYS MAKE A BACKUP FIRST.  

    If you are sure that the employees are deleting all the items and then saving the work order without doing a refund, you could run the following query.  It should clear up your issue.

    UPDATE [Order] Set Deposit =0.00 where Total = 0.00

    To run this, open Administrator program.  Connect to your database, open a new Query window.  copy that command in and click green arrow (or F5)

    ALWAYS MAKE A BACKUP FIRST.

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans