O'Reilly logo

NetSuite ERP for Administrators by Anthony Bickof

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Transaction import

I'm going to focus on an update as the transaction import. Let's assume we need to change a specific item that appears on sales orders, such as Product A rev. 1 needs to replaced by Product 1 rev. 2 on all open sales orders.  

Updates are best done by starting with the data that is already in the system. Create a saved search to identify the data you are looking to update with the plan to export the data, manipulate it in Excel, and then re-upload the changes. The internal ID of the transaction will be used to ensure that the correct record is being updated.

There are two options to update the line level of a transaction. The first option is to overwrite the entire line level with the information in the source file. This ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required