Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

newuserT (TechnicalUser) (OP)
6 Dec 12 16:05
I created a journal entry and it had two separate credits for our checking account. When I went to reconcile the checking account only one of the credits showed up, but if I run a trial balance of my cash account I see both entries. How do I get the other entry to show up in my bank rec so that I can correctly reconcile?
VictoriaYudin (IS/IT--Management)
7 Dec 12 8:49
If you entered something directly in the General Ledger (Transactions | Financial | General), that will NEVER show up in the Bank Rec subledger. All posting in Dynamics GP goes from the subledgers to the General Ledger, there is never a time when the General Ledger posts something to a subledger. (At least out of the box.)

So...if one of your amounts is showing up in the Bank Rec, it is most likely there from another source and entering it directly into the General Ledger may have duplicated it. If you're seeing it in Bank Rec, you can drill back on the transaction to see where it came from.

Victoria Yudin
Dynamics GP MVP 2005 - 2012
Use Crystal Reports and SSRS with GP:
http://www.GPReportsViewer.com/gpreports.html
blog: http://victoriayudin.com

newuserT (TechnicalUser) (OP)
10 Dec 12 14:45
I am in the bank rec and looking at the transaction ... it is a bank transaction set up as a withdrawal and both dollar amounts, the draw and the check are showing up here, but only one is on my bank rec. And they are both listed on the correct account.
VictoriaYudin (IS/IT--Management)
10 Dec 12 14:52
Sorry, I am not quite clear on what you mean. When you say you're 'in the bank rec' - what does that mean? What window? What search did you do? When you say "only one is on my bank rec" - where are you looking? Perhaps you could post screenshots showing what you're looking at?

Victoria Yudin
Dynamics GP MVP 2005 - 2012
Use Crystal Reports and SSRS with GP:
http://www.GPReportsViewer.com/gpreports.html
blog: http://victoriayudin.com

newuserT (TechnicalUser) (OP)
10 Dec 12 15:06
For some reason my screen print isn't working. When I click into reconcile bank statement and put in all my info and click transactions ... all of my deposits and checks come up just fine. I had created one "bank transaction entry" that had two credits to our cash account and only the first one in the transaction is listed as a transaction in my bank reconciliation as a WDL, the second one is not. How can I add the second one? I don't want to add it as a check because I'm afraid it will be entering it twice and that would not be necessary.
VictoriaYudin (IS/IT--Management)
10 Dec 12 15:24
Are you saying you have one Bank Transaction, but two GL distributions hitting the Cash account on it?

If that is the case, what you are seeing is to be expected. The GL distributions on the Bank Transactions are not what determines what shows up in Bank Rec. Only the amount in the Amount field (above the GL distributions) will show up in the Bank Rec module. If you need to have 2 separate withdrawals show up in Bank Rec, you would need to enter 2 separate bank transactions each with the Amount of the withdrawal that needs to show up in Bank Rec.

At this point, to fix this, you can do one of the following:
1. Void the transaction and re-enter as 2 transactions.
2. Enter a new withdrawal with the amount of the 2nd withdrawal (the one not showing up in Bank Rec). Choose the same Cash GL account for both the debit and credit. This way it will update the Bank Rec module, but not change anything in the GL.

If I am still misunderstanding what you are looking at, please give me more detail.

Victoria Yudin
Dynamics GP MVP 2005 - 2012
Use Crystal Reports and SSRS with GP:
http://www.GPReportsViewer.com/gpreports.html
blog: http://victoriayudin.com

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close