Home Forums OpenSync Update Failed

This topic contains 2 replies, has 2 voices, and was last updated by  Nanto Himawan 2 years, 6 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
  • #64158

    Nanto Himawan


    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 Rosales

    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 Himawan

    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.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.