I've bumped into a problem with a staff member having to work over nights into the morning (11pm-7am).
Because of all the things the server does with the database I was hoping there is a way to start all the End Of Day Sequences at a later time in the morning.
Is this possible or is there...
Oh never mind.
I had to force the chk to close and then deleted it.
I used the command:
call micros.sp_forcechkclose (insert check seq here)
This seems to have fixed my issue. The amount is no longer there.
Thanks so much Steve, you're a life saver.
I'm able to pull up the chk now with the command
select * from micros.chk_dtl
where chk_open = 'T'
But its not letting me close the chk (Says access denied from doing that).
Is there a way to wipe it completely from the database?
Can someone tell me the query to run to lookup an amount and then delete the record.
I have a dollar amount sitting in outstanding day after day but has no chk number assigned to it. It doesn't even have an emplayee assigned to it. I have no idea how it got there, but really need to remove it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.