Hi all - a couple of workflow questions: 1. On a t...
# suiteflow
b
Hi all - a couple of workflow questions: 1. On a transaction workflow, is there a "trick" to getting the line level fields to show an a Set Field Value action? The only way I've been able to get them to show in the "Field" dropdown list is to copy an existing Action that is using line level fields. Then all the line level fields show. Works on updating an existing workflow but at some point we'll need a new one. I can't figure out what I'm missing. 2. This is more a formula question regarding "Percent" fields. Is there a way to get Netsuite to display percentage fields correctly? A percent field that Netsuite shows as .195% is "really" 19.5% - and if it was .195% would be .00195. Thanks!
m
You can only use the Set Field Value of lines if you add a Sublist Action Group. Then inside the Sublist Action group you can add a new Action of Set Field Value
(This only works for Items sublist)
For the percentage problem, I'm not sure what you mean by "display correctly". If you type "19 into a percentage field it will automatically convert it to 19%. Then in saved searches and formulas it will act as 0.19
Is that what you mean?
b
Thank you! I wasn't inside the Sublist Action Group when adding the Action. Very helpful! For the percent fields - here's a screenshot from a transaction where they're populated by the workflow.
m
Add “ *100” to your formula
b
d'uh - thank you!