Verifying & Repairing Data / What if Rebuilding Does Not Work
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Full Access Members have full access to VTC.com’s entire library of video tutorials.
Learn More
Subtitles of the Movie
What if we've gone through troubleshooting, we've rebuilt our data and we're still having the same difficulties. Well I'd like you to keep in mind that there is a few other things that we can try, however QuickBooks does have a service that you can send them your data and they will try to fix it for you. Unfortunately this comes with a price, it can be very expensive to rework your data, so make sure you absolutely need to do that. Again it goes back to, back up and check your back ups, I recommend at least once a month makes sure you have an absolutely good back up. If I have a good back up, no errors, I'm going to check my logs, rebuild my data, the nice part is I can usually redo a month's worth of work. Of course I don't want to but we're talking worse case scenario. Now some of the other things I want to point out to you, when you're in your list and your adding new items, new customers, new vendors, please be careful about using too many special characters and spaces. The rule of thumb is try to avoid them at all costs. However very often we like to use the ampersand, we like to use dashes, just keep in mind that this has a higher risk of things going wrong. In particular they cause issues when they are at the beginning of an item, very often we like to put an asterisk in front, to just kind of flag it for ourselves, resist this opportunity. That could cause you problem with corruption and the thing with corruption is its progressive, it works today and then two weeks from now it doesn't work. So you don't remember what you did wrong. Try as much as possible to keep your names as clean as possible, go to town in the description list because that is more of a dormat type field that's not used sorts in the background. In our inventory, same thing, becareful, what I want you to becareful of in particular is that if you accidentally put a space at the beginning of an item list. I've known this to cause great deal of headaches. We can also do some troubleshooting by looking at our journals, our chart of accounts, our transaction detail reports. Under your report area in the accountant area you'll see all the reports I'm about to talk about. First in our journal, remember your journal is going to make sure that you can see everything that you've done in journal entries. I want you to ensure that they are in balance; I want you to ensure that you're account numbers and everything are coming up correctly. Now again remember this is just in the case of when things are going wrong. If your journals check out then I'd like you to eyeball your general ledger. In the general ledger in particular I want to make sure everything is in balance in each of the accounts. So I'm going to make sure my debits equal my credits. In the case of a corrupted entry, this could be out of balance and that's what we're looking for. I can also look at a custom transaction detail report, this will give me debits and credits per transaction. It's a little bit harder to read but again remember in most instances we're going to be looking at a small section of data not all of it. Here I'm just eyeballing that each of my transactions again have a Debit ad Credit. In corrupt data one of these could have a hiccup to it. So when we're troubleshooting I'm going to make sure that there are no special characters or spaces in my item list, I'm going to look at my ledgers and my journals to make sure that everything is gone correctly with both my debits and my credits and I'm going to eyeball the custom transaction detail report. If I've done all of this, I've rebuilt my data, I've checked my preventive maintenance on my machine, the last area of recommendation that I have is to ensure you run a scan disk on all of the machines that are running QuickBooks in particular the machine that is storing your data. You could have an issue on your hard drive; you could have what we call a bad sector that is causing the problem. Run your scan disk, all of those are coming up clean, then you'll probably need to return to a back up or absolutely worst case scenario ask Quick Books to try to fix your data. Remember if you don't have those backups though there's not going to be any type of data that you can actually fix.
Tutorial Information
| Course: | QuickBooks 2008 Advanced |
| Author: | Lauri Sowa-Matson |
| SKU: | 33900 |
| ISBN: | 1-934743-82-8 |
| Release Date: | 2008-08-28 |
| Duration: | 7 hrs / 88 lessons |
| Work Files: |
Yes |
| Captions: | Available on CD and Online University |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 98,729 Video Tutorials (23,265 free)
- Video Available as Flash or QuickTime
- Over 1026 Courses
- $30 for One Month Access
- Multi-User Discounts Available
United States 