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”,
}),
],
});

 


                
Rookie Asked on December 29, 2022 in SuiteCloud.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor