Dynamics Community Forum Thread Details

Cash Receipt hitting bank rec incorrectly

Hello,

We have a company set up in GP for our single vending machine. When people use cash to buy products from the machine I get a report showing how much and when.

I then enter a cash receipt on the sales module to record the cash for the week but I debit cash on hand, credit inventory. Then, when we actually pull the cash out and deposit it into our bank, I would then make a bank transactions to debit the bank account and credit cash on hand.

This has worked all year, but now when I enter the initial cash receipt (which does not hit the bank account at all) the transactions are showing up on the bank rec. Even though if I drill into the document number on the bank rec and look at the distribution, the bank account has not been debited or credited.

Has anyone had a similar problem or know why this would be happening now?

Thanks!

Categories:

Financial Management

Other

Project Accounting

Hello,

Nothing has changed in GP. Any time you key a cash receipt, it flows to the Receipts table (CM20300) in Bank Rec, to be deposited and will show up in the Bank Deposits entry window. When you deposit it, then it updates the checkbook balance (not GL) and you see it in the reconcile window.

So you should find all your old receipts in the CM20300 table, and likely you just never did anything with them. You would have to use the 'clear unused receipts' type in the Bank deposits entry window if you are not going to deposit them. The GL account used ont hat cash receipt don't matter. They have a 'cash' amount and 'CASH" type on the distributions is why they flow to Bank Rec. But since you are keying a bank transaction instead instead of depositing these, a GL entry will be made so you are doing the reclass entry there. And that is fine, but your cash receipt should have always updated the CM20300 receipts table, waiting to be deposited. (You can check this table for some old ones to confirm.) It has always worked this way. You can use the 'clear unused receipts' type in the Bank deposits entry window to remove them from the window if you will not be depositing them, and doing a bank transaction or increase adjustment instead, so you get the GL entry with it.

Cheryl

Microsoft Dynamics GP Support

Quick Links

Leaderboard