Outstanding amount total has no chk number - micros 3700

[Dexmex]

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.

Thanks.

 

[DrZogg]

Hi,
you need to set its open value to 'F' (c;osed).

Step 1 in DBISQL:

select * from micros.chk_dtl
where chk_open = 'T'

Take a note of the check sequence and check number.

Step 2 in DBISQL
update micros.chk_dtl
set chk_open ='F'
where chk_seq = 1199439 and
chk_num = 3158


Cheers

 

[DrZogg]

Hi,

just reread your problem. When all the checks are closed (at EOD) you can set all open checks to closed in DBISQL with the code

update micros.chk_dtl
set chk_open ='F'

Steve

 

[Dexmex]

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?

 

[Dexmex]

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.