How do i import attachments into Netsuite and Assign them to transactions . I have 1000+ attachments which needs to be imported .
Hi Friends ,
I am doing Data Migration into Netsuite and one of the requirements is to migrate attachments and assign them to Invoices .. I am able to do that manually from the Netsuite application , but am looking for a solution where i can import them into Netsuite . Could Gurus here help me in this regards .. Thanks in Advance
You’re going to struggle with this requirement without scripting, and even then it might still be challenging as there aren’t fields available to files.
If you name the files something that ties them to the invoice – you could zip them, use the mass unzip upload process and write a script for attaching them to the appropriate invoices. I’ve done something similar in SS1.0 some time ago for attaching files to Customers.
Edit* Also* have you considered the storage ramifications of performing these uploads? You may run into hefty storage fees doing this.
Thanks a lot Kevin for the reply , What if i can load all the attachments into file cabinet .. I will name the file with a prefix of invoice number so that i can link the attachments to the invoices . Extract internal id’s of the attachments from file cabinet and update these id’s against the transactions .. does this work ? Please let me know if this approach makes sense
That’s how we did it essentially
I’ve basically done the same thing for adding images to Items