QuickBooks Error Report

[LauraD]

There is a known 'glitch' in QuickBooks Pro, Premier, and Enterprise, v 2008 and 2009, of which you might want to be aware.

It will not throw your Balance Sheet 'out of balance', but it will affect your Checking and Undeposited Funds accounts.

To determine if this is a problem in your file, do this:

Go to Banking>Make deposit and select all payments waiting to be deposited. Compare that total amount to your Undeposited Funds amount as reflected on the Chart of Accounts. These should match.

If they don't, this is due to a broken transaction. One or more deposits (with payments) were deleted, but got 'hung up' in mid-air, so to speak, leaving a one-sided transaction.

If you go to the payment and click on 'history', you will see the invoice and the 'deposit'. The deposit will have a 1901 (that is not a typo) date on it. When you drill down, you will get the message that this transaction has been deleted by another user.

This is a known glitch with Intuit and occurs in v 2008 and v 2009, Pro, Premier, and Enterprise.

The only solutions, per Intuit tech support, is this:

1) Restore a backup from before the problem happened.

or

2) Send the file to Data Services for repair (takes up to 2 weeks)

To prevent this problem, do this:

When you have a deposit that has one or more payment lines along with additional line (a refund check, for example), make sure that the refund check is the last line on that deposit. Otherwise, in the event that you delete that deposit, the payment(s) might get caught in a time warp (1901) and will not be retrievable to re-enter to another deposit form.

I have seen this in a few files so far (one contacted me and I found a $103K discrepancy, which has accumulated over time).

I hope this helps prevent some major problems for you and your clients.

Laura D

________________________

See my profile at:

http://proadvisor.intuit.com/referral/proadvisor_profile.jsp?id=YQ88CA%2BS0H5c1ImS11E9oQ %3D%3D

[Joe Williams]

Just courious. Can you run a report for date set to 1900 through 1910 and get a list of those transactions?

[LauraD]

You cannot search anything pre 01/01/1901.

But searching from 01/01/1901 - 12/31/1999 brings no results.

Laura D

[RobJoy]

Might it be an idea to put this in the FAQs?

[Shannon Tucker]

I'll move this thread to the QuickBooks FAQ forum.

We can repair this error in a couple of days or less. Details here. (http://quickbooksusers.com/datarepair.htm)

[JERRYSR]

I THINK I MAY HAVE FOUND AN ANSWER TO THE BUG IN THE QB PRO2009 WHICH GOES LIKE THIS:
I was trying to reconcile my bank statement to QB PRO 2009 and I found a few checks which were written on online banking which gave them their own numbers in the 5000 range and when I tryed to modify the check number, not any math, on the original check by opening it up while in the reconciliation register, it then wrote an additional check for the same amount and it was then in my account twice.

SOLUTION TO PROBLEM:

WHEN RECONCILING THE CHECK REGISTER IN QP PRO 2009, ALWAYS CLOSE THE RECONCILIATION BEFORE ATTEMPTING TO MAKE ANY CHANGES AT ALL ON ANY OF THE CHECKS EVEN CHANGING THE DATE OR ADDING A DATE WHERE ONE WAS WRONG WILL CAUSE IT TO MAKE AN ADDITIONAL CHECK AS IT IS READING IT AS AN ENTIRELY NEW TRANSACTION INSTEAD OF AN ADJUSTMENT. THEN THIS ERROR WILL NOT HAPPEN. I TRIED IT BOTH WAYS AND THIS WAS MY FINDINGS. HOPE THIS HELPS SOMEONE.:p

[D.meave]

An invalid certificate error when trying to access Quickbooks is usually caused by runtime MS Access. You need a full commercial copy of MS Access to sync data with Quickbooks.

Users who are not directly triggering the sync with Quickbooks can use the free runtime version of MS Access.

[skies_unlimited]

Hi, just joined the group.

I am using an old version of QB - version 8 dated about 2000. It does all I want of it.

I first noticed a problem a couple of years back of getting runtime errors which I concluded (after much frustration, reinstalling, moving to spare computer that did the same) was caused by IE7 installing itself. I just tried a laptop that had gone to IE8 and guess what, same runtime error. The problem only shows when accessing the customer list and the effect is you can't scroll down and see any customer other than the first.

QB's answer - we don't support that product. Fine. So they advise I buy a 'new' version. I asked what had happened to the years 2009/2010 as I couldn't see anything other than 2008. Yet, to be released was the reply - umm - new version?

Anyway, removing IE8 leaving no IE versions on the computer - problem solved. It works fine. I browse with Firefox.

Moral: if it ain't broke, wait a moment and someone will break it for you with an 'improvement'.

Happy accounting - Alan

[ronblack]

Thank you for the information. A friend of mine using an older version of QB was having a similar issue and has now been resolved.

Cheers,