Finance | Project Operations, Human Resources, ...

Cash Receipts missing from deposits for Check Register

(0) Share

Report

Posted on by Richard Wheeler

75,852 Moderator

Looking at the list below you will see the differences in which tables got hit after posting cash receipts. The column marked Missing is the one where the cash receipts do not appear on the bank deposit on the checkbook. The first thing I noticed when I zoomed on the cash receipts was that the distributions were missing. That would explain the RM10101 table. Running check links did not fix any of these and before I start manually correcting the missing records I was wondering if scripts already exist to assist in matter like this? Obviously this is the result of incomplete posting. There were three of them posted on the same day in the same batch.

	Missing	Not Missing
CM20300	No	Yes
GL20000	No	Yes
PA13100	Yes	No
PA23000	Yes	Yes
PA23010	Yes	Yes
PA23100	Yes	No
RM00401	Yes	Yes
RM10101	No	Yes
RM20101	Yes	Yes
RM20201	Yes	Yes
RM30202	Yes	Yes

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (4)

Answers (0)

Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

By the way, missing No means no records existed in the table. So there were no records in the RM10101 table for the cash receipts that were missing from the deposits.

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

I just compared the RM20101 table to the GL20000 using the ORDOCNUM AND DOCNUMBER fields and there are over 3,100 mismatches. Many of these have BCHSOURC as XRM_Cash or XRM_Sales and the batch number is the user's name in lower case letters. I will start working on scripts to correct the ledger and start inquiry as to why this has not been noticed before now.

Was this reply helpful? Yes No
Suggested answer

Cheryl Waswick Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (1)

Report
Copy link

Link copied!

Cheryl. as always you are correct. They never run Paid Transaction removal. I should have said I compared the RM20101 to the union of the GL20000 and GL30000 tables. We are having a meeting this week to discuss my findings.

Was this reply helpful? Yes No