Rounding Error on setValue (taxamountoverride)

Hey! I’m trying to set the value of taxamountoverride (invoice) and I get a ’rounding error’ for any value that is not zero.

Any idea how to overcome this issue?
Code:

It’s a user event script, aftersubmit.

rec.setValue({
  fieldId: 'taxamountoverride', //      Error on values that are not 0 / 0.00 etc.
  value: salesTaxAmountFixedFormat
})
Error:

{

  "type": "error.SuiteScriptError",

  "name": "ROUNDING_ERROR",

  "message": "Rounding Error: 1",

  "stack":

    [

      "Error\n at RecordInvoker.save (suitescript/resources/javascript/record/serverRecordService.js:371:13)\n at NetSuiteObject.thenableFunction() (suitescript/resources/javascript/record/proxy.js:115:24)\n at insertTax (/SuiteScripts/tax_tst.js:245:13)\n at Object.afterSubmit (/SuiteScripts/tax_tst.js:21:9)",

    ],

  "cause":

    {

      "type": "internal error",

      "code": "ROUNDING_ERROR",

      "details": "Rounding Error: 1",

      "userEvent": null,

      "stackTrace":

        [

          "Error\n at RecordInvoker.save (suitescript/resources/javascript/record/serverRecordService.js:371:13)\n at NetSuiteObject.thenableFunction() (suitescript/resources/javascript/record/proxy.js:115:24)\n at insertTax (/SuiteScripts/tax_tst.js:245:13)\n at Object.afterSubmit (/SuiteScripts/tax_tst.js:21:9)",

        ],

      "notifyOff": false,

    },

  "id": "",

  "notifyOff": false,

  "userFacing": true,
}


Things I tried:
  • Change the format of the salesTaxAmount to a currency format (with ‘N/format/i18n’ module)

  • Passing 1 / 1.0 / 1.00 as the value

  • Using parseFloat(number).toPrecision() (passed 1 / 2 / 3)

Thanks in advance < 3

Rookie Asked on May 30, 2022 in SuiteScript.

you tried using only :

var value = 2
parseFloat(value )

on June 3, 2022.
Add Comment
1 Answer(s)

Hi,

Can you please message us or drop your email id? We are expert NetSuite Consultants in the USA. We will help you regarding all your NetSuite queries, and provide free expert consultation.
You may drop a message here: Contact NetSuite Consultants

Rookie Answered on May 31, 2022.
Add Comment

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   Limebox   Become a Sponsor   Become a Sponsor