PaidStaus codes under InvoiceQuery

[trebor97]

Anyone know the PaidStatus codes under InvoiceQuery? I do not see any reference on the OSR.  Or better yet, when I click on PaidStatus it jus flashes in my browser. 

I want to pull all invoices that are "open", not fully paid or paid at all. 

Thanks

I found it......

PaidOnly

NotPaidOnly

 

From the QBSDK Reference:

The PaidStatus filter searches for invoices or bills on the basis of whether their balances are paid or not. If you specify PaidOnly for this filter, QuickBooks returns only those bills or invoices that are completely paid (that is, closed). If you specify NotPaidOnly, QuickBooks returns those bills or invoices that have a non-zero balance. (You will probably not bother specifying All for this filter, since that is the equivalent of not specifying the filter.)

[PCIPal]

Hi trebor07,

You are correct. The "PaidStatus" element for the InvoiceQuery request accepts the following values: "All", "PaidOnly", or "NotPaidOnly". By default, "All" is provided. So if you wanted to query for unpaid or partially-paid invoices, you'd specify a "PaidStatus" of "NotPaidOnly".

Let us know if there's something else you have questions about!

Thanks!