RE: Cash Receipts missing from deposits for Check Register
Hi Richard,
All cash receipts when posted will update GL and then flow into the Bank Rec receipts table (CM20300). When drilling back on a deposit in the checkbook inquiry window (CM20200), it will display the receipts with a matching 'depositnumber' from the CM20300 table only. So if you are missing the drillback from a deposit, first make sure the deposit type is (DEPTYPE) = 1, so is a 'deposit with receipts' type, and then it should display those receipts form the Receipts table (CM20300) with the same deposit number. There would not be receipts if the deposit type is 2-deposit without receipts or 3-clear unused receipts. But the CM20300 is the only table the display of receipts come from when drilling back on a deposit in checkbook inquiry.
The RM10101 is a 'distribution' table. This table is not used by the ATB or HATB reports, so it's really not a big deal if records are missing from this table, as long as they made it to GL. The ATB/HATB reports uses transaction and apply tables and not any distribution tables. Having records in the RM10101 distribution table would just provide a 'display' to the user when drilling back on a transaction in RM. But that doesn't necessarily mean it didn't make it to GL. It's not imperative to get the RM10101 table populated, if they made it to GL, unless it's something the client is requesting for 'display' purposes. Missing records from the RM10101 doesn't affect the ATB reports, so is not a big deal, as long as they made it to GL.
You said you found over 3,100 records from the RM20101 missing from the GL20000 table. Be aware that many users don't run the 'paid transaction removal' process to move the records in RM from the open table to history tables, and so they have huge open tables in RM. But the corresponding year in GL may be closed, so you'd have to look at both the GL20000 and GL30000 tables, and also make sure they are not posting in summary. If they have been completing reconciliations between the HATB to the GL balance to date, then all records are there.
Hope that helps,
Thanks
Cheryl Waswick
Microsoft Support
Share
Report
75,788
All responses (
Answers (
