Hi there,

Looking for a little support on a mission to update Sage 300 O/E Order Header ship-to values.

This is a scenario where IMAN creates the order, and right afterward, the data pass through a filter to check for which ship-to address we're using. If certain criteria are met, we need to update the ship-to information on the order header (OEORDH1 table in the database, not ARCSP ship-to master data).

I am surprised by several things:

1. When I attempt this, there is no "WHERE" clause when I select "Update" or "Insert/Update." I would think we'd need that so we know which order we're updating? 
2. When I tried to add the ORDNUMBER field as one of the "update" fields, I get this error:

Accpac API Error 1144 - Order Detail Attempt to change read-only field 'Optional Fields'.

3. When I remove the ORDNUMBER field from the list of fields to update, IMAN shows that the record was updated, but in fact I don't see that the order ship-to data was updated.

Sample mapping here.