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?
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!
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
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'
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
No they do not. Here is a snippet of all created accounts under Financial>Checkbooks
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.'
Hi Ryan!
Out of curiosity, do the new checkbook IDs start with a letter before "O"?
Joe
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.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156