Is it possible to script the Depreciation History ...
# suitescriptl
Luis
11/30/2020, 10:41 PMIs it possible to script the Depreciation History records? I can't see it on the Records Browser. Is is not shown because it's part of FAM or it's really not scriptable?
s
Sandii
11/30/2020, 10:46 PMI am not familiar with this module at all, what is the internalid of the depreciation history record?
l
Luis
11/30/2020, 10:50 PM691
Luis
11/30/2020, 10:50 PMIt's Fixed Asset Management.
s
Sandii
11/30/2020, 10:51 PMWell, lets back up, what do you mean by script the depreciation record. Create them via script, add a client script to them, etc?
l
Luis
11/30/2020, 10:52 PMCreate a scheduled script to delete those records based on a saved search.
s
Sandii
11/30/2020, 10:54 PMWhy would want to delete the histories that are automatically created with the bundle? My guess is it's just a custom record, what is the record type if you navigate to one of the records.
l
Luis
11/30/2020, 10:57 PMYes, it is indeed a custom record from FAM.
We want to delete them because the users accidentally imported mid-life assets' depreciation history with wrong info. 33k+
s
Sandii
11/30/2020, 10:57 PMThen you don't need the records browser, custom records would not be in there.
l
Luis
11/30/2020, 11:00 PMWhere would I find it? Thanks.
s
Sandii
11/30/2020, 11:01 PMYou just said it's a custom record, use the id of the custom record, like
customrecord_whateverishererecord.Type.somethingl
Luis
11/30/2020, 11:10 PMHi, I'm sorry but I can't see where the id of the custom record is.
s
Sandii
11/30/2020, 11:11 PMCheck the definition of the bundle, or look in the custom record list. It should show you the id.
l
Luis
11/30/2020, 11:38 PMThank you so much! It worked. How to rerun the scheduled script automatically after reaching the governance limit?
s
Sandii
11/30/2020, 11:42 PMUse a map/reduce instead to delete a bunch of records, no need to requeue.
l
Luis
11/30/2020, 11:44 PMAlright. I will search about that. By the way, will try and catch solve my issue on requeue? Thanks.
Luis
11/30/2020, 11:46 PMvar count=0;
var counter=0;
var result=[];
var testSearch = search.create({
type: 'customrecord1',
filters: [ 'custrecord_date_created', 'notonorafter', 'startOfLastMonth' ],
columns: [ 'internalid' ]
});
do{
var resultSearch = testSearch.run().getRange({
start : count,
end : count+1000
});
for(var arr=0;arr<resultSearch.length;arr++){
result.push(resultSearch[arr]);
}
counter = count+counter;
}while(resultSearch.length >= 1000 && counter != 4000);
return result;
Luis
11/30/2020, 11:46 PMI found this example. Does it have a 4000 limit or I can adjust it?
2 Views