Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Losing Decimal Precision
I’m losing the decimal digits out of a variable for Duration (Hours) when creating a Timebill record. Here is the code snippett:
for ( var i = 0; searchstudents != null && i < searchstudents.length; i++ )
{
var searchstudent = searchstudents[ i ];
if (editts != "T") // Must be Create
{
var hours = searchimport.getValue('custrecord7'); //Get hours
// alert('Custom Hours' + " " + hours);
var classdate = searchimport.getValue('custrecord6'); //Get Date
var instrid = searchinstr.getId( ); //Get instr id
var classid = searchclass.getId( ); //Get class id
recordCreated = nlapiCreateRecord('timebill');
recordCreated.setFieldValue('employee', instrid);
recordCreated.setFieldValue('hours', hours);
The alert will show the variable "hours" has 3.3 hours however when Timebill is created, Duration show 3.0. Custrecord7 is a Decimal field in the custom record. Any ideas?