Hello Gurus,
I have very strange problem in our multibook development account. I have created Saved Transaction Search with four Formula (Currency) fields:
On the results page on the UI I see the Formula (Currency) field values correctly - with two decimal places:
But when I get the results in the SuiteScript I see the Formula (Currency) field values with three decimal places:
Here is the Saved Search Code:
var transactionSearch = nlapiSearchRecord("transaction",null,[ [[["type","anyof","CashSale","CustInvc","CustCred","Custom100"],"AND",["custbody_type_of_document","noneof","8","9","10"],"AND",["accounttype","anyof","AcctRec"],"AND",["mainline","is","T"]],"OR",[["type","anyof","VendBill","VendCred"],"AND",["custbody_type_of_document","noneof","8","9","10"],"AND",["custbody_tax_item","noneof","1008"],"AND",["mainline","is","T"]],"OR",[["type","anyof","Journal"],"AND",["custbody_type_of_document","noneof","8","9","10"],"AND",["account","anyof","186","191","185","187"],"AND",["custbody_bg_protocol","is","T"]],"OR",[["type","anyof","VendBill","VendCred","CashSale","CustCred","CustInvc"],"AND",["custbody_type_of_document","noneof","8","9","10"],"AND",["accounttype","anyof","AcctRec"],"AND",["mainline","is","T"],"AND",["memomain","is","VOID"]],"OR",[["type","anyof","Journal"],"AND",["custbody_type_of_document","noneof","8","9","10"],"AND",["memomain","is","VOID"]]], "AND", ["memorized","is","F"], "AND", ["custbody_tax_item","noneof","1008"]], [ new nlobjSearchColumn("taxidnum","subsidiary","GROUP"), new nlobjSearchColumn("legalname","subsidiary","GROUP"), new nlobjSearchColumn("formulacurrency",null,"SUM").setFormula("{custbody_col_9_sr}"), new nlobjSearchColumn("formulacurrency",null,"SUM").setFormula("{custbody_col10_sr}"), new nlobjSearchColumn("formulacurrency",null,"SUM").setFormula("{custbody_col_11_sr}"), new nlobjSearchColumn("formulacurrency",null,"SUM").setFormula("{custbody_col_12_sr}")]);
What can be the problem?
Thanks
