Support for Microsoft Dynamics, Acumatica, and Greentree

« Back to Search

Dynamics SL: How to Adjust the GL without Effecting the Cash Manager Cash Account Balance

Posted by Gary Korby on October 19, 2017

Many times, we get calls from clients where their Microsoft Dynamics SL Cash Manager Cash Account balance is correct but the General Ledger (GL) is off.  Here’s the simple way to fix the GL without effecting the Cash Manager cash account balance.


In our Dynamics SL example, the cash balance is correct; however, the GL is too high by $1,562.  I have the account set up to accept the GL transaction in Cash Manager and it’s been determined the cash balance has to be credited by $1,562 without affecting the balance in Cash Manager.


Here’s how:

  1. Enter an Outstanding Deposit (OD) transaction in Cash Manager for $1,562. Make sure the reconciliation status is set to “Cleared” and the transaction dates are correct.  The OD transaction will not affect the GL and will only effect the Cash Account balance, making them equal. 

    The other trick here is to make the transaction status “Cleared” right away.  By doing this, the outstanding deposit will not be created.  If you don’t set it to “Cleared”, then you would cause and imbalance between Cash Manager and the GL when cleared.

  2. Next, make a journal transaction crediting account 1041 for $1,562.  Again, make sure the transaction date is correct, the Reconciliation Status is set to “Cleared”, and the clear date is correct.  This should reduce the balance for both GL and Cash Account and not have any effect on the Adjusted Balance.

    The Bank Reconciliation now shows that Cash Manager and GL are now in balance for the correct amount.

For more helpful support resolutions for Dynamics SL, visit our blog.

Share this:


Add your comment:

Start a Support Ticket

Director of Support

We'll get back to you
within 3 hours

8am-5pm CST | 847-394-8820 ext 7

2015 Support Team Stats


support tickets


tickets solved
same day


closed within
5 business days

Webinars & Events



Dynamics GP 2017 Year-end Training - Madison, WI

Wednesday, December 6, 2017  |  9:00 AM–3:00 PM  |  Free



Dynamics GP 2017 Year-end Training - Farmington Hills, MI

Thursday, December 14, 2017  |  1:00 PM–4:00 PM  |  Free



Dynamics GP 2017 Year-end Training - Maitland, FL

Thursday, December 14, 2017  |  1:00 PM–4:00 PM  |  Free