Do anyone know why I am getting this error "Please...
# csvimportsn
nsAI
08/30/2023, 8:32 PMDo anyone know why I am getting this error "Please choose an item to add" when importing to update existing Invoice lines?
I am only updating a custom field on the line item and i do not want to change or update any item, quantity rate or amount data. From the documentation I should be able to use the order line as the primary key to know which lines to update which I did, but still recieved the error.
r
RJMNS
08/31/2023, 6:14 PMOn that second screen are you choosing Update or Add Or Update?
Also on that same screen did you check the Overwrite Sublists option?
Also, you're using the internal ID or the overall order in conjunction with Line IDs right?
n
nsAI
08/31/2023, 6:16 PMI am choosing Update only>
I am NOT checking overwrite sublists
nsAI
08/31/2023, 6:17 PMI am using internal ID of transaction and Line Ids to reference each line
r
RJMNS
08/31/2023, 6:20 PMIs the line you're trying to update part of an item group?
RJMNS
08/31/2023, 6:20 PMOr is the item on the line you're trying to update inactive maybe?
RJMNS
08/31/2023, 6:21 PMCould also try (in a test environment probably) running the CSV import with the opposite of whatever value you have for the Run Server Suitescript and trigger workflows option.
n
nsAI
08/31/2023, 6:22 PMYes the item is set to inactive
r
RJMNS
08/31/2023, 6:22 PMIf that's the issue, you probably should do some more research to figure out what's going on. You generally shouldn't mess with that setting otherwise you might get some unexpected results
RJMNS
08/31/2023, 6:23 PMoh if it's inactive, you'd probably need to reactivate it temporarily to make your update. NetSuite won't mess with items already on orders when you inactivate it, but it won't let you save an order or make an update to one that contains an inactive item.
RJMNS
08/31/2023, 6:24 PMBasically when you go into edit mode, that item is disappearing from the line it's on because inactive items don't show up in that drop-down. So when the system is going to attempt to save that line again, it's attempting to save without an item populated, which is why you're getting that error.
n
nsAI
08/31/2023, 6:24 PMhmmm ok bummer
nsAI
08/31/2023, 6:24 PMlet me test that
nsAI
08/31/2023, 6:29 PMnope didn't work
nsAI
08/31/2023, 6:29 PMstill get the same error
nsAI
09/14/2023, 9:03 PMI think I figured it out. If you map the Line ID and Item fields (but in your csv the item field is blank) then it worked
nsAI
09/14/2023, 9:03 PMweird
nsAI
09/14/2023, 9:03 PMactually i remember someone mentioning to try this but I can't find their message anymore so don't know who to thank
77 Views