B1i Sales Order Subdeletion Returns DI Error: (-1029) Field cannot be updated (ODBC -1029)

[Former Member]

Hi Specialists,

When i m trying to update sales order through B1 Object getting DI Error: (-1029) Field cannot be updated.

DI method is UpdateDocWithSubDeletion. Dont know which field i missed in object template please help me out.

[edy_simon]

Hi Atul,

The error message is indicating the xml contains field that can not be updated.

Can you post the final xml content ?

Regards

Edy

[Former Member]

Hi Edy,

Here is my final payload :-

<Payload Role="X" id="atom2">

  <Documents xmlns="">

    <row>

      <DocEntry>50</DocEntry>

      <CardCode>C8139</CardCode>

      <DocDate>20160414</DocDate>

      <DocDueDate>20160414</DocDueDate>

      <SalesPersonCode>9</SalesPersonCode>

      <NumAtCard/>

      <Comments>Test</Comments>

      <U_PAYSTAT>B</U_PAYSTAT>

      <U_PYMMOD/>

      <U_PYMRMK/>

      <U_OrderID>26022</U_OrderID>

    </row>

  </Documents>

  <Document_Lines xmlns="">

    <row>

      <DocEntry>50</DocEntry>

      <ItemCode>PKG0005</ItemCode>

      <Quantity>1</Quantity>

      <InventoryQuantity>1</InventoryQuantity>

      <Factor1>1.000000</Factor1>

      <Factor2>1.000000</Factor2>

      <Factor3>1.000000</Factor3>

      <Factor4>1.000000</Factor4>

      <UnitPrice>0</UnitPrice>

      <ShipDate>20160414</ShipDate>

      <TaxCode>Zero</TaxCode>

      <U_Rmrks>5</U_Rmrks>

      <U_IGrPrice>1500</U_IGrPrice>

      <U_PKGSDT/>

      <U_PKGEDT/>

      <U_ORDTYP>N</U_ORDTYP>

      <U_DiscPercnt>0</U_DiscPercnt>

      <FreeText/>

      <U_PckgQty>1</U_PckgQty>

      <CostingCode3/>

      <CostingCode5>MU</CostingCode5>

      <U_SubOrderID>21233</U_SubOrderID>

    </row>

    <row>

      <DocEntry>50</DocEntry>

      <ItemCode>FG0009</ItemCode>

      <Quantity>1</Quantity>

      <InventoryQuantity>1</InventoryQuantity>

      <Factor1>1.000000</Factor1>

      <Factor2>1.000000</Factor2>

      <Factor3>1.000000</Factor3>

      <Factor4>1.000000</Factor4>

      <UnitPrice>238.0952380952381</UnitPrice>

      <ShipDate>20160414</ShipDate>

      <TaxCode>VAT@5</TaxCode>

      <U_Rmrks>PKG0005</U_Rmrks>

      <U_IGrPrice>250</U_IGrPrice>

      <U_PKGSDT/>

      <U_PKGEDT/>

      <U_ORDTYP>N</U_ORDTYP>

      <U_DiscPercnt>0</U_DiscPercnt>

      <FreeText/>

      <U_PckgQty>1</U_PckgQty>

      <CostingCode3/>

      <CostingCode5>MU</CostingCode5>

      <U_SubOrderID>21233</U_SubOrderID>

    </row>

  </Document_Lines>

</Payload>

Please let me know which field cannot be updated or missed anything in template.

Regards,

Atul

[edy_simon]

Hi Atul,

I am guessing it is the InventoryQuantity field.

Can you try to remove this field ?

The rest looks ok,

Regards

Edy

[Former Member]

Hi Edy,

Did that but no luck,any other field that needs to be removed.

However I tried with few required document header and items field but still getting same error.

Please let me know this is the template issue or any other issue.

Regards,

Atul

[edy_simon]

Hi Atul,

I was wondering why in your final payload you don't have the object type information ?

Regards

Edy

[former_member192773]

Hello Atul,

Think you also need linenum in de lines as a key.

Try to update only the itemcode (and no header except DocEntry) and add step-by-step the other values.
Also remove Docentry in the lines.

This is the best way to solve these issues.

Regards Teun

[Former Member]

Hi Teun,

tried to update given fields with payload as below :-

<AddSalesOrder xmlns="http://www.w3.org/UPSO">\r\n

<DocEntry>50</DocEntry>\r\n

<Document_Lines>\r\n

<row>\r\n

<ItemCode>PKG0005</ItemCode>\r\n

<LineNum>0</LineNum>\r\n

</row>\r\n

<row>\r\n

<ItemCode>FG0009</ItemCode>\r\n

<LineNum>1</LineNum>\r\n

</row>\r\n

</Document_Lines>\r\n

</AddSalesOrder>

Getting same error as field cannot be updated (ODBC -1029).

Please let me know if any workaround to handle this and get document updated.

Regards,

Atul G.

[former_member185682]

Hi Atul,

There is a specific board for B1i. Maybe you can get answers more fast.

---

Best regards,

Diego Lother