Re: Filtering QBO invoice line items in Report Designer

Method_Audisho — Thu, 21 May 2015 19:01:43 GMT

Hi Brian,

The only way to verify that a line is paid it by verifying that the invoice has been paid. You can do this by creating a linked field on your InvoiceLine table that links to the BalanceRemaining field on the Invoice table.

You’ll need to create a button on one of your screens with the Generate Report action for generating your report. You can setup the filters on the action itself for only returning lines specified by the filter. You can filter for the particular item name and your linked Invoice.BalanceRemaining field equals 0 like so.

Give this a shot and post back if you have any more questions. I hope this helps.

-Audisho

Filtering QBO invoice line items in Report Designer

brian — Thu, 21 May 2015 15:28:06 GMT

I have another question about report designer. I would like to create a report to print certain paid invoice lines and group by customer. I can get to the invoice lines but I don't know how to filter just the invoice paid items with a certain word in the item name. Then, I can't see how to call up that report in the CRM under the Invoice tab since it's based on the Invoice table. Can I create a new tab and call it up there?

Method Beta General Q & A

Re: Filtering QBO invoice line items in Report Designer

Filtering QBO invoice line items in Report Designer