A credit balance in a cash account is displayed as a positive value in the "GL Balance" box but as a negative value in the "CA Balance" box in the "Bank Reconciliation (20.210.00)" dialog box in Microsoft Dynamics SL

Article translations Article translations
Article ID: 898696 - View products that this article applies to.
Expand all | Collapse all

On This Page

Symptoms

The Bank Reconciliation (20.210.00) dialog box in Microsoft Business Solutions - Dynamics SL displays conflicting information for a credit balance in a cash account. The GL Balance box contains a positive value. However, the CA Balance box contains a negative value.

Cause

This problem occurs if the cash account is set up as a liability account. Typically, the account is set up in this manner because the cash account represents a credit card. Any balance in the account represents an amount due to the credit card company. The Microsoft Dynamics SL Cash Manager module does not anticipate that cash accounts will be liability accounts. The program displays a positive balance for an account as a positive value in the GL Balance box regardless of the account type.

Workaround

The GL Out of Balance value does not have to be zero to reconcile this account. If the following conditions are true, this account is in balance, and no additional action is required:
  • The absolute value of the CA Balance value is the same as the GL Balance value.
  • The GL Out of Balance value is exactly double the GL Balance value.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

This issue has been reported as bug 8218. If a hotfix is available, you can find the hotfix in the "Downloads & Updates" section of the Microsoft Business Solutions PartnerSource Web site or CustomerSource Web site. If you do not find a hotfix for this bug number in PartnerSource or CustomerSource, search the “Summary of Changes” document for the next Microsoft Dynamics SL release or Microsoft Dynamics SL service pack to determine whether the bug has been corrected in the release or the service pack.

More information

Steps to reproduce the problem

  1. Create a new liability account:
    1. Open the Chart of Accounts Maintenance (01.260.00) dialog box.
    2. Press F4.
    3. In the Account box, type 2035.
    4. In the Description box, type American Express.
    5. In the Type box, click Liability.
    6. Click Save, and then click Close.
  2. Set up the new account that you created in step 1 as a cash account:
    1. Open the Cash Account Maintenance (20.250.00) dialog box.
    2. Press F4.
    3. In the Company ID box, type 0060.
    4. In the Bank Account box, type 2035.
    5. In the Bank subaccount box, type 00-000-00-00-00-0.
    6. In the Cash Account Name box, type Amex Credit Card.
    7. In the Bank Account Number box, type 12345678.
    8. Click Save, and then click Close.
  3. Set up a credit card entry type:
    1. Open the Entry Type Maintenance (20.260.00) dialog box.
    2. Press F4.
    3. In the Entry Type box, type CC.
    4. In the Description box, type Credit Card Charges.
    5. In the Default Account box, type 6510.
    6. In the Default Subaccount box, type 00-000-00-00-00-0.
    7. Click Save, and then click Close.
  4. Enter a cash transaction for the new account that you created in step 1:
    1. Open the Cash Account Transactions (20.010.00) dialog box.
    2. In the Handling box, click Release Now.
    3. In the Control box, type 350.00.
    4. In the Bank Account box, type 2035.
    5. In the Bank Subaccount box, type 00-000-00-00-00-0.
    6. In the Entry Type box, type CC.
    7. In the Debit Amount box, type 350.00.
    8. Click Save, note the value in the Batch Number box, and then click Finish.
  5. Post the batch that you entered and released in step 4:
    1. Open the Post Transactions (01.520.00) dialog box.
    2. Click Clear All.
    3. Click to select the Selected check box for the batch number that you noted in step 4.
    4. Click Begin Processing.
  6. Reconcile the bank account:
    1. Open the Bank Reconciliation (20.210.00) dialog box.
    2. In the Cash Account box, type 2035.
    3. In the Cash Subaccount box, type 00-000-00-00-00-0, and then press TAB.
    4. In the Statement Date box, press F7.
    5. In the Statement Balance box, type -350.00, and then press TAB.
    6. Click Reconcile Checks to open the Reconcile Checks (20.210.01) dialog box.
    7. Click to select the Cleared Check check box, click Save, and then click OK.
    Note The value in the Adjusted Balance box is -350.00. The value in the CA Balance box is -350.00. The value in the CA Out of Balance box is 0.00. However, the value in the GL Balance box is 350.00. The value in the GL Out of Balance box is 700.00.

Properties

Article ID: 898696 - Last Review: September 17, 2012 - Revision: 2.1
Applies to
  • Microsoft Dynamics SL 2011
  • Microsoft Dynamics SL 2011 Service Pack 1
  • Microsoft Dynamics SL 6.5
  • Microsoft Dynamics SL 6.5 Service Pack 3
  • Microsoft Dynamics SL 7.0
  • Microsoft Dynamics SL 7.0 Service Pack 2
  • Microsoft Dynamics SL 7.0 Service Pack 3
  • Microsoft Dynamics SL 7.0 Service Pack 4
Keywords: 
kbretire kbmbsmigrate kbbug KB898696
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com