Hi Renee,
There is never an issue with an O type entry date not matching the period to post of the CA Batch.
If there is an OOB GL per the Cash Manager >Bank Rec screen, verify that the GL balance that displays in the Bank Rec screen matches the GL balance in GL>Account History. The GL balance displaying in the Bank Rec screen comes from the Curyacct Table. Sometimes it is not stored correctly.
If the amts are not the same AND you have a single currency database, then do this.
1. Go into Initialization mode
2. Go to GL>Account History screen
3. Bring up your Cash Acct/sub/ledger/year.
4. Change the Beginning Balance at the bottom left by a penny. Save. Change it Back. Save again.
This updates the curyacct table to match accthist in a single currency database.
An O type entry can ALWAYS be made to make the Cash Manager >Bank Rec be in balance. But the problem with doing this without knowing a particular entry that is wrong (wrong date usually) is that you get in the mode of having to make such an entry each month without knowing why. So you lose track of single issues and they all get lumped into one unknown transaction.
One would expect to need to make an O type entry the first month if you are starting to use Cash Manager after the acct has been active for some time. You would need O entries to represent open checks that have dates prior to the Start date in Cash Manager > Setup. Plus you would need an O entry that is reflected in the GL balance but for which there is no open document. But after the first month, the only reason an O entry is needed is when there is a date error or something that was posted to GL that did not update cash manager such as using the cash acct on an AD document from the AP module. That would not be updating Cash Manager because it is not a document type that would be expected to update Cash.
When there is a date error, there would normally be 2 O type entries - one entered for the right date and one to offset the wrong date.
Be sure to verify in Cash Acct Maintenance that you have the box selected to update Cash Manager with any GL transactions.
And, always verify that the Bank Rec>CA balance matches the Daily Cash Balance>Closing balance for the date of the bank rec. If these 2 don't match, then there is either a data error (bad data created by the system ) or someone posted something with a transaction date in a closed Bank Rec.
Now what to do.....
There are a couple of KBs that discuss starting Cash Manager over: 848240 and 843770.
Sometimes the client will go back say 6 months to use as the start date hoping to pick up most unreconciled checks and then start over from there. It is quite a bit of work. During this process you will be deleting all of the O type entries that were made because ALL O type entries from the beginning of time are used whereas only AR/AP/GL entries from the CA setup start dates are use.
If you decide on a start over plan, I would do so first in a test copy of the database.
If you don't start over and the GL balance is displayed for the correct amt but the GL <> CA balance, then you would need to decide which balance is correct. If the cash manager balance is correct, you would need to make a GL entry (with the box Unchecked to update cash Manager when you release the transaction. If the box remains checked, then both GL and Cash Manager are updated and you have gained nothing). If GL is correct, then you would need to enter an O type entry which, of course, would update the CA Balance.
Share
Report
All responses (
Answers (
291,280
