Hi All, While importing subscriptions by SuiteScri...
# suitescriptm
Menno Janssen
08/31/2021, 12:29 PMHi All, While importing subscriptions by SuiteScript i am tring to set the discount of some lines to '100%' this is possible in the UI and is stored as such:
but when importing using suitescript i get the following error: "U hebt een ongeldige veldwaarde 100.00% voor het volgende veld ingevoerd: discount" which translates to "you entered a invalid value '100.00%' for the field 'discount'"
Menno Janssen
08/31/2021, 12:29 PMAls with "100%" it is not working btw
d
Dmitry Masanov
08/31/2021, 12:30 PMTry to put number 1.0 into that field
m
Menno Janssen
08/31/2021, 12:36 PMWell the script continues but the discount is imported as 1.00
Menno Janssen
08/31/2021, 12:36 PMso 1 dollar instead of 100% 😉
d
Dmitry Masanov
08/31/2021, 12:37 PMYou sure that the field type is percent?
Dmitry Masanov
08/31/2021, 12:38 PMIf it is just number, then put 100
m
Menno Janssen
08/31/2021, 12:40 PMwel de discount field in the UI accepts numbers
Menno Janssen
08/31/2021, 12:40 PMwhich will be translated into net discount
Menno Janssen
08/31/2021, 12:40 PMbut it also accepts a number suffixed by '%' which makes it a calculated discount on the sum of the item
Menno Janssen
08/31/2021, 12:41 PMi'm not sure if i need to do something in suitescript to have netsuite interperet it as a percentage
d
Dmitry Masanov
08/31/2021, 12:42 PMDid you try setText?
Copy code
discountItem.setText({fieldId:'rate',text:'8.5%'});m
Menno Janssen
08/31/2021, 12:42 PMi will try
Menno Janssen
08/31/2021, 12:53 PM@Dmitry Masanov lifesaver! 😅
Menno Janssen
08/31/2021, 12:53 PMset text works and it stores the value as a percentage
👍 2