Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

QBXML for Adding Invoice to Quickbooks Desktop via the web connector fails

I having a problem with the format of my XML file for adding an invoice to Quickbooks Desktop Enterprise US version, my qbxml request is as follows;

<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="13.0"?>
<QBXML>
  <QBXMLMsgsRq onError="stopOnError">
    <InvoiceAddRq>
      <InvoiceAdd>
        <CustomerRef>
          <FullName>XXXXXXXXX</FullName>
        </CustomerRef>
        <ClassRef>
          <FullName>XXXXXXX</FullName>
        </ClassRef>
        <ARAccountRef>
          <FullName>XXXXXXXXXX</FullName>
        </ARAccountRef>
        <TemplateRef>
          <FullName>Standard invoice</FullName>
        </TemplateRef>
        <TxnDate/>
        <RefNumber>83434</RefNumber>
        <BillAddress>
          <Addr1>4xxxxxx</Addr1>
          <City>xxxxxxxx</City>
          <State>XX</State>
          <PostalCode>0000</PostalCode>
        </BillAddress>
        <IsPending>1</IsPending>
        <IsFinanceCharge>0</IsFinanceCharge>
        <PONumber>12345</PONumber>
        <TermsRef>
          <FullName>Net 30</FullName>
        </TermsRef>
        <DueDate/>
        <SalesRepRef/>
        <FOB/>
        <ShipDate/>
        <ShipMethodRef/>
        <ItemSalesTaxRef/>
        <Memo/>
        <CustomerMsgRef/>
        <IsToBePrinted>0</IsToBePrinted>
        <IsToBeEmailed>0</IsToBeEmailed>
        <IsTaxIncluded>0</IsTaxIncluded>
        <CustomerSalesTaxCodeRef/>
        <Other/>
        <ExchangeRate>1</ExchangeRate>
        <SetCredit>
          <CreditTxnID>1</CreditTxnID>
          <AppliedAmount>0</AppliedAmount>
          <Override>1</Override>
        </SetCredit>
        <InvoiceLineAdd>
          <itemRef>
            <FullName>S-check UT</FullName>
          </itemRef>
          <Desc>Interpreter</Desc>
          <Quantity>1</Quantity>
          <UnitOfMeasure/>
          <Rate>10</Rate>
          <RatePercent>100</RatePercent>
          <PriceLevelRef/>
          <ClassRef/>
          <Amount>10</Amount>
          <OptionForPriceRuleConflict>0</OptionForPriceRuleConflict>
          <InventorySiteRef/>
          <InventorySiteLocationRef/>
          <SerialNumber/>
          <LotNumber/>
          <ServiceDate/>
          <SalesTaxCodeRef/>
          <OverrideItemAccountRef/>
          <Other1/>
          <Other2/>
          <LinkToTxn>
            <TxnID>0</TxnID>
            <TxnLineID>0</TxnLineID>
          </LinkToTxn>
          <DataExt>
            <OwnerID>3caa4f6f-fcb3-4767-99e6-0ba5dfd34e8f</OwnerID>
            <DataExtName>Sample</DataExtName>
            <DataExtValue>Sample</DataExtValue>
          </DataExt>
        </InvoiceLineAdd>
      </InvoiceAdd>
    </InvoiceAddRq>
  </QBXMLMsgsRq>
</QBXML>

When i check this xml request using the qbxml validator i'm getting the following error message even though i have supplied all the required fields as outlined in the OSR tool;


Line: 53
    LinePos: 20
    Src Text: <itemRef>
    Reason: Element content is invalid according to the DTD/Schema.
    Expecting: ItemRef, Desc, Quantity, UnitOfMeasure, Rate, RatePercent, PriceLevelRef, ClassRef, 
    Amount, TaxAmount, OptionForPriceRuleCon....

When i run the quickbooks webconnector, i get the following error message;

Message: QuickBooks found an error when parsing the provided XML text stream.

I need some help checking if i'm missing something in the format of my InvoiceAdd qbXML file.

1 Comment
QuickBooks Team

QBXML for Adding Invoice to Quickbooks Desktop via the web connector fails

I'm here to make sure you'll get answers to the error when adding invoices via Web Connector, dumetro.

 

I recommend seeking help from another forum called Intuit Developers Forum. It's a place where different developers and coders help each other with programming, integration, and app development.

 

They can check what needs to be corrected and help provide the correct source code so you add invoices to QuickBooks.

 

Here's how to contact them:

 

  1. Go to this link: https://developer.intuit.com/.
  2. Scroll down, then click Contact us under the Intuit column.
  3. Select the subscription you need help with.
    contactIntuitdeveloper.PNG
  4. Click Ask A Question.
    contactIntuitdeveloper1.PNG
  5. Sign in to your account, then follow on-screen instructions.

Let me know how the contact goes or if you need anything else about adding invoices. I'll be around to help ensure you're able to record your transactions in QuickBooks.

Need to get in touch?

Contact us