Skip to main content

Notifications

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

Customer Deposits not going to the correct Bank Account for reconciliation

Posted on by 5

Hello,

We created a new bank account in Dynamics GP last month. When using the Customer Deposits feature, Sales>Sales Transaction Entry, I enter the new account information correctly. When it came time to reconcile, all deposits show up under the old bank account for reconciliation and not the new bank account. How do I insure all past and future deposits go to the correct bank account for reconciliation?

Categories:
  • Ryan McDaniel Profile Picture
    Ryan McDaniel 5 on at
    RE: Customer Deposits not going to the correct Bank Account for reconciliation

    I figured out the issue late Friday. I had no idea that when you do Credit Card setups that they HAVE to have a Bank account attached to them. The only reason i figured this out was because i inactivited the account that it kept going to and received an error trying to post a customer deposit. This making having to enter an account after a credit card deposit redundant and pointless. If you never had to set up a CC yourself, you would have no way of knowing this. This may be the single worst feature that i have had to deal with in Dynamics.

    Thank you for all your help all the same!

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: Customer Deposits not going to the correct Bank Account for reconciliation

    hi

    look this

    learn.microsoft.com/.../bankreconciliation

    DAniele

  • Joseph Markovich Profile Picture
    Joseph Markovich 3,900 on at
    RE: Customer Deposits not going to the correct Bank Account for reconciliation

    Hey Ryan-

    Is the order you are entering already existing or did you just enter it now? If entered before: when an order is created, it takes a copy of all those settings so they can be changed from the defaults in the future if they need to.

    You may have to go through your open orders and change that field to the new checkbook.

    Joe

  • Ryan McDaniel Profile Picture
    Ryan McDaniel 5 on at
    RE: Customer Deposits not going to the correct Bank Account for reconciliation

    Well that solves where those accounts were... Kind of annoyed I didn't notice that sooner. Thank you so much for that

    I do have still have the same issue though. I already changed the Checkbook ID under 'Sales Order Processing' but then I followed up with posting a deposit and it still showed up in the incorrect account in the 'Bank Deposits'

  • Joseph Markovich Profile Picture
    Joseph Markovich 3,900 on at
    RE: Customer Deposits not going to the correct Bank Account for reconciliation

    Hi Ryan-

    If you open that lookup screen again, it is defaulting to the checkbook ID of "OPERATING." What happens if you scroll up in the window or click the up arrows? Do the other accounts now show?

    Joe

  • Ryan McDaniel Profile Picture
    Ryan McDaniel 5 on at
    RE: Customer Deposits not going to the correct Bank Account for reconciliation

    No they do not. Here is a snippet of all created accounts under Financial>Checkbooks

    pastedimage1674768119854v1.png

    The operating is the one i showed previously under 'Sales Order Processing.' The other two are the ones that i cannot get to appear in the list. NMBT is the account that i want the deposits to appear in but they all show up in the Chase account when I go to 'Bank Deposits' in order to post them prior to reconciling. This is only affected by the deposits. When entering payments under 'Cash Receipts' it correctly goes to the NMBT account under 'Bank Deposits.'

  • Joseph Markovich Profile Picture
    Joseph Markovich 3,900 on at
    RE: Customer Deposits not going to the correct Bank Account for reconciliation

    Hi Ryan!

    Out of curiosity, do the new checkbook IDs start with a letter before "O"?

    Joe

  • Ryan McDaniel Profile Picture
    Ryan McDaniel 5 on at
    RE: Customer Deposits not going to the correct Bank Account for reconciliation

    pastedimage1674762152728v1.png Here is a snippet of how it reads when i apply the deposits in the 'Sales Transaction Entry'. The struggle comes when i go into 'Sales Order Processing' and open up the 'Checkbook ID' NMBT Checking doesnt show up and i have no idea why. Snippet below is the only account to show up under Checkbook ID. 

    pastedimage1674762268493v2.png

  • Joseph Markovich Profile Picture
    Joseph Markovich 3,900 on at
    RE: Customer Deposits not going to the correct Bank Account for reconciliation

    Hey Ryan-

    It is the same in the current versions too. Just change that field to the checkbook you want to use and it should be fine going forward.

    Joe

  • Ryan McDaniel Profile Picture
    Ryan McDaniel 5 on at
    RE: Customer Deposits not going to the correct Bank Account for reconciliation

    Hi Joseph,

    It looks like there may be potential that it may not have been set up correctly. I went into 'Sales Order Processing' but it only shows the oldest inactive account under Checkbook ID. Since this account was used, we have changed bank accounts twice. I'm not sure why the previous account we were using isn't showing up here either.

    I have also found out which version we are currently on. We are using the 2015 version. I'm not sure how much things change for this version. Assume i know little to nothing about Dynamics.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans