AFL
05/01/2020, 2:22 PMvar revenueplanSearch = nlapiSearchRecord("revenueplan",null,
[
["postingperiod","anyof","115"],
"AND",
["journal","noneof","@NONE@"],
"AND",
["lineamount","notequalto","0.00"],
"AND",
["appliedtotransaction.custcol_is_allocable_line","is","T"],
"AND",
["internalid","anyof","824909"]
],
[
new nlobjSearchColumn("recordnumber"),
new nlobjSearchColumn("createdfrom"),
new nlobjSearchColumn("tranid","appliedToTransaction",null).setSort(false),
new nlobjSearchColumn("postingperiod"),
new nlobjSearchColumn("journal").setSort(false),
new nlobjSearchColumn("subsidiarynohierarchy","journal",null),
new nlobjSearchColumn("internalid","customer",null),
new nlobjSearchColumn("entityid","customer",null),
new nlobjSearchColumn("item").setSort(false),
new nlobjSearchColumn("custcol_nxt_bundle_version","appliedToTransaction",null),
new nlobjSearchColumn("lineamount"),
new nlobjSearchColumn("class","journal",null),
new nlobjSearchColumn("deferralaccount"),
new nlobjSearchColumn("recognitionaccount"),
new nlobjSearchColumn("deferralaccount","revenueElement",null),
new nlobjSearchColumn("recognitionaccount","revenueElement",null)
]
);