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) / Error 91 on RMS Dynami...
Microsoft Dynamics RMS (Archived)

Error 91 on RMS Dynamics POS

(0) ShareShare
ReportReport
Posted on by TheNeos 1,347

Hello,

I have a condition running RMS Microsoft Dynamics that crashes POS and gives error 91 object not found ( or something similar).

This happened when we placed an order on hold for an account. Later we discovered that this customer had already an account with different number. So,,,, we deleted the account that this on hold order is done in mind that when we recall the on hold order we would change the customer to the one we wanted to use. But when recalling this order from on hold error 91 takes over and POS exits.  Restarting is no problem anything else seems to be working right what I want to do is remove that offending order from on hold if it is possible.

Anyone any suggestion?

Thanks TheNeos 

*This post is locked for comments

I have the same question (0)
  • eliud mugo Profile Picture
    eliud mugo 1,444 on at
    RE: Error 91 on RMS Dynamics POS

    Its not advisable to delete customers since they might be carrying very important history of your transactions

    but since the mess has already been done just do the following.

    query from you database using sql and note the (customer id) of the deleted customer.

    you may use the following queries to determine that

    select * from [order]

    then run the following query

    delete from [order] where customerid='x'  (replace x with the id of deleted customer)

    all the remaining orders on hold should work fine

  • TheNeos Profile Picture
    TheNeos 1,347 on at
    RE: Error 91 on RMS Dynamics POS

    Hello Eliud Mugo,

    Thanks for responding.

    It seem that I need more precise spelling of table and column names. I was able to find from "transaction", "Daily Sales", and "typeID" of transaction (using 5 as typeID for sales on hold that completed). But not the offending one which is still in Sale On Hold list. I could not use the "order" or "sale" to select, SQL responded that table name is not correct.

    Any other suggestion please?

    Thanks TheNeo

  • eliud mugo Profile Picture
    eliud mugo 1,444 on at
    RE: Error 91 on RMS Dynamics POS

    Hello TheNeo,

    Did you omit this symbol? [ ]  while executing the query? if so you might have seen this error

    Msg 156, Level 15, State 1, Line 1

    Incorrect syntax near the keyword 'order'.

  • eliud mugo Profile Picture
    eliud mugo 1,444 on at
    RE: Error 91 on RMS Dynamics POS

    If so Try Rerunning the query with the symbols.I used to have that kind of problem but solved it that way

  • Verified answer
    TheNeos Profile Picture
    TheNeos 1,347 on at
    RE: Error 91 on RMS Dynamics POS

    Hello,

    I have been able to clean up the mess with these steps:

    1 - In POS opened Recall Transaction On Hold where the offending entry was and recorded the Transaction ID number.

    2 - In RMS Administrator I used the following queries,

         select * from TransactionHold (this showed the contents(items) in this entry),

         delete from TransactionHold where TransactionHoId='xxx', (xxx is the number of the offending entry, this cleared the contents of the entry),

    3 - In POS opened Recall Transaction On Hold and select the offending entry (it has not gone yet), and enter as I would done normally. This action resulted to a New error message saying that "customer not found in database" but no crush of POS. Pressed the OK button and the offending entry gone.

    Cheers everyone

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September 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