Looking to see if anyone has successfully integrated D3 with UPS WorldShip using ODBC -

When voiding a shipment/package in WorldShip, I receive a duplicate key error because it appears that it's trying to perform an insert instead of an update statement.

On void in WorldShip:

Execute 0F99B418( INSERT INTO ups_packages ( ...., voided, id, shipment_id )  VALUES ( ..., 'Y', 'PACKAGE ID', 'UPS SHIPMENT ID' ) )
Execute 0F99B418( INSERT INTO ups_shipments ( ...., voided, id )  VALUES ( ..., 'Y', 'UPS SHIPMENT ID' ) )

Given that these records already exist, and we're just trying to set the voided flag, it should be an update statement:

update ups_packages set voided = 'Y' where shipment_id = 'UPS SHIPMENT ID'
update ups_shipments set voided = 'Y' where id = 'UPS SHIPMENT ID'

Everything else seems to work.

Did I miss mapping something in WorldShip?  Is this a known issue?  Any ideas on how to work around this?

Appreciate any help!

------------------------------
Jeremy Lockwood
Awesome
ASE Supply Inc
Portland OR US
------------------------------