• Oracle Micros Point of Sale
  • Tools
    • QR Code Printing
    • ISLCrypt & ISLDecrypt
  • Blog
  • Contact
Micros POS Tools

3700 - Error: Check Detail Read Failed

6/28/2012

9 Comments

 
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.
9 Comments
Kristin Knox
5/18/2016 11:53:24 pm

I followed all steps and I was able to 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 clos or is the outstanding balance just stick out there in the micros system?

Thank you

Reply
business objects training in chennai link
8/16/2016 03:57:26 am

Buoyancy Technologies is a Premier IT Training & Consultation Institute in Chennai that provides High quality, Job Oriented Training programs for Oracle, Cloud Computing, Java, Web, DBA, Software Testing and Microsoft technologies.

Reply
job oriented training centers in chennai link
8/31/2016 03:28:59 am

Buoyancy Technologies is a premier IT training and consultation institute in Chennai

Reply
Oracle SQL Training in Chennai link
1/30/2017 02:53:16 am

Expert Oracle SQL and PLSQL Training in Chennai topics taught by experienced Oracle Certified Professionals (OCP) with extensive real-world experience.

Reply
ANDROID TRAINNING IN CHENNAI link
1/30/2017 03:05:11 am

Android applications are written in Java, so at least moderate previous Java experience is needed. You need not be a Java expert

Reply
Chennai City Bus Advertisement link
4/5/2017 10:57:21 pm

We are one of the authorized person for bus branding in Chennai metropolitan.Across Tamilnadu we can do bus advertising like city’s Coimbatore,Madurai,Trichy,Tirunelveli,Pondycherry

Reply
web designing company in chennai link
6/14/2017 05:12:46 am

PartnerITechnologies is a worldwide pioneer in counselling, innovation, and outsourcing .Built up in 2013 IT administrations organization with more than 50 Workers.Making your organization exceed expectations with an incomprehensible low consumption.

Reply
Web Application Development in chennai link
7/7/2017 04:09:50 am

PartnerITech is a worldwide pioneer in counselling, innovation, and outsourcing .Built up in 2013 IT administrations organization with more than 50 Workers

Reply
Ajay link
1/5/2018 11:05:30 pm

we offers java training in chennai

Reply



Leave a Reply.

    Author

    Developer and Blogger about Micros POS Products.

    Archives

    August 2020
    June 2012

    Categories

    All
    3700
    9700
    E7
    Simphony

    RSS Feed

Powered by Create your own unique website with customizable templates.