A DataExtMod sets a custom field's first value on a sales order that never had one; no DataExtAdd is needed

Observed 2026-10-10 on QuickBooks Enterprise Solutions 24.0 (US), reporting qbXML 17.0.

A DataExtMod writes a custom field's first value on a sales order that never had one. No DataExtAdd is needed. Intuit's DataExtMod reference opens by saying the request can only be used once a definition has been added to the target object, which reads as if a value had to exist already. On a custom field (OwnerID 0) defined on Customer, which reaches sales orders, QuickBooks accepted a DataExtMod on a new sales order with no value.

The sales order had just been added, and its answer carried no DataExtRet. No DataExtAdd was sent:

qbXML
<DataExtModRq>
  <DataExtMod>
    <OwnerID>0</OwnerID>
    <DataExtName>SHIP STATUS</DataExtName>
    <TxnDataExtType>SalesOrder</TxnDataExtType>
    <TxnID>4F84-1791594831</TxnID>
    <DataExtValue>Ordered</DataExtValue>
  </DataExtMod>
</DataExtModRq>

QuickBooks answered with the same DataExtRet a DataExtAdd answers:

qbXML
<DataExtModRs statusCode="0" statusSeverity="Info" statusMessage="Status OK">
<DataExtRet>
<OwnerID>0</OwnerID>
<DataExtName>SHIP STATUS</DataExtName>
<DataExtType>STR255TYPE</DataExtType>
<DataExtValue>Ordered</DataExtValue>
</DataExtRet>
</DataExtModRs>

A later SalesOrderQueryRq with <OwnerID>0</OwnerID> read the value back. The write also moved the sales order's TimeModified and EditSequence, as Intuit says both requests do.

What to do

To set a custom field on a sales order, send DataExtMod whether or not the order already has a value. There is no need to check for a value first and choose between DataExtAdd and DataExtMod. After the write, use the sales order's new EditSequence for any later SalesOrderMod.

Not observed

  • Objects other than sales orders, such as customers, items, other sales forms or transaction lines.
  • Private data extensions with a GUID OwnerID, and types other than STR255TYPE.
  • What DataExtMod answers when the definition does not reach the object or does not exist.

QuBe Sync is a JSON API for QuickBooks Desktop that is built on what these findings show.