XML Error while Modifying Sales Order in QB Desktop

141 Views Asked by At

I am trying to modify a sales order created in QB Desktop. But it gives me XML error

0x80040400: QuickBooks found an error when parsing the provided XML text stream

Here is my XML Request

<?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="11.0"?>
<QBXML>
  <QBXMLMsgsRq onError="stopOnError">
    <SalesOrderModRq>
      <SalesOrderMod>
        <TxnID>1-1672737866</TxnID>
        <EditSequence>1672737866</EditSequence>
        <CustomerRef>
          <FullName>156004 Loose Bee Ln</FullName>
        </CustomerRef>
        <TxnDate>2023-01-03</TxnDate>
        <BillAddress>
          <Addr1>123</Addr1>
          <Addr2></Addr2>
          <City>Gity</City>
          <State>Ritham</State>
          <PostalCode>5555</PostalCode>
          <Country>Universe</Country>
        </BillAddress>
        <PONumber>4444444</PONumber>
        <Other>Southshore Bay</Other>
        <SalesOrderLineMod>
         <TxnID>3-1672737866</TxnID
          <ItemRef>
            <FullName>Single Family - One Story</FullName>
          </ItemRef>
          <Desc>Foundation</Desc>
          <Quantity>1</Quantity>
          <Amount>85.00</Amount>
          <DataExtMod>
            <OwnerID>0</OwnerID>
            <DataExtName>Lot</DataExtName>
            <DataExtValue>8/98</DataExtValue>
          </DataExtMod>
          <DataExtMod>
            <OwnerID>0</OwnerID>
            <DataExtName>Address</DataExtName>
            <DataExtValue>156004 Loose Bee Ln</DataExtValue>
          </DataExtMod>
        </SalesOrderLineMod>
      </SalesOrderMod>
    </SalesOrderModRq>
  </QBXMLMsgsRq>
</QBXML>
1

There are 1 best solutions below

4
On BEST ANSWER

Whenever you get this error:

0x80040400: QuickBooks found an error when parsing the provided XML text stream

It means you used an XML tag incorrectly, an unsupported XML tag, or an XML tag in the wrong order.

You can refer to the documentation to see what supported tags, their order, etc. are:

At least at first glance, I can see that TxnID inside SalesOrderLineMod is not correct (maybe you meant TxnLineID instead?):

      <SalesOrderLineMod>
         <TxnID>3-1672737866</TxnID

It may also be worth double-checking those DataExtMod tags too.