Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

Help needed WorkOrder error/issue

Posted on by Microsoft Employee

Small single store RMS setup.

We had a weird error occur while one of the cashier did a work-order and accepted a deposit. Two things happened:

1) the cashier never added an item
2) the cashier did override the deposit to accept $20 dollars

I can't see this work-order on any reports and I can't see the transactions under the customers history.

What should I do to fix this problem/Issue? I can use SQL - just not sure which tables need to be corrected?

Dan

See attached receipt.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Help needed WorkOrder error/issue

    I had the cashier who did the transaction show me how he did it and I see what's going on now.  If you put a deposit on a workorder that has no items on it, when you tender the transaction it asks how much of the deposit you want to keep. If you don't understand what that means and just click ok or hit enter, the tender goes through and the money goes into the infamous kept-deposit black hole. I'm guessing MS will just say it's working as designed. (designed very poorly IMHO)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Help needed WorkOrder error/issue

    Strangely we had this same issue happen today. It looks like it's a bug that's been around quite awhile. (see the link below) I'm going to report it to MS and will post what they say in this thread.

    groups.google.com/.../zp3A0NHkFy4J

  • Spencer McCandless Profile Picture
    Spencer McCandless 2,085 on at
    RE: Help needed WorkOrder error/issue

    It looks like you have an entry in the Order table without any corresponding entries in the OrderEntry table matching its  ID value. I'm not sure how this happened, as we don't really use the work order functionality.

    Essentially, most every table in the database has an ID column that is used to link it to other tables. So, Order would contain an entry representing the entire work order, and OrderEntry would have an entry for each item in the work order consisting of an OrderID, quantity, an ItemID (referencing the Item table), and some other information.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans