We have an Excel migration job to append or update purchase price list records.
The method we use is PURCHASE_QUANTITY_PRICE_API, with New and Modify checked.
In this method there are columns for a rental indicator, with flags MI (Mandatory Insert)
When we leave the Default Value for these fields empty, the job runs into an error because the column is mandatory.
When we put a default value like above the inserts run fine, but on modifying an existing record the response is: “Field [RENTAL] in Purchase Quantity Price may not be modified.”
How can we work around this?
Is it for example possible to check the existance of the record in the SOURCE_COLUMN?
