hey guys, I am trying to set a rate as a % while a...
# suitescriptm
Matias Bonifacino
12/15/2021, 2:52 PMhey guys, I am trying to set a rate as a % while adding a sublist item for a markup item on a Sales Order, but I am getting this error when doing so:
Copy code
Notice
You have entered an Invalid Field Value 7.00% for the following field: ratea
Alan Fitch
12/15/2021, 2:52 PMTry 0.07
m
Matias Bonifacino
12/15/2021, 2:54 PMI tried it but it doesn't show up as a percentage 😕
Matias Bonifacino
12/15/2021, 2:54 PMmessage has been deleted
Matias Bonifacino
12/15/2021, 2:55 PMI also tried to do 0.07% and same error as the first
Matias Bonifacino
12/15/2021, 2:55 PMYou have entered an Invalid Field Value 0.07% for the following field: rate
d
Dmitry Masanov
12/15/2021, 2:57 PMI thought rate was a currency field. Why are you trying to put percent here?
m
Matias Bonifacino
12/15/2021, 2:58 PMbecause you can on the UI
a
Alan Fitch
12/15/2021, 2:58 PMHave you tried loading the record in dynamic mode?
m
Matias Bonifacino
12/15/2021, 2:58 PM@Alan Fitch I am doing this on a user event (before submit)
a
Alan Fitch
12/15/2021, 2:59 PMSet it to 7.00% in the ui and get the value in the script. What does it return?
m
Matias Bonifacino
12/15/2021, 3:00 PMrate:"7.00%"
Matias Bonifacino
12/15/2021, 3:00 PMi can just calculate it, but i thought it'd be nice to use the %
Matias Bonifacino
12/15/2021, 3:01 PMsince I am using a subtotal item as well
s
Shawn Talbert
12/15/2021, 4:13 PMtry setting it with the integer 7
Shawn Talbert
12/15/2021, 4:14 PMactually, IIRC setText with the % sign should work.
Shawn Talbert
12/15/2021, 4:15 PMThe rate field is funky in this regard. Other true percent fields are also funky (asymmetrical). You set them with numbers but when retrieved they are strings with % suffix
m
Matias Bonifacino
12/15/2021, 4:19 PM@Shawn Talbert I was just trying that, but no luck
Matias Bonifacino
12/15/2021, 4:19 PMIt shows "Please enter a value for amount"
Matias Bonifacino
12/15/2021, 4:20 PMI also tried the field "porate" but it doesn't calculate
b
battk
12/15/2021, 9:54 PMbattk
12/15/2021, 9:54 PMdont make the common mistake of assuming setSublistValue and setSublistText use the same parameters
2 Views