ANS-0456 · SALES ORDER PROCESSING
How to Update the Billing Address on a NetSuite Invoice Using Scripting?
NetSuite workflows cannot directly modify invoice billing addresses, requiring a script for updates due to the address fields being sublist records.
Short answer
NetSuite workflows cannot directly update invoice billing addresses because these fields are sublist records and are not exposed to workflow actions. A NetSuite script is required to programmatically modify the billing address on an invoice, especially when the invoice is generated from a Sales Order with an outdated address.
Scenario
When an invoice is created from a Sales Order, the billing address is typically inherited from the Sales Order at the time of its creation. If the customer's billing address changes after the Sales Order is created but before the invoice is generated, the invoice may display an outdated address. Users often seek to update this billing address on the invoice.
Solution
Updating the billing address on a NetSuite invoice requires a script rather than a workflow. This is because the address fields are considered sublist records, which are not directly accessible or modifiable through standard workflow actions. The billing address override field is also not available in workflow. When an invoice is generated from a Sales Order, the transform process merely feeds in the data from the Sales Order into the relevant fields. If the Sales Order contains an outdated billing address, a script can be used to programmatically update the invoice's billing address to the correct information.
Expert NetSuite Support
Need help with this NetSuite issue?
Sales Order Processing consulting and configuration support