Quickbooks - Collecting Line Items from Invoices

How To
1

I need someone to point me in the right direction. I want to be able to pull item id details from invoices.

Example: Item ID = 2 is Hourly Work in Quickbooks for us. I want to return line items from invoices where Item ID = 2 exists.

2

Hi ,
You could use the “Search for Invoices” of Make’s Quickbook’s module to search for all invoices where id is 2 by passing the appropiate query in the filter field
eg

SELECT * FROM Invoice WHERE Id = '2'

After that extract all the line items from the returned invoices.

2 Likes