1. Home
  2. QuickBooks Discussions
  3. Report sorting - busted in 2006?

Report sorting - busted in 2006?

We recently 'upgraded' from the 2003 Premier Contractor Edition to the 2006 Premier Contractor Edition. Not my choice, the old version worked just fine, thank you. But, we use Intuit payroll and the gun was to our heads with the trigger cocked.

Today I went to the report center, and pulled up an "Open Invoice' report. It is not sorted. It is not sorted in any manner. The first customer open invoice is Chxxxt, followed by McDxxxxl, and Kuxxxe (x's inserted to protect my customer's privacy). The aging is 8 days, 0 days, 0 days. (Those are just the first three entries, the rest of the report is similarly cluged). Attempting to reset the sort by sorting the customer list and/or resorting the report by any other field does not work. Ditto for the canned Collections report in the Reports section. The memorized reports I have created ALSO have this same sorting problem.

We have been doing regular backups WITH verify. Nothing seems to be wrong with the file.

What gives? And how do I fix it? TIA

Reply to
L
Loading thread data ...

Have you hit modify report and looked to see what sort is applied to the report?

Reply to
Golden California Girls

Yes, I did. It was 'default' (as stated by QB. And yes, I would like it if QB detailed what the default sort was for each report.). I also tried to re-sort the report(s) based on aging or name, and it was a no-go. The fact that the problem occurred both in memorized reports AND in QB 'canned' reports really bothered me, and also suggested to this ex-programmer that the issue was perhaps in the customer database itself.

I tried going direct to the customer list, and re-sorting there. Resorting the list did not work. Neither did verifying or rebuilding the company file.

Finally fixed it though. Got onto the admin account, kicked all workers off the file and switched to single user mode (again!), switched the customer list to flat view, resorted, switched the customer list back to hierarchical view.

Problem solved.

No clue as to why QB can't sort the database with the file in hierarchical view, but evidently it is a problem.

Reply to
L

Interesting. Wonder if there was some corruption in your 2003 data that wasn't fixed in the conversion that caused that. We didn't and don't have that problem in our 2003 to 2006 move but we're using premiere accountant edition. Our customer data has gotten unsorted (2003 did this too) for no reason. A resort in hierarchical view brings it back in line though. I'll keep this tip in the back of my head though.

Reply to
Golden California Girls

I wondered that myself. Truthfully, it is one reason the bad sort in the report bothered me. I felt strongly the file was corrupted somehow.

Before the installation of the 2006 version the company file was backed up and verified. There did not appear to be any errors. QB made the conversion from 2003 data format to 2006, again with no errors reported. The logs are clean. We are using the premier contractor edition.

Reply to
L

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.