Hello, I'm trying to import an invoice with multip...
# csvimports
b
Hello, I'm trying to import an invoice with multiple line items. I'm getting a super helpful
An error occurred while processing item options
error. I'm guessing it has to do with the multiple lines, but I can't find a line ID or line # field on Invoices like there is with SOs. I tried using a line ID we use with outside vendors, but those didn't work either. I never use Netsuite templates anymore, but I dug the invoice template out of the file cabinet, and it references multiple line invoices, but the field it references
itemLine_itemRef
doesn't show up in the import mapping. I've looked at the form to see if we'd removed it, but I don't see it. Any ideas? Thanks!
r
I don't believe you can assign Line IDs on new transactions. Based on that error, I'd guess you have some setup issue with Item Options on the item record. I don't have access to an account to screengrab where those are, but I'd guess maybe under the Sales/Pricing subtab? The setup issue is probably causing incorrect data to try and pull into the imported line item, which is causing that error.
b
Thank you! I'll look into this.