web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Cash receipt not appea...
Microsoft Dynamics GP (Archived)

Cash receipt not appearing in Bank deposit - cheque posted without a batch

(0) ShareShare
ReportReport
Posted on by Shady Kaaky 440

Hi, I'm using GP 10.0 and I recently upgraded to  SP5.

Now, I'm having an issue related to cash receitps and bank deposits. When I post a cash receipt using cheque as payment and posting it without using a batch, the receipt doesn't show up in the bank deposit entry window; however when I enter a receipt as cash it does show and what is strange is that when I enter a receipt as cheque and post it using a batch it DOES appear in bank deposit entry window.

what is the difference between posting a cash receipt with or without a batch?

Cash receipt not appearing in Bank deposit - cheque posted without a batch

 any help? Thanks

*This post is locked for comments

I have the same question (0)
  • Noni Profile Picture
    Noni 25 on at
    RE: Cash receipt not appearing in Bank deposit - cheque posted without a batch

    Unfortunately I do not have a full work around as previously stated.

    Cheque payments only appear as Bank Deposits when posted in a Sales Transaction batch. Cheque payments posted in a Cash Receipts batch do not update onto Bank Deposit list.

    I need help on this. Anyone?

  • Noni Profile Picture
    Noni 25 on at
    RE: Cash receipt not appearing in Bank deposit - cheque posted without a batch

    We are running GP 2013. Cash Receipts posted with payment method = Cheque are not appearing in Bank Deposit Entry unless they are posted in a batch.

    Disabling both Cashflow Mgmt and Payment Doc Mgmt have not had any impact on this bug.

    I would like to know if any other customers are experiencing this issue, and if they are just working around it by posting Cash Receipts in batches?

    Ideally I would like the bug troubleshooted and resolved by Microsoft as it would seem it has been around since at least GP10.

  • Brian Wick Profile Picture
    Brian Wick on at
    Re: Cash receipt not appearing in Bank deposit - cheque posted without a batch

    Hi Shady,

    If you voided MC payments from Payables, then that information would be in the MC020103, CM20200, PM30200, & PM30600 tables.  You could review these tables to ensure all of the information is correct in them.  Most likely the problem is going to be in the MC020103, but I am just speculating by your description.  I would need to see table results of the payments to confirm the best approach to tackling this and to do that you would need to open a support case.

    I hope this helps.

    Thank you,

    Brian Wick

    Microsoft Dynamics GP

  • Shady Kaaky Profile Picture
    Shady Kaaky 440 on at
    Re: Cash receipt not appearing in Bank deposit - cheque posted without a batch

    Thanks a lot Brain,

    I will remove PDM from the Dynamics.set and redistribute the modified file to all users since we install client version on user's machines.

    As for the missing cash receipts, I will have them re-entered into the bank rec but I've also noticed that this issue affected the voided payments as well.

    Voided payments in the checkbook were shown at zero original currency but the correct functional currency.

    I'm still trying to find a work around this issue, if you have any idea how to fix these voided payments please let me know. Do you know which tables voided payments use in case I can fix the issue through SQL.

    Thanks again Brain,

    Regards,

    Shady

  • Brian Wick Profile Picture
    Brian Wick on at
    Re: Cash receipt not appearing in Bank deposit - cheque posted without a batch

    Hi Shady,

    If don't plan on using PDM, you could remove it from Add/Remove Programs if you wish or just remove it from the DYNAMICS.set file following KB 872087 to permanently disable it.  

    872087 How to disable third-party products in the Dynamics.set file in Microsoft Dynamics GP

    mbs.microsoft.com/.../KBDisplay.aspx

    As far as I know, we don't have any open bugs on Cash Flow Management that seem to be causing an issue like what you are encountering, but from what Leslie mentioned from her client it can cause issues.  If you don't use the module or plan to use it in the future, you could also remove it from Add/Remove or just remove it from the DYNAMICS.set file.  Just make sure you have a copy of the DYNAMICS.set file prior to making any changes to it in case you need to revert back to it.

    For the missing cash receipts, you'll have to enter them manually in Bank Rec.  You can enter one big deposit without receipts that totals the amount of the missing receipts by going to Transactions>>Financial>>Bank Deposits or you can enter in individual receipts by going to Transactions>>Financial>>Bank Transactions.  Choose Enter Receipts and then your Type which will allow you to enter in each  missing receipt.  Then you can go back to Bank Deposit Entry and Deposit the receipts.  This will be a lengthy option.

    Both options should update the current checkbook balance once deposited.  Make sure you do not post through to the GL if you enter Bank Transactions as this will create GL batches.  Most likely your cash account balance was updated when the cash receipts GL Batch posted from RM.  You'll want to verify that because you will not want to post to the GL twice.  If the cash account/GL is correct, then be sure to delete any batches created from Bank Rec as you don't want to update the GL again.

    Thank you,

    Brian Wick

    Microsoft Dynamics GP

  • Shady Kaaky Profile Picture
    Shady Kaaky 440 on at
    Re: Cash receipt not appearing in Bank deposit - cheque posted without a batch

    Hi Brain,

    For those transaction that didn't show in the Bank deposit, is there a way to manually transfer them to Bank deposit so the Bank rec. balances with the GL?

  • Verified answer
    Shady Kaaky Profile Picture
    Shady Kaaky 440 on at
    Re: Cash receipt not appearing in Bank deposit - cheque posted without a batch

    Thanks Brian,

    Disabling Payment Document Management fixes the problem but the issue comes back once I re-enable Payment Document Management.

    Disabling/Enableing Cash flow management didn't have any effect on cash receipts but could it be affecting other modules? should I disable it or is there anything special that I have to do?

    Thanks again.

  • Brian Wick Profile Picture
    Brian Wick on at
    Re: Cash receipt not appearing in Bank deposit - cheque posted without a batch

    Hi Shady,

    Try temporarily disabling Cash Flow Management through Customization Status to see if that truly is the cause.  You can do this through Tools>>Customize>>Customization Status.  Test out the issue once the module is disabled to see if the issue persists.  

    Another module that has been known to cause issues is Payment Document Management.  If you have that module installed, I would try to temporarily disable that module as well.

    Thank you,

    Brian Wick

    Microsoft Dynamics GP

  • Shady Kaaky Profile Picture
    Shady Kaaky 440 on at
    Re: Cash receipt not appearing in Bank deposit - cheque posted without a batch

    Hi Leslie,

    Yes, I do have Cash flow management installed. Actually, recently I entered new keys and I clicked on validate and register All. I'm not sure whether this module was enabled or not before I enetered the new keys.

    Do you think it has any effect?

    What should I do in this case?

    Thanks.

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Cash receipt not appearing in Bank deposit - cheque posted without a batch

    Recently another user had this problem and it turned out to be an issue with the cash management module. Do you have that module installed?

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans