RES 3700 - Error : Check Detail Read Failed

 .

The error "Check Detail Read Failed" while trying to open a check/table on the micros RES 3700 point of sale system. This error is present is all versions of RES but occurs much less frequently since RES 4.0


This error is an indication that the check has become unreadable in the database. It can occur if the check is being accessed during a power failure or some other interruption to the operation of the micros system.


These checks are unrecoverable and can only be closed in the database.

To proceed you will need to know the check number which is currently causing the error.


Step 1) On the Micros POS server open DBISQL. To do this press Start -> Run -> Type "dbisql" without the quotes.


Step 2) Enter the username and password:

Username: custom

Password: custom

or

Username: installer

Password: installer



Step 3) Type the following command and replace XXXX with your check number and execute:

Select chk_seq, chk_num, chk_open from micros.chk_dtl where chk_num = XXXX;


chk_seq = Check Sequence number is a unique number

chk_num = Four digit check number used to identify a transaction.

chk_open = True or False. True means the check is open, False means its closed.


Step 4)  Make a note of the number in the chk_seq column and type in the following command and replace XXXXXX with the chk_seq number and execute:

call micros.sp_forcechkclose(XXXXXX);


The check should now be closed.

.

24 comments:

  1. That's exactly what I needed. In my case, the terminal lost connection to the server when the waiter was keying in a check. He then openned the same table on another terminal. When the original terminal reconnected it created a conflict. this fixed the issue. Thanks!!

    ReplyDelete
  2. This all sounds very simple, but neither of the suggested passwords will work for me, so I am stuck!

    ReplyDelete
  3. Worked like a charm. Thank you Dealer for not changing default PW!!

    ReplyDelete
  4. Si que funciona.... excelente aporte

    ReplyDelete
  5. Can this be fixed when you don't have the check number?

    ReplyDelete
  6. Kassa
    Kassaregisterkassa register

    Vi erbjuder Kvalité och snabb service och vet att det är mycket viktigt att få saker gjort snabbt , därför kan vi erbjuda service avtal Från 99:-/mån så du får snabbt på plats service (även distans avtal)och så ser vi till att du alltid håller ditt kassasystem uppdaterad med den nyaste programvaran!

    Kontakt información:

    Norra Ågatan 5 A Arboga Västmanland 732 31
    teléfono: 0589-10031
    Site: www.kassanetto.se

    ReplyDelete
  7. I have a question: i force to close the Check call micros.sp_forcechkclose(XXXXXX); using that . Works!

    Next
    when i close the SQL , everting come back again .

    save it ? how..! ?

    ReplyDelete
    Replies
    1. Type the following command and execute: commit;

      Delete
  8. I have a bit of a problem. Do I have followed all steps and I was able to force close the check, but I still have an outstanding balance that is going to throw me off when I do my audit reports. When I tried to edit the closed check it says that the call failed, so I am unable to properly handle the outstanding balance. Is there a way that I can open the check that I forced to close or is the outstanding balance just stuck out there in the micros system?

    Thank you

    ReplyDelete
  9. IS THERE A NEW USER NAME & PASSWORD ?

    ReplyDelete
  10. IS THERE A NEW USER NAME & PASSWORD ?

    ReplyDelete
  11. I download this software
    http://www.pos-or.com/
    on my POS micros RES 3700 and it's not work, I charge it, but nothing happens, what can you tell me about this problem?

    ReplyDelete
  12. Wonderful post, till system thankful to all your team for sharing such best information about EPOS systems.

    ReplyDelete
  13. This is an interesting blog that you have posted, epos system you shares a lot of things about epos system.

    ReplyDelete
  14. Thanks for this post epos for hospitality and i really helpful information keep sharing updates

    ReplyDelete
  15. Great blog created by you. I read your blog, epos system its best and useful information. You have done a good work.

    ReplyDelete
  16. very nice post.and thank you for providing this information
    Read More:http://www.e-novations.co.uk/

    ReplyDelete
  17. Can anyone help me a possible username and password

    ReplyDelete
  18. I tried the entire process but still the new bills could not be viewed

    ReplyDelete
  19. This worked! thank you so much.

    ReplyDelete
  20. Good morning, I have outstanding checks but when you look at all servers check outs it adds up? Also no tables are open on table lay out? Can’t figure it out??

    ReplyDelete

-->

Disclaimer

All information on this web site is correct to the best of my knowledge at the time of writing.
I will not be held responsible for any damage caused through information on this website.