Update Failed

[Nanto HimawanParticipant]

Hi,

I am trying to use the update feature to update the price of an item inventory. I created a task to do the update, and I set the status field in the table to UPDATE. When I ran the task, I got an error that asks me to look at the error table

Here’s what the error table shows:
Error_Num: -2147220502
Error_Table: iteminventory
Error_Field: assignvalues
IDKey: 80000004-1331348966
Error_Desc: Field cannot be modified
TIME_DATE: 2018-09-01 15:23:42

[Yudel RosalesKeymaster]

Make sure that you are putting all the require fields.
Required fields:

AssetAccount ListID or FullName (Required)
CogsAccount ListID or FullName (Required)
IncomeAccountRef ListID or FullName (Required)
ListID (Required)
Name (Required)

–First Time Add Only
Income Account ListID or FullName (Required)

[Nanto HimawanParticipant]

Thank you for the response. I just checked, the 8 fields that you mentioned are all filled. Both ListID and FullName of the fields you mentioned are filled. They are actually a refresh table from QuickBooks, so they should have all the required fields filled. I just modified one field, the price, and try to update using opensynch.

[Author]

Posts