We started using the Enable Item Line Shipping checkbox on sales order over the past year. It has been a tremendous improvement for our sales teams since they can now place an order on the fly with multiple shipping methods or ship to addresses. However, these multi-ship orders have caused a problem when billing.
We bill from the Item Fulfillment so we only want to invoice the customer what has actually been shipped out; the item(s) and actual shipping cost for that item. When we bill sales orders that use item line shipping, it will bill the item(s) that have been shipped and the actual shipping cost, but it also bills the remaining shipping cost as calculated from the sales order. This is not how we want or expect it to function.
For example, we have a sales order that uses 2 different shipping methods:
Item A: UPS Ground - est. shipping cost $10
Item B: UPS 2nd Day Air - est. shipping cost $25
Let's say we shipped out Item B and it's ready to be billed and we have not shipped out Item A yet. When we click bill from the item fulfillment of Item B, it will list item B and the actual shipping cost of $20 (instead of the sales order estimate of $25). But then, it will also add on Item A's estimated shipping cost of $10 from the sales order.
If anyone has any insight on how to change this behavior or have a workaround, other than not using Enable Item Line Shipping, please share! I'm lost on how to "fix" the native NetSuite behavior.