65
hello all..
i'm facing a problem in my checkbook , there's a difference between
Sub-ledger and general ledger in banks module after we analysis
the difference we found that, there was a sales cash receipt already entered and posted
but I can’t find it on bank deposit window ( it's lost )
although it’s posted to General Ledger
so I need the reason behind this problem and how to solve ?
thanks
*This post is locked for comments
Hi Tristan,
How could they delete it in bank rec? I can see where I could void it, or do a clear unused receipts transaction, but I don't know how they might have deleted it. Have you found a way to do that?
Kind regards,
Leslie
Mahmoud,
Awesome piece of work, thank you for the gift!
Just to make sure the transaction isn't living somewhere else, I would additionally search the entire database for the string which is the payment number before I increased the checkbook register balance. If you find that increasing the register balance is the way to go, then I would use a Deposit without Receipts transaction to increase the balance without touching the general ledger.
Kind regards,
Leslie
Since you don't have a reconcile to GL utility for the checkbook module, you may use this script which will provide matched, unmatched and potentially matched transactions for the Checkbook versus GL
Check this out at Reconcile Check books to General Ledger – SQL Script
Your feedback is highly appreciated,
Its possible that it was deleted in BankRec.
2 Options you can do:
A. Just make a deposit to correct the bank balance. Shortest and easiest approach.
B. Void the Cash Receipt this should correct GL as well. Once done, re-enter the transaction as it should be. Note that if the Cash Receipt is already in History, you will need to use RM Transaction Unapply (PSTL) to bring it back to open status so you can Void it.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
