Hello Community! I hope you are all doing well. I'm currently trying to do a little batch import manipulation but I've encounter a pinch-point. I'm stuck on this and I hope someone could bring some insight. I'll spare you the why I have to do this because It would take a lot of time to explain. Long story Short, I would like to be able to UPDATE a batch of invoices in order to be able to modify their TRANID (Invoice#) and Date. It definitely should be possible since the Import Template for Open A/R Contains EXTERNALID and TRANID. Now here is the thing; First I have to Export the Invoices I want to modify; open get the list, and based on the ExternalID I would just modify TRANID and import-update those Invoices. However when I choose to do an Export from NetSuite, all the option that It offers is FULL EXPORT and the file with the transaction does not contain any ExternalID. Why can you Export the Records in the same format than the Import process? Is there a way around that? Thank you on advance for bringing some light on that Topic if you can. Best-

External ID is not set by default, it is typically set when transactions come in via integration or csv import from an external source. You should use the Internal ID instead. This is an autonumbering field that is not editable thus is the safest data key to use to update transactions.

Thanks. Where do you find the InternatID of the INVOICE records? I don't have those.

Internal ID or just ID. It will be a number. Are you exporting with a saved search? You will need to add it as a column.

I understand! I never thought the list of a saved searched could be edited to act as an export file with additional Fields. This is really good, the internalID allow me to update the tranID and the date as I wanted. Very flexible. I appreciate your help!