I've been struggling to figure out how to bulk upd...
# generalr
Red
04/15/2019, 8:57 PMI've been struggling to figure out how to bulk update sales orders that need to have an item number updated to a new item number. Over the weekend a few graciously helped, but I am still struggling. I was told each sales order has a unique Line ID and a non-unique Sequence ID. However when I build a saved search to get this data, the only option I have found for my results is "Line ID" which returns the sequential number. What field do I use to pull the unique line ID?
s
sam1128
04/15/2019, 9:00 PMLine ID is sequential number but if you remove one item and add another line ID sequence number for deleted line wouldn’t be there.
v
Vtor
04/15/2019, 9:00 PMI have an option in my search dropdowns for "Line Unique Key" - maybe that's what you're looking for
s
sam1128
04/15/2019, 9:01 PMIf you’ve all the details you might use sublist override for update. Easier that way.
r
Red
04/15/2019, 9:02 PMI think that's it Vtor, thanks!
Red
04/15/2019, 9:03 PMSam, if I am essentially trying to swap part number A for part number B on multiple sales orders and have the rest of the original field data remain the same (qty, price, etc). Is sublist override the best method?
s
sam1128
04/15/2019, 9:06 PMSublist Override is good option if you’ve all the line info and none of the lines have been fulfilled.
r
Red
04/15/2019, 9:23 PMI'm trying out the "Line Unique Key" field which I can find and use on a saved search, but under a Transcations>Sales Order CSV import it is not an available field option. How do I use that field for an import map?
Red
04/15/2019, 9:28 PMSeems like because that field is hidden on our custom form and so it won't show up as an import field
3 Views