Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
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"
| Article ID | : | 948600 |
| Last Review | : | April 2, 2008 |
| Revision | : | 2.0 |
SYMPTOMS
When you try to close a fiscal year for a company in Microsoft Office Accounting Professional 2007 or in Microsoft Office Accounting Express 2007, 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:| a. | Visit the following Microsoft Web site: | | b. | Scroll to the Files in This Dowload section, and then download the SQLServer2005_SSMSEE.msi file.
| | c. | Install SSMSE. |
|
| 2. | Run a script against your database. To do this, follow these steps:| a. | Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio Express. | | b. | In the Server name box, click the instance of SQL Server that is being used by Office Accounting Professional 2007 or by Office Accounting Express 2007.
Note By default, the name of the instance of SQL Server that is being used by Office Accounting Professional 2007 or by Office Accounting Express 2007 is MSSMLBIZ.
| | c. | In the Authentication box, click Windows Authentication. | | d. | Click Connect.
| | e. | In Object Explorer, expand Databases.
| | f. | 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." | | g. | 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 | | h. | On the Query menu, click Execute.
You receive the following message: A successful completion of query will indicate number of rows affected. | | i. | On the File menu, click Close. | | j. | If you are prompted to save the script, click No. |
|
| 3. | Close the fiscal year for the company in Office Accounting Professional 2007 or in Office Accounting Express 2007. To do this, follow these steps: | a. | Start Office Accounting Professional 2007 or Office Accounting Express 2007.
| | b. | Open the company where you tried to close the fiscal year. | | c. | 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:
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
| 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
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please
