This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi everyone. How does NetSuite pull the relationship between an invoice and the correct item fulfillment record for a sales order with multiple shipments? I'm looking to write a script and trying to understand the root of this.

The issue that we're running into is where we have a shipping cost set on a sales order with multiple shipments. The cost is being transferred over to all of the subsequent invoices instead of just to the invoice associated with that item fulfillment record.

I'm not sure the best way to target this but I was thinking to write a script to run on before submit of the invoice - to be activated when bulk invoicning.

As far as I know invoices aren't actually tied to fulfillment at all.  They are both just tied to the sales order.

That's what it seems like. Any ideas how I could transfer the correct shipping cost from the item fulfillment to the invoice?

only available on load of a record, not in search unfortunately