cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Community Contributor *
Solved

Remove zero rows from A/R Aging Summary

I wish for my A/R Aging Summary to exclude zero rows.  Previous posts have indicated that these are due to payments and invoices that were not linked, but this is not the case here -- all of the invoices in question are showing as paid and they were linked to the payments at the time that the payments were entered (I have Auto-Apply turned on as well.)  Other prior responses have said that the report could be filtered using Amount > 0 but that has not worked for me either.  I could use the Except Zero Amounts feature on the Fonts tab, but that only removes the zeros, not the rows.  And the Advanced button on the Display tab does not include an option for excluding zero rows.  Does anyone have any other options for clearing these rows off of the A/R Aging report?  Thanks in advance for any help!

Best answer 01-26-2019 06:20 AM

Accepted Solutions
QuickBooks Team

Re: Remove zero rows from A/R Aging Summary

Hello there, FMPOA.

 

Thanks for doing the troubleshooting step @qbteachmt suggested. Running the verify and rebuild utilities help resolves data integrity issues.

 

In your case, since there are no errors found, you can try to repair QuickBooks. Repairing the software fixes program-related issues.

 

Before doing so, create a backup copy of your company file. This way, we have a copy of your data in case it will be messed up.

 

Then, here's how to repair QuickBooks:

  1. Click the Windows/Start icon on your computer.
  2. Choose Programs and Features, then look for Control Panel.
  3. Choose QuickBooks, then click Uninstall/Change.
  4. Click Continue, then Next.
  5. Choose Repair, then Next.
  6. Wait for the repair to complete, then click Finish.
  7. Restart your computer if prompted. 

Open the report again.

 

If you still have the same issues after repairing QuickBooks. I suggest contacting our technical support to have this investigated further. You can check my colleague @MaryGraceS's post on how to contact them.

 

You can always visit us if you have other concerns. We'll be happy to work with you again. 

7 Comments
Moderator

Re: Remove zero rows from A/R Aging Summary

Hello there, @FMPOA.

 

Thank you for reaching out in the Community. I'd be glad to assist you with being able to remove the zero rows on the A/R Aging Summary report.

 

 You can also add customization to remove zero rows in addition to the Except Zero Amounts feature.

 

Here's how:

  1. On the left pane, select Reports.
  2. Search for Accounts receivable aging summary.
  3. Under Show non-zero or active only, click the drop-down.
  4. Select All under Show rows
  5. Click Run report.

I've included a screenshot and some articles for additional reference: 

 

For additional help, you can also reach out to our Customer Care support. They have the tools that can help you get this resolved quickly.

 

Here's how:

  1. Go to https://help.quickbooks.intuit.com/en_US/contact.
  2. At the top right, select your QuickBooks version.
  3. Select a topic.
  4. Click on the Get Phone Number or Start a Message button.

That should point you in the right direction today.

 

Feel free to drop a comment below if you have any other questions about customizing the A/R Aging Summary report. I'll be happy to help you out. 

Established Community Backer ***

Re: Remove zero rows from A/R Aging Summary

By definition, you see a name and it has unapplied amounts, because of this: " but this is not the case here"

 

Otherwise, they would not show on the report at all. You don't Hide them. Double-click the Zero in their Total Column. Here are the Unapplied Entries.

 

They need to be Applied.

 

If you had applied them and still see the invoice has the status of Paid, then you likely need to Rebuild this file, to relink that transactions behind the scenes.

 

The Zero is Math; double-clicking their Total of zero, just like double-clicking any value, shows the underlying transactions Causing that value. There should never be a Name on AR or AP aging if the total = 0.

 

@MaryGraceS

 

Please Learn from the input here.

 

The problem is that the AR keeps Aging, and the negative AR is never seen as income or sales tax liability even though it represents Funds.

 

You need to Fix this, not Hide it.

Community Contributor *

Re: Remove zero rows from A/R Aging Summary

Thanks for the reply.  Unfortunately, I am using the Desktop Pro version, not QB Online.  The report feature that you point to does not appear to be available in the Desktop version.  Much appreciated.

Community Contributor *

Re: Remove zero rows from A/R Aging Summary

Thank you for the response.  I did click down through the zeros in the Total column.  It led me to two transactions -- one payment and one invoice -- and it clearly showed that the payment had been applied to that particular invoice.  So I backed everything up and ran the Rebuild utility.  Unfortunately, that had no effect (there were no errors picked up when I ran the utility.)  Any other suggestions would be greatly appreciated!  

QuickBooks Team

Re: Remove zero rows from A/R Aging Summary

Hello there, FMPOA.

 

Thanks for doing the troubleshooting step @qbteachmt suggested. Running the verify and rebuild utilities help resolves data integrity issues.

 

In your case, since there are no errors found, you can try to repair QuickBooks. Repairing the software fixes program-related issues.

 

Before doing so, create a backup copy of your company file. This way, we have a copy of your data in case it will be messed up.

 

Then, here's how to repair QuickBooks:

  1. Click the Windows/Start icon on your computer.
  2. Choose Programs and Features, then look for Control Panel.
  3. Choose QuickBooks, then click Uninstall/Change.
  4. Click Continue, then Next.
  5. Choose Repair, then Next.
  6. Wait for the repair to complete, then click Finish.
  7. Restart your computer if prompted. 

Open the report again.

 

If you still have the same issues after repairing QuickBooks. I suggest contacting our technical support to have this investigated further. You can check my colleague @MaryGraceS's post on how to contact them.

 

You can always visit us if you have other concerns. We'll be happy to work with you again. 

Community Contributor *

Re: Remove zero rows from A/R Aging Summary

Thank you so much -- running the repair did the trick!

Established Community Backer ***

Re: Remove zero rows from A/R Aging Summary

"The report feature that you point to does not appear to be available in the Desktop version."

 

I only answered for Desktop. Everything I explained is for Desktop.