If I wanted to clear out my junk from the last few...
# generala
Adam Weaver
03/12/2025, 9:46 PMIf I wanted to clear out my junk from the last few years, specifically sales orders and work orders what is the cleanest most efficient way to go?
c
creece
03/12/2025, 9:51 PMBy clear out do you mean delete?
✅ 1
creece
03/12/2025, 10:00 PMIf you want to delete them, then I would create saved searches that identifies the records to be deleted. Type/Internal ID must be specified in the results columns. Then create a map/reduce script with 2 parameters. One for doing a "test run" where it can log the count/information on records to be deleted but doesn't actually delete for verification purposes and another that is a list/record of type saved search that specifies the search to run. Have the map/reduce get the saved search results in getInputData(...) (type and internal ID) and for each reduce(...) delete the record given the type/ID.
creece
03/12/2025, 10:02 PMWith the saved search and the "test run" script param, you at least have 2 places to review data prior to deleting since its "a risk".
r
RJMNS
03/12/2025, 11:33 PMFYI if you're not a Dev and don't know how to do what they're saying, Techfino has a free bundle that does what they're suggesting, minus the test run.
🙌 2
a
Adam Weaver
03/12/2025, 11:43 PMI just have sloppy 3/4 finished WO and Sales orders I just want to clear out.. lots of "committed" items which is why I'm a little hesitant also...I think we have old inventory that isn't here that is probably "committed"/shipped to unfished Sales Orders. I want to be as acerate as possible so when we have to writing off inventory it's because its lost/missing
Adam Weaver
03/16/2025, 4:11 PM@RJMNS is it this?
🙅 1
Adam Weaver
03/16/2025, 4:35 PMfound it thanks
👍 1
2 Views