June 15, 20187 yr 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.)
June 15, 20187 yr 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!
Create an account or sign in to comment