Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Cash Receipt hitting bank rec incorrectly

(0) ShareShare
ReportReport
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!

Categories:
  • 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans