Shortest tip ever.
If you ever extract data from NetSuite, and hand it off to someone with the intention that it might get manipulated and imported back in, please remember to export the Internal ID of the record!
End tip.
It doesn’t matter what the record is. It could be contacts, companies, transactions or items. It is possible to work without the internal ID but it’s a lot simpler to use it. Most records have 2 or 3 fields the import utility can key off of but the internal id is the one that gives you the most confidence when messing with data.
You don’t need to worry yourself with doing this in normal searches, just when you want to re-import your data later. And if you’re unsure, include it. It’s also useful if you want to compare data exports later.
Related posts tagged with: Best Practise, Exporting