Discussions
Update Term field using Start and End Date
Hello,
I've been trying to create a client script to that would allow me to update a custom field called "Term" by calculating the fractional months between Start and End Date on Sales Order. Since I'm new to SuiteScript and coding, I tried out the Page Init Sample, and was able to run it fine. I was having trouble with the Field Changed and Validate Field samples that have been provided in the help section when I tweaked them for my use case.
The code below, basically, calculates the difference between the Start and End Date, and sets the value of the custom field "Term".