search - Netsuite getting the display text for a formula -

-

i in need of getting text (display) value of field compare date ranges on posting period. have formula below pushing in filter array other filters need run

var columns = []; columns.push(new nlobjsearchcolumn('transactionnumber'));    columns.push(new nlobjsearchcolumn('line')); columns.push(new nlobjsearchcolumn('item')); columns.push(new nlobjsearchcolumn('account')); columns.push(new nlobjsearchcolumn('amount')); columns.push(new nlobjsearchcolumn('vsoeallocation')); columns.push(new nlobjsearchcolumn('postingperiod'));        columns.push(new nlobjsearchcolumn('srctranpostperiod','revrecschedule')); columns.push(new nlobjsearchcolumn('recuramount','revrecschedule')); columns.push(new nlobjsearchcolumn('jedoc', 'revrecschedule'));  columns[0].setsort(); columns[1].setsort();     var filter = [];          var formula = "case when to_date({postingperiod.displayname}, 'mon yyyy') >= " + newselecteddate.getfullyear() + " 1 else 0 end";  filter.push(new nlobjsearchfilter('revrecenddate', null, 'after', newselecteddate)); filter.push(new nlobjsearchfilter('type', null, 'anyof', ['custinvc', 'cashsale']));     filter.push(new nlobjsearchfilter('templatename','revrecschedule','isnotempty')); filter.push(new nlobjsearchfilter('deferredamount','revrecschedule','isnot', 0)); filter.push(new nlobjsearchfilter('formulanumeric', null, 'equalto', 1).setformula(formula));     var search = nlapicreatesearch('transaction', filter, columns);  var searchresult = search.runsearch();

which in theory work except gets value of field instead of text (it turns out non date value). know there ways once have ran search text instead of value (nlobjsearchresult.gettext) have not found way within formula.

any ideas?

it seems posting period might contain additional information apparently used in functions to_date(). may because of internal hierarchy of accounting periods. or might because periods list/record fields in single select box, there id every posting period. around this, i've done following (applied code):

var formula = "case when to_date(substr({postingperiod},-8,8), 'mon yyyy') >= " + newselecteddate.getfullyear() + " 1 else 0 end";

which adding substr function pick last 8 characters in string pass onto date function.


Comments

Post a Comment

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

-
this question has answer here: what's mongoose error cast objectid failed value xxx @ path “_id”? 7 answers even though has been asked many times because entity has no valid objectid field. i came across situation objectid set value can casted objectid still error. the schema: var serviceschema = parammongoose.schema({ servicename:{ type: parammongoose.schema.types.objectid , ref: 'servicenames',required:true } }); pseudo code: servicefromdb=new service({servicename:'some name'}); servicefromdb.servicename='000000000000000000000001'; servicefromdb.save(function(paramerror,paramdata){ if(paramerror){ console.log('but but...',servicefromdb,paramerror) } }); the output of code is: but but... { servicename: 000000000000000000000001, _id: 55079a90286f49280364f78b } { [casterror: cast objectid faile...
Read more

gradle error "Cannot convert the provided notation to a File or URI" -

-
i have defined 2 system properties in gradle.properties: systemprop.builddir=build systemprop.cfgdir=build\\cfg and have following task defined in build.gradle: task clean(group:'clean',description:'clean project') << { ant.sequential { delete(dir: system.properties.builddir) mkdir(dir: system.properties.builddir) delete(dir: system.properties.cfgdir) mkdir(dir: system.properties.cfgdir) } } this generates following error: execution failed task ':clean'. > cannot convert provided notation file or uri: {dir=build}. following types/formats supported: - string or charsequence path, e.g 'src/main/java' or '/usr/include' - string or charsequence uri, e.g 'file:/usr/include' - file instance. - uri or url instance. but equivalent block of code not generate error , works expected: task clean(group:'clean',description:'clean project') << { ...
Read more

python - NameError: name 'subprocess' is not defined -

-
i'm trying make rng website: http://jamesdotcom.com/?p=417 . when run following code: captureimage = subprocess.popen( [ "fswebcam", "-r", "356x292", "-d", "/dev/video0", "static.jpg", "--skip", "10" ], stdout=devnull, stderr=devnull) captureimage.communicate() i following error message: nameerror: name 'subprocess' not defined what should do? thanks have imported first? import subprocess captureimage = subprocess.popen(["fswebcam", ...) subprocess included in python standard library since python 2.4. should not necessary install it.
Read more