Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Cash Receipt hitting bank rec incorrectly

Posted on by 10

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!

  • Suggested answer
    RE: Cash Receipt hitting bank rec incorrectly

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans