Microsoft Knowledge Base Email Alertz
All KB/RSS Links  |  Hot Kb!  |  New Kb!  |  Scott Cate  |  FAQ / KB  |  Web Hosting  |  Unsubscribe  

Error message when you close a fiscal year for a company in Accounting Professional 2007 or in Accounting Express 2007: Please make sure that Debit equal to DebitCompanyCurrency and Credit equal to CreditCompanyCurrency

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.
Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks
Article ID: 948600 - Last Review: September 10, 2011 - Revision: 2.0

Error message when you close a fiscal year for a company in Accounting Professional or in Accounting Express: "Please make sure that Debit equal to DebitCompanyCurrency and Credit equal to CreditCompanyCurrency"

View products that this article applies to.

SYMPTOMS

When you try to close a fiscal year for a company in Microsoft Office Accounting Professional or in Microsoft Office Accounting Express, you receive the following error message:
Please make sure that Debit equal to DebitCompanyCurrency and Credit equal to CreditCompanyCurrency.
Back to the top

CAUSE

This problem occurs because the rounding of the transaction totals is incorrect.
Back to the top

RESOLUTION

To resolve this problem, follow these steps.

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.
  1. If you do not have Microsoft SQL Server Management Studio installed, download and then install SQL Server Management Studio Express (SSMSE). To do this, follow these steps:
    1. Visit the following Microsoft Web site:
      http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796 (http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796)
    2. Scroll to the Files in This Dowload section, and then download the SQLServer2005_SSMSEE.msi file.
    3. Install SSMSE.
  2. Run a script against your database. To do this, follow these steps:
    1. Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio Express.
    2. In the Server name box, click the instance of SQL Server that is being used by Office Accounting Professional or by Office Accounting Express.

      Note By default, the name of the instance of SQL Server that is being used by Office Accounting Professional or by Office Accounting Express is MSSMLBIZ.
    3. In the Authentication box, click Windows Authentication.
    4. Click Connect.
    5. In Object Explorer, expand Databases.
    6. Right-click the company database that you received the error message for, and then click New Query.

      Note The company database usually appears as the company name without spaces. For example, "Sample Product Company" will be displayed as "SampleProductCompany."
    7. Copy the following script, and then paste the script in the Query window. 
      UPDATE cashpostingtable SET amountCreditCompanyCurrency = amountCredit, amountDebitCompanyCurrency = amountDebit, 
companyAmountRemainder = accountAmountRemainder 
WHERE (amountcredit <> amountCreditCompanyCurrency OR amountDebit <> amountDebitCompanyCurrency) 
AND exchangeRate=100 AND perRatio < 100
    8. On the Query menu, click Execute.

      You receive the following message:
      A successful completion of query will indicate number of rows affected.
    9. On the File menu, click Close.
    10. If you are prompted to save the script, click No.
  3. Close the fiscal year for the company in Office Accounting Professional or in Office Accounting Express. To do this, follow these steps:
    1. Start Office Accounting Professional or Office Accounting Express.
    2. Open the company where you tried to close the fiscal year.
    3. Close the fiscal year.
Note If you cannot perform the steps or the steps do not resolve the problem, log on to the Technical Support site for Microsoft Dynamics and related products, and then create a new support request. To do this, visit the following Microsoft Web site:
http://support.microsoft.com/oas/default.aspx?gprid=13056 (http://support.microsoft.com/oas/default.aspx?gprid=13056)
You can also contact Technical Support for Microsoft Dynamics and related products by telephone by calling (888) 477-7877.
Back to the top
APPLIES TO
  • Microsoft Office Accounting Professional 2007
  • Microsoft Office Accounting Express 2007
Back to the top
Keywords: 
kberrmsg kbexpertisebeginner kbtshoot kbmbsmigrate kbprb kbexpertiseinter KB948600
Back to the top
        

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate

Copyright © 2002-2007 KBALERTZ.COM.  All Rights Reserved. Terms / Privacy. Discount ASP.NET Hosting