[stagelightingstore]

Hello,

Can someone please provide a sample of the outline for a csv to import purchase orders ? I have tried several different ways and cannot get a successful import. The forum, help files, and suite answers have a few posts similar to my issue but I haven’t found exactly what I need. I have a list of items, and the quantity I want to order. I tried creating a p.o. manually in netsuite with just one item, and using that p.o. number to map the import for the rest but that did not work. I also tried using the internal ID for the p.o. I created to map it. I’m not sure if I’m leaving out required fields or what. If anyone has had success with csv importing a purchase order, please let me know what the magic trick is. Thank you.
This is a cached copy. Click here to see the original post.

[rnedelkow]

What error are you getting in the csv response?

[stagelightingstore]

Invalid Item Reference Key and then it lists an item’s part number, but it only says it about one item on the list. & it says 0 of 1 records imported when there’s at least 20 items on the list I’m trying to import..

[Thomas]

The record that it’s importing is the purchase order. So, if you were importing 5 POs with 250 total items, the resulting message on the Job Status screen is 5 of 5 records imported.

The only fields that you need when creating purchase orders are Date, Vendor, External ID(you can use a random number here), Item(use the internal id or item name/number), Quantity.

Hope this helps.

Thanks,

Thomas

[stagelightingstore]

Oh ok so I’m missing the external ID. I’ll try it with a random number and reply with my results. Thank you!

[stagelightingstore]

Set external id to a random number (4) and the error message is now saying “Could not find record with externalid = 4” <— does the random number external id work for you ? Should I be using the purchase order number as external id instead ? Everything else I did matches what you said so this should be the only issue

[Author]

Posts