Run-time Error 94 'Invalid use of null' when Closing the Billing Cycle in QuickSell 2000

Article ID: 857227
Expand all | Collapse all

TechKnowledge Content

Issue

Run-time Error 94 - 'Invalid use of null' occurs when closing the billing cycle in QuickSell 2000.

Resolution

This error indicates a null value in the ChargableBalance field of the Customers table. The following SQL statement may correct this:

UPDATE Customer SET ChargableBalance = 0 WHERE ChargableBalance IS NULL

Follow the steps below to run this SQL statement. Be sure to make a backup of your QuickSell 2000 database file prior to completing these steps.

1. Launch QuickSell 2000 Doctor.

2. Select the Update QS2000 Database Structure button.

3. At the Update Database Structure window press Ctrl-S. This opens the QS2000 SQL Statement window.

4. In the QS2000 SQL Statement window copy and paste the above SQL statement into this window.

5. Press OK to run the statement.

6. Press OK when you see the message SQL Statement successfully executed.

7. Cancel out of the Update Database Structure window.

8. Exit out of QuickSell 2000 Doctor.

You should now be able to close the billing cycle in QuickSell 2000 Manager by going to Journals | Close Billing Cycle.

This article was TechKnowledge Document ID: 27291

Properties

Article ID: 857227 - Last Review: July 13, 2011 - Revision: 2.0
Keywords: 
kbmbsmigrate KB857227
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.

Give Feedback

 

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