Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
NSC | How to Update Journal Entry Memo Through CSV
Scenario:
The user would like to know how to add and / or update Notes in 20 Journal Entries through CSV
Solution:
Create a CSV file with the following columns:
- Note: Memo
- Note: Transaction
- Internal ID of the Journal
To Add User Notes:
- Setup > Import/Export > Import CSV Records
- Import Type = Communications
- Record Type = Notes
- Select your file
- Data Handling = Add
- Map the following (Note = Note : Memo (Req)Internal ID (Journal Entry) = Note: Transaction-Click pencil Icon beside Internal ID-Choose Reference Type = Internal ID)
- Click Done
- Save and Run Import.
To Update User Notes:
- Setup > Import/Export > Import CSV Records
- Import Type = Communications
Tagged:
0