Unused or 0 quantity fields in memorized transactions

[Ryan Riz]

Hello all,

My mother owns a bookkeeping business and hired me 18 months ago. I am a die-hard for doing things the most efficient way possible and I have come across a problem.

I have entered thousands of invoices and bills for a client. This client has a generic invoice that they use for all customers. All products are listed with a price next to it, and a quantity field for the user to fill in. I created an identical memorized transaction for said invoice in quickbooks and have come across a problem:

I did not delete the fields that were unused in the invoices.

This has become a big problem when pulling up certain reports that display all of these 0's. My client offers over 30 products and most customers don't purchase more than 5 on any given invoice. So the reports are ridiculous. I have three questions here:

Is there a way to remove these 0's from reports?

Is there a way to remove all 0 fields in bulk? (on the invoices themselves, not just the reports)

if not,

As previously stated, I enter the invoices by simply recording the transaction after filling in the necessary quantities. I am now under the impression that I should manually delete (ctrl+delete, of course) all of the 0 quantity fields. This adds a fairly significant amount of time to the task, and I'm wondering, is there is a more efficient way to go about this?

Thank you so much to any of you who reply. Even if it is to tell me that there is no better way. I look forward to being an active member on this forum and helping others with their problems as well.

[Joe Williams]

There is a preference under Customer Preference to not Print zero amount items.