NetSuite: WorldShop/OZLink overwriting NetSuite Shipping Price

Question

I've got an online store powered by Netsuite where I am charging customers a fixed rate for shipping. So we take an order, and we tell the customer the shipping is $10. (for example)

We use WorldShip to actually do our shipping, and so we then weigh the package, enter a weight, etc.

The problem is, whatever our shipping costs actually are from WorldShip are overwriting the amount we promised the customer, and then when we go to charge the card it can't because we're only authorized.

What's the best approach to fixing this? When charges are created, have custom scripts that run that take the amount from the Sales Order instead of the amount from the fulfillment record? Is there a way to have WorldShip only overwrite the shipping amount on offline orders and not on online orders?

Answer 1

For this scenario, we've created a custom transaction body field on the sales order called "Shipping Charge Exception". This field holds the shipping amount that we've promised to the customer and automatically gets copied to subsequent invoices or cash sales.

Then we have a workflow on the creation of invoices and cash sales (Before Submit) that copies the value of the Shipping Charge Exception field into the Shipping Cost field on the invoice or cash sale.

The item fulfillment will still hold the actual shipping cost but the invoice or cash sale will get the amount promised to the customer.