LedgerWire

Invoice · Query

simulated in sandbox

InvoiceQuery

Invoices record a sale on credit. QuickBooks posts them to Accounts Receivable and tracks BalanceRemaining until received payments are applied.

qbXML request

InvoiceQueryRq
<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="13.0"?>
<QBXML>
  <QBXMLMsgsRq onError="stopOnError">
    <InvoiceQueryRq requestID="1">
      <MaxReturned>10</MaxReturned>
      <ModifiedDateRangeFilter>
        <FromModifiedDate>2026-10-01T00:00:00</FromModifiedDate>
      </ModifiedDateRangeFilter>
      <IncludeLineItems>true</IncludeLineItems>
    </InvoiceQueryRq>
  </QBXMLMsgsRq>
</QBXML>

JSON equivalent

GET /v1/invoices?limit=10&updatedAfter=2026-10-01
GET /v1/invoices?limit=10&updatedAfter=2026-10-01
curl
curl "https://ledgerwire.vibiz.app/v1/invoices?limit=10&updatedAfter=2026-10-01" \
  -H "Authorization: Bearer $LEDGERWIRE_KEY"
Sends this exact qbXML to the shared demo sandbox (simulated sample data).

qbXML response (from the sandbox seed data)

InvoiceQueryRs
<?xml version="1.0" ?>
<QBXML>
  <QBXMLMsgsRs>
    <InvoiceQueryRs requestID="1" statusCode="0" statusSeverity="Info" statusMessage="Status OK">
      <InvoiceRet>
        <TxnID>101-1780875062</TxnID>
        <TimeCreated>2026-06-07T23:31:02+00:00</TimeCreated>
        <TimeModified>2026-06-19T23:31:02+00:00</TimeModified>
        <EditSequence>1781911862</EditSequence>
        <TxnNumber>1000</TxnNumber>
        <CustomerRef>
          <ListID>8000006F-1794871862</ListID>
          <FullName>Clearwater Facilities Group</FullName>
        </CustomerRef>
        <ARAccountRef>
          <ListID>80000003-1760311862</ListID>
          <FullName>Accounts Receivable</FullName>
        </ARAccountRef>
        <TemplateRef>
          <FullName>Intuit Service Invoice</FullName>
        </TemplateRef>
        <TxnDate>2026-06-07</TxnDate>
        <RefNumber>1001</RefNumber>
        <BillAddress>
          <Addr1>Clearwater Facilities Group</Addr1>
          <Addr2>8932 River Rd</Addr2>
          <City>Madison</City>
          <State>WI</State>
          <PostalCode>53703</PostalCode>
          <Country>US</Country>
        </BillAddress>
        <IsPending>false</IsPending>
        <TermsRef>
          <FullName>Net 15</FullName>
        </TermsRef>
        <DueDate>2026-07-07</DueDate>
        <IsToBePrinted>false</IsToBePrinted>
        <IsToBeEmailed>false</IsToBeEmailed>
        <Subtotal>24.75</Subtotal>
        <SalesTaxPercentage>0</SalesTaxPercentage>
        <SalesTaxTotal>0.00</SalesTaxTotal>
        <AppliedAmount>-24.75</AppliedAmount>
        <BalanceRemaining>0.00</BalanceRemaining>
        <IsPaid>true</IsPaid>
        <InvoiceLineRet>
          <TxnLineID>100-1780875062</TxnLineID>
          <ItemRef>
            <ListID>8000002E-1794871862</ListID>
            <FullName>PVC Elbow 2in</FullName>
          </ItemRef>
          <Desc>PVC 90 degree elbow, 2 in</Desc>
          <Quantity>9</Quantity>
          <Rate>2.75</Rate>
          <Amount>24.75</Amount>
        </InvoiceLineRet>
      </InvoiceRet>
    </InvoiceQueryRs>
  </QBXMLMsgsRs>
</QBXML>

FAQ

How do I page through InvoiceQuery results?

In qbXML, add iterator="Start" to InvoiceQueryRq with MaxReturned, then send iterator="Continue" with the iteratorID until iteratorRemainingCount is 0. With LedgerWire, GET /v1/invoices?limit=100 and follow nextCursor.

How do I fetch only invoices changed since my last sync?

Use ModifiedDateRangeFilter/FromModifiedDate inside InvoiceQueryRq, or updatedAfter on the REST endpoint.

Why does InvoiceQuery return statusCode 1?

Status 1 is informational: "A query request did not find a matching object in QuickBooks". The request was valid and nothing matched the filters. LedgerWire returns an empty data array for it.

Sandbox fidelity

The LedgerWire sandbox simulates InvoiceQuery with QuickBooks rules: required fields, element names, refs that must exist (3140), unique names (3100), field lengths (3070) and EditSequence locking (3200). Tax calculation, custom fields and preferences are not simulated.

More Invoice messages

Other Query messages

Skip the XML: call GET /v1/invoices with JSON.

Get a free sandbox key