cancel
Showing results for 
Search instead for 
Did you mean: 
dumetro
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 1
MaryLandT
Moderator

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.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us