I have this custom script, which returns a sublist...
# suitescriptc
c c
07/21/2021, 11:33 AMI have this custom script, which returns a sublist of materials/items for a user chosen assembly.
But i found a problem, when i sort on the material cost, it does not sort the values correctly. etc (the most expensive items should show at the top) But they dont?? Which you can see on the screenshot, so im wondering if this is a netsuite thing or a thing that has to do with my script
j
jarens
07/21/2021, 11:37 AMLooks like you are sorting it as if it is text, instead of a number.
jarens
07/21/2021, 11:38 AMIf the field is text, you can do formula number and have TO_NUMBER({yourfield})
c
c c
07/21/2021, 11:39 AMmessage has been deleted
c c
07/21/2021, 11:39 AMmessage has been deleted
c c
07/21/2021, 11:39 AMI think you are right!
c c
07/21/2021, 11:51 AMIm getting an error when changing the fieldType
c c
07/21/2021, 11:55 AMFixed the error, tried to change the field type to currency, but it makes no difference
c c
07/21/2021, 12:59 PMworks now
🎉 1