Our Quickbooks 2008 Invoice Detail file is huge because we create invoices from estimates. The estimate includes all possible items, we put quantities on the valid line for this invoice but invoice contains many items with 0 quantities.

I would like to write a program that marks those 0 quantity invoice detail line for deletion, and hopefully be able to remove them with file cleanup option. 

Is there a field in the item detail line item file that can mark the line as deleted ?

Thanks, Robert

Run this query first to check if these are the correct Invoice Lines (items) to delete:

Select * from InvoiceLine where InvoiceLIneType = 'Item' and InvoiceLineQuantity = 0

And if that's what you want, backup your company file and run:

Delete from InvoiceLine where InvoiceLIneType = 'Item' and InvoiceLineQuantity = 0

and they will all disappear! After that run:

sp_optimizefullsync InvoiceLine

to fully re-sync your optimized InvoiceLine table with all the new deleted invoice lines!