The " RUN SERVER SUITESCRIPT AND TRIGGER WORKFLOWS...
# generalb
Becca A
08/21/2019, 6:53 PMThe " RUN SERVER SUITESCRIPT AND TRIGGER WORKFLOWS" checkbox? That's already unchecked by default!
s
Sirus Badiee
08/21/2019, 6:55 PMCan you take a look at your file and make sure your file doesn't have any empty rows at the bottom? A good way to quickly check for sure is to right click the CSV and click Open With Notepad. Scroll to the bottom and see if there are a bunch of commas
Sirus Badiee
08/21/2019, 6:55 PMAnd when you say they work on every other Vendor Bill - is it only one specific Vendor Bill that you're getting this issue with or is it this particular import?
b
Becca A
08/21/2019, 6:57 PMI opened with notepad and nothing out of the ordinary. As for the other vendor bills - I tried uploading about 20 vendor bills at once. 16 of them worked and 4 separate ones came back with this same error message.
s
Sirus Badiee
08/21/2019, 7:00 PMAnd there's no notable difference between those 16 working ones and the other 4 cranky ones?
Sirus Badiee
08/21/2019, 7:01 PMAlso, just to make sure, you are using the actual Line ID generated by an NS Saved Search, right?
b
Becca A
08/21/2019, 9:37 PMYep. I confirmed that they were the correct line ids. The only thing I can think of that seems odd to me is that when I search this document number, 3 different vendor bills come up with the same document number. They all have different internal ids and different dates. And I'm not using the document number in the upload. That's the only noticeable difference to me so far.
s
Sirus Badiee
08/21/2019, 9:41 PMOhhhh okay, I think I might know what's going on here. Can you try to go to one of those Vendor Bills, click Edit, and Save? I imagine you'll get a very similar error. The issue isn't so much the upload with the Internal ID - the error message that says something about the "ID" is probably in reference to the Document Number.
Sirus Badiee
08/21/2019, 9:42 PMIs it at all possible to update the Document Number?
b
Becca A
08/21/2019, 10:06 PMStrange enough, it let me edit and save. I think I'm going to give up on this mystery for now and just make the users manually update these 4 transactions. I really appreciate all of your help!
s
Sirus Badiee
08/21/2019, 10:15 PMDang, swing and a miss. No problem!
3 Views