AR Report by rep

I tried filtering the report for the Rep field and it seems to work for me, for the invoices that included the rep I filtered for. I can't seem to break it...

Hi, chadcmc. I'm here to help you figure this out.

The report might disappear due to data damage. Let's ensure you have the latest version of QBDT installed. Once done, run the Verify/Rebuild utility to detect the data damage.

Here's how:

1. Click File.
2. Go to Utilities, then choose Verify Data.
3. If QuickBooks detected no problems, there's no further action needed. If you receive a message, "Your data has lost integrity," the file is damaged. Just continue to Rebuild Data to correct the problem.
4. When you Rebuild Data, you'll receive a message to back up your company file, just click OK. The utility starts as soon as the backup is finished.
5. Click OK when you get the message "Rebuild has completed."
6. Run Verify Data again to check for remaining data damage.

Afterward, pull up the report again and filter it to see if it works.

Need help customizing reports? You can also check this article for reference: Customize reports in QuickBooks Desktop.

You can always get back to me for further questions about reports. I'll be sure to get back to you.

I did the verify data process as explained. It did find some issues and went through the correction process. However when I pulled the report again I get the same results. To be clear on what I am trying to do my process is: Reports, Customers and Receivables, A/R Aging Summary once the report is open it then shows all balances due in the 30 day increments. I then go customize report, Filters, choose the Rep filter and at this point if I leave all reps the report does not change but if I select an individual rep the report basically disappears. For one rep it shows one customer and not even an accurate open balance on the account

Thanks for following my peer's suggested resolutions. I'm here to help you get past this issue. 

Since you're still getting the same result, we can rebuild again two or three times more to ensure it will work. 

If the issue persists, we can download the File Doctor to your computer. We recommend uninstalling anything you've used before today. Here's how: 

1. Click this link: QuickBooks File Doctor, then save the file somewhere you can easily find it. If you've installed Tool Hub before, find out which version you have by select the Home tab. The version will be on the bottom.
2. Open the file you downloaded (QuickBooksToolHub.exe).
3. Follow the on-screen steps to install and agree to the terms and conditions, then double-click the icon on your Windows desktop to open the tool hub.

Once done, follow Step 2: Run Quick Fix my File outlined in this help article: Fix company file and network issues with QuickBooks File Doctor.

You can also visit this link to learn more about saving the settings of your report for your future use: Create, access, and modify memorized reports.

If you have additional questions, feel free to post again. Take care!