Hi, Is there any way we can Void all the sales or...
# general
k
Hi, Is there any way we can Void all the sales orders all at once? (CSV import/Mass update/Anything?)
k
Have you tried doing a CSV download of all orders (so you get all Sales order internal IDs), and then add a column “Closed” with value = Yes for all rows (Sales orders), and then upload back in? This should mark all SOs closed. A SO by itself has no GL impact if it’s not fulfilled. You can also add a comment in the memo fields that the SO was coded because “Reason X”. So you won’t see any financial impact by closing (ie voiding). You might be able to delete them as well - although it is not a good idea to delete transactions.
k
Hi Kman, Thanks for your response. Yes, I tried doing the CSV upload but, I didn't find any option in NetSuite mapping on the right side to drag and map it. I see there is a field called "Status" but that's for the line items and it didn't work either.
s
@KC - I’ve done this before - you need to get the line ID of all items on the SO and use the status column for each line, as @Kman said, and mark it closed for all lines, once all lines are marked closed, the SO level will be marked closed