How to get InvoiceLine from InvoiceQuery in QBXML

Question

When I add an Invoice to Quickbooks with QBXML I use <InvoiceLineAdd> to add invoice lines. How do I get the invoice lines for an invoice when I am doing InvoiceQuery?

score 1 · Accepted Answer · answered Nov 25 '21 at 02:20

1

The IncludeLineItems tag is what you're looking for. For example:

<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="13.0"?>
<QBXML>
  <QBXMLMsgsRq onError="stopOnError">
    <InvoiceQueryRq>

      <RefNumber>ABC123</RefNumber>

      <IncludeLineItems>true</IncludeLineItems>
      <IncludeLinkedTxns>true</IncludeLinkedTxns>
    
    </InvoiceQueryRq>
  </QBXMLMsgsRq>
</QBXML>

answered Nov 25 '21 at 02:20

Keith Palmer Jr.

27,666
16
68
105

DUDE! You just rocked my world! You wouldn't happen to know how to get bill items with the bill query too would you? – Tyler Nov 29 '21 at 15:00
And thanks for including txns also! I'm trying to get all the info I can from invoices and bills – Tyler Nov 29 '21 at 15:01
1

@Tyler That same `` tags works for getting bill line items in a `` as well. – Keith Palmer Jr. Nov 30 '21 at 18:33

How to get InvoiceLine from InvoiceQuery in QBXML

1 Answers1