I am trying to update order lines using the Item number. (The source is a spreadsheet that does not contain the original line number value).

I have mapped the Item Number in the detail line, but the result is that IMAN always inserts new lines to the Order rather than updating an existing line on match of the Item Number.

In the drop down list of Sage 300 Fields, Line Match Method is not a choice in the list of fields.

My Sage 300 Connector Update Operation is set to “Insert/Update”