Suitescript search result is wrong compare to saved search
Saved search shows taxtotal and total correctly for transaction.
“taxtotal” shows empty on suitescript, and total shows total – taxtotal instead.
I can’t figure out why that is the case.
const salesorderSearchObj = search.create({
type: search.Type.SALES_ORDER,
filters: [
[“type”, “anyof”, “SalesOrd”],
“AND”,
[“internalid”, “anyof”, netsuiteId],
],
columns: [
search.createColumn({name: “tranid”, label: “Document Number”}),
search.createColumn({
name: “taxtotal”,
label: “Amount (Transaction Tax Total)”,
}),
search.createColumn({
name: “total”,
label: “Amount (Transaction Total)”,
}),
search.createColumn({
name: “shippingamount”,
label: “Amount (Shipping)”,
}),
search.createColumn({
name: “formulatext”,
formula: “NVL({discountamount}, 0)”,
label: “Amount Discount”,
}),
],
});
