Hi everyone,
I'm trying to perform a CSV Update to modify existing transaction line fields, such as Department and Class, without changing any other line information.
Based on the NetSuite Help documentation for Line Item Updates on Transactions Imports (Suite Answer ID#37258), NetSuite recommends using Items : Order Line (Line/Order Line) as the key field when updating existing transaction lines. It also mentions that using Item as the key is not recommended because duplicate items may exist on the same transaction.
However, I'm facing a problem.
The documentation suggests using Order Line, but in my Saved Search Transaction, I cannot find this value on the transaction itself. Since the Order Line ID is not visible, I don't know how to prepare the CSV file for updating existing lines.
My questions are:
- What is the recommended way to obtain the Order Line value for existing transaction lines?
- Is there a standard Saved Search that can expose this field, or does it require a specific configuration?
- If Order Line is unavailable, what is the correct approach to update line-level fields such as Department and Class using CSV Import?
- Is using Item as the key the only alternative, and if so, how do you avoid issues when the same item appears multiple times on a single transaction?
My objective is simply to update line-level classification fields (Department/Class) on existing transactions without adding new lines or modifying quantities.
I'd appreciate any best practices or examples from anyone who has successfully performed this type of CSV update.
Thank you!