Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

BKCHK STATUS = 4 - what does that mean? Reconciliation Help needed

Status
Not open for further replies.

Kwekoolio

Technical User
Jun 25, 2009
16
GH
I'm having trouble finding checks in Bank services and noticed that most of the missing ones have BKCHK.STATUS = 4. I found this list of status codes online:


2 = Void
3 = Outstanding
9 = Printed
10 = Posting error

The number four doesn't show up here but it does show up in this list for RECSUGGEST:

1 = Alignment
2 = Void
3 = Outstanding
4 = Reversed
5 = Cleared
6 = Cleared with bank error
7 = Non-negotiable
8 = Continuation
9 = Printed
10 = Posting error
11 = Cleared with write-off

What does the status "4" mean in this situation? If it means reversed, as suggested by the second list, I have a bit of an issue because I can't find any reversal batches that would have created that situation. Also, my review of the GL account shows that the checks did post correctly to the bank's GL account.

What can I do to make those checks appear in Bank Services so that I can clear them and reconcile the statement? None of my October checks appear in Bank Services (all of the withdrawals, however, are listed). Some of the missing checks have status = 3 which calls my original theory that the status code is what created the issue into question but I'm still a bit lost as to how to bring these checks back to the reconciliation module.

Please help! Thanks in advance!
 
Thanks. So what can I do to make those checks appear in Bank Services so that I can clear them and reconcile the statement?
The checks are not reversed in the GL or anywhere else that I know of so I'm not sure how to reverse the reversal...
 
Nothing, reversed is reversed...
They will disappear once you post the bank reconciliation.
 
I don't think that I'm being clear - the checks don't appear at all in Bank Services. They are also not reversed in the General Ledger (the original entries appear in the GL as checks and none of them have been reversed; they also appear in AP in successfully posted batches).

The only place these checks appear as reversed is in this one table - it just doesn't make sense to me that they are not in the withdrawals section of the reconciliation module. They must have either never made it there in the first place or improperly cleared in a prior reconciliation. How can one reverse all checks in a month, encompassing several batches, without leaving any evidence of a reversal batch anywhere?

Thanks for your help.
 
If they are in BKCHK then they will appear in the bank rec, because that is where the bank rec pulls checks from for the withdrawals. Either the checks are in a different bank or they are in a later period than the one you are working in with the bank rec.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top