Is the "Status" of a Sales Order or a 'Line Item' ...
# administration
c
Is the "Status" of a Sales Order or a 'Line Item' set-able via
mass update
?
k
Define "status"
Either way - the closest you'll probably get to that is via a CSV import - and odds are you aren't going to get what you are asking for.
c
Status, as in the state that NetSuite puts at the top "Billed", "Awaiting Approval", etc.
Ah, dang. The end goal it mark a swath of SO's as
Closed
, at least temporarily because the product is simply not available right now.
k
See, that's easy via CSV import
There's a closed checkbox on the lines - mark that true via CSV and the order will close
c
Oh? I didn't realize you could set the line item like that!
k
Have a saved search that grabs all the sales orders, with it's internal IDs and Line IDs
and then CSV import that into NS - with 3 fields mapped. Internal ID, Line ID, and the "Closed" checkbox marked true (hard code that in your import)
🤔 1
(do this on a small sample set first to make sure it works)
1000 1
c
I am amused that this might actually be that simple. Because there are so very few of these things that seem that simple in NetSuite. 🙃
s
in general, statuses on transactions are just a representation of something to do with the lines. The closed status on the sales order simply means lines are closed
c
Thanks for your help everyone.